SAP ABAP Table T5A74 (E18 Consolidation File)

Hierarchy

☛ SAP_HRCAT (Software Component) Sub component SAP_HRCAT of SAP_HR
   ⤷ PY-AT (Application Component) Austria
     ⤷ PC03 (Package) HR Payroll: Austria

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	T5A74	Table Relationship Diagram
Short Description	E18 Consolidation File

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	.INCLUDE	☑				0	0	Key of Person-Related Payslip-Dependent Revision Records
3	PERNR	☑	PERSNO	PERSNO	NUMC	8	0	Personnel number	*
4	REVTY	☑	P03_REVTY	P03_REVTY	CHAR	1	0	Revision Type
5	BEGDA	☑	BEGDA	DATUM	DATS	8	0	Start Date
6	ENDDA	☑	ENDDA	DATUM	DATS	8	0	End Date
7	SEQNR	☑	P03_SEQNR	P03_SEQNR	NUMC	6	0	Sequence Document Number
8	.INCLUDE	☐				0	0	Technical Information of a Payslip-Dependent Revision Record
9	SETYP	☐	P03_SETYP	P03_SETYP	CHAR	1	0	Record Type for Electronic Notification
10	READY	☐	P03_READY	P03_READY	CHAR	1	0	Release Status for Electronic Transfer
11	SRTZA	☐	P03_SRTZA	P03_SRTZA	NUMC	3	0	Process Status for Consolidation and Notification Creation
12	EMETH	☐	P03_EMETH	P03_EMETH	CHAR	1	0	Electronic Notification Procedure
13	LZTYP	☐	P03_LZTYP	P03_LZTYP	CHAR	1	0	Payslip Data Category
14	UNAME	☐	P03_MUNAM	UNAME	CHAR	12	0	User Name
15	DATUM	☐	P03_MDATU	DATUM	DATS	8	0	Date
16	UZEIT	☐	P03_MTIME	UZEIT	TIMS	6	0	Time
17	PGMID	☐	P03_MPROG	PROGNAME	CHAR	40	0	ABAP Program Name
18	.INCLUDE	☐				0	0	Payslip - General ELDA Consolidation Data
19	EPRO2	☐	P03_EPRO2	P03_EPRO2	CHAR	1	0	ELDA Project
20	ESVGR	☐	P03_ESVGR	ASVGR	CHAR	1	0	SI Group Transferring Data	*
21	EUSVA	☐	PC03_UVST0		CHAR	2	0	ELDA: Insurance Agency as Data Recipient
22	WOBD0	☐	PB03_WOBD0	TEXT12	CHAR	12	0	Additional Classification Key for Employer
23	ZOBD0	☐	PB03_ZOBD0	TEXT15	CHAR	15	0	Additional Classification Key for Employer
24	EDTNR	☐	PC03_DTRNR	CHAR6	CHAR	6	0	ELDA: Data Medium Number
25	ESANR	☐	PC03_LFDNR	NUM07	NUMC	7	0	ELDA: Sequence Record Number for Each Data Medium
26	.INCLUDE	☐				0	0	Include 1 E18 Consolidation Data
27	ESANI	☐	P03_ESANI	NUM07	NUMC	7	0	ELDA: Number of the Corresponding Information Record
28	.INCLUDE	☐				0	0	General Payslip Tax and Consolidation Data
29	LFVER	☐	P03_LFVER	NUMC2	NUMC	2	0	Payslip Tax: Structure Version
30	TFDAT	☐	P03_TFDAT	DATS	DATS	8	0	Date of Transfer
31	TFTIM	☐	P03C_P_TIM	SYTIME	TIMS	6	0	Time of Transfer
32	FEHL1	☐	P03_LZEID	CHAR005	CHAR	5	0	Error ID for Electronic Notification Record
33	FEHL2	☐	P03_LZEID	CHAR005	CHAR	5	0	Error ID for Electronic Notification Record
34	FEHL3	☐	P03_LZEID	CHAR005	CHAR	5	0	Error ID for Electronic Notification Record
35	FEHL4	☐	P03_LZEID	CHAR005	CHAR	5	0	Error ID for Electronic Notification Record
36	FEHL5	☐	P03_LZEID	CHAR005	CHAR	5	0	Error ID for Electronic Notification Record
37	ESTAT	☐	P03_EPSTA	CHAR1	CHAR	1	0	External Process Status
38	ANZA0	☐	P03_ANZA0	NUM7	NUMC	7	0	Payslip Tax: Number of Notifications (Current)
39	TTE18	☐	P03_ANZE18	NUM7	NUMC	7	0	Total Number of Annual E18 Payslips for DME
40	REFNR	☐	P03_REFNR	CHAR30	CHAR	30	0	Reference Number
41	AUSVL	☐	AUSVL	NUM4	NUMC	4	0	1st part of SI number (sequential number)
42	AUSVG	☐	AUSVG	NUM8	NUMC	8	0	2nd part of SI number (birthdate)
43	ANNNA	☐	PAD_NACHN	PAD_NACHN	CHAR	40	0	Last Name
44	ANVNA	☐	PAD_VORNA	PAD_VORNM	CHAR	40	0	First Name
45	ANTIT	☐	TITEL	TITEL	CHAR	15	0	Title	*
46	GESCH	☐	GESCH	GESCH	CHAR	1	0	Gender Key
47	ANADR	☐	P03_ANLST	PAD_STRAS	CHAR	60	0	Employee's Residential Address
48	ANLKZ	☐	P03_ANLKZ	LANDK	CHAR	3	0	Vehicle Country Key for Home Address
49	ANPLZ	☐	P03_ANPLZ	PSTLZ	CHAR	10	0	Postal Code of Residential Address
50	ANORT	☐	P03_ORT01	PAD_ORT01	CHAR	40	0	Type of Residence
51	ANNUM	☐	P03_ANSTE	NUM7	NUMC	7	0	Tax Number - Employee
52	ANFZA	☐	P03_ANFA0	FZAMA	NUMC	4	0	Tax Office Number of Employee (4-Digit)	*
53	LOHNB	☐	P03_LOHNB	P03_LOHNB	CHAR	4	0	Employer Assignment Unit	*
54	AGNUM	☐	P03_AGNUM	CHAR7	CHAR	7	0	Employer Tax Number
55	AGFZA	☐	FZAMA	FZAMA	NUMC	4	0	Tax office number	*
56	AGDVR	☐	P03_DVRNR	CHAR7	CHAR	7	0	Employer's Data Processing Number
57	AGNAM	☐	P03_NAMAG	TEXT80	CHAR	80	0	Name of Employer
58	AGTIT	☐	P03_TITAG	TEXT30	CHAR	30	0	Title of Employer
59	AGADR	☐	P03_ADRAG	TEXT60	CHAR	60	0	Address of Employer/Contracting Party/Benefits Provider
60	AGLKZ	☐	P03_AGLKZ	LANDK	CHAR	3	0	Vehicle Country Key for Company Address of Empl./Contr.Party
61	AGZIP	☐	P03_AGPLZ	PSTLZ	CHAR	10	0	Postal Code in Company Address of Employer, Contractng Party
62	AGORT	☐	P03_ORTAG	PAD_ORT01	CHAR	40	0	City in Company Address of Employer
63	LBTEL	☐	TLFNR	TEXT30	CHAR	30	0	Addresses: telephone no.
64	LBFAX	☐	TELFX_BAS	TEXT31	CHAR	31	0	Fax number
65	LVNUM	☐	P03_TRSTN	CHAR7	CHAR	7	0	Tax Number of Payroll Service Provider
66	LVFZA	☐	P03_TRFAN	FZAMA	NUMC	4	0	Tax Office Number of Payroll Service Provider	*
67	LVDVR	☐	P03_TRDVR	CHAR7	CHAR	7	0	Data Processing Number of Payroll Service Provider
68	ARTE0	☐	P03_ARTE0	P03_ARTE0	NUMC	2	0	Type of Payslip E18 (Service Provided)
69	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
70	KZ341	☐	P03_KZ341	PRBETRG	CURR	15	2	Remuneration (Without Sales Tax, Incl. Cost Reimb., P/K)
71	KZ344	☐	P03_KZ344	PRBETRG	CURR	15	2	Invoiced Sales Tax (KZ344)
72	KZ270	☐	P03_KZ270	PRBETRG	CURR	15	2	Employee's Contribution to Social Insurance
73	KZ271	☐	P03_KZ271	PRBETRG	CURR	15	2	Paid Contribution to Company Pension Fund (BV)
74	INPER	☐	P03_IPERI	CHAR6	CHAR	6	0	Last In-Period of Payroll in the Record
75	REFN0	☐	P03_REFNR	CHAR30	CHAR	30	0	Reference Number

History

Last changed by/on	SAP	20131127
SAP Release Created in	470