	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

208 COLUMNS | 1 INDEXES | ERP 6.0 | PA0441 TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Personnel Management :: Personnel Administration
1	ERP EHP7	6.0	PA0441	208	1	Corrections for reports (Hungary)	Personnel Administration

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, TIPUS, ERVNY, WAERS, ZEINH, LGT01, NUM01, AMT01, BEG01, END01, FL101, FL201, FL301, FL401, FL501, LGT02, NUM02, AMT02, BEG02, END02, FL102, FL202, FL302, FL402, FL502, LGT03, NUM03, AMT03, BEG03, END03, FL103, FL203, FL303, FL403, FL503, LGT04, NUM04, AMT04, BEG04, END04, FL104, FL204, FL304, FL404, FL504, LGT05, NUM05, AMT05, BEG05, END05, FL105, FL205, FL305, FL405, FL505, LGT06, NUM06, AMT06, BEG06, END06, FL106, FL206, FL306, FL406, FL506, LGT07, NUM07, AMT07, BEG07, END07, FL107, FL207, FL307, FL407, FL507, LGT08, NUM08, AMT08, BEG08, END08, FL108, FL208, FL308, FL408, FL508, LGT09, NUM09, AMT09, BEG09, END09, FL109, FL209, FL309, FL409, FL509, LGT10, NUM10, AMT10, BEG10, END10, FL110, FL210, FL310, FL410, FL510, LGT11, NUM11, AMT11, BEG11, END11, FL111, FL211, FL311, FL411, FL511, LGT12, NUM12, AMT12, BEG12, END12, FL112, FL212, FL312, FL412, FL512, LGT13, NUM13, AMT13, BEG13, END13, FL113, FL213, FL313, FL413, FL513, LGT14, NUM14, AMT14, BEG14, END14, FL114, FL214, FL314, FL414, FL514, LGT15, NUM15, AMT15, BEG15, END15, FL115, FL215, FL315, FL415, FL515, STR01, STR02, STR03, STR04, STR05, STR06, STR07, STR08, STR09, STR10, STR11, STR12, STR13, STR14, STR15, TVK01, TVK02, TVK03, TVK04, TVK05, TVK06, TVK07, TVK08, TVK09, TVK10, TVK11, TVK12, TVK13, TVK14, TVK15, HATAR FROM PA0441

TOP ERP 6.0 | PA0441 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	*	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	TIPUS	Subtype	nvarchar	4	0	CHAR	(N' ')	Yes		SUBTY	Allow NULL?
25	ERVNY	End Date	nvarchar	8	0	DATS	(N'00000000')	Yes		ENDDA	Allow NULL?
26	WAERS	Currency Key	nvarchar	5	0	CUKY	(N' ')	Yes	TCURC	WAERS	Allow NULL?
27	ZEINH	Time/Measurement Unit	nvarchar	3	0	CHAR	(N' ')	Yes	T538A	PT_ZEINH	Allow NULL?
28	LGT01	HR-H: serial number field for infotype P0041	nvarchar	2	0	CHAR	(N' ')	Yes	*	P21_SORS2	Allow NULL?
29	NUM01	Number	decimal	7	2	DEC	((0))	Yes		ANZHL
30	AMT01	Amount	decimal	9	2	CURR	((0))	Yes		BETRG
31	BEG01	Date	nvarchar	8	0	DATS	(N'00000000')	Yes		DATUM	Allow NULL?
32	END01	Date	nvarchar	8	0	DATS	(N'00000000')	Yes		DATUM	Allow NULL?
33	FL101	HR-H: one character flag to infotype 0441	char	1	0	CHAR	(N' ')	Yes		P21_FLAG1	Allow NULL?
34	FL201	HR-H: one character flag to infotype 0441	char	1	0	CHAR	(N' ')	Yes		P21_FLAG1	Allow NULL?
35	FL301	HR-H: one character flag to infotype 0441	char	1	0	CHAR	(N' ')	Yes		P21_FLAG1	Allow NULL?
36	FL401	HR-H: one character flag to infotype 0441	char	1	0	CHAR	(N' ')	Yes		P21_FLAG1	Allow NULL?
37	FL501	HR-H: one character flag to infotype 0441	char	1	0	CHAR	(N' ')	Yes		P21_FLAG1	Allow NULL?
38	LGT02	HR-H: serial number field for infotype P0041	nvarchar	2	0	CHAR	(N' ')	Yes	*	P21_SORS2	Allow NULL?
39	NUM02	Number	decimal	7	2	DEC	((0))	Yes		ANZHL
40	AMT02	Amount	decimal	9	2	CURR	((0))	Yes		BETRG
41	BEG02	Date	nvarchar	8	0	DATS	(N'00000000')	Yes		DATUM	Allow NULL?
42	END02	Date	nvarchar	8	0	DATS	(N'00000000')	Yes		DATUM	Allow NULL?
43	FL102	HR-H: one character flag to infotype 0441	char	1	0	CHAR	(N' ')	Yes		P21_FLAG1	Allow NULL?
44	FL202	HR-H: one character flag to infotype 0441	char	1	0	CHAR	(N' ')	Yes		P21_FLAG1	Allow NULL?
45	FL302	HR-H: one character flag to infotype 0441	char	1	0	CHAR	(N' ')	Yes		P21_FLAG1	Allow NULL?
46	FL402	HR-H: one character flag to infotype 0441	char	1	0	CHAR	(N' ')	Yes		P21_FLAG1	Allow NULL?
47	FL502	HR-H: one character flag to infotype 0441	char	1	0	CHAR	(N' ')	Yes		P21_FLAG1	Allow NULL?
48	LGT03	HR-H: serial number field for infotype P0041	nvarchar	2	0	CHAR	(N' ')	Yes	*	P21_SORS2	Allow NULL?
49	NUM03	Number	decimal	7	2	DEC	((0))	Yes		ANZHL
50	AMT03	Amount	decimal	9	2	CURR	((0))	Yes		BETRG
51	BEG03	Date	nvarchar	8	0	DATS	(N'00000000')	Yes		DATUM	Allow NULL?
52	END03	Date	nvarchar	8	0	DATS	(N'00000000')	Yes		DATUM	Allow NULL?
53	FL103	HR-H: one character flag to infotype 0441	char	1	0	CHAR	(N' ')	Yes		P21_FLAG1	Allow NULL?
54	FL203	HR-H: one character flag to infotype 0441	char	1	0	CHAR	(N' ')	Yes		P21_FLAG1	Allow NULL?
55	FL303	HR-H: one character flag to infotype 0441	char	1	0	CHAR	(N' ')	Yes		P21_FLAG1	Allow NULL?
56	FL403	HR-H: one character flag to infotype 0441	char	1	0	CHAR	(N' ')	Yes		P21_FLAG1	Allow NULL?
57	FL503	HR-H: one character flag to infotype 0441	char	1	0	CHAR	(N' ')	Yes		P21_FLAG1	Allow NULL?
58	LGT04	HR-H: serial number field for infotype P0041	nvarchar	2	0	CHAR	(N' ')	Yes	*	P21_SORS2	Allow NULL?
59	NUM04	Number	decimal	7	2	DEC	((0))	Yes		ANZHL
60	AMT04	Amount	decimal	9	2	CURR	((0))	Yes		BETRG
61	BEG04	Date	nvarchar	8	0	DATS	(N'00000000')	Yes		DATUM	Allow NULL?
62	END04	Date	nvarchar	8	0	DATS	(N'00000000')	Yes		DATUM	Allow NULL?
63	FL104	HR-H: one character flag to infotype 0441	char	1	0	CHAR	(N' ')	Yes		P21_FLAG1	Allow NULL?
64	FL204	HR-H: one character flag to infotype 0441	char	1	0	CHAR	(N' ')	Yes		P21_FLAG1	Allow NULL?
65	FL304	HR-H: one character flag to infotype 0441	char	1	0	CHAR	(N' ')	Yes		P21_FLAG1	Allow NULL?
66	FL404	HR-H: one character flag to infotype 0441	char	1	0	CHAR	(N' ')	Yes		P21_FLAG1	Allow NULL?
67	FL504	HR-H: one character flag to infotype 0441	char	1	0	CHAR	(N' ')	Yes		P21_FLAG1	Allow NULL?
68	LGT05	HR-H: serial number field for infotype P0041	nvarchar	2	0	CHAR	(N' ')	Yes	*	P21_SORS2	Allow NULL?
69	NUM05	Number	decimal	7	2	DEC	((0))	Yes		ANZHL
70	AMT05	Amount	decimal	9	2	CURR	((0))	Yes		BETRG
71	BEG05	Date	nvarchar	8	0	DATS	(N'00000000')	Yes		DATUM	Allow NULL?
72	END05	Date	nvarchar	8	0	DATS	(N'00000000')	Yes		DATUM	Allow NULL?
73	FL105	HR-H: one character flag to infotype 0441	char	1	0	CHAR	(N' ')	Yes		P21_FLAG1	Allow NULL?
74	FL205	HR-H: one character flag to infotype 0441	char	1	0	CHAR	(N' ')	Yes		P21_FLAG1	Allow NULL?
75	FL305	HR-H: one character flag to infotype 0441	char	1	0	CHAR	(N' ')	Yes		P21_FLAG1	Allow NULL?
76	FL405	HR-H: one character flag to infotype 0441	char	1	0	CHAR	(N' ')	Yes		P21_FLAG1	Allow NULL?
77	FL505	HR-H: one character flag to infotype 0441	char	1	0	CHAR	(N' ')	Yes		P21_FLAG1	Allow NULL?
78	LGT06	HR-H: serial number field for infotype P0041	nvarchar	2	0	CHAR	(N' ')	Yes	*	P21_SORS2	Allow NULL?
79	NUM06	Number	decimal	7	2	DEC	((0))	Yes		ANZHL
80	AMT06	Amount	decimal	9	2	CURR	((0))	Yes		BETRG
81	BEG06	Date	nvarchar	8	0	DATS	(N'00000000')	Yes		DATUM	Allow NULL?
82	END06	Date	nvarchar	8	0	DATS	(N'00000000')	Yes		DATUM	Allow NULL?
83	FL106	HR-H: one character flag to infotype 0441	char	1	0	CHAR	(N' ')	Yes		P21_FLAG1	Allow NULL?
84	FL206	HR-H: one character flag to infotype 0441	char	1	0	CHAR	(N' ')	Yes		P21_FLAG1	Allow NULL?
85	FL306	HR-H: one character flag to infotype 0441	char	1	0	CHAR	(N' ')	Yes		P21_FLAG1	Allow NULL?
86	FL406	HR-H: one character flag to infotype 0441	char	1	0	CHAR	(N' ')	Yes		P21_FLAG1	Allow NULL?
87	FL506	HR-H: one character flag to infotype 0441	char	1	0	CHAR	(N' ')	Yes		P21_FLAG1	Allow NULL?
88	LGT07	HR-H: serial number field for infotype P0041	nvarchar	2	0	CHAR	(N' ')	Yes	*	P21_SORS2	Allow NULL?
89	NUM07	Number	decimal	7	2	DEC	((0))	Yes		ANZHL
90	AMT07	Amount	decimal	9	2	CURR	((0))	Yes		BETRG
91	BEG07	Date	nvarchar	8	0	DATS	(N'00000000')	Yes		DATUM	Allow NULL?
92	END07	Date	nvarchar	8	0	DATS	(N'00000000')	Yes		DATUM	Allow NULL?
93	FL107	HR-H: one character flag to infotype 0441	char	1	0	CHAR	(N' ')	Yes		P21_FLAG1	Allow NULL?
94	FL207	HR-H: one character flag to infotype 0441	char	1	0	CHAR	(N' ')	Yes		P21_FLAG1	Allow NULL?
95	FL307	HR-H: one character flag to infotype 0441	char	1	0	CHAR	(N' ')	Yes		P21_FLAG1	Allow NULL?
96	FL407	HR-H: one character flag to infotype 0441	char	1	0	CHAR	(N' ')	Yes		P21_FLAG1	Allow NULL?
97	FL507	HR-H: one character flag to infotype 0441	char	1	0	CHAR	(N' ')	Yes		P21_FLAG1	Allow NULL?
98	LGT08	HR-H: serial number field for infotype P0041	nvarchar	2	0	CHAR	(N' ')	Yes	*	P21_SORS2	Allow NULL?
99	NUM08	Number	decimal	7	2	DEC	((0))	Yes		ANZHL
100	AMT08	Amount	decimal	9	2	CURR	((0))	Yes		BETRG
101	BEG08	Date	nvarchar	8	0	DATS	(N'00000000')	Yes		DATUM	Allow NULL?
102	END08	Date	nvarchar	8	0	DATS	(N'00000000')	Yes		DATUM	Allow NULL?
103	FL108	HR-H: one character flag to infotype 0441	char	1	0	CHAR	(N' ')	Yes		P21_FLAG1	Allow NULL?
104	FL208	HR-H: one character flag to infotype 0441	char	1	0	CHAR	(N' ')	Yes		P21_FLAG1	Allow NULL?
105	FL308	HR-H: one character flag to infotype 0441	char	1	0	CHAR	(N' ')	Yes		P21_FLAG1	Allow NULL?
106	FL408	HR-H: one character flag to infotype 0441	char	1	0	CHAR	(N' ')	Yes		P21_FLAG1	Allow NULL?
107	FL508	HR-H: one character flag to infotype 0441	char	1	0	CHAR	(N' ')	Yes		P21_FLAG1	Allow NULL?
108	LGT09	HR-H: serial number field for infotype P0041	nvarchar	2	0	CHAR	(N' ')	Yes	*	P21_SORS2	Allow NULL?
109	NUM09	Number	decimal	7	2	DEC	((0))	Yes		ANZHL
110	AMT09	Amount	decimal	9	2	CURR	((0))	Yes		BETRG
111	BEG09	Date	nvarchar	8	0	DATS	(N'00000000')	Yes		DATUM	Allow NULL?
112	END09	Date	nvarchar	8	0	DATS	(N'00000000')	Yes		DATUM	Allow NULL?
113	FL109	HR-H: one character flag to infotype 0441	char	1	0	CHAR	(N' ')	Yes		P21_FLAG1	Allow NULL?
114	FL209	HR-H: one character flag to infotype 0441	char	1	0	CHAR	(N' ')	Yes		P21_FLAG1	Allow NULL?
115	FL309	HR-H: one character flag to infotype 0441	char	1	0	CHAR	(N' ')	Yes		P21_FLAG1	Allow NULL?
116	FL409	HR-H: one character flag to infotype 0441	char	1	0	CHAR	(N' ')	Yes		P21_FLAG1	Allow NULL?
117	FL509	HR-H: one character flag to infotype 0441	char	1	0	CHAR	(N' ')	Yes		P21_FLAG1	Allow NULL?
118	LGT10	HR-H: serial number field for infotype P0041	nvarchar	2	0	CHAR	(N' ')	Yes	*	P21_SORS2	Allow NULL?
119	NUM10	Number	decimal	7	2	DEC	((0))	Yes		ANZHL
120	AMT10	Amount	decimal	9	2	CURR	((0))	Yes		BETRG
121	BEG10	Date	nvarchar	8	0	DATS	(N'00000000')	Yes		DATUM	Allow NULL?
122	END10	Date	nvarchar	8	0	DATS	(N'00000000')	Yes		DATUM	Allow NULL?
123	FL110	HR-H: one character flag to infotype 0441	char	1	0	CHAR	(N' ')	Yes		P21_FLAG1	Allow NULL?
124	FL210	HR-H: one character flag to infotype 0441	char	1	0	CHAR	(N' ')	Yes		P21_FLAG1	Allow NULL?
125	FL310	HR-H: one character flag to infotype 0441	char	1	0	CHAR	(N' ')	Yes		P21_FLAG1	Allow NULL?
126	FL410	HR-H: one character flag to infotype 0441	char	1	0	CHAR	(N' ')	Yes		P21_FLAG1	Allow NULL?
127	FL510	HR-H: one character flag to infotype 0441	char	1	0	CHAR	(N' ')	Yes		P21_FLAG1	Allow NULL?
128	LGT11	HR-H: serial number field for infotype P0041	nvarchar	2	0	CHAR	(N' ')	Yes	*	P21_SORS2	Allow NULL?
129	NUM11	Number	decimal	7	2	DEC	((0))	Yes		ANZHL
130	AMT11	Amount	decimal	9	2	CURR	((0))	Yes		BETRG
131	BEG11	Date	nvarchar	8	0	DATS	(N'00000000')	Yes		DATUM	Allow NULL?
132	END11	Date	nvarchar	8	0	DATS	(N'00000000')	Yes		DATUM	Allow NULL?
133	FL111	HR-H: one character flag to infotype 0441	char	1	0	CHAR	(N' ')	Yes		P21_FLAG1	Allow NULL?
134	FL211	HR-H: one character flag to infotype 0441	char	1	0	CHAR	(N' ')	Yes		P21_FLAG1	Allow NULL?
135	FL311	HR-H: one character flag to infotype 0441	char	1	0	CHAR	(N' ')	Yes		P21_FLAG1	Allow NULL?
136	FL411	HR-H: one character flag to infotype 0441	char	1	0	CHAR	(N' ')	Yes		P21_FLAG1	Allow NULL?
137	FL511	HR-H: one character flag to infotype 0441	char	1	0	CHAR	(N' ')	Yes		P21_FLAG1	Allow NULL?
138	LGT12	HR-H: serial number field for infotype P0041	nvarchar	2	0	CHAR	(N' ')	Yes	*	P21_SORS2	Allow NULL?
139	NUM12	Number	decimal	7	2	DEC	((0))	Yes		ANZHL
140	AMT12	Amount	decimal	9	2	CURR	((0))	Yes		BETRG
141	BEG12	Date	nvarchar	8	0	DATS	(N'00000000')	Yes		DATUM	Allow NULL?
142	END12	Date	nvarchar	8	0	DATS	(N'00000000')	Yes		DATUM	Allow NULL?
143	FL112	HR-H: one character flag to infotype 0441	char	1	0	CHAR	(N' ')	Yes		P21_FLAG1	Allow NULL?
144	FL212	HR-H: one character flag to infotype 0441	char	1	0	CHAR	(N' ')	Yes		P21_FLAG1	Allow NULL?
145	FL312	HR-H: one character flag to infotype 0441	char	1	0	CHAR	(N' ')	Yes		P21_FLAG1	Allow NULL?
146	FL412	HR-H: one character flag to infotype 0441	char	1	0	CHAR	(N' ')	Yes		P21_FLAG1	Allow NULL?
147	FL512	HR-H: one character flag to infotype 0441	char	1	0	CHAR	(N' ')	Yes		P21_FLAG1	Allow NULL?
148	LGT13	HR-H: serial number field for infotype P0041	nvarchar	2	0	CHAR	(N' ')	Yes	*	P21_SORS2	Allow NULL?
149	NUM13	Number	decimal	7	2	DEC	((0))	Yes		ANZHL
150	AMT13	Amount	decimal	9	2	CURR	((0))	Yes		BETRG
151	BEG13	Date	nvarchar	8	0	DATS	(N'00000000')	Yes		DATUM	Allow NULL?
152	END13	Date	nvarchar	8	0	DATS	(N'00000000')	Yes		DATUM	Allow NULL?
153	FL113	HR-H: one character flag to infotype 0441	char	1	0	CHAR	(N' ')	Yes		P21_FLAG1	Allow NULL?
154	FL213	HR-H: one character flag to infotype 0441	char	1	0	CHAR	(N' ')	Yes		P21_FLAG1	Allow NULL?
155	FL313	HR-H: one character flag to infotype 0441	char	1	0	CHAR	(N' ')	Yes		P21_FLAG1	Allow NULL?
156	FL413	HR-H: one character flag to infotype 0441	char	1	0	CHAR	(N' ')	Yes		P21_FLAG1	Allow NULL?
157	FL513	HR-H: one character flag to infotype 0441	char	1	0	CHAR	(N' ')	Yes		P21_FLAG1	Allow NULL?
158	LGT14	HR-H: serial number field for infotype P0041	nvarchar	2	0	CHAR	(N' ')	Yes	*	P21_SORS2	Allow NULL?
159	NUM14	Number	decimal	7	2	DEC	((0))	Yes		ANZHL
160	AMT14	Amount	decimal	9	2	CURR	((0))	Yes		BETRG
161	BEG14	Date	nvarchar	8	0	DATS	(N'00000000')	Yes		DATUM	Allow NULL?
162	END14	Date	nvarchar	8	0	DATS	(N'00000000')	Yes		DATUM	Allow NULL?
163	FL114	HR-H: one character flag to infotype 0441	char	1	0	CHAR	(N' ')	Yes		P21_FLAG1	Allow NULL?
164	FL214	HR-H: one character flag to infotype 0441	char	1	0	CHAR	(N' ')	Yes		P21_FLAG1	Allow NULL?
165	FL314	HR-H: one character flag to infotype 0441	char	1	0	CHAR	(N' ')	Yes		P21_FLAG1	Allow NULL?
166	FL414	HR-H: one character flag to infotype 0441	char	1	0	CHAR	(N' ')	Yes		P21_FLAG1	Allow NULL?
167	FL514	HR-H: one character flag to infotype 0441	char	1	0	CHAR	(N' ')	Yes		P21_FLAG1	Allow NULL?
168	LGT15	HR-H: serial number field for infotype P0041	nvarchar	2	0	CHAR	(N' ')	Yes	*	P21_SORS2	Allow NULL?
169	NUM15	Number	decimal	7	2	DEC	((0))	Yes		ANZHL
170	AMT15	Amount	decimal	9	2	CURR	((0))	Yes		BETRG
171	BEG15	Date	nvarchar	8	0	DATS	(N'00000000')	Yes		DATUM	Allow NULL?
172	END15	Date	nvarchar	8	0	DATS	(N'00000000')	Yes		DATUM	Allow NULL?
173	FL115	HR-H: one character flag to infotype 0441	char	1	0	CHAR	(N' ')	Yes		P21_FLAG1	Allow NULL?
174	FL215	HR-H: one character flag to infotype 0441	char	1	0	CHAR	(N' ')	Yes		P21_FLAG1	Allow NULL?
175	FL315	HR-H: one character flag to infotype 0441	char	1	0	CHAR	(N' ')	Yes		P21_FLAG1	Allow NULL?
176	FL415	HR-H: one character flag to infotype 0441	char	1	0	CHAR	(N' ')	Yes		P21_FLAG1	Allow NULL?
177	FL515	HR-H: one character flag to infotype 0441	char	1	0	CHAR	(N' ')	Yes		P21_FLAG1	Allow NULL?
178	STR01	HR-H: one character flag to infotype 0441	char	1	0	CHAR	(N' ')	Yes		P21_FLAG1	Allow NULL?
179	STR02	HR-H: one character flag to infotype 0441	char	1	0	CHAR	(N' ')	Yes		P21_FLAG1	Allow NULL?
180	STR03	HR-H: one character flag to infotype 0441	char	1	0	CHAR	(N' ')	Yes		P21_FLAG1	Allow NULL?
181	STR04	HR-H: one character flag to infotype 0441	char	1	0	CHAR	(N' ')	Yes		P21_FLAG1	Allow NULL?
182	STR05	HR-H: one character flag to infotype 0441	char	1	0	CHAR	(N' ')	Yes		P21_FLAG1	Allow NULL?
183	STR06	HR-H: one character flag to infotype 0441	char	1	0	CHAR	(N' ')	Yes		P21_FLAG1	Allow NULL?
184	STR07	HR-H: one character flag to infotype 0441	char	1	0	CHAR	(N' ')	Yes		P21_FLAG1	Allow NULL?
185	STR08	HR-H: one character flag to infotype 0441	char	1	0	CHAR	(N' ')	Yes		P21_FLAG1	Allow NULL?
186	STR09	HR-H: one character flag to infotype 0441	char	1	0	CHAR	(N' ')	Yes		P21_FLAG1	Allow NULL?
187	STR10	HR-H: one character flag to infotype 0441	char	1	0	CHAR	(N' ')	Yes		P21_FLAG1	Allow NULL?
188	STR11	HR-H: one character flag to infotype 0441	char	1	0	CHAR	(N' ')	Yes		P21_FLAG1	Allow NULL?
189	STR12	HR-H: one character flag to infotype 0441	char	1	0	CHAR	(N' ')	Yes		P21_FLAG1	Allow NULL?
190	STR13	HR-H: one character flag to infotype 0441	char	1	0	CHAR	(N' ')	Yes		P21_FLAG1	Allow NULL?
191	STR14	HR-H: one character flag to infotype 0441	char	1	0	CHAR	(N' ')	Yes		P21_FLAG1	Allow NULL?
192	STR15	HR-H: one character flag to infotype 0441	char	1	0	CHAR	(N' ')	Yes		P21_FLAG1	Allow NULL?
193	TVK01	SI accounting - 5-character absence code	nvarchar	5	0	CHAR	(N' ')	Yes	*	P21_HABTY	Allow NULL?
194	TVK02	SI accounting - 5-character absence code	nvarchar	5	0	CHAR	(N' ')	Yes	*	P21_HABTY	Allow NULL?
195	TVK03	SI accounting - 5-character absence code	nvarchar	5	0	CHAR	(N' ')	Yes	*	P21_HABTY	Allow NULL?
196	TVK04	SI accounting - 5-character absence code	nvarchar	5	0	CHAR	(N' ')	Yes	*	P21_HABTY	Allow NULL?
197	TVK05	SI accounting - 5-character absence code	nvarchar	5	0	CHAR	(N' ')	Yes	*	P21_HABTY	Allow NULL?
198	TVK06	SI accounting - 5-character absence code	nvarchar	5	0	CHAR	(N' ')	Yes	*	P21_HABTY	Allow NULL?
199	TVK07	SI accounting - 5-character absence code	nvarchar	5	0	CHAR	(N' ')	Yes	*	P21_HABTY	Allow NULL?
200	TVK08	SI accounting - 5-character absence code	nvarchar	5	0	CHAR	(N' ')	Yes	*	P21_HABTY	Allow NULL?
201	TVK09	SI accounting - 5-character absence code	nvarchar	5	0	CHAR	(N' ')	Yes	*	P21_HABTY	Allow NULL?
202	TVK10	SI accounting - 5-character absence code	nvarchar	5	0	CHAR	(N' ')	Yes	*	P21_HABTY	Allow NULL?
203	TVK11	SI accounting - 5-character absence code	nvarchar	5	0	CHAR	(N' ')	Yes	*	P21_HABTY	Allow NULL?
204	TVK12	SI accounting - 5-character absence code	nvarchar	5	0	CHAR	(N' ')	Yes	*	P21_HABTY	Allow NULL?
205	TVK13	SI accounting - 5-character absence code	nvarchar	5	0	CHAR	(N' ')	Yes	*	P21_HABTY	Allow NULL?
206	TVK14	SI accounting - 5-character absence code	nvarchar	5	0	CHAR	(N' ')	Yes	*	P21_HABTY	Allow NULL?
207	TVK15	SI accounting - 5-character absence code	nvarchar	5	0	CHAR	(N' ')	Yes	*	P21_HABTY	Allow NULL?
208	HATAR		nvarchar	132	0		(N' ')	Yes			Allow NULL?

TOP ERP 6.0 | PA0441 INDEXES

Name	Primary	Unique	Type	Columns
PA0441~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

208 COLUMNS | 1 INDEXES | ERP 6.0 | PA0441 TABLE

TOP ERP 6.0 | PA0441 COLUMNS

TOP ERP 6.0 | PA0441 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

208 COLUMNS | 1 INDEXES | ERP 6.0 | PA0441 TABLE

TOPERP 6.0 | PA0441 COLUMNS

TOPERP 6.0 | PA0441 INDEXES

TOP ERP 6.0 | PA0441 COLUMNS

TOP ERP 6.0 | PA0441 INDEXES