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

	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

41 columns | ERP 6.0 | UMSGVO

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
TOPData Collection
1	S077	STRPS: Movements	23	UMSGVO	Sales at retail	decimal	19	2
2	S079	STRPS: Movements + Stock	23	UMSGVO	Sales at retail	decimal	19	2
3	S080	Purchasing: Movements	23	UMSGVO	Sales at retail	decimal	19	2
4	S082	Purchasing: Movements + Stock	23	UMSGVO	Sales at retail	decimal	19	2
5	S083	Material: Movements	23	UMSGVO	Sales at retail	decimal	19	2
6	S085	Material: Movements + Stock	23	UMSGVO	Sales at retail	decimal	19	2
7	S086	Promotion	23	UMSGVO	Sales at retail	decimal	19	2
8	S105	Season: Movements	23	UMSGVO	Sales at retail	decimal	19	2
9	S107	Season: Movements + Stock	23	UMSGVO	Sales at retail	decimal	19	2
10	S110	OTB	76	UMSGVO	Sales at retail	decimal	19	2
11	S120	Sales as per receipts	25	UMSGVO	Rtl price from sales as per receipts/aggreg.sales	decimal	19	2
12	S120BIW1	S120BIW1 * Sales as Per Receipts	25	UMSGVO	Rtl price from sales as per receipts/aggreg.sales	decimal	19	2
13	S120BIW2	S120BIW2 * Sales as Per Receipts	25	UMSGVO	Rtl price from sales as per receipts/aggreg.sales	decimal	19	2
14	S121	Material aggregation - POS	19	UMSGVO	Rtl price from sales as per receipts/aggreg.sales	decimal	19	2
15	S122	Cashier	18	UMSGVO	Retail price without tax from cashier statistics	decimal	19	2
16	S122BIW1	S122BIW1 * Cashier	18	UMSGVO	Retail price without tax from cashier statistics	decimal	19	2
17	S122BIW2	S122BIW2 * Cashier	18	UMSGVO	Retail price without tax from cashier statistics	decimal	19	2
18	S123	Customer / material group	58	UMSGVO	Third-party sales at retail	decimal	19	2
19	S124	Customer / material	57	UMSGVO	Third-party sales at retail	decimal	19	2
20	S160	Perishables	61	UMSGVO	Sales at retail	decimal	19	2
21	S685	MAP IRT350	16	UMSGVO	Umsatz VP	decimal	19	2
22	S952	Reference Structure for Generating Info Structures	38	UMSGVO	Sales at retail	decimal	19	2
23	S955	Istdatenspeicher MAP - BW	42	UMSGVO	Umsatz VP	decimal	19	2
24	S957	Reference Structure for Generating Info Structures	22	UMSGVO	Sales at retail	decimal	19	2
TOPMaterial Master
25	WSTN_BW_EXTRACT	Sample DB Table that contains pre-extracted data from B.W.	4	UMSGVO	Sales at retail	decimal	19	2
TOPMerchandise and Assortment Planning
26	S202	MAP: Merchandise Planning Structure	38	UMSGVO	Sales at retail	decimal	19	2
27	S204	MAP: Merchandise Planning Movements	28	UMSGVO	Sales at retail	decimal	19	2
28	S207	MAP: Store Planning Structure	22	UMSGVO	Sales at retail	decimal	19	2
29	S212	CatMan: Hohe Ebene	21	UMSGVO	Omzet verkoopprijs	decimal	19	2
30	S212BIW1	S212BIW1 * CatMan: High Level	21	UMSGVO	Sales at retail	decimal	19	2
31	S212BIW2	S212BIW2 * CatMan: High Level	21	UMSGVO	Sales at retail	decimal	19	2
32	S214	CatMan: Indizees für ROP	20	UMSGVO	Omzet verkoopprijs	decimal	19	2
33	S214BIW1	S214BIW1 * CatMan: Indexes for Space Management Program	20	UMSGVO	Sales at retail	decimal	19	2
34	S214BIW2	S214BIW2 * CatMan: Indexes for Space Management Program	20	UMSGVO	Sales at retail	decimal	19	2
35	S216	MAP: Average Retail WOC	23	UMSGVO	Sales at retail	decimal	19	2
36	S217	MAP: AvgRetail MON	23	UMSGVO	Sales at retail	decimal	19	2
37	S218	MAP: AvgRetail BUP	23	UMSGVO	Sales at retail	decimal	19	2
38	S219	CatMan: Feine Ebene	23	UMSGVO	Omzet verkoopprijs	decimal	19	2
39	S219BIW1	S219BIW1 * CatMan: Fine Level	23	UMSGVO	Sales at retail	decimal	19	2
40	S219BIW2	S219BIW2 * CatMan: Detailed Level	23	UMSGVO	Sales at retail	decimal	19	2
TOPReporting
41	S205	MAP: Store Planning Movements	22	UMSGVO	Sales at retail	decimal	19	2

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

41 columns | ERP 6.0 | UMSGVO