ERP 6.0: Top 10 requests

	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

B1 9.2: Top 10 requests

	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	JDT1	124	Journal Entry - Rows
9	OPOR	386	Purchase Order
10	OVTG	52	Tax Definition

B1 8.8: Top 10 requests

	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

	Product	Version	Table	Columns	Indexes	Description	Module
Production Planning and Control :: Production Orders :: Order Processing :: Confirmations
1	ERP EHP7	6.0	AFRV	187	1	Confirmation pool	Confirmations

Column	Field	Description	SQL Type	Length	Decimals	SQL Create Statement
1	CLIENT	Client	nvarchar	3	0	Allow NULL?
2	AFORI	Origin Indicator of PDC Message (Application)	char	1	0	Allow NULL?
3	AFRUV	Confirmation pool	nvarchar	20	0	Allow NULL?
4	COUNTER	Internal counter	nvarchar	8	0	Allow NULL?
5	VTEXT	Operation short text	nvarchar	40	0	Allow NULL?
6	BEAKNZ	Indicator: Entry in pool was confirmed	char	1	0	Allow NULL?
7	PDSNR	Sequential number for PDC messages	nvarchar	12	0	Allow NULL?
8	PERNR	Personnel Number	nvarchar	8	0	Allow NULL?
9	INFTY	Infotype	nvarchar	4	0	Allow NULL?
10	SUBTY	Subtype	nvarchar	4	0	Allow NULL?
11	OBJPS	Character field, length 2	nvarchar	2	0	Allow NULL?
12	SPRPS	Single-Character Indicator	char	1	0	Allow NULL?
13	ENDDA	End Date	nvarchar	8	0	Allow NULL?
14	BEGDA	Start Date	nvarchar	8	0	Allow NULL?
15	SEQNR	Number of Infotype Record with Same Key	nvarchar	3	0	Allow NULL?
16	BUKRS	Company Code	nvarchar	4	0	Allow NULL?
17	GSBER	Business Area	nvarchar	4	0	Allow NULL?
18	KOKRS	Controlling Area	nvarchar	4	0	Allow NULL?
19	KOSTL	Cost Center	nvarchar	10	0	Allow NULL?
20	AUFNR	Order Number	nvarchar	12	0	Allow NULL?
21	KSTRG	Cost Object	nvarchar	12	0	Allow NULL?
22	POSNR	Work Breakdown Structure Element (WBS Element)	nvarchar	8	0	Allow NULL?
23	NPLNR	Network Number for Account Assignment	nvarchar	12	0	Allow NULL?
24	VORNR	Operation/Activity Number	nvarchar	4	0	Allow NULL?
25	KDAUF	Sales Order Number	nvarchar	10	0	Allow NULL?
26	KDPOS	Item Number in Sales Order	nvarchar	6	0	Allow NULL?
27	PAOBJNR	Profitability Segment Number (CO-PA)	nvarchar	10	0	Allow NULL?
28	PRZNR	Business Process	nvarchar	12	0	Allow NULL?
29	FISTL	Funds Center	nvarchar	16	0	Allow NULL?
30	FIPOS	Commitment Item	nvarchar	14	0	Allow NULL?
31	GEBER	Fund	nvarchar	10	0	Allow NULL?
32	EBELN	Purchasing Document Number	nvarchar	10	0	Allow NULL?
33	EBELP	Item Number of Purchasing Document	nvarchar	5	0	Allow NULL?
34	LSTNR	Activity Number	nvarchar	18	0	Allow NULL?
35	LTLST	Activity Type	nvarchar	6	0	Allow NULL?
36	SBUKR	Company Code	nvarchar	4	0	Allow NULL?
37	SGSBR	Business Area	nvarchar	4	0	Allow NULL?
38	SKOST	Cost Center	nvarchar	10	0	Allow NULL?
39	LSTAR	Activity Type	nvarchar	6	0	Allow NULL?
40	EXBEL	Field length 18	nvarchar	18	0	Allow NULL?
41	MWSKZ	Tax on sales/purchases code	nvarchar	2	0	Allow NULL?
42	OTYPE	Object Type	nvarchar	2	0	Allow NULL?
43	STELL	Job	nvarchar	8	0	Allow NULL?
44	POHRS	Number of Hours for Activity Allocation/External Services	decimal	7	2
45	DART	Character field, length 2	nvarchar	2	0	Allow NULL?
46	UDART	Character field, length 2	nvarchar	2	0	Allow NULL?
47	SGTXT	Item Text	nvarchar	50	0	Allow NULL?
48	TXJCD	Tax Jurisdiction	nvarchar	15	0	Allow NULL?
49	LDATE	Entry Date	nvarchar	8	0	Allow NULL?
50	LTIME	Time received	nvarchar	6	0	Allow NULL?
51	ERDAT	Created on	nvarchar	8	0	Allow NULL?
52	ERTIM	Created at	nvarchar	6	0	Allow NULL?
53	SATZA	Time Event Type	nvarchar	3	0	Allow NULL?
54	TERID	Terminal ID	nvarchar	4	0	Allow NULL?
55	ABWGR	Not More Closely Defined Area, Possibly Used for Patchlevels	nvarchar	4	0	Allow NULL?
56	EXLGA	Not More Closely Defined Area, Possibly Used for Patchlevels	nvarchar	4	0	Allow NULL?
57	ZEINH	3-Byte field	nvarchar	3	0	Allow NULL?
58	HRAZL	Decimal field of length 7	decimal	7	2
59	HRBET	Currency amount, field length 9	decimal	9	2
60	ORIGF	Origin Indicator of PDC Message	char	1	0	Allow NULL?
61	DALLF	Single-Character Indicator	char	1	0	Allow NULL?
62	PDC_OTYPE	Object Type	nvarchar	2	0	Allow NULL?
63	PDC_PLANS	Position	nvarchar	8	0	Allow NULL?
64	PDC_USRUP	Customer-Specific Field	nvarchar	20	0	Allow NULL?
65	REFEX	Single-Character Indicator	char	1	0	Allow NULL?
66	ORDEX	Single-Character Indicator	char	1	0	Allow NULL?
67	ZAUSW	Time Recording ID Number	nvarchar	8	0	Allow NULL?
68	ORIND	Origin Indicator of PDC Message (Application)	char	1	0	Allow NULL?
69	INDEU	Insert/delete or update indicator	char	1	0	Allow NULL?
70	RUECK	Completion confirmation number for the operation	nvarchar	10	0	Allow NULL?
71	SPLIT	Split number	tinyint	3	0
72	RMZHL	Confirmation counter	nvarchar	8	0	Allow NULL?
73	BUDAT	Posting date	nvarchar	8	0	Allow NULL?
74	WERKS	Plant	nvarchar	4	0	Allow NULL?
75	ARBPL	Work center	nvarchar	8	0	Allow NULL?
76	KAPAR	Capacity category	nvarchar	3	0	Allow NULL?
77	LTXA1	Confirmation text	nvarchar	40	0	Allow NULL?
78	ISERH	Confirmed break time	decimal	9	3
79	ZEIER	Unit for the break time	nvarchar	3	0	Allow NULL?
80	ILE01	Unit of measure for the activity to be confirmed	nvarchar	3	0	Allow NULL?
81	ISM01	Activity currently to be confirmed	decimal	13	3
82	OFM01	Forecast value used to update the standard value	decimal	9	3
83	OFE01	Unit of measure for the standard value	nvarchar	3	0	Allow NULL?
84	LEK01	Indicator: No remaining activity expected	char	1	0	Allow NULL?
85	ILE02	Unit of measure for the activity to be confirmed	nvarchar	3	0	Allow NULL?
86	ISM02	Activity currently to be confirmed	decimal	13	3
87	OFM02	Forecast value used to update the standard value	decimal	9	3
88	OFE02	Unit of measure for the standard value	nvarchar	3	0	Allow NULL?
89	LEK02	Indicator: No remaining activity expected	char	1	0	Allow NULL?
90	ILE03	Unit of measure for the activity to be confirmed	nvarchar	3	0	Allow NULL?
91	ISM03	Activity currently to be confirmed	decimal	13	3
92	OFM03	Forecast value used to update the standard value	decimal	9	3
93	OFE03	Unit of measure for the standard value	nvarchar	3	0	Allow NULL?
94	LEK03	Indicator: No remaining activity expected	char	1	0	Allow NULL?
95	ILE04	Unit of measure for the activity to be confirmed	nvarchar	3	0	Allow NULL?
96	ISM04	Activity currently to be confirmed	decimal	13	3
97	OFM04	Forecast value used to update the standard value	decimal	9	3
98	OFE04	Unit of measure for the standard value	nvarchar	3	0	Allow NULL?
99	LEK04	Indicator: No remaining activity expected	char	1	0	Allow NULL?
100	ILE05	Unit of measure for the activity to be confirmed	nvarchar	3	0	Allow NULL?
101	ISM05	Activity currently to be confirmed	decimal	13	3
102	OFM05	Forecast value used to update the standard value	decimal	9	3
103	OFE05	Unit of measure for the standard value	nvarchar	3	0	Allow NULL?
104	LEK05	Indicator: No remaining activity expected	char	1	0	Allow NULL?
105	ILE06	Unit of measure for the activity to be confirmed	nvarchar	3	0	Allow NULL?
106	ISM06	Activity currently to be confirmed	decimal	13	3
107	OFM06	Forecast value used to update the standard value	decimal	9	3
108	OFE06	Unit of measure for the standard value	nvarchar	3	0	Allow NULL?
109	LEK06	Indicator: No remaining activity expected	char	1	0	Allow NULL?
110	ISMNW	Actual work	decimal	7	1
111	ISMNE	Unit for work	nvarchar	3	0	Allow NULL?
112	LEARR	Activity Type for Confirmation	nvarchar	6	0	Allow NULL?
113	OFMNW	Remaining work	decimal	7	1
114	OFMNE	Unit of measure for remaining work	nvarchar	3	0	Allow NULL?
115	LEKNW	Indicator: No Remaining Work Expected	char	1	0	Allow NULL?
116	ABARB	Confirmation: Degree of processing	nvarchar	3	0	Allow NULL?
117	IDAUR	Actual Duration for Confirmation	decimal	5	1
118	IDAUE	Unit for actual duration	nvarchar	3	0	Allow NULL?
119	ODAUR	Remaining duration of activity	decimal	5	1
120	ODAUE	Unit for remaining duration	nvarchar	3	0	Allow NULL?
121	LOART	Wage Type	nvarchar	4	0	Allow NULL?
122	QUALF	Suitability	nvarchar	2	0	Allow NULL?
123	ANZMA	Number of employees	decimal	5	2
124	LOGRP	Wage group	nvarchar	3	0	Allow NULL?
125	LMNGA	Yield to Be Confirmed	decimal	13	3
126	XMNGA	Scrap to Be Confirmed	decimal	13	3
127	MEINH	Confirmation unit of measure	nvarchar	3	0	Allow NULL?
128	GRUND	Reason for Variance	nvarchar	4	0	Allow NULL?
129	ISDD	Confirmed date for start of execution	nvarchar	8	0	Allow NULL?
130	ISDZ	Confirmed time for 'Execution start'	nvarchar	6	0	Allow NULL?
131	IERD	Confirmed date for 'Setup finish'	nvarchar	8	0	Allow NULL?
132	IERZ	Confirmed time for 'Setup finish'	nvarchar	6	0	Allow NULL?
133	ISBD	Confirmed date for 'Processing start'	nvarchar	8	0	Allow NULL?
134	ISBZ	Confirmed time for 'Processing start'	nvarchar	6	0	Allow NULL?
135	IEBD	Confirmed date for 'processing finish'	nvarchar	8	0	Allow NULL?
136	IEBZ	Confirmed time for 'processing finish'	nvarchar	6	0	Allow NULL?
137	ISAD	Confirmed date for 'teardown start'	nvarchar	8	0	Allow NULL?
138	ISAZ	Confirmed time for 'teardown start'	nvarchar	6	0	Allow NULL?
139	IEDD	Confirmed date for execution finish	nvarchar	8	0	Allow NULL?
140	IEDZ	Confirmed time for 'Execution finish'	nvarchar	6	0	Allow NULL?
141	PEDD	Forecast finish date of operation from confirmation	nvarchar	8	0	Allow NULL?
142	PEDZ	Forecast finish time of operation from confirmation	nvarchar	6	0	Allow NULL?
143	AUERU	Activation of Final Confirmation	char	1	0	Allow NULL?
144	AUSOR	Post open reservations	char	1	0	Allow NULL?
145	APLFL	Sequence	nvarchar	6	0	Allow NULL?
146	UVORN	Suboperation	nvarchar	4	0	Allow NULL?
147	AUTYP	Order category	nvarchar	2	0	Allow NULL?
148	PKNUM	Control cycle number	nvarchar	7	0	Allow NULL?
149	PKPOS	Kanban item number / control cycle item	nvarchar	3	0	Allow NULL?
150	PKBST	Kanban status	char	1	0	Allow NULL?
151	ABMNG	Reduced quantity in the planned order	decimal	13	3
152	RMNGA	Total confirmed rework quantity	decimal	13	3
153	PKKEY	Identification Number	nvarchar	10	0	Allow NULL?
154	PKIMG	Actual quantity	decimal	13	3
155	CATSBELNR	Document Number	nvarchar	10	0	Allow NULL?
156	CATSPRICE	Price in Transaction Currency	decimal	11	2
157	CATSTCURR	Transaction Currency	nvarchar	5	0	Allow NULL?
158	CATSPEINH	Price Unit	decimal	5	0
159	BEMOT	Accounting Indicator	nvarchar	2	0	Allow NULL?
160	PRZ01	Business Process	nvarchar	12	0	Allow NULL?
161	IPRZ1	Current quantity to be confirmed for the business process	decimal	13	3
162	IPRE1	Unit of measurement for conf. quantity for business process	nvarchar	3	0	Allow NULL?
163	IPRK1	No remaining quantity expected for business process	char	1	0	Allow NULL?
164	OPRZ1	Remaining quantity for business process	decimal	13	3
165	OPRE1	Unit for remaining quantity of business process	nvarchar	3	0	Allow NULL?
166	EXNAM	External creator of confirmation	nvarchar	12	0	Allow NULL?
167	EXERD	External date of entry for confirmation	nvarchar	8	0	Allow NULL?
168	EXERZ	External time of entry for confirmation	nvarchar	6	0	Allow NULL?
169	WEBLNR	Number of a document from a goods movement with errors	nvarchar	10	0	Allow NULL?
170	PKLUZ	Delivery time for a kanban, time of day	nvarchar	6	0	Allow NULL?
171	PKLDT	Delivery time for a kanban, date	nvarchar	8	0	Allow NULL?
172	PKBMG	Quantity requested	decimal	13	3
173	CHARG	Batch Number	nvarchar	10	0	Allow NULL?
174	SKOKRS	Controlling Area	nvarchar	4	0	Allow NULL?
175	SKOSTL	Sender Cost Center	nvarchar	10	0	Allow NULL?
176	NODAT	Do not update actual date in the operation	char	1	0	Allow NULL?
177	ISMNU	Unit for work	nvarchar	3	0	Allow NULL?
178	OFMNU	Unit for work	nvarchar	3	0	Allow NULL?
179	PACKNO	Package number	nvarchar	10	0	Allow NULL?
180	SLK01	Indicator: Determine target activity	char	1	0	Allow NULL?
181	SLK02	Indicator: Determine target activity	char	1	0	Allow NULL?
182	SLK03	Indicator: Determine target activity	char	1	0	Allow NULL?
183	SLK04	Indicator: Determine target activity	char	1	0	Allow NULL?
184	SLK05	Indicator: Determine target activity	char	1	0	Allow NULL?
185	SLK06	Indicator: Determine target activity	char	1	0	Allow NULL?
186	SPRK1	Indicator: Determine target qty for business transaction	char	1	0	Allow NULL?
187	EXTID	External Key for Confirmation (for example, from PDC System)	varbinary	16	0

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

187 COLUMNS | 1 INDEXES | ERP 6.0 | AFRV TABLE

TOP ERP 6.0 | AFRV COLUMNS

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

187 COLUMNS | 1 INDEXES | ERP 6.0 | AFRV TABLE

TOPERP 6.0 | AFRV COLUMNS

TOPERP 6.0 | AFRV INDEXES

TOP ERP 6.0 | AFRV COLUMNS

TOP ERP 6.0 | AFRV INDEXES