SAP ABAP Table P0221 (Manual checks)

Hierarchy

☛ SAP_HRRXX (Software Component) Sub component SAP_HRRXX of SAP_HR
   ⤷ PY-CA (Application Component) Canada
     ⤷ PCNA (Package) Payroll North America

Basic Data

Table Category	INTTAB	Structure
Structure	P0221	Table Relationship Diagram
Short Description	Manual checks

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	Headers for Infotype Records
2	.INCLUDE	☐				0	0	Keys for HR Master Data
3	PERNR	☐	PERNR_D	PERNR	NUMC	8	0	Personnel Number
4	INFTY	☐	INFTY	INFOTYP	CHAR	4	0	Infotype	T582A
5	SUBTY	☐	SUBTY	SUBTY	CHAR	4	0	Subtype
6	OBJPS	☐	OBJPS	OBJPS	CHAR	2	0	Object Identification
7	SPRPS	☐	SPRPS	SPRPS	CHAR	1	0	Lock Indicator for HR Master Data Record
8	ENDDA	☐	ENDDA	DATUM	DATS	8	0	End Date
9	BEGDA	☐	BEGDA	DATUM	DATS	8	0	Start Date
10	SEQNR	☐	SEQNR	NUM03	NUMC	3	0	Number of Infotype Record With Same Key
11	.INCLUDE	☐				0	0	HR Master Record: Control Field
12	AEDTM	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
13	UNAME	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
14	HISTO	☐	HISTO	CHAR1	CHAR	1	0	Historical Record Flag
15	ITXEX	☐	ITXEX	XFELD	CHAR	1	0	Text Exists for Infotype
16	REFEX	☐	PRFEX	XFELD	CHAR	1	0	Reference Fields Exist (Primary/Secondary Costs)
17	ORDEX	☐	ORDEX	XFELD	CHAR	1	0	Confirmation Fields Exist
18	ITBLD	☐	ITBLD	CHAR2	CHAR	2	0	Infotype Screen Control
19	PREAS	☐	PREAS	PREAS	CHAR	2	0	Reason for Changing Master Data	T530E
20	FLAG1	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
21	FLAG2	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
22	FLAG3	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
23	FLAG4	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
24	RESE1	☐	NUSED2	NUSED2	CHAR	2	0	Reserved Field/Unused Field of Length 2
25	RESE2	☐	NUSED2	NUSED2	CHAR	2	0	Reserved Field/Unused Field of Length 2
26	GRPVL	☐	PCCE_GPVAL	PCCE_GPVAL	CHAR	4	0	Grouping Value for Personnel Assignments
27	.INCLUDE	☐				0	0	Manual Checks
28	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
29	LGA01	☐	LGART	LGART	CHAR	4	0	Wage Type	*
30	TAX01	☐	TAXAT	TAXAT	CHAR	4	0	Tax authority	*
31	BWG01	☐	BWGRL	CURR5_2V	CURR	5	2	Valuation basis
32	STD01	☐	ENSTD	JRSTD	DEC	7	2	No.of hours for remuneration info.
33	BET01	☐	PAD_AMT7S	P_AMT07V	CURR	13	2	Wage Type Amount for Payments
34	OPK01	☐	OPKEN	OPKEN	CHAR	1	0	Operation Indicator for Wage Types
35	LGA02	☐	LGART	LGART	CHAR	4	0	Wage Type	*
36	TAX02	☐	TAXAT	TAXAT	CHAR	4	0	Tax authority	*
37	BWG02	☐	BWGRL	CURR5_2V	CURR	5	2	Valuation basis
38	STD02	☐	ENSTD	JRSTD	DEC	7	2	No.of hours for remuneration info.
39	BET02	☐	PAD_AMT7S	P_AMT07V	CURR	13	2	Wage Type Amount for Payments
40	OPK02	☐	OPKEN	OPKEN	CHAR	1	0	Operation Indicator for Wage Types
41	LGA03	☐	LGART	LGART	CHAR	4	0	Wage Type	*
42	TAX03	☐	TAXAT	TAXAT	CHAR	4	0	Tax authority	*
43	BWG03	☐	BWGRL	CURR5_2V	CURR	5	2	Valuation basis
44	STD03	☐	ENSTD	JRSTD	DEC	7	2	No.of hours for remuneration info.
45	BET03	☐	PAD_AMT7S	P_AMT07V	CURR	13	2	Wage Type Amount for Payments
46	OPK03	☐	OPKEN	OPKEN	CHAR	1	0	Operation Indicator for Wage Types
47	LGA04	☐	LGART	LGART	CHAR	4	0	Wage Type	*
48	TAX04	☐	TAXAT	TAXAT	CHAR	4	0	Tax authority	*
49	BWG04	☐	BWGRL	CURR5_2V	CURR	5	2	Valuation basis
50	STD04	☐	ENSTD	JRSTD	DEC	7	2	No.of hours for remuneration info.
51	BET04	☐	PAD_AMT7S	P_AMT07V	CURR	13	2	Wage Type Amount for Payments
52	OPK04	☐	OPKEN	OPKEN	CHAR	1	0	Operation Indicator for Wage Types
53	LGA05	☐	LGART	LGART	CHAR	4	0	Wage Type	*
54	TAX05	☐	TAXAT	TAXAT	CHAR	4	0	Tax authority	*
55	BWG05	☐	BWGRL	CURR5_2V	CURR	5	2	Valuation basis
56	STD05	☐	ENSTD	JRSTD	DEC	7	2	No.of hours for remuneration info.
57	BET05	☐	PAD_AMT7S	P_AMT07V	CURR	13	2	Wage Type Amount for Payments
58	OPK05	☐	OPKEN	OPKEN	CHAR	1	0	Operation Indicator for Wage Types
59	LGA06	☐	LGART	LGART	CHAR	4	0	Wage Type	*
60	TAX06	☐	TAXAT	TAXAT	CHAR	4	0	Tax authority	*
61	BWG06	☐	BWGRL	CURR5_2V	CURR	5	2	Valuation basis
62	STD06	☐	ENSTD	JRSTD	DEC	7	2	No.of hours for remuneration info.
63	BET06	☐	PAD_AMT7S	P_AMT07V	CURR	13	2	Wage Type Amount for Payments
64	OPK06	☐	OPKEN	OPKEN	CHAR	1	0	Operation Indicator for Wage Types
65	LGA07	☐	LGART	LGART	CHAR	4	0	Wage Type	*
66	TAX07	☐	TAXAT	TAXAT	CHAR	4	0	Tax authority	*
67	BWG07	☐	BWGRL	CURR5_2V	CURR	5	2	Valuation basis
68	STD07	☐	ENSTD	JRSTD	DEC	7	2	No.of hours for remuneration info.
69	BET07	☐	PAD_AMT7S	P_AMT07V	CURR	13	2	Wage Type Amount for Payments
70	OPK07	☐	OPKEN	OPKEN	CHAR	1	0	Operation Indicator for Wage Types
71	LGA08	☐	LGART	LGART	CHAR	4	0	Wage Type	*
72	TAX08	☐	TAXAT	TAXAT	CHAR	4	0	Tax authority	*
73	BWG08	☐	BWGRL	CURR5_2V	CURR	5	2	Valuation basis
74	STD08	☐	ENSTD	JRSTD	DEC	7	2	No.of hours for remuneration info.
75	BET08	☐	PAD_AMT7S	P_AMT07V	CURR	13	2	Wage Type Amount for Payments
76	OPK08	☐	OPKEN	OPKEN	CHAR	1	0	Operation Indicator for Wage Types
77	LGA09	☐	LGART	LGART	CHAR	4	0	Wage Type	*
78	TAX09	☐	TAXAT	TAXAT	CHAR	4	0	Tax authority	*
79	BWG09	☐	BWGRL	CURR5_2V	CURR	5	2	Valuation basis
80	STD09	☐	ENSTD	JRSTD	DEC	7	2	No.of hours for remuneration info.
81	BET09	☐	PAD_AMT7S	P_AMT07V	CURR	13	2	Wage Type Amount for Payments
82	OPK09	☐	OPKEN	OPKEN	CHAR	1	0	Operation Indicator for Wage Types
83	LGA10	☐	LGART	LGART	CHAR	4	0	Wage Type	*
84	TAX10	☐	TAXAT	TAXAT	CHAR	4	0	Tax authority	*
85	BWG10	☐	BWGRL	CURR5_2V	CURR	5	2	Valuation basis
86	STD10	☐	ENSTD	JRSTD	DEC	7	2	No.of hours for remuneration info.
87	BET10	☐	PAD_AMT7S	P_AMT07V	CURR	13	2	Wage Type Amount for Payments
88	OPK10	☐	OPKEN	OPKEN	CHAR	1	0	Operation Indicator for Wage Types
89	LGA11	☐	LGART	LGART	CHAR	4	0	Wage Type	*
90	TAX11	☐	TAXAT	TAXAT	CHAR	4	0	Tax authority	*
91	BWG11	☐	BWGRL	CURR5_2V	CURR	5	2	Valuation basis
92	STD11	☐	ENSTD	JRSTD	DEC	7	2	No.of hours for remuneration info.
93	BET11	☐	PAD_AMT7S	P_AMT07V	CURR	13	2	Wage Type Amount for Payments
94	OPK11	☐	OPKEN	OPKEN	CHAR	1	0	Operation Indicator for Wage Types
95	LGA12	☐	LGART	LGART	CHAR	4	0	Wage Type	*
96	TAX12	☐	TAXAT	TAXAT	CHAR	4	0	Tax authority	*
97	BWG12	☐	BWGRL	CURR5_2V	CURR	5	2	Valuation basis
98	STD12	☐	ENSTD	JRSTD	DEC	7	2	No.of hours for remuneration info.
99	BET12	☐	PAD_AMT7S	P_AMT07V	CURR	13	2	Wage Type Amount for Payments
100	OPK12	☐	OPKEN	OPKEN	CHAR	1	0	Operation Indicator for Wage Types
101	LGA13	☐	LGART	LGART	CHAR	4	0	Wage Type	*
102	TAX13	☐	TAXAT	TAXAT	CHAR	4	0	Tax authority	*
103	BWG13	☐	BWGRL	CURR5_2V	CURR	5	2	Valuation basis
104	STD13	☐	ENSTD	JRSTD	DEC	7	2	No.of hours for remuneration info.
105	BET13	☐	PAD_AMT7S	P_AMT07V	CURR	13	2	Wage Type Amount for Payments
106	OPK13	☐	OPKEN	OPKEN	CHAR	1	0	Operation Indicator for Wage Types
107	LGA14	☐	LGART	LGART	CHAR	4	0	Wage Type	*
108	TAX14	☐	TAXAT	TAXAT	CHAR	4	0	Tax authority	*
109	BWG14	☐	BWGRL	CURR5_2V	CURR	5	2	Valuation basis
110	STD14	☐	ENSTD	JRSTD	DEC	7	2	No.of hours for remuneration info.
111	BET14	☐	PAD_AMT7S	P_AMT07V	CURR	13	2	Wage Type Amount for Payments
112	OPK14	☐	OPKEN	OPKEN	CHAR	1	0	Operation Indicator for Wage Types
113	LGA15	☐	LGART	LGART	CHAR	4	0	Wage Type	*
114	TAX15	☐	TAXAT	TAXAT	CHAR	4	0	Tax authority	*
115	BWG15	☐	BWGRL	CURR5_2V	CURR	5	2	Valuation basis
116	STD15	☐	ENSTD	JRSTD	DEC	7	2	No.of hours for remuneration info.
117	BET15	☐	PAD_AMT7S	P_AMT07V	CURR	13	2	Wage Type Amount for Payments
118	OPK15	☐	OPKEN	OPKEN	CHAR	1	0	Operation Indicator for Wage Types
119	LGA16	☐	LGART	LGART	CHAR	4	0	Wage Type	*
120	TAX16	☐	TAXAT	TAXAT	CHAR	4	0	Tax authority	*
121	BWG16	☐	BWGRL	CURR5_2V	CURR	5	2	Valuation basis
122	STD16	☐	ENSTD	JRSTD	DEC	7	2	No.of hours for remuneration info.
123	BET16	☐	PAD_AMT7S	P_AMT07V	CURR	13	2	Wage Type Amount for Payments
124	OPK16	☐	OPKEN	OPKEN	CHAR	1	0	Operation Indicator for Wage Types
125	LGA17	☐	LGART	LGART	CHAR	4	0	Wage Type	*
126	TAX17	☐	TAXAT	TAXAT	CHAR	4	0	Tax authority	*
127	BWG17	☐	BWGRL	CURR5_2V	CURR	5	2	Valuation basis
128	STD17	☐	ENSTD	JRSTD	DEC	7	2	No.of hours for remuneration info.
129	BET17	☐	PAD_AMT7S	P_AMT07V	CURR	13	2	Wage Type Amount for Payments
130	OPK17	☐	OPKEN	OPKEN	CHAR	1	0	Operation Indicator for Wage Types
131	LGA18	☐	LGART	LGART	CHAR	4	0	Wage Type	*
132	TAX18	☐	TAXAT	TAXAT	CHAR	4	0	Tax authority	*
133	BWG18	☐	BWGRL	CURR5_2V	CURR	5	2	Valuation basis
134	STD18	☐	ENSTD	JRSTD	DEC	7	2	No.of hours for remuneration info.
135	BET18	☐	PAD_AMT7S	P_AMT07V	CURR	13	2	Wage Type Amount for Payments
136	OPK18	☐	OPKEN	OPKEN	CHAR	1	0	Operation Indicator for Wage Types
137	LGA19	☐	LGART	LGART	CHAR	4	0	Wage Type	*
138	TAX19	☐	TAXAT	TAXAT	CHAR	4	0	Tax authority	*
139	BWG19	☐	BWGRL	CURR5_2V	CURR	5	2	Valuation basis
140	STD19	☐	ENSTD	JRSTD	DEC	7	2	No.of hours for remuneration info.
141	BET19	☐	PAD_AMT7S	P_AMT07V	CURR	13	2	Wage Type Amount for Payments
142	OPK19	☐	OPKEN	OPKEN	CHAR	1	0	Operation Indicator for Wage Types
143	LGA20	☐	LGART	LGART	CHAR	4	0	Wage Type	*
144	TAX20	☐	TAXAT	TAXAT	CHAR	4	0	Tax authority	*
145	BWG20	☐	BWGRL	CURR5_2V	CURR	5	2	Valuation basis
146	STD20	☐	ENSTD	JRSTD	DEC	7	2	No.of hours for remuneration info.
147	BET20	☐	PAD_AMT7S	P_AMT07V	CURR	13	2	Wage Type Amount for Payments
148	OPK20	☐	OPKEN	OPKEN	CHAR	1	0	Operation Indicator for Wage Types
149	PAYTY	☐	PAYTY	PAYTY	CHAR	1	0	Payroll type
150	PAYID	☐	PAYID	CHAR1	CHAR	1	0	Payroll Identifier
151	CHECN	☐	CHECT	CHCKN	CHAR	13	0	Check number
152	OCRSN	☐	PAY_OCRSN	PAY_OCRSN	CHAR	4	0	Reason for Off-Cycle Payroll	*
153	.INCLUDE	☐				0	0
154	TCP01	☐	TXCMP	TXCMP	CHAR	4	0	Tax company	T5UTL
155	TCP02	☐	TXCMP	TXCMP	CHAR	4	0	Tax company	T5UTL
156	TCP03	☐	TXCMP	TXCMP	CHAR	4	0	Tax company	T5UTL
157	TCP04	☐	TXCMP	TXCMP	CHAR	4	0	Tax company	T5UTL
158	TCP05	☐	TXCMP	TXCMP	CHAR	4	0	Tax company	T5UTL
159	TCP06	☐	TXCMP	TXCMP	CHAR	4	0	Tax company	T5UTL
160	TCP07	☐	TXCMP	TXCMP	CHAR	4	0	Tax company	T5UTL
161	TCP08	☐	TXCMP	TXCMP	CHAR	4	0	Tax company	T5UTL
162	TCP09	☐	TXCMP	TXCMP	CHAR	4	0	Tax company	T5UTL
163	TCP10	☐	TXCMP	TXCMP	CHAR	4	0	Tax company	T5UTL
164	TCP11	☐	TXCMP	TXCMP	CHAR	4	0	Tax company	T5UTL
165	TCP12	☐	TXCMP	TXCMP	CHAR	4	0	Tax company	T5UTL
166	TCP13	☐	TXCMP	TXCMP	CHAR	4	0	Tax company	T5UTL
167	TCP14	☐	TXCMP	TXCMP	CHAR	4	0	Tax company	T5UTL
168	TCP15	☐	TXCMP	TXCMP	CHAR	4	0	Tax company	T5UTL
169	TCP16	☐	TXCMP	TXCMP	CHAR	4	0	Tax company	T5UTL
170	TCP17	☐	TXCMP	TXCMP	CHAR	4	0	Tax company	T5UTL
171	TCP18	☐	TXCMP	TXCMP	CHAR	4	0	Tax company	T5UTL
172	TCP19	☐	TXCMP	TXCMP	CHAR	4	0	Tax company	T5UTL
173	TCP20	☐	TXCMP	TXCMP	CHAR	4	0	Tax company	T5UTL
174	WRKAR	☐	PCA_WRKAR	PCA_WRKAR	CHAR	4	0	Province of employment	*
175	RESAR	☐	PCA_RESAR	PCA_WRKAR	CHAR	4	0	Employment standard jurisdiction	*
176	CBUSN	☐	PCA_CBUSN	PCA_CBUSN	CHAR	15	0	Business number
177	QCTXI	☐	PCA_QCTXI	PCA_QCTXI	CHAR	16	0	Taxation identification number - QC
178	ADJRN	☐	PNA_ADJRN	FLAG	CHAR	1	0	Status indicator: Infotype 0221 not considered in payroll
179	SEQNO	☐	CDSEQ	NUM5	NUMC	5	0	Sequence Number
180	UOVRD	☐	TAXAT	TAXAT	CHAR	4	0	Tax authority	T5UTZ
181	ROVRD	☐	RESAR	RESAR	CHAR	4	0	Residence tax area	T5UTA
182	WOVRD	☐	WTART	WRKAR	CHAR	4	0	Work tax area	T5UTB

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	P0221	INFTY	T582A	INFTY
2	P0221	PREAS	T530E	PREAS
3	P0221	ROVRD	T5UTA	TAXAR	REF	1	CN
4	P0221	TCP01	T5UTL	TXCMP	REF	1	CN
5	P0221	TCP02	T5UTL	TXCMP	REF	1	CN
6	P0221	TCP03	T5UTL	TXCMP	REF	1	CN
7	P0221	TCP04	T5UTL	TXCMP	REF	1	CN
8	P0221	TCP05	T5UTL	TXCMP	REF	1	CN
9	P0221	TCP06	T5UTL	TXCMP	REF	1	CN
10	P0221	TCP07	T5UTL	TXCMP	REF	1	CN
11	P0221	TCP08	T5UTL	TXCMP	REF	1	CN
12	P0221	TCP09	T5UTL	TXCMP	REF	1	CN
13	P0221	TCP10	T5UTL	TXCMP	REF	1	CN
14	P0221	TCP11	T5UTL	TXCMP	REF	1	CN
15	P0221	TCP12	T5UTL	TXCMP	REF	1	CN
16	P0221	TCP13	T5UTL	TXCMP	REF	1	CN
17	P0221	TCP14	T5UTL	TXCMP	REF	1	CN
18	P0221	TCP15	T5UTL	TXCMP	REF	1	CN
19	P0221	TCP16	T5UTL	TXCMP	REF	1	CN
20	P0221	TCP17	T5UTL	TXCMP	REF	1	CN
21	P0221	TCP18	T5UTL	TXCMP	REF	1	CN
22	P0221	TCP19	T5UTL	TXCMP	REF	1	CN
23	P0221	TCP20	T5UTL	TXCMP	REF	1	CN
24	P0221	UOVRD	T5UTZ	TAXAU	REF	1	CN
25	P0221	WAERS	TCURC	WAERS
26	P0221	WOVRD	T5UTB	TAXAR	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in