	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

39 columns | ERP 6.0 | UMSMNG

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
TOPData Collection
1	S077	STRPS: Movements	21	UMSMNG	Sales quantity in base unit of measure	decimal	15	3
2	S079	STRPS: Movements + Stock	21	UMSMNG	Sales quantity in base unit of measure	decimal	15	3
3	S080	Purchasing: Movements	21	UMSMNG	Sales quantity in base unit of measure	decimal	15	3
4	S082	Purchasing: Movements + Stock	21	UMSMNG	Sales quantity in base unit of measure	decimal	15	3
5	S083	Material: Movements	21	UMSMNG	Sales quantity in base unit of measure	decimal	15	3
6	S085	Material: Movements + Stock	21	UMSMNG	Sales quantity in base unit of measure	decimal	15	3
7	S086	Promotion	21	UMSMNG	Sales quantity in base unit of measure	decimal	15	3
8	S105	Season: Movements	21	UMSMNG	Sales quantity in base unit of measure	decimal	15	3
9	S107	Season: Movements + Stock	21	UMSMNG	Sales quantity in base unit of measure	decimal	15	3
10	S110	OTB	22	UMSMNG	Sales quantity in base unit of measure	decimal	15	3
11	S117	Receipt/article	36	UMSMNG	Transaction sales - quantity in base unit of measure	decimal	15	3
12	S119	Transaction Number (Till Receipt)	23	UMSMNG	Transaction sales - quantity in base unit of measure	decimal	15	3
13	S120	Sales as per receipts	23	UMSMNG	Transaction sales - quantity in base unit of measure	decimal	15	3
14	S120BIW1	S120BIW1 * Sales as Per Receipts	23	UMSMNG	Transaction sales - quantity in base unit of measure	decimal	15	3
15	S120BIW2	S120BIW2 * Sales as Per Receipts	23	UMSMNG	Transaction sales - quantity in base unit of measure	decimal	15	3
16	S121	Material aggregation - POS	17	UMSMNG	Transaction sales - quantity in base unit of measure	decimal	15	3
17	S123	Customer / material group	56	UMSMNG	Third-party sales quantity in BUn	decimal	15	3
18	S124	Customer / material	55	UMSMNG	Third-party sales quantity in BUn	decimal	15	3
19	S130	Replenishment	14	UMSMNG	Sales quantity in base unit of measure	decimal	15	3
20	S160	Perishables	59	UMSMNG	Sales quantity in base unit of measure	decimal	15	3
21	S685	MAP IRT350	18	UMSMNG	Umsatz Menge in BME	decimal	15	3
22	S730	copy of S130 Repl.m 4 VMI XI	14	UMSMNG	Sales quantity in base unit of measure	decimal	15	3
23	S952	Reference Structure for Generating Info Structures	36	UMSMNG	Sales quantity in base unit of measure	decimal	15	3
24	S953	BW Vorl.für BON/Artikel S117	36	UMSMNG	Bon-Umsatz Menge in Basismengeneinheit	decimal	15	3
25	S954	BW Vorl.für BON S119	23	UMSMNG	Bon-Umsatz Menge in Basismengeneinheit	decimal	15	3
26	S955	Istdatenspeicher MAP - BW	32	UMSMNG	Umsatz Menge in BME	decimal	15	3
27	S958	Reference Structure for Generating Info Structures	30	UMSMNG	Sales quantity in base unit of measure	decimal	15	3
TOPMerchandise and Assortment Planning
28	S202	MAP: Merchandise Planning Structure	36	UMSMNG	Sales quantity in base unit of measure	decimal	15	3
29	S204	MAP: Merchandise Planning Movements	30	UMSMNG	Sales quantity in base unit of measure	decimal	15	3
30	S214	CatMan: Indizees für ROP	19	UMSMNG	Omzethoeveelheid in BEh	decimal	15	3
31	S214BIW1	S214BIW1 * CatMan: Indexes for Space Management Program	19	UMSMNG	Sales quantity in base unit of measure	decimal	15	3
32	S214BIW2	S214BIW2 * CatMan: Indexes for Space Management Program	19	UMSMNG	Sales quantity in base unit of measure	decimal	15	3
33	S216	MAP: Average Retail WOC	19	UMSMNG	Sales quantity in base unit of measure	decimal	15	3
34	S217	MAP: AvgRetail MON	19	UMSMNG	Sales quantity in base unit of measure	decimal	15	3
35	S218	MAP: AvgRetail BUP	19	UMSMNG	Sales quantity in base unit of measure	decimal	15	3
36	S219	CatMan: Feine Ebene	25	UMSMNG	Omzethoeveelheid in BEh	decimal	15	3
37	S219BIW1	S219BIW1 * CatMan: Fine Level	25	UMSMNG	Sales quantity in base unit of measure	decimal	15	3
38	S219BIW2	S219BIW2 * CatMan: Detailed Level	25	UMSMNG	Sales quantity in base unit of measure	decimal	15	3
TOPPurchasing
39	WDFR1	Requirements Planning for Perishables	10	UMSMNG	Sales quantity in base unit of measure	decimal	15	3

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

39 columns | ERP 6.0 | UMSMNG