	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

121 columns | ERP 6.0 | REFDOCNR

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

121 columns | ERP 6.0 | REFDOCNR