	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	/ISDFPS/CHVW_E	34	External Batch Where-Used List
7	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	BSEG	345	Accounting Document Segment
10	FMARCPAR	4	Parallelization of FMARC_BATCH

	Table	Columns	Description
1	OITM	299	Items
2	OINV	386	A/R Invoice
3	OCRD	332	Business Partner
4	ORDR	386	Sales Order
5	OJDT	100	Journal Entry
6	INV1	265	A/R Invoice - Rows
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	OINM	101	Whse Journal
10	OSRN	20	Serial Numbers Master Data

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