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

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
Project System :: Simulation
1	ERP EHP7	6.0	VSPLAF_CN	123	2	Version: Planned order	Simulation

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	PLNUM	Planned order number	nvarchar	10	0	Allow NULL?
4	MATNR	Planning material	nvarchar	18	0	Allow NULL?
5	PLWRK	Planning Plant	nvarchar	4	0	Allow NULL?
6	PWWRK	Production plant in planned order	nvarchar	4	0	Allow NULL?
7	PAART	Order type	nvarchar	4	0	Allow NULL?
8	BESKZ	Procurement Type	char	1	0	Allow NULL?
9	SOBES	Special procurement type	char	1	0	Allow NULL?
10	GSMNG	Total planned order quantity	decimal	13	3
11	TLMNG	Partial lot quantity	decimal	13	3
12	AVMNG	Fixed quantity of scrap from production	decimal	13	3
13	BDMNG	Requirement Quantity	decimal	13	3
14	PSTTR	Order start date in planned order	nvarchar	8	0	Allow NULL?
15	PEDTR	Order finish date in the planned order	nvarchar	8	0	Allow NULL?
16	PERTR	Planned opening date in planned order	nvarchar	8	0	Allow NULL?
17	WEBAZ	Goods receipt processing time in days	decimal	3	0
18	DISPO	MRP controller	nvarchar	3	0	Allow NULL?
19	UMSKZ	Conversion indicator for planned order	char	1	0	Allow NULL?
20	AUFFX	Firming indicator for planned order data	char	1	0	Allow NULL?
21	STLFX	Fixing indicator for BOM explosion	char	1	0	Allow NULL?
22	KNTTP	Account Assignment Category	char	1	0	Allow NULL?
23	KDAUF	Sales Order Number	nvarchar	10	0	Allow NULL?
24	KDPOS	Item Number in Sales Order	nvarchar	6	0	Allow NULL?
25	KDEIN	Delivery Schedule for Sales Order	nvarchar	4	0	Allow NULL?
26	PROJN	Old: Project number : No longer used --> PS_POSNR	nvarchar	16	0	Allow NULL?
27	RSNUM	Number of Reservation/Dependent Requirement	nvarchar	10	0	Allow NULL?
28	QUNUM	Number of Quota Arrangement	nvarchar	10	0	Allow NULL?
29	QUPOS	Quota Arrangement Item	nvarchar	3	0	Allow NULL?
30	FLIEF	Fixed Vendor	nvarchar	10	0	Allow NULL?
31	KONNR	Number of Principal Purchase Agreement	nvarchar	10	0	Allow NULL?
32	KTPNR	Item Number of Principal Purchase Agreement	nvarchar	5	0	Allow NULL?
33	EKORG	Purchasing Organization	nvarchar	4	0	Allow NULL?
34	LGORT	Storage Location	nvarchar	4	0	Allow NULL?
35	NUMVR	Version number	nvarchar	2	0	Allow NULL?
36	KZVBR	Consumption Posting	char	1	0	Allow NULL?
37	SOBKZ	Special Stock Indicator	char	1	0	Allow NULL?
38	PSPEL	WBS Element	nvarchar	8	0	Allow NULL?
39	SERNR	BOM explosion number	nvarchar	8	0	Allow NULL?
40	PALTR	Explosion date	nvarchar	8	0	Allow NULL?
41	TECHS	Parameter Variant/Standard Variant	nvarchar	12	0	Allow NULL?
42	STLAN	BOM Usage	char	1	0	Allow NULL?
43	STALT	Alternative BOM	nvarchar	2	0	Allow NULL?
44	AENNR	Change Number	nvarchar	12	0	Allow NULL?
45	ARSNR	Settlement reservation number	nvarchar	10	0	Allow NULL?
46	ARSPS	Item number of the settlement reservation	nvarchar	4	0	Allow NULL?
47	VERTO	Distribution key for quantity produced	nvarchar	4	0	Allow NULL?
48	VERID	Production Version	nvarchar	4	0	Allow NULL?
49	AUFNR	Run schedule header number	nvarchar	12	0	Allow NULL?
50	TRART	Scheduling type of the planned order	char	1	0	Allow NULL?
51	PLGRP	Responsible planner group/department	nvarchar	3	0	Allow NULL?
52	TERST	Start date for production	nvarchar	8	0	Allow NULL?
53	TERED	Finish date for production	nvarchar	8	0	Allow NULL?
54	BEDID	ID of the capacity requirements record	nvarchar	12	0	Allow NULL?
55	AUFPL	Routing number of operations in the order	nvarchar	10	0	Allow NULL?
56	LINID	ID for a schedule record	nvarchar	15	0	Allow NULL?
57	TRMKZ	Scheduling indicator	char	1	0	Allow NULL?
58	TRMER	Scheduling error	nvarchar	2	0	Allow NULL?
59	REDKZ	Reduction indicator for scheduling	char	1	0	Allow NULL?
60	TRMHK	Scheduling source	char	1	0	Allow NULL?
61	PLNNR	Key for Task List Group	nvarchar	8	0	Allow NULL?
62	PLNAL	Group Counter	nvarchar	2	0	Allow NULL?
63	PLNTY	Task List Type	char	1	0	Allow NULL?
64	FRTHW	Production note in the planned order	char	1	0	Allow NULL?
65	RGEKZ	Indicator: Backflushing for order	char	1	0	Allow NULL?
66	MEINS	Base Unit of Measure	nvarchar	3	0	Allow NULL?
67	CUOBJ	Configuration (internal object number)	nvarchar	18	0	Allow NULL?
68	REVLV	Revision Level	nvarchar	2	0	Allow NULL?
69	ABMNG	Reduced quantity in the planned order	decimal	13	3
70	RATID	Index for the results of scheduling production rates	nvarchar	12	0	Allow NULL?
71	GROID	Index for rough scheduling results	nvarchar	12	0	Allow NULL?
72	RATER	Scheduling error in scheduling production rates	nvarchar	2	0	Allow NULL?
73	GROER	Scheduling error in rough scheduling	nvarchar	2	0	Allow NULL?
74	OBART	Object type	char	1	0	Allow NULL?
75	PLSCN	Planning Scenario of Long-Term Planning	nvarchar	3	0	Allow NULL?
76	SBNUM	Simulation requirements number	nvarchar	10	0	Allow NULL?
77	KBNKZ	Kanban Indicator	char	1	0	Allow NULL?
78	KAPFX	Indicator: capacity for planned order dispatched	char	1	0	Allow NULL?
79	SEQNR	Seq. number order	nvarchar	14	0	Allow NULL?
80	PSTTI	Start Time of Planned Order	nvarchar	6	0	Allow NULL?
81	PEDTI	End Time of Planned Order	nvarchar	6	0	Allow NULL?
82	MONKZ	Indicator: for assembly order procedures	char	1	0	Allow NULL?
83	STSTA	BOM status	nvarchar	2	0	Allow NULL?
84	PRNKZ	Ind.: Leading order in collective order is planned ordre	char	1	0	Allow NULL?
85	MDPBV	Planned order: confirmation of availability	char	1	0	Allow NULL?
86	VFMNG	Planned order: committed quantity	decimal	13	3
87	MDACH	Action control: planned order processing	nvarchar	2	0	Allow NULL?
88	MDACC	Action: planned order processing	nvarchar	4	0	Allow NULL?
89	MDACD	Date of action: planned order	nvarchar	8	0	Allow NULL?
90	MDACT	Time of action: Planned order processing	nvarchar	6	0	Allow NULL?
91	GSBTR	Total commitment date of plnd ord. after ATP check f.comps.	nvarchar	8	0	Allow NULL?
92	PLETX	Planned order shift quantities exist	char	1	0	Allow NULL?
93	PRSCH	Planned order: scheduling using production dates	char	1	0	Allow NULL?
94	LVSCH	Planned order: leading scheduling level (determines dates)	char	1	0	Allow NULL?
95	KZAVC	Indicator for type of availability check	char	1	0	Allow NULL?
96	VRPLA	Indicator: planning without final assembly	char	1	0	Allow NULL?
97	PBDNR	Requirements Plan Number	nvarchar	10	0	Allow NULL?
98	AGREQ	Requirements totaling	char	1	0	Allow NULL?
99	UMREZ	Numerator for Conversion to Base Units of Measure	decimal	5	0
100	UMREN	Denominator for conversion to base units of measure	decimal	5	0
101	ERFMG	Quantity in Unit of Entry	decimal	13	3
102	ERFME	Unit of Entry	nvarchar	3	0	Allow NULL?
103	RQNUM	Requirements record number	nvarchar	10	0	Allow NULL?
104	KZBWS	Valuation of Special Stock	char	1	0	Allow NULL?
105	WEMNG	Quantity of Goods Received	decimal	13	3
106	WAMNG	Issued Quantity	decimal	13	3
107	EDGNO	Internal number for edge of object dependencies tree	nvarchar	17	0	Allow NULL?
108	LBLKZ	Subcontracting vendor	char	1	0	Allow NULL?
109	EMLIF	Vendor to be supplied/who is to receive delivery	nvarchar	10	0	Allow NULL?
110	BERID	MRP Area	nvarchar	10	0	Allow NULL?
111	UBERI	Issuing MRP area when transferring stock	nvarchar	10	0	Allow NULL?
112	EMATN	Material Number Corresponding to Manufacturer Part Number	nvarchar	18	0	Allow NULL?
113	REMFL	Repetitive Manufacturing indicator	char	1	0	Allow NULL?
114	PSTMP	Last Change to Planned Order: Time Stamp	decimal	15	0
115	PUSER	Last Change to Planned Order: User	nvarchar	12	0	Allow NULL?
116	BADI	Object change via active Business Add-In	char	1	0	Allow NULL?
117	STAEX	Status information on BOM explosion in planned order	nvarchar	2	0	Allow NULL?
118	RESLO	Issuing Storage Location for Stock Transport Order	nvarchar	4	0	Allow NULL?
119	MEDKZ	Indicator for Distributed Planned Order	char	1	0	Allow NULL?
120	CNFQTY	Total Confirmed Qty Planned Order (Repetitive Manufacturing)	decimal	13	3
121	KUNNR	Customer Number	nvarchar	10	0	Allow NULL?
122	SRM_CONTRACT_ID	Central Contract	nvarchar	10	0	Allow NULL?
123	SRM_CONTRACT_ITM	Central Contract Item Number	nvarchar	10	0	Allow NULL?

Name	Primary	Unique	Type	Columns
VSPLAF_CN~0	Yes	Yes	CLUSTERED	MANDT, VSNMR, PLNUM
VSPLAF_CN~1	No	No	NONCLUSTERED	MANDT, VSNMR, PSPEL

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

123 COLUMNS | 2 INDEXES | ERP 6.0 | VSPLAF_CN TABLE

TOP ERP 6.0 | VSPLAF_CN COLUMNS

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

123 COLUMNS | 2 INDEXES | ERP 6.0 | VSPLAF_CN TABLE

TOPERP 6.0 | VSPLAF_CN COLUMNS

TOPERP 6.0 | VSPLAF_CN INDEXES

TOP ERP 6.0 | VSPLAF_CN COLUMNS

TOP ERP 6.0 | VSPLAF_CN INDEXES