	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	/ISDFPS/CHVW_E	34	External Batch Where-Used List
7	FIQAC_PART	8	Reporting Parameters Text for Company Code ( Qatar)
8	/1RA/0SD010MI	170	Items for Class SD01 - Raw Data
9	BSEG	345	Accounting Document Segment
10	FMARCPAR	4	Parallelization of FMARC_BATCH

	Table	Columns	Description
1	OITM	299	Items
2	OINV	386	A/R Invoice
3	OCRD	332	Business Partner
4	ORDR	386	Sales Order
5	OJDT	100	Journal Entry
6	INV1	265	A/R Invoice - Rows
7	OPCH	386	A/P Invoice
8	JDT1	124	Journal Entry - Rows
9	OPOR	386	Purchase Order
10	OVTG	52	Tax Definition

	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	OINM	101	Whse Journal
10	OSRN	20	Serial Numbers Master Data

147 columns | ERP 6.0 | DOCLN

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	/BIC/B0000168000	PSA for 0FI_GL_40 T90CLNT090 G/L Accounts: Items	96	DOCLN		nvarchar	6	0
2	/BIC/B0000169000	PSA for 0FI_GL_41 T90CLNT090 Documents, Compact	96	DOCLN		nvarchar	6	0
3	/BIC/B0000172000	PSA for 0FI_GL_14 T90CLNT090 Gen. Ledger: Items	137	DOCLN		nvarchar	6	0
4	BSEG	Accounting Document Segment	317	DOCLN	Six-Character Posting Item for Ledger	nvarchar	6	0
5	CNFM_FMBL	Extension table for table FMBL (localization PSM China)	5	DOCLN	Budget entry document line	nvarchar	6	0
6	CNFM_FMHBL	Extension table for table FMHBL (localization PSM China)	5	DOCLN	Budget entry document line	nvarchar	6	0
7	FMBCS_FMBL_CD	Empty table for change documents on FMBL incl. local. fields	5	DOCLN	Budget entry document line	nvarchar	6	0
8	FUDT_VDOCBSEG	Verification Document Item with Additional Info	306	DOCLN	Six-Character Posting Item for Ledger	nvarchar	6	0
9	FUDT_VDOCBSEGEV	Verification Document Item in the Entry View	306	DOCLN	Six-Character Posting Item for Ledger	nvarchar	6	0
10	FUDT_VDOCBSEGH	Verification Document Segment with Additional Info(History)	306	DOCLN	Six-Character Posting Item for Ledger	nvarchar	6	0
11	GLIDXB	Line-item index for FI-SL BUKRS	8	DOCLN	Document line	nvarchar	3	0
12	GLIDXC	Line Item Index for FI-SL Global Company	9	DOCLN	Document line	nvarchar	3	0
13	GLPCA_CT	Profit Center Documents	63	DOCLN	Document line	nvarchar	3	0
14	GLPCA_T_CT	Profit Center Documents	79	DOCLN	Document line	nvarchar	3	0
15	GLPOS_N_CT	New General Ledger: Line Item with Currency Type	91	DOCLN	Six-Character Posting Item for Ledger	nvarchar	6	0
16	GLPOS_N_GL_CT	New General Ledger: Line Item with Currency Type	91	DOCLN	Six-Character Posting Item for Ledger	nvarchar	6	0
17	GLS2IDX	Index table for FI-LC document cluster	6	DOCLN	Document line	nvarchar	3	0
18	ZSAWA	Actual line item table	13	DOCLN	Six-Character Posting Item for Ledger	nvarchar	6	0
19	ZSAWP	Plan line items table	13	DOCLN	Six-Character Posting Item for Ledger	nvarchar	6	0
20	ZSEMBPSA	Actual line item table	13	DOCLN	Six-Character Posting Item for Ledger	nvarchar	6	0
21	ZSEMBPSP	Plan line items table	13	DOCLN	Six-Character Posting Item for Ledger	nvarchar	6	0
22	ZSPLITA	Isteinzelposten-Tabelle	13	DOCLN	Sechsstellige Buchungszeile für Ledger	nvarchar	6	0
23	ZSPLITP	Planeinzelposten-Tabelle	13	DOCLN	Sechsstellige Buchungszeile für Ledger	nvarchar	6	0
24	ZZ001A	Actual Line Item Table	13	DOCLN	Six-Character Posting Item for Ledger	nvarchar	6	0
25	ZZ001P	Plan Line Items Table	13	DOCLN	Six-Character Posting Item for Ledger	nvarchar	6	0
26	ZZLINEA	Actual line item table	13	DOCLN	Six-Character Posting Item for Ledger	nvarchar	6	0
27	ZZLINEP	Plan line items table	13	DOCLN	Six-Character Posting Item for Ledger	nvarchar	6	0
28	ZZSL01A	Actual line item table	13	DOCLN	Six-Character Posting Item for Ledger	nvarchar	6	0
29	ZZSL01P	Plan line items table	13	DOCLN	Six-Character Posting Item for Ledger	nvarchar	6	0
30	ZZSPECA	Actual line item table	13	DOCLN	Document line	nvarchar	3	0
31	ZZSPECP	Plan line item table	13	DOCLN	Document line	nvarchar	3	0
TOPAccounting Interface
32	GLE_FI_ITEM_MODF	ECS: Modified FI Line Items (Header/Item/Currency Data)	46	DOCLN	Six-Character Posting Item for Ledger	nvarchar	6	0
33	GLE_FI_ITEM_ORIG	ECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)	46	DOCLN	Six-Character Posting Item for Ledger	nvarchar	6	0
TOPAvailability Control
34	FMAVCA	Actual line item table	12	DOCLN	Six-Character Posting Item for Ledger	nvarchar	6	0
35	FMAVCP	Plan line items table	12	DOCLN	Six-Character Posting Item for Ledger	nvarchar	6	0
TOPBasic Functions
36	FILCA	FI-LC: Actual journal entry table with 2 object tables	13	DOCLN	Document line	nvarchar	3	0
37	FILCP	FI-LC: Plan line items for object table	13	DOCLN	Document line	nvarchar	3	0
38	GGREFA	Example for Global FI-SL Line Items (Actual)	13	DOCLN	Six-Character Posting Item for Ledger	nvarchar	6	0
39	GGREFP	Example for Global FI-SL Line Items (Plan)	13	DOCLN	Six-Character Posting Item for Ledger	nvarchar	6	0
40	GLFUNCA	Actual Line Items Table for Cost of Sales Accounting	13	DOCLN	Document line	nvarchar	3	0
41	GLFUNCP	Plan Line Items Table for Cost of Sales Accounting	13	DOCLN	Document line	nvarchar	3	0
42	GLFUNCU	Rollup line item tables with function area for IDES	13	DOCLN	Document line	nvarchar	3	0
43	GLFUNCV	Rollup plan line items table with function area for IDES	13	DOCLN	Document line	nvarchar	3	0
44	GLP0	Local Logical General Ledger Plan Line Items	14	DOCLN	Document line	nvarchar	3	0
45	GLPO1	Plan Line Items for Object Table	15	DOCLN	Document line	nvarchar	3	0
46	GLPO2	Plan Line Items for Object Table Global	15	DOCLN	Document line	nvarchar	3	0
47	GLPO3	Plan Line Items for Object Table	15	DOCLN	Document line	nvarchar	3	0
48	GLREFA	Example for Local FI-SL Line Items (Actual)	13	DOCLN	Six-Character Posting Item for Ledger	nvarchar	6	0
49	GLREFP	Example for Local FI-SL Line Items (Plan)	13	DOCLN	Six-Character Posting Item for Ledger	nvarchar	6	0
50	GLREFU	Example for FI-SL Rollup Line Items (Actual)	13	DOCLN	Document line	nvarchar	3	0
51	GLREFV	Example for Rollup FI-SL Line Items (Plan)	13	DOCLN	Document line	nvarchar	3	0
52	GLSO1	FI-SL Line Item Table with Objects for GLTO1	15	DOCLN	Document line	nvarchar	3	0
53	GLSO2	FI-SL Table with Objects, Structure corresponds to GLS2	15	DOCLN	Document line	nvarchar	3	0
54	GLSO3	FI-SL LI Table with Objects for GLTO3	15	DOCLN	Document line	nvarchar	3	0
TOPBudgeting
55	FMBDA	Actual line item table	12	DOCLN	Six-Character Posting Item for Ledger	nvarchar	6	0
56	FMBDP	FM Budget change line items table	12	DOCLN	Six-Character Posting Item for Ledger	nvarchar	6	0
57	FMBL	Funds management budget document lines (entry documents)	5	DOCLN	Budget entry document line	nvarchar	6	0
58	FMHBL	Funds management budget document lines (held documents)	5	DOCLN	Budget entry document line	nvarchar	6	0
59	FMPEP_VARIANTL	Session variants (line part) for transaction FMPEP	5	DOCLN	Budget entry document line	nvarchar	6	0
60	FMRBA	Actual line item table	12	DOCLN	Six-Character Posting Item for Ledger	nvarchar	6	0
61	FMRBP	Plan line items table	12	DOCLN	Six-Character Posting Item for Ledger	nvarchar	6	0
TOPCollectionsDisbursements
62	GLISDEA	Actual Line Item Tables for Insurance (DE)	13	DOCLN	Document line	nvarchar	3	0
63	GLISDEP	Plan Line Item Table for Insurance (DE)	13	DOCLN	Document line	nvarchar	3	0
64	GRISDEA	Actual Line Item Table for Insurance (DE) - Rollup	13	DOCLN	Document line	nvarchar	3	0
65	GRISDEP	Plan Line Item Table for Insurance (DE) - Rollup	13	DOCLN	Document line	nvarchar	3	0
TOPConsolidation
66	ECMCA	SAP Cons.: Journal Entry Table (Actual)	13	DOCLN	Six-Character Posting Item for Ledger	nvarchar	6	0
TOPCost Element Accounting
67	COFIP	Single plan items for reconciliation ledger	13	DOCLN	Document line	nvarchar	3	0
68	COFIS	Actual line items for reconciliation ledger	13	DOCLN	Document line	nvarchar	3	0
TOPData Retention Tool
69	TXW_S_COFI	Retrieve COFIS from archive	7	DOCLN	Document line	nvarchar	3	0
TOPFinancial Accounting
70	FBICRC001A	ICRC: Open Items GL Accounts: Documents	12	DOCLN	Six-Character Posting Item for Ledger	nvarchar	6	0
71	FBICRC001P	Not in use	12	DOCLN	Six-Character Posting Item for Ledger	nvarchar	6	0
72	FBICRC002A	ICRC: GL Accounts: Documents	12	DOCLN	Six-Character Posting Item for Ledger	nvarchar	6	0
73	FBICRC002P	Not in use	12	DOCLN	Six-Character Posting Item for Ledger	nvarchar	6	0
74	FBICRC003A	ICRC: Open Items Customers/Vendors: Documents	12	DOCLN	Six-Character Posting Item for Ledger	nvarchar	6	0
75	FBICRC003P	Not in use	12	DOCLN	Six-Character Posting Item for Ledger	nvarchar	6	0
TOPFinancial Services Localization
76	/CEEIS/RUA	Actual line item table	13	DOCLN	Six-Character Posting Item for Ledger	nvarchar	6	0
77	/CEEIS/RUP	Plan line items table	13	DOCLN	Six-Character Posting Item for Ledger	nvarchar	6	0
TOPFlexible Real Estate Management
78	VIPRLEDTAGRA	Isteinzelposten-Tabelle	13	DOCLN	Sechsstellige Buchungszeile für Ledger	nvarchar	6	0
79	VIPRLEDTAGRP	Planeinzelposten-Tabelle	13	DOCLN	Sechsstellige Buchungszeile für Ledger	nvarchar	6	0
TOPFund Accounting
80	FMCCAVCA	Actual line item table	12	DOCLN	Six-Character Posting Item for Ledger	nvarchar	6	0
81	FMCCAVCP	Plan line items table	12	DOCLN	Six-Character Posting Item for Ledger	nvarchar	6	0
82	FMGLFLEXA	General Ledger: Actual Line Items	6	DOCLN	Six-Character Posting Item for Ledger	nvarchar	6	0
83	FMGLFLEXP	General Ledger: Plan Line Items	6	DOCLN	Six-Character Posting Item for Ledger	nvarchar	6	0
84	PSGLFLEXA	General Ledger: Actual Line Items	6	DOCLN	Six-Character Posting Item for Ledger	nvarchar	6	0
85	PSGLFLEXP	General Ledger: Plan Line Items	6	DOCLN	Six-Character Posting Item for Ledger	nvarchar	6	0
TOPFunds Management
86	FMFG_SAV_FACTS1A	Saved FACTS1A data for docs excluded from SL Repost for 600	12	DOCLN	Six-Character Posting Item for Ledger	nvarchar	6	0
87	FMFG_SAV_FACTS2A	Saved FACTS2A data for docs excluded from SL Repost for 600	12	DOCLN	Six-Character Posting Item for Ledger	nvarchar	6	0
88	FMFG_SAV_FMUSFGA	Saved FMUSFGA data for docs excluded from SL Repost for 600	12	DOCLN	Six-Character Posting Item for Ledger	nvarchar	6	0
89	FMIA	Actual Line Item Table for Funds Management	11	DOCLN	Document line	nvarchar	3	0
90	FMIP	Plan Line Items Table for Funds Management	11	DOCLN	Document line	nvarchar	3	0
91	FMSPLITA	Actual line item table	12	DOCLN	Six-Character Posting Item for Ledger	nvarchar	6	0
92	FMSPLITP	Plan line items table	12	DOCLN	Six-Character Posting Item for Ledger	nvarchar	6	0
93	FMUSFGA	Actual line item table for US Federal Government.	12	DOCLN	Six-Character Posting Item for Ledger	nvarchar	6	0
94	FMUSFGFACTS1A	4Actual line item table	12	DOCLN	Six-Character Posting Item for Ledger	nvarchar	6	0
95	FMUSFGFACTS1P	Plan line items table	12	DOCLN	Six-Character Posting Item for Ledger	nvarchar	6	0
96	FMUSFGFACTS2A	Actual line item table	12	DOCLN	Six-Character Posting Item for Ledger	nvarchar	6	0
97	FMUSFGFACTS2P	Plan line items table	12	DOCLN	Six-Character Posting Item for Ledger	nvarchar	6	0
98	FMUSFGP	Plan line items table	12	DOCLN	Six-Character Posting Item for Ledger	nvarchar	6	0
TOPGeneral Ledger Accounting
99	FAGLFLEXA	General Ledger: Actual Line Items	6	DOCLN	Six-Character Posting Item for Ledger	nvarchar	6	0
100	FAGLFLEXP	General Ledger: Plan Line Items	6	DOCLN	Six-Character Posting Item for Ledger	nvarchar	6	0
101	FAGLSKF_PN	General Ledger; Statistical Key Figures (Source Document)	5	DOCLN	Six-Character Posting Item for Ledger	nvarchar	6	0
102	FAGL_BW_LOG_ITEM	FI-GL: Log for BW Extraction: Line Items	13	DOCLN	Six-Character Posting Item for Ledger	nvarchar	6	0
103	FAGL_EXTR	Documents for Summary Document Transfer	11	DOCLN	Six-Character Posting Item for Ledger	nvarchar	6	0
104	GLFLEXA	Flexible general ledger: Actual line items	6	DOCLN	Six-Character Posting Item for Ledger	nvarchar	6	0
105	GLFLEXP	Flexible G/L: Plan line items	6	DOCLN	Six-Character Posting Item for Ledger	nvarchar	6	0
TOPGrantee Management
106	GMAVCA	Actual line item table	13	DOCLN	Six-Character Posting Item for Ledger	nvarchar	6	0
107	GMAVCP	Plan line items table	13	DOCLN	Six-Character Posting Item for Ledger	nvarchar	6	0
108	GMIA	Actual Line Item Table	12	DOCLN	Six-Character Posting Item for Ledger	nvarchar	6	0
109	GMIP	Plan line items table	12	DOCLN	Six-Character Posting Item for Ledger	nvarchar	6	0
TOPJoint Venture und Production Sharing Accounting
110	JVGLFLEXA	General Ledger: Actual Line Items	6	DOCLN	Six-Character Posting Item for Ledger	nvarchar	6	0
111	JVGLFLEXP	General Ledger: Plan Line Items	6	DOCLN	Six-Character Posting Item for Ledger	nvarchar	6	0
112	JVPO1	JVA: Plan Line Items	13	DOCLN	Line Item in Joint Venture Document	nvarchar	3	0
113	JVPSC01A	Actual line item table	13	DOCLN	Six-Character Posting Item for Ledger	nvarchar	6	0
114	JVPSC01P	Plan line item table	13	DOCLN	Six-Character Posting Item for Ledger	nvarchar	6	0
115	JVSO1	JV LI Table with Objects for JVTO1	13	DOCLN	Line Item in Joint Venture Document	nvarchar	3	0
116	JVSO2	JV Billing FI-SL Line Item	12	DOCLN	Line Item in Joint Venture Document	nvarchar	3	0
117	T8JBI_THD	JVA billing threshold details	9	DOCLN	Number of Line Item Within Accounting Document	nvarchar	3	0
118	T8JVBA	Documents included in Bank Account Switching	6	DOCLN	Line Item in Joint Venture Document	nvarchar	3	0
119	T8J_JVEC	JVA equity change document relationship	6	DOCLN	Document line	nvarchar	3	0
120	T8PSA_COST_ADJ	PSA Cost Adjustment	3	DOCLN	PSA Document line	nvarchar	3	0
121	T8PSA_PREPOST	Preliminary Posting	7	DOCLN	PSA Document line	nvarchar	3	0
122	T8PSA_STOCK_ADJ	PSA Stock Adjustment	3	DOCLN	PSA Document line	nvarchar	3	0
TOPLocalization
123	J_3RFTAXRA	Tax Accounting: Actual line item table	13	DOCLN	Six-Character Posting Item for Ledger	nvarchar	6	0
124	J_3RFTAXRP	Tax Accounting: Plan line item table	13	DOCLN	Six-Character Posting Item for Ledger	nvarchar	6	0
125	J_3RFTAXRVA	Tax Accounting: Actual line item table	13	DOCLN	Six-Character Posting Item for Ledger	nvarchar	6	0
126	J_3RFTAXRVP	Tax Accounting: Plan line item table	13	DOCLN	Six-Character Posting Item for Ledger	nvarchar	6	0
TOPProfit Center Accounting
127	GLPCA	EC-PCA: Actual Line Items	13	DOCLN	Document line	nvarchar	3	0
128	GLPCP	EC-PCA: Plan Line Items	13	DOCLN	Document line	nvarchar	3	0
TOPRegulatory reporting for insurance companies
129	ISSRFLDEA	Actual line item table	13	DOCLN	Six-Character Posting Item for Ledger	nvarchar	6	0
130	ISSRFLDEP	Plan line items table	13	DOCLN	Six-Character Posting Item for Ledger	nvarchar	6	0
TOPRemaining Beverage - Obsolete Objects
131	/BEV3/CHFIA	Actual line item table	13	DOCLN	Six-Character Posting Item for Ledger	nvarchar	6	0
132	/BEV3/CHFIP	Plan Line Items Table	13	DOCLN	Six-Character Posting Item for Ledger	nvarchar	6	0
133	/BEV3/CHVGRA	Actual line item table	13	DOCLN	Six-Character Posting Item for Ledger	nvarchar	6	0
134	/BEV3/CHVGRP	Plan Line Items Table	13	DOCLN	Six-Character Posting Item for Ledger	nvarchar	6	0
TOPRemote Logistics Management
135	OIO_RT_RTDOC_CT	Returns document - container items	3	DOCLN	Returns document item number	nvarchar	4	0
136	OIO_RT_RTDOC_MT	Returns document - material items	3	DOCLN	Returns document item number	nvarchar	4	0
TOPRetail Ledger
137	PCRRETAILA	Actual line item table	13	DOCLN	Six-Character Posting Item for Ledger	nvarchar	6	0
138	PCRRETAILP	Plan line items table	13	DOCLN	Six-Character Posting Item for Ledger	nvarchar	6	0
TOPSpecial Purpose Ledger
139	/CCIS/PBU18A	PBU18: Actual line item table	13	DOCLN	Six-Character Posting Item for Ledger	nvarchar	6	0
140	/CCIS/PBU18P	PBU18: Plan line item table	13	DOCLN	Six-Character Posting Item for Ledger	nvarchar	6	0
141	/CCIS/PROFTAXA	Actual Line Items Table for General Ledger	6	DOCLN	Six-Character Posting Item for Ledger	nvarchar	6	0
142	/CCIS/PROFTAXP	Plan Line Items Table for General Ledger	6	DOCLN	Six-Character Posting Item for Ledger	nvarchar	6	0
TOPTariffs, Duties and Permits
143	OIHEDA	Actual line item table, IS-OIL Excise Duty Special Ledger	13	DOCLN	Six-Character Posting Item for Ledger	nvarchar	6	0
144	OIHEDP	Plan line item table, IS-OIL Excise Duty Special Ledger	13	DOCLN	Six-Character Posting Item for Ledger	nvarchar	6	0
145	OIHSLA	TDP (excise duty) special ledger actual line item table	13	DOCLN	Document line	nvarchar	3	0
TOPTransfer to Financial Accounting
146	TRACTSLA	Actual Line Item Table	13	DOCLN	Six-Character Posting Item for Ledger	nvarchar	6	0
147	TRACTSLP	Plan Line Items Table	13	DOCLN	Six-Character Posting Item for Ledger	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

147 columns | ERP 6.0 | DOCLN