SAP Table PA0697
Infotype 0697 ( Drug Screening)
Recommended Now
All-new Echo Dot Smart speaker with Alexa
This bundle includes Echo Dot (3rd Gen) Charcoal and Philips Hue White A19 Medium Lumen Smart Bulb, 1100 Lumens. Built in Smart Home hub. Ask Alexa to control Zigbee-compatible devices. No additional Philips Hue hub required. Two choices for easy smart lighting - Start setting the mood with Hue Smart bulbs and your Echo device, supporting up to 5 Hue Bluetooth & Zigbee smart bulbs. Add the Hue Hub for whole-home smart lighting (up to 50 light points) and bonus features.
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 | * |