SAP TABLES

SAP Tables - SAP Business One/ERP Table Definition reference

sap.erpref.com

Schema:
 Module:  Table: 
Column: 
Searchbeta 

icon of database logic symbol SAP  TABLESv1Made in Britain

JDETables.com - the webs number one JD Edwards Table Definition reference

ERP 6.0: Top 10 requests

TableColumnsDescription
1TJKWE15IS-M/SD: WBZ, Order Data for Inbound Processing
2RSADMINC96Customizing Table General BW
3BBP_PD_XML8Table for Persistent Class CL_XML_PPF_BBP
4/OTX/RM_TELIB24Enterprise Library Server Settings
5UMV_TR1259Obsolete:Val.Driver Tree:Assign.Web Reports to Value Drivers
6/ISDFPS/CHVW_E34External Batch Where-Used List
7FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9BSEG345Accounting Document Segment
10FMARCPAR4Parallelization of FMARC_BATCH

B1 9.2: Top 10 requests

TableColumnsDescription
1OITM299Items
2OINV386A/R Invoice
3OCRD332Business Partner
4ORDR386Sales Order
5OJDT100Journal Entry
6INV1265A/R Invoice - Rows
7OPCH386A/P Invoice
8JDT1124Journal Entry - Rows
9OPOR386Purchase Order
10OVTG52Tax Definition

B1 8.8: Top 10 requests

TableColumnsDescription
1OITM249Items
2ORCT154Incoming Payment
3OINV268A/R Invoice
4OIVL77Whse Journal
5OVPM154Outgoing Payments
6OPCH268A/P Invoice
7JDT1110Journal Entry - Rows
8OOCR9Loading Factors
9OINM101Whse Journal
10OSRN20Serial Numbers Master Data

139 columns | Print definition?ERP 6.0  | OPUPK

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1CNV_10520FICAMAPMappingtable for conversion of foreign currencies13OPUPKItem number in contract account documentnvarchar40
2CNV_10520_DOCMAPCNV_10520: Mapping Table for FICA Documents8OPUPKItem number in contract account documentnvarchar40
3DFKKCFKWLKWL: KPI Cockpit Worklist11OPUPKItem number in contract account documentnvarchar40
4DFKKDFCNTRLControl Table for Transfer Postings3OPUPKItem number in contract account documentnvarchar40
5DFKKEPRTLog for Inconsistent FI-CA Documents5OPUPKItem number in contract account documentnvarchar40
6DFKKODNREPOfficial Document Number for Reporting5OPUPKItem number in contract account documentnvarchar40
7DFKKOP_DPDown Payments: Tax Data for Business Partner Item4OPUPKItem number in contract account documentnvarchar40
8DFKKPDCFI-CA: Postdated Checks21OPUPKItem number in contract account documentnvarchar40
9DFKKPDCSFI-CA: Status Changes for Postdated Checks10OPUPKItem number in contract account documentnvarchar40
10DFKKPICLARIFClarification Work List for Penalty and Interest4OPUPKItem number in contract account documentnvarchar40
11DFKKPICLARIFITPenalty and Interest Clarification Case: Processed objects4OPUPKItem number in contract account documentnvarchar40
12DFKKPICLARIFITAPenalty and Interest Clarification Case: Mass Processes Log4OPUPKItem number in contract account documentnvarchar40
13DFKKPRNDSEPA: Direct Debit Pre-Notification (FI-CA) Deleted Items5OPUPKItem number in contract account documentnvarchar40
14DFKK_ACCADJAdjustment Postings when Implementing Acct Assgmt Chars21OPUPKItem number in contract account documentnvarchar40
15DFKK_NEWACCADJObsolete: See DFKK_ACCADJ21OPUPKItem number in contract account documentnvarchar40
16DFKK_TRIGX_CLOutbound Interface: New Trigger Table of Cleared Items3OPUPKItem number in contract account documentnvarchar40
17DFKK_TRIGX_RCLOI: New Trigger Table for Reopened Items3OPUPKItem number in contract account documentnvarchar40
18FKKID_EXP_HDR_ACr.Mem.&Exp.Conf.: Export Confirmation Header3OPUPKItem number in contract account documentnvarchar40
19FKKID_EXP_ITM_ACr.Mem.&Exp.Conf.: Export Confirmation Items3OPUPKItem number in contract account documentnvarchar40
20FKKID_VAT_ITM_ACr.Mem.&Exp.Conf.: VAT Transfer Items11OPUPKItem number in contract account documentnvarchar40
21FKKSK_VATLEDFI-CA Slovakia: VAT Ledger Exported Data8OPUPKItem number in contract account documentnvarchar40
22FKKSK_VATLED_D2FI-CA Slovakia: VAT Ledger Section D2 records(keys)8OPUPKItem number in contract account documentnvarchar40
TOPCollectionsDisbursements
23IBROSTMSISCD: Broker Report - Selected Items Related to an Item7OPUPKItem number in contract account documentnvarchar40
24ITAGCYAGENCYFIAgency Collections: Data for Transfer to Agency FI4OPUPKItem number in contract account documentnvarchar40
25ITAGCYPYMETSETSetting Payment Methods in Agency Collections6OPUPKItem number in contract account documentnvarchar40
26ITAGCYSUBCOMMTRGTrigger Table for Posting and Transferring Subcommission4OPUPKItem number in contract account documentnvarchar40
27TKKV_VZK_LINKLink Table Document <> Additional Acct Assignment for Ins.3OPUPKItem number in contract account documentnvarchar40
28VVKKCFRECCash Receipts to be Transferred to Claims System4OPUPKItem number in contract account documentnvarchar40
29VVKKDRZEDunning Notice Output: Repetition Items10OPUPKItem number in contract account documentnvarchar40
30VVKKEXPTRIGGERTrigger for Expiry Notes7OPUPKItem number in contract account documentnvarchar40
31VVKKFAPOSInvoicing Items in FS-CD5OPUPKItem number in contract account documentnvarchar40
32VVKKMHISTContract-Related Dunning History33OPUPKItem number in contract account documentnvarchar40
33VVKKREPCLMoney Laundering Clarification Worklist3OPUPKItem number in contract account documentnvarchar40
34VVKKREPCL_REPFS-CD: Money Laundering Law Reporting State3OPUPKItem number in contract account documentnvarchar40
35VVKKREPRPCoinsurance Reporting: Recording Item OBSOLETE8OPUPKItem number in contract account documentnvarchar40
36VVSCCLINFOBill Scheduling: Clearing Information4OPUPKItem number in contract account documentnvarchar40
37VVSCITEMBill Scheduling: Scheduling Document10OPUPKItem number in contract account documentnvarchar40
38VVSCITEM_MANScheduling Items: Temp. Storage for Manual -> Auto Change10OPUPKItem number in contract account documentnvarchar40
39VVSCRESPAYMENTBill Scheduling: Universal Life8OPUPKItem number in contract account documentnvarchar40
40VVSCULCFCCustomer-Initiated Payment Clearing6OPUPKItem number in contract account documentnvarchar40
TOPContract Accounts Receivable and Payable
41DFKCRPOClarification Worklist Credit3OPUPKItem number in contract account documentnvarchar40
42DFKK10991099 Statutory Reporting Data5OPUPKItem number in contract account documentnvarchar40
43DFKKCASEITEMSItem List in Cases, Lines5OPUPKItem number in contract account documentnvarchar40
44DFKKCFPAYRUNClarif. Worklist: Payment Program (Obsolete)8OPUPKItem number in contract account documentnvarchar40
45DFKKCFPAYRUN2Calrification Worklist: Payment Program (New Version)8OPUPKItem number in contract account documentnvarchar40
46DFKKDEFREV_POSLine Item Table (Event-Based Deferred Revenues)6OPUPKItem number in contract account documentnvarchar40
47DFKKDOUBTD_WBuffer: Create Printout for Receivables Adjustment8OPUPKItem number in contract account documentnvarchar40
48DFKKEWUDOCCRITEuro: Critical Documents in Conversion6OPUPKItem number in contract account documentnvarchar40
49DFKKFHFI-CA: Table of Fine History4OPUPKItem number in contract account documentnvarchar40
50DFKKFWTRIGTrigger Table for Inverse Postings3OPUPKItem number in contract account documentnvarchar40
51DFKKIAFI-CA: Database table for FKKIA - intrst supp6OPUPKItem number in contract account documentnvarchar40
52DFKKIAPTInterest Calculation: Log for Interest Run10OPUPKItem number in contract account documentnvarchar40
53DFKKIHFI-CA: Table with Interest History4OPUPKItem number in contract account documentnvarchar40
54DFKKIPBW_ITEMInstallment Plan Items for Business Warehouse4OPUPKItem number in contract account documentnvarchar40
55DFKKIPBW_ORIGInstallment Plan Original Items for Business Warehouse4OPUPKItem number in contract account documentnvarchar40
56DFKKIP_ITMPayment Specification: Related Items5OPUPKItem number in contract account documentnvarchar40
57DFKKIP_ITMHPayment Specification: Deletions Not Yet Confirmed5OPUPKItem number in contract account documentnvarchar40
58DFKKIP_ITMVPayment Specification: Preselected Items4OPUPKItem number in contract account documentnvarchar40
59DFKKMOPItems in contract account document4OPUPKItem number in contract account documentnvarchar40
60DFKKMOPKItems in contract account document3OPUPKItem number in contract account documentnvarchar40
61DFKKOPItems in contract account document4OPUPKItem number in contract account documentnvarchar40
62DFKKOPAADistribution Items with Account Assignment3OPUPKItem number in contract account documentnvarchar40
63DFKKOPBEWFI-CA Foreign Currency Valuation3OPUPKItem number in contract account documentnvarchar40
64DFKKOPBEW_LDFI-CA Ledger-Specific Foreign Currency Valuation3OPUPKItem number in contract account documentnvarchar40
65DFKKOPCOLLCollection: Log of Receivables Submitted8OPUPKItem number in contract account documentnvarchar40
66DFKKOPEWBusiness Partner Items: Amounts Before Euro Conversion4OPUPKItem number in contract account documentnvarchar40
67DFKKOPKItems in contract account document3OPUPKItem number in contract account documentnvarchar40
68DFKKOPKCCard Data Appendix for FICA Document3OPUPKItem number in contract account documentnvarchar40
69DFKKOPKC_ERRError Table for Payment Card Billing3OPUPKItem number in contract account documentnvarchar40
70DFKKOPKC_RESENDCard Data Supplement: Status After Resend3OPUPKItem number in contract account documentnvarchar40
71DFKKOPKEWG/L Account Items: Amounts Before Euro Conversion3OPUPKItem number in contract account documentnvarchar40
72DFKKOPKXItems for Contract Accounting Document (Enhancement)3OPUPKItem number in contract account documentnvarchar40
73DFKKOPK_SHORTOffsetting Items for FI-CA Document - Extracts5OPUPKItem Number in Contract Account Documentnvarchar110
74DFKKOPK_TEXT_GLText G/L Item3OPUPKItem number in contract account documentnvarchar40
75DFKKOPLLocks for Open Items (Change Document Interface)3OPUPKItem number in contract account documentnvarchar40
76DFKKOPVZAgreed Payment Amounts3OPUPKItem number in contract account documentnvarchar40
77DFKKOPWHWithholding Tax Data for Business Partner Item4OPUPKItem number in contract account documentnvarchar40
78DFKKOP_REPOpen Items from FPO48OPUPKItem number in contract account documentnvarchar40
79DFKKOP_SHORTPartner Items for FI-CA Document - Extracts5OPUPKItem Number in Contract Account Documentnvarchar110
80DFKKPPIOpen Items for Promise to Pay, with Amount5OPUPKItem number in contract account documentnvarchar40
81DFKKPPPPayment Assignments to Promises to Pay5OPUPKItem number in contract account documentnvarchar40
82DFKKRAPClearing/Reversal History (Line Item Level) < 4.624OPUPKItem number in contract account documentnvarchar40
83DFKKRAPTClearing/Reversal History (Line Item Level)4OPUPKItem number in contract account documentnvarchar40
84DFKKRDIRevenue Distribution7OPUPKItem number in contract account documentnvarchar40
85DFKKREP06Tax Report Data (Invoicing Time or Triggered)3OPUPKItem Number in Contract Account Documentnvarchar40
86DFKKREP06_STax Report Data - Shadow Table for Posting Date3OPUPKItem Number in Contract Account Documentnvarchar40
87DFKKREP07Tax Report Data (Clearing Time)3OPUPKItem number in contract account documentnvarchar40
88DFKKREP07_TTax Report Data (Additional Data for Transfer Posting)3OPUPKItem number in contract account documentnvarchar40
89DFKKREPAPRecording Record8OPUPKItem number in contract account documentnvarchar40
90DFKKREPTCLClearing Information for Receipt Documents5OPUPKItem number in contract account documentnvarchar40
91DFKKREPTDAdjusted Tax Data (Currently Not Used)4OPUPKItem number in contract account documentnvarchar40
92DFKKRESReserve Postings5OPUPKItem number in contract account documentnvarchar40
93DFKKREV06Report for Tax on Sales/Purchases (bill. time or triggered)3OPUPKItem number in contract account documentnvarchar40
94DFKKREV07Report on Tax on Sales/Purchases (clearing time)3OPUPKItem number in contract account documentnvarchar40
95DFKKSUMPosting totals from FI-CA13OPUPKItem number in contract account documentnvarchar40
96DFKKTHITransfer Records for Invoice Issue by Third Party4OPUPKItem number in contract account documentnvarchar40
97DFKKTHI_HISTHistorical Entries of DFKKTHI5OPUPKItem number in contract account documentnvarchar40
98DFKKTHI_HIST2Reversal: Historical Entries DFKKTHI (w/o Tax Posting)5OPUPKItem number in contract account documentnvarchar40
99DFKKTHPTransfer Records for Billing on Behalf of 3rd Party4OPUPKItem number in contract account documentnvarchar40
100DFKKVBUND_REVVBUND Adjustments for Revenues and Expenses3OPUPKItem number in contract account documentnvarchar40
101DFKKWLI_ILItem List of Work Item5OPUPKItem number in contract account documentnvarchar40
102DFKKWOHWrite-Off History5OPUPKItem number in contract account documentnvarchar40
103DFKKWOHTMPTemporary Write-Off History4OPUPKItem number in contract account documentnvarchar40
104DFKKWO_PROTLine Items Written Off from Mass Run6OPUPKItem number in contract account documentnvarchar40
105DFKKWRTOFF_WFFI-CA Data for Write-Off in Workflow5OPUPKItem number in contract account documentnvarchar40
106DFKKZRPayment form4OPUPKItem number in contract account documentnvarchar40
107DFKKZWDoubtful/Individual Val. Adjust. for Receivables - Trigger4OPUPKItem number in contract account documentnvarchar40
108DFKKZW2Doubtful/Indiv. Val. Adjustments for Receivables - Tfr Pstg4OPUPKItem number in contract account documentnvarchar40
109DFKKZWFHDoubtful/Individually Adjusted Receivables: History4OPUPKItem number in contract account documentnvarchar40
110DFKKZWFPDoubtful/Individually Adjusted Receivables: Tfrd Receivables4OPUPKItem number in contract account documentnvarchar40
111DFKKZWFTDoubtful/Individually Adjusted Receivables: Trigger Table4OPUPKItem number in contract account documentnvarchar40
112DFKKZWHDoubtful/Ind.Val.Adj.Receivables - History4OPUPKItem number in contract account documentnvarchar40
113DFKK_IPL_ITEMSInstallment Plan Key Date Recording (Original Items)5OPUPKItem number in contract account documentnvarchar40
114DFKK_PYREFPayment Reference5OPUPKItem number in contract account documentnvarchar40
115DFKK_TRIGGER_CLOutbound Interface: Trigger Table of Cleared Items3OPUPKItem number in contract account documentnvarchar40
116DFKK_TRIGGER_RCLOutbound Interface: Trigger Table for Reopened Items3OPUPKItem number in contract account documentnvarchar40
117FKKDEFREVTrigger Table for Deferred Revenue Postings3OPUPKItem number in contract account documentnvarchar40
118FKKMAZEDunning history of line items9OPUPKItem number in contract account documentnvarchar40
119FKK_INSTPLN_HISTInstallment Plan History3OPUPKItem number in contract account documentnvarchar40
120FKK_INSTPLN_INVHHistory of Installment Plan Due Dates from Invoicing3OPUPKItem number in contract account documentnvarchar40
121FKK_IP_DEACT_DBInstallment Plan Deactivation History3OPUPKItem number in contract account documentnvarchar40
122FKK_KONTL_LINKLink Table: Document <> Variable Additional Account Assigmts3OPUPKItem number in contract account documentnvarchar40
123FKK_UMBPOSHistory of Document Transfer to Another Account5OPUPKItem number in contract account documentnvarchar40
124IST_LOCK_PROP_DBDis/Reconnection Proposals Table for IS-T Services in RM-CA3OPUPKItem number in contract account documentnvarchar40
125IST_WLTELIS-T/CA: Work List: Reconnect Tel. No. <- Post Document 00206OPUPKItem number in contract account documentnvarchar40
TOPContract Billing
126EPPMDEBTOPBELNRDocuments Transferred to PPM8OPUPKItem number in contract account documentnvarchar40
TOPFinancial Services Localization
127/GSINS/UPR_DEFREUPR - Calculation of unearned insurance premium reserve7OPUPKItem number in contract account documentnvarchar40
128/GSINS/UPR_FKUPRUPR - Calculation of unearned insurance premium reserve6OPUPKItem number in contract account documentnvarchar40
TOPIntercompany Data Exchange
129IUEEDPPLOTATREF3Distribution of Aggr. Payments: Admission Amts for Dist. Lot4OPUPKItem number in contract account documentnvarchar40
130TINV_BW_TRIG_THITrigger for Delta Extraction of Transfer Recs f. Third Party4OPUPKItem number in contract account documentnvarchar40
TOPInvoicing
131DEABPSCustomer change table: Logical view of BB amounts4OPUPKItem number in contract account documentnvarchar40
TOPInvoicing in Contract Accounts Receivable and Payable
132DFKKINVDOC_CInvoicing Document: Charges and Discounts4OPUPKItem number in contract account documentnvarchar40
133DFKKINVDOC_CHInvoicing Document: Charges and Discounts History Record4OPUPKItem number in contract account documentnvarchar40
134DFKKINVDOC_PInvoicing: Posting Document Reference Table7OPUPKItem number in contract account documentnvarchar40
135DFKKINV_OTRIGOrder for Offsetting in Invoicing16OPUPKItem number in contract account documentnvarchar40
TOPLease Accounting
136/LSIERP/TRIG_NALeases Not Set to Non-Accrual5OPUPKItem number in contract account documentnvarchar40
137/LSIERP/WLI_ILItem List of Work Item5OPUPKItem number in contract account documentnvarchar40
TOPPublic Sector Contract Accounts Receivable and Payable
138DFMCAINVPOSInvoice in IS-PS-CA: Items5OPUPKItem number in contract account documentnvarchar40
139DFMCA_OP_REFDOCItems in contract account document of a Form Bundle3OPUPKItem number in contract account documentnvarchar40