	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	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	OSRN	20	Serial Numbers Master Data
10	OBOT	10	Bill Of Exchang Transaction

78 columns | ERP 6.0 | ITCLG

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
TOPBasic Functions
1	T884	Currency translation	17	ITCLG	Consolidation chart of accounts	nvarchar	2	0
2	T884M	Currency translation methods used in Consolidation	8	ITCLG	Consolidation chart of accounts	nvarchar	2	0
TOPConsolidation
3	ECMCO	SAP Cons.: Object Table Assignment Fields (Object/Partner)	10	ITCLG	Consolidation chart of accounts	nvarchar	2	0
4	EWUCS01	SAP Cons.-EURO: Selected FS Items for Euro Conversion	2	ITCLG	Consolidation chart of accounts	nvarchar	2	0
5	TF002	SAP Cons.: Assignment of Sets -> Items	5	ITCLG	Consolidation chart of accounts	nvarchar	2	0
6	TF003	SAP Cons.: Assignments of Items --> Sets	2	ITCLG	Consolidation chart of accounts	nvarchar	2	0
7	TF080	List Directory of MCDX	3	ITCLG	Consolidation chart of accounts	nvarchar	2	0
8	TF100	Financial Statement Items	2	ITCLG	Consolidation chart of accounts	nvarchar	2	0
9	TF101	FS Items: Short and Medium Texts	3	ITCLG	Consolidation chart of accounts	nvarchar	2	0
10	TF102	FS Items: Long Texts	3	ITCLG	Consolidation chart of accounts	nvarchar	2	0
11	TF103	Breakdown Categories	2	ITCLG	Consolidation chart of accounts	nvarchar	2	0
12	TF103A	Breakdown Categories: Breakdown Info per Subassignment	2	ITCLG	Consolidation chart of accounts	nvarchar	2	0
13	TF104	Breakdown Categories: Name	3	ITCLG	Consolidation chart of accounts	nvarchar	2	0
14	TF120	Consolidation Charts of Accounts	2	ITCLG	Consolidation chart of accounts	nvarchar	2	0
15	TF121	Consolidation Charts of Accounts: Description	3	ITCLG	Consolidation chart of accounts	nvarchar	2	0
16	TF130	FS Item Hierarchies	2	ITCLG	Consolidation chart of accounts	nvarchar	2	0
17	TF131	Item Hierarchies: Name	3	ITCLG	Consolidation chart of accounts	nvarchar	2	0
18	TF140	Selected FS Items	3	ITCLG	Consolidation chart of accounts	nvarchar	2	0
19	TF141	Selected FS Items	3	ITCLG	Consolidation chart of accounts	nvarchar	2	0
20	TF193	Hierarchies, Version-Dependent	5	ITCLG	Consolidation chart of accounts	nvarchar	2	0
21	TF250	Periods, Opened/Closed	3	ITCLG	Consolidation chart of accounts	nvarchar	2	0
22	TF260	Overall Status of CG/CU - Data Monitor	3	ITCLG	Consolidation chart of accounts	nvarchar	2	0
23	TF261	CG/CU: Detail Status of Tasks - Data Monitor	3	ITCLG	Consolidation chart of accounts	nvarchar	2	0
24	TF270	CG/CU Overall Status of Consolidation Monitor	3	ITCLG	Consolidation chart of accounts	nvarchar	2	0
25	TF271	CG/CU: Detail Status of Tasks - Consolidation Monitor	3	ITCLG	Consolidation chart of accounts	nvarchar	2	0
26	TF361	Download: Selection Parameters for General Download	6	ITCLG	Consolidation chart of accounts	nvarchar	2	0
27	TF390	Selected Items for Carryforwards	3	ITCLG	Consolidation chart of accounts	nvarchar	2	0
28	TF410	Currency Translation Methods: Entries	3	ITCLG	Consolidation chart of accounts	nvarchar	2	0
29	TF411	Translation Methods: Entries for Subassignments	3	ITCLG	Consolidation chart of accounts	nvarchar	2	0
30	TF415	FS Items for Posting Trans. Diffs with Effect on Earnings	2	ITCLG	Consolidation chart of accounts	nvarchar	2	0
31	TF503	Chart-Based Document Type Attributes	3	ITCLG	Consolidation chart of accounts	nvarchar	2	0
32	TF556	Methods for IU Elimination: Item Set Assignments	3	ITCLG	Consolidation chart of accounts	nvarchar	2	0
33	TF556A	IU Elimination Methods: Allocation of Addtl Acct Assignments	3	ITCLG	Consolidation chart of accounts	nvarchar	2	0
34	TF558	IU Elimination Methods: Reclassi. for Proportional Cons.	3	ITCLG	Consolidation chart of accounts	nvarchar	2	0
35	TF560	Methods for Reclassification	3	ITCLG	Consolidation chart of accounts	nvarchar	2	0
36	TF560A	Reclassification Methods: Fields	3	ITCLG	Consolidation chart of accounts	nvarchar	2	0
37	TF583	Dimension-Dep.Assignmt of CoA, Prod. Group to in(NOT USED)	3	ITCLG	Consolidation chart of accounts	nvarchar	2	0
38	TF584	Assignment of Inventory Item to Product Group	3	ITCLG	Consolidation chart of accounts	nvarchar	2	0
39	TF584A	Assignment of Inventory Item to Product Group (NOT USED)	3	ITCLG	Consolidation chart of accounts	nvarchar	2	0
40	TF585	Inventory Data	3	ITCLG	Consolidation chart of accounts	nvarchar	2	0
41	TF590	Elim. of IU P/L in Inventory: Selected Items (NOT IN USE!)	3	ITCLG	Consolidation chart of accounts	nvarchar	2	0
42	TF591	Elim of IU Profit/Loss in Inventory: FS Items (NOT USED)	4	ITCLG	Consolidation chart of accounts	nvarchar	2	0
43	TF592	Elimination of IU Profit/Loss in Inventory: FS Items	4	ITCLG	Consolidation chart of accounts	nvarchar	2	0
44	TF592A	Elimination of IU Profit/Loss in Inventory: FS Items	4	ITCLG	Consolidation chart of accounts	nvarchar	2	0
45	TF593	Subassignments of Inventory Items	3	ITCLG	Consolidation chart of accounts	nvarchar	2	0
46	TF602	C/I Methods: Cons Chart of Accounts-Based Settings	3	ITCLG	Consolidation chart of accounts	nvarchar	2	0
47	TF620	Changes in Investments	4	ITCLG	Consolidation chart of accounts	nvarchar	2	0
48	TF625	Group Shares	3	ITCLG	Consolidation chart of accounts	nvarchar	2	0
49	TF630	Changes in Investee Equity	4	ITCLG	Consolidation chart of accounts	nvarchar	2	0
50	TF635	Goodwill/Neg.Goodwill	4	ITCLG	Consolidation chart of accounts	nvarchar	2	0
51	TF635A	Goodwill/Neg.Goodwill	3	ITCLG	Consolidation chart of accounts	nvarchar	2	0
52	TF644	Fair Value Adjustments: Cons Chart of Accounts-Sensitive	3	ITCLG	Consolidation chart of accounts	nvarchar	2	0
53	TF645	Reporting Fair Value Adjustment Data	4	ITCLG	Consolidation chart of accounts	nvarchar	2	0
54	TF646	Recorded Fair Value Adjustments	3	ITCLG	Consolidation chart of accounts	nvarchar	2	0
55	TF650	C/I Activity Numbers	5	ITCLG	Consolidation chart of accounts	nvarchar	2	0
56	TF651	Activity Numbers - Sequence	4	ITCLG	Consolidation chart of accounts	nvarchar	2	0
57	TF652	Activity Numbers - Sequence - Sort Status	4	ITCLG	Consolidation chart of accounts	nvarchar	2	0
58	TF655	C/I Entry of Activities: Default Values	3	ITCLG	Consolidation chart of accounts	nvarchar	2	0
59	TF658	Activities: Reported Items - Equity	2	ITCLG	Consolidation chart of accounts	nvarchar	2	0
60	TF659	Activities: Reported Items for Push-down Goodwill	2	ITCLG	Consolidation chart of accounts	nvarchar	2	0
61	TF660	Equity Holdings Adjustments	4	ITCLG	Consolidation chart of accounts	nvarchar	2	0
62	TF661	Equity Holdings Adjustments by Upper Unit	4	ITCLG	Consolidation chart of accounts	nvarchar	2	0
63	TF667	Reported Items for Equity Holdings Adjustments	2	ITCLG	Consolidation chart of accounts	nvarchar	2	0
64	TF692	Global Chart of Accounts-Based Settings for C/I	3	ITCLG	Consolidation chart of accounts	nvarchar	2	0
65	TF695	Selected Items for Consolidation of Investments	3	ITCLG	Consolidation chart of accounts	nvarchar	2	0
66	TF696	Posting Items for the Equity Method	3	ITCLG	Consolidation chart of accounts	nvarchar	2	0
67	TF697	Posting Items for Push-down Accounting	2	ITCLG	Consolidation chart of accounts	nvarchar	2	0
68	TFBW1	Data streams into BW	5	ITCLG	Consolidation chart of accounts	nvarchar	2	0
69	TFBW3	Data streams from BW	5	ITCLG	Consolidation chart of accounts	nvarchar	2	0
70	TFBW4	Additional selections	5	ITCLG	Consolidation chart of accounts	nvarchar	2	0
71	TFIN000	Independent Characteristic Values for Consolidation Type	4	ITCLG	Consolidation chart of accounts	nvarchar	2	0
72	TFIN200	Mapping of G/L Charts of Accounts and Target Cons C/As	3	ITCLG	Consolidation chart of accounts	nvarchar	2	0
73	TFIN201	Mapping of Secondary Cost Elements to FS Items: Details	3	ITCLG	Consolidation chart of accounts	nvarchar	2	0
74	TFMIG10	Migration: Processing Options	4	ITCLG	Consolidation chart of accounts	nvarchar	2	0
75	TFMIG11	Migration: Control for Cons Charts of Accounts	2	ITCLG	Consolidation chart of accounts	nvarchar	2	0
TOPData Collection
76	CF709	Consolidation Basic	13	ITCLG	Consolidation chart of accounts	nvarchar	2	0
77	CF710	IDES FPI	9	ITCLG	Consolidation chart of accounts	nvarchar	2	0
78	KCK710	Comments for FPI	13	ITCLG	Consolidation chart of accounts	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

78 columns | ERP 6.0 | ITCLG