	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	/ISDFPS/CHVW_E	34	External Batch Where-Used List
7	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	BSEG	345	Accounting Document Segment
10	FMARCPAR	4	Parallelization of FMARC_BATCH

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

	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	OINM	101	Whse Journal
10	OSRN	20	Serial Numbers Master Data

186 columns | ERP 6.0 | RACCT

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	/BIC/B0000171000	PSA for 0FI_GL_21 T90CLNT090 G/L Accts: Balances	12	RACCT		nvarchar	10	0
2	/BIC/B0000173000	PSA for 0FI_GL_10 T90CLNT090 General Ledger: Bal.	14	RACCT		nvarchar	10	0
3	/BIC/B0000174000	PSA for 0FI_GL_11 T90CLNT090 Lead. Ldgr Bals LIs	15	RACCT		nvarchar	10	0
4	/BIC/B0000175000	PSA for 0FI_GL_12 T90CLNT090 Lead. Ldgr Bals (Q)	15	RACCT		nvarchar	10	0
5	FAGLFLEXC	EMU: Sum of Open Items of Table FAGLFLEXT	5	RACCT	Account Number	nvarchar	10	0
6	FAGLFLEXD	EMU: Documentation of changes in Txn.Figs of Tabl FAGLFLEXT	7	RACCT	Account Number	nvarchar	10	0
7	FAGLFLEXT_BAK	General Ledger: Totals	23	RACCT	Account Number	nvarchar	10	0
8	FAGLFLEXT_DIF	Delta Table: G/L Totals	23	RACCT	Account Number	nvarchar	10	0
9	GLPCA_CT	Profit Center Documents	96	RACCT	Account Number	nvarchar	10	0
10	GLPCA_T_CT	Profit Center Documents	112	RACCT	Account Number	nvarchar	10	0
11	GLT0_BAK	G/L Account Master Record Transaction Figures	7	RACCT	Account Number	nvarchar	10	0
12	GLT0_DIF	Delta Table: G/L Account Master Transaction Figures	7	RACCT	Account Number	nvarchar	10	0
13	REFXCN_GLMAP	Mapping of General Ledger	4	RACCT	Account Number	nvarchar	10	0
14	T901	WRA Percentage Reporting Table	2	RACCT	Account Number	nvarchar	10	0
15	ZSAWA	Actual line item table	15	RACCT	Account Number	nvarchar	10	0
16	ZSAWP	Plan line items table	15	RACCT	Account Number	nvarchar	10	0
17	ZSAWT	Summary table	14	RACCT	Account Number	nvarchar	10	0
18	ZSEMBPSA	Actual line item table	15	RACCT	Account Number	nvarchar	10	0
19	ZSEMBPSP	Plan line items table	15	RACCT	Account Number	nvarchar	10	0
20	ZSEMBPST	Summary table	14	RACCT	Account Number	nvarchar	10	0
21	ZSPLITA	Isteinzelposten-Tabelle	15	RACCT	Kontonummer	nvarchar	10	0
22	ZSPLITP	Planeinzelposten-Tabelle	15	RACCT	Kontonummer	nvarchar	10	0
23	ZSPLITT	Summentabelle	14	RACCT	Kontonummer	nvarchar	10	0
24	ZZ001A	Actual Line Item Table	15	RACCT	Account Number	nvarchar	10	0
25	ZZ001P	Plan Line Items Table	15	RACCT	Account Number	nvarchar	10	0
26	ZZ001T	Summary Table	14	RACCT	Account Number	nvarchar	10	0
27	ZZLINEA	Actual line item table	15	RACCT	Account Number	nvarchar	10	0
28	ZZLINEP	Plan line items table	15	RACCT	Account Number	nvarchar	10	0
29	ZZLINET	Summary table	14	RACCT	Account Number	nvarchar	10	0
30	ZZSL01A	Actual line item table	15	RACCT	Account Number	nvarchar	10	0
31	ZZSL01P	Plan line items table	15	RACCT	Account Number	nvarchar	10	0
32	ZZSL01T	Summary table	14	RACCT	Account Number	nvarchar	10	0
33	ZZSPECA	Actual line item table	15	RACCT	Account Number	nvarchar	10	0
34	ZZSPECP	Plan line item table	15	RACCT	Account Number	nvarchar	10	0
35	ZZSPECT	Summary table	13	RACCT	Account Number	nvarchar	10	0
TOPBasic Functions
36	FILCA	FI-LC: Actual journal entry table with 2 object tables	15	RACCT	Consolidation item	nvarchar	10	0
37	FILCP	FI-LC: Plan line items for object table	15	RACCT	Consolidation item	nvarchar	10	0
38	FILCT	FI-LC: Global totals table with 2 object tables	14	RACCT	Consolidation item	nvarchar	10	0
39	GGREFA	Example for Global FI-SL Line Items (Actual)	16	RACCT	Account Number	nvarchar	10	0
40	GGREFP	Example for Global FI-SL Line Items (Plan)	16	RACCT	Account Number	nvarchar	10	0
41	GGREFT	Example for Global FI-SL Summary Table	15	RACCT	Account Number	nvarchar	10	0
42	GLFUNCA	Actual Line Items Table for Cost of Sales Accounting	15	RACCT	Account Number	nvarchar	10	0
43	GLFUNCP	Plan Line Items Table for Cost of Sales Accounting	15	RACCT	Account Number	nvarchar	10	0
44	GLFUNCT	Totals Table for Cost of Sales Accounting	14	RACCT	Account Number	nvarchar	10	0
45	GLFUNCU	Rollup line item tables with function area for IDES	15	RACCT	Account Number	nvarchar	10	0
46	GLFUNCV	Rollup plan line items table with function area for IDES	15	RACCT	Account Number	nvarchar	10	0
47	GLP0	Local Logical General Ledger Plan Line Items	7	RACCT	Account Number	nvarchar	10	0
48	GLPO1	Plan Line Items for Object Table	17	RACCT	Account Number	nvarchar	10	0
49	GLPO2	Plan Line Items for Object Table Global	18	RACCT	Account Number	nvarchar	10	0
50	GLPO3	Plan Line Items for Object Table	17	RACCT	Account Number	nvarchar	10	0
51	GLREFA	Example for Local FI-SL Line Items (Actual)	15	RACCT	Account Number	nvarchar	10	0
52	GLREFP	Example for Local FI-SL Line Items (Plan)	15	RACCT	Account Number	nvarchar	10	0
53	GLREFT	Example for Local FI-SL Summary Table	14	RACCT	Account Number	nvarchar	10	0
54	GLREFU	Example for FI-SL Rollup Line Items (Actual)	15	RACCT	Account Number	nvarchar	10	0
55	GLREFV	Example for Rollup FI-SL Line Items (Plan)	15	RACCT	Account Number	nvarchar	10	0
56	GLSO1	FI-SL Line Item Table with Objects for GLTO1	17	RACCT	Account Number	nvarchar	10	0
57	GLSO2	FI-SL Table with Objects, Structure corresponds to GLS2	18	RACCT	Account Number	nvarchar	10	0
58	GLSO3	FI-SL LI Table with Objects for GLTO3	17	RACCT	Account Number	nvarchar	10	0
59	GLT0	G/L account master record transaction figures	7	RACCT	Account Number	nvarchar	10	0
60	GLT3	Summary Data Preparations for Consolidation	7	RACCT	Account Number	nvarchar	10	0
61	GLTO1	FI-SL Table with Objects, Structure Corresponds to GLT1	14	RACCT	Account Number	nvarchar	10	0
62	GLTO2	FI-SL Table with Objects, Structure Corresponds to GLT2	15	RACCT	Account Number	nvarchar	10	0
63	GLTO3	FISL Table with Objects, Amounts and Quantities in Format P9	14	RACCT	Account Number	nvarchar	10	0
TOPCollectionsDisbursements
64	GLISDEA	Actual Line Item Tables for Insurance (DE)	15	RACCT	Account Number	nvarchar	10	0
65	GLISDEP	Plan Line Item Table for Insurance (DE)	15	RACCT	Account Number	nvarchar	10	0
66	GLISDET	Summary Table for Insurance (DE)	14	RACCT	Account Number	nvarchar	10	0
67	GRISDEA	Actual Line Item Table for Insurance (DE) - Rollup	15	RACCT	Account Number	nvarchar	10	0
68	GRISDEP	Plan Line Item Table for Insurance (DE) - Rollup	15	RACCT	Account Number	nvarchar	10	0
69	GRISDET	Summary Table for Insurance (DE) - Rollup	14	RACCT	Account Number	nvarchar	10	0
TOPConsolidation
70	TFMIG04	Allocation: FS Item -> FS Item	2	RACCT	Consolidation item	nvarchar	10	0
TOPCost Element Accounting
71	COFIP	Single plan items for reconciliation ledger	15	RACCT	Cost Element	nvarchar	10	0
72	COFIS	Actual line items for reconciliation ledger	15	RACCT	Cost Element	nvarchar	10	0
73	COFIT	Totals Records for Reconciliation Ledger	14	RACCT	Cost Element	nvarchar	10	0
TOPData Collection
74	CF715	IDES:PCA-Integration	12	RACCT	PC Account	nvarchar	10	0
TOPData Retention Tool
75	TXW_S_COFI	Retrieve COFIS from archive	11	RACCT	Cost Element	nvarchar	10	0
76	TXW_S_GLT0	Retrieve archived GLT0 data	7	RACCT	Account Number	nvarchar	10	0
TOPFinancial Accounting
77	FBICRC001A	ICRC: Open Items GL Accounts: Documents	16	RACCT	Group Account Number	nvarchar	10	0
78	FBICRC001P	Not in use	15	RACCT	Group Account Number	nvarchar	10	0
79	FBICRC001T	ICRC: Open Items GL Accounts: Totals	15	RACCT	Group Account Number	nvarchar	10	0
80	FBICRC002A	ICRC: GL Accounts: Documents	16	RACCT	Group Account Number	nvarchar	10	0
81	FBICRC002P	Not in use	15	RACCT	Group Account Number	nvarchar	10	0
82	FBICRC002T	ICRC: GL Accounts: Totals	15	RACCT	Group Account Number	nvarchar	10	0
83	FBICRC003A	ICRC: Open Items Customers/Vendors: Documents	47	RACCT	Account Number	nvarchar	10	0
TOPFinancial Services Localization
84	/CEEIS/RUA	Actual line item table	15	RACCT	Account Number	nvarchar	10	0
85	/CEEIS/RUP	Plan line items table	15	RACCT	Account Number	nvarchar	10	0
86	/CEEIS/RUT	Totals Table	14	RACCT	Account Number	nvarchar	10	0
TOPFlexible Real Estate Management
87	VIPRLEDTAGRA	Isteinzelposten-Tabelle	15	RACCT	Kontonummer	nvarchar	10	0
88	VIPRLEDTAGRP	Planeinzelposten-Tabelle	15	RACCT	Kontonummer	nvarchar	10	0
89	VIPRLEDTAGRT	Summentabelle Ledger 7A Mandate	13	RACCT	Kontonummer	nvarchar	10	0
TOPFunctions for U.S. Federal Government
90	FMUSFG_TSA	Assign. of FI Doc Type/ Accnt/Fund to Treasury Subclass Code	3	RACCT	Account Number	nvarchar	10	0
TOPFund Accounting
91	FMCCAVCA	Actual line item table	14	RACCT	Account Number	nvarchar	10	0
92	FMCCAVCP	Plan line items table	14	RACCT	Account Number	nvarchar	10	0
93	FMCCAVCT	Totals Table	13	RACCT	Account Number	nvarchar	10	0
94	FMGLFLEX02	General ledger: Main account assignment	2	RACCT	Account Number	nvarchar	10	0
95	FMGLFLEXA	General Ledger: Actual Line Items	15	RACCT	Account Number	nvarchar	10	0
96	FMGLFLEXP	General Ledger: Plan Line Items	17	RACCT	Account Number	nvarchar	10	0
97	FMGLFLEXT	General Ledger Public Sector: Total	23	RACCT	Account Number	nvarchar	10	0
98	PSGLFLEX02	General ledger: Main account assignment	2	RACCT	Account Number	nvarchar	10	0
99	PSGLFLEXA	General Ledger: Actual Line Items	15	RACCT	Account Number	nvarchar	10	0
100	PSGLFLEXP	General Ledger: Plan Line Items	17	RACCT	Account Number	nvarchar	10	0
101	PSGLFLEXT	General Ledger Public Sector: Total	23	RACCT	Account Number	nvarchar	10	0
TOPFunds Management
102	FMFG_SAV_FACTS1A	Saved FACTS1A data for docs excluded from SL Repost for 600	14	RACCT	Account Number	nvarchar	10	0
103	FMFG_SAV_FACTS2A	Saved FACTS2A data for docs excluded from SL Repost for 600	14	RACCT	Account Number	nvarchar	10	0
104	FMFG_SAV_FMUSFGA	Saved FMUSFGA data for docs excluded from SL Repost for 600	14	RACCT	Account Number	nvarchar	10	0
105	FMSPLITA	Actual line item table	14	RACCT	Account Number	nvarchar	10	0
106	FMSPLITP	Plan line items table	14	RACCT	Account Number	nvarchar	10	0
107	FMSPLITT	Summary table	13	RACCT	Account Number	nvarchar	10	0
108	FMUSFGA	Actual line item table for US Federal Government.	14	RACCT	Account Number	nvarchar	10	0
109	FMUSFGFACTS1A	4Actual line item table	14	RACCT	Account Number	nvarchar	10	0
110	FMUSFGFACTS1P	Plan line items table	14	RACCT	Account Number	nvarchar	10	0
111	FMUSFGFACTS1T	Summary table	13	RACCT	Account Number	nvarchar	10	0
112	FMUSFGFACTS2A	Actual line item table	14	RACCT	Account Number	nvarchar	10	0
113	FMUSFGFACTS2P	Plan line items table	14	RACCT	Account Number	nvarchar	10	0
114	FMUSFGFACTS2T	Summary table	13	RACCT	Account Number	nvarchar	10	0
115	FMUSFGP	Plan line items table	14	RACCT	Account Number	nvarchar	10	0
116	FMUSFGT	Summary table for US Federal Government	13	RACCT	Account Number	nvarchar	10	0
TOPGeneral Ledger Accounting
117	FAGLFLEX02	General ledger: Main account assignment	2	RACCT	Account Number	nvarchar	10	0
118	FAGLFLEXA	General Ledger: Actual Line Items	15	RACCT	Account Number	nvarchar	10	0
119	FAGLFLEXP	General Ledger: Plan Line Items	17	RACCT	Account Number	nvarchar	10	0
120	FAGLFLEXT	General Ledger: Totals	23	RACCT	Account Number	nvarchar	10	0
121	FAGL_BW_LOG_ITEM	FI-GL: Log for BW Extraction: Line Items	51	RACCT	Account Number	nvarchar	10	0
122	FAGL_BW_LOG_TOTL	FI-GL: Log for BW Extraction: Totals Records	16	RACCT	Account Number	nvarchar	10	0
123	FAGL_MIG_TOTALS	Log Table for Building Balances in New G/L	5	RACCT	Account Number	nvarchar	10	0
124	FAGL_QUEUE_LOG	Log of Delta Queue for Error Analysis	14	RACCT	Account Number	nvarchar	10	0
125	FAGL_RSNAPSHOT	Reorganization: Snapshot	6	RACCT	Account Number	nvarchar	10	0
126	GLFLEX02	General ledger: Main account assignment	2	RACCT	Account Number	nvarchar	10	0
127	GLFLEXA	Flexible general ledger: Actual line items	12	RACCT	Account Number	nvarchar	10	0
128	GLFLEXP	Flexible G/L: Plan line items	12	RACCT	Account Number	nvarchar	10	0
129	GLFLEXT	Flexible G/L: Totals	18	RACCT	Account Number	nvarchar	10	0
TOPGeneral Ledger Reorganization
130	FAGL_R_BLNCE	Reorganization: Balances to Be Transferred	6	RACCT	Account Number	nvarchar	10	0
131	FAGL_R_BLNCE_VAL	Reorganization: Balances to Be Transferred - Values	6	RACCT	Account Number	nvarchar	10	0
TOPJoint Venture und Production Sharing Accounting
132	JVGLFLEX02	General ledger: Main account assignment	2	RACCT	Account Number	nvarchar	10	0
133	JVGLFLEXA	General Ledger: Actual Line Items	15	RACCT	Account Number	nvarchar	10	0
134	JVGLFLEXP	General Ledger: Plan Line Items	17	RACCT	Account Number	nvarchar	10	0
135	JVGLFLEXT	General Ledger: Totals	23	RACCT	Account Number	nvarchar	10	0
136	JVPO1	JVA: Plan Line Items	17	RACCT	Account Number	nvarchar	10	0
137	JVPSC01A	Actual line item table	19	RACCT	Account Number	nvarchar	10	0
138	JVPSC01P	Plan line item table	19	RACCT	Account Number	nvarchar	10	0
139	JVPSC01T	Summary table	18	RACCT	Account Number	nvarchar	10	0
140	JVSO1	JV LI Table with Objects for JVTO1	17	RACCT	Account Number	nvarchar	10	0
141	JVT1	JV Summary Table	9	RACCT	Account Number	nvarchar	10	0
142	JVTO1	JV Summary Table with Objects	16	RACCT	Account Number	nvarchar	10	0
143	T8JFRM_ACCT	JV Farm In/Out Intercompany adjustment accounts	7	RACCT	Account number	nvarchar	10	0
144	T8JFRM_STP	Farm In/Out & Re-Determination (Farm) Main Table	12	RACCT	Account number	nvarchar	10	0
145	T8JIX	JV index table	8	RACCT	Account Number	nvarchar	10	0
TOPLocal Currency Changeover
146	EWUTSL	EMU: Combinations for TSL fields to be converted in FI-SL	6	RACCT	Account Number	nvarchar	10	0
TOPLocalization
147	IDCN_ZJFPLBAL	P&L Balances for Period Account Entry Closing Method	6	RACCT	Account Number	nvarchar	10	0
148	J_3RFTAXRA	Tax Accounting: Actual line item table	18	RACCT	Account Number	nvarchar	10	0
149	J_3RFTAXRP	Tax Accounting: Plan line item table	18	RACCT	Account Number	nvarchar	10	0
150	J_3RFTAXRT	Tax Accounting: Summary table	16	RACCT	Account Number	nvarchar	10	0
151	J_3RFTAXRVA	Tax Accounting: Actual line item table	17	RACCT	Account Number	nvarchar	10	0
152	J_3RFTAXRVP	Tax Accounting: Plan line item table	17	RACCT	Account Number	nvarchar	10	0
153	J_3RFTAXRVT	Tax Accounting: Summary table	15	RACCT	Account Number	nvarchar	10	0
TOPProfit Center Accounting
154	GLPCA	EC-PCA: Actual Line Items	19	RACCT	Account Number	nvarchar	10	0
155	GLPCC	EC-PCA: Transaction Attributes	3	RACCT	Account Number	nvarchar	10	0
156	GLPCP	EC-PCA: Plan Line Items	19	RACCT	Account Number	nvarchar	10	0
157	GLPCT	EC-PCA: Totals Table	18	RACCT	Account Number	nvarchar	10	0
158	T8APP_GLPCM	EC-PCA: Plan Costs from Material Costing for Rep. Material	20	RACCT	Account Number	nvarchar	10	0
TOPProfitability Analysis
159	GLTPC	Profit Center Accounting	7	RACCT	Account Number	nvarchar	10	0
TOPRegulatory reporting for insurance companies
160	ISSRFLDEA	Actual line item table	16	RACCT	Account Number	nvarchar	10	0
161	ISSRFLDEP	Plan line items table	16	RACCT	Account Number	nvarchar	10	0
162	ISSRFLDET	Summary table	15	RACCT	Account Number	nvarchar	10	0
TOPRemaining Beverage - Obsolete Objects
163	/BEV3/CHFIA	Actual line item table	19	RACCT	Account Number	nvarchar	10	0
164	/BEV3/CHFIP	Plan Line Items Table	19	RACCT	Account Number	nvarchar	10	0
165	/BEV3/CHFIT	Totals table	18	RACCT	Account Number	nvarchar	10	0
166	/BEV3/CHVGRA	Actual line item table	19	RACCT	Account Number	nvarchar	10	0
167	/BEV3/CHVGRP	Plan Line Items Table	19	RACCT	Account Number	nvarchar	10	0
168	/BEV3/CHVGRT	Totals table	18	RACCT	Account Number	nvarchar	10	0
TOPRetail Ledger
169	PCRRETAILA	Actual line item table	15	RACCT	Account Number	nvarchar	10	0
170	PCRRETAILP	Plan line items table	15	RACCT	Account Number	nvarchar	10	0
171	PCRRETAILT	Totals Table	14	RACCT	Account Number	nvarchar	10	0
TOPSpecial Purpose Ledger
172	/CCIS/PBU18A	PBU18: Actual line item table	15	RACCT	Account Number	nvarchar	10	0
173	/CCIS/PBU18P	PBU18: Plan line item table	15	RACCT	Account Number	nvarchar	10	0
174	/CCIS/PBU18T	PBU18: Summary table x	14	RACCT	Account Number	nvarchar	10	0
175	/CCIS/PROFTAX02	Object Table Number:02	2	RACCT	Account Number	nvarchar	10	0
176	/CCIS/PROFTAXA	Actual Line Items Table for General Ledger	15	RACCT	Account Number	nvarchar	10	0
177	/CCIS/PROFTAXP	Plan Line Items Table for General Ledger	17	RACCT	Account Number	nvarchar	10	0
178	/CCIS/PROFTAXT	Totals Table for General Ledger	23	RACCT	Account Number	nvarchar	10	0
TOPTariffs, Duties and Permits
179	OIHEDA	Actual line item table, IS-OIL Excise Duty Special Ledger	22	RACCT	Account Number	nvarchar	10	0
180	OIHEDP	Plan line item table, IS-OIL Excise Duty Special Ledger	22	RACCT	Account Number	nvarchar	10	0
181	OIHEDT	Summary table, IS-OIL Excise Duty Special Ledger	21	RACCT	Account Number	nvarchar	10	0
182	OIHSLA	TDP (excise duty) special ledger actual line item table	15	RACCT	Account Number	nvarchar	10	0
183	OIHSLT	TDP (excise duty) special ledger summary table	19	RACCT	Account Number	nvarchar	10	0
TOPTransfer to Financial Accounting
184	TRACTSLA	Actual Line Item Table	15	RACCT	Account Number	nvarchar	10	0
185	TRACTSLP	Plan Line Items Table	15	RACCT	Account Number	nvarchar	10	0
186	TRACTSLT	Totals Table	14	RACCT	Account Number	nvarchar	10	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

186 columns | ERP 6.0 | RACCT