	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	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	OSRN	20	Serial Numbers Master Data
10	OBOT	10	Bill Of Exchang Transaction

73 columns | ERP 6.0 | FIKEY

	Table	Table Description	Column#	Alias	Column Description	Data Type	Length	Decimals
1	CNVTDMS_05_DFKS	Posting totals from FI-CA TDMS for ISU	4	FIKEY	AUFNR for TDMS without ALPHA	nvarchar	12	0
2	CNV_10520FICAMAP	Mappingtable for conversion of foreign currencies	4	FIKEY	Reconciliation Key for General Ledger	nvarchar	12	0
3	DBESTA_BWTRIG	Order for Updating BW Sales Statistics	4	FIKEY	Reconciliation Key for General Ledger	nvarchar	12	0
4	DBESTA_BWTRIGE	Single Order for Updating BW Sales Statistics	4	FIKEY	Reconciliation Key for General Ledger	nvarchar	12	0
5	DFKKEPRT	Log for Inconsistent FI-CA Documents	40	FIKEY	Reconciliation Key for General Ledger	nvarchar	12	0
6	DFKKHUREPDS	Recording Data for Domestic Sales Hungary	29	FIKEY	Reconciliation Key for General Ledger	nvarchar	12	0
7	DFKKINVDOC_LOG	Log of Invoicing Runs	6	FIKEY	Reconciliation Key for General Ledger	nvarchar	12	0
TOPCollectionsDisbursements
8	IBROSTMFKY	Broker Report: Reconciliation Key	3	FIKEY	Reconciliation Key for General Ledger	nvarchar	12	0
9	IBROSTMH	ISCD: Broker Report - Header Data	20	FIKEY	Reconciliation Key for General Ledger	nvarchar	12	0
10	IBROSTMP	ISCD: Broker Report - Item Data	29	FIKEY	Reconciliation Key for General Ledger	nvarchar	12	0
11	ITAGCYCONTH	Header Data for Cash Desk Container	11	FIKEY	Reconciliation Key for General Ledger	nvarchar	12	0
TOPContract Accounts Receivable and Payable
12	ARCH_FKKKO	FI-CA doc: Header-oriented doc index for archive	4	FIKEY	Reconciliation Key for General Ledger	nvarchar	12	0
13	DFKKCASHFC	Interim Table for Cash Management and Forecast Data	2	FIKEY	Reconciliation Key for General Ledger	nvarchar	12	0
14	DFKKCFRLS	Clarification Cases: Returns Lots	15	FIKEY	Reconciliation Key for General Ledger	nvarchar	12	0
15	DFKKCMF	Manually Entered Checks Lot: Reconciliation Key	3	FIKEY	Reconciliation Key for General Ledger	nvarchar	12	0
16	DFKKCMK	Manually Issued Checks Lot: Header Data	17	FIKEY	Reconciliation Key for General Ledger	nvarchar	12	0
17	DFKKCMP	Manually Issued Checks Lot: Item Data	18	FIKEY	Reconciliation Key for General Ledger	nvarchar	12	0
18	DFKKCOPA	Log Table for COPA Transfer	2	FIKEY	Reconciliation Key for General Ledger	nvarchar	12	0
19	DFKKDEFREV_POS	Line Item Table (Event-Based Deferred Revenues)	44	FIKEY	Reconciliation Key for General Ledger	nvarchar	12	0
20	DFKKFWBEW	Management Data for Foreign Currency Valuations	10	FIKEY	Reconciliation Key for General Ledger	nvarchar	12	0
21	DFKKFWBEW_LD	Management Data for Ledger-Specific Foreign Crcy Valuations	11	FIKEY	Reconciliation Key for General Ledger	nvarchar	12	0
22	DFKKGLPOST	Lock Table for General Ledger Postings	2	FIKEY	Reconciliation Key for General Ledger	nvarchar	12	0
23	DFKKKO	Header Data in Open Item Accounting Document	3	FIKEY	Reconciliation Key for General Ledger	nvarchar	12	0
24	DFKKKO_SHORT	Header Data for Contract Accounting Document - Extracts	11	FIKEY	Reconciliation Key for General Ledger	nvarchar	12	0
25	DFKKMKO	Header data for sample contract accounting document	3	FIKEY	Reconciliation Key for General Ledger	nvarchar	12	0
26	DFKKMOPK	Items in contract account document	47	FIKEY	Reconciliation Key for General Ledger	nvarchar	12	0
27	DFKKOPK	Items in contract account document	47	FIKEY	Reconciliation Key for General Ledger	nvarchar	12	0
28	DFKKORDER	Requests: Header Data	5	FIKEY	Reconciliation Key for General Ledger	nvarchar	12	0
29	DFKKORDER_S	Request Templates: Header Data	5	FIKEY	Reconciliation Key for General Ledger	nvarchar	12	0
30	DFKKREVPAR	Management Data of Reversal Run of Aggregated Document	4	FIKEY	Reconciliation Key for General Ledger	nvarchar	12	0
31	DFKKRF	Returns Lot: Reconciliation Key	3	FIKEY	Reconciliation Key for General Ledger	nvarchar	12	0
32	DFKKRK	Returns lot: Header data	6	FIKEY	Reconciliation Key for General Ledger	nvarchar	12	0
33	DFKKRP	Returns lot: Data for payment	21	FIKEY	Reconciliation Key for General Ledger	nvarchar	12	0
34	DFKKSUM	Posting totals from FI-CA	3	FIKEY	Reconciliation Key for General Ledger	nvarchar	12	0
35	DFKKSUMC	Control details for posting totals	2	FIKEY	Reconciliation Key for General Ledger	nvarchar	12	0
36	DFKKSUMCB	Control details for posting totals per company code	2	FIKEY	Reconciliation Key for General Ledger	nvarchar	12	0
37	DFKKSUMCBD	Control Information for Posting Totals - Alt. Posting Date	2	FIKEY	Reconciliation Key for General Ledger	nvarchar	12	0
38	DFKKSUMCC	Control Table for Summarization of Reconciliation Keys	3	FIKEY	Reconciliation Key for General Ledger	nvarchar	12	0
39	DFKKSUMOLD	Totals Records Without Account Assignment Changes	2	FIKEY	Reconciliation Key for General Ledger	nvarchar	12	0
40	DFKKTHI_SUM_HIST	Historical Entries of DFKKTHI_SUM	7	FIKEY	Reconciliation Key for General Ledger	nvarchar	12	0
41	DFKKWRTOFF_WF	FI-CA Data for Write-Off in Workflow	15	FIKEY	Reconciliation Key for General Ledger	nvarchar	12	0
42	DFKKZF	Payment lot: Reconciliation key	3	FIKEY	Reconciliation Key for General Ledger	nvarchar	12	0
43	DFKKZK	Payment lot: Header data	6	FIKEY	Reconciliation Key for General Ledger	nvarchar	12	0
44	DFKKZP	Payment lot: Data for payment	16	FIKEY	Reconciliation Key for General Ledger	nvarchar	12	0
45	DFKKZW2	Doubtful/Indiv. Val. Adjustments for Receivables - Tfr Pstg	25	FIKEY	Reconciliation Key for General Ledger	nvarchar	12	0
46	DFKKZWFP	Doubtful/Individually Adjusted Receivables: Tfrd Receivables	29	FIKEY	Reconciliation Key for General Ledger	nvarchar	12	0
47	DFKK_SG_ERR	Table of Incorrect Checked Documents (Safeguarding)	2	FIKEY	Reconciliation Key for General Ledger	nvarchar	12	0
48	DFKK_SG_TRIG	Trigger Table for Documents to Be Checked (Safeguarding)	2	FIKEY	Reconciliation Key for General Ledger	nvarchar	12	0
49	DFKK_SG_TRIG_C	Table of Successfully Checked Documents (Safeguarding)	2	FIKEY	Reconciliation Key for General Ledger	nvarchar	12	0
50	FKKDEFREV	Trigger Table for Deferred Revenue Postings	36	FIKEY	Reconciliation Key for General Ledger	nvarchar	12	0
51	TFK001F	Reconciliation key per user	4	FIKEY	Reconciliation Key for General Ledger	nvarchar	12	0
TOPContract Billing
52	EITRELEASE	Trigger table for release of outsorted billing documents	5	FIKEY	Reconciliation Key for General Ledger	nvarchar	12	0
TOPGL transfer
53	BKKC01	Gen.Ledger: Reconciliation Key Accounting Documents	3	FIKEY	Reconciliation Key Accounting Documents	nvarchar	10	0
54	BKKC01C	Gen.Ledger: Commitments Reconciliation Key Acctg. Documents	3	FIKEY	Reconciliation Key Accounting Documents	nvarchar	10	0
55	BKKC02	General Ledger: Posting Totals for FI	3	FIKEY	Reconciliation Key Accounting Documents	nvarchar	10	0
56	BKKC30	Gen. Ledger: Log for Transfer Postings (Bal.Sh.Prep., etc.)	4	FIKEY	Reconciliation Key Accounting Documents	nvarchar	10	0
57	BKKCNOITGL	Table of Items not Updated on the Account	5	FIKEY	Reconciliation Key Accounting Documents	nvarchar	10	0
58	BKKITGL	Gen. Ledger: Payment Item Data	6	FIKEY	Reconciliation Key Accounting Documents	nvarchar	10	0
TOPInvoicing
59	EITCOPA	IS-U -> COPA: Temp. Index for Document Selection	6	FIKEY	Reconciliation Key for General Ledger	nvarchar	12	0
60	EITEDI	Temporary Index Selection in Invoicing -> EDI Transmission	7	FIKEY	Reconciliation Key for General Ledger	nvarchar	12	0
61	EITERDK	Temporary Data Selection: Invoicing -> Bill Printout	8	FIKEY	Reconciliation Key for General Ledger	nvarchar	12	0
62	ERDK	Print Document/Header Data	30	FIKEY	Reconciliation Key for General Ledger	nvarchar	12	0
63	ERDK_SHORT	Header Data for Print Document - Extract	18	FIKEY	Reconciliation Key for General Ledger	nvarchar	12	0
TOPInvoicing in Contract Accounts Receivable and Payable
64	DFKKINVDOC_H	Invoicing Document Header	19	FIKEY	Reconciliation Key for General Ledger	nvarchar	12	0
65	DFKKINV_BWTRIG	BW: Group Extraction Order for Invoicing Documents/FIKEY	5	FIKEY	Reconciliation Key for General Ledger	nvarchar	12	0
66	DFKKINV_BWTRIGH	BI: History Record for Extraction of Invoicing Documents	5	FIKEY	Reconciliation Key for General Ledger	nvarchar	12	0
67	DFKKINV_BWTRIGS	BW: Individual Extraction Order for Invoicing Documents	5	FIKEY	Reconciliation Key for General Ledger	nvarchar	12	0
TOPStatistics
68	DBESTA_BWPROT	Log Recordc for BW Sales Statistics Update	2	FIKEY	Reconciliation Key for General Ledger	nvarchar	12	0
69	DBESTA_BWPROTE	Single Document Log Record of BW Sales Statistics	2	FIKEY	Reconciliation Key for General Ledger	nvarchar	12	0
70	DBESTA_BWPROTH	History Record for Extraction to BW Sales Statistics	4	FIKEY	Reconciliation Key for General Ledger	nvarchar	12	0
71	DBESTA_UISPROT	Log Record for UIS Sales Statistics Update	2	FIKEY	Reconciliation Key for General Ledger	nvarchar	12	0
72	EITESTA	IS-U Sales Statistics: Temp. Index for Document Selection	6	FIKEY	Reconciliation Key for General Ledger	nvarchar	12	0
73	IESTA_UISPROT	Help Structure for Block ESTA_UISROT (UIS Update)	2	FIKEY	Reconciliation Key for General Ledger	nvarchar	12	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

73 columns | ERP 6.0 | FIKEY