SAP ABAP Table P05T_JLO_DATA (Data for Annual Wage Return)

Hierarchy

☛ SAP_HRCNL (Software Component) Sub component SAP_HRCNL of SAP_HR
   ⤷ PY-NL-RP (Application Component) Reporting
     ⤷ P05T (Package) HR Payroll: The Netherlands

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	P05T_JLO_DATA	Table Relationship Diagram
Short Description	Data for Annual Wage Return

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	T000
2	LHNR	☑	P05T_LHNR	CHAR12	CHAR	12	0	Wage Return: Wage Tax Number
3	JAAR	☑	P05T_JLO_YEAR	GJAHR	NUMC	4	0	Year of Annual Wage Return
4	DATAANVTV	☑	BEGDA	DATUM	DATS	8	0	Start Date
5	SEQNO	☑	P05T_SEQNO	NUMC4	NUMC	4	0	Wage Return: Sequence Number
6	PERNR	☑	P_PERNR	PERNR	NUMC	8	0	Personnel Number
7	BEGDAIV	☑	BEGDA	DATUM	DATS	8	0	Start Date
8	ENDDAIV	☐	ENDDA	DATUM	DATS	8	0	End Date
9	AANDIV	☐	P05T_AANDIV	TEXT35	CHAR	35	0	Wage Return: Income Relationship Code
10	SOFINR	☐	P05T_SOFINR		NUMC	9	0	Wage return: CSN/SoFi Number
11	SIGNM	☐	P05T_SIGNM	TEXT200	CHAR	200	0	Wage Return: Significant Part of Last Name
12	GEBDAT	☐	GBDAT	GBDAT	DATS	8	0	Date of Birth
13	SRTIV	☐	P05T_SRTIV	P05T_SRTIV	CHAR	2	0	Wage Return: Income Relationship
14	CDAARD	☐	P05T_CDAARD	P05_CAARD	CHAR	2	0	Wage Return: Type of Work Relationship Code	T5N72
15	CDINVLVPL	☐	P05_CIVPL	P05_CIVPL	CHAR	3	0	Insurance Obligation Influence Code	T5N74
16	CDBEPTD	☐	P05T_CDBEPTD	P05T_CDBEPTD	CHAR	1	0	Wage Return: Open-Ended/Fixed-Term Contract Code
17	FSINDFZ	☐	P05T_FSINDFZ	P05_CFIFZ	CHAR	2	0	Wage Return: F & S Phase Categorization Code	T5N75
18	CDAGH	☐	P05T_CDAGH	P05T_CDAGH	CHAR	1	0	Contribution Reduction Code
19	INDLHKORT	☐	P05T_INDLHKORT	P05_INDIC	CHAR	1	0	Wage Return: Wage Tax Reduction Code
20	GEBRAUTO	☐	P05T_GEBRAUTO	P05T_GEBRAUTO	CHAR	1	0	Wage Return: Reason for No Add.to Taxab.Income for Car Code
21	LBTAB	☐	P05T_LBTAB	CHAR3	CHAR	3	0	Wage Return: Employment Tax Table Code
22	INDWAO	☐	P05T_INDWAO	P05_INDIC	CHAR	1	0	Wage Return: "WAO" Insured Code
23	INDWW	☐	P05T_INDWW	P05_INDIC	CHAR	1	0	Wage Return: "WW" Insured Code
24	INDZW	☐	P05T_INDZW	P05_INDIC	CHAR	1	0	Wage Return: "ZW" Insured Code
25	CDZVW	☐	P05T_CDZVW	P05_CDZVW	CHAR	1	0	Wage Return: "Zvw" Insurance Situation Code
26	INDSA71	☐	P05T_INDICATOR	P05_INDIC	CHAR	1	0	Wage Return: Code
27	INDSA72	☐	P05T_INDICATOR	P05_INDIC	CHAR	1	0	Wage Return: Code
28	INDSA43	☐	P05T_INDICATOR	P05_INDIC	CHAR	1	0	Wage Return: Code
29	INDSA03	☐	P05T_INDICATOR	P05_INDIC	CHAR	1	0	Wage Return: Code
30	SECT	☐	P05_SECT	P05_SECT	CHAR	3	0	Sector	T5N15
31	RISGRP	☐	P05_RISGRP	P05_RISGRP	CHAR	2	0	Risk Group Indicator	T5N13
32	LNLBPH	☐	P05T_AMOUNT	P05T_AMOUNT	CURR	15	2	Amount
33	LNSV	☐	P05T_AMOUNT	P05T_AMOUNT	CURR	15	2	Amount
34	LNTABBB	☐	P05T_AMOUNT	P05T_AMOUNT	CURR	15	2	Amount
35	INGLBPH	☐	P05T_AMOUNT	P05T_AMOUNT	CURR	15	2	Amount
36	PRWAOAOF	☐	P05T_AMOUNT	P05T_AMOUNT	CURR	15	2	Amount
37	PRWAOAOK	☐	P05T_AMOUNT	P05T_AMOUNT	CURR	15	2	Amount
38	PRAWF	☐	P05T_AMOUNT	P05T_AMOUNT	CURR	15	2	Amount
39	PRWGF	☐	P05T_AMOUNT	P05T_AMOUNT	CURR	15	2	Amount
40	PRUFO	☐	P05T_AMOUNT	P05T_AMOUNT	CURR	15	2	Amount
41	BIJDRZVW	☐	P05T_AMOUNT	P05T_AMOUNT	CURR	15	2	Amount
42	VERGZVW	☐	P05T_AMOUNT	P05T_AMOUNT	CURR	15	2	Amount
43	WRDPRGEBRAUT	☐	P05T_AMOUNT	P05T_AMOUNT	CURR	15	2	Amount
44	WRKNBIJDRAUT	☐	P05T_AMOUNT	P05T_AMOUNT	CURR	15	2	Amount
45	LVLPREG	☐	P05T_AMOUNT	P05T_AMOUNT	CURR	15	2	Amount
46	REISK	☐	P05T_AMOUNT	P05T_AMOUNT	CURR	15	2	Amount
47	VERRARBKRT	☐	P05T_AMOUNT	P05T_AMOUNT	CURR	15	2	Amount
48	BEDRZDAFTR	☐	P05T_AMOUNT	P05T_AMOUNT	CURR	15	2	Amount
49	BEDRALINWWB	☐	P05T_AMOUNT	P05T_AMOUNT	CURR	15	2	Amount
50	BEDRRCHTAL	☐	P05T_AMOUNT	P05T_AMOUNT	CURR	15	2	Amount
51	NUMIV	☐	P05T_NUMIV	NUM4	NUMC	4	0	IR Number
52	LVLPREGTOEG	☐	P05T_AMOUNT	P05T_AMOUNT	CURR	15	2	Amount
53	INDPKAGH	☐	P05T_INDPKAGH	P05_INDIC	CHAR	1	0	Premium Reduction Work Disability
54	INDPKNAOW	☐	P05T_INDPKNAOW	P05_INDIC	CHAR	1	0	Premium Reduction Hiring Elderly Employee
55	INDPKIDOW	☐	P05T_INDPKIDOW	P05_INDIC	CHAR	1	0	Premium Reduction Employing Elderly Employee
56	INDPMA	☐	P05T_INDPMA	P05_INDIC	CHAR	1	0	PMA (Ex-Social Benefits Recipient)
57	INDWOR	☐	P05T_INDWOR	P05_INDIC	CHAR	1	0	Reduced Pay Old Regulation
58	PRLNWAOAOF	☐	P05T_AMOUNT	P05T_AMOUNT	CURR	15	2	Amount
59	PRLNPRSECTFNDS	☐	P05T_AMOUNT	P05T_AMOUNT	CURR	15	2	Amount
60	PRLNWAOAOK	☐	P05T_AMOUNT	P05T_AMOUNT	CURR	15	2	Amount
61	PRLNAWF	☐	P05T_AMOUNT	P05T_AMOUNT	CURR	15	2	Amount
62	PRLNUFO	☐	P05T_AMOUNT	P05T_AMOUNT	CURR	15	2	Amount

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	P05T_JLO_DATA	CDAARD	T5N72	CAARD	KEY	C	CN
2	P05T_JLO_DATA	CDINVLVPL	T5N74	CIVPL	KEY	C	CN
3	P05T_JLO_DATA	FSINDFZ	T5N75	CFIFZ	KEY	C	CN
4	P05T_JLO_DATA	MANDT	T000	MANDT	KEY	1	CN
5	P05T_JLO_DATA	RISGRP	T5N13	RISICOGROEP	KEY	C	CN
6	P05T_JLO_DATA	SECT	T5N15	SECTOR	KEY	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in