	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	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
7	/ISDFPS/CHVW_E	34	External Batch Where-Used List
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	FMARCPAR	4	Parallelization of FMARC_BATCH
10	CEKRS	5	Movement type parameters for automatic ERS

	Table	Columns	Description
1	OITM	299	Items
2	OINV	386	A/R Invoice
3	OCRD	332	Business Partner
4	ORDR	386	Sales Order
5	INV1	265	A/R Invoice - Rows
6	OJDT	100	Journal Entry
7	OPCH	386	A/P Invoice
8	OVTG	52	Tax Definition
9	OPOR	386	Purchase Order
10	JDT1	124	Journal Entry - Rows

	Table	Columns	Description
1	OITM	249	Items
2	ORCT	154	Incoming Payment
3	OINV	268	A/R Invoice
4	OVPM	154	Outgoing Payments
5	OIVL	77	Whse Journal
6	OPCH	268	A/P Invoice
7	JDT1	110	Journal Entry - Rows
8	OOCR	9	Loading Factors
9	OSRN	20	Serial Numbers Master Data
10	OBOT	10	Bill Of Exchang Transaction

83 columns | ERP 6.0 | WGRU1

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

83 columns | ERP 6.0 | WGRU1