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

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