	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

54 columns | ERP 6.0 | PSWSL

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	/BIC/B0000172000	PSA for 0FI_GL_14 T90CLNT090 Gen. Ledger: Items	96	PSWSL		nvarchar	5	0
2	BSAD_BAK	Accounting: Secondary index for customers (cleared items)	120	PSWSL	Update Currency for General Ledger Transaction Figures	nvarchar	5	0
3	BSAK_BAK	Accounting: Secondary Index for Vendors (Cleared Items)	128	PSWSL	Update Currency for General Ledger Transaction Figures	nvarchar	5	0
4	BSAS_BAK	Accounting: Secondary Index for G/L Accounts (Cleared Items)	37	PSWSL	Update Currency for General Ledger Transaction Figures	nvarchar	5	0
5	BSEG	Accounting Document Segment	35	PSWSL	Update Currency for General Ledger Transaction Figures	nvarchar	5	0
6	BSID_BAK	Accounting: Secondary Index for Customers	120	PSWSL	Update Currency for General Ledger Transaction Figures	nvarchar	5	0
7	BSIK_BAK	Accounting: Secondary index for vendors	128	PSWSL	Update Currency for General Ledger Transaction Figures	nvarchar	5	0
8	BSIS_BAK	Accounting: Secondary Index for G/L Accounts	37	PSWSL	Update Currency for General Ledger Transaction Figures	nvarchar	5	0
9	BSSEG	Accounting Document Segment	24	PSWSL	Update Currency for General Ledger Transaction Figures	nvarchar	5	0
10	DFKKEPRT	Log for Inconsistent FI-CA Documents	52	PSWSL	Update Currency for General Ledger Transaction Figures	nvarchar	5	0
11	FAGLBSAS_BAK	Accounting: Secondary Index for G/L Accounts (Cleared Items)	37	PSWSL	Update Currency for General Ledger Transaction Figures	nvarchar	5	0
12	FAGLBSIS_BAK	Accounting: Secondary Index for G/L Accounts	37	PSWSL	Update Currency for General Ledger Transaction Figures	nvarchar	5	0
13	FUDT_VDOCBSEG	Verification Document Item with Additional Info	24	PSWSL	Update Currency for General Ledger Transaction Figures	nvarchar	5	0
14	FUDT_VDOCBSEGEV	Verification Document Item in the Entry View	24	PSWSL	Update Currency for General Ledger Transaction Figures	nvarchar	5	0
15	FUDT_VDOCBSEGH	Verification Document Segment with Additional Info(History)	24	PSWSL	Update Currency for General Ledger Transaction Figures	nvarchar	5	0
16	REGUP	Processed items from payment program	154	PSWSL	Update Currency for General Ledger Transaction Figures	nvarchar	5	0
TOPAccounting Interface
17	GLE_FI_ITEM_MODF	ECS: Modified FI Line Items (Header/Item/Currency Data)	82	PSWSL	Update Currency for General Ledger Transaction Figures	nvarchar	5	0
18	GLE_FI_ITEM_ORIG	ECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)	82	PSWSL	Update Currency for General Ledger Transaction Figures	nvarchar	5	0
TOPContract Accounts Receivable and Payable
19	DFKKMOP	Items in contract account document	130	PSWSL	Update Currency for General Ledger Transaction Figures	nvarchar	5	0
20	DFKKMOPK	Items in contract account document	57	PSWSL	Update Currency for General Ledger Transaction Figures	nvarchar	5	0
21	DFKKOP	Items in contract account document	130	PSWSL	Update Currency for General Ledger Transaction Figures	nvarchar	5	0
22	DFKKOPK	Items in contract account document	57	PSWSL	Update Currency for General Ledger Transaction Figures	nvarchar	5	0
23	DFKKOP_REP	Open Items from FPO4	136	PSWSL	Update Currency for General Ledger Transaction Figures	nvarchar	5	0
24	DFKKRAP	Clearing/Reversal History (Line Item Level) < 4.62	17	PSWSL	Update Currency for General Ledger Transaction Figures	nvarchar	5	0
25	DFKKRAPT	Clearing/Reversal History (Line Item Level)	17	PSWSL	Update Currency for General Ledger Transaction Figures	nvarchar	5	0
26	DFKKSUM	Posting totals from FI-CA	10	PSWSL	Update Currency for General Ledger Transaction Figures	nvarchar	5	0
TOPCross-Application Components
27	BBSID	Accounting: Secondary index for customers	120	PSWSL	Update Currency for General Ledger Transaction Figures	nvarchar	5	0
TOPData Retention Tool
28	TXW_S_BSEG	Retrieve BSEG from archive	68	PSWSL	Update Currency for General Ledger Transaction Figures	nvarchar	5	0
TOPFinancial Accounting
29	ACCTIT	Compressed Data from FI/CO Document	26	PSWSL	Update Currency for General Ledger Transaction Figures	nvarchar	5	0
30	BSAD	Accounting: Secondary Index for Customers (Cleared Items)	120	PSWSL	Update Currency for General Ledger Transaction Figures	nvarchar	5	0
31	BSAK	Accounting: Secondary Index for Vendors (Cleared Items)	128	PSWSL	Update Currency for General Ledger Transaction Figures	nvarchar	5	0
32	BSAS	Accounting: Secondary Index for G/L Accounts (Cleared Items)	37	PSWSL	Update Currency for General Ledger Transaction Figures	nvarchar	5	0
33	BSID	Accounting: Secondary Index for Customers	120	PSWSL	Update Currency for General Ledger Transaction Figures	nvarchar	5	0
34	BSIK	Accounting: Secondary Index for Vendors	128	PSWSL	Update Currency for General Ledger Transaction Figures	nvarchar	5	0
35	BSIS	Accounting: Secondary Index for G/L Accounts	37	PSWSL	Update Currency for General Ledger Transaction Figures	nvarchar	5	0
TOPGeneral Ledger Accounting
36	BSEG_ADD	Entry View of Accounting Document for Additional Ledgers	80	PSWSL	Update Currency for General Ledger Transaction Figures	nvarchar	5	0
37	FAGLBSAS	Accounting: Secondary Index for G/L Accounts (Cleared Items)	37	PSWSL	Update Currency for General Ledger Transaction Figures	nvarchar	5	0
38	FAGLBSIS	Accounting: Secondary Index for G/L Accounts	37	PSWSL	Update Currency for General Ledger Transaction Figures	nvarchar	5	0
39	FAGL_SPLINFO	Splittling Information of Open Items	57	PSWSL	Update Currency for General Ledger Transaction Figures	nvarchar	5	0
TOPGeneral Ledger Reorganization
40	FAGL_R_BLNCE	Reorganization: Balances to Be Transferred	7	PSWSL	Update Currency for General Ledger Transaction Figures	nvarchar	5	0
41	FAGL_R_BLNCE_VAL	Reorganization: Balances to Be Transferred - Values	7	PSWSL	Update Currency for General Ledger Transaction Figures	nvarchar	5	0
42	FAGL_R_SPL	Reorganization: Splitting Information of the Open Items	36	PSWSL	Update Currency for General Ledger Transaction Figures	nvarchar	5	0
TOPLocal Currency Changeover
43	EWUFI_SCA	EMU conversion: Table of the clearings to be adjusted	41	PSWSL	Update Currency for General Ledger Transaction Figures	nvarchar	5	0
44	EWUFI_SOP	EMU conversion: Table for open items total	11	PSWSL	Update Currency for General Ledger Transaction Figures	nvarchar	5	0
TOPLocalization
45	J_1AINFINV	Inflation: Invoices for Replacement Value Determination	14	PSWSL	Update Currency for General Ledger Transaction Figures	nvarchar	5	0
46	J_3RFTAX_EXTRD	Tax Extract Detail Lines	99	PSWSL	Update Currency for General Ledger Transaction Figures	nvarchar	5	0
47	RFITEMAP_NO_ITEM	Item wise detail for the Vendor Transactions	98	PSWSL	Update Currency for General Ledger Transaction Figures	nvarchar	5	0
48	RFITEMAR_NO_ITEM	Item wise detail for the Customer Transactions	98	PSWSL	Update Currency for General Ledger Transaction Figures	nvarchar	5	0
49	RFITEMGL_NO_ITEM	Item wise detail for the GL Account Transactions	98	PSWSL	Update Currency for General Ledger Transaction Figures	nvarchar	5	0
TOPPayment Transactions
50	FPRL_ITEM	Item Data	26	PSWSL	Update Currency for General Ledger Transaction Figures	nvarchar	5	0
51	REGUP_CORE	Processed Items from Payment Program	35	PSWSL	Currency Key	nvarchar	5	0
TOPRemaining Beverage - Obsolete Objects
52	/BEV3/CH1030BSG1	Document Segment CH Event Ledger Part1	26	PSWSL	Update Currency for General Ledger Transaction Figures	nvarchar	5	0
TOPTechnical Application Support
53	CNV_20425_SCA	EMU conversion: Table of the clearings to be adjusted	36	PSWSL	Update Currency for General Ledger Transaction Figures	nvarchar	5	0
54	CNV_20425_SOP	EMU conversion: Table for open items total	10	PSWSL	Update Currency for General Ledger Transaction Figures	nvarchar	5	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

54 columns | ERP 6.0 | PSWSL