T7BREFD_EEDOCS - Employee identification documents
Employee identification documents information is stored in SAP table T7BREFD_EEDOCS.
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_EEDOCS
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 | ||
CTPS_NUMBER | Worker's Card for Social Welfare number - WCSW | PBR_CTNR | CHAR | 20 | ||
CTPS_SERIES | Worker's Card series number - WCSW | PBR_CTSR | CHAR | 12 | ||
CTPS_STATE | State (FU) | PBR_ESTAD | CHAR | 6 | ||
RIC_NUMBER | Civil identity registry number (RIC) | PBR_RICNR | CHAR | 30 | ||
RIC_ISSUE_DT | Issuing date of the civil identity registry | HRPADBR_RIC_DEMIS | DATS | 16 | ||
RIC_ISSUER | CHAR | 16 | ||||
RG_NUMBER | Identification Document number | PBR_IDNR | CHAR | 32 | ||
RG_ISSUE_DT | Issuing date of the ID card | HRPADBR_RG_DEMIS | DATS | 16 | ||
RG_ISSUER | CHAR | 16 | ||||
RNE_NUMBER | Foreign Identification Document number | PBR_IDFNR | CHAR | 40 | ||
RNE_ISSUE_DT | Issuing date of the national foreigner registry | HRPADBR_RNE_DEMIS | DATS | 16 | ||
RNE_ISSUER | CHAR | 16 | ||||
OC_NUMBER | Registration number in the class body | HRPADBR_OC_NUMBER | CHAR | 28 | ||
OC_ISSUER | CHAR | 16 | ||||
OC_ISSUE_DT | Issuing date of the registration in class entity | HRPADBR_OC_DEMIS | DATS | 16 | ||
OC_VALIDITY_DT | Validity date of the registration in class entity | HRPADBR_OC_VALIDITY_DT | DATS | 16 | ||
CNH_NUMBER | Professional Driver's License number | PBR_DRVNR | CHAR | 24 | ||
CNH_ISSUER | Reserved | CHAR | 16 | |||
CHN_ISSUE_DT | Driver's license issuing date | HRPADBR_CNH_DEMIS | DATS | 16 | ||
CNH_VALIDITY_DT | Driver's license validity date | HRPADBR_CNH_VALIDITY_DT | DATS | 16 | ||
RIC_ISSUER_ORG | Issuing authority of the civil identity registry | HRPADBR_RIC_ISSUER | CHAR | 40 | ||
RG_ISSUER_ORG | Issuing authority of the ID card | HRPADBR_RG_ISSUER | CHAR | 40 | ||
RNE_ISSUER_ORG | Issuing authority of the national foreigner registry | HRPADBR_RNE_ISSUER | CHAR | 40 | ||
OC_ISSUER_ORG | Issuing authority of the registration in class entity | HRPADBR_OC_ISSUER | CHAR | 40 | ||
CNH_ISSUER_ORG | Driver's license issuing authority | HRPADBR_CNH_ISSUER | CHAR | 40 | ||
CNH_UF | CNH issuing federation state | HRPADBR_EFD_CNH_UF | CHAR | 4 | ||
CNH_EXPEDITION | First qualification date (CNH) | HRPADBR_EFD_CNH_EXPEDITION | DATS | 16 | ||
CNH_CATEGORY | CNH category | HRPADBR_EFD_CNH_CATEGORY | CHAR | 4 |