SAP Table PA0697
Infotype 0697 ( Drug Screening)
Recommended Now
Fire TV Stick Lite Essentials Bundle
This bundle contains Amazon Fire TV Stick Lite and Mission USB Power Cable. The USB power cable eliminates the need to find an AC outlet near your TV by powering Amazon Fire TV directly from your TV's USB port. Includes special power management circuitry that enhances the peak power capability of the USB port by storing excess energy and then releasing it as needed.
Check it out on amazon.com →
The table PA0697 (Infotype 0697 ( Drug Screening)) is a standard table in SAP ERP. It belongs to the package P10P1.
Technical Information
| Table | PA0697 |
| Short Text | Infotype 0697 ( Drug Screening) |
| Package | P10P1 |
| Table Type | Transparent Table |
Fields for Table PA0697
| Field Name | Key | Description | Data Element | Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | ✔ | Client | MANDT | CLNT | 3 | * |
| PERNR | ✔ | Personnel number | PERSNO | NUMC | 8 | PA0003 |
| SUBTY | ✔ | Subtype | SUBTY | CHAR | 4 | |
| OBJPS | ✔ | Object Identification | OBJPS | CHAR | 2 | |
| SPRPS | ✔ | Lock Indicator for HR Master Data Record | SPRPS | CHAR | 1 | |
| ENDDA | ✔ | End Date | ENDDA | DATS | 8 | |
| BEGDA | ✔ | Start Date | BEGDA | DATS | 8 | |
| SEQNR | ✔ | Number of Infotype Record with Same Key | SEQNR | NUMC | 3 | |
| AEDTM | Changed On | AEDAT | DATS | 8 | ||
| UNAME | Name of Person Who Changed Object | AENAM | CHAR | 12 | ||
| HISTO | Historical Record Flag | HISTO | CHAR | 1 | ||
| ITXEX | Text Exists for Infotype | ITXEX | CHAR | 1 | ||
| REFEX | Reference Fields Exist (Primary/Secondary Costs) | PRFEX | CHAR | 1 | ||
| ORDEX | Confirmation Fields Exist | ORDEX | CHAR | 1 | ||
| ITBLD | Infotype Screen Control | ITBLD | CHAR | 2 | ||
| PREAS | Reason for Changing Master Data | PREAS | CHAR | 2 | T530E | |
| FLAG1 | Reserved Field/Unused Field | NUSED | CHAR | 1 | ||
| FLAG2 | Reserved Field/Unused Field | NUSED | CHAR | 1 | ||
| FLAG3 | Reserved Field/Unused Field | NUSED | CHAR | 1 | ||
| FLAG4 | Reserved Field/Unused Field | NUSED | CHAR | 1 | ||
| RESE1 | Reserved Field/Unused Field of Length 2 | NUSED2 | CHAR | 2 | ||
| RESE2 | Reserved Field/Unused Field of Length 2 | NUSED2 | CHAR | 2 | ||
| GRPVL | Grouping Value for Personnel Assignments | PCCE_GPVAL | CHAR | 4 | ||
| TESTY | Drug screening test type | P10_TESTY | CHAR | 4 | T591A | |
| TESDT | Sample collecting date | P10_TESDT | DATS | 8 | ||
| TESRN | Drug screening test reason | P10_TERSN | CHAR | 4 | T5UPBS20DSR | |
| TRESU | Overall test result | P10_TRESU | CHAR | 1 | T5UPBS20DSU | |
| SANUM | Sample number | P10_SANUM | CHAR | 8 | ||
| TEXEC | Test executer name | P10_TEXEC | CHAR | 80 | ||
| TOBSE | Test observer name | P10_TOBSE | CHAR | 80 | ||
| TSITE | Test site | P10_TSITE | CHAR | 4 | T5UPBS20DSS | |
| TMEDA | Test method for sample A | P10_TMEDA | CHAR | 4 | T5UPBS20DSM | |
| TMEDB | Test method for sample B | P10_TMEDB | CHAR | 4 | T5UPBS20DSM | |
| STA01 | Substance test content code | P10_SUBST | CHAR | 4 | T5UPBS20DS | |
| RSA01 | Substance test result | P10_TSRES | CHAR | 1 | T5UPBS20DSUT | |
| ATA01 | Substance test amout | P10_TSAMT | QUAN | 8 | ||
| UTA01 | Substance test unit | P10_TSUNT | UNIT | 3 | ||
| STA02 | Substance test content code | P10_SUBST | CHAR | 4 | T5UPBS20DS | |
| RSA02 | Substance test result | P10_TSRES | CHAR | 1 | T5UPBS20DSUT | |
| ATA02 | Substance test amout | P10_TSAMT | QUAN | 8 | ||
| UTA02 | Substance test unit | P10_TSUNT | UNIT | 3 | ||
| STA03 | Substance test content code | P10_SUBST | CHAR | 4 | T5UPBS20DS | |
| RSA03 | Substance test result | P10_TSRES | CHAR | 1 | T5UPBS20DSUT | |
| ATA03 | Substance test amout | P10_TSAMT | QUAN | 8 | ||
| UTA03 | Substance test unit | P10_TSUNT | UNIT | 3 | ||
| STA04 | Substance test content code | P10_SUBST | CHAR | 4 | T5UPBS20DS | |
| RSA04 | Substance test result | P10_TSRES | CHAR | 1 | T5UPBS20DSUT | |
| ATA04 | Substance test amout | P10_TSAMT | QUAN | 8 | ||
| UTA04 | Substance test unit | P10_TSUNT | UNIT | 3 | ||
| STA05 | Substance test content code | P10_SUBST | CHAR | 4 | T5UPBS20DS | |
| RSA05 | Substance test result | P10_TSRES | CHAR | 1 | T5UPBS20DSUT | |
| ATA05 | Substance test amout | P10_TSAMT | QUAN | 8 | ||
| UTA05 | Substance test unit | P10_TSUNT | UNIT | 3 | ||
| STA06 | Substance test content code | P10_SUBST | CHAR | 4 | T5UPBS20DS | |
| RSA06 | Substance test result | P10_TSRES | CHAR | 1 | T5UPBS20DSUT | |
| ATA06 | Substance test amout | P10_TSAMT | QUAN | 8 | ||
| UTA06 | Substance test unit | P10_TSUNT | UNIT | 3 | ||
| STA07 | Substance test content code | P10_SUBST | CHAR | 4 | T5UPBS20DS | |
| RSA07 | Substance test result | P10_TSRES | CHAR | 1 | T5UPBS20DSUT | |
| ATA07 | Substance test amout | P10_TSAMT | QUAN | 8 | ||
| UTA07 | Substance test unit | P10_TSUNT | UNIT | 3 | ||
| STA08 | Substance test content code | P10_SUBST | CHAR | 4 | T5UPBS20DS | |
| RSA08 | Substance test result | P10_TSRES | CHAR | 1 | T5UPBS20DSUT | |
| ATA08 | Substance test amout | P10_TSAMT | QUAN | 8 | ||
| UTA08 | Substance test unit | P10_TSUNT | UNIT | 3 | ||
| STA09 | Substance test content code | P10_SUBST | CHAR | 4 | T5UPBS20DS | |
| RSA09 | Substance test result | P10_TSRES | CHAR | 1 | T5UPBS20DSUT | |
| ATA09 | Substance test amout | P10_TSAMT | QUAN | 8 | ||
| UTA09 | Substance test unit | P10_TSUNT | UNIT | 3 | ||
| STA10 | Substance test content code | P10_SUBST | CHAR | 4 | T5UPBS20DS | |
| RSA10 | Substance test result | P10_TSRES | CHAR | 1 | T5UPBS20DSUT | |
| ATA10 | Substance test amout | P10_TSAMT | QUAN | 8 | ||
| UTA10 | Substance test unit | P10_TSUNT | UNIT | 3 | ||
| STB01 | Substance test content code | P10_SUBST | CHAR | 4 | T5UPBS20DS | |
| RSB01 | Substance test result | P10_TSRES | CHAR | 1 | T5UPBS20DSUT | |
| ATB01 | Substance test amout | P10_TSAMT | QUAN | 8 | ||
| UTB01 | Substance test unit | P10_TSUNT | UNIT | 3 | ||
| STB02 | Substance test content code | P10_SUBST | CHAR | 4 | T5UPBS20DS | |
| RSB02 | Substance test result | P10_TSRES | CHAR | 1 | T5UPBS20DSUT | |
| ATB02 | Substance test amout | P10_TSAMT | QUAN | 8 | ||
| UTB02 | Substance test unit | P10_TSUNT | UNIT | 3 | ||
| STB03 | Substance test content code | P10_SUBST | CHAR | 4 | T5UPBS20DS | |
| RSB03 | Substance test result | P10_TSRES | CHAR | 1 | T5UPBS20DSUT | |
| ATB03 | Substance test amout | P10_TSAMT | QUAN | 8 | ||
| UTB03 | Substance test unit | P10_TSUNT | UNIT | 3 | ||
| STB04 | Substance test content code | P10_SUBST | CHAR | 4 | T5UPBS20DS | |
| RSB04 | Substance test result | P10_TSRES | CHAR | 1 | T5UPBS20DSUT | |
| ATB04 | Substance test amout | P10_TSAMT | QUAN | 8 | ||
| UTB04 | Substance test unit | P10_TSUNT | UNIT | 3 | ||
| STB05 | Substance test content code | P10_SUBST | CHAR | 4 | T5UPBS20DS | |
| RSB05 | Substance test result | P10_TSRES | CHAR | 1 | T5UPBS20DSUT | |
| ATB05 | Substance test amout | P10_TSAMT | QUAN | 8 | ||
| UTB05 | Substance test unit | P10_TSUNT | UNIT | 3 | ||
| STB06 | Substance test content code | P10_SUBST | CHAR | 4 | T5UPBS20DS | |
| RSB06 | Substance test result | P10_TSRES | CHAR | 1 | T5UPBS20DSUT | |
| ATB06 | Substance test amout | P10_TSAMT | QUAN | 8 | ||
| UTB06 | Substance test unit | P10_TSUNT | UNIT | 3 | ||
| STB07 | Substance test content code | P10_SUBST | CHAR | 4 | T5UPBS20DS | |
| RSB07 | Substance test result | P10_TSRES | CHAR | 1 | T5UPBS20DSUT | |
| ATB07 | Substance test amout | P10_TSAMT | QUAN | 8 | ||
| UTB07 | Substance test unit | P10_TSUNT | UNIT | 3 | ||
| STB08 | Substance test content code | P10_SUBST | CHAR | 4 | T5UPBS20DS | |
| RSB08 | Substance test result | P10_TSRES | CHAR | 1 | T5UPBS20DSUT | |
| ATB08 | Substance test amout | P10_TSAMT | QUAN | 8 | ||
| UTB08 | Substance test unit | P10_TSUNT | UNIT | 3 | ||
| STB09 | Substance test content code | P10_SUBST | CHAR | 4 | T5UPBS20DS | |
| RSB09 | Substance test result | P10_TSRES | CHAR | 1 | T5UPBS20DSUT | |
| ATB09 | Substance test amout | P10_TSAMT | QUAN | 8 | ||
| UTB09 | Substance test unit | P10_TSUNT | UNIT | 3 | ||
| STB10 | Substance test content code | P10_SUBST | CHAR | 4 | T5UPBS20DS | |
| RSB10 | Substance test result | P10_TSRES | CHAR | 1 | T5UPBS20DSUT | |
| ATB10 | Substance test amout | P10_TSAMT | QUAN | 8 | ||
| UTB10 | Substance test unit | P10_TSUNT | UNIT | 3 | ||
| EADDR | Address number | P10_CADDR | CHAR | 10 | * | |
| OADDR | Address number | P10_CADDR | CHAR | 10 | * |