	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

94 columns | ERP 6.0 | KSL01

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	FAGLFLEXT_BAK	General Ledger: Totals	74	KSL01	Total of transactions of the period in group currency	decimal	23	2
2	GLT0_BAK	G/L Account Master Record Transaction Figures	48	KSL01	Total transactions in the period in group currency (curr 3)	decimal	15	2
3	ZSAWP	Plan line items table	60	KSL01	Total of transactions of the period in group currency	decimal	17	2
4	ZSAWT	Summary table	59	KSL01	Total of transactions of the period in group currency	decimal	17	2
5	ZSEMBPSP	Plan line items table	56	KSL01	Total of transactions of the period in group currency	decimal	17	2
6	ZSEMBPST	Summary table	55	KSL01	Total of transactions of the period in group currency	decimal	17	2
7	ZSPLITP	Planeinzelposten-Tabelle	60	KSL01	Summe der Bewegungen der Periode in Konzernwährung	decimal	17	2
8	ZSPLITT	Summentabelle	59	KSL01	Summe der Bewegungen der Periode in Konzernwährung	decimal	17	2
9	ZZ001P	Plan Line Items Table	67	KSL01	Total of transactions of the period in group currency	decimal	17	2
10	ZZ001T	Summary Table	66	KSL01	Total of transactions of the period in group currency	decimal	17	2
11	ZZLINEP	Plan line items table	63	KSL01	Total of transactions of the period in group currency	decimal	17	2
12	ZZLINET	Summary table	62	KSL01	Total of transactions of the period in group currency	decimal	17	2
13	ZZSL01P	Plan line items table	69	KSL01	Total of transactions of the period in group currency	decimal	17	2
14	ZZSL01T	Summary table	68	KSL01	Total of transactions of the period in group currency	decimal	17	2
15	ZZSPECP	Plan line item table	61	KSL01	Total of transactions of the period in group currency	decimal	17	2
16	ZZSPECT	Summary table	59	KSL01	Total of transactions of the period in group currency	decimal	17	2
TOPAvailability Control
17	FMAVCP	Plan line items table	62	KSL01	Total of transactions of the period in group currency	decimal	17	2
18	FMAVCT	AVC Summary Table (BCS)	61	KSL01	Total of transactions of the period in group currency	decimal	17	2
TOPBasic Functions
19	FILCP	FI-LC: Plan line items for object table	68	KSL01	Total of transactions of the period in group currency	decimal	17	2
20	FILCT	FI-LC: Global totals table with 2 object tables	68	KSL01	Total of transactions of the period in group currency	decimal	17	2
21	GGREFP	Example for Global FI-SL Line Items (Plan)	62	KSL01	Total of transactions of the period in group currency	decimal	17	2
22	GGREFT	Example for Global FI-SL Summary Table	61	KSL01	Total of transactions of the period in group currency	decimal	17	2
23	GLFUNCP	Plan Line Items Table for Cost of Sales Accounting	61	KSL01	Total of transactions of the period in group currency	decimal	17	2
24	GLFUNCT	Totals Table for Cost of Sales Accounting	60	KSL01	Total of transactions of the period in group currency	decimal	17	2
25	GLFUNCV	Rollup plan line items table with function area for IDES	61	KSL01	Total of transactions of the period in group currency	decimal	17	2
26	GLP0	Local Logical General Ledger Plan Line Items	53	KSL01	Total transactions in the period in group currency (curr 3)	decimal	15	2
27	GLPO1	Plan Line Items for Object Table	69	KSL01	Total of transactions of the period in group currency	decimal	17	2
28	GLPO2	Plan Line Items for Object Table Global	77	KSL01	Total of transactions of the period in group currency	decimal	17	2
29	GLPO3	Plan Line Items for Object Table	69	KSL01	Total of transactions of the period in group currency	decimal	17	2
30	GLREFP	Example for Local FI-SL Line Items (Plan)	60	KSL01	Total of transactions of the period in group currency	decimal	17	2
31	GLREFT	Example for Local FI-SL Summary Table	59	KSL01	Total of transactions of the period in group currency	decimal	17	2
32	GLREFV	Example for Rollup FI-SL Line Items (Plan)	61	KSL01	Total of transactions of the period in group currency	decimal	17	2
33	GLT0	G/L account master record transaction figures	48	KSL01	Total transactions in the period in group currency (curr 3)	decimal	15	2
34	GLT3	Summary Data Preparations for Consolidation	52	KSL01	Total transactions in the period in group currency (curr 3)	decimal	15	2
35	GLTO1	FI-SL Table with Objects, Structure Corresponds to GLT1	66	KSL01	Total of transactions of the period in group currency	decimal	17	2
36	GLTO2	FI-SL Table with Objects, Structure Corresponds to GLT2	74	KSL01	Total of transactions of the period in group currency	decimal	17	2
37	GLTO3	FISL Table with Objects, Amounts and Quantities in Format P9	66	KSL01	Total of transactions of the period in group currency	decimal	17	2
TOPBudgeting
38	FMBDP	FM Budget change line items table	63	KSL01	Total of transactions of the period in group currency	decimal	17	2
39	FMBDT	FM budget totals table	62	KSL01	Total of transactions of the period in group currency	decimal	17	2
40	FMRBP	Plan line items table	61	KSL01	Total of transactions of the period in group currency	decimal	17	2
41	FMRBT	Summary table	60	KSL01	Total of transactions of the period in group currency	decimal	17	2
TOPCollectionsDisbursements
42	GLISDEP	Plan Line Item Table for Insurance (DE)	73	KSL01	Total of transactions of the period in group currency	decimal	17	2
43	GLISDET	Summary Table for Insurance (DE)	72	KSL01	Total of transactions of the period in group currency	decimal	17	2
44	GRISDEP	Plan Line Item Table for Insurance (DE) - Rollup	73	KSL01	Total of transactions of the period in group currency	decimal	17	2
45	GRISDET	Summary Table for Insurance (DE) - Rollup	72	KSL01	Total of transactions of the period in group currency	decimal	17	2
TOPConsolidation
46	ECMCT	SAP Cons.: Totals Table	69	KSL01	Total of transactions of the period in group currency	decimal	17	2
TOPCost Element Accounting
47	COFIP	Single plan items for reconciliation ledger	73	KSL01	Total of transactions of the period in group currency	decimal	17	2
48	COFIT	Totals Records for Reconciliation Ledger	73	KSL01	Total of transactions of the period in group currency	decimal	17	2
TOPData Retention Tool
49	TXW_S_GLT0	Retrieve archived GLT0 data	48	KSL01	Total transactions in the period in group currency (curr 3)	decimal	15	2
TOPFinancial Services Localization
50	/CEEIS/RUP	Plan line items table	71	KSL01	Total of transactions of the period in group currency	decimal	17	2
51	/CEEIS/RUT	Totals Table	70	KSL01	Total of transactions of the period in group currency	decimal	17	2
TOPFlexible Real Estate Management
52	VIPRLEDTAGRP	Planeinzelposten-Tabelle	52	KSL01	Summe der Bewegungen der Periode in Konzernwährung	decimal	17	2
53	VIPRLEDTAGRT	Summentabelle Ledger 7A Mandate	50	KSL01	Summe der Bewegungen der Periode in Konzernwährung	decimal	17	2
TOPFund Accounting
54	FMCCAVCP	Plan line items table	59	KSL01	Total of transactions of the period in group currency	decimal	17	2
55	FMCCAVCT	Totals Table	58	KSL01	Total of transactions of the period in group currency	decimal	17	2
56	FMGLFLEXP	General Ledger: Plan Line Items	65	KSL01	Total of transactions of the period in group currency	decimal	23	2
57	FMGLFLEXT	General Ledger Public Sector: Total	72	KSL01	Total of transactions of the period in group currency	decimal	23	2
58	PSGLFLEXP	General Ledger: Plan Line Items	69	KSL01	Total of transactions of the period in group currency	decimal	23	2
59	PSGLFLEXT	General Ledger Public Sector: Total	76	KSL01	Total of transactions of the period in group currency	decimal	23	2
TOPGeneral Ledger Accounting
60	FAGLFLEXP	General Ledger: Plan Line Items	67	KSL01	Total of transactions of the period in group currency	decimal	23	2
61	FAGLFLEXT	General Ledger: Totals	74	KSL01	Total of transactions of the period in group currency	decimal	23	2
62	GLFLEXP	Flexible G/L: Plan line items	64	KSL01	Total of transactions of the period in group currency	decimal	23	2
63	GLFLEXT	Flexible G/L: Totals	70	KSL01	Total of transactions of the period in group currency	decimal	23	2
TOPGrantee Management
64	GMAVCP	Plan line items table	61	KSL01	Total of transactions of the period in group currency	decimal	17	2
65	GMAVCT	Summary table	60	KSL01	Total of transactions of the period in group currency	decimal	17	2
TOPJoint Venture und Production Sharing Accounting
66	JVGLFLEXP	General Ledger: Plan Line Items	69	KSL01	Total of transactions of the period in group currency	decimal	23	2
67	JVGLFLEXT	General Ledger: Totals	76	KSL01	Total of transactions of the period in group currency	decimal	23	2
68	JVPO1	JVA: Plan Line Items	70	KSL01	Total of transactions of the period in group currency	decimal	17	2
69	JVPSC01P	Plan line item table	72	KSL01	Total of transactions of the period in group currency	decimal	17	2
70	JVPSC01T	Summary table	71	KSL01	Total of transactions of the period in group currency	decimal	17	2
71	JVT1	JV Summary Table	52	KSL01	Total transactions in the period in group currency (curr 3)	decimal	15	2
72	JVTO1	JV Summary Table with Objects	67	KSL01	Total of transactions of the period in group currency	decimal	17	2
73	JVTO2	JV Billing FI-SL Summary Table	54	KSL01	Total of transactions of the period in group currency	decimal	17	2
TOPProfit Center Accounting
74	GLPCP	EC-PCA: Plan Line Items	65	KSL01	Total transactions for the period in pctr local currency	decimal	15	2
75	GLPCT	EC-PCA: Totals Table	66	KSL01	Total transactions for the period in pctr local currency	decimal	15	2
76	T8APP_GLPCM	EC-PCA: Plan Costs from Material Costing for Rep. Material	68	KSL01	Total transactions for the period in pctr local currency	decimal	15	2
TOPProfitability Analysis
77	GLTPC	Profit Center Accounting	50	KSL01	Total transactions in the period in group currency (curr 3)	decimal	15	2
TOPRegulatory reporting for insurance companies
78	ISSRFLDEP	Plan line items table	94	KSL01	Total of transactions of the period in group currency	decimal	17	2
79	ISSRFLDET	Summary table	93	KSL01	Total of transactions of the period in group currency	decimal	17	2
TOPRemaining Beverage - Obsolete Objects
80	/BEV3/CHFIP	Plan Line Items Table	58	KSL01	Total of transactions of the period in group currency	decimal	17	2
81	/BEV3/CHFIT	Totals table	57	KSL01	Total of transactions of the period in group currency	decimal	17	2
82	/BEV3/CHVGRP	Plan Line Items Table	60	KSL01	Total of transactions of the period in group currency	decimal	17	2
83	/BEV3/CHVGRT	Totals table	59	KSL01	Total of transactions of the period in group currency	decimal	17	2
TOPRetail Ledger
84	PCRRETAILP	Plan line items table	59	KSL01	Total of transactions of the period in group currency	decimal	17	2
85	PCRRETAILT	Totals Table	58	KSL01	Total of transactions of the period in group currency	decimal	17	2
TOPSpecial Purpose Ledger
86	/CCIS/PBU18P	PBU18: Plan line item table	73	KSL01	Total of transactions of the period in group currency	decimal	17	2
87	/CCIS/PBU18T	PBU18: Summary table x	72	KSL01	Total of transactions of the period in group currency	decimal	17	2
88	/CCIS/PROFTAXP	Plan Line Items Table for General Ledger	77	KSL01	Total of transactions of the period in group currency	decimal	23	2
89	/CCIS/PROFTAXT	Totals Table for General Ledger	84	KSL01	Total of transactions of the period in group currency	decimal	23	2
TOPTariffs, Duties and Permits
90	OIHEDP	Plan line item table, IS-OIL Excise Duty Special Ledger	74	KSL01	Total of transactions of the period in group currency	decimal	17	2
91	OIHEDT	Summary table, IS-OIL Excise Duty Special Ledger	73	KSL01	Total of transactions of the period in group currency	decimal	17	2
92	OIHSLT	TDP (excise duty) special ledger summary table	57	KSL01	Total of transactions of the period in group currency	decimal	17	2
TOPTransfer to Financial Accounting
93	TRACTSLP	Plan Line Items Table	52	KSL01	Total of transactions of the period in group currency	decimal	17	2
94	TRACTSLT	Totals Table	51	KSL01	Total of transactions of the period in group currency	decimal	17	2

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

94 columns | ERP 6.0 | KSL01