	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

106 columns | ERP 6.0 | RFAREA

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	/ATL/6111_CONV	Convert Financial Key/Functional Area to Form 6111 Code	3	RFAREA	Functional Area	nvarchar	16	0
2	/BIC/B0000171000	PSA for 0FI_GL_21 T90CLNT090 G/L Accts: Balances	17	RFAREA		nvarchar	16	0
3	/BIC/B0000173000	PSA for 0FI_GL_10 T90CLNT090 General Ledger: Bal.	18	RFAREA		nvarchar	16	0
4	/BIC/B0000174000	PSA for 0FI_GL_11 T90CLNT090 Lead. Ldgr Bals LIs	20	RFAREA		nvarchar	16	0
5	/BIC/B0000175000	PSA for 0FI_GL_12 T90CLNT090 Lead. Ldgr Bals (Q)	20	RFAREA		nvarchar	16	0
6	FAGLFLEXC	EMU: Sum of Open Items of Table FAGLFLEXT	26	RFAREA	Functional Area	nvarchar	16	0
7	FAGLFLEXD	EMU: Documentation of changes in Txn.Figs of Tabl FAGLFLEXT	28	RFAREA	Functional Area	nvarchar	16	0
8	FAGLFLEXT_BAK	General Ledger: Totals	28	RFAREA	Functional Area	nvarchar	16	0
9	FAGLFLEXT_DIF	Delta Table: G/L Totals	28	RFAREA	Functional Area	nvarchar	16	0
10	GLPCA_CT	Profit Center Documents	105	RFAREA	Functional Area	nvarchar	16	0
11	GLPCA_T_CT	Profit Center Documents	121	RFAREA	Functional Area	nvarchar	16	0
12	ZSAWA	Actual line item table	18	RFAREA	Functional Area	nvarchar	16	0
13	ZSAWP	Plan line items table	18	RFAREA	Functional Area	nvarchar	16	0
14	ZSAWT	Summary table	17	RFAREA	Functional Area	nvarchar	16	0
15	ZSPLITA	Isteinzelposten-Tabelle	17	RFAREA	Funktionsbereich	nvarchar	16	0
16	ZSPLITP	Planeinzelposten-Tabelle	17	RFAREA	Funktionsbereich	nvarchar	16	0
17	ZSPLITT	Summentabelle	16	RFAREA	Funktionsbereich	nvarchar	16	0
18	ZZ001A	Actual Line Item Table	18	RFAREA	Functional Area	nvarchar	16	0
19	ZZ001P	Plan Line Items Table	18	RFAREA	Functional Area	nvarchar	16	0
20	ZZ001T	Summary Table	17	RFAREA	Functional Area	nvarchar	16	0
21	ZZLINEA	Actual line item table	17	RFAREA	Functional Area	nvarchar	16	0
22	ZZLINEP	Plan line items table	17	RFAREA	Functional Area	nvarchar	16	0
23	ZZLINET	Summary table	16	RFAREA	Functional Area	nvarchar	16	0
24	ZZSPECA	Actual line item table	17	RFAREA	Functional Area	nvarchar	16	0
25	ZZSPECP	Plan line item table	17	RFAREA	Functional Area	nvarchar	16	0
26	ZZSPECT	Summary table	15	RFAREA	Functional Area	nvarchar	16	0
TOPBasic Functions
27	GGREFA	Example for Global FI-SL Line Items (Actual)	19	RFAREA	Functional Area	nvarchar	16	0
28	GGREFP	Example for Global FI-SL Line Items (Plan)	19	RFAREA	Functional Area	nvarchar	16	0
29	GGREFT	Example for Global FI-SL Summary Table	18	RFAREA	Functional Area	nvarchar	16	0
30	GLFUNCA	Actual Line Items Table for Cost of Sales Accounting	17	RFAREA	Functional Area	nvarchar	16	0
31	GLFUNCP	Plan Line Items Table for Cost of Sales Accounting	17	RFAREA	Functional Area	nvarchar	16	0
32	GLFUNCT	Totals Table for Cost of Sales Accounting	16	RFAREA	Functional Area	nvarchar	16	0
33	GLFUNCU	Rollup line item tables with function area for IDES	17	RFAREA	Functional Area	nvarchar	16	0
34	GLFUNCV	Rollup plan line items table with function area for IDES	17	RFAREA	Functional Area	nvarchar	16	0
35	GLREFA	Example for Local FI-SL Line Items (Actual)	18	RFAREA	Functional Area	nvarchar	16	0
36	GLREFP	Example for Local FI-SL Line Items (Plan)	18	RFAREA	Functional Area	nvarchar	16	0
37	GLREFT	Example for Local FI-SL Summary Table	17	RFAREA	Functional Area	nvarchar	16	0
38	GLREFU	Example for FI-SL Rollup Line Items (Actual)	18	RFAREA	Functional Area	nvarchar	16	0
39	GLREFV	Example for Rollup FI-SL Line Items (Plan)	18	RFAREA	Functional Area	nvarchar	16	0
TOPCost Element Accounting
40	COFIP	Single plan items for reconciliation ledger	20	RFAREA	Functional Area	nvarchar	16	0
41	COFIS	Actual line items for reconciliation ledger	20	RFAREA	Functional Area	nvarchar	16	0
42	COFIT	Totals Records for Reconciliation Ledger	19	RFAREA	Functional Area	nvarchar	16	0
TOPData Retention Tool
43	TXW_S_COFI	Retrieve COFIS from archive	13	RFAREA	Functional Area	nvarchar	16	0
TOPFinancial Services Localization
44	/CEEIS/RUA	Actual line item table	18	RFAREA	Functional Area	nvarchar	16	0
45	/CEEIS/RUP	Plan line items table	18	RFAREA	Functional Area	nvarchar	16	0
46	/CEEIS/RUT	Totals Table	17	RFAREA	Functional Area	nvarchar	16	0
TOPFund Accounting
47	FMCCAVCA	Actual line item table	18	RFAREA	Functional Area	nvarchar	16	0
48	FMCCAVCP	Plan line items table	18	RFAREA	Functional Area	nvarchar	16	0
49	FMCCAVCT	Totals Table	17	RFAREA	Functional Area	nvarchar	16	0
50	FMGLFLEX07	General Ledger: Reserve Table 1	4	RFAREA	Functional Area	nvarchar	16	0
51	FMGLFLEXA	General Ledger: Actual Line Items	27	RFAREA	Functional Area	nvarchar	16	0
52	FMGLFLEXP	General Ledger: Plan Line Items	29	RFAREA	Functional Area	nvarchar	16	0
53	FMGLFLEXT	General Ledger Public Sector: Total	36	RFAREA	Functional Area	nvarchar	16	0
54	PSGLFLEX07	General Ledger: Reserve Table 1	4	RFAREA	Functional Area	nvarchar	16	0
55	PSGLFLEXA	General Ledger: Actual Line Items	30	RFAREA	Functional Area	nvarchar	16	0
56	PSGLFLEXP	General Ledger: Plan Line Items	32	RFAREA	Functional Area	nvarchar	16	0
57	PSGLFLEXT	General Ledger Public Sector: Total	39	RFAREA	Functional Area	nvarchar	16	0
TOPFunds Management
58	FMCCFD	Fiscal Year Change Documents (FM)	32	RFAREA	Receiver Functional Area (Fiscal Year Change FM)	nvarchar	16	0
59	FMCCFLOT	Commitment Carryforward of Held Documents (Approval Proc.)	27	RFAREA	Receiver Functional Area (Fiscal Year Change FM)	nvarchar	16	0
60	FMFG_SAV_FACTS1A	Saved FACTS1A data for docs excluded from SL Repost for 600	26	RFAREA	Functional Area	nvarchar	16	0
61	FMFG_SAV_FMUSFGA	Saved FMUSFGA data for docs excluded from SL Repost for 600	19	RFAREA	Functional Area	nvarchar	16	0
62	FMIA	Actual Line Item Table for Funds Management	26	RFAREA	Functional Area	nvarchar	16	0
63	FMIP	Plan Line Items Table for Funds Management	25	RFAREA	Functional Area	nvarchar	16	0
64	FMIT	Totals Table for Funds Management	24	RFAREA	Functional Area	nvarchar	16	0
65	FMRPREL	Assignment of Expenditure Objects to Revenue Cover Pool	6	RFAREA	Functional Area	nvarchar	16	0
66	FMSPLITA	Actual line item table	18	RFAREA	Functional Area	nvarchar	16	0
67	FMSPLITP	Plan line items table	18	RFAREA	Functional Area	nvarchar	16	0
68	FMSPLITT	Summary table	17	RFAREA	Functional Area	nvarchar	16	0
69	FMUDBSEGH	Addtl Info on Revenues Increasing Budget for Recovery Order	9	RFAREA	Functional Area	nvarchar	16	0
70	FMUDBSEGP	Part.Payt Item for Customer Invoice of a Rev. Incr. the Bgt	15	RFAREA	Functional Area	nvarchar	16	0
71	FMUDKBLPH	Addtl Info re Revenues Increasing Budget for Fcst of Revenue	7	RFAREA	Functional Area	nvarchar	16	0
72	FMUDKBLPP	Item Revenues Increasing Budget for Forecast of Revenue	10	RFAREA	Functional Area	nvarchar	16	0
73	FMUDREL	Assignment of Expenditure Objs.to Revenue Objs Incr.Budget	9	RFAREA	Functional Area	nvarchar	16	0
74	FMUDRELC	Assignment of Expenditure Objs.to Revenue Objs Incr.Budget	9	RFAREA	Functional Area	nvarchar	16	0
75	FMUSFGA	Actual line item table for US Federal Government.	19	RFAREA	Functional Area	nvarchar	16	0
76	FMUSFGFACTS1A	4Actual line item table	26	RFAREA	Functional Area	nvarchar	16	0
77	FMUSFGFACTS1P	Plan line items table	26	RFAREA	Functional Area	nvarchar	16	0
78	FMUSFGFACTS1T	Summary table	25	RFAREA	Functional Area	nvarchar	16	0
79	FMUSFGP	Plan line items table	19	RFAREA	Functional Area	nvarchar	16	0
80	FMUSFGT	Summary table for US Federal Government	18	RFAREA	Functional Area	nvarchar	16	0
TOPGeneral Ledger Accounting
81	FAGLFLEX03	General ledger: SAP additional account assignment	5	RFAREA	Functional Area	nvarchar	16	0
82	FAGLFLEXA	General Ledger: Actual Line Items	19	RFAREA	Functional Area	nvarchar	16	0
83	FAGLFLEXP	General Ledger: Plan Line Items	21	RFAREA	Functional Area	nvarchar	16	0
84	FAGLFLEXT	General Ledger: Totals	28	RFAREA	Functional Area	nvarchar	16	0
85	FAGLSKF	General Ledger: Statistical Key Figures (Current Values)	8	RFAREA	Functional Area	nvarchar	16	0
86	FAGLSKF_PN	General Ledger; Statistical Key Figures (Source Document)	10	RFAREA	Functional Area	nvarchar	16	0
87	FAGL_BW_LOG_TOTL	FI-GL: Log for BW Extraction: Totals Records	21	RFAREA	Functional Area	nvarchar	16	0
88	FAGL_QUEUE_LOG	Log of Delta Queue for Error Analysis	19	RFAREA	Functional Area	nvarchar	16	0
89	GLFLEX03	General ledger: SAP additional account assignment	4	RFAREA	Functional Area	nvarchar	16	0
90	GLFLEXA	Flexible general ledger: Actual line items	15	RFAREA	Functional Area	nvarchar	16	0
91	GLFLEXP	Flexible G/L: Plan line items	15	RFAREA	Functional Area	nvarchar	16	0
92	GLFLEXT	Flexible G/L: Totals	21	RFAREA	Functional Area	nvarchar	16	0
TOPJoint Venture und Production Sharing Accounting
93	JVGLFLEX03	General ledger: SAP additional account assignment	5	RFAREA	Functional Area	nvarchar	16	0
94	JVGLFLEXA	General Ledger: Actual Line Items	19	RFAREA	Functional Area	nvarchar	16	0
95	JVGLFLEXP	General Ledger: Plan Line Items	21	RFAREA	Functional Area	nvarchar	16	0
96	JVGLFLEXT	General Ledger: Totals	28	RFAREA	Functional Area	nvarchar	16	0
TOPProfit Center Accounting
97	GLPCA	EC-PCA: Actual Line Items	17	RFAREA	Functional Area	nvarchar	16	0
98	GLPCP	EC-PCA: Plan Line Items	17	RFAREA	Functional Area	nvarchar	16	0
99	GLPCT	EC-PCA: Totals Table	16	RFAREA	Functional Area	nvarchar	16	0
100	T8APP_GLPCM	EC-PCA: Plan Costs from Material Costing for Rep. Material	18	RFAREA	Functional Area	nvarchar	16	0
TOPRetail Ledger
101	PCRRETAILA	Actual line item table	18	RFAREA	Functional Area	nvarchar	16	0
102	PCRRETAILP	Plan line items table	18	RFAREA	Functional Area	nvarchar	16	0
103	PCRRETAILT	Totals Table	17	RFAREA	Functional Area	nvarchar	16	0
TOPTariffs, Duties and Permits
104	OIHEDA	Actual line item table, IS-OIL Excise Duty Special Ledger	25	RFAREA	Functional Area	nvarchar	16	0
105	OIHEDP	Plan line item table, IS-OIL Excise Duty Special Ledger	25	RFAREA	Functional Area	nvarchar	16	0
106	OIHEDT	Summary table, IS-OIL Excise Duty Special Ledger	24	RFAREA	Functional Area	nvarchar	16	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

106 columns | ERP 6.0 | RFAREA