	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

118 columns | ERP 6.0 | RBUSA

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	/BIC/B0000171000	PSA for 0FI_GL_21 T90CLNT090 G/L Accts: Balances	18	RBUSA		nvarchar	4	0
2	/BIC/B0000173000	PSA for 0FI_GL_10 T90CLNT090 General Ledger: Bal.	19	RBUSA		nvarchar	4	0
3	/BIC/B0000174000	PSA for 0FI_GL_11 T90CLNT090 Lead. Ldgr Bals LIs	21	RBUSA		nvarchar	4	0
4	/BIC/B0000175000	PSA for 0FI_GL_12 T90CLNT090 Lead. Ldgr Bals (Q)	21	RBUSA		nvarchar	4	0
5	FAGLFLEXC	EMU: Sum of Open Items of Table FAGLFLEXT	27	RBUSA	Business Area	nvarchar	4	0
6	FAGLFLEXD	EMU: Documentation of changes in Txn.Figs of Tabl FAGLFLEXT	29	RBUSA	Business Area	nvarchar	4	0
7	FAGLFLEXT_BAK	General Ledger: Totals	29	RBUSA	Business Area	nvarchar	4	0
8	FAGLFLEXT_DIF	Delta Table: G/L Totals	29	RBUSA	Business Area	nvarchar	4	0
9	GLT0_BAK	G/L Account Master Record Transaction Figures	8	RBUSA	Business Area	nvarchar	4	0
10	GLT0_DIF	Delta Table: G/L Account Master Transaction Figures	8	RBUSA	Business Area	nvarchar	4	0
11	ZSAWA	Actual line item table	16	RBUSA	Business Area	nvarchar	4	0
12	ZSAWP	Plan line items table	16	RBUSA	Business Area	nvarchar	4	0
13	ZSAWT	Summary table	15	RBUSA	Business Area	nvarchar	4	0
14	ZSPLITA	Isteinzelposten-Tabelle	16	RBUSA	Geschäftsbereich	nvarchar	4	0
15	ZSPLITP	Planeinzelposten-Tabelle	16	RBUSA	Geschäftsbereich	nvarchar	4	0
16	ZSPLITT	Summentabelle	15	RBUSA	Geschäftsbereich	nvarchar	4	0
17	ZZ001A	Actual Line Item Table	16	RBUSA	Business Area	nvarchar	4	0
18	ZZ001P	Plan Line Items Table	16	RBUSA	Business Area	nvarchar	4	0
19	ZZ001T	Summary Table	15	RBUSA	Business Area	nvarchar	4	0
20	ZZLINEA	Actual line item table	16	RBUSA	Business Area	nvarchar	4	0
21	ZZLINEP	Plan line items table	16	RBUSA	Business Area	nvarchar	4	0
22	ZZLINET	Summary table	15	RBUSA	Business Area	nvarchar	4	0
23	ZZSPECA	Actual line item table	16	RBUSA	Business Area	nvarchar	4	0
24	ZZSPECP	Plan line item table	16	RBUSA	Business Area	nvarchar	4	0
25	ZZSPECT	Summary table	14	RBUSA	Business Area	nvarchar	4	0
TOPBasic Functions
26	FILCA	FI-LC: Actual journal entry table with 2 object tables	16	RBUSA	Business Area	nvarchar	4	0
27	FILCP	FI-LC: Plan line items for object table	16	RBUSA	Business Area	nvarchar	4	0
28	FILCT	FI-LC: Global totals table with 2 object tables	15	RBUSA	Business Area	nvarchar	4	0
29	GGREFA	Example for Global FI-SL Line Items (Actual)	17	RBUSA	Business Area	nvarchar	4	0
30	GGREFP	Example for Global FI-SL Line Items (Plan)	17	RBUSA	Business Area	nvarchar	4	0
31	GGREFT	Example for Global FI-SL Summary Table	16	RBUSA	Business Area	nvarchar	4	0
32	GLFUNCA	Actual Line Items Table for Cost of Sales Accounting	16	RBUSA	Business Area	nvarchar	4	0
33	GLFUNCP	Plan Line Items Table for Cost of Sales Accounting	16	RBUSA	Business Area	nvarchar	4	0
34	GLFUNCT	Totals Table for Cost of Sales Accounting	15	RBUSA	Business Area	nvarchar	4	0
35	GLFUNCU	Rollup line item tables with function area for IDES	16	RBUSA	Business Area	nvarchar	4	0
36	GLFUNCV	Rollup plan line items table with function area for IDES	16	RBUSA	Business Area	nvarchar	4	0
37	GLP0	Local Logical General Ledger Plan Line Items	8	RBUSA	Business Area	nvarchar	4	0
38	GLPO1	Plan Line Items for Object Table	18	RBUSA	Business Area	nvarchar	4	0
39	GLPO2	Plan Line Items for Object Table Global	19	RBUSA	Business Area	nvarchar	4	0
40	GLPO3	Plan Line Items for Object Table	18	RBUSA	Business Area	nvarchar	4	0
41	GLREFA	Example for Local FI-SL Line Items (Actual)	16	RBUSA	Business Area	nvarchar	4	0
42	GLREFP	Example for Local FI-SL Line Items (Plan)	16	RBUSA	Business Area	nvarchar	4	0
43	GLREFT	Example for Local FI-SL Summary Table	15	RBUSA	Business Area	nvarchar	4	0
44	GLREFU	Example for FI-SL Rollup Line Items (Actual)	16	RBUSA	Business Area	nvarchar	4	0
45	GLREFV	Example for Rollup FI-SL Line Items (Plan)	16	RBUSA	Business Area	nvarchar	4	0
46	GLSO1	FI-SL Line Item Table with Objects for GLTO1	18	RBUSA	Business Area	nvarchar	4	0
47	GLSO2	FI-SL Table with Objects, Structure corresponds to GLS2	19	RBUSA	Business Area	nvarchar	4	0
48	GLSO3	FI-SL LI Table with Objects for GLTO3	18	RBUSA	Business Area	nvarchar	4	0
49	GLT0	G/L account master record transaction figures	8	RBUSA	Business Area	nvarchar	4	0
50	GLT3	Summary Data Preparations for Consolidation	8	RBUSA	Business Area	nvarchar	4	0
51	GLTO1	FI-SL Table with Objects, Structure Corresponds to GLT1	15	RBUSA	Business Area	nvarchar	4	0
52	GLTO2	FI-SL Table with Objects, Structure Corresponds to GLT2	16	RBUSA	Business Area	nvarchar	4	0
53	GLTO3	FISL Table with Objects, Amounts and Quantities in Format P9	15	RBUSA	Business Area	nvarchar	4	0
TOPCollectionsDisbursements
54	GLISDEA	Actual Line Item Tables for Insurance (DE)	16	RBUSA	Business Area	nvarchar	4	0
55	GLISDEP	Plan Line Item Table for Insurance (DE)	16	RBUSA	Business Area	nvarchar	4	0
56	GLISDET	Summary Table for Insurance (DE)	15	RBUSA	Business Area	nvarchar	4	0
57	GRISDEA	Actual Line Item Table for Insurance (DE) - Rollup	16	RBUSA	Business Area	nvarchar	4	0
58	GRISDEP	Plan Line Item Table for Insurance (DE) - Rollup	16	RBUSA	Business Area	nvarchar	4	0
59	GRISDET	Summary Table for Insurance (DE) - Rollup	15	RBUSA	Business Area	nvarchar	4	0
TOPCost Element Accounting
60	COFIP	Single plan items for reconciliation ledger	19	RBUSA	Business Area	nvarchar	4	0
61	COFIS	Actual line items for reconciliation ledger	19	RBUSA	Business Area	nvarchar	4	0
62	COFIT	Totals Records for Reconciliation Ledger	18	RBUSA	Business Area	nvarchar	4	0
TOPData Retention Tool
63	TXW_S_COFI	Retrieve COFIS from archive	12	RBUSA	Business Area	nvarchar	4	0
64	TXW_S_GLT0	Retrieve archived GLT0 data	8	RBUSA	Business Area	nvarchar	4	0
TOPFinancial Services Localization
65	/CEEIS/RUA	Actual line item table	16	RBUSA	Business Area	nvarchar	4	0
66	/CEEIS/RUP	Plan line items table	16	RBUSA	Business Area	nvarchar	4	0
67	/CEEIS/RUT	Totals Table	15	RBUSA	Business Area	nvarchar	4	0
TOPFund Accounting
68	FMGLFLEX03	General ledger: SAP additional account assignment	3	RBUSA	Business Area	nvarchar	4	0
69	FMGLFLEXA	General Ledger: Actual Line Items	17	RBUSA	Business Area	nvarchar	4	0
70	FMGLFLEXP	General Ledger: Plan Line Items	19	RBUSA	Business Area	nvarchar	4	0
71	FMGLFLEXT	General Ledger Public Sector: Total	26	RBUSA	Business Area	nvarchar	4	0
72	PSGLFLEX03	General ledger: SAP additional account assignment	3	RBUSA	Business Area	nvarchar	4	0
73	PSGLFLEXA	General Ledger: Actual Line Items	19	RBUSA	Business Area	nvarchar	4	0
74	PSGLFLEXP	General Ledger: Plan Line Items	21	RBUSA	Business Area	nvarchar	4	0
75	PSGLFLEXT	General Ledger Public Sector: Total	28	RBUSA	Business Area	nvarchar	4	0
TOPFunds Management
76	FMFG_SAV_FACTS1A	Saved FACTS1A data for docs excluded from SL Repost for 600	24	RBUSA	Business Area	nvarchar	4	0
77	FMFG_SAV_FMUSFGA	Saved FMUSFGA data for docs excluded from SL Repost for 600	15	RBUSA	Business Area	nvarchar	4	0
78	FMIA	Actual Line Item Table for Funds Management	30	RBUSA	Business Area	nvarchar	4	0
79	FMIC	Object table 2	5	RBUSA	Business Area	nvarchar	4	0
80	FMIP	Plan Line Items Table for Funds Management	29	RBUSA	Business Area	nvarchar	4	0
81	FMIT	Totals Table for Funds Management	28	RBUSA	Business Area	nvarchar	4	0
82	FMSPLITA	Actual line item table	15	RBUSA	Business Area	nvarchar	4	0
83	FMSPLITP	Plan line items table	15	RBUSA	Business Area	nvarchar	4	0
84	FMSPLITT	Summary table	14	RBUSA	Business Area	nvarchar	4	0
85	FMUSFGA	Actual line item table for US Federal Government.	15	RBUSA	Business Area	nvarchar	4	0
86	FMUSFGFACTS1A	4Actual line item table	24	RBUSA	Business Area	nvarchar	4	0
87	FMUSFGFACTS1P	Plan line items table	24	RBUSA	Business Area	nvarchar	4	0
88	FMUSFGFACTS1T	Summary table	23	RBUSA	Business Area	nvarchar	4	0
89	FMUSFGP	Plan line items table	15	RBUSA	Business Area	nvarchar	4	0
90	FMUSFGT	Summary table for US Federal Government	14	RBUSA	Business Area	nvarchar	4	0
TOPGeneral Ledger Accounting
91	FAGLFLEX03	General ledger: SAP additional account assignment	6	RBUSA	Business Area	nvarchar	4	0
92	FAGLFLEXA	General Ledger: Actual Line Items	20	RBUSA	Business Area	nvarchar	4	0
93	FAGLFLEXP	General Ledger: Plan Line Items	22	RBUSA	Business Area	nvarchar	4	0
94	FAGLFLEXT	General Ledger: Totals	29	RBUSA	Business Area	nvarchar	4	0
95	FAGLSKF	General Ledger: Statistical Key Figures (Current Values)	9	RBUSA	Business Area	nvarchar	4	0
96	FAGLSKF_PN	General Ledger; Statistical Key Figures (Source Document)	11	RBUSA	Business Area	nvarchar	4	0
97	FAGL_BW_LOG_TOTL	FI-GL: Log for BW Extraction: Totals Records	22	RBUSA	Business Area	nvarchar	4	0
98	FAGL_QUEUE_LOG	Log of Delta Queue for Error Analysis	20	RBUSA	Business Area	nvarchar	4	0
99	GLFLEX03	General ledger: SAP additional account assignment	5	RBUSA	Business Area	nvarchar	4	0
100	GLFLEXA	Flexible general ledger: Actual line items	16	RBUSA	Business Area	nvarchar	4	0
101	GLFLEXP	Flexible G/L: Plan line items	16	RBUSA	Business Area	nvarchar	4	0
102	GLFLEXT	Flexible G/L: Totals	22	RBUSA	Business Area	nvarchar	4	0
TOPJoint Venture und Production Sharing Accounting
103	JVGLFLEX03	General ledger: SAP additional account assignment	6	RBUSA	Business Area	nvarchar	4	0
104	JVGLFLEXA	General Ledger: Actual Line Items	20	RBUSA	Business Area	nvarchar	4	0
105	JVGLFLEXP	General Ledger: Plan Line Items	22	RBUSA	Business Area	nvarchar	4	0
106	JVGLFLEXT	General Ledger: Totals	29	RBUSA	Business Area	nvarchar	4	0
107	JVPO1	JVA: Plan Line Items	18	RBUSA	Business Area	nvarchar	4	0
108	JVPSC01A	Actual line item table	20	RBUSA	Business Area	nvarchar	4	0
109	JVPSC01P	Plan line item table	20	RBUSA	Business Area	nvarchar	4	0
110	JVPSC01T	Summary table	19	RBUSA	Business Area	nvarchar	4	0
111	JVSO1	JV LI Table with Objects for JVTO1	18	RBUSA	Business Area	nvarchar	4	0
112	JVTO1	JV Summary Table with Objects	17	RBUSA	Business Area	nvarchar	4	0
113	T8JIX	JV index table	9	RBUSA	Business Area	nvarchar	4	0
TOPTariffs, Duties and Permits
114	OIHEDA	Actual line item table, IS-OIL Excise Duty Special Ledger	23	RBUSA	Business Area	nvarchar	4	0
115	OIHEDP	Plan line item table, IS-OIL Excise Duty Special Ledger	23	RBUSA	Business Area	nvarchar	4	0
116	OIHEDT	Summary table, IS-OIL Excise Duty Special Ledger	22	RBUSA	Business Area	nvarchar	4	0
117	OIHSLA	TDP (excise duty) special ledger actual line item table	22	RBUSA	Business Area	nvarchar	4	0
118	OIHSLT	TDP (excise duty) special ledger summary table	20	RBUSA	Business Area	nvarchar	4	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

118 columns | ERP 6.0 | RBUSA