	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

150 columns | ERP 6.0 | BSCHL

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	/ATL/FORDOCLINE	Document line details : Posting key & Block indication	4	BSCHL	Posting Key	nvarchar	2	0
2	/BIC/B0000165000	PSA for 0FI_AP_4 T90CLNT090 FI-AP: Items Delta	17	BSCHL		nvarchar	2	0
3	/BIC/B0000166000	PSA for 0FI_AR_4 T90CLNT090 FI-AR Items Delta	17	BSCHL		nvarchar	2	0
4	/BIC/B0000168000	PSA for 0FI_GL_40 T90CLNT090 G/L Accounts: Items	13	BSCHL		nvarchar	2	0
5	/BIC/B0000169000	PSA for 0FI_GL_41 T90CLNT090 Documents, Compact	13	BSCHL		nvarchar	2	0
6	/BIC/B0000170000	PSA for 0FI_GL_4 T90CLNT090 FI-GL Items Delta	15	BSCHL		nvarchar	2	0
7	/BIC/B0000172000	PSA for 0FI_GL_14 T90CLNT090 Gen. Ledger: Items	13	BSCHL		nvarchar	2	0
8	/CCEE/SIFIPOBOTI	ePoboti: Obligatory manysided reconciliation - XML output	23	BSCHL	Posting Key	nvarchar	2	0
9	/CCEE/SIFI_CDTYP	SI: Cash Sales report - document type assignment	4	BSCHL	Posting Key	nvarchar	2	0
10	/OPT/AT_APPR_HIS	Approval History for Level Based Approvals	108	BSCHL	Posting Key	nvarchar	2	0
11	/OPT/AT_LBA_LOG	Approval History for Level Based Approvals	109	BSCHL	Posting Key	nvarchar	2	0
12	/OPT/VIM_1CLEAR	/OPT/VIM_1HEAD Extension with Clearing Documents (BSAK)	12	BSCHL	Posting Key	nvarchar	2	0
13	BOE_COL_ITEM	Collection item data table	16	BSCHL	Posting Key	nvarchar	2	0
14	BOE_DIS_ITEM	Discount item data table	5	BSCHL	Posting Key	nvarchar	2	0
15	BOE_PAY_ITEM	Payment item data table	5	BSCHL	Posting Key	nvarchar	2	0
16	BSAD_BAK	Accounting: Secondary index for customers (cleared items)	19	BSCHL	Posting Key	nvarchar	2	0
17	BSAK_BAK	Accounting: Secondary Index for Vendors (Cleared Items)	19	BSCHL	Posting Key	nvarchar	2	0
18	BSAS_BAK	Accounting: Secondary Index for G/L Accounts (Cleared Items)	16	BSCHL	Posting Key	nvarchar	2	0
19	BSEG	Accounting Document Segment	10	BSCHL	Posting Key	nvarchar	2	0
20	BSID_BAK	Accounting: Secondary Index for Customers	19	BSCHL	Posting Key	nvarchar	2	0
21	BSIK_BAK	Accounting: Secondary index for vendors	19	BSCHL	Posting Key	nvarchar	2	0
22	BSIS_BAK	Accounting: Secondary Index for G/L Accounts	16	BSCHL	Posting Key	nvarchar	2	0
23	BSSEG	Accounting Document Segment	10	BSCHL	Posting Key	nvarchar	2	0
24	FAGLBSAS_BAK	Accounting: Secondary Index for G/L Accounts (Cleared Items)	16	BSCHL	Posting Key	nvarchar	2	0
25	FAGLBSIS_BAK	Accounting: Secondary Index for G/L Accounts	16	BSCHL	Posting Key	nvarchar	2	0
26	FIDOC_EOP	Document extract for EOP check	6	BSCHL	Posting Key	nvarchar	2	0
27	FIEUD_FIDOC_I	SAFT: FI Transaction Document Item	68	BSCHL	Posting Key	nvarchar	2	0
28	FUCNBUSTRAN	Assign Document Type to Entry Layout	6	BSCHL	Posting Key Indicator	nvarchar	1	0
29	FUDT_VDOCBSEG	Verification Document Item with Additional Info	10	BSCHL	Posting Key	nvarchar	2	0
30	FUDT_VDOCBSEGEV	Verification Document Item in the Entry View	10	BSCHL	Posting Key	nvarchar	2	0
31	FUDT_VDOCBSEGH	Verification Document Segment with Additional Info(History)	10	BSCHL	Posting Key	nvarchar	2	0
32	GLPOS_C_CT	FI Document: Entry View	63	BSCHL	Posting Key	nvarchar	2	0
33	GLPOS_C_DEB_CT	GLPOS_C_CT Customer Line Items	63	BSCHL	Posting Key	nvarchar	2	0
34	GLPOS_C_GL_CT	GLPOS_C_CT G/L Line Items	63	BSCHL	Posting Key	nvarchar	2	0
35	GLPOS_C_VEN_CT	GLPOS_C_CT Vendor Line Items	63	BSCHL	Posting Key	nvarchar	2	0
36	GLPOS_N_CT	New General Ledger: Line Item with Currency Type	63	BSCHL	Posting Key	nvarchar	2	0
37	GLPOS_N_GL_CT	New General Ledger: Line Item with Currency Type	63	BSCHL	Posting Key	nvarchar	2	0
38	J_1AWTH_TAX_PSTK	Conditions per Posting Key for Applying WithholdingTax	3	BSCHL	Posting Key	nvarchar	2	0
39	MHND	Dunning Data	25	BSCHL	Posting Key	nvarchar	2	0
40	REGUP	Processed items from payment program	25	BSCHL	Posting Key	nvarchar	2	0
41	T017	is being deleted	3	BSCHL	G/L Accounts Posting Key	nvarchar	2	0
42	TBSL	Posting Key	2	BSCHL	Posting Key	nvarchar	2	0
43	TBSLT	Posting Key Names	3	BSCHL	Posting Key	nvarchar	2	0
44	VIYCEXPITEM	Expense Items	16	BSCHL	Posting Key	nvarchar	2	0
TOPAccounting Interface
45	GLE_FI_ITEM_MODF	ECS: Modified FI Line Items (Header/Item/Currency Data)	80	BSCHL	Posting Key	nvarchar	2	0
46	GLE_FI_ITEM_ORIG	ECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)	80	BSCHL	Posting Key	nvarchar	2	0
TOPAlternative Valuation Run
47	CKMLAVRDOCIT	Lines for Cumulation Posting Document	21	BSCHL	Posting Key	nvarchar	2	0
TOPBasic Functions
48	BSIW	Index table for customer bills of exchange used	12	BSCHL	Posting Key	nvarchar	2	0
49	BSIX	Index table for customer bills of exchange used	12	BSCHL	Posting Key	nvarchar	2	0
TOPCentral Cash Desk Procedure
50	FMFGT_IPAC_ACCT	List of DIT & FBT Accounts for IPAC Interface Process	6	BSCHL	Posting Key	nvarchar	2	0
TOPCross-Application Components
51	BBSID	Accounting: Secondary index for customers	19	BSCHL	Posting Key	nvarchar	2	0
52	J_2GLPFI	Logical Papers for FI	5	BSCHL	Posting Key	nvarchar	2	0
TOPData Retention Tool
53	TXW_S_BSEG	Retrieve BSEG from archive	13	BSCHL	Posting Key	nvarchar	2	0
TOPElectronic Bank Statement
54	FEB_ACCNT_SAVE	Saving of Posting Lines for Postprocessing (Account Assign.)	6	BSCHL	Posting Key	nvarchar	2	0
55	FEB_ACT	Acct Assignment Templates	6	BSCHL	Posting Key	nvarchar	2	0
56	FEB_ITEM_SAVE	Saving of Posting Items for Postprocessing (On Account)	6	BSCHL	Posting Key	nvarchar	2	0
TOPExtended Rebate
57	BON_ENH_LEDGER	Reconciliation Accounts for Rebate Credit Memos	7	BSCHL	Posting Key	nvarchar	2	0
TOPExtra Charge
58	/BEV1/ECMITD	Extra Charge Reconciliation Accounts	8	BSCHL	Posting Key	nvarchar	2	0
TOPFinancial Accounting
59	ACCTIT	Compressed Data from FI/CO Document	24	BSCHL	Posting Key	nvarchar	2	0
60	BSAD	Accounting: Secondary Index for Customers (Cleared Items)	19	BSCHL	Posting Key	nvarchar	2	0
61	BSAK	Accounting: Secondary Index for Vendors (Cleared Items)	19	BSCHL	Posting Key	nvarchar	2	0
62	BSAS	Accounting: Secondary Index for G/L Accounts (Cleared Items)	16	BSCHL	Posting Key	nvarchar	2	0
63	BSID	Accounting: Secondary Index for Customers	19	BSCHL	Posting Key	nvarchar	2	0
64	BSIK	Accounting: Secondary Index for Vendors	19	BSCHL	Posting Key	nvarchar	2	0
65	BSIS	Accounting: Secondary Index for G/L Accounts	16	BSCHL	Posting Key	nvarchar	2	0
66	DOCCHG_EWBUCH	Customizing of Posting Transaction	3	BSCHL	Posting Key	nvarchar	2	0
67	EBSEG	Doc.Segment of Fin.Accntng External Documents	9	BSCHL	Posting Key	nvarchar	2	0
68	ICRCA	ICRC: Items to be Reconciled	19	BSCHL	Posting Key	nvarchar	2	0
69	ICRCU	ICRC: Potentially Differing Document Groups	19	BSCHL	Posting Key	nvarchar	2	0
70	ICRCZ	ICRC: Reconciled, Completed Items	19	BSCHL	Posting Key	nvarchar	2	0
71	J_1GJR_PK	Posting key descriptions in Journal	4	BSCHL	Posting Key	nvarchar	2	0
72	J_1GMYF2	Customer/Vendor invoice selection criteria	5	BSCHL	Posting Key	nvarchar	2	0
73	J_5KFH_CADVTYPE	Advance accounting control settings	3	BSCHL	Posting Key	nvarchar	2	0
74	KMZEI	FI: Account Assignment Model Item Information	6	BSCHL	Posting Key	nvarchar	2	0
75	KOMU	Account Assignment Templates for G/L Account Items	6	BSCHL	Posting Key	nvarchar	2	0
76	VBSEGA	Document Segment for Document Parking - Asset Database	8	BSCHL	Posting Key	nvarchar	2	0
77	VBSEGD	Document Segment for Customer Document Parking	8	BSCHL	Posting Key	nvarchar	2	0
78	VBSEGK	Document Segment for Vendor Document Parking	8	BSCHL	Posting Key	nvarchar	2	0
79	VBSEGS	Document Segment for Document Parking - G/L Account Database	8	BSCHL	Posting Key	nvarchar	2	0
TOPFlexible Real Estate Management
80	VIXCOTDOC	COA, Distribution of VAT, Documents	12	BSCHL	Posting Key	nvarchar	2	0
TOPFund Accounting
81	FMGLFLEXA	General Ledger: Actual Line Items	41	BSCHL	Posting Key	nvarchar	2	0
82	PSGLFLEXA	General Ledger: Actual Line Items	45	BSCHL	Posting Key	nvarchar	2	0
TOPFunds Management-Specific Postings
83	FMFUNDTRANSYEAR	Additional Documents for Funds Transfer to Diff. Years	10	BSCHL	Posting Key	nvarchar	2	0
84	PAYAC10	Posting Key per DR/CR Indicator	5	BSCHL	Posting Key	nvarchar	2	0
85	PSOSEGA	Document Segment for Assets Document Parking	9	BSCHL	Posting Key	nvarchar	2	0
86	PSOSEGD	Document Segment: Recurring Request, Customer	9	BSCHL	Posting Key	nvarchar	2	0
87	PSOSEGK	Recurring Request Document Segment, Vendors	9	BSCHL	Posting Key	nvarchar	2	0
88	PSOSEGS	Recurring Request Document Segment, G/L Accounts	9	BSCHL	Posting Key	nvarchar	2	0
TOPGeneral Ledger Accounting
89	BSEG_ADD	Entry View of Accounting Document for Additional Ledgers	8	BSCHL	Posting Key	nvarchar	2	0
90	FAGLBSAS	Accounting: Secondary Index for G/L Accounts (Cleared Items)	16	BSCHL	Posting Key	nvarchar	2	0
91	FAGLBSIS	Accounting: Secondary Index for G/L Accounts	16	BSCHL	Posting Key	nvarchar	2	0
92	FAGLFLEXA	General Ledger: Actual Line Items	43	BSCHL	Posting Key	nvarchar	2	0
93	FAGL_BW_LOG_ITEM	FI-GL: Log for BW Extraction: Line Items	20	BSCHL	Posting Key	nvarchar	2	0
94	FAGL_SPLINFO	Splittling Information of Open Items	52	BSCHL	Posting Key	nvarchar	2	0
TOPInformation System
95	BWPOS	Valuations for Open Items	26	BSCHL	Posting Key	nvarchar	2	0
96	DKKOP	Balance Audit Trail	29	BSCHL	Posting Key	nvarchar	2	0
97	DKOKP	Open Item Account Balance Audit Trail	32	BSCHL	Posting Key	nvarchar	2	0
98	DSKOP	Balance Audit Trail	28	BSCHL	Posting Key	nvarchar	2	0
TOPJoint Venture und Production Sharing Accounting
99	JVGLFLEXA	General Ledger: Actual Line Items	45	BSCHL	Posting Key	nvarchar	2	0
TOPLocalization
100	ISJPSELECTION	Selection of line items for Invoice Summary	4	BSCHL	Posting Key	nvarchar	2	0
101	J_1BIMFI	Movement Types for Vendor Invoices (Brazil)	5	BSCHL	Posting Key	nvarchar	2	0
102	J_1IEWT_CUST	Customer certificates ,Challan customizing EWT- India	6	BSCHL	Posting Key	nvarchar	2	0
103	J_3RFTAX_EXTRD	Tax Extract Detail Lines	16	BSCHL	Posting Key	nvarchar	2	0
104	J_3RNKS_TBSL	Credit memo posting keys for AuC	2	BSCHL	Posting Key	nvarchar	2	0
105	RFITEMAP_NO_ITEM	Item wise detail for the Vendor Transactions	16	BSCHL	Posting Key	nvarchar	2	0
106	RFITEMAR_NO_ITEM	Item wise detail for the Customer Transactions	16	BSCHL	Posting Key	nvarchar	2	0
107	RFITEMGL_NO_ITEM	Item wise detail for the GL Account Transactions	16	BSCHL	Posting Key	nvarchar	2	0
TOPPatient Accounting
108	TN22P	IS-H: Control Parameters FI Posting Down Payment	11	BSCHL	IS-H: Posting key for bank posting	nvarchar	2	0
109	TN22R	IS-H: Control Params FI Posting Copayment/Copay.Cred.Memo	9	BSCHL	IS-H: Posting key for bank posting	nvarchar	2	0
TOPPayment Transactions
110	FPRL_ITEM	Item Data	33	BSCHL	Posting Key	nvarchar	2	0
TOPPeriodical Sales and Distribution
111	JFXBPOSDL	IS-M: Backup Transfer Internal Table XBPOS	9	BSCHL	Posting Key	nvarchar	2	0
TOPPOS Interface
112	TWPIF	Transaction type-dependent control of POS financial trans.	5	BSCHL	Posting Key	nvarchar	2	0
TOPReal Estate Management
113	VIAKBSEG	Document Line Item from SCS for Interface	32	BSCHL	Posting Key	nvarchar	2	0
TOPRemaining Beverage - Obsolete Objects
114	/BEV1/BO_LEDGER	Reconciliation Accounts for Rebate Credit Memos	7	BSCHL	Posting Key	nvarchar	2	0
115	/BEV1/RBMITD	Rebate Reconciliation Accounts	7	BSCHL	Posting Key	nvarchar	2	0
116	/BEV3/CH1030BSG1	Document Segment CH Event Ledger Part1	12	BSCHL	Posting Key	nvarchar	2	0
117	/BEV3/CHABRSTZ_P	CH Settlement Items - With Translations	55	BSCHL	Posting Key	nvarchar	2	0
118	/BEV3/CHA_DRGZUO	Assignment CH business transactions to print groups	4	BSCHL	Posting key	nvarchar	2	0
119	/BEV3/CHBDMDHST	History of Condit. Modifications from Temp. Settlement Items	56	BSCHL	Posting Key	nvarchar	2	0
120	/BEV3/CHCEV1030X	CH BTE Allowed 00001030 Data	6	BSCHL	Posting Key	nvarchar	2	0
121	/BEV3/CHCEV103X	CH BTE Permissible Events Res. frm Combination CHD/1030 Data	8	BSCHL	Posting Key	nvarchar	2	0
122	/BEV3/CHCEVACDT	Assignment to posting, document and to-settlement date (BTE)	5	BSCHL	Posting Key	nvarchar	2	0
123	/BEV3/CHCEVACPR	Selection of posting line for the date compensation (BTE)	5	BSCHL	Posting Key	nvarchar	2	0
124	/BEV3/CHCEVLASFI	CH BTE: Customizing Event Listener Assessment FI	4	BSCHL	Posting Key	nvarchar	2	0
125	/BEV3/CHCEVLCAC	CH BTE Customizing Event Listener ACCOUNT	6	BSCHL	Posting Key	nvarchar	2	0
126	/BEV3/CHCEVLCAFI	CH BTE: Customizing Event Listener Assessment FI	5	BSCHL	Posting Key	nvarchar	2	0
127	/BEV3/CHCIVRG01	CI: Customizing Business Process Detail 0001	5	BSCHL	Posting Key	nvarchar	2	0
128	/BEV3/CHCI_VORG	Customizing Business Processes Header Data	4	BSCHL	Posting Key	nvarchar	2	0
129	/BEV3/CHCTBSCHL	Posting key dependent on CoCd,acc. type/Datepart,sett.method	6	BSCHL	Posting Key	nvarchar	2	0
130	/BEV3/CHCTKMPBCH	Complement Postings (BTE)	5	BSCHL	Posting Key	nvarchar	2	0
131	/BEV3/CHCTKONT	Customizing Account View	7	BSCHL	Posting Key	nvarchar	2	0
132	/BEV3/CHCTSTBSHL	Posting key dependent on CoCd,acc. type/Datepart,sett.method	6	BSCHL	Posting Key	nvarchar	2	0
133	/BEV3/CHCTSTRKZ	CH Settlement Tax Indicator	6	BSCHL	Posting Key	nvarchar	2	0
134	/BEV3/CHCVALI1	Customizing Validation FI - CH Transactions	6	BSCHL	Posting Key	nvarchar	2	0
135	/BEV3/CHERGSTZ_P	CH Settlement Items - With Translations	55	BSCHL	Posting Key	nvarchar	2	0
136	/BEV3/CHERGSTZ_S	CH Settlement Statistics	56	BSCHL	Posting Key	nvarchar	2	0
137	/BEV3/CHEVLIASFI	CH BTE Event Listener Assessment FI	9	BSCHL	Posting Key	nvarchar	2	0
138	/BEV3/CHEXCSTZ_P	CH Settlement Items/Non-Posted Docs w/o Date Statistics	55	BSCHL	Posting Key	nvarchar	2	0
139	/BEV3/CHRESSTZ_P	CH Settlement Items - Reset Documents (2/Transaction)	55	BSCHL	Posting Key	nvarchar	2	0
140	/BEV3/CHSHTSTZ_P	CH Settlement Item	55	BSCHL	Posting Key	nvarchar	2	0
141	/BEV3/CHSIMBDMDH	CH simulation history of modifications caused by conditions	56	BSCHL	Posting Key	nvarchar	2	0
142	/BEV3/CHSIMSTZ_P	CH Simulation Items	55	BSCHL	Posting Key	nvarchar	2	0
143	/BEV3/CHSIMSTZ_S	CH Simulation Statistics	56	BSCHL	Posting Key	nvarchar	2	0
144	/BEV3/CHTMPMDHST	Temp. history of cond. modifications from temp. settle. item	56	BSCHL	Posting Key	nvarchar	2	0
145	/BEV3/CHTRMSTZ_P	CH Date Item	55	BSCHL	Posting Key	nvarchar	2	0
146	/BEV3/CHTRMSTZ_S	CH Date Statistics	56	BSCHL	Posting Key	nvarchar	2	0
147	/BEV3/CHVABRSTZS	CH Settlement Statistics	56	BSCHL	Posting Key	nvarchar	2	0
TOPSAP Healthcare - Industry-Specific Components for Hospitals
148	TN22G	IS-H: Steuerungsparameter FI-Buchung amb. Zuzahlung	8	BSCHL	IS-H: Buchungsschlüssel für Bankbuchung	nvarchar	2	0
TOPSpecial Purpose Ledger
149	/CCIS/PROFTAXA	Actual Line Items Table for General Ledger	53	BSCHL	Posting Key	nvarchar	2	0
TOPTraders and Schedulers Workbench
150	OIJ_RU_FI_POST	Define posting parameters	3	BSCHL	Posting Key	nvarchar	2	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

150 columns | ERP 6.0 | BSCHL