	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

67 columns | ERP 6.0 | BETRH

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	/1RA/0SD010CO	Items for Class SD01 - Raw Data	13	BETRH	Amount in Local Currency	decimal	23	2
2	/1RA/0SD012CO	Items for Class SD01 - Processable	13	BETRH	Amount in Local Currency	decimal	23	2
3	/1RA/0SD014CO	Items for Class SD01 - Processed	13	BETRH	Amount in Local Currency	decimal	23	2
4	/1RA/0SD020CO	Items for Class SD02 - Raw Data	13	BETRH	Amount in Local Currency	decimal	23	2
5	/1RA/0SD022CO	Items for Class SD02 - Processable	13	BETRH	Amount in Local Currency	decimal	23	2
6	/1RA/0SD024CO	Items for Class SD02 - Processed	13	BETRH	Amount in Local Currency	decimal	23	2
7	/1RA/0SD030CO	Items for Class SD03 - Raw Data	13	BETRH	Amount in Local Currency	decimal	23	2
8	/1RA/0SD032CO	Items for Class SD03 - Processable	13	BETRH	Amount in Local Currency	decimal	23	2
9	/1RA/0SD034CO	Items for Class SD03 - Processed	13	BETRH	Amount in Local Currency	decimal	23	2
10	DFKKEPRT	Log for Inconsistent FI-CA Documents	21	BETRH	Amount In Local Currency With +/- Signs	decimal	13	2
11	DFKKFWKORRN	Cumul. Table for Adjustment and Inverse Postings (New)	16	BETRH	Amount In Local Currency With +/- Signs	decimal	13	2
12	DFKK_ACCADJ	Adjustment Postings when Implementing Acct Assgmt Chars	14	BETRH	Amount In Local Currency With +/- Signs	decimal	13	2
13	DFKK_NEWACCADJ	Obsolete: See DFKK_ACCADJ	14	BETRH	Amount In Local Currency With +/- Signs	decimal	13	2
14	FARR_D_INVOICE	Invoice Entries	12	BETRH	Amount in Local Currency	decimal	23	2
15	FARR_D_POSTING	Posting table	12	BETRH	Amount in Local Currency	decimal	23	2
16	T043G	Tolerances for Groups of Customers/Vendors	5	BETRH	Maximum Payment Difference for Expense	decimal	7	2
17	T043S	Tolerances for Groups of G/L Accounts	5	BETRH	Maximum Expense Difference on Clearing	decimal	7	2
18	T043T	FI tolerance groups for employees	5	BETRH	Maximum Payment Difference for Expense	decimal	7	2
TOPBusiness transactions
19	DFKKTXINV	Tax Invoices	14	BETRH	Amount In Local Currency With +/- Signs	decimal	13	2
TOPContract Accounts Receivable and Payable
20	DFKKBRPOPNOT	Balance reporting: noticed contract account document items	11	BETRH	Amount In Local Currency With +/- Signs	decimal	13	2
21	DFKKCIBW	FICA: Extraction of Cleared Items	16	BETRH	Amount in Local Currency with +/- Signs	decimal	15	2
22	DFKKDEFREV_POS	Line Item Table (Event-Based Deferred Revenues)	10	BETRH	Amount In Local Currency With +/- Signs	decimal	13	2
23	DFKKFMBGAINFO	Tax Information for Public-Owned Commercial Operations	20	BETRH	Amount in Local Currency	decimal	13	2
24	DFKKFWKORR	Cumulation Table for Adjustment and Inverse Postings	15	BETRH	Amount In Local Currency With +/- Signs	decimal	13	2
25	DFKKIPBW_ITEM	Installment Plan Items for Business Warehouse	16	BETRH	Amount In Local Currency With +/- Signs	decimal	13	2
26	DFKKIPBW_ORIG	Installment Plan Original Items for Business Warehouse	19	BETRH	Amount In Local Currency With +/- Signs	decimal	13	2
27	DFKKIP_GRP	Payment Specification: Header Data	41	BETRH	Amount In Local Currency With +/- Signs	decimal	13	2
28	DFKKIP_GRPH	Payment Specification: Payment Data (History)	43	BETRH	Amount In Local Currency With +/- Signs	decimal	13	2
29	DFKKMOP	Items in contract account document	41	BETRH	Amount In Local Currency With +/- Signs	decimal	13	2
30	DFKKMOPK	Items in contract account document	20	BETRH	Amount In Local Currency With +/- Signs	decimal	13	2
31	DFKKOP	Items in contract account document	41	BETRH	Amount In Local Currency With +/- Signs	decimal	13	2
32	DFKKOPAA	Distribution Items with Account Assignment	5	BETRH	Amount In Local Currency With +/- Signs	decimal	13	2
33	DFKKOPBW	OI Extraction	17	BETRH	Amount in Local Currency with +/- Signs	decimal	15	2
34	DFKKOPCOLL	Collection: Log of Receivables Submitted	24	BETRH	Amount In Local Currency With +/- Signs	decimal	13	2
35	DFKKOPK	Items in contract account document	20	BETRH	Amount In Local Currency With +/- Signs	decimal	13	2
36	DFKKOPK_SHORT	Offsetting Items for FI-CA Document - Extracts	8	BETRH	Amount In Local Currency With +/- Signs	decimal	13	2
37	DFKKOP_REP	Open Items from FPO4	45	BETRH	Amount In Local Currency With +/- Signs	decimal	13	2
38	DFKKOP_SHORT	Partner Items for FI-CA Document - Extracts	12	BETRH	Amount In Local Currency With +/- Signs	decimal	13	2
39	DFKKORDERPOS	Requests: Items	23	BETRH	Amount In Local Currency With +/- Signs	decimal	13	2
40	DFKKORDERPOS_S	Request Templates: Items	22	BETRH	Amount In Local Currency With +/- Signs	decimal	13	2
41	DFKKPPI	Open Items for Promise to Pay, with Amount	8	BETRH	Amount In Local Currency With +/- Signs	decimal	13	2
42	DFKKQSR	Individual Records for Withholding Tax Report	14	BETRH	Amount In Local Currency With +/- Signs	decimal	13	2
43	DFKKRAP	Clearing/Reversal History (Line Item Level) < 4.62	11	BETRH	Amount In Local Currency With +/- Signs	decimal	13	2
44	DFKKRAPT	Clearing/Reversal History (Line Item Level)	11	BETRH	Amount In Local Currency With +/- Signs	decimal	13	2
45	DFKKREP01	Data for Sales Lists (Belgium)	10	BETRH	Amount In Local Currency With +/- Signs	decimal	13	2
46	DFKKREP02	Data for Sales Lists (Belgium)	10	BETRH	Amount In Local Currency With +/- Signs	decimal	13	2
47	DFKKREP03	Payment History: Posting Totals for Debit Entries	8	BETRH	Amount In Local Currency With +/- Signs	decimal	13	2
48	DFKKREP04	Payment History: Open Items at End of Period	10	BETRH	Amount In Local Currency With +/- Signs	decimal	13	2
49	DFKKREPTD	Adjusted Tax Data (Currently Not Used)	10	BETRH	Amount In Local Currency With +/- Signs	decimal	13	2
50	DFKKRES	Reserve Postings	11	BETRH	Amount In Local Currency With +/- Signs	decimal	13	2
51	DFKKREV06	Report for Tax on Sales/Purchases (bill. time or triggered)	12	BETRH	Amount In Local Currency With +/- Signs	decimal	13	2
52	DFKKREV07	Report on Tax on Sales/Purchases (clearing time)	13	BETRH	Amount In Local Currency With +/- Signs	decimal	13	2
53	DFKKRP	Returns lot: Data for payment	7	BETRH	Amount In Local Currency With +/- Signs	decimal	13	2
54	DFKKRP3	Returns: Manual Posting Specifications	18	BETRH	Amount In Local Currency With +/- Signs	decimal	13	2
55	DFKKRP3H	Returns: History for Manual Posting Items	14	BETRH	Amount In Local Currency With +/- Signs	decimal	13	2
56	DFKKSUM	Posting totals from FI-CA	47	BETRH	Amount In Local Currency With +/- Signs	decimal	13	2
57	DFKKZA	Repayment Request	7	BETRH	Amount In Local Currency With +/- Signs	decimal	13	2
58	DFKKZP	Payment lot: Data for payment	11	BETRH	Amount In Local Currency With +/- Signs	decimal	13	2
59	DFKK_DUEGRID	OI - Reclassifications	14	BETRH	Amount in Local Currency with +/- Signs	decimal	15	2
60	DFKK_IPL_ITEMS	Installment Plan Key Date Recording (Original Items)	10	BETRH	Amount In Local Currency With +/- Signs	decimal	13	2
61	DFKK_RECLASS	OI - Reclassifications	12	BETRH	Amount In Local Currency With +/- Signs	decimal	13	2
62	FKKDEFREV	Trigger Table for Deferred Revenue Postings	7	BETRH	Amount In Local Currency With +/- Signs	decimal	13	2
63	FKKMAREDUCT	Dunning Reductions	11	BETRH	Amount In Local Currency With +/- Signs	decimal	13	2
TOPContract Billing
64	EPPMDEBTOPBELNR	Documents Transferred to PPM	10	BETRH	Amount In Local Currency With +/- Signs	decimal	13	2
TOPFinancial Services Localization
65	/GSINS/UPR_FKUPR	UPR - Calculation of unearned insurance premium reserve	10	BETRH	Amount In Local Currency With +/- Signs	decimal	13	2
TOPInvoicing
66	DEABPS	Customer change table: Logical view of BB amounts	36	BETRH	Amount In Local Currency With +/- Signs	decimal	13	2
67	EABPS_CORR	Sub Budget Billing Plan for Correspondence Print	25	BETRH	Amount In Local Currency With +/- Signs	decimal	13	2

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

67 columns | ERP 6.0 | BETRH