	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

83 columns | ERP 6.0 | SFAREA

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	/BIC/B0000171000	PSA for 0FI_GL_21 T90CLNT090 G/L Accts: Balances	23	SFAREA		nvarchar	16	0
2	/BIC/B0000173000	PSA for 0FI_GL_10 T90CLNT090 General Ledger: Bal.	24	SFAREA		nvarchar	16	0
3	/BIC/B0000174000	PSA for 0FI_GL_11 T90CLNT090 Lead. Ldgr Bals LIs	26	SFAREA		nvarchar	16	0
4	/BIC/B0000175000	PSA for 0FI_GL_12 T90CLNT090 Lead. Ldgr Bals (Q)	26	SFAREA		nvarchar	16	0
5	FAGLFLEXC	EMU: Sum of Open Items of Table FAGLFLEXT	33	SFAREA	Partner Functional Area	nvarchar	16	0
6	FAGLFLEXD	EMU: Documentation of changes in Txn.Figs of Tabl FAGLFLEXT	35	SFAREA	Partner Functional Area	nvarchar	16	0
7	FAGLFLEXT_BAK	General Ledger: Totals	35	SFAREA	Partner Functional Area	nvarchar	16	0
8	FAGLFLEXT_DIF	Delta Table: G/L Totals	35	SFAREA	Partner Functional Area	nvarchar	16	0
9	GLPCA_CT	Profit Center Documents	115	SFAREA	Partner Functional Area	nvarchar	16	0
10	GLPCA_T_CT	Profit Center Documents	131	SFAREA	Partner Functional Area	nvarchar	16	0
11	ZSAWA	Actual line item table	24	SFAREA	Partner Functional Area	nvarchar	16	0
12	ZSAWP	Plan line items table	24	SFAREA	Partner Functional Area	nvarchar	16	0
13	ZSAWT	Summary table	23	SFAREA	Partner Functional Area	nvarchar	16	0
14	ZSPLITA	Isteinzelposten-Tabelle	23	SFAREA	Funktionsbereich des Partners	nvarchar	16	0
15	ZSPLITP	Planeinzelposten-Tabelle	23	SFAREA	Funktionsbereich des Partners	nvarchar	16	0
16	ZSPLITT	Summentabelle	22	SFAREA	Funktionsbereich des Partners	nvarchar	16	0
17	ZZ001A	Actual Line Item Table	31	SFAREA	Partner Functional Area	nvarchar	16	0
18	ZZ001P	Plan Line Items Table	31	SFAREA	Partner Functional Area	nvarchar	16	0
19	ZZ001T	Summary Table	30	SFAREA	Partner Functional Area	nvarchar	16	0
20	ZZLINEA	Actual line item table	25	SFAREA	Partner Functional Area	nvarchar	16	0
21	ZZLINEP	Plan line items table	25	SFAREA	Partner Functional Area	nvarchar	16	0
22	ZZLINET	Summary table	24	SFAREA	Partner Functional Area	nvarchar	16	0
23	ZZSPECA	Actual line item table	23	SFAREA	Partner Functional Area	nvarchar	16	0
24	ZZSPECP	Plan line item table	23	SFAREA	Partner Functional Area	nvarchar	16	0
25	ZZSPECT	Summary table	21	SFAREA	Partner Functional Area	nvarchar	16	0
TOPBasic Functions
26	GGREFA	Example for Global FI-SL Line Items (Actual)	26	SFAREA	Partner Functional Area	nvarchar	16	0
27	GGREFP	Example for Global FI-SL Line Items (Plan)	26	SFAREA	Partner Functional Area	nvarchar	16	0
28	GGREFT	Example for Global FI-SL Summary Table	25	SFAREA	Partner Functional Area	nvarchar	16	0
29	GLFUNCA	Actual Line Items Table for Cost of Sales Accounting	25	SFAREA	Partner Functional Area	nvarchar	16	0
30	GLFUNCP	Plan Line Items Table for Cost of Sales Accounting	25	SFAREA	Partner Functional Area	nvarchar	16	0
31	GLFUNCT	Totals Table for Cost of Sales Accounting	24	SFAREA	Partner Functional Area	nvarchar	16	0
32	GLFUNCU	Rollup line item tables with function area for IDES	25	SFAREA	Partner Functional Area	nvarchar	16	0
33	GLFUNCV	Rollup plan line items table with function area for IDES	25	SFAREA	Partner Functional Area	nvarchar	16	0
34	GLREFA	Example for Local FI-SL Line Items (Actual)	24	SFAREA	Partner Functional Area	nvarchar	16	0
35	GLREFP	Example for Local FI-SL Line Items (Plan)	24	SFAREA	Partner Functional Area	nvarchar	16	0
36	GLREFT	Example for Local FI-SL Summary Table	23	SFAREA	Partner Functional Area	nvarchar	16	0
37	GLREFU	Example for FI-SL Rollup Line Items (Actual)	25	SFAREA	Partner Functional Area	nvarchar	16	0
38	GLREFV	Example for Rollup FI-SL Line Items (Plan)	25	SFAREA	Partner Functional Area	nvarchar	16	0
TOPCost Element Accounting
39	COFIP	Single plan items for reconciliation ledger	30	SFAREA	Partner Functional Area	nvarchar	16	0
40	COFIS	Actual line items for reconciliation ledger	30	SFAREA	Partner Functional Area	nvarchar	16	0
41	COFIT	Totals Records for Reconciliation Ledger	29	SFAREA	Partner Functional Area	nvarchar	16	0
TOPData Retention Tool
42	TXW_S_COFI	Retrieve COFIS from archive	17	SFAREA	Partner Functional Area	nvarchar	16	0
TOPFinancial Services Localization
43	/CEEIS/RUA	Actual line item table	32	SFAREA	Partner Functional Area	nvarchar	16	0
44	/CEEIS/RUP	Plan line items table	32	SFAREA	Partner Functional Area	nvarchar	16	0
45	/CEEIS/RUT	Totals Table	31	SFAREA	Partner Functional Area	nvarchar	16	0
TOPFund Accounting
46	FMGLFLEX06	General ledger: Sender SAP additional account assignment	2	SFAREA	Partner Functional Area	nvarchar	16	0
47	FMGLFLEXA	General Ledger: Actual Line Items	20	SFAREA	Partner Functional Area	nvarchar	16	0
48	FMGLFLEXP	General Ledger: Plan Line Items	22	SFAREA	Partner Functional Area	nvarchar	16	0
49	FMGLFLEXT	General Ledger Public Sector: Total	29	SFAREA	Partner Functional Area	nvarchar	16	0
50	PSGLFLEX06	General ledger: Sender SAP additional account assignment	2	SFAREA	Partner Functional Area	nvarchar	16	0
51	PSGLFLEXA	General Ledger: Actual Line Items	22	SFAREA	Partner Functional Area	nvarchar	16	0
52	PSGLFLEXP	General Ledger: Plan Line Items	24	SFAREA	Partner Functional Area	nvarchar	16	0
53	PSGLFLEXT	General Ledger Public Sector: Total	31	SFAREA	Partner Functional Area	nvarchar	16	0
TOPFunds Management
54	FMCCFD	Fiscal Year Change Documents (FM)	26	SFAREA	Sender Functional Area (Fiscal Year Change FM)	nvarchar	16	0
55	FMCCFLOT	Commitment Carryforward of Held Documents (Approval Proc.)	35	SFAREA	Sender Functional Area (Fiscal Year Change FM)	nvarchar	16	0
56	FMCHA1	Work List for Reassignment Tool	18	SFAREA	Functional Area	nvarchar	16	0
57	FMREAS_INDEX_FA	Index Table for Reassignment Tool Using the Functional Area	4	SFAREA	Functional Area	nvarchar	16	0
58	FMSPLITA	Actual line item table	29	SFAREA	Partner Functional Area	nvarchar	16	0
59	FMSPLITP	Plan line items table	29	SFAREA	Partner Functional Area	nvarchar	16	0
60	FMSPLITT	Summary table	30	SFAREA	Partner Functional Area	nvarchar	16	0
61	FMUDREL	Assignment of Expenditure Objs.to Revenue Objs Incr.Budget	5	SFAREA	Functional Area	nvarchar	16	0
62	FMUDRELC	Assignment of Expenditure Objs.to Revenue Objs Incr.Budget	5	SFAREA	Functional Area	nvarchar	16	0
TOPGeneral Ledger Accounting
63	FAGLFLEX06	General ledger: Sender SAP additional account assignment	4	SFAREA	Partner Functional Area	nvarchar	16	0
64	FAGLFLEXA	General Ledger: Actual Line Items	26	SFAREA	Partner Functional Area	nvarchar	16	0
65	FAGLFLEXP	General Ledger: Plan Line Items	28	SFAREA	Partner Functional Area	nvarchar	16	0
66	FAGLFLEXT	General Ledger: Totals	35	SFAREA	Partner Functional Area	nvarchar	16	0
67	FAGL_BW_LOG_TOTL	FI-GL: Log for BW Extraction: Totals Records	27	SFAREA	Partner Functional Area	nvarchar	16	0
68	FAGL_QUEUE_LOG	Log of Delta Queue for Error Analysis	25	SFAREA	Partner Functional Area	nvarchar	16	0
69	GLFLEX06	General ledger: Sender SAP additional account assignment	4	SFAREA	Partner Functional Area	nvarchar	16	0
70	GLFLEXA	Flexible general ledger: Actual line items	21	SFAREA	Partner Functional Area	nvarchar	16	0
71	GLFLEXP	Flexible G/L: Plan line items	21	SFAREA	Partner Functional Area	nvarchar	16	0
72	GLFLEXT	Flexible G/L: Totals	27	SFAREA	Partner Functional Area	nvarchar	16	0
TOPJoint Venture und Production Sharing Accounting
73	JVGLFLEX06	General ledger: Sender SAP additional account assignment	4	SFAREA	Partner Functional Area	nvarchar	16	0
74	JVGLFLEXA	General Ledger: Actual Line Items	25	SFAREA	Partner Functional Area	nvarchar	16	0
75	JVGLFLEXP	General Ledger: Plan Line Items	27	SFAREA	Partner Functional Area	nvarchar	16	0
76	JVGLFLEXT	General Ledger: Totals	34	SFAREA	Partner Functional Area	nvarchar	16	0
TOPProfit Center Accounting
77	GLPCA	EC-PCA: Actual Line Items	29	SFAREA	Partner Functional Area	nvarchar	16	0
78	GLPCP	EC-PCA: Plan Line Items	29	SFAREA	Partner Functional Area	nvarchar	16	0
79	GLPCT	EC-PCA: Totals Table	29	SFAREA	Partner Functional Area	nvarchar	16	0
80	T8APP_GLPCM	EC-PCA: Plan Costs from Material Costing for Rep. Material	31	SFAREA	Partner Functional Area	nvarchar	16	0
TOPTariffs, Duties and Permits
81	OIHEDA	Actual line item table, IS-OIL Excise Duty Special Ledger	38	SFAREA	Partner Functional Area	nvarchar	16	0
82	OIHEDP	Plan line item table, IS-OIL Excise Duty Special Ledger	38	SFAREA	Partner Functional Area	nvarchar	16	0
83	OIHEDT	Summary table, IS-OIL Excise Duty Special Ledger	37	SFAREA	Partner 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

83 columns | ERP 6.0 | SFAREA