	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

86 columns | ERP 6.0 | MSL12

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	FAGLFLEXT_BAK	General Ledger: Totals	119	MSL12	Total of the transactions of period in units of measure	decimal	23	3
2	ZSAWP	Plan line items table	88	MSL12	Total of the transactions of period in units of measure	decimal	15	3
3	ZSAWT	Summary table	87	MSL12	Total of the transactions of period in units of measure	decimal	15	3
4	ZSEMBPSP	Plan line items table	84	MSL12	Total of the transactions of period in units of measure	decimal	15	3
5	ZSEMBPST	Summary table	83	MSL12	Total of the transactions of period in units of measure	decimal	15	3
6	ZSPLITP	Planeinzelposten-Tabelle	88	MSL12	Summe der Bewegungen der Periode in Mengeneinheiten	decimal	15	3
7	ZSPLITT	Summentabelle	87	MSL12	Summe der Bewegungen der Periode in Mengeneinheiten	decimal	15	3
8	ZZ001P	Plan Line Items Table	95	MSL12	Total of the transactions of period in units of measure	decimal	15	3
9	ZZ001T	Summary Table	94	MSL12	Total of the transactions of period in units of measure	decimal	15	3
10	ZZLINEP	Plan line items table	91	MSL12	Total of the transactions of period in units of measure	decimal	15	3
11	ZZLINET	Summary table	90	MSL12	Total of the transactions of period in units of measure	decimal	15	3
12	ZZSL01P	Plan line items table	97	MSL12	Total of the transactions of period in units of measure	decimal	15	3
13	ZZSL01T	Summary table	96	MSL12	Total of the transactions of period in units of measure	decimal	15	3
14	ZZSPECP	Plan line item table	89	MSL12	Total of the transactions of period in units of measure	decimal	15	3
15	ZZSPECT	Summary table	87	MSL12	Total of the transactions of period in units of measure	decimal	15	3
TOPBasic Functions
16	FILCP	FI-LC: Plan line items for object table	96	MSL12	Total of the transactions of period in units of measure	decimal	15	3
17	FILCT	FI-LC: Global totals table with 2 object tables	96	MSL12	Total of the transactions of period in units of measure	decimal	15	3
18	GGREFP	Example for Global FI-SL Line Items (Plan)	90	MSL12	Total of the transactions of period in units of measure	decimal	15	3
19	GGREFT	Example for Global FI-SL Summary Table	89	MSL12	Total of the transactions of period in units of measure	decimal	15	3
20	GLFUNCP	Plan Line Items Table for Cost of Sales Accounting	89	MSL12	Total of the transactions of period in units of measure	decimal	15	3
21	GLFUNCT	Totals Table for Cost of Sales Accounting	88	MSL12	Total of the transactions of period in units of measure	decimal	15	3
22	GLFUNCV	Rollup plan line items table with function area for IDES	89	MSL12	Total of the transactions of period in units of measure	decimal	15	3
23	GLPO1	Plan Line Items for Object Table	97	MSL12	Total of the transactions of period in units of measure	decimal	15	3
24	GLPO2	Plan Line Items for Object Table Global	105	MSL12	Total of the transactions of period in units of measure	decimal	15	3
25	GLPO3	Plan Line Items for Object Table	97	MSL12	Total of the transactions of period in units of measure	decimal	17	3
26	GLREFP	Example for Local FI-SL Line Items (Plan)	88	MSL12	Total of the transactions of period in units of measure	decimal	15	3
27	GLREFT	Example for Local FI-SL Summary Table	87	MSL12	Total of the transactions of period in units of measure	decimal	15	3
28	GLREFV	Example for Rollup FI-SL Line Items (Plan)	89	MSL12	Total of the transactions of period in units of measure	decimal	15	3
29	GLTO1	FI-SL Table with Objects, Structure Corresponds to GLT1	94	MSL12	Total of the transactions of period in units of measure	decimal	15	3
30	GLTO2	FI-SL Table with Objects, Structure Corresponds to GLT2	102	MSL12	Total of the transactions of period in units of measure	decimal	15	3
31	GLTO3	FISL Table with Objects, Amounts and Quantities in Format P9	94	MSL12	Total of the transactions of period in units of measure	decimal	17	3
TOPCollectionsDisbursements
32	GLISDEP	Plan Line Item Table for Insurance (DE)	101	MSL12	Total of the transactions of period in units of measure	decimal	15	3
33	GLISDET	Summary Table for Insurance (DE)	100	MSL12	Total of the transactions of period in units of measure	decimal	15	3
34	GRISDEP	Plan Line Item Table for Insurance (DE) - Rollup	101	MSL12	Total of the transactions of period in units of measure	decimal	15	3
35	GRISDET	Summary Table for Insurance (DE) - Rollup	100	MSL12	Total of the transactions of period in units of measure	decimal	15	3
TOPConsolidation
36	ECMCT	SAP Cons.: Totals Table	97	MSL12	Total of the transactions of period in units of measure	decimal	17	3
TOPCost Element Accounting
37	COFIP	Single plan items for reconciliation ledger	101	MSL12	Total of the transactions of period in units of measure	decimal	15	3
38	COFIT	Totals Records for Reconciliation Ledger	101	MSL12	Total of the transactions of period in units of measure	decimal	15	3
TOPFinancial Services Localization
39	/CEEIS/RUP	Plan line items table	99	MSL12	Total of the transactions of period in units of measure	decimal	15	3
40	/CEEIS/RUT	Totals Table	98	MSL12	Total of the transactions of period in units of measure	decimal	15	3
TOPFlexible Real Estate Management
41	VIPRLEDTAGRP	Planeinzelposten-Tabelle	80	MSL12	Summe der Bewegungen der Periode in Mengeneinheiten	decimal	17	3
42	VIPRLEDTAGRT	Summentabelle Ledger 7A Mandate	78	MSL12	Summe der Bewegungen der Periode in Mengeneinheiten	decimal	17	3
TOPFund Accounting
43	FMGLFLEXP	General Ledger: Plan Line Items	110	MSL12	Total of the transactions of period in units of measure	decimal	23	3
44	FMGLFLEXT	General Ledger Public Sector: Total	117	MSL12	Total of the transactions of period in units of measure	decimal	23	3
45	PSGLFLEXP	General Ledger: Plan Line Items	114	MSL12	Total of the transactions of period in units of measure	decimal	23	3
46	PSGLFLEXT	General Ledger Public Sector: Total	121	MSL12	Total of the transactions of period in units of measure	decimal	23	3
TOPGeneral Ledger Accounting
47	FAGLFLEXP	General Ledger: Plan Line Items	112	MSL12	Total of the transactions of period in units of measure	decimal	23	3
48	FAGLFLEXT	General Ledger: Totals	119	MSL12	Total of the transactions of period in units of measure	decimal	23	3
49	GLFLEXP	Flexible G/L: Plan line items	109	MSL12	Total of the transactions of period in units of measure	decimal	23	3
50	GLFLEXT	Flexible G/L: Totals	115	MSL12	Total of the transactions of period in units of measure	decimal	23	3
TOPGrantee Management
51	GMAVCP	Plan line items table	89	MSL12	Total of the transactions of period in units of measure	decimal	15	3
52	GMAVCT	Summary table	88	MSL12	Total of the transactions of period in units of measure	decimal	15	3
53	GMIP	Plan line items table	71	MSL12	Total of the transactions of period in units of measure	decimal	15	3
54	GMIT	Summary table	70	MSL12	Total of the transactions of period in units of measure	decimal	15	3
TOPJoint Venture und Production Sharing Accounting
55	JVGLFLEXP	General Ledger: Plan Line Items	114	MSL12	Total of the transactions of period in units of measure	decimal	23	3
56	JVGLFLEXT	General Ledger: Totals	121	MSL12	Total of the transactions of period in units of measure	decimal	23	3
57	JVPO1	JVA: Plan Line Items	98	MSL12	Total of the transactions of period in units of measure	decimal	15	3
58	JVPSC01P	Plan line item table	100	MSL12	Total of the transactions of period in units of measure	decimal	15	3
59	JVPSC01T	Summary table	99	MSL12	Total of the transactions of period in units of measure	decimal	15	3
60	JVT1	JV Summary Table	80	MSL12	Total of the transactions of period in units of measure	decimal	15	3
61	JVTO1	JV Summary Table with Objects	95	MSL12	Total of the transactions of period in units of measure	decimal	15	3
TOPLocalization
62	J_3RFTAXRP	Tax Accounting: Plan line item table	85	MSL12	Total of the transactions of period in units of measure	decimal	15	3
63	J_3RFTAXRT	Tax Accounting: Summary table	83	MSL12	Total of the transactions of period in units of measure	decimal	15	3
64	J_3RFTAXRVP	Tax Accounting: Plan line item table	85	MSL12	Total of the transactions of period in units of measure	decimal	15	3
65	J_3RFTAXRVT	Tax Accounting: Summary table	83	MSL12	Total of the transactions of period in units of measure	decimal	15	3
TOPProfit Center Accounting
66	GLPCP	EC-PCA: Plan Line Items	93	MSL12	Total of the transactions of period in units of measure	decimal	15	3
67	GLPCT	EC-PCA: Totals Table	94	MSL12	Total of the transactions of period in units of measure	decimal	15	3
68	T8APP_GLPCM	EC-PCA: Plan Costs from Material Costing for Rep. Material	96	MSL12	Total of the transactions of period in units of measure	decimal	15	3
TOPProfitability Analysis
69	GLTPC	Profit Center Accounting	78	MSL12	Total of the transactions of period in units of measure	decimal	15	3
TOPRegulatory reporting for insurance companies
70	ISSRFLDEP	Plan line items table	122	MSL12	Total of the transactions of period in units of measure	decimal	17	3
71	ISSRFLDET	Summary table	121	MSL12	Total of the transactions of period in units of measure	decimal	17	3
TOPRemaining Beverage - Obsolete Objects
72	/BEV3/CHFIP	Plan Line Items Table	86	MSL12	Total of the transactions of period in units of measure	decimal	15	3
73	/BEV3/CHFIT	Totals table	85	MSL12	Total of the transactions of period in units of measure	decimal	15	3
74	/BEV3/CHVGRP	Plan Line Items Table	88	MSL12	Total of the transactions of period in units of measure	decimal	15	3
75	/BEV3/CHVGRT	Totals table	87	MSL12	Total of the transactions of period in units of measure	decimal	15	3
TOPRetail Ledger
76	PCRRETAILP	Plan line items table	87	MSL12	Total of the transactions of period in units of measure	decimal	15	3
77	PCRRETAILT	Totals Table	86	MSL12	Total of the transactions of period in units of measure	decimal	15	3
TOPSpecial Purpose Ledger
78	/CCIS/PBU18P	PBU18: Plan line item table	101	MSL12	Total of the transactions of period in units of measure	decimal	15	3
79	/CCIS/PBU18T	PBU18: Summary table x	100	MSL12	Total of the transactions of period in units of measure	decimal	15	3
80	/CCIS/PROFTAXP	Plan Line Items Table for General Ledger	122	MSL12	Total of the transactions of period in units of measure	decimal	23	3
81	/CCIS/PROFTAXT	Totals Table for General Ledger	129	MSL12	Total of the transactions of period in units of measure	decimal	23	3
TOPTariffs, Duties and Permits
82	OIHEDP	Plan line item table, IS-OIL Excise Duty Special Ledger	102	MSL12	Total of the transactions of period in units of measure	decimal	15	3
83	OIHEDT	Summary table, IS-OIL Excise Duty Special Ledger	101	MSL12	Total of the transactions of period in units of measure	decimal	15	3
84	OIHSLT	TDP (excise duty) special ledger summary table	85	MSL12	Total of the transactions of period in units of measure	decimal	15	3
TOPTransfer to Financial Accounting
85	TRACTSLP	Plan Line Items Table	80	MSL12	Total of the transactions of period in units of measure	decimal	15	3
86	TRACTSLT	Totals Table	79	MSL12	Total of the transactions of period in units of measure	decimal	15	3

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

86 columns | ERP 6.0 | MSL12