	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

246 COLUMNS | 1 INDEXES | ERP 6.0 | PA0027 TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Personnel Management :: Personnel Administration
1	ERP EHP7	6.0	PA0027	246	1	HR Master Record: Infotype 0027 (Cost Distribution)	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, KSTAR, KBU01, KGB01, KST01, KPR01, KBU02, KGB02, KST02, KPR02, KBU03, KGB03, KST03, KPR03, KBU04, KGB04, KST04, KPR04, KBU05, KGB05, KST05, KPR05, KBU06, KGB06, KST06, KPR06, KBU07, KGB07, KST07, KPR07, KBU08, KGB08, KST08, KPR08, KBU09, KGB09, KST09, KPR09, KBU10, KGB10, KST10, KPR10, KBU11, KGB11, KST11, KPR11, KBU12, KGB12, KST12, KPR12, KBU13, KGB13, KST13, KPR13, KBU14, KGB14, KST14, KPR14, KBU15, KGB15, KST15, KPR15, KBU16, KGB16, KST16, KPR16, KBU17, KGB17, KST17, KPR17, KBU18, KGB18, KST18, KPR18, KBU19, KGB19, KST19, KPR19, KBU20, KGB20, KST20, KPR20, KBU21, KGB21, KST21, KPR21, KBU22, KGB22, KST22, KPR22, KBU23, KGB23, KST23, KPR23, KBU24, KGB24, KST24, KPR24, KBU25, KGB25, KST25, KPR25, FCT01, FCD01, FKBER01, GRANT01, FCT02, FCD02, FKBER02, GRANT02, FCT03, FCD03, FKBER03, GRANT03, FCT04, FCD04, FKBER04, GRANT04, FCT05, FCD05, FKBER05, GRANT05, FCT06, FCD06, FKBER06, GRANT06, FCT07, FCD07, FKBER07, GRANT07, FCT08, FCD08, FKBER08, GRANT08, FCT09, FCD09, FKBER09, GRANT09, FCT10, FCD10, FKBER10, GRANT10, FCT11, FCD11, FKBER11, GRANT11, FCT12, FCD12, FKBER12, GRANT12, AUF01, AUF02, AUF03, AUF04, AUF05, AUF06, AUF07, AUF08, AUF09, AUF10, AUF11, AUF12, AUF13, AUF14, AUF15, AUF16, AUF17, AUF18, AUF19, AUF20, AUF21, AUF22, AUF23, AUF24, AUF25, PSP01, PSP02, PSP03, PSP04, PSP05, PSP06, PSP07, PSP08, PSP09, PSP10, PSP11, PSP12, PSP13, PSP14, PSP15, PSP16, PSP17, PSP18, PSP19, PSP20, PSP21, PSP22, PSP23, PSP24, PSP25, SGM01, SGM02, SGM03, SGM04, SGM05, SGM06, SGM07, SGM08, SGM09, SGM10, SGM11, SGM12, BUDGET_PD01, BUDGET_PD02, BUDGET_PD03, BUDGET_PD04, BUDGET_PD05, BUDGET_PD06, BUDGET_PD07, BUDGET_PD08, BUDGET_PD09, BUDGET_PD10, BUDGET_PD11, BUDGET_PD12 FROM PA0027

TOP ERP 6.0 | PA0027 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')	No		AEDAT	Allow NULL?
10	UNAME	Name of Person Who Changed Object	nvarchar	12	0	CHAR	(N' ')	No		AENAM	Allow NULL?
11	HISTO	Historical Record Flag	char	1	0	CHAR	(N' ')	No		HISTO	Allow NULL?
12	ITXEX	Text Exists for Infotype	char	1	0	CHAR	(N' ')	No		ITXEX	Allow NULL?
13	REFEX	Reference Fields Exist (Primary/Secondary Costs)	char	1	0	CHAR	(N' ')	No		PRFEX	Allow NULL?
14	ORDEX	Confirmation Fields Exist	char	1	0	CHAR	(N' ')	No		ORDEX	Allow NULL?
15	ITBLD	Infotype Screen Control	nvarchar	2	0	CHAR	(N' ')	No		ITBLD	Allow NULL?
16	PREAS	Reason for Changing Master Data	nvarchar	2	0	CHAR	(N' ')	No	T530E	PREAS	Allow NULL?
17	FLAG1	Reserved Field/Unused Field	char	1	0	CHAR	(N' ')	No		NUSED	Allow NULL?
18	FLAG2	Reserved Field/Unused Field	char	1	0	CHAR	(N' ')	No		NUSED	Allow NULL?
19	FLAG3	Reserved Field/Unused Field	char	1	0	CHAR	(N' ')	No		NUSED	Allow NULL?
20	FLAG4	Reserved Field/Unused Field	char	1	0	CHAR	(N' ')	No		NUSED	Allow NULL?
21	RESE1	Reserved Field/Unused Field of Length 2	nvarchar	2	0	CHAR	(N' ')	No		NUSED2	Allow NULL?
22	RESE2	Reserved Field/Unused Field of Length 2	nvarchar	2	0	CHAR	(N' ')	No		NUSED2	Allow NULL?
23	GRPVL	Grouping Value for Personnel Assignments	nvarchar	4	0	CHAR	(N' ')	Yes		PCCE_GPVAL	Allow NULL?
24	KSTAR	Costs to be distributed	nvarchar	4	0	CHAR	(N' ')	No	T591A	CSTTY	Allow NULL?
25	KBU01	Company Code	nvarchar	4	0	CHAR	(N' ')	No	T001	BUKRS	Allow NULL?
26	KGB01	Business Area	nvarchar	4	0	CHAR	(N' ')	No	TGSB	GSBER	Allow NULL?
27	KST01	Cost Center	nvarchar	10	0	CHAR	(N' ')	No	CSKS	KOSTL	Allow NULL?
28	KPR01	Cost center percentage	decimal	5	2	DEC	((0))	No		PKPRZ
29	KBU02	Company Code	nvarchar	4	0	CHAR	(N' ')	No	T001	BUKRS	Allow NULL?
30	KGB02	Business Area	nvarchar	4	0	CHAR	(N' ')	No	TGSB	GSBER	Allow NULL?
31	KST02	Cost Center	nvarchar	10	0	CHAR	(N' ')	No	CSKS	KOSTL	Allow NULL?
32	KPR02	Cost center percentage	decimal	5	2	DEC	((0))	No		PKPRZ
33	KBU03	Company Code	nvarchar	4	0	CHAR	(N' ')	No	T001	BUKRS	Allow NULL?
34	KGB03	Business Area	nvarchar	4	0	CHAR	(N' ')	No	TGSB	GSBER	Allow NULL?
35	KST03	Cost Center	nvarchar	10	0	CHAR	(N' ')	No	CSKS	KOSTL	Allow NULL?
36	KPR03	Cost center percentage	decimal	5	2	DEC	((0))	No		PKPRZ
37	KBU04	Company Code	nvarchar	4	0	CHAR	(N' ')	No	T001	BUKRS	Allow NULL?
38	KGB04	Business Area	nvarchar	4	0	CHAR	(N' ')	No	TGSB	GSBER	Allow NULL?
39	KST04	Cost Center	nvarchar	10	0	CHAR	(N' ')	No	CSKS	KOSTL	Allow NULL?
40	KPR04	Cost center percentage	decimal	5	2	DEC	((0))	No		PKPRZ
41	KBU05	Company Code	nvarchar	4	0	CHAR	(N' ')	No	T001	BUKRS	Allow NULL?
42	KGB05	Business Area	nvarchar	4	0	CHAR	(N' ')	No	TGSB	GSBER	Allow NULL?
43	KST05	Cost Center	nvarchar	10	0	CHAR	(N' ')	No	CSKS	KOSTL	Allow NULL?
44	KPR05	Cost center percentage	decimal	5	2	DEC	((0))	No		PKPRZ
45	KBU06	Company Code	nvarchar	4	0	CHAR	(N' ')	No	T001	BUKRS	Allow NULL?
46	KGB06	Business Area	nvarchar	4	0	CHAR	(N' ')	No	TGSB	GSBER	Allow NULL?
47	KST06	Cost Center	nvarchar	10	0	CHAR	(N' ')	No	CSKS	KOSTL	Allow NULL?
48	KPR06	Cost center percentage	decimal	5	2	DEC	((0))	No		PKPRZ
49	KBU07	Company Code	nvarchar	4	0	CHAR	(N' ')	No	T001	BUKRS	Allow NULL?
50	KGB07	Business Area	nvarchar	4	0	CHAR	(N' ')	No	TGSB	GSBER	Allow NULL?
51	KST07	Cost Center	nvarchar	10	0	CHAR	(N' ')	No	CSKS	KOSTL	Allow NULL?
52	KPR07	Cost center percentage	decimal	5	2	DEC	((0))	No		PKPRZ
53	KBU08	Company Code	nvarchar	4	0	CHAR	(N' ')	No	T001	BUKRS	Allow NULL?
54	KGB08	Business Area	nvarchar	4	0	CHAR	(N' ')	No	TGSB	GSBER	Allow NULL?
55	KST08	Cost Center	nvarchar	10	0	CHAR	(N' ')	No	CSKS	KOSTL	Allow NULL?
56	KPR08	Cost center percentage	decimal	5	2	DEC	((0))	No		PKPRZ
57	KBU09	Company Code	nvarchar	4	0	CHAR	(N' ')	No	T001	BUKRS	Allow NULL?
58	KGB09	Business Area	nvarchar	4	0	CHAR	(N' ')	No	TGSB	GSBER	Allow NULL?
59	KST09	Cost Center	nvarchar	10	0	CHAR	(N' ')	No	CSKS	KOSTL	Allow NULL?
60	KPR09	Cost center percentage	decimal	5	2	DEC	((0))	No		PKPRZ
61	KBU10	Company Code	nvarchar	4	0	CHAR	(N' ')	No	T001	BUKRS	Allow NULL?
62	KGB10	Business Area	nvarchar	4	0	CHAR	(N' ')	No	TGSB	GSBER	Allow NULL?
63	KST10	Cost Center	nvarchar	10	0	CHAR	(N' ')	No	CSKS	KOSTL	Allow NULL?
64	KPR10	Cost center percentage	decimal	5	2	DEC	((0))	No		PKPRZ
65	KBU11	Company Code	nvarchar	4	0	CHAR	(N' ')	No	T001	BUKRS	Allow NULL?
66	KGB11	Business Area	nvarchar	4	0	CHAR	(N' ')	No	TGSB	GSBER	Allow NULL?
67	KST11	Cost Center	nvarchar	10	0	CHAR	(N' ')	No	CSKS	KOSTL	Allow NULL?
68	KPR11	Cost center percentage	decimal	5	2	DEC	((0))	No		PKPRZ
69	KBU12	Company Code	nvarchar	4	0	CHAR	(N' ')	No	T001	BUKRS	Allow NULL?
70	KGB12	Business Area	nvarchar	4	0	CHAR	(N' ')	No	TGSB	GSBER	Allow NULL?
71	KST12	Cost Center	nvarchar	10	0	CHAR	(N' ')	No	CSKS	KOSTL	Allow NULL?
72	KPR12	Cost center percentage	decimal	5	2	DEC	((0))	No		PKPRZ
73	KBU13	Company Code	nvarchar	4	0	CHAR	(N' ')	No	T001	BUKRS	Allow NULL?
74	KGB13	Business Area	nvarchar	4	0	CHAR	(N' ')	No	TGSB	GSBER	Allow NULL?
75	KST13	Cost Center	nvarchar	10	0	CHAR	(N' ')	No	CSKS	KOSTL	Allow NULL?
76	KPR13	Cost center percentage	decimal	5	2	DEC	((0))	No		PKPRZ
77	KBU14	Company Code	nvarchar	4	0	CHAR	(N' ')	No	T001	BUKRS	Allow NULL?
78	KGB14	Business Area	nvarchar	4	0	CHAR	(N' ')	No	TGSB	GSBER	Allow NULL?
79	KST14	Cost Center	nvarchar	10	0	CHAR	(N' ')	No	CSKS	KOSTL	Allow NULL?
80	KPR14	Cost center percentage	decimal	5	2	DEC	((0))	No		PKPRZ
81	KBU15	Company Code	nvarchar	4	0	CHAR	(N' ')	No	T001	BUKRS	Allow NULL?
82	KGB15	Business Area	nvarchar	4	0	CHAR	(N' ')	No	TGSB	GSBER	Allow NULL?
83	KST15	Cost Center	nvarchar	10	0	CHAR	(N' ')	No	CSKS	KOSTL	Allow NULL?
84	KPR15	Cost center percentage	decimal	5	2	DEC	((0))	No		PKPRZ
85	KBU16	Company Code	nvarchar	4	0	CHAR	(N' ')	No	T001	BUKRS	Allow NULL?
86	KGB16	Business Area	nvarchar	4	0	CHAR	(N' ')	No	TGSB	GSBER	Allow NULL?
87	KST16	Cost Center	nvarchar	10	0	CHAR	(N' ')	No	CSKS	KOSTL	Allow NULL?
88	KPR16	Cost center percentage	decimal	5	2	DEC	((0))	No		PKPRZ
89	KBU17	Company Code	nvarchar	4	0	CHAR	(N' ')	No	T001	BUKRS	Allow NULL?
90	KGB17	Business Area	nvarchar	4	0	CHAR	(N' ')	No	TGSB	GSBER	Allow NULL?
91	KST17	Cost Center	nvarchar	10	0	CHAR	(N' ')	No	CSKS	KOSTL	Allow NULL?
92	KPR17	Cost center percentage	decimal	5	2	DEC	((0))	No		PKPRZ
93	KBU18	Company Code	nvarchar	4	0	CHAR	(N' ')	No	T001	BUKRS	Allow NULL?
94	KGB18	Business Area	nvarchar	4	0	CHAR	(N' ')	No	TGSB	GSBER	Allow NULL?
95	KST18	Cost Center	nvarchar	10	0	CHAR	(N' ')	No	CSKS	KOSTL	Allow NULL?
96	KPR18	Cost center percentage	decimal	5	2	DEC	((0))	No		PKPRZ
97	KBU19	Company Code	nvarchar	4	0	CHAR	(N' ')	No	T001	BUKRS	Allow NULL?
98	KGB19	Business Area	nvarchar	4	0	CHAR	(N' ')	No	TGSB	GSBER	Allow NULL?
99	KST19	Cost Center	nvarchar	10	0	CHAR	(N' ')	No	CSKS	KOSTL	Allow NULL?
100	KPR19	Cost center percentage	decimal	5	2	DEC	((0))	No		PKPRZ
101	KBU20	Company Code	nvarchar	4	0	CHAR	(N' ')	No	T001	BUKRS	Allow NULL?
102	KGB20	Business Area	nvarchar	4	0	CHAR	(N' ')	No	TGSB	GSBER	Allow NULL?
103	KST20	Cost Center	nvarchar	10	0	CHAR	(N' ')	No	CSKS	KOSTL	Allow NULL?
104	KPR20	Cost center percentage	decimal	5	2	DEC	((0))	No		PKPRZ
105	KBU21	Company Code	nvarchar	4	0	CHAR	(N' ')	No	T001	BUKRS	Allow NULL?
106	KGB21	Business Area	nvarchar	4	0	CHAR	(N' ')	No	TGSB	GSBER	Allow NULL?
107	KST21	Cost Center	nvarchar	10	0	CHAR	(N' ')	No	CSKS	KOSTL	Allow NULL?
108	KPR21	Cost center percentage	decimal	5	2	DEC	((0))	No		PKPRZ
109	KBU22	Company Code	nvarchar	4	0	CHAR	(N' ')	No	T001	BUKRS	Allow NULL?
110	KGB22	Business Area	nvarchar	4	0	CHAR	(N' ')	No	TGSB	GSBER	Allow NULL?
111	KST22	Cost Center	nvarchar	10	0	CHAR	(N' ')	No	CSKS	KOSTL	Allow NULL?
112	KPR22	Cost center percentage	decimal	5	2	DEC	((0))	No		PKPRZ
113	KBU23	Company Code	nvarchar	4	0	CHAR	(N' ')	No	T001	BUKRS	Allow NULL?
114	KGB23	Business Area	nvarchar	4	0	CHAR	(N' ')	No	TGSB	GSBER	Allow NULL?
115	KST23	Cost Center	nvarchar	10	0	CHAR	(N' ')	No	CSKS	KOSTL	Allow NULL?
116	KPR23	Cost center percentage	decimal	5	2	DEC	((0))	No		PKPRZ
117	KBU24	Company Code	nvarchar	4	0	CHAR	(N' ')	No	T001	BUKRS	Allow NULL?
118	KGB24	Business Area	nvarchar	4	0	CHAR	(N' ')	No	TGSB	GSBER	Allow NULL?
119	KST24	Cost Center	nvarchar	10	0	CHAR	(N' ')	No	CSKS	KOSTL	Allow NULL?
120	KPR24	Cost center percentage	decimal	5	2	DEC	((0))	No		PKPRZ
121	KBU25	Company Code	nvarchar	4	0	CHAR	(N' ')	No	T001	BUKRS	Allow NULL?
122	KGB25	Business Area	nvarchar	4	0	CHAR	(N' ')	No	TGSB	GSBER	Allow NULL?
123	KST25	Cost Center	nvarchar	10	0	CHAR	(N' ')	No	CSKS	KOSTL	Allow NULL?
124	KPR25	Cost center percentage	decimal	5	2	DEC	((0))	No		PKPRZ
125	FCT01	Funds Center	nvarchar	16	0	CHAR	(N' ')	No	*	FISTL	Allow NULL?
126	FCD01	Fund	nvarchar	10	0	CHAR	(N' ')	No	*	BP_GEBER	Allow NULL?
127	FKBER01	Functional Area	nvarchar	16	0	CHAR	(N' ')	Yes	*	FKBER	Allow NULL?
128	GRANT01	Grant	nvarchar	20	0	CHAR	(N' ')	Yes		GM_GRANT_NBR	Allow NULL?
129	FCT02	Funds Center	nvarchar	16	0	CHAR	(N' ')	No	*	FISTL	Allow NULL?
130	FCD02	Fund	nvarchar	10	0	CHAR	(N' ')	No	*	BP_GEBER	Allow NULL?
131	FKBER02	Functional Area	nvarchar	16	0	CHAR	(N' ')	Yes	*	FKBER	Allow NULL?
132	GRANT02	Grant	nvarchar	20	0	CHAR	(N' ')	Yes		GM_GRANT_NBR	Allow NULL?
133	FCT03	Funds Center	nvarchar	16	0	CHAR	(N' ')	No	*	FISTL	Allow NULL?
134	FCD03	Fund	nvarchar	10	0	CHAR	(N' ')	No	*	BP_GEBER	Allow NULL?
135	FKBER03	Functional Area	nvarchar	16	0	CHAR	(N' ')	Yes	*	FKBER	Allow NULL?
136	GRANT03	Grant	nvarchar	20	0	CHAR	(N' ')	Yes		GM_GRANT_NBR	Allow NULL?
137	FCT04	Funds Center	nvarchar	16	0	CHAR	(N' ')	No	*	FISTL	Allow NULL?
138	FCD04	Fund	nvarchar	10	0	CHAR	(N' ')	No	*	BP_GEBER	Allow NULL?
139	FKBER04	Functional Area	nvarchar	16	0	CHAR	(N' ')	Yes	*	FKBER	Allow NULL?
140	GRANT04	Grant	nvarchar	20	0	CHAR	(N' ')	Yes		GM_GRANT_NBR	Allow NULL?
141	FCT05	Funds Center	nvarchar	16	0	CHAR	(N' ')	No	*	FISTL	Allow NULL?
142	FCD05	Fund	nvarchar	10	0	CHAR	(N' ')	No	*	BP_GEBER	Allow NULL?
143	FKBER05	Functional Area	nvarchar	16	0	CHAR	(N' ')	Yes	*	FKBER	Allow NULL?
144	GRANT05	Grant	nvarchar	20	0	CHAR	(N' ')	Yes		GM_GRANT_NBR	Allow NULL?
145	FCT06	Funds Center	nvarchar	16	0	CHAR	(N' ')	No	*	FISTL	Allow NULL?
146	FCD06	Fund	nvarchar	10	0	CHAR	(N' ')	No	*	BP_GEBER	Allow NULL?
147	FKBER06	Functional Area	nvarchar	16	0	CHAR	(N' ')	Yes	*	FKBER	Allow NULL?
148	GRANT06	Grant	nvarchar	20	0	CHAR	(N' ')	Yes		GM_GRANT_NBR	Allow NULL?
149	FCT07	Funds Center	nvarchar	16	0	CHAR	(N' ')	No	*	FISTL	Allow NULL?
150	FCD07	Fund	nvarchar	10	0	CHAR	(N' ')	No	*	BP_GEBER	Allow NULL?
151	FKBER07	Functional Area	nvarchar	16	0	CHAR	(N' ')	Yes	*	FKBER	Allow NULL?
152	GRANT07	Grant	nvarchar	20	0	CHAR	(N' ')	Yes		GM_GRANT_NBR	Allow NULL?
153	FCT08	Funds Center	nvarchar	16	0	CHAR	(N' ')	No	*	FISTL	Allow NULL?
154	FCD08	Fund	nvarchar	10	0	CHAR	(N' ')	No	*	BP_GEBER	Allow NULL?
155	FKBER08	Functional Area	nvarchar	16	0	CHAR	(N' ')	Yes	*	FKBER	Allow NULL?
156	GRANT08	Grant	nvarchar	20	0	CHAR	(N' ')	Yes		GM_GRANT_NBR	Allow NULL?
157	FCT09	Funds Center	nvarchar	16	0	CHAR	(N' ')	Yes	*	FISTL	Allow NULL?
158	FCD09	Fund	nvarchar	10	0	CHAR	(N' ')	Yes	*	BP_GEBER	Allow NULL?
159	FKBER09	Functional Area	nvarchar	16	0	CHAR	(N' ')	Yes	*	FKBER	Allow NULL?
160	GRANT09	Grant	nvarchar	20	0	CHAR	(N' ')	Yes		GM_GRANT_NBR	Allow NULL?
161	FCT10	Funds Center	nvarchar	16	0	CHAR	(N' ')	Yes	*	FISTL	Allow NULL?
162	FCD10	Fund	nvarchar	10	0	CHAR	(N' ')	Yes	*	BP_GEBER	Allow NULL?
163	FKBER10	Functional Area	nvarchar	16	0	CHAR	(N' ')	Yes	*	FKBER	Allow NULL?
164	GRANT10	Grant	nvarchar	20	0	CHAR	(N' ')	Yes		GM_GRANT_NBR	Allow NULL?
165	FCT11	Funds Center	nvarchar	16	0	CHAR	(N' ')	Yes	*	FISTL	Allow NULL?
166	FCD11	Fund	nvarchar	10	0	CHAR	(N' ')	Yes	*	BP_GEBER	Allow NULL?
167	FKBER11	Functional Area	nvarchar	16	0	CHAR	(N' ')	Yes	*	FKBER	Allow NULL?
168	GRANT11	Grant	nvarchar	20	0	CHAR	(N' ')	Yes		GM_GRANT_NBR	Allow NULL?
169	FCT12	Funds Center	nvarchar	16	0	CHAR	(N' ')	Yes	*	FISTL	Allow NULL?
170	FCD12	Fund	nvarchar	10	0	CHAR	(N' ')	Yes	*	BP_GEBER	Allow NULL?
171	FKBER12	Functional Area	nvarchar	16	0	CHAR	(N' ')	Yes	*	FKBER	Allow NULL?
172	GRANT12	Grant	nvarchar	20	0	CHAR	(N' ')	Yes		GM_GRANT_NBR	Allow NULL?
173	AUF01	Order Number	nvarchar	12	0	CHAR	(N' ')	Yes	*	AUFNR	Allow NULL?
174	AUF02	Order Number	nvarchar	12	0	CHAR	(N' ')	No	*	AUFNR	Allow NULL?
175	AUF03	Order Number	nvarchar	12	0	CHAR	(N' ')	No	*	AUFNR	Allow NULL?
176	AUF04	Order Number	nvarchar	12	0	CHAR	(N' ')	No	*	AUFNR	Allow NULL?
177	AUF05	Order Number	nvarchar	12	0	CHAR	(N' ')	No	*	AUFNR	Allow NULL?
178	AUF06	Order Number	nvarchar	12	0	CHAR	(N' ')	No	*	AUFNR	Allow NULL?
179	AUF07	Order Number	nvarchar	12	0	CHAR	(N' ')	No	*	AUFNR	Allow NULL?
180	AUF08	Order Number	nvarchar	12	0	CHAR	(N' ')	No	*	AUFNR	Allow NULL?
181	AUF09	Order Number	nvarchar	12	0	CHAR	(N' ')	No	*	AUFNR	Allow NULL?
182	AUF10	Order Number	nvarchar	12	0	CHAR	(N' ')	No	*	AUFNR	Allow NULL?
183	AUF11	Order Number	nvarchar	12	0	CHAR	(N' ')	No	*	AUFNR	Allow NULL?
184	AUF12	Order Number	nvarchar	12	0	CHAR	(N' ')	No	*	AUFNR	Allow NULL?
185	AUF13	Order Number	nvarchar	12	0	CHAR	(N' ')	No	*	AUFNR	Allow NULL?
186	AUF14	Order Number	nvarchar	12	0	CHAR	(N' ')	No	*	AUFNR	Allow NULL?
187	AUF15	Order Number	nvarchar	12	0	CHAR	(N' ')	No	*	AUFNR	Allow NULL?
188	AUF16	Order Number	nvarchar	12	0	CHAR	(N' ')	No	*	AUFNR	Allow NULL?
189	AUF17	Order Number	nvarchar	12	0	CHAR	(N' ')	No	*	AUFNR	Allow NULL?
190	AUF18	Order Number	nvarchar	12	0	CHAR	(N' ')	No	*	AUFNR	Allow NULL?
191	AUF19	Order Number	nvarchar	12	0	CHAR	(N' ')	No	*	AUFNR	Allow NULL?
192	AUF20	Order Number	nvarchar	12	0	CHAR	(N' ')	No	*	AUFNR	Allow NULL?
193	AUF21	Order Number	nvarchar	12	0	CHAR	(N' ')	No	*	AUFNR	Allow NULL?
194	AUF22	Order Number	nvarchar	12	0	CHAR	(N' ')	No	*	AUFNR	Allow NULL?
195	AUF23	Order Number	nvarchar	12	0	CHAR	(N' ')	No	*	AUFNR	Allow NULL?
196	AUF24	Order Number	nvarchar	12	0	CHAR	(N' ')	No	*	AUFNR	Allow NULL?
197	AUF25	Order Number	nvarchar	12	0	CHAR	(N' ')	No	*	AUFNR	Allow NULL?
198	PSP01	Work Breakdown Structure Element (WBS Element)	nvarchar	8	0	NUMC	(N'00000000')	No	*	PS_PSP_PNR	Allow NULL?
199	PSP02	Work Breakdown Structure Element (WBS Element)	nvarchar	8	0	NUMC	(N'00000000')	No	*	PS_PSP_PNR	Allow NULL?
200	PSP03	Work Breakdown Structure Element (WBS Element)	nvarchar	8	0	NUMC	(N'00000000')	No	*	PS_PSP_PNR	Allow NULL?
201	PSP04	Work Breakdown Structure Element (WBS Element)	nvarchar	8	0	NUMC	(N'00000000')	No	*	PS_PSP_PNR	Allow NULL?
202	PSP05	Work Breakdown Structure Element (WBS Element)	nvarchar	8	0	NUMC	(N'00000000')	No	*	PS_PSP_PNR	Allow NULL?
203	PSP06	Work Breakdown Structure Element (WBS Element)	nvarchar	8	0	NUMC	(N'00000000')	No	*	PS_PSP_PNR	Allow NULL?
204	PSP07	Work Breakdown Structure Element (WBS Element)	nvarchar	8	0	NUMC	(N'00000000')	No	*	PS_PSP_PNR	Allow NULL?
205	PSP08	Work Breakdown Structure Element (WBS Element)	nvarchar	8	0	NUMC	(N'00000000')	No	*	PS_PSP_PNR	Allow NULL?
206	PSP09	Work Breakdown Structure Element (WBS Element)	nvarchar	8	0	NUMC	(N'00000000')	No	*	PS_PSP_PNR	Allow NULL?
207	PSP10	Work Breakdown Structure Element (WBS Element)	nvarchar	8	0	NUMC	(N'00000000')	No	*	PS_PSP_PNR	Allow NULL?
208	PSP11	Work Breakdown Structure Element (WBS Element)	nvarchar	8	0	NUMC	(N'00000000')	No	*	PS_PSP_PNR	Allow NULL?
209	PSP12	Work Breakdown Structure Element (WBS Element)	nvarchar	8	0	NUMC	(N'00000000')	No	*	PS_PSP_PNR	Allow NULL?
210	PSP13	Work Breakdown Structure Element (WBS Element)	nvarchar	8	0	NUMC	(N'00000000')	No	*	PS_PSP_PNR	Allow NULL?
211	PSP14	Work Breakdown Structure Element (WBS Element)	nvarchar	8	0	NUMC	(N'00000000')	No	*	PS_PSP_PNR	Allow NULL?
212	PSP15	Work Breakdown Structure Element (WBS Element)	nvarchar	8	0	NUMC	(N'00000000')	No	*	PS_PSP_PNR	Allow NULL?
213	PSP16	Work Breakdown Structure Element (WBS Element)	nvarchar	8	0	NUMC	(N'00000000')	No	*	PS_PSP_PNR	Allow NULL?
214	PSP17	Work Breakdown Structure Element (WBS Element)	nvarchar	8	0	NUMC	(N'00000000')	No	*	PS_PSP_PNR	Allow NULL?
215	PSP18	Work Breakdown Structure Element (WBS Element)	nvarchar	8	0	NUMC	(N'00000000')	No	*	PS_PSP_PNR	Allow NULL?
216	PSP19	Work Breakdown Structure Element (WBS Element)	nvarchar	8	0	NUMC	(N'00000000')	No	*	PS_PSP_PNR	Allow NULL?
217	PSP20	Work Breakdown Structure Element (WBS Element)	nvarchar	8	0	NUMC	(N'00000000')	No	*	PS_PSP_PNR	Allow NULL?
218	PSP21	Work Breakdown Structure Element (WBS Element)	nvarchar	8	0	NUMC	(N'00000000')	No	*	PS_PSP_PNR	Allow NULL?
219	PSP22	Work Breakdown Structure Element (WBS Element)	nvarchar	8	0	NUMC	(N'00000000')	No	*	PS_PSP_PNR	Allow NULL?
220	PSP23	Work Breakdown Structure Element (WBS Element)	nvarchar	8	0	NUMC	(N'00000000')	No	*	PS_PSP_PNR	Allow NULL?
221	PSP24	Work Breakdown Structure Element (WBS Element)	nvarchar	8	0	NUMC	(N'00000000')	No	*	PS_PSP_PNR	Allow NULL?
222	PSP25	Work Breakdown Structure Element (WBS Element)	nvarchar	8	0	NUMC	(N'00000000')	No	*	PS_PSP_PNR	Allow NULL?
223	SGM01	Segment for Segmental Reporting	nvarchar	10	0	CHAR	(N' ')	Yes	*	FB_SEGMENT	Allow NULL?
224	SGM02	Segment for Segmental Reporting	nvarchar	10	0	CHAR	(N' ')	Yes	*	FB_SEGMENT	Allow NULL?
225	SGM03	Segment for Segmental Reporting	nvarchar	10	0	CHAR	(N' ')	Yes	*	FB_SEGMENT	Allow NULL?
226	SGM04	Segment for Segmental Reporting	nvarchar	10	0	CHAR	(N' ')	Yes	*	FB_SEGMENT	Allow NULL?
227	SGM05	Segment for Segmental Reporting	nvarchar	10	0	CHAR	(N' ')	Yes	*	FB_SEGMENT	Allow NULL?
228	SGM06	Segment for Segmental Reporting	nvarchar	10	0	CHAR	(N' ')	Yes	*	FB_SEGMENT	Allow NULL?
229	SGM07	Segment for Segmental Reporting	nvarchar	10	0	CHAR	(N' ')	Yes	*	FB_SEGMENT	Allow NULL?
230	SGM08	Segment for Segmental Reporting	nvarchar	10	0	CHAR	(N' ')	Yes	*	FB_SEGMENT	Allow NULL?
231	SGM09	Segment for Segmental Reporting	nvarchar	10	0	CHAR	(N' ')	Yes	*	FB_SEGMENT	Allow NULL?
232	SGM10	Segment for Segmental Reporting	nvarchar	10	0	CHAR	(N' ')	Yes	*	FB_SEGMENT	Allow NULL?
233	SGM11	Segment for Segmental Reporting	nvarchar	10	0	CHAR	(N' ')	Yes	*	FB_SEGMENT	Allow NULL?
234	SGM12	Segment for Segmental Reporting	nvarchar	10	0	CHAR	(N' ')	Yes	*	FB_SEGMENT	Allow NULL?
235	BUDGET_PD01	FM: Budget Period	nvarchar	10	0	CHAR	(N' ')	Yes	*	FM_BUDGET_PERIOD	Allow NULL?
236	BUDGET_PD02	FM: Budget Period	nvarchar	10	0	CHAR	(N' ')	Yes	*	FM_BUDGET_PERIOD	Allow NULL?
237	BUDGET_PD03	FM: Budget Period	nvarchar	10	0	CHAR	(N' ')	Yes	*	FM_BUDGET_PERIOD	Allow NULL?
238	BUDGET_PD04	FM: Budget Period	nvarchar	10	0	CHAR	(N' ')	Yes	*	FM_BUDGET_PERIOD	Allow NULL?
239	BUDGET_PD05	FM: Budget Period	nvarchar	10	0	CHAR	(N' ')	Yes	*	FM_BUDGET_PERIOD	Allow NULL?
240	BUDGET_PD06	FM: Budget Period	nvarchar	10	0	CHAR	(N' ')	Yes	*	FM_BUDGET_PERIOD	Allow NULL?
241	BUDGET_PD07	FM: Budget Period	nvarchar	10	0	CHAR	(N' ')	Yes	*	FM_BUDGET_PERIOD	Allow NULL?
242	BUDGET_PD08	FM: Budget Period	nvarchar	10	0	CHAR	(N' ')	Yes	*	FM_BUDGET_PERIOD	Allow NULL?
243	BUDGET_PD09	FM: Budget Period	nvarchar	10	0	CHAR	(N' ')	Yes	*	FM_BUDGET_PERIOD	Allow NULL?
244	BUDGET_PD10	FM: Budget Period	nvarchar	10	0	CHAR	(N' ')	Yes	*	FM_BUDGET_PERIOD	Allow NULL?
245	BUDGET_PD11	FM: Budget Period	nvarchar	10	0	CHAR	(N' ')	Yes	*	FM_BUDGET_PERIOD	Allow NULL?
246	BUDGET_PD12	FM: Budget Period	nvarchar	10	0	CHAR	(N' ')	Yes	*	FM_BUDGET_PERIOD	Allow NULL?

TOP ERP 6.0 | PA0027 INDEXES

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

246 COLUMNS | 1 INDEXES | ERP 6.0 | PA0027 TABLE

TOP ERP 6.0 | PA0027 COLUMNS

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

246 COLUMNS | 1 INDEXES | ERP 6.0 | PA0027 TABLE

TOPERP 6.0 | PA0027 COLUMNS

TOPERP 6.0 | PA0027 INDEXES

TOP ERP 6.0 | PA0027 COLUMNS

TOP ERP 6.0 | PA0027 INDEXES