SAP Table P11_P46_XML
HR-IE: XML Reporting structure of P45 Employee details
P11_P46_XML (HR-IE: XML Reporting structure of P45 Employee details) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link P11_P46_XML to other SAP tables.
Source: P11_P46_XML (HR-IE: XML Reporting structure of P45 Employee details)
P11_P46_XML table fields
Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
BUKRS | Company Code | BUKRS | CHAR | 4 | 0 | |||||||||
BUTXT | Name of Company Code or Company | BUTXT | CHAR | 25 | 0 | |||||||||
WERKS | Personnel Area | PERSA | T500P | CHAR | 4 | 0 | ||||||||
NAME1 | Personnel Area Text | PBTXT | CHAR | 30 | 0 | |||||||||
BTRTL | Personnel Subarea | BTRTL | T001P | CHAR | 4 | 0 | ||||||||
BTEXT | Personnel Subarea Text | BTRTX | CHAR | 15 | 0 | |||||||||
PERSG | Employee Group | PERSG | T501 | CHAR | 1 | 0 | ||||||||
PGTXT | Name of Employee Group | PGTXT | CHAR | 20 | 0 | |||||||||
PERSK | Employee Subgroup | PERSK | T503K | CHAR | 2 | 0 | ||||||||
PKTXT | Name of Employee Subgroup | PKTXT | CHAR | 20 | 0 | |||||||||
ORGEH | Organizational Unit | ORGEH | T527X | NUMC | 8 | 0 | ||||||||
ORGTX | Short Text of Organizational Unit | ORGTX | CHAR | 25 | 0 | |||||||||
KOSTL | Cost Center | KOSTL | CHAR | 10 | 0 | |||||||||
KOSTT | General Name | KTEXT | CHAR | 20 | 0 | |||||||||
ABKRS | Payroll Area | ABKRS | T549A | CHAR | 2 | 0 | ||||||||
ABKTX | Payroll Area Text | ABKTX | CHAR | 20 | 0 | |||||||||
PERNR | Personnel number | PERSNO | NUMC | 8 | 0 | |||||||||
ENAME | Employer Name | PIE_ENAME | CHAR | 30 | 0 | |||||||||
TNAME | Employer Name | PIE_ENAME | CHAR | 30 | 0 | |||||||||
EADR1 | Employer address line | PIE_EADDR | CHAR | 30 | 0 | |||||||||
EADR2 | Employer address line | PIE_EADDR | CHAR | 30 | 0 | |||||||||
EADR3 | Employer address line | PIE_EADDR | CHAR | 30 | 0 | |||||||||
ERNIE | Employer's Registered Number | PIE_ERNIE | CHAR | 9 | 0 | |||||||||
CNTCT | HR-IE: Mag Media Rec 1 Contact name | P11_CNAME | CHAR | 20 | 0 | |||||||||
PHONE | HR-IE: Mag Media Rec 1 Contact Phone number | P11_CPHON | CHAR | 12 | 0 | |||||||||
EFAXN | HR-IE: Mag Media Rec 1 Contact Phone number | P11_CPHON | CHAR | 12 | 0 | |||||||||
PERID | Personnel ID Number | PRDNI | CHAR | 20 | 0 | |||||||||
NACHN | Last Name | PAD_NACHN | CHAR | 40 | 0 | |||||||||
VORNA | First Name | PAD_VORNA | CHAR | 40 | 0 | |||||||||
LINE1 | HR-IE: Legal reporting Address line | P11_ADRS_LINE | CHAR | 35 | 0 | |||||||||
LINE2 | HR-IE: Legal reporting Address line | P11_ADRS_LINE | CHAR | 35 | 0 | |||||||||
LINE3 | HR-IE: Legal reporting Address line | P11_ADRS_LINE | CHAR | 35 | 0 | |||||||||
LINE4 | HR-IE: Legal reporting Address line | P11_ADRS_LINE | CHAR | 35 | 0 | |||||||||
EBGDA | Start Date | BEGDA | DATS | 8 | 0 | |||||||||
PFREQ | Pay frequency | IE_PFREQ | CHAR | 1 | 0 | |||||||||
FRMID | Issued Form type | PIE_FRMID | CHAR | 5 | 0 |
Possible values
|
P11_P46_XML foreign key relationships
Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
---|---|---|---|---|---|---|
P11_P46_XML | ABKRS | SYST | MANDT | T549A | Payroll areas | MANDT |
P11_P46_XML | ABKRS | P11_P46_XML | ABKRS | T549A | Payroll areas | ABKRS |
P11_P46_XML | BTRTL | SYST | MANDT | T001P | Personnel Area/Subarea | MANDT |
P11_P46_XML | BTRTL | P11_P46_XML | WERKS | T001P | Personnel Area/Subarea | WERKS |
P11_P46_XML | BTRTL | P11_P46_XML | BTRTL | T001P | Personnel Area/Subarea | BTRTL |
P11_P46_XML | ORGEH | SYST | MANDT | T527X | Organizational Units | MANDT |
P11_P46_XML | ORGEH | SYST | LANGU | T527X | Organizational Units | SPRSL |
P11_P46_XML | ORGEH | P11_P46_XML | ORGEH | T527X | Organizational Units | ORGEH |
P11_P46_XML | ORGEH | * | T527X | Organizational Units | ENDDA | |
P11_P46_XML | PERSG | SYST | MANDT | T501 | Employee Group | MANDT |
P11_P46_XML | PERSG | P11_P46_XML | PERSG | T501 | Employee Group | PERSG |
P11_P46_XML | PERSK | SYST | MANDT | T503K | Employee subgroup | MANDT |
P11_P46_XML | PERSK | P11_P46_XML | PERSK | T503K | Employee subgroup | PERSK |
P11_P46_XML | WERKS | SYST | MANDT | T500P | Personnel Areas | MANDT |
P11_P46_XML | WERKS | P11_P46_XML | WERKS | T500P | Personnel Areas | PERSA |