	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

154 columns | ERP 6.0 | RUNIT

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	/BIC/B0000173000	PSA for 0FI_GL_10 T90CLNT090 General Ledger: Bal.	9	RUNIT		nvarchar	3	0
2	/BIC/B0000174000	PSA for 0FI_GL_11 T90CLNT090 Lead. Ldgr Bals LIs	9	RUNIT		nvarchar	3	0
3	/BIC/B0000175000	PSA for 0FI_GL_12 T90CLNT090 Lead. Ldgr Bals (Q)	9	RUNIT		nvarchar	3	0
4	FAGLFLEXC	EMU: Sum of Open Items of Table FAGLFLEXT	18	RUNIT	Base Unit of Measure	nvarchar	3	0
5	FAGLFLEXD	EMU: Documentation of changes in Txn.Figs of Tabl FAGLFLEXT	20	RUNIT	Base Unit of Measure	nvarchar	3	0
6	FAGLFLEXT_BAK	General Ledger: Totals	17	RUNIT	Base Unit of Measure	nvarchar	3	0
7	FAGLFLEXT_DIF	Delta Table: G/L Totals	17	RUNIT	Base Unit of Measure	nvarchar	3	0
8	ZSAWA	Actual line item table	8	RUNIT	Base Unit of Measure	nvarchar	3	0
9	ZSAWP	Plan line items table	8	RUNIT	Base Unit of Measure	nvarchar	3	0
10	ZSAWT	Summary table	10	RUNIT	Base Unit of Measure	nvarchar	3	0
11	ZSEMBPSA	Actual line item table	8	RUNIT	Base Unit of Measure	nvarchar	3	0
12	ZSEMBPSP	Plan line items table	8	RUNIT	Base Unit of Measure	nvarchar	3	0
13	ZSEMBPST	Summary table	10	RUNIT	Base Unit of Measure	nvarchar	3	0
14	ZSPLITA	Isteinzelposten-Tabelle	8	RUNIT	Basismengeneinheit	nvarchar	3	0
15	ZSPLITP	Planeinzelposten-Tabelle	8	RUNIT	Basismengeneinheit	nvarchar	3	0
16	ZSPLITT	Summentabelle	10	RUNIT	Basismengeneinheit	nvarchar	3	0
17	ZZ001A	Actual Line Item Table	8	RUNIT	Base Unit of Measure	nvarchar	3	0
18	ZZ001P	Plan Line Items Table	8	RUNIT	Base Unit of Measure	nvarchar	3	0
19	ZZ001T	Summary Table	10	RUNIT	Base Unit of Measure	nvarchar	3	0
20	ZZLINEA	Actual line item table	8	RUNIT	Base Unit of Measure	nvarchar	3	0
21	ZZLINEP	Plan line items table	8	RUNIT	Base Unit of Measure	nvarchar	3	0
22	ZZLINET	Summary table	10	RUNIT	Base Unit of Measure	nvarchar	3	0
23	ZZSL01A	Actual line item table	8	RUNIT	Base Unit of Measure	nvarchar	3	0
24	ZZSL01P	Plan line items table	8	RUNIT	Base Unit of Measure	nvarchar	3	0
25	ZZSL01T	Summary table	10	RUNIT	Base Unit of Measure	nvarchar	3	0
26	ZZSPECA	Actual line item table	8	RUNIT	Base Unit of Measure	nvarchar	3	0
27	ZZSPECP	Plan line item table	8	RUNIT	Base Unit of Measure	nvarchar	3	0
28	ZZSPECT	Summary table	9	RUNIT	Base Unit of Measure	nvarchar	3	0
TOPBasic Functions
29	FILCA	FI-LC: Actual journal entry table with 2 object tables	8	RUNIT	Base Unit of Measure	nvarchar	3	0
30	FILCP	FI-LC: Plan line items for object table	8	RUNIT	Base Unit of Measure	nvarchar	3	0
31	FILCT	FI-LC: Global totals table with 2 object tables	10	RUNIT	Base Unit of Measure	nvarchar	3	0
32	GGREFA	Example for Global FI-SL Line Items (Actual)	8	RUNIT	Base Unit of Measure	nvarchar	3	0
33	GGREFP	Example for Global FI-SL Line Items (Plan)	8	RUNIT	Base Unit of Measure	nvarchar	3	0
34	GGREFT	Example for Global FI-SL Summary Table	10	RUNIT	Base Unit of Measure	nvarchar	3	0
35	GLFUNCA	Actual Line Items Table for Cost of Sales Accounting	8	RUNIT	Base Unit of Measure	nvarchar	3	0
36	GLFUNCP	Plan Line Items Table for Cost of Sales Accounting	8	RUNIT	Base Unit of Measure	nvarchar	3	0
37	GLFUNCT	Totals Table for Cost of Sales Accounting	10	RUNIT	Base Unit of Measure	nvarchar	3	0
38	GLFUNCU	Rollup line item tables with function area for IDES	8	RUNIT	Base Unit of Measure	nvarchar	3	0
39	GLFUNCV	Rollup plan line items table with function area for IDES	8	RUNIT	Base Unit of Measure	nvarchar	3	0
40	GLPO1	Plan Line Items for Object Table	10	RUNIT	Base Unit of Measure	nvarchar	3	0
41	GLPO2	Plan Line Items for Object Table Global	10	RUNIT	Base Unit of Measure	nvarchar	3	0
42	GLPO3	Plan Line Items for Object Table	10	RUNIT	Base Unit of Measure	nvarchar	3	0
43	GLREFA	Example for Local FI-SL Line Items (Actual)	8	RUNIT	Base Unit of Measure	nvarchar	3	0
44	GLREFP	Example for Local FI-SL Line Items (Plan)	8	RUNIT	Base Unit of Measure	nvarchar	3	0
45	GLREFT	Example for Local FI-SL Summary Table	10	RUNIT	Base Unit of Measure	nvarchar	3	0
46	GLREFU	Example for FI-SL Rollup Line Items (Actual)	8	RUNIT	Base Unit of Measure	nvarchar	3	0
47	GLREFV	Example for Rollup FI-SL Line Items (Plan)	8	RUNIT	Base Unit of Measure	nvarchar	3	0
48	GLSO1	FI-SL Line Item Table with Objects for GLTO1	10	RUNIT	Base Unit of Measure	nvarchar	3	0
49	GLSO2	FI-SL Table with Objects, Structure corresponds to GLS2	10	RUNIT	Base Unit of Measure	nvarchar	3	0
50	GLSO3	FI-SL LI Table with Objects for GLTO3	10	RUNIT	Base Unit of Measure	nvarchar	3	0
51	GLTO1	FI-SL Table with Objects, Structure Corresponds to GLT1	10	RUNIT	Base Unit of Measure	nvarchar	3	0
52	GLTO2	FI-SL Table with Objects, Structure Corresponds to GLT2	10	RUNIT	Base Unit of Measure	nvarchar	3	0
53	GLTO3	FISL Table with Objects, Amounts and Quantities in Format P9	10	RUNIT	Base Unit of Measure	nvarchar	3	0
TOPCollectionsDisbursements
54	GLISDEA	Actual Line Item Tables for Insurance (DE)	8	RUNIT	Base Unit of Measure	nvarchar	3	0
55	GLISDEP	Plan Line Item Table for Insurance (DE)	8	RUNIT	Base Unit of Measure	nvarchar	3	0
56	GLISDET	Summary Table for Insurance (DE)	10	RUNIT	Base Unit of Measure	nvarchar	3	0
57	GRISDEA	Actual Line Item Table for Insurance (DE) - Rollup	8	RUNIT	Base Unit of Measure	nvarchar	3	0
58	GRISDEP	Plan Line Item Table for Insurance (DE) - Rollup	8	RUNIT	Base Unit of Measure	nvarchar	3	0
59	GRISDET	Summary Table for Insurance (DE) - Rollup	10	RUNIT	Base Unit of Measure	nvarchar	3	0
TOPConsolidation
60	ECMCA	SAP Cons.: Journal Entry Table (Actual)	8	RUNIT	Base Unit of Measure	nvarchar	3	0
61	ECMCT	SAP Cons.: Totals Table	10	RUNIT	Base Unit of Measure	nvarchar	3	0
TOPContract Accounts Receivable and Payable
62	TFK060A	Install.Plan Proposal Cats	6	RUNIT	Interval Type	nvarchar	1	0
TOPCost Element Accounting
63	COFIP	Single plan items for reconciliation ledger	8	RUNIT	Base Unit of Measure	nvarchar	3	0
64	COFIS	Actual line items for reconciliation ledger	8	RUNIT	Base Unit of Measure	nvarchar	3	0
65	COFIT	Totals Records for Reconciliation Ledger	10	RUNIT	Base Unit of Measure	nvarchar	3	0
TOPFinancial Services Localization
66	/CEEIS/RUA	Actual line item table	8	RUNIT	Base Unit of Measure	nvarchar	3	0
67	/CEEIS/RUP	Plan line items table	8	RUNIT	Base Unit of Measure	nvarchar	3	0
68	/CEEIS/RUT	Totals Table	10	RUNIT	Base Unit of Measure	nvarchar	3	0
TOPFlexible Real Estate Management
69	VIPRLEDTAGRA	Isteinzelposten-Tabelle	8	RUNIT	Basismengeneinheit	nvarchar	3	0
70	VIPRLEDTAGRP	Planeinzelposten-Tabelle	8	RUNIT	Basismengeneinheit	nvarchar	3	0
71	VIPRLEDTAGRT	Summentabelle Ledger 7A Mandate	9	RUNIT	Basismengeneinheit	nvarchar	3	0
TOPFund Accounting
72	FMGLFLEX00	General ledger: Transaction attributes	5	RUNIT	Base Unit of Measure	nvarchar	3	0
73	FMGLFLEXA	General Ledger: Actual Line Items	10	RUNIT	Base Unit of Measure	nvarchar	3	0
74	FMGLFLEXP	General Ledger: Plan Line Items	12	RUNIT	Base Unit of Measure	nvarchar	3	0
75	FMGLFLEXT	General Ledger Public Sector: Total	17	RUNIT	Base Unit of Measure	nvarchar	3	0
76	PSGLFLEX00	General ledger: Transaction attributes	5	RUNIT	Base Unit of Measure	nvarchar	3	0
77	PSGLFLEXA	General Ledger: Actual Line Items	10	RUNIT	Base Unit of Measure	nvarchar	3	0
78	PSGLFLEXP	General Ledger: Plan Line Items	12	RUNIT	Base Unit of Measure	nvarchar	3	0
79	PSGLFLEXT	General Ledger Public Sector: Total	17	RUNIT	Base Unit of Measure	nvarchar	3	0
TOPGeneral Ledger Accounting
80	FAGLFLEX00	General ledger: Transaction attributes	5	RUNIT	Base Unit of Measure	nvarchar	3	0
81	FAGLFLEXA	General Ledger: Actual Line Items	10	RUNIT	Base Unit of Measure	nvarchar	3	0
82	FAGLFLEXP	General Ledger: Plan Line Items	12	RUNIT	Base Unit of Measure	nvarchar	3	0
83	FAGLFLEXT	General Ledger: Totals	17	RUNIT	Base Unit of Measure	nvarchar	3	0
84	FAGLSKF	General Ledger: Statistical Key Figures (Current Values)	14	RUNIT	Unit of measure	nvarchar	3	0
85	FAGLSKF_PN	General Ledger; Statistical Key Figures (Source Document)	16	RUNIT	Unit of measure	nvarchar	3	0
86	FAGL_BW_LOG_TOTL	FI-GL: Log for BW Extraction: Totals Records	10	RUNIT	Base Unit of Measure	nvarchar	3	0
87	FAGL_QUEUE_LOG	Log of Delta Queue for Error Analysis	8	RUNIT	Base Unit of Measure	nvarchar	3	0
88	GLFLEX07	General ledger: Transaction attributes	5	RUNIT	Base Unit of Measure	nvarchar	3	0
89	GLFLEXA	Flexible general ledger: Actual line items	27	RUNIT	Base Unit of Measure	nvarchar	3	0
90	GLFLEXP	Flexible G/L: Plan line items	27	RUNIT	Base Unit of Measure	nvarchar	3	0
91	GLFLEXT	Flexible G/L: Totals	33	RUNIT	Base Unit of Measure	nvarchar	3	0
TOPGrantee Management
92	GMAVCA	Actual line item table	8	RUNIT	Base Unit of Measure	nvarchar	3	0
93	GMAVCP	Plan line items table	8	RUNIT	Base Unit of Measure	nvarchar	3	0
94	GMAVCT	Summary table	10	RUNIT	Base Unit of Measure	nvarchar	3	0
95	GMIA	Actual Line Item Table	8	RUNIT	Base Unit of Measure	nvarchar	3	0
96	GMIP	Plan line items table	8	RUNIT	Base Unit of Measure	nvarchar	3	0
97	GMIT	Summary table	10	RUNIT	Base Unit of Measure	nvarchar	3	0
TOPJoint Venture und Production Sharing Accounting
98	JVGLFLEX00	General ledger: Transaction attributes	5	RUNIT	Base Unit of Measure	nvarchar	3	0
99	JVGLFLEXA	General Ledger: Actual Line Items	10	RUNIT	Base Unit of Measure	nvarchar	3	0
100	JVGLFLEXP	General Ledger: Plan Line Items	12	RUNIT	Base Unit of Measure	nvarchar	3	0
101	JVGLFLEXT	General Ledger: Totals	17	RUNIT	Base Unit of Measure	nvarchar	3	0
102	JVPO1	JVA: Plan Line Items	8	RUNIT	Base Unit of Measure	nvarchar	3	0
103	JVPSC01A	Actual line item table	8	RUNIT	Base Unit of Measure	nvarchar	3	0
104	JVPSC01P	Plan line item table	8	RUNIT	Base Unit of Measure	nvarchar	3	0
105	JVPSC01T	Summary table	10	RUNIT	Base Unit of Measure	nvarchar	3	0
106	JVSO1	JV LI Table with Objects for JVTO1	8	RUNIT	Base Unit of Measure	nvarchar	3	0
107	JVT1	JV Summary Table	15	RUNIT	Base Unit of Measure	nvarchar	3	0
108	JVTO1	JV Summary Table with Objects	10	RUNIT	Base Unit of Measure	nvarchar	3	0
109	T8JTPM	Joint Venture Production Month Summary Data	9	RUNIT	Base Unit of Measure	nvarchar	3	0
110	T8PSA_CLOS_STOCK	PSA Closing Stock per Partner	10	RUNIT	unit of Measure	nvarchar	3	0
111	T8PSA_PREPOST	Preliminary Posting	9	RUNIT	unit of Measure	nvarchar	3	0
112	T8PSA_STOCK_ADJ	PSA Stock Adjustment	16	RUNIT	unit of Measure	nvarchar	3	0
TOPLocalization
113	J_3RFTAXRA	Tax Accounting: Actual line item table	8	RUNIT	Base Unit of Measure	nvarchar	3	0
114	J_3RFTAXRP	Tax Accounting: Plan line item table	8	RUNIT	Base Unit of Measure	nvarchar	3	0
115	J_3RFTAXRT	Tax Accounting: Summary table	9	RUNIT	Base Unit of Measure	nvarchar	3	0
116	J_3RFTAXRVA	Tax Accounting: Actual line item table	8	RUNIT	Base Unit of Measure	nvarchar	3	0
117	J_3RFTAXRVP	Tax Accounting: Plan line item table	8	RUNIT	Base Unit of Measure	nvarchar	3	0
118	J_3RFTAXRVT	Tax Accounting: Summary table	9	RUNIT	Base Unit of Measure	nvarchar	3	0
TOPProduction and Revenue Accounting
119	OIUP_ME_MEDOC_IT	Measurement document item (PDM Shadow)	9	RUNIT	Meas.reading unit	nvarchar	3	0
120	OIU_ME_MEDOC_IT	Measurement document item	8	RUNIT	Meas.reading unit	nvarchar	3	0
TOPProfit Center Accounting
121	GLPCA	EC-PCA: Actual Line Items	8	RUNIT	Base Unit of Measure	nvarchar	3	0
122	GLPCP	EC-PCA: Plan Line Items	8	RUNIT	Base Unit of Measure	nvarchar	3	0
123	GLPCT	EC-PCA: Totals Table	10	RUNIT	Base Unit of Measure	nvarchar	3	0
124	T8APP_GLPCM	EC-PCA: Plan Costs from Material Costing for Rep. Material	10	RUNIT	Base Unit of Measure	nvarchar	3	0
TOPProfitability Analysis
125	GLTPC	Profit Center Accounting	12	RUNIT	Base Unit of Measure	nvarchar	3	0
TOPRegulatory reporting for insurance companies
126	ISSRFLDEA	Actual line item table	8	RUNIT	Base Unit of Measure	nvarchar	3	0
127	ISSRFLDEP	Plan line items table	8	RUNIT	Base Unit of Measure	nvarchar	3	0
128	ISSRFLDET	Summary table	10	RUNIT	Base Unit of Measure	nvarchar	3	0
TOPRemaining Beverage - Obsolete Objects
129	/BEV3/CHFIA	Actual line item table	8	RUNIT	Base Unit of Measure	nvarchar	3	0
130	/BEV3/CHFIP	Plan Line Items Table	8	RUNIT	Base Unit of Measure	nvarchar	3	0
131	/BEV3/CHFIT	Totals table	10	RUNIT	Base Unit of Measure	nvarchar	3	0
132	/BEV3/CHVGRA	Actual line item table	8	RUNIT	Base Unit of Measure	nvarchar	3	0
133	/BEV3/CHVGRP	Plan Line Items Table	8	RUNIT	Base Unit of Measure	nvarchar	3	0
134	/BEV3/CHVGRT	Totals table	10	RUNIT	Base Unit of Measure	nvarchar	3	0
TOPRetail Ledger
135	PCRRETAILA	Actual line item table	8	RUNIT	Base Unit of Measure	nvarchar	3	0
136	PCRRETAILP	Plan line items table	8	RUNIT	Base Unit of Measure	nvarchar	3	0
137	PCRRETAILT	Totals Table	10	RUNIT	Base Unit of Measure	nvarchar	3	0
TOPSets
138	T800S	FI-SL Set Table (before Release 4.0)	16	RUNIT	Base Unit of Measure	nvarchar	3	0
TOPSpecial Purpose Ledger
139	/CCIS/PBU18A	PBU18: Actual line item table	8	RUNIT	Base Unit of Measure	nvarchar	3	0
140	/CCIS/PBU18P	PBU18: Plan line item table	8	RUNIT	Base Unit of Measure	nvarchar	3	0
141	/CCIS/PBU18T	PBU18: Summary table x	10	RUNIT	Base Unit of Measure	nvarchar	3	0
142	/CCIS/PROFTAX00	Object Table Number:00	5	RUNIT	Base Unit of Measure	nvarchar	3	0
143	/CCIS/PROFTAXA	Actual Line Items Table for General Ledger	10	RUNIT	Base Unit of Measure	nvarchar	3	0
144	/CCIS/PROFTAXP	Plan Line Items Table for General Ledger	12	RUNIT	Base Unit of Measure	nvarchar	3	0
145	/CCIS/PROFTAXT	Totals Table for General Ledger	17	RUNIT	Base Unit of Measure	nvarchar	3	0
TOPTariffs, Duties and Permits
146	OIHEDA	Actual line item table, IS-OIL Excise Duty Special Ledger	8	RUNIT	Base Unit of Measure	nvarchar	3	0
147	OIHEDP	Plan line item table, IS-OIL Excise Duty Special Ledger	8	RUNIT	Base Unit of Measure	nvarchar	3	0
148	OIHEDT	Summary table, IS-OIL Excise Duty Special Ledger	10	RUNIT	Base Unit of Measure	nvarchar	3	0
149	OIHSLA	TDP (excise duty) special ledger actual line item table	8	RUNIT	Base Unit of Measure	nvarchar	3	0
150	OIHSLT	TDP (excise duty) special ledger summary table	9	RUNIT	Base Unit of Measure	nvarchar	3	0
TOPTransaction Data Pool
151	JBDVTLD_POS	Variable Transaction: Ledger Item	7	RUNIT	Base Unit of Measure	nvarchar	3	0
TOPTransfer to Financial Accounting
152	TRACTSLA	Actual Line Item Table	8	RUNIT	Base Unit of Measure	nvarchar	3	0
153	TRACTSLP	Plan Line Items Table	8	RUNIT	Base Unit of Measure	nvarchar	3	0
154	TRACTSLT	Totals Table	10	RUNIT	Base Unit of Measure	nvarchar	3	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

154 columns | ERP 6.0 | RUNIT