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	BSEG	345	Accounting Document Segment
9	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
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	OPCH	386	A/P Invoice
7	INV1	265	A/R Invoice - Rows
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	ORCT	154	Incoming Payment
2	OITM	249	Items
3	OINV	268	A/R Invoice
4	OIVL	77	Whse Journal
5	OINM	101	Whse Journal
6	OVPM	154	Outgoing Payments
7	OPCH	268	A/P Invoice
8	JDT1	110	Journal Entry - Rows
9	OOCR	9	Loading Factors
10	OSRN	20	Serial Numbers Master Data

	Product	Version	Table	Columns	Indexes	Description	Module
Project System :: Simulation
1	ERP EHP7	6.0	VSRESB_CN	201	3	Version: Reservation/Dependent requirements	Simulation

Name	Primary	Unique	Type	Columns
VSRESB_CN~0	Yes	Yes	CLUSTERED	MANDT, VSNMR, RSNUM, RSPOS, RSART
VSRESB_CN~A	No	No	NONCLUSTERED	MANDT, OBJNR
VSRESB_CN~B	No	No	NONCLUSTERED	RSNUM, RSPOS, RSART, 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

201 COLUMNS | 3 INDEXES | ERP 6.0 | VSRESB_CN TABLE

TOP ERP 6.0 | VSRESB_CN COLUMNS

TOP ERP 6.0 | VSRESB_CN INDEXES

Column	Field	Description	SQL Type	Length	Decimals	SQL Create Statement
1	MANDT	Client	nvarchar	3	0	Allow NULL?
2	VSNMR	Number or description of a version	nvarchar	12	0	Allow NULL?
3	RSNUM	Number of Reservation/Dependent Requirement	nvarchar	10	0	Allow NULL?
4	RSPOS	Item Number of Reservation/Dependent Requirement	nvarchar	4	0	Allow NULL?
5	RSART	Record type	char	1	0	Allow NULL?
6	BDART	Requirement type	nvarchar	2	0	Allow NULL?
7	RSSTA	Status of reservation	char	1	0	Allow NULL?
8	XLOEK	Item is Deleted	char	1	0	Allow NULL?
9	XWAOK	Goods Movement for Reservation Allowed	char	1	0	Allow NULL?
10	KZEAR	Final Issue for This Reservation	char	1	0	Allow NULL?
11	XFEHL	Missing Part	char	1	0	Allow NULL?
12	MATNR	Material Number	nvarchar	18	0	Allow NULL?
13	WERKS	Plant	nvarchar	4	0	Allow NULL?
14	LGORT	Storage Location	nvarchar	4	0	Allow NULL?
15	PRVBE	Production Supply Area	nvarchar	10	0	Allow NULL?
16	CHARG	Batch Number	nvarchar	10	0	Allow NULL?
17	PLPLA	Distribution of Differences	nvarchar	10	0	Allow NULL?
18	SOBKZ	Special Stock Indicator	char	1	0	Allow NULL?
19	BDTER	Requirement Date for the Component	nvarchar	8	0	Allow NULL?
20	BDMNG	Requirement Quantity	decimal	13	3
21	MEINS	Base Unit of Measure	nvarchar	3	0	Allow NULL?
22	SHKZG	Debit/Credit Indicator	char	1	0	Allow NULL?
23	FMENG	Quantity is Fixed	char	1	0	Allow NULL?
24	ENMNG	Quantity Withdrawn	decimal	13	3
25	ENWRT	Value Withdrawn	decimal	13	2
26	WAERS	Currency Key	nvarchar	5	0	Allow NULL?
27	ERFMG	Quantity in Unit of Entry	decimal	13	3
28	ERFME	Unit of Entry	nvarchar	3	0	Allow NULL?
29	PLNUM	Planned order number	nvarchar	10	0	Allow NULL?
30	BANFN	Purchase Requisition Number	nvarchar	10	0	Allow NULL?
31	BNFPO	Item Number of Purchase Requisition	nvarchar	5	0	Allow NULL?
32	AUFNR	Order Number	nvarchar	12	0	Allow NULL?
33	BAUGR	Material number of higher-level assembly	nvarchar	18	0	Allow NULL?
34	SERNR	BOM explosion number	nvarchar	8	0	Allow NULL?
35	KDAUF	Sales Order Number	nvarchar	10	0	Allow NULL?
36	KDPOS	Item Number in Sales Order	nvarchar	6	0	Allow NULL?
37	KDEIN	Delivery Schedule for Sales Order	nvarchar	4	0	Allow NULL?
38	PROJN	Old: Project number : No longer used --> PS_POSNR	nvarchar	16	0	Allow NULL?
39	BWART	Movement Type (Inventory Management)	nvarchar	3	0	Allow NULL?
40	SAKNR	G/L Account Number	nvarchar	10	0	Allow NULL?
41	GSBER	Business Area	nvarchar	4	0	Allow NULL?
42	UMWRK	Receiving/Issuing Plant	nvarchar	4	0	Allow NULL?
43	UMLGO	Receiving/Issuing Storage Location	nvarchar	4	0	Allow NULL?
44	NAFKZ	Indicator: follow-up material active/not active	char	1	0	Allow NULL?
45	NOMAT	Follow-Up/Original Material	nvarchar	18	0	Allow NULL?
46	NOMNG	Required quantity	decimal	13	3
47	POSTP	Item Category (Bill of Material)	char	1	0	Allow NULL?
48	POSNR	BOM item number	nvarchar	4	0	Allow NULL?
49	ROMS1	Size 1	decimal	13	3
50	ROMS2	Size 2	decimal	13	3
51	ROMS3	Size 3	decimal	13	3
52	ROMEI	Unit of measure for sizes 1 to 3	nvarchar	3	0	Allow NULL?
53	ROMEN	Quantity of variable-size item	decimal	13	3
54	SGTXT	Item Text	nvarchar	50	0	Allow NULL?
55	LMENG	Required quantity for mat.management in stockkeeping units	decimal	13	3
56	ROHPS	Variable-sized item indicator	char	1	0	Allow NULL?
57	RFORM	Formula key	nvarchar	2	0	Allow NULL?
58	ROANZ	Number of variable-size items	decimal	13	3
59	FLMNG	Shortfall quantity of the component in the order	decimal	13	3
60	STLTY	BOM category	char	1	0	Allow NULL?
61	STLNR	Bill of material	nvarchar	8	0	Allow NULL?
62	STLKN	BOM item node number	nvarchar	8	0	Allow NULL?
63	STPOZ	Internal counter	nvarchar	8	0	Allow NULL?
64	LTXSP	Language: The long text was stored in this language	char	1	0	Allow NULL?
65	POTX1	BOM Item Text (Line 1)	nvarchar	40	0	Allow NULL?
66	POTX2	BOM item text (line 2)	nvarchar	40	0	Allow NULL?
67	SANKA	Indicator for Relevancy to Costing	char	1	0	Allow NULL?
68	ALPOS	Alternative item indicator	char	1	0	Allow NULL?
69	EWAHR	Usage probability in % (alternative item)	decimal	3	0
70	AUSCH	Component scrap in percent	decimal	5	2
71	AVOAU	Operation scrap	decimal	5	2
72	NETAU	Indicator: Net scrap	char	1	0	Allow NULL?
73	NLFZT	Lead-time offset	decimal	3	0
74	AENNR	Change Number	nvarchar	12	0	Allow NULL?
75	UMREZ	Numerator for Conversion to Base Units of Measure	decimal	5	0
76	UMREN	Denominator for conversion to base units of measure	decimal	5	0
77	SORTF	Sort String	nvarchar	10	0	Allow NULL?
78	SBTER	Latest requirements date	nvarchar	8	0	Allow NULL?
79	VERTI	MRP Distribution Key	nvarchar	4	0	Allow NULL?
80	SCHGT	Indicator: Bulk Material	char	1	0	Allow NULL?
81	UPSKZ	Indicator: sub-items exist	char	1	0	Allow NULL?
82	DBSKZ	Direct procurement indicator	char	1	0	Allow NULL?
83	TXTPS	Item text indicator	char	1	0	Allow NULL?
84	DUMPS	Phantom item indicator	char	1	0	Allow NULL?
85	BEIKZ	Material Provision Indicator	char	1	0	Allow NULL?
86	ERSKZ	Indicator: spare part	char	1	0	Allow NULL?
87	AUFST	Order level	nvarchar	2	0	Allow NULL?
88	AUFWG	Order path	nvarchar	2	0	Allow NULL?
89	BAUST	Assembly order level	nvarchar	2	0	Allow NULL?
90	BAUWG	Assembly order path	nvarchar	2	0	Allow NULL?
91	AUFPS	Order item number	nvarchar	2	0	Allow NULL?
92	EBELN	Purchasing Document Number	nvarchar	10	0	Allow NULL?
93	EBELP	Item Number of Purchasing Document	nvarchar	5	0	Allow NULL?
94	EBELE	Delivery Schedule Line Counter	nvarchar	4	0	Allow NULL?
95	KNTTP	Account Assignment Category	char	1	0	Allow NULL?
96	KZVBR	Consumption Posting	char	1	0	Allow NULL?
97	PSPEL	WBS Element	nvarchar	8	0	Allow NULL?
98	AUFPL	Routing number of operations in the order	nvarchar	10	0	Allow NULL?
99	PLNFL	Sequence	nvarchar	6	0	Allow NULL?
100	VORNR	Operation/Activity Number	nvarchar	4	0	Allow NULL?
101	APLZL	Internal counter	nvarchar	8	0	Allow NULL?
102	OBJNR	Object number	nvarchar	22	0	Allow NULL?
103	FLGAT	Sequence category	char	1	0	Allow NULL?
104	GPREIS	Total Price in Local Currency	decimal	15	2
105	FPREIS	Fixed Price in Foreign Currency	decimal	15	2
106	PEINH	Price Unit	decimal	5	0
107	RGEKZ	Indicator: Backflush	char	1	0	Allow NULL?
108	EKGRP	Purchasing Group	nvarchar	3	0	Allow NULL?
109	ROKME	Unit of measure for variable-size component	nvarchar	3	0	Allow NULL?
110	ZUMEI	Unit for cutting measures	nvarchar	3	0	Allow NULL?
111	ZUMS1	Cutting measure 1	decimal	13	3
112	ZUMS2	Cutting measure 2	decimal	13	3
113	ZUMS3	Cutting measure 3	decimal	13	3
114	ZUDIV	Integral divisor for cutting measures	nvarchar	5	0	Allow NULL?
115	VMENG	Confirmed quantity for availability check in SKU	decimal	15	3
116	PRREG	Checking Rule for Availability Check	nvarchar	2	0	Allow NULL?
117	LIFZT	Delivery time in days	decimal	3	0
118	CUOBJ	Configuration (internal object number)	nvarchar	18	0	Allow NULL?
119	KFPOS	Indicator: "configurable item"	char	1	0	Allow NULL?
120	REVLV	Revision Level	nvarchar	2	0	Allow NULL?
121	BERKZ	Material Staging Indicator for Production Supply	char	1	0	Allow NULL?
122	LGNUM	Warehouse Number / Warehouse Complex	nvarchar	3	0	Allow NULL?
123	LGTYP	Storage Type	nvarchar	3	0	Allow NULL?
124	LGPLA	Storage Bin	nvarchar	10	0	Allow NULL?
125	TBMNG	Transfer requirement quantity already requested	decimal	13	3
126	NPTXTKY	Internal text number (12-character)	nvarchar	12	0	Allow NULL?
127	KBNKZ	Kanban Indicator	char	1	0	Allow NULL?
128	KZKUP	Indicator: co-product	char	1	0	Allow NULL?
129	AFPOS	Order Item Number	nvarchar	4	0	Allow NULL?
130	NO_DISP	Ind: Reserv. not applicable to MRP;Purc. req. not created	char	1	0	Allow NULL?
131	BDZTP	Time that reservation quantity required	nvarchar	6	0	Allow NULL?
132	ESMNG	Usage quantity per order unit of measure	float	15	16
133	ALPGR	Alternative item: group	nvarchar	2	0	Allow NULL?
134	ALPRF	Alternative item: ranking order	nvarchar	2	0	Allow NULL?
135	ALPST	Alternative item: strategy	char	1	0	Allow NULL?
136	KZAUS	Discontinuation indicator	char	1	0	Allow NULL?
137	NFEAG	Discontinuation group	nvarchar	2	0	Allow NULL?
138	NFPKZ	Indicator: Follow-Up Item	char	1	0	Allow NULL?
139	NFGRP	Follow-up group	nvarchar	2	0	Allow NULL?
140	NFUML	NOT USED: Quantity transfer factor for follow-up material	decimal	5	4
141	ADRNR	Addresses: Address Number	nvarchar	10	0	Allow NULL?
142	CHOBJ	Internal object number of the batch classification	nvarchar	18	0	Allow NULL?
143	SPLKZ	Checkbox	char	1	0	Allow NULL?
144	SPLRV	Item Number of Reservation/Dependent Requirement	nvarchar	4	0	Allow NULL?
145	KNUMH	Number of condition record from batch determination	nvarchar	10	0	Allow NULL?
146	WEMPF	Goods Recipient/Ship-To Party	nvarchar	12	0	Allow NULL?
147	ABLAD	Unloading Point	nvarchar	25	0	Allow NULL?
148	HKMAT	Material-related origin	char	1	0	Allow NULL?
149	HRKFT	Origin Group as Subdivision of Cost Element	nvarchar	4	0	Allow NULL?
150	VORAB	Ind: Preliminary order	char	1	0	Allow NULL?
151	MATKL	Material Group	nvarchar	9	0	Allow NULL?
152	FRUNV	Indicator: External procurement data incomplete	char	1	0	Allow NULL?
153	CLAKZ	Indicator: classification exists	char	1	0	Allow NULL?
154	INPOS	Indicator: intra material	char	1	0	Allow NULL?
155	WEBAZ	Goods Receipt Processing Time in Days	decimal	3	0
156	LIFNR	Account Number of Vendor or Creditor	nvarchar	10	0	Allow NULL?
157	FLGEX	Indicator: External procurement	char	1	0	Allow NULL?
158	FUNCT	Distribution function	nvarchar	3	0	Allow NULL?
159	GPREIS_2	Total Price in Local Currency	decimal	15	2
160	FPREIS_2	Fixed Price in Local Currency	decimal	15	2
161	PEINH_2	Price Unit	decimal	5	0
162	INFNR	Number of Purchasing Info Record	nvarchar	10	0	Allow NULL?
163	KZECH	Determination of batch entry in the production/process order	char	1	0	Allow NULL?
164	KZMPF	Manual Maintenance of Requirement Date	char	1	0	Allow NULL?
165	STLAL	Alternative BOM	nvarchar	2	0	Allow NULL?
166	PBDNR	Requirements Plan Number	nvarchar	10	0	Allow NULL?
167	STVKN	Inherited node number of BOM item	nvarchar	8	0	Allow NULL?
168	KTOMA	Acct entered manually	char	1	0	Allow NULL?
169	VRPLA	Indicator: planning without final assembly	char	1	0	Allow NULL?
170	KZBWS	Valuation of Special Stock	char	1	0	Allow NULL?
171	NLFZV	Lead-time offset for operation	decimal	3	0
172	NLFMV	Unit for lead-time offset for operation	nvarchar	3	0	Allow NULL?
173	TECHS	Parameter Variant/Standard Variant	nvarchar	12	0	Allow NULL?
174	OBJTYPE	Change indicator	char	1	0	Allow NULL?
175	CH_PROC	Process that has lead to the change of an object	char	1	0	Allow NULL?
176	ORGRSNUM	Number of Reservation/Dependent Requirement	nvarchar	10	0	Allow NULL?
177	ORGRSPOS	Item Number of Reservation/Dependent Requirement	nvarchar	4	0	Allow NULL?
178	ORGRSART	Record type	char	1	0	Allow NULL?
179	FXPRU	Fixed-Price Co-Product	char	1	0	Allow NULL?
180	UMSOK	Special Stock Indicator for Physical Stock Transfer	char	1	0	Allow NULL?
181	VORAB_SM	Advance Shipment Indicator	char	1	0	Allow NULL?
182	FIPOS	Commitment Item	nvarchar	14	0	Allow NULL?
183	FIPEX	Commitment Item	nvarchar	24	0	Allow NULL?
184	FISTL	Funds Center	nvarchar	16	0	Allow NULL?
185	GEBER	Fund	nvarchar	10	0	Allow NULL?
186	EXTRSNUM	Number of Reservation/Dependent Requirement	nvarchar	10	0	Allow NULL?
187	EXTRSPOS	Item Number of Reservation/Dependent Requirement	nvarchar	4	0	Allow NULL?
188	EXTRSART	Record type	char	1	0	Allow NULL?
189	GRANT_NBR	Grant	nvarchar	20	0	Allow NULL?
190	FKBER	Functional Area	nvarchar	16	0	Allow NULL?
191	PRIO_URG	Requirement Urgency	nvarchar	2	0	Allow NULL?
192	PRIO_REQ	Requirement Priority	nvarchar	3	0	Allow NULL?
193	BUDGET_PD	FM: Budget Period	nvarchar	10	0	Allow NULL?
194	KBLNR	Document Number for Earmarked Funds	nvarchar	10	0	Allow NULL?
195	KBLPOS	Earmarked Funds: Document Item	nvarchar	3	0	Allow NULL?
196	ADVCODE	Advice Code	nvarchar	2	0	Allow NULL?
197	SC_OBJECT_ID	Object ID - Document Number	nvarchar	10	0	Allow NULL?
198	SC_ITM_NO	Internal Shopping Cart Item Number	int	10	0	Allow NULL?
199	WTY_IND	Warranty indicator	char	1	0	Allow NULL?
200	R_PART_INDICATOR	Return Part Indicator	char	1	0	Allow NULL?
201	WTYSC_CLMITEM	Claim item number	nvarchar	16	0	Allow NULL?

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

201 COLUMNS | 3 INDEXES | ERP 6.0 | VSRESB_CN TABLE

TOPERP 6.0 | VSRESB_CN COLUMNS

TOPERP 6.0 | VSRESB_CN INDEXES

TOP ERP 6.0 | VSRESB_CN COLUMNS

TOP ERP 6.0 | VSRESB_CN INDEXES