	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

131 columns | ERP 6.0 | SCALE_DIM

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	/1CN/CBPSAP001	Vendor/product	17	SCALE_DIM	Dimenstion number	nvarchar	2	0
2	/1CN/CBPSAP016	Contract Item	16	SCALE_DIM	Dimenstion number	nvarchar	2	0
3	/1CN/CBPSAP019	Contract Header	16	SCALE_DIM	Dimenstion number	nvarchar	2	0
4	/1CN/CBPSAP068	Location-Dependent	17	SCALE_DIM	Dimenstion number	nvarchar	2	0
5	/1CN/CBPSAP118	Product	16	SCALE_DIM	Dimenstion number	nvarchar	2	0
6	/1CN/CMFSAPH0FOR	PrcCondTyp/Purch.Org./Schema Grp/Vendor/Suppl.Vndr	20	SCALE_DIM	Dimenstion number	nvarchar	2	0
7	/1CN/CMFSAPH1FDT	PrcCondTyp/Purch.Org./Schema Grp/Vendor/Suppl.Vndr	20	SCALE_DIM	Dimenstion number	nvarchar	2	0
8	/1CN/CMFSAPH1FFX	PrcCondTyp/Purch.Org./Schema Grp/Vendor/Suppl.Vndr	20	SCALE_DIM	Dimenstion number	nvarchar	2	0
9	/1CN/CMFSAPH2TGR	PrcCondTyp/Purch.Org./Schema Grp/Vendor/Suppl.Vndr/Term No.	21	SCALE_DIM	Dimenstion number	nvarchar	2	0
10	/1CN/CMFSAPH2TRM	PrcCondTyp/Purch.Org./Schema Grp/Vendor/Suppl.Vndr/Term No.	21	SCALE_DIM	Dimenstion number	nvarchar	2	0
11	/1CN/CMFSAPH3TCT	PrcCondTyp/Purch.Org./Schema Grp/Vendor/Suppl.Vndr/Term No.	21	SCALE_DIM	Dimenstion number	nvarchar	2	0
12	/1CN/CMFSAPH3TUS	PrcCondTyp/Purch.Org./Schema Grp/Vendor/Suppl.Vndr/Term No.	21	SCALE_DIM	Dimenstion number	nvarchar	2	0
13	/1CN/CMFSAPH4TFX	PrcCondTyp/Purch.Org./Schema Grp/Vendor/Suppl.Vndr/Term No.	21	SCALE_DIM	Dimenstion number	nvarchar	2	0
14	/1CN/CMFSAPH4TQU	PrcCondTyp/Purch.Org./Schema Grp/Vendor/Suppl.Vndr/Term No.	21	SCALE_DIM	Dimenstion number	nvarchar	2	0
15	/1CN/CMFSAPH4TRF	PrcCondTyp/Purch.Org./Schema Grp/Vendor/Suppl.Vndr/Term No.	21	SCALE_DIM	Dimenstion number	nvarchar	2	0
16	/1CN/CMFSAPH4TRU	PrcCondTyp/Purch.Org./Schema Grp/Vendor/Suppl.Vndr/Term No.	21	SCALE_DIM	Dimenstion number	nvarchar	2	0
17	/1CN/CMFSAPH5TCR	PrcCondTyp/Purch.Org./Schema Grp/Vendor/Suppl.Vndr/Term No.	21	SCALE_DIM	Dimenstion number	nvarchar	2	0
18	/1CN/CMFSAPH5TPC	PrcCondTyp/Purch.Org./Schema Grp/Vendor/Suppl.Vndr/Term No.	21	SCALE_DIM	Dimenstion number	nvarchar	2	0
19	/1CN/CMFSAPH5TPQ	PrcCondTyp/Purch.Org./Schema Grp/Vendor/Suppl.Vndr/Term No.	21	SCALE_DIM	Dimenstion number	nvarchar	2	0
20	/1CN/CMFSAPH5TSU	PrcCondTyp/Purch.Org./Schema Grp/Vendor/Suppl.Vndr/Term No.	21	SCALE_DIM	Dimenstion number	nvarchar	2	0
21	/1CN/CMFSAPI0FOR	Condition Table	24	SCALE_DIM	Dimenstion number	nvarchar	2	0
22	/1CN/CMFSAPI0MST	CPE Condition Table: Formula Key for Stock Exposure	19	SCALE_DIM	Dimenstion number	nvarchar	2	0
23	/1CN/CMFSAPI1FDT	Condition Table	24	SCALE_DIM	Dimenstion number	nvarchar	2	0
24	/1CN/CMFSAPI1FFX	Condition Table	24	SCALE_DIM	Dimenstion number	nvarchar	2	0
25	/1CN/CMFSAPI2TGR	Condition Table	25	SCALE_DIM	Dimenstion number	nvarchar	2	0
26	/1CN/CMFSAPI2TRM	Condition Table	25	SCALE_DIM	Dimenstion number	nvarchar	2	0
27	/1CN/CMFSAPI3TCT	Condition Table	25	SCALE_DIM	Dimenstion number	nvarchar	2	0
28	/1CN/CMFSAPI3TUS	Condition Table	25	SCALE_DIM	Dimenstion number	nvarchar	2	0
29	/1CN/CMFSAPI4TFX	Condition Table	25	SCALE_DIM	Dimenstion number	nvarchar	2	0
30	/1CN/CMFSAPI4TQU	Condition Table	25	SCALE_DIM	Dimenstion number	nvarchar	2	0
31	/1CN/CMFSAPI4TRF	Condition Table	25	SCALE_DIM	Dimenstion number	nvarchar	2	0
32	/1CN/CMFSAPI4TRU	Condition Table	25	SCALE_DIM	Dimenstion number	nvarchar	2	0
33	/1CN/CMFSAPI5TCR	Condition Table	25	SCALE_DIM	Dimenstion number	nvarchar	2	0
34	/1CN/CMFSAPI5TPC	Condition Table	25	SCALE_DIM	Dimenstion number	nvarchar	2	0
35	/1CN/CMFSAPI5TPQ	Condition Table	25	SCALE_DIM	Dimenstion number	nvarchar	2	0
36	/1CN/CMFSAPI5TSU	Condition Table	25	SCALE_DIM	Dimenstion number	nvarchar	2	0
37	/1CN/CMFZ_INCO	CPE Condition Table: Formula Key (Item)	21	SCALE_DIM	Dimenstion number	nvarchar	2	0
38	/1CN/CPASAP00001	Input Product	16	SCALE_DIM	Dimenstion number	nvarchar	2	0
39	/1CN/CPNSAP00001	Business Partner/Product (GUID)	17	SCALE_DIM	Dimenstion number	nvarchar	2	0
40	/1CN/CPTSAP00001	Business Partner/Product Group	17	SCALE_DIM	Dimenstion number	nvarchar	2	0
41	/1CN/CPTSAP00004	Business Partner/Product GUID	17	SCALE_DIM	Dimenstion number	nvarchar	2	0
42	/1CN/CPTSAP00005	Business Partner/Product Group/Product GUID	18	SCALE_DIM	Dimenstion number	nvarchar	2	0
43	/1CN/CPTSAP00006	Business Partner	16	SCALE_DIM	Dimenstion number	nvarchar	2	0
44	/1CN/CRMSAP_CARR	Airline	16	SCALE_DIM	Dimenstion number	nvarchar	2	0
45	/1CN/CRMSAP_CONN	Airline/Connection Number	17	SCALE_DIM	Dimenstion number	nvarchar	2	0
46	/1CN/CRMSAP_PART	Customer ID	16	SCALE_DIM	Dimenstion number	nvarchar	2	0
47	/1CN/CTXSAPD0001	Country/Cost Center/Product Usage	18	SCALE_DIM	Dimenstion number	nvarchar	2	0
48	/1CN/CTXSAPD0002	Country/Order/Product Usage	18	SCALE_DIM	Dimenstion number	nvarchar	2	0
49	/1CN/CTXSAPD0003	Country/Product Usage	17	SCALE_DIM	Dimenstion number	nvarchar	2	0
50	/1CN/CTXSAPD0004	Country	16	SCALE_DIM	Dimenstion number	nvarchar	2	0
51	/1CN/CTXSAPD0201	Country/Tax Code	17	SCALE_DIM	Dimenstion number	nvarchar	2	0
52	/1CN/CTXSAPR0100	Country/Product Tax Group/Business Partner Tax Group	18	SCALE_DIM	Dimenstion number	nvarchar	2	0
53	/1CN/CTXSAPR0103	Country/Product Tax Group	17	SCALE_DIM	Dimenstion number	nvarchar	2	0
54	/1CN/CTXSAPR0104	Country	16	SCALE_DIM	Dimenstion number	nvarchar	2	0
55	/1CN/CTXSAPR0105	Country/Tax Event	17	SCALE_DIM	Dimenstion number	nvarchar	2	0
56	/1CN/CTXSAPR0106	Country/Region/Product Tax Group/Business Partner Tax Group	19	SCALE_DIM	Dimenstion number	nvarchar	2	0
57	/1CN/CTXSAPR0107	Country/Tax Event/ST Jurisdiction Code	18	SCALE_DIM	Dimenstion number	nvarchar	2	0
58	/1CN/CTXSAPR0108	Country/Region/Product Tax Group	18	SCALE_DIM	Dimenstion number	nvarchar	2	0
59	/1CN/CTXSAPR0110	Country/1L Sppl.Jur.Code/1L Rec.Jur.Code	18	SCALE_DIM	Dimenstion number	nvarchar	2	0
60	/1CN/CTXSAPR0111	Country/2L Sppl.Jur.Code/2L Rec.Jur.Code	18	SCALE_DIM	Dimenstion number	nvarchar	2	0
61	/1CN/CTXSAPR0112	Country/2L Sppl.Jur.Code/2L Rec.Jur.Code/Tax Tariff Code	19	SCALE_DIM	Dimenstion number	nvarchar	2	0
62	/1CN/CTXSAPR0113	Country/2L Sppl.Jur.Code/2L Rec.Jur.Code/Product Tax Group	19	SCALE_DIM	Dimenstion number	nvarchar	2	0
63	/1CN/CTXSAPR0120	Country/Tax Tariff Code	17	SCALE_DIM	Dimenstion number	nvarchar	2	0
64	/1CN/CTXSAPR0130	Country/3L Jur.Code	17	SCALE_DIM	Dimenstion number	nvarchar	2	0
65	/1CN/CTXSAPR0131	Country/3L Jur.Code/Product Tax Group	18	SCALE_DIM	Dimenstion number	nvarchar	2	0
66	/1CN/CTXSAPR0140	Country/Tax Event/Jurisdiction Code	18	SCALE_DIM	Dimenstion number	nvarchar	2	0
67	/1CN/CTXSAPR0201	Country/Tax Code	17	SCALE_DIM	Dimenstion number	nvarchar	2	0
68	/1CN/CTXSAPRBR01	Country/Tax Tariff Code	17	SCALE_DIM	Dimenstion number	nvarchar	2	0
69	/1CN/CTXSAPRBR02	Country/Product Tax Group	17	SCALE_DIM	Dimenstion number	nvarchar	2	0
70	/1CN/CTXSAPRBR03	Country/Product Tax Group/Business Partner Tax Group	18	SCALE_DIM	Dimenstion number	nvarchar	2	0
71	/1CN/CTXSAPRBR10	Country/1L Sppl.Jur.Code/1L Rec.Jur.Code	18	SCALE_DIM	Dimenstion number	nvarchar	2	0
72	/1CN/CTXSAPRBR11	Country/1L Sppl.Jur.Code/1L Rec.Jur.Code/Tax Tariff Code	19	SCALE_DIM	Dimenstion number	nvarchar	2	0
73	/1CN/CTXSAPRBR12	Country/1L Sppl.Jur.Code/1L Rec.Jur.Code/Product Tax Group	19	SCALE_DIM	Dimenstion number	nvarchar	2	0
74	/1CN/CTXSAPRBR20	Country/2L Jur.Code	17	SCALE_DIM	Dimenstion number	nvarchar	2	0
75	/1CN/CTXSAPRBR21	Country/2L Jur.Code/Product Tax Group	18	SCALE_DIM	Dimenstion number	nvarchar	2	0
76	/1CN/CTXSAPRIN03	Country/Tax Tariff Code/Business Partner ID	18	SCALE_DIM	Dimenstion number	nvarchar	2	0
77	/1CN/CTXSAPRIN04	Recipient Country/Tax Tariff Code/Business Partner ID	18	SCALE_DIM	Dimenstion number	nvarchar	2	0
78	/1CN/CTXSAPRIN06	Country/Spl Reg./Rec Region/Tax Group/Tax Group	20	SCALE_DIM	Dimenstion number	nvarchar	2	0
79	/1CN/CTXSAPRIN07	Country/Partner ID/Recip. Tax Region/Tax Group	19	SCALE_DIM	Dimenstion number	nvarchar	2	0
80	/1CN/CTXSAPS0100	Country/Business Process	17	SCALE_DIM	Dimenstion number	nvarchar	2	0
81	/1CN/CTXSAPS0101	Country/Bus. Transaction	17	SCALE_DIM	Dimenstion number	nvarchar	2	0
82	/1CN/CTXSAPS0102	Country/Bus. Transaction	17	SCALE_DIM	Dimenstion number	nvarchar	2	0
83	/1CN/CTXSAPW0201	Country/Tax Code	17	SCALE_DIM	Dimenstion number	nvarchar	2	0
84	/1CN/CTXSAPW0202	Country/Business Partner Tax Group	17	SCALE_DIM	Dimenstion number	nvarchar	2	0
85	/1CN/CTXSAPX0100	Country/Region	17	SCALE_DIM	Dimenstion number	nvarchar	2	0
86	/1CN/CTXSAPX0101	Country/Supplier BP ID/Business Partner ID	18	SCALE_DIM	Dimenstion number	nvarchar	2	0
87	/1CN/CTXSAPX0102	Country/Business Partner Tax Group	17	SCALE_DIM	Dimenstion number	nvarchar	2	0
88	/1CN/CTXSAPX0103	Country/Supplier BP ID/Business Partner ID/Product Tax Group	19	SCALE_DIM	Dimenstion number	nvarchar	2	0
89	/1CN/CTXSAPX0104	Recipient Country/Recipient Tax Region/Locat. Relationship	18	SCALE_DIM	Dimenstion number	nvarchar	2	0
90	/1CN/CTXSAPX0105	Country/Product Tax Group	17	SCALE_DIM	Dimenstion number	nvarchar	2	0
91	/1CN/CTXSAPX0106	Country/Region/Product Tax Group	18	SCALE_DIM	Dimenstion number	nvarchar	2	0
92	/1CN/CTXSAPX0140	Country/Product Tax Group/Jurisdiction Code	18	SCALE_DIM	Dimenstion number	nvarchar	2	0
93	/1CN/CTXSAPX0141	Country/Business Partner Tax Group/Jurisdiction Code	18	SCALE_DIM	Dimenstion number	nvarchar	2	0
94	/1CN/CTXSAPX0146	Country/Region/Product Tax Group	18	SCALE_DIM	Dimenstion number	nvarchar	2	0
95	/1CN/CTXSAPX0147	Country/Region/Business Partner Tax Group	18	SCALE_DIM	Dimenstion number	nvarchar	2	0
96	/1CN/CTXSAPX0148	Country	16	SCALE_DIM	Dimenstion number	nvarchar	2	0
97	/1CN/CTXSAPXBR01	Country/Tax Tariff Code	17	SCALE_DIM	Dimenstion number	nvarchar	2	0
98	/1CN/CTXSAPXBR02	Country/Product Tax Group	17	SCALE_DIM	Dimenstion number	nvarchar	2	0
99	/1CN/CTXSAPXBR03	Country/Product Tax Group/Business Partner Tax Group	18	SCALE_DIM	Dimenstion number	nvarchar	2	0
100	/1CN/CTXSAPXBR11	Country/1L Sppl.Jur.Code/1L Rec.Jur.Code/Tax Tariff Code	19	SCALE_DIM	Dimenstion number	nvarchar	2	0
101	/1CN/CVFSAPH0FOR	Condition Table	22	SCALE_DIM	Dimenstion number	nvarchar	2	0
102	/1CN/CVFSAPH1FDT	Condition Table	22	SCALE_DIM	Dimenstion number	nvarchar	2	0
103	/1CN/CVFSAPH1FFX	Condition Table	22	SCALE_DIM	Dimenstion number	nvarchar	2	0
104	/1CN/CVFSAPH2TGR	Condition Table	23	SCALE_DIM	Dimenstion number	nvarchar	2	0
105	/1CN/CVFSAPH2TRM	Condition Table	23	SCALE_DIM	Dimenstion number	nvarchar	2	0
106	/1CN/CVFSAPH3TCT	Condition Table	23	SCALE_DIM	Dimenstion number	nvarchar	2	0
107	/1CN/CVFSAPH3TUS	Condition Table	23	SCALE_DIM	Dimenstion number	nvarchar	2	0
108	/1CN/CVFSAPH4TFX	Condition Table	23	SCALE_DIM	Dimenstion number	nvarchar	2	0
109	/1CN/CVFSAPH4TQU	Condition Table	23	SCALE_DIM	Dimenstion number	nvarchar	2	0
110	/1CN/CVFSAPH4TRF	Condition Table	23	SCALE_DIM	Dimenstion number	nvarchar	2	0
111	/1CN/CVFSAPH4TRU	Condition Table	23	SCALE_DIM	Dimenstion number	nvarchar	2	0
112	/1CN/CVFSAPH5TCR	Condition Table	23	SCALE_DIM	Dimenstion number	nvarchar	2	0
113	/1CN/CVFSAPH5TPC	Condition Table	23	SCALE_DIM	Dimenstion number	nvarchar	2	0
114	/1CN/CVFSAPH5TPQ	Condition Table	23	SCALE_DIM	Dimenstion number	nvarchar	2	0
115	/1CN/CVFSAPH5TSU	Condition Table	23	SCALE_DIM	Dimenstion number	nvarchar	2	0
116	/1CN/CVFSAPI0FOR	Condition Table	24	SCALE_DIM	Dimenstion number	nvarchar	2	0
117	/1CN/CVFSAPI1FDT	Condition Table	24	SCALE_DIM	Dimenstion number	nvarchar	2	0
118	/1CN/CVFSAPI1FFX	Condition Table	24	SCALE_DIM	Dimenstion number	nvarchar	2	0
119	/1CN/CVFSAPI2TGR	Condition Table	25	SCALE_DIM	Dimenstion number	nvarchar	2	0
120	/1CN/CVFSAPI2TRM	Condition Table	25	SCALE_DIM	Dimenstion number	nvarchar	2	0
121	/1CN/CVFSAPI3TCT	Condition Table	25	SCALE_DIM	Dimenstion number	nvarchar	2	0
122	/1CN/CVFSAPI3TUS	Condition Table	25	SCALE_DIM	Dimenstion number	nvarchar	2	0
123	/1CN/CVFSAPI4TFX	Condition Table	25	SCALE_DIM	Dimenstion number	nvarchar	2	0
124	/1CN/CVFSAPI4TQU	Condition Table	25	SCALE_DIM	Dimenstion number	nvarchar	2	0
125	/1CN/CVFSAPI4TRF	Condition Table	25	SCALE_DIM	Dimenstion number	nvarchar	2	0
126	/1CN/CVFSAPI4TRU	Condition Table	25	SCALE_DIM	Dimenstion number	nvarchar	2	0
127	/1CN/CVFSAPI5TCR	Condition Table	25	SCALE_DIM	Dimenstion number	nvarchar	2	0
128	/1CN/CVFSAPI5TPC	Condition Table	25	SCALE_DIM	Dimenstion number	nvarchar	2	0
129	/1CN/CVFSAPI5TPQ	Condition Table	25	SCALE_DIM	Dimenstion number	nvarchar	2	0
130	/1CN/CVFSAPI5TSU	Condition Table	25	SCALE_DIM	Dimenstion number	nvarchar	2	0
TOPPricing
131	PRCM_TABL_000	Reference Table for Condition Tables (A000)	16	SCALE_DIM	Dimenstion number	nvarchar	2	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

131 columns | ERP 6.0 | SCALE_DIM