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
Logistics - General :: Merchandise and Assortment Planning
1	ERP EHP7	6.0	S219	32	2	CatMan: Feine Ebene	Merchandise and Assortment Planning

Column	Field	Description	SQL Type	Length	Decimals	SQL Create Statement
1	MANDT	Mandant	nvarchar	3	0	Allow NULL?
2	SSOUR	Statistiekherkomst	nvarchar	4	0	Allow NULL?
3	VRSIO	Nummer van de versie in de informatiestructuur	nvarchar	3	0	Allow NULL?
4	SPMON	Analysetijdvak - maand	nvarchar	6	0	Allow NULL?
5	SPTAG	Analysetijdvak - datum	nvarchar	8	0	Allow NULL?
6	SPWOC	Analysetijdvak - week	nvarchar	6	0	Allow NULL?
7	SPBUP	Analysetijdvak - boekingsperiode	nvarchar	6	0	Allow NULL?
8	HIER_ID	Hiërarchie-ID	nvarchar	2	0	Allow NULL?
9	CDT1	Categorie	nvarchar	18	0	Allow NULL?
10	CDT2	Subcategorie	nvarchar	18	0	Allow NULL?
11	CDT3	Segment	nvarchar	18	0	Allow NULL?
12	CDT4	Subsegment	nvarchar	18	0	Allow NULL?
13	MATNR	Artikelnummer	nvarchar	18	0	Allow NULL?
14	CM_LAND1	Landcode	nvarchar	3	0	Allow NULL?
15	REGIO	Regio (staat, deelstaat, provincie, county)	nvarchar	3	0	Allow NULL?
16	PERIV	Boekjaarvariant	nvarchar	2	0	Allow NULL?
17	VWDAT	Pointer naar beheergegevens	nvarchar	10	0	Allow NULL?
18	PSWAE	Geheugenvaluta van plangegevens van een planningsscenario	nvarchar	5	0	Allow NULL?
19	BASME	Basishoeveelheidseenheid	nvarchar	3	0	Allow NULL?
20	CDT5	Subsubsegment	nvarchar	18	0	Allow NULL?
21	CDT6	Productgroep	nvarchar	18	0	Allow NULL?
22	CDT7	Markering	nvarchar	18	0	Allow NULL?
23	UMSGVO	Omzet verkoopprijs	decimal	19	2
24	UMSGEO	Omzet inkoopprijs	decimal	19	2
25	UMSMNG	Omzethoeveelheid in BEh	decimal	15	3
26	CM_AZART	Aantal artikelen	decimal	11	3
27	CM_LISTED	Listingteken	char	1	0	Allow NULL?
28	CM_UMMKT_E	Marktomzet (EXT)	decimal	19	2
29	CM_ABDSG_E	Marktafdekking op segmentniveau (EXT)	decimal	6	3
30	CM_ABDSS_E	Marktafdekking op niveau onderliggend segment (EXT)	decimal	6	3
31	CM_AVGPR_E	Gemiddelde prijs per artikel (EXT)	decimal	7	2
32	CM_SHLFPRC	Aanbevolen schapprijs	decimal	7	2

Name	Primary	Unique	Type	Columns
S219~0	Yes	Yes	CLUSTERED	REGIO, CM_LAND1, MATNR, CDT4, CDT3, CDT2, CDT1, HIER_ID, SPBUP, SPWOC, SPTAG, SPMON, VRSIO, SSOUR, MANDT
S219~VAB	No	No	NONCLUSTERED	MATNR, 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

32 COLUMNS | 2 INDEXES | ERP 6.0 | S219 TABLE

TOP ERP 6.0 | S219 COLUMNS

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

32 COLUMNS | 2 INDEXES | ERP 6.0 | S219 TABLE

TOPERP 6.0 | S219 COLUMNS

TOPERP 6.0 | S219 INDEXES

TOP ERP 6.0 | S219 COLUMNS

TOP ERP 6.0 | S219 INDEXES