	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

308 COLUMNS | 1 INDEXES | ERP 6.0 | PA0897 TABLE

	Product	Version	Table	Columns	Indexes	Description	Module
Personnel Management :: Personnel Administration :: Netherlands
1	ERP EHP7	6.0	PA0897	308	1	HR Master Record Infotype 0897	Netherlands

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, BAREA, KZMDL, STAT1, KZVAR, BRN01, TBB01, TAB01, BBB01, BAB01, BRN02, TBB02, TAB02, BBB02, BAB02, BRN03, TBB03, TAB03, BBB03, BAB03, BRN04, TBB04, TAB04, BBB04, BAB04, BRN05, TBB05, TAB05, BBB05, BAB05, BRN06, TBB06, TAB06, BBB06, BAB06, BRN07, TBB07, TAB07, BBB07, BAB07, BRN08, TBB08, TAB08, BBB08, BAB08, DL_01, KZD01, TBD01, TAD01, DL_02, KZD02, TBD02, TAD02, DL_03, KZD03, TBD03, TAD03, DL_04, KZD04, TBD04, TAD04, DL_05, KZD05, TBD05, TAD05, DL_06, KZD06, TBD06, TAD06, DL_07, KZD07, TBD07, TAD07, DL_08, KZD08, TBD08, TAD08, DL_09, KZD09, TBD09, TAD09, DL_10, KZD10, TBD10, TAD10, DL_11, KZD11, TBD11, TAD11, DL_12, KZD12, TBD12, TAD12, B1D01, A1D01, B1D02, A1D02, B1D03, A1D03, B1D04, A1D04, B1D05, A1D05, B1D06, A1D06, B1D07, A1D07, B1D08, A1D08, B1D09, A1D09, B1D10, A1D10, B1D11, A1D11, B1D12, A1D12, B2D01, A2D01, B2D02, A2D02, B2D03, A2D03, B2D04, A2D04, B2D05, A2D05, B2D06, A2D06, B2D07, A2D07, B2D08, A2D08, B2D09, A2D09, B2D10, A2D10, B2D11, A2D11, B2D12, A2D12, B3D01, A3D01, B3D02, A3D02, B3D03, A3D03, B3D04, A3D04, B3D05, A3D05, B3D06, A3D06, B3D07, A3D07, B3D08, A3D08, B3D09, A3D09, B3D10, A3D10, B3D11, A3D11, B3D12, A3D12, B4D01, A4D01, B4D02, A4D02, B4D03, A4D03, B4D04, A4D04, B4D05, A4D05, B4D06, A4D06, B4D07, A4D07, B4D08, A4D08, B4D09, A4D09, B4D10, A4D10, B4D11, A4D11, B4D12, A4D12, B5D01, A5D01, B5D02, A5D02, B5D03, A5D03, B5D04, A5D04, B5D05, A5D05, B5D06, A5D06, B5D07, A5D07, B5D08, A5D08, B5D09, A5D09, B5D10, A5D10, B5D11, A5D11, B5D12, A5D12, B6D01, A6D01, B6D02, A6D02, B6D03, A6D03, B6D04, A6D04, B6D05, A6D05, B6D06, A6D06, B6D07, A6D07, B6D08, A6D08, B6D09, A6D09, B6D10, A6D10, B6D11, A6D11, B6D12, A6D12, B7D01, A7D01, B7D02, A7D02, B7D03, A7D03, B7D04, A7D04, B7D05, A7D05, B7D06, A7D06, B7D07, A7D07, B7D08, A7D08, B7D09, A7D09, B7D10, A7D10, B7D11, A7D11, B7D12, A7D12, B8D01, A8D01, B8D02, A8D02, B8D03, A8D03, B8D04, A8D04, B8D05, A8D05, B8D06, A8D06, B8D07, A8D07, B8D08, A8D08, B8D09, A8D09, B8D10, A8D10, B8D11, A8D11, B8D12, A8D12, EVENT FROM PA0897

TOP ERP 6.0 | PA0897 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	BAREA	Benefit area	nvarchar	2	0	CHAR	(N' ')	Yes	T5UB3	BEN_AREA	Allow NULL?
25	KZMDL	Program	nvarchar	4	0	CHAR	(N' ')	Yes	P05FBN_KEUZEMOD	P05FBN_KZMDL	Allow NULL?
26	STAT1	Status of Flexible Benefits Record	nvarchar	2	0	CHAR	(N' ')	Yes		P05FBN_STATUS	Allow NULL?
27	KZVAR	Program Variant	nvarchar	2	0	CHAR	(N' ')	Yes		P05FBN_KZVAR	Allow NULL?
28	BRN01	Source	nvarchar	4	0	CHAR	(N' ')	Yes	*	P05FBN_BRON	Allow NULL?
29	TBB01	Total Amount Source	decimal	9	2	CURR	((0))	Yes		P05FBN_TBBRON
30	TAB01	Total Number Source	decimal	5	2	DEC	((0))	Yes		P05FBN_TABRON
31	BBB01	Source amount available	decimal	9	2	CURR	((0))	Yes		P05FBN_BBBRON
32	BAB01	Source number available	decimal	5	2	DEC	((0))	Yes		P05FBN_BABRON
33	BRN02	Source	nvarchar	4	0	CHAR	(N' ')	Yes	*	P05FBN_BRON	Allow NULL?
34	TBB02	Total Amount Source	decimal	9	2	CURR	((0))	Yes		P05FBN_TBBRON
35	TAB02	Total Number Source	decimal	5	2	DEC	((0))	Yes		P05FBN_TABRON
36	BBB02	Source amount available	decimal	9	2	CURR	((0))	Yes		P05FBN_BBBRON
37	BAB02	Source number available	decimal	5	2	DEC	((0))	Yes		P05FBN_BABRON
38	BRN03	Source	nvarchar	4	0	CHAR	(N' ')	Yes	*	P05FBN_BRON	Allow NULL?
39	TBB03	Total Amount Source	decimal	9	2	CURR	((0))	Yes		P05FBN_TBBRON
40	TAB03	Total Number Source	decimal	5	2	DEC	((0))	Yes		P05FBN_TABRON
41	BBB03	Source amount available	decimal	9	2	CURR	((0))	Yes		P05FBN_BBBRON
42	BAB03	Source number available	decimal	5	2	DEC	((0))	Yes		P05FBN_BABRON
43	BRN04	Source	nvarchar	4	0	CHAR	(N' ')	Yes	*	P05FBN_BRON	Allow NULL?
44	TBB04	Total Amount Source	decimal	9	2	CURR	((0))	Yes		P05FBN_TBBRON
45	TAB04	Total Number Source	decimal	5	2	DEC	((0))	Yes		P05FBN_TABRON
46	BBB04	Source amount available	decimal	9	2	CURR	((0))	Yes		P05FBN_BBBRON
47	BAB04	Source number available	decimal	5	2	DEC	((0))	Yes		P05FBN_BABRON
48	BRN05	Source	nvarchar	4	0	CHAR	(N' ')	Yes	*	P05FBN_BRON	Allow NULL?
49	TBB05	Total Amount Source	decimal	9	2	CURR	((0))	Yes		P05FBN_TBBRON
50	TAB05	Total Number Source	decimal	5	2	DEC	((0))	Yes		P05FBN_TABRON
51	BBB05	Source amount available	decimal	9	2	CURR	((0))	Yes		P05FBN_BBBRON
52	BAB05	Source number available	decimal	5	2	DEC	((0))	Yes		P05FBN_BABRON
53	BRN06	Source	nvarchar	4	0	CHAR	(N' ')	Yes	*	P05FBN_BRON	Allow NULL?
54	TBB06	Total Amount Source	decimal	9	2	CURR	((0))	Yes		P05FBN_TBBRON
55	TAB06	Total Number Source	decimal	5	2	DEC	((0))	Yes		P05FBN_TABRON
56	BBB06	Source amount available	decimal	9	2	CURR	((0))	Yes		P05FBN_BBBRON
57	BAB06	Source number available	decimal	5	2	DEC	((0))	Yes		P05FBN_BABRON
58	BRN07	Source	nvarchar	4	0	CHAR	(N' ')	Yes	*	P05FBN_BRON	Allow NULL?
59	TBB07	Total Amount Source	decimal	9	2	CURR	((0))	Yes		P05FBN_TBBRON
60	TAB07	Total Number Source	decimal	5	2	DEC	((0))	Yes		P05FBN_TABRON
61	BBB07	Source amount available	decimal	9	2	CURR	((0))	Yes		P05FBN_BBBRON
62	BAB07	Source number available	decimal	5	2	DEC	((0))	Yes		P05FBN_BABRON
63	BRN08	Source	nvarchar	4	0	CHAR	(N' ')	Yes	*	P05FBN_BRON	Allow NULL?
64	TBB08	Total Amount Source	decimal	9	2	CURR	((0))	Yes		P05FBN_TBBRON
65	TAB08	Total Number Source	decimal	5	2	DEC	((0))	Yes		P05FBN_TABRON
66	BBB08	Source amount available	decimal	9	2	CURR	((0))	Yes		P05FBN_BBBRON
67	BAB08	Source number available	decimal	5	2	DEC	((0))	Yes		P05FBN_BABRON
68	DL_01	Note	nvarchar	4	0	CHAR	(N' ')	Yes	*	P05FBN_DOEL	Allow NULL?
69	KZD01	Options	nvarchar	4	0	CHAR	(N' ')	Yes	*	P05FBN_KEUZEDOEL	Allow NULL?
70	TBD01	Total Amount Target	decimal	9	2	CURR	((0))	Yes		P05FBN_TBDOEL
71	TAD01	Total Number Target	decimal	5	2	DEC	((0))	Yes		P05FBN_TADOEL
72	DL_02	Note	nvarchar	4	0	CHAR	(N' ')	Yes	*	P05FBN_DOEL	Allow NULL?
73	KZD02	Options	nvarchar	4	0	CHAR	(N' ')	Yes	*	P05FBN_KEUZEDOEL	Allow NULL?
74	TBD02	Total Amount Target	decimal	9	2	CURR	((0))	Yes		P05FBN_TBDOEL
75	TAD02	Total Number Target	decimal	5	2	DEC	((0))	Yes		P05FBN_TADOEL
76	DL_03	Note	nvarchar	4	0	CHAR	(N' ')	Yes	*	P05FBN_DOEL	Allow NULL?
77	KZD03	Options	nvarchar	4	0	CHAR	(N' ')	Yes	*	P05FBN_KEUZEDOEL	Allow NULL?
78	TBD03	Total Amount Target	decimal	9	2	CURR	((0))	Yes		P05FBN_TBDOEL
79	TAD03	Total Number Target	decimal	5	2	DEC	((0))	Yes		P05FBN_TADOEL
80	DL_04	Note	nvarchar	4	0	CHAR	(N' ')	Yes	*	P05FBN_DOEL	Allow NULL?
81	KZD04	Options	nvarchar	4	0	CHAR	(N' ')	Yes	*	P05FBN_KEUZEDOEL	Allow NULL?
82	TBD04	Total Amount Target	decimal	9	2	CURR	((0))	Yes		P05FBN_TBDOEL
83	TAD04	Total Number Target	decimal	5	2	DEC	((0))	Yes		P05FBN_TADOEL
84	DL_05	Note	nvarchar	4	0	CHAR	(N' ')	Yes	*	P05FBN_DOEL	Allow NULL?
85	KZD05	Options	nvarchar	4	0	CHAR	(N' ')	Yes	*	P05FBN_KEUZEDOEL	Allow NULL?
86	TBD05	Total Amount Target	decimal	9	2	CURR	((0))	Yes		P05FBN_TBDOEL
87	TAD05	Total Number Target	decimal	5	2	DEC	((0))	Yes		P05FBN_TADOEL
88	DL_06	Note	nvarchar	4	0	CHAR	(N' ')	Yes	*	P05FBN_DOEL	Allow NULL?
89	KZD06	Options	nvarchar	4	0	CHAR	(N' ')	Yes	*	P05FBN_KEUZEDOEL	Allow NULL?
90	TBD06	Total Amount Target	decimal	9	2	CURR	((0))	Yes		P05FBN_TBDOEL
91	TAD06	Total Number Target	decimal	5	2	DEC	((0))	Yes		P05FBN_TADOEL
92	DL_07	Note	nvarchar	4	0	CHAR	(N' ')	Yes	*	P05FBN_DOEL	Allow NULL?
93	KZD07	Options	nvarchar	4	0	CHAR	(N' ')	Yes	*	P05FBN_KEUZEDOEL	Allow NULL?
94	TBD07	Total Amount Target	decimal	9	2	CURR	((0))	Yes		P05FBN_TBDOEL
95	TAD07	Total Number Target	decimal	5	2	DEC	((0))	Yes		P05FBN_TADOEL
96	DL_08	Note	nvarchar	4	0	CHAR	(N' ')	Yes	*	P05FBN_DOEL	Allow NULL?
97	KZD08	Options	nvarchar	4	0	CHAR	(N' ')	Yes	*	P05FBN_KEUZEDOEL	Allow NULL?
98	TBD08	Total Amount Target	decimal	9	2	CURR	((0))	Yes		P05FBN_TBDOEL
99	TAD08	Total Number Target	decimal	5	2	DEC	((0))	Yes		P05FBN_TADOEL
100	DL_09	Note	nvarchar	4	0	CHAR	(N' ')	Yes	*	P05FBN_DOEL	Allow NULL?
101	KZD09	Options	nvarchar	4	0	CHAR	(N' ')	Yes	*	P05FBN_KEUZEDOEL	Allow NULL?
102	TBD09	Total Amount Target	decimal	9	2	CURR	((0))	Yes		P05FBN_TBDOEL
103	TAD09	Total Number Target	decimal	5	2	DEC	((0))	Yes		P05FBN_TADOEL
104	DL_10	Note	nvarchar	4	0	CHAR	(N' ')	Yes	*	P05FBN_DOEL	Allow NULL?
105	KZD10	Options	nvarchar	4	0	CHAR	(N' ')	Yes	*	P05FBN_KEUZEDOEL	Allow NULL?
106	TBD10	Total Amount Target	decimal	9	2	CURR	((0))	Yes		P05FBN_TBDOEL
107	TAD10	Total Number Target	decimal	5	2	DEC	((0))	Yes		P05FBN_TADOEL
108	DL_11	Note	nvarchar	4	0	CHAR	(N' ')	Yes	*	P05FBN_DOEL	Allow NULL?
109	KZD11	Options	nvarchar	4	0	CHAR	(N' ')	Yes	*	P05FBN_KEUZEDOEL	Allow NULL?
110	TBD11	Total Amount Target	decimal	9	2	CURR	((0))	Yes		P05FBN_TBDOEL
111	TAD11	Total Number Target	decimal	5	2	DEC	((0))	Yes		P05FBN_TADOEL
112	DL_12	Note	nvarchar	4	0	CHAR	(N' ')	Yes	*	P05FBN_DOEL	Allow NULL?
113	KZD12	Options	nvarchar	4	0	CHAR	(N' ')	Yes	*	P05FBN_KEUZEDOEL	Allow NULL?
114	TBD12	Total Amount Target	decimal	9	2	CURR	((0))	Yes		P05FBN_TBDOEL
115	TAD12	Total Number Target	decimal	5	2	DEC	((0))	Yes		P05FBN_TADOEL
116	B1D01	Source-Target Combination Program Amount	decimal	9	2	CURR	((0))	Yes		P05FBN_KEUZEBEDRAG
117	A1D01	Source-Target Combination Program Number	decimal	5	2	DEC	((0))	Yes		P05FBN_KEUZEAANTAL
118	B1D02	Source-Target Combination Program Amount	decimal	9	2	CURR	((0))	Yes		P05FBN_KEUZEBEDRAG
119	A1D02	Source-Target Combination Program Number	decimal	5	2	DEC	((0))	Yes		P05FBN_KEUZEAANTAL
120	B1D03	Source-Target Combination Program Amount	decimal	9	2	CURR	((0))	Yes		P05FBN_KEUZEBEDRAG
121	A1D03	Source-Target Combination Program Number	decimal	5	2	DEC	((0))	Yes		P05FBN_KEUZEAANTAL
122	B1D04	Source-Target Combination Program Amount	decimal	9	2	CURR	((0))	Yes		P05FBN_KEUZEBEDRAG
123	A1D04	Source-Target Combination Program Number	decimal	5	2	DEC	((0))	Yes		P05FBN_KEUZEAANTAL
124	B1D05	Source-Target Combination Program Amount	decimal	9	2	CURR	((0))	Yes		P05FBN_KEUZEBEDRAG
125	A1D05	Source-Target Combination Program Number	decimal	5	2	DEC	((0))	Yes		P05FBN_KEUZEAANTAL
126	B1D06	Source-Target Combination Program Amount	decimal	9	2	CURR	((0))	Yes		P05FBN_KEUZEBEDRAG
127	A1D06	Source-Target Combination Program Number	decimal	5	2	DEC	((0))	Yes		P05FBN_KEUZEAANTAL
128	B1D07	Source-Target Combination Program Amount	decimal	9	2	CURR	((0))	Yes		P05FBN_KEUZEBEDRAG
129	A1D07	Source-Target Combination Program Number	decimal	5	2	DEC	((0))	Yes		P05FBN_KEUZEAANTAL
130	B1D08	Source-Target Combination Program Amount	decimal	9	2	CURR	((0))	Yes		P05FBN_KEUZEBEDRAG
131	A1D08	Source-Target Combination Program Number	decimal	5	2	DEC	((0))	Yes		P05FBN_KEUZEAANTAL
132	B1D09	Source-Target Combination Program Amount	decimal	9	2	CURR	((0))	Yes		P05FBN_KEUZEBEDRAG
133	A1D09	Source-Target Combination Program Number	decimal	5	2	DEC	((0))	Yes		P05FBN_KEUZEAANTAL
134	B1D10	Source-Target Combination Program Amount	decimal	9	2	CURR	((0))	Yes		P05FBN_KEUZEBEDRAG
135	A1D10	Source-Target Combination Program Number	decimal	5	2	DEC	((0))	Yes		P05FBN_KEUZEAANTAL
136	B1D11	Source-Target Combination Program Amount	decimal	9	2	CURR	((0))	Yes		P05FBN_KEUZEBEDRAG
137	A1D11	Source-Target Combination Program Number	decimal	5	2	DEC	((0))	Yes		P05FBN_KEUZEAANTAL
138	B1D12	Source-Target Combination Program Amount	decimal	9	2	CURR	((0))	Yes		P05FBN_KEUZEBEDRAG
139	A1D12	Source-Target Combination Program Number	decimal	5	2	DEC	((0))	Yes		P05FBN_KEUZEAANTAL
140	B2D01	Source-Target Combination Program Amount	decimal	9	2	CURR	((0))	Yes		P05FBN_KEUZEBEDRAG
141	A2D01	Source-Target Combination Program Number	decimal	5	2	DEC	((0))	Yes		P05FBN_KEUZEAANTAL
142	B2D02	Source-Target Combination Program Amount	decimal	9	2	CURR	((0))	Yes		P05FBN_KEUZEBEDRAG
143	A2D02	Source-Target Combination Program Number	decimal	5	2	DEC	((0))	Yes		P05FBN_KEUZEAANTAL
144	B2D03	Source-Target Combination Program Amount	decimal	9	2	CURR	((0))	Yes		P05FBN_KEUZEBEDRAG
145	A2D03	Source-Target Combination Program Number	decimal	5	2	DEC	((0))	Yes		P05FBN_KEUZEAANTAL
146	B2D04	Source-Target Combination Program Amount	decimal	9	2	CURR	((0))	Yes		P05FBN_KEUZEBEDRAG
147	A2D04	Source-Target Combination Program Number	decimal	5	2	DEC	((0))	Yes		P05FBN_KEUZEAANTAL
148	B2D05	Source-Target Combination Program Amount	decimal	9	2	CURR	((0))	Yes		P05FBN_KEUZEBEDRAG
149	A2D05	Source-Target Combination Program Number	decimal	5	2	DEC	((0))	Yes		P05FBN_KEUZEAANTAL
150	B2D06	Source-Target Combination Program Amount	decimal	9	2	CURR	((0))	Yes		P05FBN_KEUZEBEDRAG
151	A2D06	Source-Target Combination Program Number	decimal	5	2	DEC	((0))	Yes		P05FBN_KEUZEAANTAL
152	B2D07	Source-Target Combination Program Amount	decimal	9	2	CURR	((0))	Yes		P05FBN_KEUZEBEDRAG
153	A2D07	Source-Target Combination Program Number	decimal	5	2	DEC	((0))	Yes		P05FBN_KEUZEAANTAL
154	B2D08	Source-Target Combination Program Amount	decimal	9	2	CURR	((0))	Yes		P05FBN_KEUZEBEDRAG
155	A2D08	Source-Target Combination Program Number	decimal	5	2	DEC	((0))	Yes		P05FBN_KEUZEAANTAL
156	B2D09	Source-Target Combination Program Amount	decimal	9	2	CURR	((0))	Yes		P05FBN_KEUZEBEDRAG
157	A2D09	Source-Target Combination Program Number	decimal	5	2	DEC	((0))	Yes		P05FBN_KEUZEAANTAL
158	B2D10	Source-Target Combination Program Amount	decimal	9	2	CURR	((0))	Yes		P05FBN_KEUZEBEDRAG
159	A2D10	Source-Target Combination Program Number	decimal	5	2	DEC	((0))	Yes		P05FBN_KEUZEAANTAL
160	B2D11	Source-Target Combination Program Amount	decimal	9	2	CURR	((0))	Yes		P05FBN_KEUZEBEDRAG
161	A2D11	Source-Target Combination Program Number	decimal	5	2	DEC	((0))	Yes		P05FBN_KEUZEAANTAL
162	B2D12	Source-Target Combination Program Amount	decimal	9	2	CURR	((0))	Yes		P05FBN_KEUZEBEDRAG
163	A2D12	Source-Target Combination Program Number	decimal	5	2	DEC	((0))	Yes		P05FBN_KEUZEAANTAL
164	B3D01	Source-Target Combination Program Amount	decimal	9	2	CURR	((0))	Yes		P05FBN_KEUZEBEDRAG
165	A3D01	Source-Target Combination Program Number	decimal	5	2	DEC	((0))	Yes		P05FBN_KEUZEAANTAL
166	B3D02	Source-Target Combination Program Amount	decimal	9	2	CURR	((0))	Yes		P05FBN_KEUZEBEDRAG
167	A3D02	Source-Target Combination Program Number	decimal	5	2	DEC	((0))	Yes		P05FBN_KEUZEAANTAL
168	B3D03	Source-Target Combination Program Amount	decimal	9	2	CURR	((0))	Yes		P05FBN_KEUZEBEDRAG
169	A3D03	Source-Target Combination Program Number	decimal	5	2	DEC	((0))	Yes		P05FBN_KEUZEAANTAL
170	B3D04	Source-Target Combination Program Amount	decimal	9	2	CURR	((0))	Yes		P05FBN_KEUZEBEDRAG
171	A3D04	Source-Target Combination Program Number	decimal	5	2	DEC	((0))	Yes		P05FBN_KEUZEAANTAL
172	B3D05	Source-Target Combination Program Amount	decimal	9	2	CURR	((0))	Yes		P05FBN_KEUZEBEDRAG
173	A3D05	Source-Target Combination Program Number	decimal	5	2	DEC	((0))	Yes		P05FBN_KEUZEAANTAL
174	B3D06	Source-Target Combination Program Amount	decimal	9	2	CURR	((0))	Yes		P05FBN_KEUZEBEDRAG
175	A3D06	Source-Target Combination Program Number	decimal	5	2	DEC	((0))	Yes		P05FBN_KEUZEAANTAL
176	B3D07	Source-Target Combination Program Amount	decimal	9	2	CURR	((0))	Yes		P05FBN_KEUZEBEDRAG
177	A3D07	Source-Target Combination Program Number	decimal	5	2	DEC	((0))	Yes		P05FBN_KEUZEAANTAL
178	B3D08	Source-Target Combination Program Amount	decimal	9	2	CURR	((0))	Yes		P05FBN_KEUZEBEDRAG
179	A3D08	Source-Target Combination Program Number	decimal	5	2	DEC	((0))	Yes		P05FBN_KEUZEAANTAL
180	B3D09	Source-Target Combination Program Amount	decimal	9	2	CURR	((0))	Yes		P05FBN_KEUZEBEDRAG
181	A3D09	Source-Target Combination Program Number	decimal	5	2	DEC	((0))	Yes		P05FBN_KEUZEAANTAL
182	B3D10	Source-Target Combination Program Amount	decimal	9	2	CURR	((0))	Yes		P05FBN_KEUZEBEDRAG
183	A3D10	Source-Target Combination Program Number	decimal	5	2	DEC	((0))	Yes		P05FBN_KEUZEAANTAL
184	B3D11	Source-Target Combination Program Amount	decimal	9	2	CURR	((0))	Yes		P05FBN_KEUZEBEDRAG
185	A3D11	Source-Target Combination Program Number	decimal	5	2	DEC	((0))	Yes		P05FBN_KEUZEAANTAL
186	B3D12	Source-Target Combination Program Amount	decimal	9	2	CURR	((0))	Yes		P05FBN_KEUZEBEDRAG
187	A3D12	Source-Target Combination Program Number	decimal	5	2	DEC	((0))	Yes		P05FBN_KEUZEAANTAL
188	B4D01	Source-Target Combination Program Amount	decimal	9	2	CURR	((0))	Yes		P05FBN_KEUZEBEDRAG
189	A4D01	Source-Target Combination Program Number	decimal	5	2	DEC	((0))	Yes		P05FBN_KEUZEAANTAL
190	B4D02	Source-Target Combination Program Amount	decimal	9	2	CURR	((0))	Yes		P05FBN_KEUZEBEDRAG
191	A4D02	Source-Target Combination Program Number	decimal	5	2	DEC	((0))	Yes		P05FBN_KEUZEAANTAL
192	B4D03	Source-Target Combination Program Amount	decimal	9	2	CURR	((0))	Yes		P05FBN_KEUZEBEDRAG
193	A4D03	Source-Target Combination Program Number	decimal	5	2	DEC	((0))	Yes		P05FBN_KEUZEAANTAL
194	B4D04	Source-Target Combination Program Amount	decimal	9	2	CURR	((0))	Yes		P05FBN_KEUZEBEDRAG
195	A4D04	Source-Target Combination Program Number	decimal	5	2	DEC	((0))	Yes		P05FBN_KEUZEAANTAL
196	B4D05	Source-Target Combination Program Amount	decimal	9	2	CURR	((0))	Yes		P05FBN_KEUZEBEDRAG
197	A4D05	Source-Target Combination Program Number	decimal	5	2	DEC	((0))	Yes		P05FBN_KEUZEAANTAL
198	B4D06	Source-Target Combination Program Amount	decimal	9	2	CURR	((0))	Yes		P05FBN_KEUZEBEDRAG
199	A4D06	Source-Target Combination Program Number	decimal	5	2	DEC	((0))	Yes		P05FBN_KEUZEAANTAL
200	B4D07	Source-Target Combination Program Amount	decimal	9	2	CURR	((0))	Yes		P05FBN_KEUZEBEDRAG
201	A4D07	Source-Target Combination Program Number	decimal	5	2	DEC	((0))	Yes		P05FBN_KEUZEAANTAL
202	B4D08	Source-Target Combination Program Amount	decimal	9	2	CURR	((0))	Yes		P05FBN_KEUZEBEDRAG
203	A4D08	Source-Target Combination Program Number	decimal	5	2	DEC	((0))	Yes		P05FBN_KEUZEAANTAL
204	B4D09	Source-Target Combination Program Amount	decimal	9	2	CURR	((0))	Yes		P05FBN_KEUZEBEDRAG
205	A4D09	Source-Target Combination Program Number	decimal	5	2	DEC	((0))	Yes		P05FBN_KEUZEAANTAL
206	B4D10	Source-Target Combination Program Amount	decimal	9	2	CURR	((0))	Yes		P05FBN_KEUZEBEDRAG
207	A4D10	Source-Target Combination Program Number	decimal	5	2	DEC	((0))	Yes		P05FBN_KEUZEAANTAL
208	B4D11	Source-Target Combination Program Amount	decimal	9	2	CURR	((0))	Yes		P05FBN_KEUZEBEDRAG
209	A4D11	Source-Target Combination Program Number	decimal	5	2	DEC	((0))	Yes		P05FBN_KEUZEAANTAL
210	B4D12	Source-Target Combination Program Amount	decimal	9	2	CURR	((0))	Yes		P05FBN_KEUZEBEDRAG
211	A4D12	Source-Target Combination Program Number	decimal	5	2	DEC	((0))	Yes		P05FBN_KEUZEAANTAL
212	B5D01	Source-Target Combination Program Amount	decimal	9	2	CURR	((0))	Yes		P05FBN_KEUZEBEDRAG
213	A5D01	Source-Target Combination Program Number	decimal	5	2	DEC	((0))	Yes		P05FBN_KEUZEAANTAL
214	B5D02	Source-Target Combination Program Amount	decimal	9	2	CURR	((0))	Yes		P05FBN_KEUZEBEDRAG
215	A5D02	Source-Target Combination Program Number	decimal	5	2	DEC	((0))	Yes		P05FBN_KEUZEAANTAL
216	B5D03	Source-Target Combination Program Amount	decimal	9	2	CURR	((0))	Yes		P05FBN_KEUZEBEDRAG
217	A5D03	Source-Target Combination Program Number	decimal	5	2	DEC	((0))	Yes		P05FBN_KEUZEAANTAL
218	B5D04	Source-Target Combination Program Amount	decimal	9	2	CURR	((0))	Yes		P05FBN_KEUZEBEDRAG
219	A5D04	Source-Target Combination Program Number	decimal	5	2	DEC	((0))	Yes		P05FBN_KEUZEAANTAL
220	B5D05	Source-Target Combination Program Amount	decimal	9	2	CURR	((0))	Yes		P05FBN_KEUZEBEDRAG
221	A5D05	Source-Target Combination Program Number	decimal	5	2	DEC	((0))	Yes		P05FBN_KEUZEAANTAL
222	B5D06	Source-Target Combination Program Amount	decimal	9	2	CURR	((0))	Yes		P05FBN_KEUZEBEDRAG
223	A5D06	Source-Target Combination Program Number	decimal	5	2	DEC	((0))	Yes		P05FBN_KEUZEAANTAL
224	B5D07	Source-Target Combination Program Amount	decimal	9	2	CURR	((0))	Yes		P05FBN_KEUZEBEDRAG
225	A5D07	Source-Target Combination Program Number	decimal	5	2	DEC	((0))	Yes		P05FBN_KEUZEAANTAL
226	B5D08	Source-Target Combination Program Amount	decimal	9	2	CURR	((0))	Yes		P05FBN_KEUZEBEDRAG
227	A5D08	Source-Target Combination Program Number	decimal	5	2	DEC	((0))	Yes		P05FBN_KEUZEAANTAL
228	B5D09	Source-Target Combination Program Amount	decimal	9	2	CURR	((0))	Yes		P05FBN_KEUZEBEDRAG
229	A5D09	Source-Target Combination Program Number	decimal	5	2	DEC	((0))	Yes		P05FBN_KEUZEAANTAL
230	B5D10	Source-Target Combination Program Amount	decimal	9	2	CURR	((0))	Yes		P05FBN_KEUZEBEDRAG
231	A5D10	Source-Target Combination Program Number	decimal	5	2	DEC	((0))	Yes		P05FBN_KEUZEAANTAL
232	B5D11	Source-Target Combination Program Amount	decimal	9	2	CURR	((0))	Yes		P05FBN_KEUZEBEDRAG
233	A5D11	Source-Target Combination Program Number	decimal	5	2	DEC	((0))	Yes		P05FBN_KEUZEAANTAL
234	B5D12	Source-Target Combination Program Amount	decimal	9	2	CURR	((0))	Yes		P05FBN_KEUZEBEDRAG
235	A5D12	Source-Target Combination Program Number	decimal	5	2	DEC	((0))	Yes		P05FBN_KEUZEAANTAL
236	B6D01	Source-Target Combination Program Amount	decimal	9	2	CURR	((0))	Yes		P05FBN_KEUZEBEDRAG
237	A6D01	Source-Target Combination Program Number	decimal	5	2	DEC	((0))	Yes		P05FBN_KEUZEAANTAL
238	B6D02	Source-Target Combination Program Amount	decimal	9	2	CURR	((0))	Yes		P05FBN_KEUZEBEDRAG
239	A6D02	Source-Target Combination Program Number	decimal	5	2	DEC	((0))	Yes		P05FBN_KEUZEAANTAL
240	B6D03	Source-Target Combination Program Amount	decimal	9	2	CURR	((0))	Yes		P05FBN_KEUZEBEDRAG
241	A6D03	Source-Target Combination Program Number	decimal	5	2	DEC	((0))	Yes		P05FBN_KEUZEAANTAL
242	B6D04	Source-Target Combination Program Amount	decimal	9	2	CURR	((0))	Yes		P05FBN_KEUZEBEDRAG
243	A6D04	Source-Target Combination Program Number	decimal	5	2	DEC	((0))	Yes		P05FBN_KEUZEAANTAL
244	B6D05	Source-Target Combination Program Amount	decimal	9	2	CURR	((0))	Yes		P05FBN_KEUZEBEDRAG
245	A6D05	Source-Target Combination Program Number	decimal	5	2	DEC	((0))	Yes		P05FBN_KEUZEAANTAL
246	B6D06	Source-Target Combination Program Amount	decimal	9	2	CURR	((0))	Yes		P05FBN_KEUZEBEDRAG
247	A6D06	Source-Target Combination Program Number	decimal	5	2	DEC	((0))	Yes		P05FBN_KEUZEAANTAL
248	B6D07	Source-Target Combination Program Amount	decimal	9	2	CURR	((0))	Yes		P05FBN_KEUZEBEDRAG
249	A6D07	Source-Target Combination Program Number	decimal	5	2	DEC	((0))	Yes		P05FBN_KEUZEAANTAL
250	B6D08	Source-Target Combination Program Amount	decimal	9	2	CURR	((0))	Yes		P05FBN_KEUZEBEDRAG
251	A6D08	Source-Target Combination Program Number	decimal	5	2	DEC	((0))	Yes		P05FBN_KEUZEAANTAL
252	B6D09	Source-Target Combination Program Amount	decimal	9	2	CURR	((0))	Yes		P05FBN_KEUZEBEDRAG
253	A6D09	Source-Target Combination Program Number	decimal	5	2	DEC	((0))	Yes		P05FBN_KEUZEAANTAL
254	B6D10	Source-Target Combination Program Amount	decimal	9	2	CURR	((0))	Yes		P05FBN_KEUZEBEDRAG
255	A6D10	Source-Target Combination Program Number	decimal	5	2	DEC	((0))	Yes		P05FBN_KEUZEAANTAL
256	B6D11	Source-Target Combination Program Amount	decimal	9	2	CURR	((0))	Yes		P05FBN_KEUZEBEDRAG
257	A6D11	Source-Target Combination Program Number	decimal	5	2	DEC	((0))	Yes		P05FBN_KEUZEAANTAL
258	B6D12	Source-Target Combination Program Amount	decimal	9	2	CURR	((0))	Yes		P05FBN_KEUZEBEDRAG
259	A6D12	Source-Target Combination Program Number	decimal	5	2	DEC	((0))	Yes		P05FBN_KEUZEAANTAL
260	B7D01	Source-Target Combination Program Amount	decimal	9	2	CURR	((0))	Yes		P05FBN_KEUZEBEDRAG
261	A7D01	Source-Target Combination Program Number	decimal	5	2	DEC	((0))	Yes		P05FBN_KEUZEAANTAL
262	B7D02	Source-Target Combination Program Amount	decimal	9	2	CURR	((0))	Yes		P05FBN_KEUZEBEDRAG
263	A7D02	Source-Target Combination Program Number	decimal	5	2	DEC	((0))	Yes		P05FBN_KEUZEAANTAL
264	B7D03	Source-Target Combination Program Amount	decimal	9	2	CURR	((0))	Yes		P05FBN_KEUZEBEDRAG
265	A7D03	Source-Target Combination Program Number	decimal	5	2	DEC	((0))	Yes		P05FBN_KEUZEAANTAL
266	B7D04	Source-Target Combination Program Amount	decimal	9	2	CURR	((0))	Yes		P05FBN_KEUZEBEDRAG
267	A7D04	Source-Target Combination Program Number	decimal	5	2	DEC	((0))	Yes		P05FBN_KEUZEAANTAL
268	B7D05	Source-Target Combination Program Amount	decimal	9	2	CURR	((0))	Yes		P05FBN_KEUZEBEDRAG
269	A7D05	Source-Target Combination Program Number	decimal	5	2	DEC	((0))	Yes		P05FBN_KEUZEAANTAL
270	B7D06	Source-Target Combination Program Amount	decimal	9	2	CURR	((0))	Yes		P05FBN_KEUZEBEDRAG
271	A7D06	Source-Target Combination Program Number	decimal	5	2	DEC	((0))	Yes		P05FBN_KEUZEAANTAL
272	B7D07	Source-Target Combination Program Amount	decimal	9	2	CURR	((0))	Yes		P05FBN_KEUZEBEDRAG
273	A7D07	Source-Target Combination Program Number	decimal	5	2	DEC	((0))	Yes		P05FBN_KEUZEAANTAL
274	B7D08	Source-Target Combination Program Amount	decimal	9	2	CURR	((0))	Yes		P05FBN_KEUZEBEDRAG
275	A7D08	Source-Target Combination Program Number	decimal	5	2	DEC	((0))	Yes		P05FBN_KEUZEAANTAL
276	B7D09	Source-Target Combination Program Amount	decimal	9	2	CURR	((0))	Yes		P05FBN_KEUZEBEDRAG
277	A7D09	Source-Target Combination Program Number	decimal	5	2	DEC	((0))	Yes		P05FBN_KEUZEAANTAL
278	B7D10	Source-Target Combination Program Amount	decimal	9	2	CURR	((0))	Yes		P05FBN_KEUZEBEDRAG
279	A7D10	Source-Target Combination Program Number	decimal	5	2	DEC	((0))	Yes		P05FBN_KEUZEAANTAL
280	B7D11	Source-Target Combination Program Amount	decimal	9	2	CURR	((0))	Yes		P05FBN_KEUZEBEDRAG
281	A7D11	Source-Target Combination Program Number	decimal	5	2	DEC	((0))	Yes		P05FBN_KEUZEAANTAL
282	B7D12	Source-Target Combination Program Amount	decimal	9	2	CURR	((0))	Yes		P05FBN_KEUZEBEDRAG
283	A7D12	Source-Target Combination Program Number	decimal	5	2	DEC	((0))	Yes		P05FBN_KEUZEAANTAL
284	B8D01	Source-Target Combination Program Amount	decimal	9	2	CURR	((0))	Yes		P05FBN_KEUZEBEDRAG
285	A8D01	Source-Target Combination Program Number	decimal	5	2	DEC	((0))	Yes		P05FBN_KEUZEAANTAL
286	B8D02	Source-Target Combination Program Amount	decimal	9	2	CURR	((0))	Yes		P05FBN_KEUZEBEDRAG
287	A8D02	Source-Target Combination Program Number	decimal	5	2	DEC	((0))	Yes		P05FBN_KEUZEAANTAL
288	B8D03	Source-Target Combination Program Amount	decimal	9	2	CURR	((0))	Yes		P05FBN_KEUZEBEDRAG
289	A8D03	Source-Target Combination Program Number	decimal	5	2	DEC	((0))	Yes		P05FBN_KEUZEAANTAL
290	B8D04	Source-Target Combination Program Amount	decimal	9	2	CURR	((0))	Yes		P05FBN_KEUZEBEDRAG
291	A8D04	Source-Target Combination Program Number	decimal	5	2	DEC	((0))	Yes		P05FBN_KEUZEAANTAL
292	B8D05	Source-Target Combination Program Amount	decimal	9	2	CURR	((0))	Yes		P05FBN_KEUZEBEDRAG
293	A8D05	Source-Target Combination Program Number	decimal	5	2	DEC	((0))	Yes		P05FBN_KEUZEAANTAL
294	B8D06	Source-Target Combination Program Amount	decimal	9	2	CURR	((0))	Yes		P05FBN_KEUZEBEDRAG
295	A8D06	Source-Target Combination Program Number	decimal	5	2	DEC	((0))	Yes		P05FBN_KEUZEAANTAL
296	B8D07	Source-Target Combination Program Amount	decimal	9	2	CURR	((0))	Yes		P05FBN_KEUZEBEDRAG
297	A8D07	Source-Target Combination Program Number	decimal	5	2	DEC	((0))	Yes		P05FBN_KEUZEAANTAL
298	B8D08	Source-Target Combination Program Amount	decimal	9	2	CURR	((0))	Yes		P05FBN_KEUZEBEDRAG
299	A8D08	Source-Target Combination Program Number	decimal	5	2	DEC	((0))	Yes		P05FBN_KEUZEAANTAL
300	B8D09	Source-Target Combination Program Amount	decimal	9	2	CURR	((0))	Yes		P05FBN_KEUZEBEDRAG
301	A8D09	Source-Target Combination Program Number	decimal	5	2	DEC	((0))	Yes		P05FBN_KEUZEAANTAL
302	B8D10	Source-Target Combination Program Amount	decimal	9	2	CURR	((0))	Yes		P05FBN_KEUZEBEDRAG
303	A8D10	Source-Target Combination Program Number	decimal	5	2	DEC	((0))	Yes		P05FBN_KEUZEAANTAL
304	B8D11	Source-Target Combination Program Amount	decimal	9	2	CURR	((0))	Yes		P05FBN_KEUZEBEDRAG
305	A8D11	Source-Target Combination Program Number	decimal	5	2	DEC	((0))	Yes		P05FBN_KEUZEAANTAL
306	B8D12	Source-Target Combination Program Amount	decimal	9	2	CURR	((0))	Yes		P05FBN_KEUZEBEDRAG
307	A8D12	Source-Target Combination Program Number	decimal	5	2	DEC	((0))	Yes		P05FBN_KEUZEAANTAL
308	EVENT	Adjustment Reason	nvarchar	4	0	CHAR	(N' ')	Yes	*	P05FBN_EVENT	Allow NULL?

TOP ERP 6.0 | PA0897 INDEXES

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

308 COLUMNS | 1 INDEXES | ERP 6.0 | PA0897 TABLE

TOP ERP 6.0 | PA0897 COLUMNS

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

308 COLUMNS | 1 INDEXES | ERP 6.0 | PA0897 TABLE

TOPERP 6.0 | PA0897 COLUMNS

TOPERP 6.0 | PA0897 INDEXES

TOP ERP 6.0 | PA0897 COLUMNS

TOP ERP 6.0 | PA0897 INDEXES