T7BREFD_DRUGTEST - Information on drug testing for professional drivers
Information on drug testing for professional drivers information is stored in SAP table T7BREFD_DRUGTEST.
It is part of development package PB37 in software component PA-PA-BR. This development package consists of objects that can be grouped under "HR master data: Brazil".
It is part of development package PB37 in software component PA-PA-BR. This development package consists of objects that can be grouped under "HR master data: Brazil".
Fields for table T7BREFD_DRUGTEST
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| .INCLUDE | X | HRPADBR_EFD_S_APP_KEY_FIELDS | 0 | |||
| MANDT | Client | X | MANDT | CLNT | 6 | T000 |
| EVENT_ID | Event identifier | X | HRPADBR_EFD_EVENT_ID | NUMC | 40 | T7BREFD_EVENT |
| RECORD_ID | Record code | X | HRPADBR_EFD_RECORD_ID | NUMC | 18 | |
| .INCLUDE | HRPADBR_EFD_S_APP_OTHER_FIELDS | 0 | ||||
| PARENT_ID | Parent record code | HRPADBR_EFD_PARENT_ID | NUMC | 18 | ||
| EXAM_DATE | Date | DATUM | DATS | 16 | ||
| LAB_INSC_NUM | CNPJ/SRS number | HRPADBR_CNPJ_CEI | NUMC | 28 | ||
| DRUG_TEST_CODE | Drug testing code | HRPADBR_DRUG_TEST_CODE | CHAR | 22 | ||
| DOCTOR_NAME | Physician name | HRPADBR_DOCTOR_NAME | CHAR | 160 | ||
| CRM_NUMBER | Physician identification code - CRM | HRPADBR_DOCTOR_CRM | CHAR | 16 | ||
| CRM_STATE | Region (State, Province, County) | REGIO | CHAR | 6 | ||
| REFUSAL_IND | Drug testing refusal indicator in termination | HRPADBR_DRUG_TEST_REFUSAL_IND | CHAR | 2 |