SAP ABAP Table PA0221 (HR Master Record: Infotype 0221 (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	TRANSP	Transparent table
Transparent table	PA0221	Table Relationship Diagram
Short Description	HR Master Record: Infotype 0221 (Manual Checks)

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

History

Last changed by/on	SAP	20130529
SAP Release Created in