SAP table P11_P46_XML (HR-IE: XML Reporting structure of P45 Employee details)

Field Description Data Type Length Decimals Checktable Data Element
BUKRS Company Code CHAR 4 0 BUKRS
BUTXT Name of Company Code or Company CHAR 25 0 BUTXT
WERKS Personnel Area CHAR 4 0 T500P PERSA
NAME1 Personnel Area Text CHAR 30 0 PBTXT
BTRTL Personnel Subarea CHAR 4 0 T001P BTRTL
BTEXT Personnel Subarea Text CHAR 15 0 BTRTX
PERSG Employee Group CHAR 1 0 T501 PERSG
PGTXT Name of Employee Group CHAR 20 0 PGTXT
PERSK Employee Subgroup CHAR 2 0 T503K PERSK
PKTXT Name of Employee Subgroup CHAR 20 0 PKTXT
ORGEH Organizational Unit NUMC 8 0 T527X ORGEH
ORGTX Short Text of Organizational Unit CHAR 25 0 ORGTX
KOSTL Cost Center CHAR 10 0 * KOSTL
KOSTT General Name CHAR 20 0 KTEXT
ABKRS Payroll Area CHAR 2 0 T549A ABKRS
ABKTX Payroll Area Text CHAR 20 0 ABKTX
PERNR Personnel Number NUMC 8 0 * PERSNO
ENAME Employer Name CHAR 30 0 PIE_ENAME
TNAME Employer Name CHAR 30 0 PIE_ENAME
EADR1 Employer address line CHAR 30 0 PIE_EADDR
EADR2 Employer address line CHAR 30 0 PIE_EADDR
EADR3 Employer address line CHAR 30 0 PIE_EADDR
ERNIE Employer's Registered Number CHAR 9 0 PIE_ERNIE
CNTCT HR-IE: Mag Media Rec 1 Contact name CHAR 20 0 P11_CNAME
PHONE HR-IE: Mag Media Rec 1 Contact Phone number CHAR 12 0 P11_CPHON
EFAXN HR-IE: Mag Media Rec 1 Contact Phone number CHAR 12 0 P11_CPHON
PERID Personnel ID Number CHAR 20 0 PRDNI
NACHN Last Name CHAR 40 0 PAD_NACHN
VORNA First Name CHAR 40 0 PAD_VORNA
LINE1 HR-IE: Legal reporting Address line CHAR 35 0 P11_ADRS_LINE
LINE2 HR-IE: Legal reporting Address line CHAR 35 0 P11_ADRS_LINE
LINE3 HR-IE: Legal reporting Address line CHAR 35 0 P11_ADRS_LINE
LINE4 HR-IE: Legal reporting Address line CHAR 35 0 P11_ADRS_LINE
EBGDA Start Date DATS 8 0 BEGDA
PFREQ Pay frequency CHAR 1 0 IE_PFREQ
FRMID Issued Form type CHAR 5 0 PIE_FRMID
No Forms Issued
P45P3 P45 part 3 form
P46 P46 form

P11_P46_XML foreign key relationships

Table Field Check Table Check Field
0 P11_P46_XML ABKRS T549A Payroll areas MANDT
0 P11_P46_XML ABKRS T549A Payroll areas ABKRS
1 P11_P46_XML BTRTL T001P Personnel Area/Subarea MANDT
1 P11_P46_XML BTRTL T001P Personnel Area/Subarea WERKS
1 P11_P46_XML BTRTL T001P Personnel Area/Subarea BTRTL
0 P11_P46_XML ORGEH T527X Organizational Units MANDT
0 P11_P46_XML ORGEH T527X Organizational Units SPRSL
0 P11_P46_XML ORGEH T527X Organizational Units ORGEH
0 P11_P46_XML ORGEH T527X Organizational Units ENDDA
1 P11_P46_XML PERSG T501 Employee Group MANDT
1 P11_P46_XML PERSG T501 Employee Group PERSG
0 P11_P46_XML PERSK T503K Employee subgroup MANDT
0 P11_P46_XML PERSK T503K Employee subgroup PERSK
1 P11_P46_XML WERKS T500P Personnel Areas MANDT
1 P11_P46_XML WERKS T500P Personnel Areas PERSA