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

149 columns | Print definition?ERP 6.0  | VTREF

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1DFKKBIX_RERATEReversal Request for Billable Items4VTREFReference Specifications from Contractnvarchar200
2DFKKCFKWLKWL: KPI Cockpit Worklist7VTREFReference Specifications from Contractnvarchar200
3DFKKPICLARIFClarification Work List for Penalty and Interest9VTREFReference Specifications from Contractnvarchar200
4DFKK_BIT_TESTTest Data for BITs7VTREFIdentification of a Provider Contractnvarchar200
5DFKK_TRIGX_CLOutbound Interface: New Trigger Table of Cleared Items9VTREFReference Specifications from Contractnvarchar200
6DFKK_TRIGX_OPOutbound Interface: New Trigger Table for Business Partner4VTREFReference Specifications from Contractnvarchar200
7DFKK_TRIGX_PAYOutbound Interface: New Trigger Table for Payment Info6VTREFReference Specifications from Contractnvarchar200
8DFKK_TRIGX_RCLOI: New Trigger Table for Reopened Items11VTREFReference Specifications from Contractnvarchar200
9ITAGCYTCBPAgency Collections: Temporary Collections with BP4VTREFReference Specifications from Contractnvarchar200
TOPBilling
10VBRKBilling Document: Header Data99VTREFReference Specifications from Contractnvarchar200
TOPBilling in Contract Accounts Receivable and Payable
11DFKKBIBILLACC_HBilling Account Header8VTREFReference Specifications from Contractnvarchar200
12DFKKBIXBIT_REVReversal Request for Billable Items11VTREFReference Specifications from Contractnvarchar200
TOPBusiness Partner
13DFKKBPCLBusiness Partner Duplicates: Predecessor - Successor4VTREFReference Specifications from Contractnvarchar200
14DFKKBPCL_ACTBusiness Partner Duplicates: Status of Activities7VTREFReference Specifications from Contractnvarchar200
15DFKKBPCL_IMPIImport of Master Data Combinations of BP Duplicates5VTREFReference Specifications from Contractnvarchar200
TOPCollectionsDisbursements
16DIMACOPASTReversal of Contracts in CO-PA2VTREFReference Specifications from Contractnvarchar200
17DIMAPARSCPOSIO: Change to Scheduling Items3VTREFReference Specifications from Contractnvarchar200
18DVIINFOInformation Data12VTREFIdentification for an Insurance Objectnvarchar200
19FSCD_TRI_DEFRAGTrigger Table for Mass Activity: Clearing Oldest Debt2VTREFReference Specifications from Contractnvarchar200
20PPPOS_REVPayment Plan: Reversal Table for Payment Plan Item3VTREFReference Specifications from Contractnvarchar200
21PPPOS_REV_DETAPayment Plan: Reversal Table Detail Payment Plan Item3VTREFReference Specifications from Contractnvarchar200
22VINTEGBALANCEDTrigger for Fully Cleared Documents3VTREFReference Specifications from Contractnvarchar200
23VKKQUOTSQuotation Monitoring FS-CD Acceptance Status4VTREFReference Specifications from Contractnvarchar200
24VVKKBILLCLARFS-CD: Clarification Cases Premium Rec. for Auto Clearing2VTREFReference Specifications from Contractnvarchar200
25VVKKBILLSTATClearing Status for Contract Account4VTREFReference Specifications from Contractnvarchar200
26VVKKBILLTRIGPremium Request for Automatic Clearing: Trigger4VTREFReference Specifications from Contractnvarchar200
27VVKKCFCSTELInsurance Dunning: Telephone Collections7VTREFReference Specifications from Contractnvarchar200
28VVKKCFRECCash Receipts to be Transferred to Claims System10VTREFReference Specifications from Contractnvarchar200
29VVKKCPHCurrent Policyholder2VTREFReference Specifications from Contractnvarchar200
30VVKKDRKODunning Printout:Header Items8VTREFReference Specifications from Contractnvarchar200
31VVKKDRZEDunning Notice Output: Repetition Items12VTREFReference Specifications from Contractnvarchar200
32VVKKEXPTRIGGERTrigger for Expiry Notes4VTREFReference Specifications from Contractnvarchar200
33VVKKFAPOSInvoicing Items in FS-CD13VTREFReference Specifications from Contractnvarchar200
34VVKKFKODoc Header Posting Data Interface25VTREFReference Specifications from Contractnvarchar200
35VVKKFKOTTable for FS-CD Test Data of Structure vkkkfko20VTREFReference Specifications from Contractnvarchar200
36VVKKFOPSingle Doc in Posting Data Interface33VTREFReference Specifications from Contractnvarchar200
37VVKKFOPTTable for FS-CD Test Data of Structure VKKKFOP31VTREFReference Specifications from Contractnvarchar200
38VVKKICLARIOBSec. Acct Int. Calc. Acc. to Ins. Obj.: Clarification Cases3VTREFReference Specifications from Contractnvarchar200
39VVKKIHISTIOBSec. Acct Int. Calc. Acc. to Ins. Obj.: History (Detail)3VTREFReference Specifications from Contractnvarchar200
40VVKKMAKTExecuted Dunning Activities10VTREFReference Specifications from Contractnvarchar200
41VVKKMHISTContract-Related Dunning History2VTREFReference Specifications from Contractnvarchar200
42VVKKREPCLMoney Laundering Clarification Worklist9VTREFReference Specifications from Contractnvarchar200
43VVKKREPCL_REPFS-CD: Money Laundering Law Reporting State9VTREFReference Specifications from Contractnvarchar200
44VVKKREPNHCoinsurance Reporting: Report Header OBSOLETE6VTREFReference Specifications from Contractnvarchar200
45VVKKREPNPCoinsurance Reporting: Report Item OBSOLETE6VTREFReference Specifications from Contractnvarchar200
46VVKKREPRHCoinsurance Reporting: Recording Header OBSOLETE8VTREFReference Specifications from Contractnvarchar200
47VVKKREPRPCoinsurance Reporting: Recording Item OBSOLETE6VTREFReference Specifications from Contractnvarchar200
48VVKKRESETTAXItalian Taxes - Trigger Table for Correction Run9VTREFReference Specifications from Contractnvarchar200
49VVKKRESETTAXSCItalian Taxes - Assignment of Old/New Payment Plan Items3VTREFReference Specifications from Contractnvarchar200
50VVKKTAXREPTax Reporting ITA: Data for Tax Report13VTREFReference Specifications from Contractnvarchar200
51VVKKTRIMATrigger for Checking Dunning Status4VTREFReference Specifications from Contractnvarchar200
52VVKKVSNTTrigger for FS-CD Interface to VTG (EA Generali)3VTREFReference Specifications from Contractnvarchar200
53VVKK_TRANSF_REFDocument References for FPU53VTREFReference Specifications from Contractnvarchar200
54VVSCITEMBill Scheduling: Scheduling Document3VTREFReference Specifications from Contractnvarchar200
55VVSCITEMLBill Scheduling: for General Ledger3VTREFReference Specifications from Contractnvarchar200
56VVSCITEMWHPayment Plan Subitem: Variable Withholding Tax Supplements3VTREFReference Specifications from Contractnvarchar200
57VVSCITEM_MANScheduling Items: Temp. Storage for Manual -> Auto Change3VTREFReference Specifications from Contractnvarchar200
58VVSCLOCKAMTScheduling: Premium Lock Period Share Already Transferred3VTREFReference Specifications from Contractnvarchar200
59VVSCPOSPayment Plan Item3VTREFReference Specifications from Contractnvarchar200
60VVSCPOSCOINSPayment Plan Item Supplement: Coinsurance Shares3VTREFReference Specifications from Contractnvarchar200
61VVSCPOSESRPayment Plan Item: ISR Attachment3VTREFReference Specifications from Contractnvarchar200
62VVSCPOSETAXPayment Plan Items Supplement: Ext. Calculated Tax Data3VTREFReference Specifications from Contractnvarchar200
63VVSCPOSICDRPayment Plan Item: Data for ICDR Service3VTREFReference Specifications from Contractnvarchar200
64VVSCPOSWHPayment Plan Item: Variable Withholding Tax Supplements3VTREFReference Specifications from Contractnvarchar200
65VVSCRESPAYMENTBill Scheduling: Universal Life3VTREFReference Specifications from Contractnvarchar200
66VVSCTRANSFERPayment Plan: Business Partner Transfer2VTREFReference Specifications from Contractnvarchar200
TOPContract Accounts Receivable and Payable
67DFK006ENote to Payee - Accounts8VTREFReference Specifications from Contractnvarchar200
68DFK006EXNote to Payee - Accounts New6VTREFReference Specifications from Contractnvarchar200
69DFKCRPOClarification Worklist Credit8VTREFReference Specifications from Contractnvarchar200
70DFKKCFDUNTELTelephone List for Dunning10VTREFReference Specifications from Contractnvarchar200
71DFKKCFNRClarification Cases from NOC Returns Lot9VTREFReference Specifications from Contractnvarchar200
72DFKKCFPAYRUNClarif. Worklist: Payment Program (Obsolete)5VTREFReference Specifications from Contractnvarchar200
73DFKKCFPAYRUN2Calrification Worklist: Payment Program (New Version)5VTREFReference Specifications from Contractnvarchar200
74DFKKCMPManually Issued Checks Lot: Item Data21VTREFReference Specifications from Contractnvarchar200
75DFKKCOMACorrespondence Dunning9VTREFReference Specifications from Contractnvarchar200
76DFKKDDADebit Memo Notification23VTREFReference Specifications from Contractnvarchar200
77DFKKDOCFI-CA DMS: Administrative Data of Documents9VTREFReference Specifications from Contractnvarchar200
78DFKKINFCOInformation Container7VTREFReference Specifications from Contractnvarchar200
79DFKKINFCOTInformation Container: Entries from Test8VTREFReference Specifications from Contractnvarchar200
80DFKKIP_ITMPayment Specification: Related Items9VTREFReference Specifications from Contractnvarchar200
81DFKKIP_ITMHPayment Specification: Deletions Not Yet Confirmed11VTREFReference Specifications from Contractnvarchar200
82DFKKIP_ITMVPayment Specification: Preselected Items8VTREFReference Specifications from Contractnvarchar200
83DFKKMOPItems in contract account document13VTREFReference Specifications from Contractnvarchar200
84DFKKNRPNOC Returns Lot: Item Data13VTREFReference Specifications from Contractnvarchar200
85DFKKOPItems in contract account document13VTREFReference Specifications from Contractnvarchar200
86DFKKOPCOLLCollection: Log of Receivables Submitted14VTREFReference Specifications from Contractnvarchar200
87DFKKOP_REPOpen Items from FPO417VTREFReference Specifications from Contractnvarchar200
88DFKKOP_SHORTPartner Items for FI-CA Document - Extracts16VTREFReference Specifications from Contractnvarchar200
89DFKKORDERPOSRequests: Items8VTREFReference Specifications from Contractnvarchar200
90DFKKORDERPOS_SRequest Templates: Items8VTREFReference Specifications from Contractnvarchar200
91DFKKORDERVTREFAssign VTREF to ORDNR for General Requests2VTREFReference Specifications from Contractnvarchar200
92DFKKPPIOpen Items for Promise to Pay, with Amount12VTREFReference Specifications from Contractnvarchar200
93DFKKPPROPEXCExceptions for Due Date Determination and Last Payments4VTREFReference Specifications from Contractnvarchar200
94DFKKQSRIndividual Records for Withholding Tax Report22VTREFReference Specifications from Contractnvarchar200
95DFKKRDIRevenue Distribution13VTREFReference Specifications from Contractnvarchar200
96DFKKREPAKRecording Header8VTREFReference Specifications from Contractnvarchar200
97DFKKREPAPRecording Record5VTREFReference Specifications from Contractnvarchar200
98DFKKREPMHNotification Header5VTREFReference Specifications from Contractnvarchar200
99DFKKREPMPReport Item6VTREFReference Specifications from Contractnvarchar200
100DFKKREPTCLClearing Information for Receipt Documents10VTREFReference Specifications from Contractnvarchar200
101DFKKRP3Returns: Manual Posting Specifications7VTREFReference Specifications from Contractnvarchar200
102DFKKRP3HReturns: History for Manual Posting Items7VTREFReference Specifications from Contractnvarchar200
103DFKKTHITransfer Records for Invoice Issue by Third Party14VTREFReference Specifications from Contractnvarchar200
104DFKKTHPTransfer Records for Billing on Behalf of 3rd Party13VTREFReference Specifications from Contractnvarchar200
105DFKKWO_PROTLine Items Written Off from Mass Run12VTREFReference Specifications from Contractnvarchar200
106DFKKWRTOFF_WFFI-CA Data for Write-Off in Workflow11VTREFReference Specifications from Contractnvarchar200
107DFKK_TRIGGER_CLOutbound Interface: Trigger Table of Cleared Items8VTREFReference Specifications from Contractnvarchar200
108DFKK_TRIGGER_OPOutbound Interface: Trigger Table for Business Partner4VTREFReference Specifications from Contractnvarchar200
109DFKK_TRIGGER_PAYOutbound Interface: Trigger Table for Payment Information6VTREFReference Specifications from Contractnvarchar200
110DFKK_TRIGGER_RCLOutbound Interface: Trigger Table for Reopened Items10VTREFReference Specifications from Contractnvarchar200
111DPAYDPayment Program - Payments (Check of Direct Debit Limit)6VTREFReference Specifications from Contractnvarchar200
112DPAYPPayment program - data on paid item49VTREFReference Specifications from Contractnvarchar200
113FKKMAKODunning History Header32VTREFReference Specifications from Contractnvarchar200
114FKKMAZEDunning history of line items28VTREFReference Specifications from Contractnvarchar200
115FKK_INSTPLN_HEADHeader Data for Installment Plan16VTREFReference Specifications from Contractnvarchar200
116FKK_UMBHIHistory of Transfer to Another Account5VTREFReference Specifications from Contractnvarchar200
117IST_BTACTIS-T Disconnection Number: Disconnection Activity10VTREFReference Specifications from Contractnvarchar200
118IST_WLTELIS-T/CA: Work List: Reconnect Tel. No. <- Post Document 002010VTREFReference Specifications from Contractnvarchar200
119TFK006XSException Accounts for Clarification Proposal8VTREFReference Specifications from Contractnvarchar200
120TFK006YSIBAN Exceptions for Clarification Proposal6VTREFReference Specifications from Contractnvarchar200
TOPCorrespondence Tool
121DFKKCOHCorrespondence - Correspondence Header16VTREFReference Specifications from Contractnvarchar200
122DFKKCOHICorrespondence - Correspondence History9VTREFReference Specifications from Contractnvarchar200
TOPFinancial Services Localization
123/GSINS/UPR_DEFREUPR - Calculation of unearned insurance premium reserve10VTREFReference Specifications from Contractnvarchar200
124/GSINS/UPR_FKUPRUPR - Calculation of unearned insurance premium reserve12VTREFReference Specifications from Contractnvarchar200
TOPIntercompany Data Exchange
125EPAYTHPIDE: transfer records for third party payments13VTREFReference Specifications from Contractnvarchar200
126TINV_INV_DOCBilling Doc. Data16VTREFReference Specifications from Contractnvarchar200
127TINV_INV_LINE_APayment Advice Line27VTREFReference Specifications from Contractnvarchar200
128TINV_INV_TRANSFTransfer Table for Bill Data to FI-CA25VTREFReference Specifications from Contractnvarchar200
TOPInvoicing
129DEABPSCustomer change table: Logical view of BB amounts10VTREFReference Specifications from Contractnvarchar200
130EABPLSample Lines for Budget Billing Plan6VTREFReference Specifications from Contractnvarchar200
131EABPS_CORRSub Budget Billing Plan for Correspondence Print6VTREFReference Specifications from Contractnvarchar200
TOPInvoicing in Contract Accounts Receivable and Payable
132DFKKINVBILL_IBilling Document Items47VTREFReference Specifications from Contractnvarchar200
133DFKKINVDOC_IItems of Invoicing Document7VTREFReference Specifications from Contractnvarchar200
134DFKKINV_CFCClarification Case Invoicing11VTREFReference Specifications from Contractnvarchar200
135DFKKINV_OTRIGOrder for Offsetting in Invoicing9VTREFReference Specifications from Contractnvarchar200
136DFKKINV_TRIGInvoicing Order19VTREFReference Specifications from Contractnvarchar200
TOPLease Accounting
137/LSIERP/WLI_ILItem List of Work Item13VTREFReference Specifications from Contractnvarchar200
TOPPublic Sector Contract Accounts Receivable and Payable
138DFMCAILOTPSCD: Approval List Installment Plans16VTREFReference Specifications from Contractnvarchar200
139DFMCAINVInvoice in IS-PS-CA: Header Data8VTREFReference Specifications from Contractnvarchar200
140DFMCA_BRF090BRF: Parameter for Settings Inbound Corresp. to Completed9VTREFBRF: Expressionnvarchar200
141DFMCA_BRF152BRF: Parameters for Calculation Line Items10VTREFBRF Expression: Contract Object for Credit Postingnvarchar200
142DFMCA_BRF610BRF: Clear Inbound Correspondence Request9VTREFBRF Expression: Contract Objectnvarchar200
143DFMCA_CRPAApproval List for Document Changes10VTREFReference Specifications from Contractnvarchar200
144DPSOB_BILLTRIGTrigger for TRM Billing4VTREFReference Specifications from Contractnvarchar200
145TFMCA_BRF215BRF: Parameter for Revenue Distribution9VTREFBRF: Expressionnvarchar200
146TFMCA_BRF217BRF: Parameter for Settings Inbound Corresp. to Completed10VTREFBRF: Expressionnvarchar200
147TFMCA_BRF221BRF: Parameters for Calculation Line Items11VTREFBRF Expression: Contract Object for Credit Postingnvarchar200
TOPSales
148VBKDSales Document: Business Data85VTREFReference Specifications from Contractnvarchar200
TOPSecurity Deposits
149FKK_SEC_CContracts for Security Deposit3VTREFReference Specifications from Contractnvarchar200