	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

71 columns | ERP 6.0 | MVGR1

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	/1CADMC/00000523	TVM1	5	MVGR1		nvarchar	3	0
2	/1CADMC/00000524	TVM1T	6	MVGR1		nvarchar	3	0
3	/1RA/0SD010MI	Items for Class SD01 - Raw Data	96	MVGR1	Material group 1	nvarchar	3	0
4	/BIC/B0000177000	PSA for 2LIS_11_V_ITM T90CLNT090 Sls-Ship.Alloc.Item	35	MVGR1		nvarchar	3	0
5	/BIC/B0000178000	PSA for 2LIS_11_VAITM T90CLNT090 Sales Doc. Item	69	MVGR1		nvarchar	3	0
6	/BIC/B0000179000	PSA for 2LIS_11_VASCL T90CLNT090 Sales Doc. Schedule	66	MVGR1		nvarchar	3	0
7	/BIC/B0000180000	PSA for 2LIS_11_V_SCL T90CLNT090 Sls-Ship.Alloc.Sch.	47	MVGR1		nvarchar	3	0
8	/BIC/B0000181000	PSA for 2LIS_11_VAKON T90CLNT090 Sales Document Cond.	43	MVGR1		nvarchar	3	0
9	/BIC/B0000183000	PSA for 2LIS_12_VCITM T90CLNT090 Delivery Item	63	MVGR1		nvarchar	3	0
10	/BIC/B0000185000	PSA for 2LIS_13_VDITM T90CLNT090 Billing Doc. Item	64	MVGR1		nvarchar	3	0
11	/BIC/B0000186000	PSA for 2LIS_13_VDKON T90CLNT090 Billing Docu. Cond.	47	MVGR1		nvarchar	3	0
12	/SMD/MD_____00S1	SID-Tabelle fuer Material group 1	3	MVGR1	Material group 1	nvarchar	3	0
13	A636	Camp. ID/Matl grp 1	5	MVGR1	Material group 1	nvarchar	3	0
14	A653	Camp. ID/Matl grp 1	5	MVGR1	Material group 1	nvarchar	3	0
15	CE1PR22	Périm. résultat IDES	58	MVGR1	Groupe d'articles 1	nvarchar	3	0
16	CE2PR22	Périm. résultat IDES	42	MVGR1	Groupe d'articles 1	nvarchar	3	0
17	CE4PR22	Périm. résultat IDES	27	MVGR1	Groupe d'articles 1	nvarchar	3	0
18	CE4PR22_ACCT	Périm. résultat IDES	28	MVGR1	Groupe d'articles 1	nvarchar	3	0
19	CE4PR22_FLAG	Périm. résultat IDES	24	MVGR1	Flag : caract. imputée manuellement ou via TKEZU	nvarchar	1	0
20	CE4PR22_KENC	Périm. résultat IDES	26	MVGR1	Groupe d'articles 1	nvarchar	3	0
21	ZEIM_LIPS	SD document: Delivery: Item data	94	MVGR1	Material group 1	nvarchar	3	0
22	ZEIM_VBAP	Sales Document: Item Data	124	MVGR1	Material group 1	nvarchar	3	0
TOPAccount Determination
23	TVM1	Material Pricing Group 1	2	MVGR1	Material group 1	nvarchar	3	0
24	TVM1T	Material pricing group 1: Description	3	MVGR1	Material group 1	nvarchar	3	0
TOPBilling
25	VBRP	Billing Document: Item Data	94	MVGR1	Material group 1	nvarchar	3	0
TOPConditions
26	A523	Camp. ID/Matl grp 1	5	MVGR1	Material group 1	nvarchar	3	0
27	A525	Camp. ID/Customer/Matl grp 1	6	MVGR1	Material group 1	nvarchar	3	0
28	KOTE523	Camp. ID/Customer/Matl grp 1	6	MVGR1	Material group 1	nvarchar	3	0
29	KOTE524	Camp. ID/Customer/Matl grp 1	6	MVGR1	Material group 1	nvarchar	3	0
TOPCross-Application Components
30	VVBAP	Sales Document: Item Data	124	MVGR1	Material group 1	nvarchar	3	0
TOPData Collection
31	S260	SD - Sales order	51	MVGR1	Material group 1	nvarchar	3	0
32	S260BIW1	SD - Sales order	51	MVGR1	Material group 1	nvarchar	3	0
33	S260BIW2	SD - Sales order	51	MVGR1	Material group 1	nvarchar	3	0
34	S261	SD - Delivery note	72	MVGR1	Material group 1	nvarchar	3	0
35	S261BIW1	SD - Delivery note	72	MVGR1	Material group 1	nvarchar	3	0
36	S261BIW2	SD - Delivery note	72	MVGR1	Material group 1	nvarchar	3	0
37	S262	SD - Billing document	60	MVGR1	Material group 1	nvarchar	3	0
38	S262BIW1	SD - Billing document	60	MVGR1	Material group 1	nvarchar	3	0
39	S262BIW2	SD - Billing document	60	MVGR1	Material group 1	nvarchar	3	0
40	S263	SD - Sales order/delivery note	46	MVGR1	Material group 1	nvarchar	3	0
41	S263BIW1	SD - Sales order/delivery note	46	MVGR1	Material group 1	nvarchar	3	0
42	S263BIW2	SD - Sales order/delivery note	46	MVGR1	Material group 1	nvarchar	3	0
43	S264	SD- Offer	53	MVGR1	Material group 1	nvarchar	3	0
44	S264BIW1	S264BIW1 * SD - Quotation	53	MVGR1	Material group 1	nvarchar	3	0
45	S264BIW2	S264BIW2 * SD - Quotation	53	MVGR1	Material group 1	nvarchar	3	0
TOPLogistics - General
46	WBHI	Trading Contract: Item Data	59	MVGR1	Material group 1	nvarchar	3	0
TOPMaterial Master
47	MVKE	Sales Data for Material	24	MVGR1	Material group 1	nvarchar	3	0
48	MVKE_TMP	File for Incorrect Data in Direct Input	27	MVGR1	Material group 1	nvarchar	3	0
49	MVVE	Sales Data for Material	24	MVGR1	Material group 1	nvarchar	3	0
TOPProfitability Analysis
50	CE1IDEA	Op. Concern BR World	58	MVGR1	Material group 1	nvarchar	3	0
51	CE1IDES	Ergebnisbereich IDES	58	MVGR1	Materialgruppe 1	nvarchar	3	0
52	CE1INT1	Ergebnisbereich IDES	58	MVGR1	Materialgruppe 1	nvarchar	3	0
53	CE2IDEA	Op. Concern BR World	42	MVGR1	Material group 1	nvarchar	3	0
54	CE2IDES	Ergebnisbereich IDES	42	MVGR1	Materialgruppe 1	nvarchar	3	0
55	CE2INT1	Ergebnisbereich IDES	42	MVGR1	Materialgruppe 1	nvarchar	3	0
56	CE4IDEA	Op. Concern BR World	27	MVGR1	Material group 1	nvarchar	3	0
57	CE4IDEA_ACCT	Op. Concern BR World	28	MVGR1	Material group 1	nvarchar	3	0
58	CE4IDEA_FLAG	Op. Concern BR World	24	MVGR1	Flag: Characteristic Assigned Manually or Using TKEZU	nvarchar	1	0
59	CE4IDEA_KENC	Op. Concern BR World	26	MVGR1	Material group 1	nvarchar	3	0
60	CE4IDES	Ergebnisbereich IDES	27	MVGR1	Materialgruppe 1	nvarchar	3	0
61	CE4IDES_ACCT	Ergebnisbereich IDES	28	MVGR1	Materialgruppe 1	nvarchar	3	0
62	CE4IDES_FLAG	Ergebnisbereich IDES	24	MVGR1	Flag: Merkmal manuell oder über TKEZU kontiert	nvarchar	1	0
63	CE4IDES_KENC	Ergebnisbereich IDES	26	MVGR1	Materialgruppe 1	nvarchar	3	0
64	CE4INT1	Ergebnisbereich IDES	27	MVGR1	Materialgruppe 1	nvarchar	3	0
65	CE4INT1_ACCT	Ergebnisbereich IDES	28	MVGR1	Materialgruppe 1	nvarchar	3	0
66	CE4INT1_FLAG	Ergebnisbereich IDES	24	MVGR1	Flag: Merkmal manuell oder über TKEZU kontiert	nvarchar	1	0
67	CE4INT1_KENC	Ergebnisbereich IDES	26	MVGR1	Materialgruppe 1	nvarchar	3	0
TOPRemaining Beverage - Obsolete Objects
68	/BEV1/RBVBAP	Sales Document: Item Data	124	MVGR1	Material group 1	nvarchar	3	0
TOPSales
69	VBAP	Sales Document: Item Data	124	MVGR1	Material group 1	nvarchar	3	0
TOPShipping
70	LIPS	SD document: Delivery: Item data	94	MVGR1	Material group 1	nvarchar	3	0
TOPSimulation
71	VSVBAP_CN	Version: Sales document: Item data	125	MVGR1	Material group 1	nvarchar	3	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

71 columns | ERP 6.0 | MVGR1