	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

85 columns | ERP 6.0 | WGRU2

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	/1ISRWP/800H0105	Waren & Sortimentscontrolling: Planungshierarchietabelle	6	WGRU2	Warengruppenhierarchie 2	nvarchar	18	0
2	/1ISRWP/800H0106	Waren & Sortimentscontrolling: Planungshierarchietabelle	6	WGRU2	Warengruppenhierarchie 2	nvarchar	18	0
3	/1ISRWP/800H0107	Waren & Sortimentscontrolling: Planungshierarchietabelle	6	WGRU2	Warengruppenhierarchie 2	nvarchar	18	0
4	/1ISRWP/800H0110	Waren & Sortimentscontrolling: Planungshierarchietabelle	6	WGRU2	Warengruppenhierarchie 2	nvarchar	18	0
5	/1ISRWP/800H0111	Waren & Sortimentscontrolling: Planungshierarchietabelle	6	WGRU2	Warengruppenhierarchie 2	nvarchar	18	0
6	/1ISRWP/800H0112	Waren & Sortimentscontrolling: Planungshierarchietabelle	6	WGRU2	Warengruppenhierarchie 2	nvarchar	18	0
7	/1ISRWP/800H0113	Waren & Sortimentscontrolling: Planungshierarchietabelle	6	WGRU2	Warengruppenhierarchie 2	nvarchar	18	0
8	/1ISRWP/800H0204	MAC: Planning Hierarchy Tables	5	WGRU2	Material group hierarchy 2	nvarchar	18	0
9	/1ISRWP/800H0205	MAC: Planning Hierarchy Tables	5	WGRU2	Material group hierarchy 2	nvarchar	18	0
10	/1ISRWP/800H0206	MAC: Planning Hierarchy Tables	5	WGRU2	Material group hierarchy 2	nvarchar	18	0
11	/1ISRWP/800H0208	MAC: Planning Hierarchy Tables	5	WGRU2	Material group hierarchy 2	nvarchar	18	0
12	/1ISRWP/800H0209	MAC: Planning Hierarchy Tables	5	WGRU2	Material group hierarchy 2	nvarchar	18	0
13	/1RA/0SD010MI	Items for Class SD01 - Raw Data	136	WGRU2	Material group hierarchy 2	nvarchar	18	0
14	S540E	S540 - Structural information	5	WGRU2	Material group hierarchy 2	nvarchar	18	0
15	S952E	S952 - Structural information	7	WGRU2	Material group hierarchy 2	nvarchar	18	0
16	S955E	S955 - Strukturinformationen	10	WGRU2	Warengruppenhierarchie 2	nvarchar	18	0
17	ZEIM_VBAP	Sales Document: Item Data	197	WGRU2	Material group hierarchy 2	nvarchar	18	0
TOPBilling
18	VBRP	Billing Document: Item Data	158	WGRU2	Material group hierarchy 2	nvarchar	18	0
TOPCross-Application Components
19	VVBAP	Sales Document: Item Data	197	WGRU2	Material group hierarchy 2	nvarchar	18	0
TOPData Collection
20	S077	STRPS: Movements	14	WGRU2	Material group hierarchy 2	nvarchar	18	0
21	S077E	S077 - Structural Information	9	WGRU2	Material group hierarchy 2	nvarchar	18	0
22	S078	STRPS: Stock	8	WGRU2	Material group hierarchy 2	nvarchar	18	0
23	S078E	S078 - Structural Informaton	9	WGRU2	Material group hierarchy 2	nvarchar	18	0
24	S079	STRPS: Movements + Stock	14	WGRU2	Material group hierarchy 2	nvarchar	18	0
25	S079E	S079 - Structural Information	9	WGRU2	Material group hierarchy 2	nvarchar	18	0
26	S080	Purchasing: Movements	14	WGRU2	Material group hierarchy 2	nvarchar	18	0
27	S080E	S080 - Structural Information	9	WGRU2	Material group hierarchy 2	nvarchar	18	0
28	S081	Purchasing: Stock	8	WGRU2	Material group hierarchy 2	nvarchar	18	0
29	S081E	S081 - Structural Information	9	WGRU2	Material group hierarchy 2	nvarchar	18	0
30	S082	Purchasing: Movements + Stock	14	WGRU2	Material group hierarchy 2	nvarchar	18	0
31	S082E	S082 - Structural Information	9	WGRU2	Material group hierarchy 2	nvarchar	18	0
32	S083	Material: Movements	11	WGRU2	Material group hierarchy 2	nvarchar	18	0
33	S083E	S083 - Structural Information	6	WGRU2	Material group hierarchy 2	nvarchar	18	0
34	S084	Material: Stock	5	WGRU2	Material group hierarchy 2	nvarchar	18	0
35	S084E	S084 - Structural Information	6	WGRU2	Material group hierarchy 2	nvarchar	18	0
36	S085	Material: Movements + Stock	11	WGRU2	Material group hierarchy 2	nvarchar	18	0
37	S085E	S085 - Structural Information	6	WGRU2	Material group hierarchy 2	nvarchar	18	0
38	S086	Promotion	11	WGRU2	Material group hierarchy 2	nvarchar	18	0
39	S086E	S086 - Structural Information	6	WGRU2	Material group hierarchy 2	nvarchar	18	0
40	S105	Season: Movements	72	WGRU2	Material group hierarchy 2	nvarchar	18	0
41	S106	Season: Stock	34	WGRU2	Material group hierarchy 2	nvarchar	18	0
42	S107	Season: Movements + Stock	107	WGRU2	Material group hierarchy 2	nvarchar	18	0
43	S110	OTB	12	WGRU2	Material group hierarchy 2	nvarchar	18	0
44	S110E	S110 - Structural Information	7	WGRU2	Material group hierarchy 2	nvarchar	18	0
45	S123	Customer / material group	14	WGRU2	Material group hierarchy 2	nvarchar	18	0
46	S123E	S123 - Structural Information	9	WGRU2	Material group hierarchy 2	nvarchar	18	0
47	S124	Customer / material	10	WGRU2	Material group hierarchy 2	nvarchar	18	0
48	S124E	S124 - Structural Information	5	WGRU2	Material group hierarchy 2	nvarchar	18	0
49	S200	Inventory Controlling Stores	38	WGRU2	Material group hierarchy 2	nvarchar	18	0
50	S540	Reference Structure for Generating Info Structures	10	WGRU2	Material group hierarchy 2	nvarchar	18	0
51	S952	Reference Structure for Generating Info Structures	12	WGRU2	Material group hierarchy 2	nvarchar	18	0
52	S955	Istdatenspeicher MAP - BW	15	WGRU2	Warengruppenhierarchie 2	nvarchar	18	0
53	S958	Reference Structure for Generating Info Structures	27	WGRU2	Material group hierarchy 2	nvarchar	18	0
TOPMerchandise and Assortment Planning
54	S202	MAP: Merchandise Planning Structure	7	WGRU2	Material group hierarchy 2	nvarchar	18	0
55	S202E	S202 - Structural Information	7	WGRU2	Material group hierarchy 2	nvarchar	18	0
56	S203	MAP: Merchandise Planning Stock	6	WGRU2	Material group hierarchy 2	nvarchar	18	0
57	S203E	S203 - Structural Information	7	WGRU2	Material group hierarchy 2	nvarchar	18	0
58	S204	MAP: Merchandise Planning Movements	7	WGRU2	Material group hierarchy 2	nvarchar	18	0
59	S204E	S204 - Structural Information	7	WGRU2	Material group hierarchy 2	nvarchar	18	0
60	S208	MAP: Assortment Planning	24	WGRU2	Material group hierarchy 2	nvarchar	18	0
61	S209	MAP: OTB Movements	7	WGRU2	Material group hierarchy 2	nvarchar	18	0
62	S209E	S209 - Structural Information	7	WGRU2	Material group hierarchy 2	nvarchar	18	0
63	S210	MAP: OTB Stock	6	WGRU2	Material group hierarchy 2	nvarchar	18	0
64	S210E	S210 - Structural Information	7	WGRU2	Material group hierarchy 2	nvarchar	18	0
65	S211	MAP: OTB Evaluation Structure	7	WGRU2	Material group hierarchy 2	nvarchar	18	0
66	S211E	S211 - Structural Information	7	WGRU2	Material group hierarchy 2	nvarchar	18	0
67	S216	MAP: Average Retail WOC	3	WGRU2	Material group hierarchy 2	nvarchar	18	0
68	S216E	S216 - Structural Information	3	WGRU2	Material group hierarchy 2	nvarchar	18	0
69	S217	MAP: AvgRetail MON	3	WGRU2	Material group hierarchy 2	nvarchar	18	0
70	S217E	S217 - Structural Information	3	WGRU2	Material group hierarchy 2	nvarchar	18	0
71	S218	MAP: AvgRetail BUP	3	WGRU2	Material group hierarchy 2	nvarchar	18	0
72	S218E	S218 - Structural Information	3	WGRU2	Material group hierarchy 2	nvarchar	18	0
73	TWISPA_AVERAGERT	Merchandise and Assortment Planning: Average Retail	2	WGRU2	Material group hierarchy 2	nvarchar	18	0
74	TWISPA_AVGRET	Merchandise and Assortment Planning: Average Retail	2	WGRU2	Material group hierarchy 2	nvarchar	18	0
75	TWISPC_ASORTZ	Assignment of Store Groups to Assortments	4	WGRU2	Material group hierarchy 2	nvarchar	18	0
76	TWISPC_FILGRPZ	Assignment of Stores to Store Groups	3	WGRU2	Material group hierarchy 2	nvarchar	18	0
TOPProfitability Analysis
77	CE1R300	Operating Concern IDES	61	WGRU2	Material group hierarchy 2	nvarchar	18	0
78	CE2R300	Operating Concern IDES	45	WGRU2	Material group hierarchy 2	nvarchar	18	0
79	CE4R300	Operating Concern IDES	30	WGRU2	Material group hierarchy 2	nvarchar	18	0
80	CE4R300_ACCT	Ergebnisbereich IDES	31	WGRU2	Warengruppenhierarchie 2	nvarchar	18	0
81	CE4R300_FLAG	Ergebnisbereich IDES	27	WGRU2	Flag: Merkmal manuell oder über TKEZU kontiert	nvarchar	1	0
82	CE4R300_KENC	Operating Concern IDES	29	WGRU2	Material group hierarchy 2	nvarchar	18	0
TOPRemaining Beverage - Obsolete Objects
83	/BEV1/RBVBAP	Sales Document: Item Data	197	WGRU2	Material group hierarchy 2	nvarchar	18	0
TOPSales
84	VBAP	Sales Document: Item Data	197	WGRU2	Material group hierarchy 2	nvarchar	18	0
TOPSimulation
85	VSVBAP_CN	Version: Sales document: Item data	198	WGRU2	Material group hierarchy 2	nvarchar	18	0

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

85 columns | ERP 6.0 | WGRU2