	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

75 columns | ERP 6.0 | TSL

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	FAGLFLEXC	EMU: Sum of Open Items of Table FAGLFLEXT	37	TSL	Balance carried forward in transaction currency	decimal	23	2
2	FAGLFLEXD	EMU: Documentation of changes in Txn.Figs of Tabl FAGLFLEXT	39	TSL	Balance carried forward in transaction currency	decimal	23	2
3	FAGLFLEXT_DIF	Delta Table: G/L Totals	39	TSL	Value in Transaction Currency	decimal	23	2
4	GLT0_DIF	Delta Table: G/L Account Master Transaction Figures	12	TSL	Total transactions of the period in transaction currency	decimal	15	2
5	PYD_D_AL	Payroll Data Source Framework: Action Log	4	TSL	UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)	decimal	21	7
6	PYD_D_ALI	Payroll Data Source Framework: Action Log Item	4	TSL	UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)	decimal	21	7
7	PYD_D_DAE_TRACE	PYDS: Scheduling Use Case Processing Trace	2	TSL	UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)	decimal	21	7
8	T8PSA_RUII_HIST	PSA Rollup II History (for produc split by volume)	17	TSL	Value in Transaction Currency	decimal	17	2
9	ZSAWA	Actual line item table	25	TSL	Value in Transaction Currency	decimal	17	2
10	ZSEMBPSA	Actual line item table	21	TSL	Value in Transaction Currency	decimal	17	2
11	ZSPLITA	Isteinzelposten-Tabelle	25	TSL	Wert in Transaktionswährung	decimal	17	2
12	ZZ001A	Actual Line Item Table	32	TSL	Value in Transaction Currency	decimal	17	2
13	ZZLINEA	Actual line item table	28	TSL	Value in Transaction Currency	decimal	17	2
14	ZZSL01A	Actual line item table	34	TSL	Value in Transaction Currency	decimal	17	2
15	ZZSPECA	Actual line item table	26	TSL	Value in Transaction Currency	decimal	17	2
TOPAvailability Control
16	FMAVCA	Actual line item table	27	TSL	Value in Transaction Currency	decimal	17	2
TOPBasic Functions
17	FILCA	FI-LC: Actual journal entry table with 2 object tables	34	TSL	Value in Transaction Currency	decimal	17	2
18	GGREFA	Example for Global FI-SL Line Items (Actual)	27	TSL	Value in Transaction Currency	decimal	17	2
19	GLFUNCA	Actual Line Items Table for Cost of Sales Accounting	26	TSL	Value in Transaction Currency	decimal	17	2
20	GLFUNCU	Rollup line item tables with function area for IDES	26	TSL	Value in Transaction Currency	decimal	17	2
21	GLREFA	Example for Local FI-SL Line Items (Actual)	25	TSL	Value in Transaction Currency	decimal	17	2
22	GLREFU	Example for FI-SL Rollup Line Items (Actual)	26	TSL	Value in Transaction Currency	decimal	17	2
23	GLSO1	FI-SL Line Item Table with Objects for GLTO1	34	TSL	Value in Transaction Currency	decimal	17	2
24	GLSO2	FI-SL Table with Objects, Structure corresponds to GLS2	42	TSL	Value in Transaction Currency	decimal	17	2
25	GLSO3	FI-SL LI Table with Objects for GLTO3	34	TSL	Value in Transaction Currency	decimal	17	2
TOPBudgeting
26	FMBDA	Actual line item table	28	TSL	Value in Transaction Currency	decimal	17	2
27	FMRBA	Actual line item table	26	TSL	Value in Transaction Currency	decimal	17	2
TOPCollectionsDisbursements
28	GLISDEA	Actual Line Item Tables for Insurance (DE)	38	TSL	Value in Transaction Currency	decimal	17	2
29	GRISDEA	Actual Line Item Table for Insurance (DE) - Rollup	38	TSL	Value in Transaction Currency	decimal	17	2
TOPConsolidation
30	ECMCA	SAP Cons.: Journal Entry Table (Actual)	35	TSL	Value in Transaction Currency	decimal	17	2
TOPCost Element Accounting
31	COFIS	Actual line items for reconciliation ledger	38	TSL	Value in Controlling Area Currency	decimal	17	2
TOPData Retention Tool
32	TXW_S_COFI	Retrieve COFIS from archive	20	TSL	Amount in transaction currency	nvarchar	19	0
TOPData Staging
33	RSREQDPTID	Note TID for Request and Data Package	3	TSL	UTC time stamp in long form (YYYYMMDDhhmmss,mmmuuun)	decimal	21	7
TOPFinancial Accounting
34	FBICRC001A	ICRC: Open Items GL Accounts: Documents	20	TSL	Value in Transaction Currency	decimal	17	2
35	FBICRC002A	ICRC: GL Accounts: Documents	20	TSL	Value in Transaction Currency	decimal	17	2
36	FBICRC003A	ICRC: Open Items Customers/Vendors: Documents	21	TSL	Value in Transaction Currency	decimal	17	2
TOPFinancial Services Localization
37	/CEEIS/RUA	Actual line item table	36	TSL	Value in Transaction Currency	decimal	17	2
TOPFlexible Real Estate Management
38	VIPRLEDTAGRA	Isteinzelposten-Tabelle	17	TSL	Wert in Transaktionswährung	decimal	17	2
TOPFund Accounting
39	FMCCAVCA	Actual line item table	24	TSL	Value in Transaction Currency	decimal	17	2
40	FMCCAVCRESERVE	CCAVC aux table for reserved items	24	TSL	Value in Transaction Currency	decimal	23	2
41	FMGLFLEXA	General Ledger: Actual Line Items	28	TSL	Value in Transaction Currency	decimal	23	2
42	PSGLFLEXA	General Ledger: Actual Line Items	32	TSL	Value in Transaction Currency	decimal	23	2
TOPFunds Management
43	FMFG_SAV_FACTS1A	Saved FACTS1A data for docs excluded from SL Repost for 600	30	TSL	Value in Transaction Currency	decimal	17	2
44	FMFG_SAV_FACTS2A	Saved FACTS2A data for docs excluded from SL Repost for 600	34	TSL	Value in Transaction Currency	decimal	17	2
45	FMFG_SAV_FMUSFGA	Saved FMUSFGA data for docs excluded from SL Repost for 600	30	TSL	Value in Transaction Currency	decimal	17	2
46	FMIA	Actual Line Item Table for Funds Management	31	TSL	Value in Transaction Currency	decimal	17	2
47	FMSPLITA	Actual line item table	32	TSL	Value in Transaction Currency	decimal	17	2
48	FMUSFGA	Actual line item table for US Federal Government.	30	TSL	Value in Transaction Currency	decimal	17	2
49	FMUSFGFACTS1A	4Actual line item table	30	TSL	Value in Transaction Currency	decimal	17	2
50	FMUSFGFACTS2A	Actual line item table	34	TSL	Value in Transaction Currency	decimal	17	2
TOPGeneral Ledger Accounting
51	FAGLFLEXA	General Ledger: Actual Line Items	30	TSL	Value in Transaction Currency	decimal	23	2
52	FAGL_RSNAPSHOT	Reorganization: Snapshot	15	TSL	Value in Transaction Currency	decimal	23	2
53	GLFLEXA	Flexible general ledger: Actual line items	29	TSL	Value in Transaction Currency	decimal	23	2
TOPGrantee Management
54	GMAVCA	Actual line item table	26	TSL	Value in Transaction Currency	decimal	17	2
55	GMIA	Actual Line Item Table	25	TSL	Value in Transaction Currency	decimal	17	2
TOPJoint Venture und Production Sharing Accounting
56	JVGLFLEXA	General Ledger: Actual Line Items	32	TSL	Value in Transaction Currency	decimal	23	2
57	JVPSC01A	Actual line item table	37	TSL	Value in Transaction Currency	decimal	17	2
58	JVSO1	JV LI Table with Objects for JVTO1	35	TSL	Value in Transaction Currency	decimal	17	2
59	JVSO2	JV Billing FI-SL Line Item	21	TSL	Value in Transaction Currency	decimal	17	2
60	T8PSA_COST_ADJ	PSA Cost Adjustment	24	TSL	Value in Transaction Currency	decimal	17	2
61	T8PSA_PREPOST	Preliminary Posting	24	TSL	Value in Transaction Currency	decimal	17	2
TOPLocalization
62	J_3RFTAXRA	Tax Accounting: Actual line item table	39	TSL	Value in Transaction Currency	decimal	17	2
63	J_3RFTAXRVA	Tax Accounting: Actual line item table	39	TSL	Value in Transaction Currency	decimal	17	2
TOPProfit Center Accounting
64	GLPCA	EC-PCA: Actual Line Items	30	TSL	Amount in transaction currency	decimal	15	2
TOPRegulatory reporting for insurance companies
65	ISSRFLDEA	Actual line item table	59	TSL	Value in Transaction Currency	decimal	17	2
66	ISSRPREFLOW	ISSR: Basistabelle/Bewegungstabelle	18	TSL	Bestandsverändernder Betrag in Transaktionswährung	decimal	17	2
TOPRemaining Beverage - Obsolete Objects
67	/BEV3/CHFIA	Actual line item table	23	TSL	Value in Transaction Currency	decimal	17	2
68	/BEV3/CHVGRA	Actual line item table	25	TSL	Value in Transaction Currency	decimal	17	2
TOPRetail Ledger
69	PCRRETAILA	Actual line item table	24	TSL	Value in Transaction Currency	decimal	17	2
TOPSpecial Purpose Ledger
70	/CCIS/PBU18A	PBU18: Actual line item table	38	TSL	Value in Transaction Currency	decimal	17	2
71	/CCIS/PROFTAXA	Actual Line Items Table for General Ledger	40	TSL	Value in Transaction Currency	decimal	23	2
TOPTariffs, Duties and Permits
72	OIHEDA	Actual line item table, IS-OIL Excise Duty Special Ledger	39	TSL	Value in Transaction Currency	decimal	17	2
73	OIHSLA	TDP (excise duty) special ledger actual line item table	44	TSL	Value in Transaction Currency	decimal	17	2
TOPTransfer to Financial Accounting
74	TRACTSLA	Actual Line Item Table	17	TSL	Value in Transaction Currency	decimal	17	2
TOPWeb Service and SOAP - ABAP
75	SRT_TRACEKEYS	Trace Keys	4	TSL	UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)	decimal	21	7

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

75 columns | ERP 6.0 | TSL