	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	OVPM	154	Outgoing Payments
5	OIVL	77	Whse Journal
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

130 columns | ERP 6.0 | UMSKZ

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	/ATL/KPFI00003	cashier system - checks concentration	21	UMSKZ	Special G/L Indicator	nvarchar	1	0
2	/ATL/KPFI00003DL	cashier system - checks concentration deleted	21	UMSKZ	Special G/L Indicator	nvarchar	1	0
3	/ATL/KPFI00003KP	Cashier system - checks concentration - Temporary	21	UMSKZ	Special G/L Indicator	nvarchar	1	0
4	/ATL/KPFI00004	Cashier system - Credit card concentration	73	UMSKZ	Special G/L Indicator	nvarchar	1	0
5	/ATL/KPFI00004KP	Cashier system - Credit card concentration - Temporary	74	UMSKZ	Special G/L Indicator	nvarchar	1	0
6	/ATL/KPFI00006	Cashier system - Cash payments concentration	18	UMSKZ	Special G/L Indicator	nvarchar	1	0
7	/ATL/KPFI00006KP	Cashier system - Cash payments concentration - Temporary	19	UMSKZ	Special G/L Indicator	nvarchar	1	0
8	/BIC/B0000165000	PSA for 0FI_AP_4 T90CLNT090 FI-AP: Items Delta	15	UMSKZ		nvarchar	1	0
9	/BIC/B0000166000	PSA for 0FI_AR_4 T90CLNT090 FI-AR Items Delta	15	UMSKZ		nvarchar	1	0
10	/BIC/B0000168000	PSA for 0FI_GL_40 T90CLNT090 G/L Accounts: Items	51	UMSKZ		nvarchar	1	0
11	/BIC/B0000169000	PSA for 0FI_GL_41 T90CLNT090 Documents, Compact	51	UMSKZ		nvarchar	1	0
12	/BIC/B0000170000	PSA for 0FI_GL_4 T90CLNT090 FI-GL Items Delta	13	UMSKZ		nvarchar	1	0
13	/BIC/B0000172000	PSA for 0FI_GL_14 T90CLNT090 Gen. Ledger: Items	59	UMSKZ		nvarchar	1	0
14	BOE_REF_DOC	Reference documnet for BoE	28	UMSKZ	Special G/L Indicator	nvarchar	1	0
15	BSAD_BAK	Accounting: Secondary index for customers (cleared items)	5	UMSKZ	Special G/L Indicator	nvarchar	1	0
16	BSAK_BAK	Accounting: Secondary Index for Vendors (Cleared Items)	5	UMSKZ	Special G/L Indicator	nvarchar	1	0
17	BSEG	Accounting Document Segment	12	UMSKZ	Special G/L Indicator	nvarchar	1	0
18	BSID_BAK	Accounting: Secondary Index for Customers	5	UMSKZ	Special G/L Indicator	nvarchar	1	0
19	BSIK_BAK	Accounting: Secondary index for vendors	5	UMSKZ	Special G/L Indicator	nvarchar	1	0
20	BSSEG	Accounting Document Segment	12	UMSKZ	Special G/L Indicator	nvarchar	1	0
21	CNVTDMS_05_BSAD	Header table for BSAD	6	UMSKZ	AKTBO for CNVTDMS_05_CE	nvarchar	1	0
22	CNVTDMS_05_BSAD1	Header table for BSAD	6	UMSKZ	AKTBO for CNVTDMS_05_CE	nvarchar	1	0
23	CNVTDMS_05_BSAK	Header table for BSAK	6	UMSKZ	AKTBO for CNVTDMS_05_CE	nvarchar	1	0
24	CNVTDMS_05_BSAK1	Header table for BSAK	6	UMSKZ	AKTBO for CNVTDMS_05_CE	nvarchar	1	0
25	FIAPSAC_CC_DOCTY	Settings for Document Order Types	5	UMSKZ	Special G/L Indicator	nvarchar	1	0
26	FIAPSAD_ORDR_HD	Order Number Header KSA	16	UMSKZ	Special G/L Indicator	nvarchar	1	0
27	FIEUD_FIDOC_I	SAFT: FI Transaction Document Item	62	UMSKZ	Special G/L Indicator	nvarchar	1	0
28	FIPDCOMC_SGL	PDC special G/L indicator	3	UMSKZ	Special G/L Indicator	nvarchar	1	0
29	FIPTC_BD_SPLGL	Maintain Special GL Indicator for Bad Debts (Portugal)	5	UMSKZ	Special G/L Indicator	nvarchar	1	0
30	FISUBSTKW_RET	Customize Retention for Statement of Subcontractor Report	2	UMSKZ	Special G/L Indicator	nvarchar	1	0
31	FUCNBUSTRAN	Assign Document Type to Entry Layout	7	UMSKZ	Special G/L Indicator	nvarchar	1	0
32	FUDT_VDOCBSECLRH	Additional Data for Document Segment: Clearing Information	34	UMSKZ	Special G/L Indicator	nvarchar	1	0
33	FUDT_VDOCBSEG	Verification Document Item with Additional Info	12	UMSKZ	Special G/L Indicator	nvarchar	1	0
34	FUDT_VDOCBSEGEV	Verification Document Item in the Entry View	12	UMSKZ	Special G/L Indicator	nvarchar	1	0
35	FUDT_VDOCBSEGH	Verification Document Segment with Additional Info(History)	12	UMSKZ	Special G/L Indicator	nvarchar	1	0
36	FUDT_VDOCBSE_CLR	Additional Data for Document Segment: Clearing Information	34	UMSKZ	Special G/L Indicator	nvarchar	1	0
37	GLPOS_C_CT	FI Document: Entry View	247	UMSKZ	Special G/L Indicator	nvarchar	1	0
38	GLPOS_C_DEB_CT	GLPOS_C_CT Customer Line Items	247	UMSKZ	Special G/L Indicator	nvarchar	1	0
39	GLPOS_C_GL_CT	GLPOS_C_CT G/L Line Items	247	UMSKZ	Special G/L Indicator	nvarchar	1	0
40	GLPOS_C_VEN_CT	GLPOS_C_CT Vendor Line Items	247	UMSKZ	Special G/L Indicator	nvarchar	1	0
41	GLPOS_N_CT	New General Ledger: Line Item with Currency Type	256	UMSKZ	Special G/L Indicator	nvarchar	1	0
42	GLPOS_N_GL_CT	New General Ledger: Line Item with Currency Type	256	UMSKZ	Special G/L Indicator	nvarchar	1	0
43	J_1ILOCCLR	EXIM : Letter of Credit Clearing Documents	8	UMSKZ	Special G/L Indicator	nvarchar	1	0
44	LWM_CFS_UMSKZEXC	FinFactSheet - Excluded Special G/L Indicators	3	UMSKZ	Special G/L Indicator	nvarchar	1	0
45	MHND	Dunning Data	38	UMSKZ	Special G/L Indicator	nvarchar	1	0
46	REGUP	Processed items from payment program	28	UMSKZ	Special G/L Indicator	nvarchar	1	0
47	T019	Financial Accounting Screen Selection	3	UMSKZ	Special G/L Transaction Type for Table T019	nvarchar	1	0
48	T030B	Standard Posting Keys	5	UMSKZ	Special G/L Indicator	nvarchar	1	0
49	T056Y	Assign special G/L indicator to interest indicator	4	UMSKZ	Special G/L Indicator	nvarchar	1	0
50	T074	Special G/L Accounts	4	UMSKZ	Special G/L Indicator	nvarchar	1	0
51	TBSLT	Posting Key Names	4	UMSKZ	Special G/L Indicator	nvarchar	1	0
52	VIYCEXPITEM	Expense Items	17	UMSKZ	Special G/L Indicator	nvarchar	1	0
TOPAccounting Interface
53	GLE_FI_ITEM_MODF	ECS: Modified FI Line Items (Header/Item/Currency Data)	78	UMSKZ	Special G/L Indicator	nvarchar	1	0
54	GLE_FI_ITEM_ORIG	ECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)	78	UMSKZ	Special G/L Indicator	nvarchar	1	0
TOPAccounts Receivable Accounting Process Integration
55	FDM_AR_UMSKZ	FSCM: Integration of Special GL Indicator line items	3	UMSKZ	Special G/L Indicator	nvarchar	1	0
56	TFDM_UMSKZ	Special G/L Indicator for CCM Process	3	UMSKZ	Special G/L Indicator	nvarchar	1	0
TOPAdaptor
57	UKM_TRANSFER_AR	Data from AR for SAP Credit Management	7	UMSKZ	Special G/L Indicator	nvarchar	1	0
TOPAdvertising Management
58	TJH05	IS-M/AM: Billing: Document Types	9	UMSKZ	Special G/L Indicator	nvarchar	1	0
TOPAgency Business Global Trade
59	TMPR	AB: Posting Rules	5	UMSKZ	AB: Special G/L Indicator for Posting Type	nvarchar	1	0
TOPBasic Functions
60	BSIW	Index table for customer bills of exchange used	10	UMSKZ	Special G/L Indicator	nvarchar	1	0
61	BSIX	Index table for customer bills of exchange used	10	UMSKZ	Special G/L Indicator	nvarchar	1	0
62	GLOO1	Object Table for FI-SL Table GLTO1	5	UMSKZ	Special G/L Indicator	nvarchar	1	0
63	GLOO3	Object Table for FI-SL Table GLTO3	5	UMSKZ	Special G/L Indicator	nvarchar	1	0
TOPCross-Application Components
64	BBSID	Accounting: Secondary index for customers	5	UMSKZ	Special G/L Indicator	nvarchar	1	0
65	J_2GLPFI	Logical Papers for FI	7	UMSKZ	Special G/L Indicator	nvarchar	1	0
TOPData Retention Tool
66	TXW_S_BSEG	Retrieve BSEG from archive	15	UMSKZ	Special G/L Indicator	nvarchar	1	0
TOPElectronic Bank Statement
67	FEB_ITEM_SAVE	Saving of Posting Items for Postprocessing (On Account)	20	UMSKZ	Special G/L Indicator	nvarchar	1	0
TOPExchanges
68	TOIAB	IS-OIL Exchange - Posting keys	5	UMSKZ	Special G/L Indicator	nvarchar	1	0
TOPFinancial Accounting
69	ACCTIT	Compressed Data from FI/CO Document	23	UMSKZ	Special G/L Indicator	nvarchar	1	0
70	BSAD	Accounting: Secondary Index for Customers (Cleared Items)	5	UMSKZ	Special G/L Indicator	nvarchar	1	0
71	BSAK	Accounting: Secondary Index for Vendors (Cleared Items)	5	UMSKZ	Special G/L Indicator	nvarchar	1	0
72	BSE_CLR	Additional Data for Document Segment: Clearing Information	34	UMSKZ	Special G/L Indicator	nvarchar	1	0
73	BSID	Accounting: Secondary Index for Customers	5	UMSKZ	Special G/L Indicator	nvarchar	1	0
74	BSIK	Accounting: Secondary Index for Vendors	5	UMSKZ	Special G/L Indicator	nvarchar	1	0
75	DEFTAX_ITEM	Data for Deferred Taxes	45	UMSKZ	Special G/L Indicator	nvarchar	1	0
76	ICRCA	ICRC: Items to be Reconciled	9	UMSKZ	Special G/L Indicator	nvarchar	1	0
77	ICRCU	ICRC: Potentially Differing Document Groups	9	UMSKZ	Special G/L Indicator	nvarchar	1	0
78	ICRCZ	ICRC: Reconciled, Completed Items	9	UMSKZ	Special G/L Indicator	nvarchar	1	0
79	J_1UF_MR_CUST	Exch.diff.accounting customizing	2	UMSKZ	Special G/L Indicator	nvarchar	1	0
80	J_5KFH_CADVTYPE	Advance accounting control settings	4	UMSKZ	Special G/L Indicator	nvarchar	1	0
81	PARCT	Receipt Log Table	15	UMSKZ	Special G/L Indicator	nvarchar	1	0
82	T001U	Clearing Between Company Codes	9	UMSKZ	Special G/L Indicator	nvarchar	1	0
83	T007BE	Bill of exchange customizing for deferred tax(RFUMSV50)	4	UMSKZ	Special G/L Indicator	nvarchar	1	0
84	T045W	Bank Subaccounts for Bill of Exchange Usage	5	UMSKZ	Special G/L Indicator	nvarchar	1	0
85	T074U	Special G/L Indicator Properties	3	UMSKZ	Special G/L Indicator	nvarchar	1	0
86	VBSEGD	Document Segment for Customer Document Parking	9	UMSKZ	Special G/L Indicator	nvarchar	1	0
87	VBSEGK	Document Segment for Vendor Document Parking	9	UMSKZ	Special G/L Indicator	nvarchar	1	0
TOPFunds Management-Specific Postings
88	FMITPOCT	Customizing: Payment Transfer (new in Release 4.61A )	6	UMSKZ	Special G/L indicator for payment transfer	nvarchar	1	0
89	FMPY	IS-PS: Payment Transactions	7	UMSKZ	Special G/L Indicator	nvarchar	1	0
90	PSOSEGD	Document Segment: Recurring Request, Customer	10	UMSKZ	Special G/L Indicator	nvarchar	1	0
91	PSOSEGK	Recurring Request Document Segment, Vendors	10	UMSKZ	Special G/L Indicator	nvarchar	1	0
TOPGL Account Posting
92	TCJ_POSITIONS	Cash Journal Document Items	99	UMSKZ	Special G/L Indicator	nvarchar	1	0
93	TCJ_TRANSACTIONS	Cash Journal Business Transactions	8	UMSKZ	Special G/L Indicator	nvarchar	1	0
TOPInformation System
94	BWPOS	Valuations for Open Items	32	UMSKZ	Special G/L Indicator	nvarchar	1	0
95	DKKOP	Balance Audit Trail	19	UMSKZ	Special G/L Indicator	nvarchar	1	0
96	DKOKP	Open Item Account Balance Audit Trail	33	UMSKZ	Special G/L Indicator	nvarchar	1	0
97	DSKOP	Balance Audit Trail	18	UMSKZ	Special G/L Indicator	nvarchar	1	0
98	TABKT	Automatic Accounts for End-Year Closing/Opening Postings ITA	7	UMSKZ	Special G/L Indicator	nvarchar	1	0
TOPJoint Venture und Production Sharing Accounting
99	T8J_POST_ERROR_C	Documents with errors in JV posting (Open Items)	12	UMSKZ	Special G/L Indicator	nvarchar	1	0
TOPLoans Management
100	TTONFTVZZBEPP	Test neue FIMA: VZZBEPP	187	UMSKZ	Sonderhauptbuch-Kennzeichen	nvarchar	1	0
101	VDBEPI	Posted line items for document header	24	UMSKZ	Special G/L Indicator	nvarchar	1	0
102	VDBEPI_SHADOW	Shadow Table for VDBEPI (Restrictions)	24	UMSKZ	Special G/L Indicator	nvarchar	1	0
103	VDBEPP	Flow Data - Planned Item	55	UMSKZ	Special G/L Indicator	nvarchar	1	0
104	VDBOBEPP	Business Operation: Entered and Activated Flow Data	55	UMSKZ	Special G/L Indicator	nvarchar	1	0
105	VZFZE_VDBEPP	Central Entry Table for Release Procedure	58	UMSKZ	Special G/L Indicator	nvarchar	1	0
TOPLocal Currency Changeover
106	EWUFI_SCA	EMU conversion: Table of the clearings to be adjusted	36	UMSKZ	Special G/L Indicator	nvarchar	1	0
107	EWUFI_SOP	EMU conversion: Table for open items total	9	UMSKZ	Special G/L Indicator	nvarchar	1	0
TOPLocalization
108	ISJPSELECTION	Selection of line items for Invoice Summary	5	UMSKZ	Special G/L Indicator	nvarchar	1	0
109	J_3RFSEC_ITEM	Data for Secondary events for deferred tax	32	UMSKZ	Special G/L Indicator	nvarchar	1	0
110	J_3RFTAX_EXTRD	Tax Extract Detail Lines	61	UMSKZ	Special G/L Indicator	nvarchar	1	0
111	RFITEMAP_NO_ITEM	Item wise detail for the Vendor Transactions	60	UMSKZ	Special G/L Indicator	nvarchar	1	0
112	RFITEMAR_NO_ITEM	Item wise detail for the Customer Transactions	60	UMSKZ	Special G/L Indicator	nvarchar	1	0
113	RFITEMGL_NO_ITEM	Item wise detail for the GL Account Transactions	60	UMSKZ	Special G/L Indicator	nvarchar	1	0
TOPMaster Data
114	MDTB	MRP Table	27	UMSKZ	Special G/L Indicator	nvarchar	1	0
115	PLAF	Planned Order	18	UMSKZ	Conversion indicator for planned order	nvarchar	1	0
TOPPayment Transactions
116	FPCL_ACC_PARA	Parameter for the Posting	7	UMSKZ	Special G/L Indicator	nvarchar	1	0
117	FPRL_ITEM	Item Data	36	UMSKZ	Special G/L Indicator	nvarchar	1	0
118	T042Z	Payment Methods for Automatic Payment	23	UMSKZ	Special G/L Indicicator for Bill/Exch. / Bill/Exch.Pmnt Req.	nvarchar	1	0
TOPPeriodical Sales and Distribution
119	JFXBPOSDL	IS-M: Backup Transfer Internal Table XBPOS	18	UMSKZ	Special G/L Indicator	nvarchar	1	0
120	JLRK	IS-M/SD: Settlement Header Data	53	UMSKZ	Special G/L Indicator	nvarchar	1	0
121	TJFK	IS-M/SD: Billing Document Types	34	UMSKZ	Special G/L Indicator	nvarchar	1	0
122	TJL07	IS-M/SD: Doc.Type Determ.for Settlement Transfer to FI/RF	4	UMSKZ	Special G/L Indicator	nvarchar	1	0
123	TJL11	IS-M/SD: Object Types for Document Flow etc.	34	UMSKZ	Special G/L Indicator	nvarchar	1	0
TOPReal Estate Management
124	VIAKBSEG	Document Line Item from SCS for Interface	27	UMSKZ	Special G/L Indicator	nvarchar	1	0
125	VIMIIP	Invoice Items	10	UMSKZ	Special G/L Indicator	nvarchar	1	0
TOPRemaining Beverage - Obsolete Objects
126	/BEV3/CH1030BSG1	Document Segment CH Event Ledger Part1	14	UMSKZ	Special G/L Indicator	nvarchar	1	0
TOPSimulation
127	VSPLAF_CN	Version: Planned order	19	UMSKZ	Conversion indicator for planned order	nvarchar	1	0
TOPTechnical Application Support
128	CNV_20425_SCA	EMU conversion: Table of the clearings to be adjusted	33	UMSKZ	Special G/L Indicator	nvarchar	1	0
129	CNV_20425_SOP	EMU conversion: Table for open items total	8	UMSKZ	Special G/L Indicator	nvarchar	1	0
TOPTraders and Schedulers Workbench
130	OIJ_RU_FI_POST	Define posting parameters	4	UMSKZ	Special G/L Indicator	nvarchar	1	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

130 columns | ERP 6.0 | UMSKZ