	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

112 columns | ERP 6.0 | HSL09

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

112 columns | ERP 6.0 | HSL09