SAP ABAP Table P11_P45P3_XML (HR-IE: XML Reporting structure of P45 Employee details)
Hierarchy
☛
SAP_HRCIE (Software Component) Sub component SAP_HRCIE of SAP_HR
⤷ PY-IE (Application Component) Ireland
⤷ PC11 (Package) HR payroll: Ireland
⤷ PY-IE (Application Component) Ireland
⤷ PC11 (Package) HR payroll: Ireland
Basic Data
Table Category | INTTAB | Structure |
Structure | P11_P45P3_XML | Table Relationship Diagram |
Short Description | HR-IE: XML Reporting structure of P45 Employee details |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | .INCLUDE | 0 | 0 | HR-IE: General List output header | |||||
2 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | * | |
3 | BUTXT | BUTXT | TEXT25 | CHAR | 25 | 0 | Name of Company Code or Company | ||
4 | WERKS | PERSA | PERSA | CHAR | 4 | 0 | Personnel Area | T500P | |
5 | NAME1 | PBTXT | TEXT30 | CHAR | 30 | 0 | Personnel Area Text | ||
6 | BTRTL | BTRTL | BTRTL | CHAR | 4 | 0 | Personnel Subarea | T001P | |
7 | BTEXT | BTRTX | TEXT15 | CHAR | 15 | 0 | Personnel Subarea Text | ||
8 | PERSG | PERSG | PERSG | CHAR | 1 | 0 | Employee Group | T501 | |
9 | PGTXT | PGTXT | TEXT20 | CHAR | 20 | 0 | Name of Employee Group | ||
10 | PERSK | PERSK | PERSK | CHAR | 2 | 0 | Employee Subgroup | T503K | |
11 | PKTXT | PKTXT | TEXT20 | CHAR | 20 | 0 | Name of Employee Subgroup | ||
12 | ORGEH | ORGEH | ORGEH | NUMC | 8 | 0 | Organizational Unit | T527X | |
13 | ORGTX | ORGTX | TEXT25 | CHAR | 25 | 0 | Short Text of Organizational Unit | ||
14 | KOSTL | KOSTL | KOSTL | CHAR | 10 | 0 | Cost Center | * | |
15 | KOSTT | KTEXT | TEXT20 | CHAR | 20 | 0 | General Name | ||
16 | ABKRS | ABKRS | ABKRS | CHAR | 2 | 0 | Payroll Area | T549A | |
17 | ABKTX | ABKTX | TEXT20 | CHAR | 20 | 0 | Payroll Area Text | ||
18 | PERNR | PERSNO | PERSNO | NUMC | 8 | 0 | Personnel number | * | |
19 | .INCLUDE | 0 | 0 | P45 Part 3 / P46 Employer details structure | |||||
20 | ENAME | PIE_ENAME | PIE_ENAME | CHAR | 30 | 0 | Employer Name | ||
21 | TNAME | PIE_ENAME | PIE_ENAME | CHAR | 30 | 0 | Employer Name | ||
22 | EADR1 | PIE_EADDR | PIE_EADDR | CHAR | 30 | 0 | Employer address line | ||
23 | EADR2 | PIE_EADDR | PIE_EADDR | CHAR | 30 | 0 | Employer address line | ||
24 | EADR3 | PIE_EADDR | PIE_EADDR | CHAR | 30 | 0 | Employer address line | ||
25 | ERNIE | PIE_ERNIE | PIE_ERNIE | CHAR | 9 | 0 | Employer's Registered Number | ||
26 | CNTCT | P11_CNAME | CHAR20 | CHAR | 20 | 0 | HR-IE: Mag Media Rec 1 Contact name | ||
27 | PHONE | P11_CPHON | CHAR12 | CHAR | 12 | 0 | HR-IE: Mag Media Rec 1 Contact Phone number | ||
28 | EFAXN | P11_CPHON | CHAR12 | CHAR | 12 | 0 | HR-IE: Mag Media Rec 1 Contact Phone number | ||
29 | .INCLUDE | 0 | 0 | P45 Part 3 / P46 Employee details structure | |||||
30 | PERID | PRDNI | CHAR20 | CHAR | 20 | 0 | Personnel ID Number | ||
31 | NACHN | PAD_NACHN | PAD_NACHN | CHAR | 40 | 0 | Last Name | ||
32 | VORNA | PAD_VORNA | PAD_VORNM | CHAR | 40 | 0 | First Name | ||
33 | LINE1 | P11_ADRS_LINE | CHAR35 | CHAR | 35 | 0 | HR-IE: Legal reporting Address line | ||
34 | LINE2 | P11_ADRS_LINE | CHAR35 | CHAR | 35 | 0 | HR-IE: Legal reporting Address line | ||
35 | LINE3 | P11_ADRS_LINE | CHAR35 | CHAR | 35 | 0 | HR-IE: Legal reporting Address line | ||
36 | LINE4 | P11_ADRS_LINE | CHAR35 | CHAR | 35 | 0 | HR-IE: Legal reporting Address line | ||
37 | EBGDA | BEGDA | DATUM | DATS | 8 | 0 | Start Date | ||
38 | PFREQ | IE_PFREQ | CHAR1 | CHAR | 1 | 0 | Pay frequency | ||
39 | FRMID | PIE_FRMID | PIE_FRMID | CHAR | 5 | 0 | Issued Form type | ||
40 | .INCLUDE | 0 | 0 | P45 Part 3 / P46 Previous employment details structure | |||||
41 | P45PY | PIE_P45PY | PIE_CRNCY | CURR | 11 | 2 | P45 Previous Pay | ||
42 | P45TX | PIE_P45TX | PIE_CRNCY | CURR | 11 | 2 | Tax Deducted | ||
43 | PP45P | PIE_PP45P | PIE_CRNCY | CURR | 11 | 2 | Previous employment's P45 Pay | ||
44 | PP45T | PIE_PP45T | PIE_CRNCY | CURR | 11 | 2 | Tax Deducted in Previous employment | ||
45 | PTXRD | PIE_PTXRD | XFELD | CHAR | 1 | 0 | Tax refund indicator | ||
46 | PBEGD | PIE_PBEGD | DATUM | DATS | 8 | 0 | Previous Employment Start Date | ||
47 | PENDD | PIE_PENDD | DATUM | DATS | 8 | 0 | Previous Employment's End Date | ||
48 | PERNE | PIE_ERNIE | PIE_ERNIE | CHAR | 9 | 0 | Employer's Registered Number | ||
49 | P45USCPY | P11_USC_PY | PRBETRG | CURR | 15 | 2 | HR IE: Total USC Payable | ||
50 | P45USCPD | P11_USC_PD | PRBETRG | CURR | 15 | 2 | HR IE: Total USC Paid | ||
51 | PREUSCPY | P11_USC_PY_P45 | PRBETRG | CURR | 15 | 2 | HR IE: Total USC Payable This Employment | ||
52 | PREUSCPD | P11_USC_PD_P45 | PRBETRG | CURR | 15 | 2 | HR IE: Total USC Paid this Employment | ||
53 | USCRFD | PIE_BOLEAN | CHAR5 | CHAR | 5 | 0 | HR IE: Boolean True or False Value | ||
54 | LPT | PIE_LPTAX | PIE_CRNCY | CURR | 11 | 2 | Local Property Tax |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | P11_P45P3_XML | ABKRS | T549A | ABKRS | |||
2 | P11_P45P3_XML | BTRTL | T001P | BTRTL | |||
3 | P11_P45P3_XML | ORGEH | T527X | ORGEH | |||
4 | P11_P45P3_XML | PERSG | T501 | PERSG | |||
5 | P11_P45P3_XML | PERSK | T503K | PERSK | |||
6 | P11_P45P3_XML | WERKS | T500P | PERSA |
History
Last changed by/on | SAP | 20131127 |
SAP Release Created in |