HRPADBR_EFDE_S_INITIAL_REG SAP (Initial record) Structure details

Dictionary Type: Structure
Description: Initial record




ABAP Code to SELECT data from HRPADBR_EFDE_S_INITIAL_REG
Related tables to HRPADBR_EFDE_S_INITIAL_REG
Access table HRPADBR_EFDE_S_INITIAL_REG




Structure field list including key, data, relationships and ABAP select examples

HRPADBR_EFDE_S_INITIAL_REG is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Initial record" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_HRPADBR_EFDE_S_INITIAL_REG TYPE HRPADBR_EFDE_S_INITIAL_REG.

The HRPADBR_EFDE_S_INITIAL_REG table consists of various fields, each holding specific information or linking keys about Initial record data available in SAP. These include MANDT (Client), EVENT_ID (Event identifier), RECORD_ID (Record code), PARENT_ID (Parent record code).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can Be Enhanced (Deep)


SAP HRPADBR_EFDE_S_INITIAL_REG structure fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
EMPLOYER_INFO 0
MANDTClient MANDTCLNT3MANDT
EVENT_IDEvent identifier HRPADBR_EFD_EVENT_IDNUMC20HRPADBR_EFD_EVENT_ID
RECORD_IDRecord code HRPADBR_EFD_RECORD_IDNUMC9NUMC09
PARENT_IDParent record code HRPADBR_EFD_PARENT_IDNUMC9NUMC09
INSC_TYPERegistration type HRPADBR_INSC_TYPECHAR1CHAR1
INSC_NUMCNPJ/SRS number PBR_CNPJ_CEINUMC14NUMC14
EMPLOYEE_INFO 0
MANDTClient MANDTCLNT3MANDT
EVENT_IDEvent identifier HRPADBR_EFD_EVENT_IDNUMC20HRPADBR_EFD_EVENT_ID
RECORD_IDRecord code HRPADBR_EFD_RECORD_IDNUMC9NUMC09
PARENT_IDParent record code HRPADBR_EFD_PARENT_IDNUMC9NUMC09
CPF_NUMBERSole Proprietor's Registry number (CPF) PBR_CPFNRCHAR15PBR_CPFNR
NISRegistration number in corresp.registry (SIP/PSHFP/IC/SUS) PBR_NUM_NITNUMC11
PERNRPersonnel Number P_PERNRNUMC8PERNR
EMPLOYEE_DATA 0
OTHER_INFO 0
MANDTClient MANDTCLNT3MANDT
EVENT_IDEvent identifier HRPADBR_EFD_EVENT_IDNUMC20HRPADBR_EFD_EVENT_ID
RECORD_IDRecord code HRPADBR_EFD_RECORD_IDNUMC9NUMC09
PARENT_IDParent record code HRPADBR_EFD_PARENT_IDNUMC9NUMC09
EE_NAMEName of worker HRPADBR_EMPLOYEE_NAMECHAR80CHAR80
GENDERGender PBR_SEXOCHAR1CHAR1
RACERace/complexion PBR_RACECHAR1PBR_RACE
MARITAL_STMarital status of the worker HRPADBR_EFD_MARITAL_STATUSCHAR1HRPADBR_EFD_MARITAL_STATUS
EDUCATION_LEVELEducation level PBR_FASARCHAR2PBR_FASAR
BIRTH_DTBirth date PBR_BIRTH_DTDATS8DATUM
CITY_CODMunicipality code HRPADBR_CITY_CODENUMC7NUMC07
STATEState GBDEPCHAR3REGIO
BIRTH_COUNTRYCountry of birth code HRPADBR_BIRTH_COUNTRYNUMC5NUMC5
NAT_COUNTRYNationality country code HRPADBR_NAT_COUNTRYNUMC5NUMC5
MOTHER_NAMEMother full name PBR_MOTHECHAR80TEXT80
FATHER_NAMEFull name of father HRPADBR_FATHER_NAMECHAR80CHAR80
DOCUMENTS 0
MANDTClient MANDTCLNT3MANDT
EVENT_IDEvent identifier HRPADBR_EFD_EVENT_IDNUMC20HRPADBR_EFD_EVENT_ID
RECORD_IDRecord code HRPADBR_EFD_RECORD_IDNUMC9NUMC09
PARENT_IDParent record code HRPADBR_EFD_PARENT_IDNUMC9NUMC09
CTPS_NUMBERWorker's Card for Social Welfare number - WCSW PBR_CTNRCHAR10PBR_CTNR
CTPS_SERIESWorker's Card series number - WCSW PBR_CTSRCHAR6PBR_CTSR
CTPS_STATEState (FU) PBR_ESTADCHAR3PBR_ESTAD
RIC_NUMBERCivil identity registry number (RIC) PBR_RICNRCHAR15PBR_CPFNR
RIC_ISSUE_DTDocument's Issue Date PBR_DEMISDATS8DATE
RIC_ISSUERIdentification Document Issuer PBR_IDORGCHAR8PBR_IDORG
RG_NUMBERIdentification Document number PBR_IDNRCHAR16PBR_IDNR
RG_ISSUE_DTDocument's Issue Date PBR_DEMISDATS8DATE
RG_ISSUERIdentification Document Issuer PBR_IDORGCHAR8PBR_IDORG
RNE_NUMBERForeign Identification Document number PBR_IDFNRCHAR20PBR_IDFNR
RNE_ISSUE_DTDocument's Issue Date PBR_DEMISDATS8DATE
RNE_ISSUERIdentification Document Issuer PBR_IDORGCHAR8PBR_IDORG
OC_NUMBERRegistration number in the class body HRPADBR_OC_NUMBERCHAR14CHAR14
OC_ISSUERIdentification Document Issuer PBR_IDORGCHAR8PBR_IDORG
OC_ISSUE_DTDocument's Issue Date PBR_DEMISDATS8DATE
OC_VALIDITY_DTDocument validity date HRPADBR_DOC_VALIDITY_DTDATS8DATUM
CNH_NUMBERProfessional Driver's License number PBR_DRVNRCHAR12PBR_DRVNR
CNH_ISSUERIdentification Document Issuer PBR_IDORGCHAR8PBR_IDORG
CHN_ISSUE_DTDocument's Issue Date PBR_DEMISDATS8DATE
CNH_VALIDITY_DTDocument validity date HRPADBR_DOC_VALIDITY_DTDATS8DATUM
ADDRESS 0
MANDTClient MANDTCLNT3MANDT
EVENT_IDEvent identifier HRPADBR_EFD_EVENT_IDNUMC20HRPADBR_EFD_EVENT_ID
RECORD_IDRecord code HRPADBR_EFD_RECORD_IDNUMC9NUMC09
PARENT_IDParent record code HRPADBR_EFD_PARENT_IDNUMC9NUMC09
COUNTRYCountry code for Brazilian Internal Revenue Service HRPADBR_COUNTRY_RFB_CODENUMC5NUMC05
STREET_ADDR_TYPEStreet type HRPADBR_STREET_ADDRESS_TYPECHAR3CHAR3
STREETStreet description HRPADBR_STREET_ADDRESSCHAR80CHAR80
HS_NUMBERHouse Number PAD_HSNMRCHAR10PAD_HSNMR
COMPLEMENTStreet supplement HRPADBR_ADDRESS_COMPLEMENTCHAR30CHAR30
DISTRICTDistrict PAD_ORT02CHAR40PAD_ORT01
ZIP_CODEPostal Code PSTLZ_HRCHAR10PSTLZ
CITY_CODEMunicipality code HRPADBR_CITY_CODENUMC7NUMC07
CITY_NAMEMunicipality name HRPADBR_CITY_TEXTCHAR60PBRCYHRPADBR_CITY_TEXTHRPADBR_CITY
STATESTATE (State, Province, County) REGIOCHAR3REGIO
OWN_RESIDENCE 0
MANDTClient MANDTCLNT3MANDT
EVENT_IDEvent identifier HRPADBR_EFD_EVENT_IDNUMC20HRPADBR_EFD_EVENT_ID
RECORD_IDRecord code HRPADBR_EFD_RECORD_IDNUMC9NUMC09
PARENT_IDParent record code HRPADBR_EFD_PARENT_IDNUMC9NUMC09
OWN_RESIDENCEIndicator of real estate belonging to worker HRPADBR_OWN_RESIDENCECHAR1CHAR1
FGTS_RESOURCEOwn real estate bought with FGTS resource indicator HRPADBR_FGTS_RESOURCECHAR1CHAR1
FOREIGN_EMPLOYEE 0
MANDTClient MANDTCLNT3MANDT
EVENT_IDEvent identifier HRPADBR_EFD_EVENT_IDNUMC20HRPADBR_EFD_EVENT_ID
RECORD_IDRecord code HRPADBR_EFD_RECORD_IDNUMC9NUMC09
PARENT_IDParent record code HRPADBR_EFD_PARENT_IDNUMC9NUMC09
ARRIV_DTDate of arrival in Brazil PBR_DTARRDATS8DATE
NATUR_DTBrazilian naturalization date HRPADBR_NATUR_DATEDATS8DATUM
MARR_BRBrazilian spouse PBR_MARBRCHAR1XFELD
CHILD_BRChildren with Brazilian indicator HRPADBR_BRAZIL_CHILDCHAR1CHAR1
BANK_DETAILS 0
MANDTClient MANDTCLNT3MANDT
EVENT_IDEvent identifier HRPADBR_EFD_EVENT_IDNUMC20HRPADBR_EFD_EVENT_ID
RECORD_IDRecord code HRPADBR_EFD_RECORD_IDNUMC9NUMC09
PARENT_IDParent record code HRPADBR_EFD_PARENT_IDNUMC9NUMC09
BANK_CODEBank code HRPADBR_BANK_CODECHAR3CHAR3
BANK_AGENCYBank number BANKLCHAR15BANKLBLZ
ACCOUNT_TYPEAccount type HRPADBR_BANK_ACCOUNT_TYPECHAR1HRPADBR_BANK_ACCOUNT_TYPE
ACCOUNT_NRCurrentAccount HRPADBR_BANK_ACCOUNTCHAR20CHAR20
DISABLED_EMPLOYEE 0
MANDTClient MANDTCLNT3MANDT
EVENT_IDEvent identifier HRPADBR_EFD_EVENT_IDNUMC20HRPADBR_EFD_EVENT_ID
RECORD_IDRecord code HRPADBR_EFD_RECORD_IDNUMC9NUMC09
PARENT_IDParent record code HRPADBR_EFD_PARENT_IDNUMC9NUMC09
PHYS_DISABPhysical disability HRPADBR_PHYS_DISABCHAR1CHAR1
VIS_DISABVision impairment HRPADBR_VISUAL_DISABCHAR1CHAR1
HEAR_DISABHearing impairment HRPADBR_HEAR_DISABCHAR1CHAR1
MEN_DISABMental disability HRPADBR_MENTAL_DISABCHAR1CHAR1
REHABILRehabilitated HRPADBR_REHABILITATEDCHAR1CHAR1
CONTACT_INFO 0
MANDTClient MANDTCLNT3MANDT
EVENT_IDEvent identifier HRPADBR_EFD_EVENT_IDNUMC20HRPADBR_EFD_EVENT_ID
RECORD_IDRecord code HRPADBR_EFD_RECORD_IDNUMC9NUMC09
PARENT_IDParent record code HRPADBR_EFD_PARENT_IDNUMC9NUMC09
PHONE1Telephone no. HRPADBR_PHONECHAR12CHAR12
PHONE2Alternative telephone number HRPADBR_PHONE_ALTCHAR12CHAR12
E_MAIL1E-Mail HRPADBR_EMAILCHAR60CHAR60
E_MAIL2Alternative electronic mail HRPADBR_EMAIL_ALTCHAR60CHAR60
CONTRACT 0
MANDTClient MANDTCLNT3MANDT
EVENT_IDEvent identifier HRPADBR_EFD_EVENT_IDNUMC20HRPADBR_EFD_EVENT_ID
RECORD_IDRecord code HRPADBR_EFD_RECORD_IDNUMC9NUMC09
PARENT_IDParent record code HRPADBR_EFD_PARENT_IDNUMC9NUMC09
HIRE_TYPEHiring type HRPADBR_HIRE_TYPECHAR1CHAR1
CONTRACT_TYPEContract Type CTTYPCHAR2CTTYP
CONTRACT_ENDDAContract End Date CTEDTDATS8DATUM
HIRE_INDHiring indicator HRPADBR_HIRE_INDCHAR1CHAR1
LABOR_REGIMELabor regime type HRPADBR_LABOR_REGIMENUMC1NUMC1
SS_REGIMESocial Security regime type HRPADBR_SOCIAL_SEC_REGIMECHAR1CHAR1
ACTIV_NATUREEmployment relationship PBR_EMPIDCHAR2PBR_EMPID
FIXED_WAGEWage PBR_SALACURR15(2) PRBETRG
FIXED_WAGE_UNITRemuneration payment unit HRPADBR_EFD_WAGE_UNITCHAR1HRPADBR_EFD_WAGE_UNIT
VARIABLE_WAGEVariable salary HRPADBR_VAR_WAGECURR15(2) PRBETRG
VAR_WAGE_UNITRemuneration payment unit HRPADBR_EFD_WAGE_UNITCHAR1HRPADBR_EFD_WAGE_UNIT
FIRST_JOB_INDFirst employment indicator HRPADBR_FIRST_JOB_INDCHAR1CHAR1
UNION_CNPJCNPJ/SRS number PBR_CNPJ_CEINUMC14NUMC14
LAWSUIT_NUMBERAdministrative procedure/lawsuit number HRPADBR_LAWSUIT_NUMBERCHAR20CHAR20
EMPLOYMENT_REL 0
LEGAL_INFO 0
MANDTClient MANDTCLNT3MANDT
EVENT_IDEvent identifier HRPADBR_EFD_EVENT_IDNUMC20HRPADBR_EFD_EVENT_ID
RECORD_IDRecord code HRPADBR_EFD_RECORD_IDNUMC9NUMC09
PARENT_IDParent record code HRPADBR_EFD_PARENT_IDNUMC9NUMC09
HIRE_DTHiring date PBR_HIRE_DTDATS8DATUM
CATEGWorker category HRPADBR_WORKER_CATEGNUMC3NUMC03
JOB_CODEJob code HRPADBR_JOB_CODECHAR30CHAR30
ACTIVITY_CODEFunction code HRPADBR_ACTIVITY_CODECHAR30CHAR30
FGTS_FLAGLength of Service Guarantee Fund (FGTS) option indicator PBR_FGTSOCHAR1CHAR1
FGTS_DATEOption date for Legth of Service Guarantee Fund (FGTS) PBR_FGTSDDATS8DATS
WORKPLACE 0
MANDTClient MANDTCLNT3MANDT
EVENT_IDEvent identifier HRPADBR_EFD_EVENT_IDNUMC20HRPADBR_EFD_EVENT_ID
RECORD_IDRecord code HRPADBR_EFD_RECORD_IDNUMC9NUMC09
PARENT_IDParent record code HRPADBR_EFD_PARENT_IDNUMC9NUMC09
WRKPLC_INSC_TYPERegistration type HRPADBR_INSC_TYPECHAR1CHAR1
WRKPLC_INSC_NUMCNPJ/SRS number PBR_CNPJ_CEINUMC14NUMC14
WRKPLC_CODEWorkplace code HRPADBR_WRKPLC_CODECHAR30CHAR30
WRKPLC_DESCWorkplace description HRPADBR_WRKPLC_DESCCHAR100TEXT100
PREVIOUS_ER 0
MANDTClient MANDTCLNT3MANDT
EVENT_IDEvent identifier HRPADBR_EFD_EVENT_IDNUMC20HRPADBR_EFD_EVENT_ID
RECORD_IDRecord code HRPADBR_EFD_RECORD_IDNUMC9NUMC09
PARENT_IDParent record code HRPADBR_EFD_PARENT_IDNUMC9NUMC09
PREVIOUS_CNPJCNPJ/SRS number PBR_CNPJ_CEINUMC14NUMC14
PREVIOUS_PERNRWorker registration in source company HRPADBR_PERNRCHAR30CHAR30
START_DATEEmployment relationship start date HRPADBR_START_DATEDATS8DATUM
TRANSFEROR_ER 0
MANDTClient MANDTCLNT3MANDT
EVENT_IDEvent identifier HRPADBR_EFD_EVENT_IDNUMC20HRPADBR_EFD_EVENT_ID
RECORD_IDRecord code HRPADBR_EFD_RECORD_IDNUMC9NUMC09
PARENT_IDParent record code HRPADBR_EFD_PARENT_IDNUMC9NUMC09
TRANSFEROR_CNPJCNPJ/SRS number PBR_CNPJ_CEINUMC14NUMC14
TRANSFEROR_PERNRWorker registration in source company HRPADBR_PERNRCHAR30CHAR30
TRANSFEROR_BEGDAEmployment relationship start date HRPADBR_START_DATEDATS8DATUM
TRANSFEROR_INFOCost indicador for employer in cession HRPADBR_TRANSFEROR_INFOCHAR1CHAR1
WORK_SCHEDULE 0
WORK_SCHEDULE 0
MANDTClient MANDTCLNT3MANDT
EVENT_IDEvent identifier HRPADBR_EFD_EVENT_IDNUMC20HRPADBR_EFD_EVENT_ID
RECORD_IDRecord code HRPADBR_EFD_RECORD_IDNUMC9NUMC09
PARENT_IDParent record code HRPADBR_EFD_PARENT_IDNUMC9NUMC09
WORK_HOURSHours per week WOSTDDEC5(2) STDAZ
WEEK_CODEWorking time code from Monday til Friday HRPADBR_WEEK_CODECHAR30CHAR30
SATURDAY_CODEWorking time code regarding Saturday HRPADBR_SATURDAY_CODECHAR30CHAR30
FIXED_WORK_SCH 0
MANDTClient MANDTCLNT3MANDT
EVENT_IDEvent identifier HRPADBR_EFD_EVENT_IDNUMC20HRPADBR_EFD_EVENT_ID
RECORD_IDRecord code HRPADBR_EFD_RECORD_IDNUMC9NUMC09
PARENT_IDParent record code HRPADBR_EFD_PARENT_IDNUMC9NUMC09
WORK_HOURSHours per week WOSTDDEC5(2) STDAZ
MONDAY_CODEWorking time code regarding Monday HRPADBR_MONDAY_CODECHAR30CHAR30
TUESDAY_CODEWorking time code regarding Tuesday HRPADBR_TUESDAY_CODECHAR30CHAR30
WEDNESDAY_CODEWorking time code regarding Wednesday HRPADBR_WEDNESDAY_CODECHAR30CHAR30
THURSDAY_CODEWorking time code regarding Thursday HRPADBR_THURSDAY_CODECHAR30CHAR30
FRIDAY_CODEWorking time code regarding Friday HRPADBR_FRIDAY_CODECHAR30CHAR30
SATURDAY_CODEWorking time code regarding Saturday HRPADBR_SATURDAY_CODECHAR30CHAR30
SUNDAY_CODEWorking time code regarding Sunday HRPADBR_SUNDAY_CODECHAR30CHAR30
VAR_WORK_SCHED 0
MANDTClient MANDTCLNT3MANDT
EVENT_IDEvent identifier HRPADBR_EFD_EVENT_IDNUMC20HRPADBR_EFD_EVENT_ID
RECORD_IDRecord code HRPADBR_EFD_RECORD_IDNUMC9NUMC09
PARENT_IDParent record code HRPADBR_EFD_PARENT_IDNUMC9NUMC09
SHIFTShift identification sequential HRPADBR_WSCH_SHIFTCHAR1CHAR1
WORKDAY_CODEWorkday HRPADBR_WORKDAYCHAR30CHAR30
ESPECIAL_WORK_SCH 0
MANDTClient MANDTCLNT3MANDT
EVENT_IDEvent identifier HRPADBR_EFD_EVENT_IDNUMC20HRPADBR_EFD_EVENT_ID
RECORD_IDRecord code HRPADBR_EFD_RECORD_IDNUMC9NUMC09
PARENT_IDParent record code HRPADBR_EFD_PARENT_IDNUMC9NUMC09
SCALE_TYPEScale type HRPADBR_SCALE_TYPECHAR2HRPADBR_SCALE_TYPE
WORK_HOURSHours per week WOSTDDEC5(2) STDAZ
WORKDAY_CODEWorkday HRPADBR_WORKDAYCHAR30CHAR30
ASO_DATA 0
ASO_INFO 0
MANDTClient MANDTCLNT3MANDT
EVENT_IDEvent identifier HRPADBR_EFD_EVENT_IDNUMC20HRPADBR_EFD_EVENT_ID
RECORD_IDRecord code HRPADBR_EFD_RECORD_IDNUMC9NUMC09
PARENT_IDParent record code HRPADBR_EFD_PARENT_IDNUMC9NUMC09
ASO_DATEStart Date BEGDADATS8DATUM
DOCTOR_NAMEPhysician name HRPADBR_DOCTOR_NAMECHAR80CHAR80
CRM_NUMBERPhysician identification code - CRM HRPADBR_DOCTOR_CRMCHAR8CHAR08
CRM_STATESTATE (State, Province, County) REGIOCHAR3REGIO
ASO_TYPEIssued occupational health certificate type HRPADBR_ASO_TYPECHAR1CHAR1
ASO_RESULTASO result HRPADBR_ASO_RESULTCHAR1CHAR1
EXAMS 0
DEPENDENTS 0

Key field Non-key field



How do I retrieve data from SAP structure HRPADBR_EFDE_S_INITIAL_REG using ABAP code?

As HRPADBR_EFDE_S_INITIAL_REG is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on HRPADBR_EFDE_S_INITIAL_REG as there is no data to select.

How to access SAP table HRPADBR_EFDE_S_INITIAL_REG

Within an ECC or HANA version of SAP you can also view further information about HRPADBR_EFDE_S_INITIAL_REG and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!