	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

168 columns | ERP 6.0 | DIMEN

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	/SMD/MD_____0059	SID-Tabelle fuer Dimension	3	DIMEN	Dimension	nvarchar	2	0
2	/SMD/MD_____005M	SID-Tabelle fuer Partner unit	3	DIMEN	Dimension	nvarchar	2	0
TOPCompensation Management
3	T71GD	Dimension Table	2	DIMEN	Dimension for compensation matrix	nvarchar	4	0
4	T71GDT	Text Table for Dimensions	3	DIMEN	Dimension for compensation matrix	nvarchar	4	0
5	T71GS	Segment Table for Dimensions	4	DIMEN	Dimension for compensation matrix	nvarchar	4	0
6	T71GST	Text Table for Dimension Segments	5	DIMEN	Dimension for compensation matrix	nvarchar	4	0
TOPConsolidation
7	ECMCO	SAP Cons.: Object Table Assignment Fields (Object/Partner)	8	DIMEN	Dimension	nvarchar	2	0
8	EWUCS10	SAP Cons.-EURO: Consolidation Units for Euro Conversion	3	DIMEN	Dimension	nvarchar	2	0
9	TF030	Dimension and Version-Dependent Settings	2	DIMEN	Dimension	nvarchar	2	0
10	TF080	List Directory of MCDX	2	DIMEN	Dimension	nvarchar	2	0
11	TF141	Selected FS Items	6	DIMEN	Dimension	nvarchar	2	0
12	TF150	Dimensions	2	DIMEN	Dimension	nvarchar	2	0
13	TF151	Dimensions: Texts and User-Specific Names	3	DIMEN	Dimension	nvarchar	2	0
14	TF152	Dimensions, Screen List, Consolidation Units	2	DIMEN	Dimension	nvarchar	2	0
15	TF153	Dimensions, Screen List, Consolidation Groups	2	DIMEN	Dimension	nvarchar	2	0
16	TF154	Dimensions year- and period-dependent	2	DIMEN	Dimension	nvarchar	2	0
17	TF155	Dimensions: Assign Task Groups	2	DIMEN	Dimension	nvarchar	2	0
18	TF160	Consolidation Units	2	DIMEN	Dimension	nvarchar	2	0
19	TF161	Consolidation Units: Texts	3	DIMEN	Dimension	nvarchar	2	0
20	TF162	Consolidation Unit Correspondence	2	DIMEN	Dimension	nvarchar	2	0
21	TF163	Consolidation Units, Version/Period-Based Attributes	2	DIMEN	Dimension	nvarchar	2	0
22	TF164	Consolidation Unit Year-Dependent	2	DIMEN	Dimension	nvarchar	2	0
23	TF165	Consolidation Units Version-Dependent	2	DIMEN	Dimension	nvarchar	2	0
24	TF166	Consolidation Units Version- and Period Category-Dependent	2	DIMEN	Dimension	nvarchar	2	0
25	TF167	Consolidation Units Version- and Period-Dependent	2	DIMEN	Dimension	nvarchar	2	0
26	TF168	Consolidation Units Ledger-Dependent	2	DIMEN	Dimension	nvarchar	2	0
27	TF169	Version/Period-Dependent Cons. Units: Tax Rates	2	DIMEN	Dimension	nvarchar	2	0
28	TF172	Contact Person Assignments	2	DIMEN	Dimension	nvarchar	2	0
29	TF180	Consolidation Groups	2	DIMEN	Dimension	nvarchar	2	0
30	TF181	Consolidation Groups: Texts	3	DIMEN	Dimension	nvarchar	2	0
31	TF182	Consolidation Groups, Version-Dependent	2	DIMEN	Dimension	nvarchar	2	0
32	TF183	Consolidation Groups, Version- and Period Categ.-Dependent	2	DIMEN	Dimension	nvarchar	2	0
33	TF183A	Consolidation Groups - Restricted Task Groups	2	DIMEN	Dimension	nvarchar	2	0
34	TF184	Consolidation Groups, Version- and Year-Dependent	2	DIMEN	Dimension	nvarchar	2	0
35	TF187	Consolidation Group Set Assignments	2	DIMEN	Dimension	nvarchar	2	0
36	TF188	Consolidation Group Assignment of Task Group	2	DIMEN	Dimension	nvarchar	2	0
37	TF189	Assignment of CG/CU, Version- and Period-Dependent	2	DIMEN	Dimension	nvarchar	2	0
38	TF189A	Inactive Consolidation Units per Consolidation Group	2	DIMEN	Dimension	nvarchar	2	0
39	TF190	Hierarchies	2	DIMEN	Dimension	nvarchar	2	0
40	TF191	Hierarchies: texts	3	DIMEN	Dimension	nvarchar	2	0
41	TF192	Hierarchies, Period-Dependent	2	DIMEN	Dimension	nvarchar	2	0
42	TF193	Hierarchies, Version-Dependent	2	DIMEN	Dimension	nvarchar	2	0
43	TF194	Hierarchies, Version- and Period Category-Dependent	2	DIMEN	Dimension	nvarchar	2	0
44	TF195	Hierarchy Levels	2	DIMEN	Dimension	nvarchar	2	0
45	TF196	Hierarchy Levels: Texts	3	DIMEN	Dimension	nvarchar	2	0
46	TF197	Hierarchy Levels Used	2	DIMEN	Dimension	nvarchar	2	0
47	TF198	Hierarchy Level Relationships	2	DIMEN	Dimension	nvarchar	2	0
48	TF230	Task Versions	2	DIMEN	Dimension	nvarchar	2	0
49	TF231	Task Versions: Names	3	DIMEN	Dimension	nvarchar	2	0
50	TF250	Periods, Opened/Closed	2	DIMEN	Dimension	nvarchar	2	0
51	TF260	Overall Status of CG/CU - Data Monitor	2	DIMEN	Dimension	nvarchar	2	0
52	TF261	CG/CU: Detail Status of Tasks - Data Monitor	2	DIMEN	Dimension	nvarchar	2	0
53	TF262	History of Data Entry Layouts	2	DIMEN	Dimension	nvarchar	2	0
54	TF270	CG/CU Overall Status of Consolidation Monitor	2	DIMEN	Dimension	nvarchar	2	0
55	TF271	CG/CU: Detail Status of Tasks - Consolidation Monitor	2	DIMEN	Dimension	nvarchar	2	0
56	TF280	User-Defined Tasks	2	DIMEN	Dimension	nvarchar	2	0
57	TF285	Log Archiving	2	DIMEN	Dimension	nvarchar	2	0
58	TF290	Copy Tasks	2	DIMEN	Dimension	nvarchar	2	0
59	TF291	Cons Groups to be Copied	2	DIMEN	Dimension	nvarchar	2	0
60	TF292	Cons Units to be Copied	2	DIMEN	Dimension	nvarchar	2	0
61	TF293	Assignment of Source Tasks to Copy Task	2	DIMEN	Dimension	nvarchar	2	0
62	TF350	Download: Assign CG PC Path	2	DIMEN	Receiving dimension for downloaded data	nvarchar	2	0
63	TF360	Download: Selection Parameters for Special Download	2	DIMEN	Receiving dimension for downloaded data	nvarchar	2	0
64	TF361	Download: Selection Parameters for General Download	2	DIMEN	Receiving dimension for downloaded data	nvarchar	2	0
65	TF362	Download: Selection Parameters for Downloading Fin. Data	2	DIMEN	Dimension	nvarchar	2	0
66	TF370	Equivalency Table in MC Validations	2	DIMEN	Dimension	nvarchar	2	0
67	TF400	Currency Translation Methods	2	DIMEN	Dimension	nvarchar	2	0
68	TF401	Translation Methods: Name	3	DIMEN	Dimension	nvarchar	2	0
69	TF410	Currency Translation Methods: Entries	2	DIMEN	Dimension	nvarchar	2	0
70	TF411	Translation Methods: Entries for Subassignments	2	DIMEN	Dimension	nvarchar	2	0
71	TF500	Document Types	2	DIMEN	Dimension	nvarchar	2	0
72	TF501	Document Types: Name	3	DIMEN	Dimension	nvarchar	2	0
73	TF502	Postable Item Categories	2	DIMEN	Dimension	nvarchar	2	0
74	TF503	Chart-Based Document Type Attributes	2	DIMEN	Dimension	nvarchar	2	0
75	TF505	Version-Based Document Type Attributes	2	DIMEN	Dimension	nvarchar	2	0
76	TF506	Document Types: Field-Dependent Properties	2	DIMEN	Dimension	nvarchar	2	0
77	TF510	Validation of Consolidation Documents	2	DIMEN	Dimension	nvarchar	2	0
78	TF530	Task Groups	2	DIMEN	Dimension	nvarchar	2	0
79	TF531	Task Groups: Name	3	DIMEN	Dimension	nvarchar	2	0
80	TF532	Task Groups: Task Assignments	2	DIMEN	Dimension	nvarchar	2	0
81	TF533	Task Groups: Preceding Tasks	2	DIMEN	Dimension	nvarchar	2	0
82	TF540	Consolidation Tasks	2	DIMEN	Dimension	nvarchar	2	0
83	TF541	Consolidation Tasks: Name	3	DIMEN	Dimension	nvarchar	2	0
84	TF542	Consolidation Tasks, Version-Dependent	2	DIMEN	Dimension	nvarchar	2	0
85	TF543	Consolidation Tasks: Assignments of Methods and Doc.Types	2	DIMEN	Dimension	nvarchar	2	0
86	TF544	Tasks: Task Group Exceptions	2	DIMEN	Dimension	nvarchar	2	0
87	TF545	Consolidation Tasks: Exceptions for Cons Units	2	DIMEN	Dimension	nvarchar	2	0
88	TF550	Methods	2	DIMEN	Dimension	nvarchar	2	0
89	TF551	Methods: Name	3	DIMEN	Dimension	nvarchar	2	0
90	TF555	Methods for Interunit Elimination	2	DIMEN	Dimension	nvarchar	2	0
91	TF556	Methods for IU Elimination: Item Set Assignments	2	DIMEN	Dimension	nvarchar	2	0
92	TF556A	IU Elimination Methods: Allocation of Addtl Acct Assignments	2	DIMEN	Dimension	nvarchar	2	0
93	TF557	Methods: Threshold Value for Posting Differences	2	DIMEN	Dimension	nvarchar	2	0
94	TF558	IU Elimination Methods: Reclassi. for Proportional Cons.	2	DIMEN	Dimension	nvarchar	2	0
95	TF560	Methods for Reclassification	2	DIMEN	Dimension	nvarchar	2	0
96	TF560A	Reclassification Methods: Fields	2	DIMEN	Dimension	nvarchar	2	0
97	TF562	Assignment of Method/Doc. Type to Task in Reclassification	2	DIMEN	Dimension	nvarchar	2	0
98	TF570	Tasks for Manual Posting - Document Type Assignments	2	DIMEN	Dimension	nvarchar	2	0
99	TF575	Tasks for CG Changes: Document Type Assignments	2	DIMEN	Dimension	nvarchar	2	0
100	TF583	Dimension-Dep.Assignmt of CoA, Prod. Group to in(NOT USED)	2	DIMEN	Dimension	nvarchar	2	0
101	TF584	Assignment of Inventory Item to Product Group	2	DIMEN	Dimension	nvarchar	2	0
102	TF584A	Assignment of Inventory Item to Product Group (NOT USED)	2	DIMEN	Dimension	nvarchar	2	0
103	TF585	Inventory Data	2	DIMEN	Dimension	nvarchar	2	0
104	TF586	Supplier Data	2	DIMEN	Dimension	nvarchar	2	0
105	TF591	Elim of IU Profit/Loss in Inventory: FS Items (NOT USED)	2	DIMEN	Dimension	nvarchar	2	0
106	TF592	Elimination of IU Profit/Loss in Inventory: FS Items	2	DIMEN	Dimension	nvarchar	2	0
107	TF592A	Elimination of IU Profit/Loss in Inventory: FS Items	2	DIMEN	Dimension	nvarchar	2	0
108	TF593	Subassignments of Inventory Items	2	DIMEN	Dimension	nvarchar	2	0
109	TF595	Elimination of IU Profit/Loss in Inventory: Tasks	2	DIMEN	Dimension	nvarchar	2	0
110	TF599	Global Settings for Elim. of IU P/L in Inventory	2	DIMEN	Dimension	nvarchar	2	0
111	TF600	Consolidation of Investments Methods	2	DIMEN	Dimension	nvarchar	2	0
112	TF602	C/I Methods: Cons Chart of Accounts-Based Settings	2	DIMEN	Dimension	nvarchar	2	0
113	TF605	C/I Methods: Assignments	2	DIMEN	Dimension	nvarchar	2	0
114	TF610	Tasks for the Consolidation of Investments	2	DIMEN	Dimension	nvarchar	2	0
115	TF615	C/I Tasks: Assignment of Document Types	2	DIMEN	Dimension	nvarchar	2	0
116	TF616	C/I Activities/Acctg Techniques: Document Type Assignments	2	DIMEN	Dimension	nvarchar	2	0
117	TF620	Changes in Investments	2	DIMEN	Dimension	nvarchar	2	0
118	TF625	Group Shares	2	DIMEN	Dimension	nvarchar	2	0
119	TF630	Changes in Investee Equity	2	DIMEN	Dimension	nvarchar	2	0
120	TF635	Goodwill/Neg.Goodwill	2	DIMEN	Dimension	nvarchar	2	0
121	TF635A	Goodwill/Neg.Goodwill	2	DIMEN	Dimension	nvarchar	2	0
122	TF640	Fair Value Adjustments	2	DIMEN	Dimension	nvarchar	2	0
123	TF641	Fair Value Adjustments: Subnumber	2	DIMEN	Dimension	nvarchar	2	0
124	TF642	Fair Value Adjustments: Name	3	DIMEN	Dimension	nvarchar	2	0
125	TF643	Fair Value Adjustments: Version/Date-Sensitive	2	DIMEN	Dimension	nvarchar	2	0
126	TF644	Fair Value Adjustments: Cons Chart of Accounts-Sensitive	2	DIMEN	Dimension	nvarchar	2	0
127	TF645	Reporting Fair Value Adjustment Data	2	DIMEN	Dimension	nvarchar	2	0
128	TF646	Recorded Fair Value Adjustments	2	DIMEN	Dimension	nvarchar	2	0
129	TF650	C/I Activity Numbers	3	DIMEN	Dimension	nvarchar	2	0
130	TF651	Activity Numbers - Sequence	2	DIMEN	Dimension	nvarchar	2	0
131	TF652	Activity Numbers - Sequence - Sort Status	2	DIMEN	Dimension	nvarchar	2	0
132	TF655	C/I Entry of Activities: Default Values	2	DIMEN	Dimension	nvarchar	2	0
133	TF656	Activities - Default Sequence	2	DIMEN	Dimension	nvarchar	2	0
134	TF657	Activities: Goodwill Treatment	2	DIMEN	Dimension	nvarchar	2	0
135	TF660	Equity Holdings Adjustments	2	DIMEN	Dimension	nvarchar	2	0
136	TF661	Equity Holdings Adjustments by Upper Unit	2	DIMEN	Dimension	nvarchar	2	0
137	TF690	C/I - System Utilization	2	DIMEN	Dimension	nvarchar	2	0
138	TF691	C/I - Global Settings	2	DIMEN	Dimension	nvarchar	2	0
139	TF691A	Global Settings for C/I, version-dependent	2	DIMEN	Dimension	nvarchar	2	0
140	TF692	Global Chart of Accounts-Based Settings for C/I	2	DIMEN	Dimension	nvarchar	2	0
141	TF693	Subitems for Equity Aging Report	2	DIMEN	Dimension	nvarchar	2	0
142	TF810	Top Groups, Organizational Changes	2	DIMEN	Dimension	nvarchar	2	0
143	TF820	Organizational Change Numbers	2	DIMEN	Dimension	nvarchar	2	0
144	TF821	Organizational Changes: Texts	3	DIMEN	Dimension	nvarchar	2	0
145	TF822	Organizational Changes: Version/Time-Dependent	2	DIMEN	Dimension	nvarchar	2	0
146	TF823	Organizational Changes: Group Assignment	2	DIMEN	Dimension	nvarchar	2	0
147	TFBW1	Data streams into BW	4	DIMEN	Dimension	nvarchar	2	0
148	TFBW3	Data streams from BW	4	DIMEN	Dimension	nvarchar	2	0
149	TFBW4	Additional selections	4	DIMEN	Dimension	nvarchar	2	0
150	TFIN000	Independent Characteristic Values for Consolidation Type	3	DIMEN	Dimension	nvarchar	2	0
151	TFIN002	Assignment of Consolidation Types and Dimensions	3	DIMEN	Dimension	nvarchar	2	0
152	TFIN002L	Lock Mode During Rollup per Int. Cons Type and Dimension	3	DIMEN	Dimension	nvarchar	2	0
153	TFIN010	Consolidation Unit Integration	2	DIMEN	Dimension	nvarchar	2	0
154	TFMIG10	Migration: Processing Options	3	DIMEN	Dimension	nvarchar	2	0
TOPData Collection
155	CF709	Consolidation Basic	11	DIMEN	Dimension	nvarchar	2	0
156	CF710	IDES FPI	8	DIMEN	Dimension	nvarchar	2	0
157	CF711	KPI	8	DIMEN	Dimension	nvarchar	2	0
158	CF712	EC Integration: EVA	8	DIMEN	Dimension	nvarchar	2	0
159	CF714	Strategic Planning	8	DIMEN	Dimension	nvarchar	2	0
160	KCK710	Comments for FPI	12	DIMEN	Dimension	nvarchar	2	0
TOPGlobal Trade Services
161	/SAPSLL/LCLICAQ	Legal Control: License: Available Quantity	6	DIMEN	Dimension (Quantity, Weight, Height, Width, Length)	decimal	19	3
162	/SAPSLL/LCLICAQL	License: Change Log: Available Quantity	10	DIMEN	Dimension (Quantity, Weight, Height, Width, Length)	decimal	19	3
163	/SAPSLL/LCLICCQ	Legal Control: License - Quantities per Component	12	DIMEN	Dimension (Quantity, Weight, Height, Width, Length)	decimal	19	3
164	/SAPSLL/LCLICQ	Legal Control: Licenses - Quantities	9	DIMEN	Dimension (Quantity, Weight, Height, Width, Length)	decimal	19	3
165	/SAPSLL/LEGCON	Legal Control - Document	37	DIMEN	Dimension (Quantity, Weight, Height, Width, Length)	decimal	19	3
TOPInvestment Programs
166	TAI05	CI Program Types	19	DIMEN	Dimension in Consolidation	nvarchar	2	0
167	TAI11	Group shares in Inv. Program Info System	2	DIMEN	Dimension in Consolidation	nvarchar	2	0
TOPWork Center
168	TC20	"Formula Parameters"	6	DIMEN	Dimension key	nvarchar	6	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

168 columns | ERP 6.0 | DIMEN