	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

57 columns | ERP 6.0 | CSPRED

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	GLT0_BAK	G/L Account Master Record Transaction Figures	46	CSPRED	Distribution key for currency amounts	nvarchar	4	0
2	ZSAWT	Summary table	110	CSPRED	Distribution key for currency amounts	nvarchar	4	0
3	ZSEMBPST	Summary table	106	CSPRED	Distribution key for currency amounts	nvarchar	4	0
4	ZSPLITT	Summentabelle	110	CSPRED	Verteilungsschlüssel für Währungsbeträge	nvarchar	4	0
5	ZZ001T	Summary Table	117	CSPRED	Distribution key for currency amounts	nvarchar	4	0
6	ZZLINET	Summary table	95	CSPRED	Distribution key for currency amounts	nvarchar	4	0
7	ZZSL01T	Summary table	119	CSPRED	Distribution key for currency amounts	nvarchar	4	0
8	ZZSPECT	Summary table	92	CSPRED	Distribution key for currency amounts	nvarchar	4	0
TOPAvailability Control
9	FMAVCT	AVC Summary Table (BCS)	77	CSPRED	Distribution key for currency amounts	nvarchar	4	0
TOPBasic Functions
10	FILCT	FI-LC: Global totals table with 2 object tables	119	CSPRED	Distribution key for currency amounts	nvarchar	4	0
11	GGREFT	Example for Global FI-SL Summary Table	112	CSPRED	Distribution key for currency amounts	nvarchar	4	0
12	GLFUNCT	Totals Table for Cost of Sales Accounting	93	CSPRED	Distribution key for currency amounts	nvarchar	4	0
13	GLREFT	Example for Local FI-SL Summary Table	110	CSPRED	Distribution key for currency amounts	nvarchar	4	0
14	GLT0	G/L account master record transaction figures	46	CSPRED	Distribution key for currency amounts	nvarchar	4	0
15	GLT3	Summary Data Preparations for Consolidation	68	CSPRED	Distribution key for currency amounts	nvarchar	4	0
16	GLTO1	FI-SL Table with Objects, Structure Corresponds to GLT1	117	CSPRED	Distribution key for currency amounts	nvarchar	4	0
17	GLTO2	FI-SL Table with Objects, Structure Corresponds to GLT2	125	CSPRED	Distribution key for currency amounts	nvarchar	4	0
18	GLTO3	FISL Table with Objects, Amounts and Quantities in Format P9	117	CSPRED	Distribution key for currency amounts	nvarchar	4	0
19	T820	Planning Parameters	9	CSPRED	Distribution key for currency amounts	nvarchar	4	0
TOPBudgeting
20	FMBDT	FM budget totals table	78	CSPRED	Distribution key for currency amounts	nvarchar	4	0
21	FMRBT	Summary table	76	CSPRED	Distribution key for currency amounts	nvarchar	4	0
TOPCollectionsDisbursements
22	GLISDET	Summary Table for Insurance (DE)	105	CSPRED	Distribution key for currency amounts	nvarchar	4	0
23	GRISDET	Summary Table for Insurance (DE) - Rollup	105	CSPRED	Distribution key for currency amounts	nvarchar	4	0
TOPConsolidation
24	ECMCT	SAP Cons.: Totals Table	102	CSPRED	Distribution key for currency amounts	nvarchar	4	0
TOPCost Center Accounting
25	TKA51	CO Planner Profile: Basic Configurations	5	CSPRED	Distribution key for currency amounts	nvarchar	4	0
TOPCost Element Accounting
26	COFIT	Totals Records for Reconciliation Ledger	106	CSPRED	Distribution key for currency amounts	nvarchar	4	0
TOPData Retention Tool
27	TXW_S_GLT0	Retrieve archived GLT0 data	46	CSPRED	Distribution key for currency amounts	nvarchar	4	0
TOPFinancial Accounting
28	FBICRC001T	ICRC: Open Items GL Accounts: Totals	36	CSPRED	Distribution key for currency amounts	nvarchar	4	0
29	FBICRC002T	ICRC: GL Accounts: Totals	36	CSPRED	Distribution key for currency amounts	nvarchar	4	0
30	FBICRC003T	ICRC: Open Items Customers/Vendors: Totals	37	CSPRED	Distribution key for currency amounts	nvarchar	4	0
TOPFinancial Services Localization
31	/CEEIS/RUT	Totals Table	121	CSPRED	Distribution key for currency amounts	nvarchar	4	0
TOPFlexible Real Estate Management
32	VIPRLEDTAGRT	Summentabelle Ledger 7A Mandate	83	CSPRED	Verteilungsschlüssel für Währungsbeträge	nvarchar	4	0
TOPFund Accounting
33	FMCCAVCT	Totals Table	74	CSPRED	Distribution key for currency amounts	nvarchar	4	0
TOPFunds Management
34	FMIT	Totals Table for Funds Management	64	CSPRED	Distribution key for currency amounts	nvarchar	4	0
35	FMSPLITT	Summary table	67	CSPRED	Distribution key for currency amounts	nvarchar	4	0
36	FMUSFGFACTS1T	Summary table	63	CSPRED	Distribution key for currency amounts	nvarchar	4	0
37	FMUSFGFACTS2T	Summary table	67	CSPRED	Distribution key for currency amounts	nvarchar	4	0
38	FMUSFGT	Summary table for US Federal Government	63	CSPRED	Distribution key for currency amounts	nvarchar	4	0
TOPGeneral Ledger Accounting
39	GLFLEXT	Flexible G/L: Totals	120	CSPRED	Distribution key for currency amounts	nvarchar	4	0
TOPGrantee Management
40	GMAVCT	Summary table	93	CSPRED	Distribution key for currency amounts	nvarchar	4	0
41	GMIT	Summary table	75	CSPRED	Distribution key for currency amounts	nvarchar	4	0
TOPJoint Venture und Production Sharing Accounting
42	JVPSC01T	Summary table	104	CSPRED	Distribution key for currency amounts	nvarchar	4	0
43	JVT1	JV Summary Table	85	CSPRED	Distribution key for currency amounts	nvarchar	4	0
44	JVTO1	JV Summary Table with Objects	100	CSPRED	Distribution key for currency amounts	nvarchar	4	0
45	JVTO2	JV Billing FI-SL Summary Table	70	CSPRED	Distribution key for currency amounts	nvarchar	4	0
TOPLocalization
46	J_3RFTAXRT	Tax Accounting: Summary table	88	CSPRED	Distribution key for currency amounts	nvarchar	4	0
47	J_3RFTAXRVT	Tax Accounting: Summary table	88	CSPRED	Distribution key for currency amounts	nvarchar	4	0
TOPProfit Center Accounting
48	GLPCT	EC-PCA: Totals Table	99	CSPRED	Distribution key for currency amounts	nvarchar	4	0
TOPProfitability Analysis
49	GLTPC	Profit Center Accounting	83	CSPRED	Distribution key for currency amounts	nvarchar	4	0
TOPRegulatory reporting for insurance companies
50	ISSRFLDET	Summary table	144	CSPRED	Distribution key for currency amounts	nvarchar	4	0
TOPRemaining Beverage - Obsolete Objects
51	/BEV3/CHFIT	Totals table	108	CSPRED	Distribution key for currency amounts	nvarchar	4	0
52	/BEV3/CHVGRT	Totals table	110	CSPRED	Distribution key for currency amounts	nvarchar	4	0
TOPRetail Ledger
53	PCRRETAILT	Totals Table	109	CSPRED	Distribution key for currency amounts	nvarchar	4	0
TOPSpecial Purpose Ledger
54	/CCIS/PBU18T	PBU18: Summary table x	123	CSPRED	Distribution key for currency amounts	nvarchar	4	0
TOPTariffs, Duties and Permits
55	OIHEDT	Summary table, IS-OIL Excise Duty Special Ledger	124	CSPRED	Distribution key for currency amounts	nvarchar	4	0
56	OIHSLT	TDP (excise duty) special ledger summary table	91	CSPRED	Distribution key for currency amounts	nvarchar	4	0
TOPTransfer to Financial Accounting
57	TRACTSLT	Totals Table	102	CSPRED	Distribution key for currency amounts	nvarchar	4	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

57 columns | ERP 6.0 | CSPRED