	Table	Columns	Description
1	TJKWE	15	IS-M/SD: WBZ, Order Data for Inbound Processing
2	RSADMINC	96	Customizing Table General BW
3	BBP_PD_XML	8	Table for Persistent Class CL_XML_PPF_BBP
4	/OTX/RM_TELIB	24	Enterprise Library Server Settings
5	UMV_TR125	9	Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
7	/ISDFPS/CHVW_E	34	External Batch Where-Used List
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	FMARCPAR	4	Parallelization of FMARC_BATCH
10	CEKRS	5	Movement type parameters for automatic ERS

	Table	Columns	Description
1	OITM	299	Items
2	OINV	386	A/R Invoice
3	OCRD	332	Business Partner
4	ORDR	386	Sales Order
5	INV1	265	A/R Invoice - Rows
6	OJDT	100	Journal Entry
7	OPCH	386	A/P Invoice
8	OVTG	52	Tax Definition
9	OPOR	386	Purchase Order
10	JDT1	124	Journal Entry - Rows

	Table	Columns	Description
1	OITM	249	Items
2	ORCT	154	Incoming Payment
3	OINV	268	A/R Invoice
4	OIVL	77	Whse Journal
5	OVPM	154	Outgoing Payments
6	OPCH	268	A/P Invoice
7	JDT1	110	Journal Entry - Rows
8	OOCR	9	Loading Factors
9	OSRN	20	Serial Numbers Master Data
10	OBOT	10	Bill Of Exchang Transaction

223 COLUMNS | 1 INDEXES | ERP 6.0 | PA0201 TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Personnel Management :: Pension Schemes :: Company Pension Scheme Germany
1	ERP EHP7	6.0	PA0201	223	1	HR Master Record Infotype 0201 (Basic Pension Payments)	Company Pension Scheme Germany

SQL: selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, PERNR, SUBTY, OBJPS, SPRPS, ENDDA, BEGDA, SEQNR, AEDTM, UNAME, HISTO, ITXEX, REFEX, ORDEX, ITBLD, PREAS, FLAG1, FLAG2, FLAG3, FLAG4, RESE1, RESE2, GRPVL, RNTYP, WAERS, ANG01, HAN01, AAN01, MBV01, LUR01, NAR01, LGA01, BET01, APD01, LTR01, ANG02, HAN02, AAN02, MBV02, LUR02, NAR02, LGA02, BET02, APD02, LTR02, ANG03, HAN03, AAN03, MBV03, LUR03, NAR03, LGA03, BET03, APD03, LTR03, ANG04, HAN04, AAN04, MBV04, LUR04, NAR04, LGA04, BET04, APD04, LTR04, ANG05, HAN05, AAN05, MBV05, LUR05, NAR05, LGA05, BET05, APD05, LTR05, ANG06, HAN06, AAN06, MBV06, LUR06, NAR06, LGA06, BET06, APD06, LTR06, ANG07, HAN07, AAN07, MBV07, LUR07, NAR07, LGA07, BET07, APD07, LTR07, ANG08, HAN08, AAN08, MBV08, LUR08, NAR08, LGA08, BET08, APD08, LTR08, ANG09, HAN09, AAN09, MBV09, LUR09, NAR09, LGA09, BET09, APD09, LTR09, ANG10, HAN10, AAN10, MBV10, LUR10, NAR10, LGA10, BET10, APD10, LTR10, ANG11, HAN11, AAN11, MBV11, LUR11, NAR11, LGA11, BET11, APD11, LTR11, ANG12, HAN12, AAN12, MBV12, LUR12, NAR12, LGA12, BET12, APD12, LTR12, ANG13, HAN13, AAN13, MBV13, LUR13, NAR13, LGA13, BET13, APD13, LTR13, ANG14, HAN14, AAN14, MBV14, LUR14, NAR14, LGA14, BET14, APD14, LTR14, ANG15, HAN15, AAN15, MBV15, LUR15, NAR15, LGA15, BET15, APD15, LTR15, ANG16, HAN16, AAN16, MBV16, LUR16, NAR16, LGA16, BET16, APD16, LTR16, ANG17, HAN17, AAN17, MBV17, LUR17, NAR17, LGA17, BET17, APD17, LTR17, ANG18, HAN18, AAN18, MBV18, LUR18, NAR18, LGA18, BET18, APD18, LTR18, LFD01, LFD02, LFD03, LFD04, LFD05, LFD06, LFD07, LFD08, LFD09, LFD10, LFD11, LFD12, LFD13, LFD14, LFD15, LFD16, LFD17, LFD18 FROM PA0201

TOP ERP 6.0 | PA0201 COLUMNS

Column	Field	Description	SQL Type	Length	Decimals	SAP Type	Default Value	Null Allowed	CheckTable	Rollname	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	CLNT	(N'000')	No	T000	MANDT	Allow NULL?
2	PERNR	Personnel number	nvarchar	8	0	NUMC	(N'00000000')	No	PA0003	PERSNO	Allow NULL?
3	SUBTY	Subtype	nvarchar	4	0	CHAR	(N' ')	No		SUBTY	Allow NULL?
4	OBJPS	Object Identification	nvarchar	2	0	CHAR	(N' ')	No		OBJPS	Allow NULL?
5	SPRPS	Lock Indicator for HR Master Data Record	char	1	0	CHAR	(N' ')	No		SPRPS	Allow NULL?
6	ENDDA	End Date	nvarchar	8	0	DATS	(N'00000000')	No		ENDDA	Allow NULL?
7	BEGDA	Start Date	nvarchar	8	0	DATS	(N'00000000')	No		BEGDA	Allow NULL?
8	SEQNR	Number of Infotype Record with Same Key	nvarchar	3	0	NUMC	(N'000')	No		SEQNR	Allow NULL?
9	AEDTM	Changed On	nvarchar	8	0	DATS	(N'00000000')	Yes		AEDAT	Allow NULL?
10	UNAME	Name of Person Who Changed Object	nvarchar	12	0	CHAR	(N' ')	Yes		AENAM	Allow NULL?
11	HISTO	Historical Record Flag	char	1	0	CHAR	(N' ')	Yes		HISTO	Allow NULL?
12	ITXEX	Text Exists for Infotype	char	1	0	CHAR	(N' ')	Yes		ITXEX	Allow NULL?
13	REFEX	Reference Fields Exist (Primary/Secondary Costs)	char	1	0	CHAR	(N' ')	Yes		PRFEX	Allow NULL?
14	ORDEX	Confirmation Fields Exist	char	1	0	CHAR	(N' ')	Yes		ORDEX	Allow NULL?
15	ITBLD	Infotype Screen Control	nvarchar	2	0	CHAR	(N' ')	Yes		ITBLD	Allow NULL?
16	PREAS	Reason for Changing Master Data	nvarchar	2	0	CHAR	(N' ')	Yes	T530E	PREAS	Allow NULL?
17	FLAG1	Reserved Field/Unused Field	char	1	0	CHAR	(N' ')	Yes		NUSED	Allow NULL?
18	FLAG2	Reserved Field/Unused Field	char	1	0	CHAR	(N' ')	Yes		NUSED	Allow NULL?
19	FLAG3	Reserved Field/Unused Field	char	1	0	CHAR	(N' ')	Yes		NUSED	Allow NULL?
20	FLAG4	Reserved Field/Unused Field	char	1	0	CHAR	(N' ')	Yes		NUSED	Allow NULL?
21	RESE1	Reserved Field/Unused Field of Length 2	nvarchar	2	0	CHAR	(N' ')	Yes		NUSED2	Allow NULL?
22	RESE2	Reserved Field/Unused Field of Length 2	nvarchar	2	0	CHAR	(N' ')	Yes		NUSED2	Allow NULL?
23	GRPVL	Grouping Value for Personnel Assignments	nvarchar	4	0	CHAR	(N' ')	Yes		PCCE_GPVAL	Allow NULL?
24	RNTYP	Pension Category	nvarchar	4	0	CHAR	(N' ')	Yes	T5DCE	P01C_RNTYP	Allow NULL?
25	WAERS	Currency Key	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	WAERS	Allow NULL?
26	ANG01	Pension Plan	nvarchar	4	0	CHAR	(N' ')	Yes	*	P01C_ANGRP	Allow NULL?
27	HAN01	Company Pension Scheme Entitlement	nvarchar	4	0	CHAR	(N' ')	Yes	T5DCA	P01C_HANSP	Allow NULL?
28	AAN01	Benefit Type of Company Pension Scheme	nvarchar	4	0	CHAR	(N' ')	Yes	T5DCA	P01C_AANSP	Allow NULL?
29	MBV01	Calculation Variant for Entitlement	nvarchar	2	0	CHAR	(N' ')	Yes	*	P01C_MODBV	Allow NULL?
30	LUR01	Company Responsible	nvarchar	4	0	CHAR	(N' ')	Yes	*	P01C_LURSP	Allow NULL?
31	NAR01	Not Payroll Relevant	char	1	0	CHAR	(N' ')	Yes		P01C_NAREL	Allow NULL?
32	LGA01	Wage Type	nvarchar	4	0	CHAR	(N' ')	Yes	*	P01C_LGART	Allow NULL?
33	BET01	Amount	decimal	8	2	CURR	((0))	Yes		P01C_BET72
34	APD01	Check Date for Next Adjustment	nvarchar	8	0	DATS	(N'00000000')	Yes		P01C_APDAT	Allow NULL?
35	LTR01	Benefits Provider	nvarchar	4	0	CHAR	(N' ')	Yes	*	P01C_LTRGR	Allow NULL?
36	ANG02	Pension Plan	nvarchar	4	0	CHAR	(N' ')	Yes	*	P01C_ANGRP	Allow NULL?
37	HAN02	Company Pension Scheme Entitlement	nvarchar	4	0	CHAR	(N' ')	Yes	T5DCA	P01C_HANSP	Allow NULL?
38	AAN02	Benefit Type of Company Pension Scheme	nvarchar	4	0	CHAR	(N' ')	Yes	T5DCA	P01C_AANSP	Allow NULL?
39	MBV02	Calculation Variant for Entitlement	nvarchar	2	0	CHAR	(N' ')	Yes	*	P01C_MODBV	Allow NULL?
40	LUR02	Company Responsible	nvarchar	4	0	CHAR	(N' ')	Yes	*	P01C_LURSP	Allow NULL?
41	NAR02	Not Payroll Relevant	char	1	0	CHAR	(N' ')	Yes		P01C_NAREL	Allow NULL?
42	LGA02	Wage Type	nvarchar	4	0	CHAR	(N' ')	Yes	*	P01C_LGART	Allow NULL?
43	BET02	Amount	decimal	8	2	CURR	((0))	Yes		P01C_BET72
44	APD02	Check Date for Next Adjustment	nvarchar	8	0	DATS	(N'00000000')	Yes		P01C_APDAT	Allow NULL?
45	LTR02	Benefits Provider	nvarchar	4	0	CHAR	(N' ')	Yes	*	P01C_LTRGR	Allow NULL?
46	ANG03	Pension Plan	nvarchar	4	0	CHAR	(N' ')	Yes	*	P01C_ANGRP	Allow NULL?
47	HAN03	Company Pension Scheme Entitlement	nvarchar	4	0	CHAR	(N' ')	Yes	T5DCA	P01C_HANSP	Allow NULL?
48	AAN03	Benefit Type of Company Pension Scheme	nvarchar	4	0	CHAR	(N' ')	Yes	T5DCA	P01C_AANSP	Allow NULL?
49	MBV03	Calculation Variant for Entitlement	nvarchar	2	0	CHAR	(N' ')	Yes	*	P01C_MODBV	Allow NULL?
50	LUR03	Company Responsible	nvarchar	4	0	CHAR	(N' ')	Yes	*	P01C_LURSP	Allow NULL?
51	NAR03	Not Payroll Relevant	char	1	0	CHAR	(N' ')	Yes		P01C_NAREL	Allow NULL?
52	LGA03	Wage Type	nvarchar	4	0	CHAR	(N' ')	Yes	*	P01C_LGART	Allow NULL?
53	BET03	Amount	decimal	8	2	CURR	((0))	Yes		P01C_BET72
54	APD03	Check Date for Next Adjustment	nvarchar	8	0	DATS	(N'00000000')	Yes		P01C_APDAT	Allow NULL?
55	LTR03	Benefits Provider	nvarchar	4	0	CHAR	(N' ')	Yes	*	P01C_LTRGR	Allow NULL?
56	ANG04	Pension Plan	nvarchar	4	0	CHAR	(N' ')	Yes	*	P01C_ANGRP	Allow NULL?
57	HAN04	Company Pension Scheme Entitlement	nvarchar	4	0	CHAR	(N' ')	Yes	T5DCA	P01C_HANSP	Allow NULL?
58	AAN04	Benefit Type of Company Pension Scheme	nvarchar	4	0	CHAR	(N' ')	Yes	T5DCA	P01C_AANSP	Allow NULL?
59	MBV04	Calculation Variant for Entitlement	nvarchar	2	0	CHAR	(N' ')	Yes	*	P01C_MODBV	Allow NULL?
60	LUR04	Company Responsible	nvarchar	4	0	CHAR	(N' ')	Yes	*	P01C_LURSP	Allow NULL?
61	NAR04	Not Payroll Relevant	char	1	0	CHAR	(N' ')	Yes		P01C_NAREL	Allow NULL?
62	LGA04	Wage Type	nvarchar	4	0	CHAR	(N' ')	Yes	*	P01C_LGART	Allow NULL?
63	BET04	Amount	decimal	8	2	CURR	((0))	Yes		P01C_BET72
64	APD04	Check Date for Next Adjustment	nvarchar	8	0	DATS	(N'00000000')	Yes		P01C_APDAT	Allow NULL?
65	LTR04	Benefits Provider	nvarchar	4	0	CHAR	(N' ')	Yes	*	P01C_LTRGR	Allow NULL?
66	ANG05	Pension Plan	nvarchar	4	0	CHAR	(N' ')	Yes	*	P01C_ANGRP	Allow NULL?
67	HAN05	Company Pension Scheme Entitlement	nvarchar	4	0	CHAR	(N' ')	Yes	T5DCA	P01C_HANSP	Allow NULL?
68	AAN05	Benefit Type of Company Pension Scheme	nvarchar	4	0	CHAR	(N' ')	Yes	T5DCA	P01C_AANSP	Allow NULL?
69	MBV05	Calculation Variant for Entitlement	nvarchar	2	0	CHAR	(N' ')	Yes	*	P01C_MODBV	Allow NULL?
70	LUR05	Company Responsible	nvarchar	4	0	CHAR	(N' ')	Yes	*	P01C_LURSP	Allow NULL?
71	NAR05	Not Payroll Relevant	char	1	0	CHAR	(N' ')	Yes		P01C_NAREL	Allow NULL?
72	LGA05	Wage Type	nvarchar	4	0	CHAR	(N' ')	Yes	*	P01C_LGART	Allow NULL?
73	BET05	Amount	decimal	8	2	CURR	((0))	Yes		P01C_BET72
74	APD05	Check Date for Next Adjustment	nvarchar	8	0	DATS	(N'00000000')	Yes		P01C_APDAT	Allow NULL?
75	LTR05	Benefits Provider	nvarchar	4	0	CHAR	(N' ')	Yes	*	P01C_LTRGR	Allow NULL?
76	ANG06	Pension Plan	nvarchar	4	0	CHAR	(N' ')	Yes	*	P01C_ANGRP	Allow NULL?
77	HAN06	Company Pension Scheme Entitlement	nvarchar	4	0	CHAR	(N' ')	Yes	T5DCA	P01C_HANSP	Allow NULL?
78	AAN06	Benefit Type of Company Pension Scheme	nvarchar	4	0	CHAR	(N' ')	Yes	T5DCA	P01C_AANSP	Allow NULL?
79	MBV06	Calculation Variant for Entitlement	nvarchar	2	0	CHAR	(N' ')	Yes	*	P01C_MODBV	Allow NULL?
80	LUR06	Company Responsible	nvarchar	4	0	CHAR	(N' ')	Yes	*	P01C_LURSP	Allow NULL?
81	NAR06	Not Payroll Relevant	char	1	0	CHAR	(N' ')	Yes		P01C_NAREL	Allow NULL?
82	LGA06	Wage Type	nvarchar	4	0	CHAR	(N' ')	Yes	*	P01C_LGART	Allow NULL?
83	BET06	Amount	decimal	8	2	CURR	((0))	Yes		P01C_BET72
84	APD06	Check Date for Next Adjustment	nvarchar	8	0	DATS	(N'00000000')	Yes		P01C_APDAT	Allow NULL?
85	LTR06	Benefits Provider	nvarchar	4	0	CHAR	(N' ')	Yes	*	P01C_LTRGR	Allow NULL?
86	ANG07	Pension Plan	nvarchar	4	0	CHAR	(N' ')	Yes	*	P01C_ANGRP	Allow NULL?
87	HAN07	Company Pension Scheme Entitlement	nvarchar	4	0	CHAR	(N' ')	Yes	T5DCA	P01C_HANSP	Allow NULL?
88	AAN07	Benefit Type of Company Pension Scheme	nvarchar	4	0	CHAR	(N' ')	Yes	T5DCA	P01C_AANSP	Allow NULL?
89	MBV07	Calculation Variant for Entitlement	nvarchar	2	0	CHAR	(N' ')	Yes	*	P01C_MODBV	Allow NULL?
90	LUR07	Company Responsible	nvarchar	4	0	CHAR	(N' ')	Yes	*	P01C_LURSP	Allow NULL?
91	NAR07	Not Payroll Relevant	char	1	0	CHAR	(N' ')	Yes		P01C_NAREL	Allow NULL?
92	LGA07	Wage Type	nvarchar	4	0	CHAR	(N' ')	Yes	*	P01C_LGART	Allow NULL?
93	BET07	Amount	decimal	8	2	CURR	((0))	Yes		P01C_BET72
94	APD07	Check Date for Next Adjustment	nvarchar	8	0	DATS	(N'00000000')	Yes		P01C_APDAT	Allow NULL?
95	LTR07	Benefits Provider	nvarchar	4	0	CHAR	(N' ')	Yes	*	P01C_LTRGR	Allow NULL?
96	ANG08	Pension Plan	nvarchar	4	0	CHAR	(N' ')	Yes	*	P01C_ANGRP	Allow NULL?
97	HAN08	Company Pension Scheme Entitlement	nvarchar	4	0	CHAR	(N' ')	Yes	T5DCA	P01C_HANSP	Allow NULL?
98	AAN08	Benefit Type of Company Pension Scheme	nvarchar	4	0	CHAR	(N' ')	Yes	T5DCA	P01C_AANSP	Allow NULL?
99	MBV08	Calculation Variant for Entitlement	nvarchar	2	0	CHAR	(N' ')	Yes	*	P01C_MODBV	Allow NULL?
100	LUR08	Company Responsible	nvarchar	4	0	CHAR	(N' ')	Yes	*	P01C_LURSP	Allow NULL?
101	NAR08	Not Payroll Relevant	char	1	0	CHAR	(N' ')	Yes		P01C_NAREL	Allow NULL?
102	LGA08	Wage Type	nvarchar	4	0	CHAR	(N' ')	Yes	*	P01C_LGART	Allow NULL?
103	BET08	Amount	decimal	8	2	CURR	((0))	Yes		P01C_BET72
104	APD08	Check Date for Next Adjustment	nvarchar	8	0	DATS	(N'00000000')	Yes		P01C_APDAT	Allow NULL?
105	LTR08	Benefits Provider	nvarchar	4	0	CHAR	(N' ')	Yes	*	P01C_LTRGR	Allow NULL?
106	ANG09	Pension Plan	nvarchar	4	0	CHAR	(N' ')	Yes	*	P01C_ANGRP	Allow NULL?
107	HAN09	Company Pension Scheme Entitlement	nvarchar	4	0	CHAR	(N' ')	Yes	T5DCA	P01C_HANSP	Allow NULL?
108	AAN09	Benefit Type of Company Pension Scheme	nvarchar	4	0	CHAR	(N' ')	Yes	T5DCA	P01C_AANSP	Allow NULL?
109	MBV09	Calculation Variant for Entitlement	nvarchar	2	0	CHAR	(N' ')	Yes	*	P01C_MODBV	Allow NULL?
110	LUR09	Company Responsible	nvarchar	4	0	CHAR	(N' ')	Yes	*	P01C_LURSP	Allow NULL?
111	NAR09	Not Payroll Relevant	char	1	0	CHAR	(N' ')	Yes		P01C_NAREL	Allow NULL?
112	LGA09	Wage Type	nvarchar	4	0	CHAR	(N' ')	Yes	*	P01C_LGART	Allow NULL?
113	BET09	Amount	decimal	8	2	CURR	((0))	Yes		P01C_BET72
114	APD09	Check Date for Next Adjustment	nvarchar	8	0	DATS	(N'00000000')	Yes		P01C_APDAT	Allow NULL?
115	LTR09	Benefits Provider	nvarchar	4	0	CHAR	(N' ')	Yes	*	P01C_LTRGR	Allow NULL?
116	ANG10	Pension Plan	nvarchar	4	0	CHAR	(N' ')	Yes	*	P01C_ANGRP	Allow NULL?
117	HAN10	Company Pension Scheme Entitlement	nvarchar	4	0	CHAR	(N' ')	Yes	T5DCA	P01C_HANSP	Allow NULL?
118	AAN10	Benefit Type of Company Pension Scheme	nvarchar	4	0	CHAR	(N' ')	Yes	T5DCA	P01C_AANSP	Allow NULL?
119	MBV10	Calculation Variant for Entitlement	nvarchar	2	0	CHAR	(N' ')	Yes	*	P01C_MODBV	Allow NULL?
120	LUR10	Company Responsible	nvarchar	4	0	CHAR	(N' ')	Yes	*	P01C_LURSP	Allow NULL?
121	NAR10	Not Payroll Relevant	char	1	0	CHAR	(N' ')	Yes		P01C_NAREL	Allow NULL?
122	LGA10	Wage Type	nvarchar	4	0	CHAR	(N' ')	Yes	*	P01C_LGART	Allow NULL?
123	BET10	Amount	decimal	8	2	CURR	((0))	Yes		P01C_BET72
124	APD10	Check Date for Next Adjustment	nvarchar	8	0	DATS	(N'00000000')	Yes		P01C_APDAT	Allow NULL?
125	LTR10	Benefits Provider	nvarchar	4	0	CHAR	(N' ')	Yes	*	P01C_LTRGR	Allow NULL?
126	ANG11	Pension Plan	nvarchar	4	0	CHAR	(N' ')	Yes	*	P01C_ANGRP	Allow NULL?
127	HAN11	Company Pension Scheme Entitlement	nvarchar	4	0	CHAR	(N' ')	Yes	T5DCA	P01C_HANSP	Allow NULL?
128	AAN11	Benefit Type of Company Pension Scheme	nvarchar	4	0	CHAR	(N' ')	Yes	T5DCA	P01C_AANSP	Allow NULL?
129	MBV11	Calculation Variant for Entitlement	nvarchar	2	0	CHAR	(N' ')	Yes	*	P01C_MODBV	Allow NULL?
130	LUR11	Company Responsible	nvarchar	4	0	CHAR	(N' ')	Yes	*	P01C_LURSP	Allow NULL?
131	NAR11	Not Payroll Relevant	char	1	0	CHAR	(N' ')	Yes		P01C_NAREL	Allow NULL?
132	LGA11	Wage Type	nvarchar	4	0	CHAR	(N' ')	Yes	*	P01C_LGART	Allow NULL?
133	BET11	Amount	decimal	8	2	CURR	((0))	Yes		P01C_BET72
134	APD11	Check Date for Next Adjustment	nvarchar	8	0	DATS	(N'00000000')	Yes		P01C_APDAT	Allow NULL?
135	LTR11	Benefits Provider	nvarchar	4	0	CHAR	(N' ')	Yes	*	P01C_LTRGR	Allow NULL?
136	ANG12	Pension Plan	nvarchar	4	0	CHAR	(N' ')	Yes	*	P01C_ANGRP	Allow NULL?
137	HAN12	Company Pension Scheme Entitlement	nvarchar	4	0	CHAR	(N' ')	Yes	T5DCA	P01C_HANSP	Allow NULL?
138	AAN12	Benefit Type of Company Pension Scheme	nvarchar	4	0	CHAR	(N' ')	Yes	T5DCA	P01C_AANSP	Allow NULL?
139	MBV12	Calculation Variant for Entitlement	nvarchar	2	0	CHAR	(N' ')	Yes	*	P01C_MODBV	Allow NULL?
140	LUR12	Company Responsible	nvarchar	4	0	CHAR	(N' ')	Yes	*	P01C_LURSP	Allow NULL?
141	NAR12	Not Payroll Relevant	char	1	0	CHAR	(N' ')	Yes		P01C_NAREL	Allow NULL?
142	LGA12	Wage Type	nvarchar	4	0	CHAR	(N' ')	Yes	*	P01C_LGART	Allow NULL?
143	BET12	Amount	decimal	8	2	CURR	((0))	Yes		P01C_BET72
144	APD12	Check Date for Next Adjustment	nvarchar	8	0	DATS	(N'00000000')	Yes		P01C_APDAT	Allow NULL?
145	LTR12	Benefits Provider	nvarchar	4	0	CHAR	(N' ')	Yes	*	P01C_LTRGR	Allow NULL?
146	ANG13	Pension Plan	nvarchar	4	0	CHAR	(N' ')	Yes	*	P01C_ANGRP	Allow NULL?
147	HAN13	Company Pension Scheme Entitlement	nvarchar	4	0	CHAR	(N' ')	Yes	T5DCA	P01C_HANSP	Allow NULL?
148	AAN13	Benefit Type of Company Pension Scheme	nvarchar	4	0	CHAR	(N' ')	Yes	T5DCA	P01C_AANSP	Allow NULL?
149	MBV13	Calculation Variant for Entitlement	nvarchar	2	0	CHAR	(N' ')	Yes	*	P01C_MODBV	Allow NULL?
150	LUR13	Company Responsible	nvarchar	4	0	CHAR	(N' ')	Yes	*	P01C_LURSP	Allow NULL?
151	NAR13	Not Payroll Relevant	char	1	0	CHAR	(N' ')	Yes		P01C_NAREL	Allow NULL?
152	LGA13	Wage Type	nvarchar	4	0	CHAR	(N' ')	Yes	*	P01C_LGART	Allow NULL?
153	BET13	Amount	decimal	8	2	CURR	((0))	Yes		P01C_BET72
154	APD13	Check Date for Next Adjustment	nvarchar	8	0	DATS	(N'00000000')	Yes		P01C_APDAT	Allow NULL?
155	LTR13	Benefits Provider	nvarchar	4	0	CHAR	(N' ')	Yes	*	P01C_LTRGR	Allow NULL?
156	ANG14	Pension Plan	nvarchar	4	0	CHAR	(N' ')	Yes	*	P01C_ANGRP	Allow NULL?
157	HAN14	Company Pension Scheme Entitlement	nvarchar	4	0	CHAR	(N' ')	Yes	T5DCA	P01C_HANSP	Allow NULL?
158	AAN14	Benefit Type of Company Pension Scheme	nvarchar	4	0	CHAR	(N' ')	Yes	T5DCA	P01C_AANSP	Allow NULL?
159	MBV14	Calculation Variant for Entitlement	nvarchar	2	0	CHAR	(N' ')	Yes	*	P01C_MODBV	Allow NULL?
160	LUR14	Company Responsible	nvarchar	4	0	CHAR	(N' ')	Yes	*	P01C_LURSP	Allow NULL?
161	NAR14	Not Payroll Relevant	char	1	0	CHAR	(N' ')	Yes		P01C_NAREL	Allow NULL?
162	LGA14	Wage Type	nvarchar	4	0	CHAR	(N' ')	Yes	*	P01C_LGART	Allow NULL?
163	BET14	Amount	decimal	8	2	CURR	((0))	Yes		P01C_BET72
164	APD14	Check Date for Next Adjustment	nvarchar	8	0	DATS	(N'00000000')	Yes		P01C_APDAT	Allow NULL?
165	LTR14	Benefits Provider	nvarchar	4	0	CHAR	(N' ')	Yes	*	P01C_LTRGR	Allow NULL?
166	ANG15	Pension Plan	nvarchar	4	0	CHAR	(N' ')	Yes	*	P01C_ANGRP	Allow NULL?
167	HAN15	Company Pension Scheme Entitlement	nvarchar	4	0	CHAR	(N' ')	Yes	T5DCA	P01C_HANSP	Allow NULL?
168	AAN15	Benefit Type of Company Pension Scheme	nvarchar	4	0	CHAR	(N' ')	Yes	T5DCA	P01C_AANSP	Allow NULL?
169	MBV15	Calculation Variant for Entitlement	nvarchar	2	0	CHAR	(N' ')	Yes	*	P01C_MODBV	Allow NULL?
170	LUR15	Company Responsible	nvarchar	4	0	CHAR	(N' ')	Yes	*	P01C_LURSP	Allow NULL?
171	NAR15	Not Payroll Relevant	char	1	0	CHAR	(N' ')	Yes		P01C_NAREL	Allow NULL?
172	LGA15	Wage Type	nvarchar	4	0	CHAR	(N' ')	Yes	*	P01C_LGART	Allow NULL?
173	BET15	Amount	decimal	8	2	CURR	((0))	Yes		P01C_BET72
174	APD15	Check Date for Next Adjustment	nvarchar	8	0	DATS	(N'00000000')	Yes		P01C_APDAT	Allow NULL?
175	LTR15	Benefits Provider	nvarchar	4	0	CHAR	(N' ')	Yes	*	P01C_LTRGR	Allow NULL?
176	ANG16	Pension Plan	nvarchar	4	0	CHAR	(N' ')	Yes	*	P01C_ANGRP	Allow NULL?
177	HAN16	Company Pension Scheme Entitlement	nvarchar	4	0	CHAR	(N' ')	Yes	T5DCA	P01C_HANSP	Allow NULL?
178	AAN16	Benefit Type of Company Pension Scheme	nvarchar	4	0	CHAR	(N' ')	Yes	T5DCA	P01C_AANSP	Allow NULL?
179	MBV16	Calculation Variant for Entitlement	nvarchar	2	0	CHAR	(N' ')	Yes	*	P01C_MODBV	Allow NULL?
180	LUR16	Company Responsible	nvarchar	4	0	CHAR	(N' ')	Yes	*	P01C_LURSP	Allow NULL?
181	NAR16	Not Payroll Relevant	char	1	0	CHAR	(N' ')	Yes		P01C_NAREL	Allow NULL?
182	LGA16	Wage Type	nvarchar	4	0	CHAR	(N' ')	Yes	*	P01C_LGART	Allow NULL?
183	BET16	Amount	decimal	8	2	CURR	((0))	Yes		P01C_BET72
184	APD16	Check Date for Next Adjustment	nvarchar	8	0	DATS	(N'00000000')	Yes		P01C_APDAT	Allow NULL?
185	LTR16	Benefits Provider	nvarchar	4	0	CHAR	(N' ')	Yes	*	P01C_LTRGR	Allow NULL?
186	ANG17	Pension Plan	nvarchar	4	0	CHAR	(N' ')	Yes	*	P01C_ANGRP	Allow NULL?
187	HAN17	Company Pension Scheme Entitlement	nvarchar	4	0	CHAR	(N' ')	Yes	T5DCA	P01C_HANSP	Allow NULL?
188	AAN17	Benefit Type of Company Pension Scheme	nvarchar	4	0	CHAR	(N' ')	Yes	T5DCA	P01C_AANSP	Allow NULL?
189	MBV17	Calculation Variant for Entitlement	nvarchar	2	0	CHAR	(N' ')	Yes	*	P01C_MODBV	Allow NULL?
190	LUR17	Company Responsible	nvarchar	4	0	CHAR	(N' ')	Yes	*	P01C_LURSP	Allow NULL?
191	NAR17	Not Payroll Relevant	char	1	0	CHAR	(N' ')	Yes		P01C_NAREL	Allow NULL?
192	LGA17	Wage Type	nvarchar	4	0	CHAR	(N' ')	Yes	*	P01C_LGART	Allow NULL?
193	BET17	Amount	decimal	8	2	CURR	((0))	Yes		P01C_BET72
194	APD17	Check Date for Next Adjustment	nvarchar	8	0	DATS	(N'00000000')	Yes		P01C_APDAT	Allow NULL?
195	LTR17	Benefits Provider	nvarchar	4	0	CHAR	(N' ')	Yes	*	P01C_LTRGR	Allow NULL?
196	ANG18	Pension Plan	nvarchar	4	0	CHAR	(N' ')	Yes	*	P01C_ANGRP	Allow NULL?
197	HAN18	Company Pension Scheme Entitlement	nvarchar	4	0	CHAR	(N' ')	Yes	T5DCA	P01C_HANSP	Allow NULL?
198	AAN18	Benefit Type of Company Pension Scheme	nvarchar	4	0	CHAR	(N' ')	Yes	T5DCA	P01C_AANSP	Allow NULL?
199	MBV18	Calculation Variant for Entitlement	nvarchar	2	0	CHAR	(N' ')	Yes	*	P01C_MODBV	Allow NULL?
200	LUR18	Company Responsible	nvarchar	4	0	CHAR	(N' ')	Yes	*	P01C_LURSP	Allow NULL?
201	NAR18	Not Payroll Relevant	char	1	0	CHAR	(N' ')	Yes		P01C_NAREL	Allow NULL?
202	LGA18	Wage Type	nvarchar	4	0	CHAR	(N' ')	Yes	*	P01C_LGART	Allow NULL?
203	BET18	Amount	decimal	8	2	CURR	((0))	Yes		P01C_BET72
204	APD18	Check Date for Next Adjustment	nvarchar	8	0	DATS	(N'00000000')	Yes		P01C_APDAT	Allow NULL?
205	LTR18	Benefits Provider	nvarchar	4	0	CHAR	(N' ')	Yes	*	P01C_LTRGR	Allow NULL?
206	LFD01	Identification Number	nvarchar	2	0	NUMC	(N'00')	Yes		P01C_LFDNR	Allow NULL?
207	LFD02	Identification Number	nvarchar	2	0	NUMC	(N'00')	Yes		P01C_LFDNR	Allow NULL?
208	LFD03	Identification Number	nvarchar	2	0	NUMC	(N'00')	Yes		P01C_LFDNR	Allow NULL?
209	LFD04	Identification Number	nvarchar	2	0	NUMC	(N'00')	Yes		P01C_LFDNR	Allow NULL?
210	LFD05	Identification Number	nvarchar	2	0	NUMC	(N'00')	Yes		P01C_LFDNR	Allow NULL?
211	LFD06	Identification Number	nvarchar	2	0	NUMC	(N'00')	Yes		P01C_LFDNR	Allow NULL?
212	LFD07	Identification Number	nvarchar	2	0	NUMC	(N'00')	Yes		P01C_LFDNR	Allow NULL?
213	LFD08	Identification Number	nvarchar	2	0	NUMC	(N'00')	Yes		P01C_LFDNR	Allow NULL?
214	LFD09	Identification Number	nvarchar	2	0	NUMC	(N'00')	Yes		P01C_LFDNR	Allow NULL?
215	LFD10	Identification Number	nvarchar	2	0	NUMC	(N'00')	Yes		P01C_LFDNR	Allow NULL?
216	LFD11	Identification Number	nvarchar	2	0	NUMC	(N'00')	Yes		P01C_LFDNR	Allow NULL?
217	LFD12	Identification Number	nvarchar	2	0	NUMC	(N'00')	Yes		P01C_LFDNR	Allow NULL?
218	LFD13	Identification Number	nvarchar	2	0	NUMC	(N'00')	Yes		P01C_LFDNR	Allow NULL?
219	LFD14	Identification Number	nvarchar	2	0	NUMC	(N'00')	Yes		P01C_LFDNR	Allow NULL?
220	LFD15	Identification Number	nvarchar	2	0	NUMC	(N'00')	Yes		P01C_LFDNR	Allow NULL?
221	LFD16	Identification Number	nvarchar	2	0	NUMC	(N'00')	Yes		P01C_LFDNR	Allow NULL?
222	LFD17	Identification Number	nvarchar	2	0	NUMC	(N'00')	Yes		P01C_LFDNR	Allow NULL?
223	LFD18	Identification Number	nvarchar	2	0	NUMC	(N'00')	Yes		P01C_LFDNR	Allow NULL?

TOP ERP 6.0 | PA0201 INDEXES

Name	Primary	Unique	Type	Columns
PA0201~0	Yes	Yes	CLUSTERED	SEQNR, BEGDA, ENDDA, SPRPS, OBJPS, SUBTY, PERNR, MANDT

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

223 COLUMNS | 1 INDEXES | ERP 6.0 | PA0201 TABLE

TOP ERP 6.0 | PA0201 COLUMNS

TOP ERP 6.0 | PA0201 INDEXES

SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

SAP TABLESv1

ERP 6.0: Top 10 requests

B1 9.2: Top 10 requests

B1 8.8: Top 10 requests

223 COLUMNS | 1 INDEXES | ERP 6.0 | PA0201 TABLE

TOPERP 6.0 | PA0201 COLUMNS

TOPERP 6.0 | PA0201 INDEXES

TOP ERP 6.0 | PA0201 COLUMNS

TOP ERP 6.0 | PA0201 INDEXES