	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

113 columns | ERP 6.0 | REFDOCLN

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	GLPCA_CT	Profit Center Documents	101	REFDOCLN	Number of Line Item Within Accounting Document	nvarchar	3	0
2	GLPCA_T_CT	Profit Center Documents	117	REFDOCLN	Number of Line Item Within Accounting Document	nvarchar	3	0
3	ZSAWA	Actual line item table	38	REFDOCLN	Six-digit number of the reference posting line	nvarchar	6	0
4	ZSAWP	Plan line items table	118	REFDOCLN	Six-digit number of the reference posting line	nvarchar	6	0
5	ZSEMBPSA	Actual line item table	34	REFDOCLN	Six-digit number of the reference posting line	nvarchar	6	0
6	ZSEMBPSP	Plan line items table	114	REFDOCLN	Six-digit number of the reference posting line	nvarchar	6	0
7	ZSPLITA	Isteinzelposten-Tabelle	38	REFDOCLN	Sechsstellige Nummer der Referenz-Buchungszeile	nvarchar	6	0
8	ZSPLITP	Planeinzelposten-Tabelle	118	REFDOCLN	Sechsstellige Nummer der Referenz-Buchungszeile	nvarchar	6	0
9	ZZ001A	Actual Line Item Table	45	REFDOCLN	Six-digit number of the reference posting line	nvarchar	6	0
10	ZZ001P	Plan Line Items Table	125	REFDOCLN	Six-digit number of the reference posting line	nvarchar	6	0
11	ZZLINEA	Actual line item table	39	REFDOCLN	Six-digit number of the reference posting line	nvarchar	6	0
12	ZZLINEP	Plan line items table	103	REFDOCLN	Six-digit number of the reference posting line	nvarchar	6	0
13	ZZSL01A	Actual line item table	47	REFDOCLN	Six-digit number of the reference posting line	nvarchar	6	0
14	ZZSL01P	Plan line items table	127	REFDOCLN	Six-digit number of the reference posting line	nvarchar	6	0
15	ZZSPECA	Actual line item table	38	REFDOCLN	Number of Line Item Within Accounting Document	nvarchar	3	0
16	ZZSPECP	Plan line item table	102	REFDOCLN	Number of Line Item Within Accounting Document	nvarchar	3	0
TOPAvailability Control
17	FMAVCA	Actual line item table	37	REFDOCLN	Six-digit number of the reference posting line	nvarchar	6	0
18	FMAVCP	Plan line items table	85	REFDOCLN	Six-digit number of the reference posting line	nvarchar	6	0
TOPBasic Functions
19	FILCA	FI-LC: Actual journal entry table with 2 object tables	48	REFDOCLN	Number of Line Item Within Accounting Document	nvarchar	3	0
20	FILCP	FI-LC: Plan line items for object table	126	REFDOCLN	Number of Line Item Within Accounting Document	nvarchar	3	0
21	GGREFA	Example for Global FI-SL Line Items (Actual)	40	REFDOCLN	Six-digit number of the reference posting line	nvarchar	6	0
22	GGREFP	Example for Global FI-SL Line Items (Plan)	120	REFDOCLN	Six-digit number of the reference posting line	nvarchar	6	0
23	GLFUNCA	Actual Line Items Table for Cost of Sales Accounting	38	REFDOCLN	Reference posting line within the accounting document	nvarchar	3	0
24	GLFUNCP	Plan Line Items Table for Cost of Sales Accounting	102	REFDOCLN	Reference posting line within the accounting document	nvarchar	3	0
25	GLFUNCU	Rollup line item tables with function area for IDES	38	REFDOCLN	Reference posting line within the accounting document	nvarchar	3	0
26	GLFUNCV	Rollup plan line items table with function area for IDES	102	REFDOCLN	Reference posting line within the accounting document	nvarchar	3	0
27	GLP0	Local Logical General Ledger Plan Line Items	76	REFDOCLN	Number of Line Item Within Accounting Document	nvarchar	3	0
28	GLPO1	Plan Line Items for Object Table	128	REFDOCLN	Number of Line Item Within Accounting Document	nvarchar	3	0
29	GLPO2	Plan Line Items for Object Table Global	136	REFDOCLN	Number of Line Item Within Accounting Document	nvarchar	3	0
30	GLPO3	Plan Line Items for Object Table	128	REFDOCLN	Number of Line Item Within Accounting Document	nvarchar	3	0
31	GLREFA	Example for Local FI-SL Line Items (Actual)	38	REFDOCLN	Six-digit number of the reference posting line	nvarchar	6	0
32	GLREFP	Example for Local FI-SL Line Items (Plan)	118	REFDOCLN	Six-digit number of the reference posting line	nvarchar	6	0
33	GLREFU	Example for FI-SL Rollup Line Items (Actual)	40	REFDOCLN	Six-digit number of the reference posting line	nvarchar	6	0
34	GLREFV	Example for Rollup FI-SL Line Items (Plan)	120	REFDOCLN	Six-digit number of the reference posting line	nvarchar	6	0
35	GLSO1	FI-SL Line Item Table with Objects for GLTO1	49	REFDOCLN	Number of Line Item Within Accounting Document	nvarchar	3	0
36	GLSO2	FI-SL Table with Objects, Structure corresponds to GLS2	57	REFDOCLN	Number of Line Item Within Accounting Document	nvarchar	3	0
37	GLSO3	FI-SL LI Table with Objects for GLTO3	49	REFDOCLN	Number of Line Item Within Accounting Document	nvarchar	3	0
TOPBudgeting
38	FMBDA	Actual line item table	38	REFDOCLN	Six-digit number of the reference posting line	nvarchar	6	0
39	FMBDP	FM Budget change line items table	86	REFDOCLN	Six-digit number of the reference posting line	nvarchar	6	0
40	FMRBA	Actual line item table	36	REFDOCLN	Six-digit number of the reference posting line	nvarchar	6	0
41	FMRBP	Plan line items table	84	REFDOCLN	Six-digit number of the reference posting line	nvarchar	6	0
TOPCollectionsDisbursements
42	GLISDEA	Actual Line Item Tables for Insurance (DE)	50	REFDOCLN	Number of Line Item Within Accounting Document	nvarchar	3	0
43	GLISDEP	Plan Line Item Table for Insurance (DE)	114	REFDOCLN	Number of Line Item Within Accounting Document	nvarchar	3	0
44	GRISDEA	Actual Line Item Table for Insurance (DE) - Rollup	50	REFDOCLN	Number of Line Item Within Accounting Document	nvarchar	3	0
45	GRISDEP	Plan Line Item Table for Insurance (DE) - Rollup	114	REFDOCLN	Number of Line Item Within Accounting Document	nvarchar	3	0
TOPConsolidation
46	ECMCA	SAP Cons.: Journal Entry Table (Actual)	47	REFDOCLN	Six-figure number of line item	nvarchar	6	0
TOPCost Element Accounting
47	COFIP	Single plan items for reconciliation ledger	114	REFDOCLN	Number of Line Item Within Accounting Document	nvarchar	3	0
48	COFIS	Actual line items for reconciliation ledger	51	REFDOCLN	Number of Line Item Within Accounting Document	nvarchar	3	0
TOPFinancial Accounting
49	FBICRC001A	ICRC: Open Items GL Accounts: Documents	28	REFDOCLN	Six-digit number of the reference posting line	nvarchar	6	0
50	FBICRC001P	Not in use	43	REFDOCLN	Six-digit number of the reference posting line	nvarchar	6	0
51	FBICRC002A	ICRC: GL Accounts: Documents	28	REFDOCLN	Six-digit number of the reference posting line	nvarchar	6	0
52	FBICRC002P	Not in use	43	REFDOCLN	Six-digit number of the reference posting line	nvarchar	6	0
53	FBICRC003A	ICRC: Open Items Customers/Vendors: Documents	29	REFDOCLN	Six-digit number of the reference posting line	nvarchar	6	0
54	FBICRC003P	Not in use	44	REFDOCLN	Six-digit number of the reference posting line	nvarchar	6	0
TOPFinancial Services Localization
55	/CEEIS/RUA	Actual line item table	49	REFDOCLN	Six-digit number of the reference posting line	nvarchar	6	0
56	/CEEIS/RUP	Plan line items table	129	REFDOCLN	Six-digit number of the reference posting line	nvarchar	6	0
TOPFlexible Real Estate Management
57	VIPRLEDTAGRA	Isteinzelposten-Tabelle	28	REFDOCLN	Sechsstellige Nummer der Referenz-Buchungszeile	nvarchar	6	0
58	VIPRLEDTAGRP	Planeinzelposten-Tabelle	92	REFDOCLN	Sechsstellige Nummer der Referenz-Buchungszeile	nvarchar	6	0
TOPFund Accounting
59	FMCCAVCA	Actual line item table	34	REFDOCLN	Six-digit number of the reference posting line	nvarchar	6	0
60	FMCCAVCP	Plan line items table	82	REFDOCLN	Six-digit number of the reference posting line	nvarchar	6	0
61	FMGLFLEXP	General Ledger: Plan Line Items	119	REFDOCLN	Six-digit number of the reference posting line	nvarchar	6	0
62	PSGLFLEXP	General Ledger: Plan Line Items	123	REFDOCLN	Six-digit number of the reference posting line	nvarchar	6	0
TOPFunds Management
63	FMFG_SAV_FACTS1A	Saved FACTS1A data for docs excluded from SL Repost for 600	40	REFDOCLN	Six-digit number of the reference posting line	nvarchar	6	0
64	FMFG_SAV_FACTS2A	Saved FACTS2A data for docs excluded from SL Repost for 600	44	REFDOCLN	Six-digit number of the reference posting line	nvarchar	6	0
65	FMFG_SAV_FMUSFGA	Saved FMUSFGA data for docs excluded from SL Repost for 600	40	REFDOCLN	Six-digit number of the reference posting line	nvarchar	6	0
66	FMIA	Actual Line Item Table for Funds Management	41	REFDOCLN	Number of Line Item Within Accounting Document	nvarchar	3	0
67	FMIP	Plan Line Items Table for Funds Management	73	REFDOCLN	Number of Line Item Within Accounting Document	nvarchar	3	0
68	FMSPLITA	Actual line item table	42	REFDOCLN	Six-digit number of the reference posting line	nvarchar	6	0
69	FMSPLITP	Plan line items table	74	REFDOCLN	Six-digit number of the reference posting line	nvarchar	6	0
70	FMUSFGA	Actual line item table for US Federal Government.	40	REFDOCLN	Six-digit number of the reference posting line	nvarchar	6	0
71	FMUSFGFACTS1A	4Actual line item table	40	REFDOCLN	Six-digit number of the reference posting line	nvarchar	6	0
72	FMUSFGFACTS1P	Plan line items table	71	REFDOCLN	Six-digit number of the reference posting line	nvarchar	6	0
73	FMUSFGFACTS2A	Actual line item table	44	REFDOCLN	Six-digit number of the reference posting line	nvarchar	6	0
74	FMUSFGFACTS2P	Plan line items table	75	REFDOCLN	Six-digit number of the reference posting line	nvarchar	6	0
75	FMUSFGP	Plan line items table	71	REFDOCLN	Six-digit number of the reference posting line	nvarchar	6	0
76	PSBM_EVENT	PS Budget Monitoring Events	8	REFDOCLN	Six-digit number of the reference posting line	nvarchar	6	0
TOPGeneral Ledger Accounting
77	FAGLFLEXP	General Ledger: Plan Line Items	121	REFDOCLN	Six-digit number of the reference posting line	nvarchar	6	0
78	GLFLEXA	Flexible general ledger: Actual line items	42	REFDOCLN	Six-digit number of the reference posting line	nvarchar	6	0
79	GLFLEXP	Flexible G/L: Plan line items	120	REFDOCLN	Six-digit number of the reference posting line	nvarchar	6	0
TOPGrantee Management
80	GMAVCA	Actual line item table	37	REFDOCLN	Six-digit number of the reference posting line	nvarchar	6	0
81	GMAVCP	Plan line items table	101	REFDOCLN	Six-digit number of the reference posting line	nvarchar	6	0
82	GMIA	Actual Line Item Table	35	REFDOCLN	Six-digit number of the reference posting line	nvarchar	6	0
83	GMIP	Plan line items table	83	REFDOCLN	Six-digit number of the reference posting line	nvarchar	6	0
TOPJoint Venture und Production Sharing Accounting
84	JVGLFLEXP	General Ledger: Plan Line Items	123	REFDOCLN	Six-digit number of the reference posting line	nvarchar	6	0
85	JVPO1	JVA: Plan Line Items	113	REFDOCLN	Line Item in Joint Venture Reference Doc	nvarchar	5	0
86	JVPSC01A	Actual line item table	48	REFDOCLN	Six-figure number of line item	nvarchar	6	0
87	JVPSC01P	Plan line item table	112	REFDOCLN	Six-figure number of line item	nvarchar	6	0
88	JVSO1	JV LI Table with Objects for JVTO1	49	REFDOCLN	Line Item in Joint Venture Reference Doc	nvarchar	5	0
89	JVSO2	JV Billing FI-SL Line Item	33	REFDOCLN	Line Item in Joint Venture Reference Doc	nvarchar	5	0
90	T8J_JVEC	JVA equity change document relationship	14	REFDOCLN	Line Item in Joint Venture Reference Doc	nvarchar	5	0
TOPLocalization
91	J_3RFTAXRA	Tax Accounting: Actual line item table	49	REFDOCLN	Six-figure number of line item	nvarchar	6	0
92	J_3RFTAXRP	Tax Accounting: Plan line item table	97	REFDOCLN	Six-figure number of line item	nvarchar	6	0
93	J_3RFTAXRVA	Tax Accounting: Actual line item table	49	REFDOCLN	Six-figure number of line item	nvarchar	6	0
94	J_3RFTAXRVP	Tax Accounting: Plan line item table	97	REFDOCLN	Six-figure number of line item	nvarchar	6	0
TOPProfit Center Accounting
95	GLPCA	EC-PCA: Actual Line Items	45	REFDOCLN	Number of Line Item Within Accounting Document	nvarchar	3	0
96	GLPCP	EC-PCA: Plan Line Items	106	REFDOCLN	Number of Line Item Within Accounting Document	nvarchar	3	0
TOPRegulatory reporting for insurance companies
97	ISSRFLDEA	Actual line item table	72	REFDOCLN	Six-digit number of the reference posting line	nvarchar	6	0
98	ISSRFLDEP	Plan line items table	152	REFDOCLN	Six-digit number of the reference posting line	nvarchar	6	0
TOPRemaining Beverage - Obsolete Objects
99	/BEV3/CHFIA	Actual line item table	36	REFDOCLN	Six-figure number of line item	nvarchar	6	0
100	/BEV3/CHFIP	Plan Line Items Table	116	REFDOCLN	Six-figure number of line item	nvarchar	6	0
101	/BEV3/CHVGRA	Actual line item table	38	REFDOCLN	Six-figure number of line item	nvarchar	6	0
102	/BEV3/CHVGRP	Plan Line Items Table	118	REFDOCLN	Six-figure number of line item	nvarchar	6	0
TOPRetail Ledger
103	PCRRETAILA	Actual line item table	37	REFDOCLN	Six-digit number of the reference posting line	nvarchar	6	0
104	PCRRETAILP	Plan line items table	117	REFDOCLN	Six-digit number of the reference posting line	nvarchar	6	0
TOPRevenues and Earnings
105	AD01DLI	Dynamic items (DI)	58	REFDOCLN	Six-digit number of the reference posting line	nvarchar	6	0
TOPSpecial Purpose Ledger
106	/CCIS/PBU18A	PBU18: Actual line item table	51	REFDOCLN	Six-digit number of the reference posting line	nvarchar	6	0
107	/CCIS/PBU18P	PBU18: Plan line item table	131	REFDOCLN	Six-digit number of the reference posting line	nvarchar	6	0
108	/CCIS/PROFTAXP	Plan Line Items Table for General Ledger	131	REFDOCLN	Six-digit number of the reference posting line	nvarchar	6	0
TOPTariffs, Duties and Permits
109	OIHEDA	Actual line item table, IS-OIL Excise Duty Special Ledger	52	REFDOCLN	Six-digit number of the reference posting line	nvarchar	6	0
110	OIHEDP	Plan line item table, IS-OIL Excise Duty Special Ledger	132	REFDOCLN	Six-digit number of the reference posting line	nvarchar	6	0
111	OIHSLA	TDP (excise duty) special ledger actual line item table	57	REFDOCLN	Number of Line Item Within Accounting Document	nvarchar	3	0
TOPTransfer to Financial Accounting
112	TRACTSLA	Actual Line Item Table	30	REFDOCLN	Six-digit number of the reference posting line	nvarchar	6	0
113	TRACTSLP	Plan Line Items Table	110	REFDOCLN	Six-digit number of the reference posting line	nvarchar	6	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

113 columns | ERP 6.0 | REFDOCLN