	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

35 columns | ERP 6.0 | UMSGVP

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
TOPData Collection
1	S077	STRPS: Movements	24	UMSGVP	Sales at retail with tax	decimal	19	2
2	S079	STRPS: Movements + Stock	24	UMSGVP	Sales at retail with tax	decimal	19	2
3	S080	Purchasing: Movements	24	UMSGVP	Sales at retail with tax	decimal	19	2
4	S082	Purchasing: Movements + Stock	24	UMSGVP	Sales at retail with tax	decimal	19	2
5	S083	Material: Movements	24	UMSGVP	Sales at retail with tax	decimal	19	2
6	S085	Material: Movements + Stock	24	UMSGVP	Sales at retail with tax	decimal	19	2
7	S086	Promotion	24	UMSGVP	Sales at retail with tax	decimal	19	2
8	S105	Season: Movements	24	UMSGVP	Sales at retail with tax	decimal	19	2
9	S107	Season: Movements + Stock	24	UMSGVP	Sales at retail with tax	decimal	19	2
10	S110	OTB	21	UMSGVP	Sales at retail with tax	decimal	19	2
11	S120	Sales as per receipts	24	UMSGVP	Retail price w/tax from sales as per receipts/aggreg.sales	decimal	19	2
12	S120BIW1	S120BIW1 * Sales as Per Receipts	24	UMSGVP	Retail price w/tax from sales as per receipts/aggreg.sales	decimal	19	2
13	S120BIW2	S120BIW2 * Sales as Per Receipts	24	UMSGVP	Retail price w/tax from sales as per receipts/aggreg.sales	decimal	19	2
14	S121	Material aggregation - POS	18	UMSGVP	Retail price w/tax from sales as per receipts/aggreg.sales	decimal	19	2
15	S122	Cashier	55	UMSGVP	Retail price w/tax from sales as per receipts/aggreg.sales	decimal	19	2
16	S122BIW1	S122BIW1 * Cashier	55	UMSGVP	Retail price w/tax from sales as per receipts/aggreg.sales	decimal	19	2
17	S122BIW2	S122BIW2 * Cashier	55	UMSGVP	Retail price w/tax from sales as per receipts/aggreg.sales	decimal	19	2
18	S123	Customer / material group	59	UMSGVP	Third-party sales at retail with tax	decimal	19	2
19	S124	Customer / material	58	UMSGVP	Third-party sales at retail with tax	decimal	19	2
20	S160	Perishables	62	UMSGVP	Sales at retail with tax	decimal	19	2
21	S540	Reference Structure for Generating Info Structures	14	UMSGVP	Sales at retail with tax	decimal	19	2
22	S952	Reference Structure for Generating Info Structures	39	UMSGVP	Sales at retail with tax	decimal	19	2
23	S955	Istdatenspeicher MAP - BW	31	UMSGVP	Umsatz VP m. Steuer	decimal	19	2
24	S957	Reference Structure for Generating Info Structures	21	UMSGVP	Sales at retail with tax	decimal	19	2
25	S958	Reference Structure for Generating Info Structures	29	UMSGVP	Sales at retail with tax	decimal	19	2
TOPMerchandise and Assortment Planning
26	S202	MAP: Merchandise Planning Structure	39	UMSGVP	Sales at retail with tax	decimal	19	2
27	S204	MAP: Merchandise Planning Movements	27	UMSGVP	Sales at retail with tax	decimal	19	2
28	S207	MAP: Store Planning Structure	21	UMSGVP	Sales at retail with tax	decimal	19	2
29	S212	CatMan: Hohe Ebene	22	UMSGVP	Omzet VP met BTW	decimal	19	2
30	S212BIW1	S212BIW1 * CatMan: High Level	22	UMSGVP	Sales at retail with tax	decimal	19	2
31	S212BIW2	S212BIW2 * CatMan: High Level	22	UMSGVP	Sales at retail with tax	decimal	19	2
32	S216	MAP: Average Retail WOC	24	UMSGVP	Sales at retail with tax	decimal	19	2
33	S217	MAP: AvgRetail MON	24	UMSGVP	Sales at retail with tax	decimal	19	2
34	S218	MAP: AvgRetail BUP	24	UMSGVP	Sales at retail with tax	decimal	19	2
TOPReporting
35	S205	MAP: Store Planning Movements	21	UMSGVP	Sales at retail with tax	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

35 columns | ERP 6.0 | UMSGVP