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

161 columns | Print definition?ERP 6.0  | BETRW

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/1RA/0SD010COItems for Class SD01 - Raw Data11BETRWAmount in Transaction Currencydecimal232
2/1RA/0SD012COItems for Class SD01 - Processable11BETRWAmount in Transaction Currencydecimal232
3/1RA/0SD014COItems for Class SD01 - Processed11BETRWAmount in Transaction Currencydecimal232
4/1RA/0SD020COItems for Class SD02 - Raw Data11BETRWAmount in Transaction Currencydecimal232
5/1RA/0SD022COItems for Class SD02 - Processable11BETRWAmount in Transaction Currencydecimal232
6/1RA/0SD024COItems for Class SD02 - Processed11BETRWAmount in Transaction Currencydecimal232
7/1RA/0SD030COItems for Class SD03 - Raw Data11BETRWAmount in Transaction Currencydecimal232
8/1RA/0SD032COItems for Class SD03 - Processable11BETRWAmount in Transaction Currencydecimal232
9/1RA/0SD034COItems for Class SD03 - Processed11BETRWAmount in Transaction Currencydecimal232
10DBERDTAX_ADDAdditional Information for Print Document Tax Indicator7BETRWAmount in Transaction Currency with +/- Signdecimal132
11DFKKCFKWLKWL: KPI Cockpit Worklist14BETRWAmount in Transaction Currency with +/- Signdecimal132
12DFKKCJT_WDRWHCash Journal: Historical Data for Withdrawal Posting8BETRWAmount in Transaction Currency with +/- Signdecimal132
13DFKKEPRTLog for Inconsistent FI-CA Documents23BETRWAmount in Transaction Currency with +/- Signdecimal132
14DFKKOPK_USTPDHelp Table for Taxes When Writing Off US SALES TAXES5BETRWAmount in Transaction Currency with +/- Signdecimal132
15DFKKPRNDSEPA: Direct Debit Pre-Notification (FI-CA) Deleted Items11BETRWAmount in Transaction Currency with +/- Signdecimal132
16DFKKPRNHSEPA: Direct Debit Pre-Notifications (FI-CA)9BETRWAmount in Transaction Currency with +/- Signdecimal132
17DFKK_ACCADJAdjustment Postings when Implementing Acct Assgmt Chars13BETRWAmount in Transaction Currency with +/- Signdecimal132
18DFKK_NEWACCADJObsolete: See DFKK_ACCADJ13BETRWAmount in Transaction Currency with +/- Signdecimal132
19DFKK_TRIGX_PAYOutbound Interface: New Trigger Table for Payment Info14BETRWAmount in Transaction Currency with +/- Signdecimal132
20FARR_D_INVOICEInvoice Entries10BETRWAmount in Transaction Currencydecimal232
21FARR_D_POSTINGPosting table10BETRWAmount in Transaction Currencydecimal232
22FKKID_EXP_HDR_ACr.Mem.&Exp.Conf.: Export Confirmation Header12BETRWAmount in Transaction Currency with +/- Signdecimal132
23FKKID_VAT_HDR_ACr.Mem.&Exp.Conf.: VAT Transfer Header8BETRWAmount in Transaction Currency with +/- Signdecimal132
24FKKID_VAT_ITM_ACr.Mem.&Exp.Conf.: VAT Transfer Items8BETRWAmount in Transaction Currency with +/- Signdecimal132
25ITAGCYTCBPAgency Collections: Temporary Collections with BP6BETRWAmount in Transaction Currency with +/- Signdecimal132
26T7PIQSINGLEFEESDefine Attributes for Individual Fees4BETRWAmount in Transaction Currency with +/- Signdecimal132
27TCMAC06DDerivation of ISR Scenario Related Data4BETRWAmount in Transaction Currency with +/- Signdecimal132
TOPCollectionsDisbursements
28IBROSTMSISCD: Broker Report - Selected Items Related to an Item9BETRWAmount in Transaction Currency with +/- Signdecimal132
29ITAGCYAGENCYFIAgency Collections: Data for Transfer to Agency FI14BETRWAmount in Transaction Currency with +/- Signdecimal132
30ITAGCYSUBCOMMTRGTrigger Table for Posting and Transferring Subcommission10BETRWAmount in Transaction Currency with +/- Signdecimal132
31VINTEGBALANCEDTrigger for Fully Cleared Documents6BETRWAmount in Transaction Currency with +/- Signdecimal132
32VKKINTERESTHISTInt. Calc. History for Deposit Acct10BETRWAmount in Transaction Currency with +/- Signdecimal132
33VVKKCFRECCash Receipts to be Transferred to Claims System22BETRWAmount in Transaction Currency with +/- Signdecimal132
34VVKKFAPOSInvoicing Items in FS-CD18BETRWAmount in Transaction Currency with +/- Signdecimal132
35VVKKFOPSingle Doc in Posting Data Interface5BETRWAmount in Transaction Currency with +/- Signdecimal132
36VVKKFOPTTable for FS-CD Test Data of Structure VKKKFOP5BETRWPosting Amount with +/- Sign in CHAR Formatnvarchar270
37VVKKIHISTDeposit Acct Interest Calc: History (Detail)11BETRWAmount in Transaction Currency with +/- Signdecimal132
38VVKKIHISTIOBSec. Acct Int. Calc. Acc. to Ins. Obj.: History (Detail)17BETRWAmount in Transaction Currency with +/- Signdecimal132
39VVKKISUMIOBBal. Interest Calc. Acc. to Ins. Obj.: Interest Total8BETRWAmount in Transaction Currency with +/- Signdecimal132
40VVKKKDTRIGTrigger for Cust. Field Check DME Media7BETRWAmount in Transaction Currency with +/- Signdecimal132
41VVKKREPCLMoney Laundering Clarification Worklist15BETRWAmount in Transaction Currency with +/- Signdecimal132
42VVKKREPCL_REPFS-CD: Money Laundering Law Reporting State15BETRWAmount in Transaction Currency with +/- Signdecimal132
43VVSCCLINFOBill Scheduling: Clearing Information8BETRWAmount in Transaction Currency with +/- Signdecimal132
44VVSCRESPAYMENTBill Scheduling: Universal Life12BETRWAmount in Transaction Currency with +/- Signdecimal132
45VVSCULCFCCustomer-Initiated Payment Clearing8BETRWAmount in Transaction Currency with +/- Signdecimal132
TOPContract Accounts Receivable and Payable
46DFKCRPOClarification Worklist Credit14BETRWAmount in Transaction Currency with +/- Signdecimal132
47DFKKCFPAYRUNClarif. Worklist: Payment Program (Obsolete)22BETRWAmount in Transaction Currency with +/- Signdecimal132
48DFKKCFPAYRUN2Calrification Worklist: Payment Program (New Version)20BETRWAmount in Transaction Currency with +/- Signdecimal132
49DFKKCIBWFICA: Extraction of Cleared Items11BETRWAmount in Transaction Currency with +/- Signdecimal152
50DFKKCJTTransaction Data for Cash Journal7BETRWAmount in Transaction Currency with +/- Signdecimal132
51DFKKCMPManually Issued Checks Lot: Item Data24BETRWAmount in Transaction Currency with +/- Signdecimal132
52DFKKCOLFILE_P_WSubm. of Receivable for Collection: Item Buffer8BETRWAmount in Transaction Currency with +/- Signdecimal132
53DFKKCOLI_LOGCollection Agency Information File: Communication Log9BETRWSubmitted Amount (Batch Input)nvarchar160
54DFKKCOLLAdmin. Data for Sumbission of Receivables for Coll. Agency11BETRWAmount in Transaction Currency with +/- Signdecimal132
55DFKKCOLLHManagement Data for Submission to Coll. Agency (History)12BETRWAmount in Transaction Currency with +/- Signdecimal132
56DFKKCOLLPAYMCollection Payments8BETRWAmount in Transaction Currency with +/- Signdecimal132
57DFKKCOLLP_IP_WBuffer: Collection Agency Info File (Item for Payments)16BETRWSubmitted Amount (Batch Input)nvarchar160
58DFKKCOLLP_IR_WBuffer: Collection Agency Info File (Item for Callback)15BETRWSubmitted Amount (Batch Input)nvarchar160
59DFKKCRCASHCR: Cashed Checks Not Yet Entered in Register14BETRWAmount in Transaction Currency with +/- Signdecimal132
60DFKKCRCL_DOCSTable for Checks To Be Clarified13BETRWAmount in Transaction Currency with +/- Signdecimal132
61DFKKDDADebit Memo Notification6BETRWAmount in Transaction Currency with +/- Signdecimal132
62DFKKDEFREV_HEADHeader Table (Event-Based Deferred Revenues)6BETRWAmount in Transaction Currency with +/- Signdecimal132
63DFKKDEFREV_POSLine Item Table (Event-Based Deferred Revenues)11BETRWAmount in Transaction Currency with +/- Signdecimal132
64DFKKDEFREV_TRIGTrigger Table - Amounts (Event-Based Deferred Revenues)6BETRWAmount in Transaction Currency with +/- Signdecimal132
65DFKKDOUBTD_RET_WBuffer: Printout for Ind.Val.Ad - Return Values (User Event)14BETRWAmount in Transaction Currency with +/- Signdecimal132
66DFKKDOUBTD_WBuffer: Create Printout for Receivables Adjustment20BETRWAmount in Transaction Currency with +/- Signdecimal132
67DFKKEXCJCash Journal: Data Store for Inbound Services6BETRWAmount in Transaction Currency with +/- Signdecimal132
68DFKKEXC_PAYINFOInformation for Payment Medium24BETRWAmount in Transaction Currency with +/- Signdecimal132
69DFKKIAFI-CA: Database table for FKKIA - intrst supp15BETRWAmount in Transaction Currency with +/- Signdecimal132
70DFKKIAPTInterest Calculation: Log for Interest Run20BETRWAmount in Transaction Currency with +/- Signdecimal132
71DFKKIPBW_ITEMInstallment Plan Items for Business Warehouse14BETRWAmount in Transaction Currency with +/- Signdecimal132
72DFKKIPBW_ORIGInstallment Plan Original Items for Business Warehouse17BETRWAmount in Transaction Currency with +/- Signdecimal132
73DFKKIP_GRPPayment Specification: Header Data13BETRWPayment Amount of Payment Specificationdecimal132
74DFKKIP_GRPHPayment Specification: Payment Data (History)15BETRWPayment Amount of Payment Specificationdecimal132
75DFKKIP_ITMPayment Specification: Related Items11BETRWAmount in Transaction Currency with +/- Signdecimal132
76DFKKIP_ITMHPayment Specification: Deletions Not Yet Confirmed13BETRWAmount in Transaction Currency with +/- Signdecimal132
77DFKKMOPItems in contract account document42BETRWAmount in Transaction Currency with +/- Signdecimal132
78DFKKMOPKItems in contract account document21BETRWAmount in Transaction Currency with +/- Signdecimal132
79DFKKOPItems in contract account document42BETRWAmount in Transaction Currency with +/- Signdecimal132
80DFKKOPAADistribution Items with Account Assignment6BETRWAmount in Transaction Currency with +/- Signdecimal132
81DFKKOPBWOI Extraction12BETRWAmount in Transaction Currency with +/- Signdecimal152
82DFKKOPCOLLCollection: Log of Receivables Submitted25BETRWAmount in Transaction Currency with +/- Signdecimal132
83DFKKOPKItems in contract account document21BETRWAmount in Transaction Currency with +/- Signdecimal132
84DFKKOPKCCard Data Appendix for FICA Document19BETRWAmount in Transaction Currency with +/- Signdecimal132
85DFKKOPK_SHORTOffsetting Items for FI-CA Document - Extracts9BETRWAmount in Transaction Currency with +/- Signdecimal132
86DFKKOPVZAgreed Payment Amounts9BETRWAmount in Transaction Currency with +/- Signdecimal132
87DFKKOP_REPOpen Items from FPO446BETRWAmount in Transaction Currency with +/- Signdecimal132
88DFKKOP_SHORTPartner Items for FI-CA Document - Extracts13BETRWAmount in Transaction Currency with +/- Signdecimal132
89DFKKORDERPOSRequests: Items22BETRWAmount in Transaction Currency with +/- Signdecimal132
90DFKKORDERPOS_SRequest Templates: Items21BETRWAmount in Transaction Currency with +/- Signdecimal132
91DFKKPC_LOGIPayment Cards: Billing Log (Paid Items)6BETRWAmount in Transaction Currency with +/- Signdecimal132
92DFKKPC_LOGPPayment Cards: Billing Log (Payments)7BETRWAmount in Transaction Currency with +/- Signdecimal132
93DFKKPREPERRFailed Prepaid Balance Changes in SAP CC19BETRWRequested Change of Creditdecimal132
94DFKKQSRIndividual Records for Withholding Tax Report15BETRWAmount in Transaction Currency with +/- Signdecimal132
95DFKKRAPClearing/Reversal History (Line Item Level) < 4.6212BETRWAmount in Transaction Currency with +/- Signdecimal132
96DFKKRAPTClearing/Reversal History (Line Item Level)12BETRWAmount in Transaction Currency with +/- Signdecimal132
97DFKKRDIRevenue Distribution17BETRWAmount in Transaction Currency with +/- Signdecimal132
98DFKKREP02Data for Sales Lists (Belgium)13BETRWAmount in Transaction Currency with +/- Signdecimal132
99DFKKREPTDAdjusted Tax Data (Currently Not Used)9BETRWAmount in Transaction Currency with +/- Signdecimal132
100DFKKRESReserve Postings12BETRWAmount in Transaction Currency with +/- Signdecimal132
101DFKKREV06Report for Tax on Sales/Purchases (bill. time or triggered)13BETRWAmount in Transaction Currency with +/- Signdecimal132
102DFKKREV07Report on Tax on Sales/Purchases (clearing time)14BETRWAmount in Transaction Currency with +/- Signdecimal132
103DFKKRP3Returns: Manual Posting Specifications17BETRWAmount in Transaction Currency with +/- Signdecimal132
104DFKKRP3HReturns: History for Manual Posting Items13BETRWAmount in Transaction Currency with +/- Signdecimal132
105DFKKSUMPosting totals from FI-CA48BETRWAmount in Transaction Currency with +/- Signdecimal132
106DFKKTHITransfer Records for Invoice Issue by Third Party26BETRWAmount in Transaction Currency with +/- Signdecimal132
107DFKKTHI_HIST2Reversal: Historical Entries DFKKTHI (w/o Tax Posting)13BETRWAmount in Transaction Currency with +/- Signdecimal132
108DFKKTHI_SUMAggregated Transfer Records for Invoicing17BETRWAmount in Transaction Currency with +/- Signdecimal132
109DFKKTHPTransfer Records for Billing on Behalf of 3rd Party29BETRWAmount in Transaction Currency with +/- Signdecimal132
110DFKKWEBPEBPP: Payment Data for Payments via Web9BETRWAmount in Transaction Currency with +/- Signdecimal132
111DFKKWLIWork Items23BETRWAmount in Transaction Currency with +/- Signdecimal132
112DFKKWLIAWork Items (Work Item Type)23BETRWAmount in Transaction Currency with +/- Signdecimal132
113DFKKWLI_ILItem List of Work Item7BETRWAmount in Transaction Currency with +/- Signdecimal132
114DFKKWOHWrite-Off History11BETRWAmount in Transaction Currency with +/- Signdecimal132
115DFKKWOHTMPTemporary Write-Off History10BETRWAmount in Transaction Currency with +/- Signdecimal132
116DFKKWO_PROTLine Items Written Off from Mass Run15BETRWAmount in Transaction Currency with +/- Signdecimal132
117DFKKZARepayment Request6BETRWAmount in Transaction Currency with +/- Signdecimal132
118DFKK_DUEGRIDOI - Reclassifications15BETRWAmount in Transaction Currency with +/- Signdecimal152
119DFKK_IPL_ITEMSInstallment Plan Key Date Recording (Original Items)9BETRWAmount in Transaction Currency with +/- Signdecimal132
120DFKK_IPL_RATESInstallment Plan Key Date Recording (Installments)6BETRWAmount in Transaction Currency with +/- Signdecimal132
121DFKK_RECLASSOI - Reclassifications21BETRWAmount in Transaction Currency with +/- Signdecimal132
122DFKK_SG_ERRTable of Incorrect Checked Documents (Safeguarding)5BETRWAmount in Transaction Currency with +/- Signdecimal132
123DFKK_SG_TRIGTrigger Table for Documents to Be Checked (Safeguarding)5BETRWAmount in Transaction Currency with +/- Signdecimal132
124DFKK_SG_TRIG_CTable of Successfully Checked Documents (Safeguarding)5BETRWAmount in Transaction Currency with +/- Signdecimal132
125DFKK_TRIGGER_PAYOutbound Interface: Trigger Table for Payment Information13BETRWAmount in Transaction Currency with +/- Signdecimal132
126DPAYPPayment program - data on paid item30BETRWAmount in Transaction Currency with +/- Signdecimal132
127FKKDEFREVTrigger Table for Deferred Revenue Postings8BETRWAmount in Transaction Currency with +/- Signdecimal132
128FKKMAREDUCTDunning Reductions12BETRWAmount of Dunning Reductiondecimal132
129TFK_PAYMENTRELFI-CA: Customizing Payment Release Disbursements5BETRWAmount in Transaction Currency with +/- Signdecimal132
130TFK_PAYMENTREL_NFICA: Customizing Payment Release Disbursements - New6BETRWAmount in Transaction Currency with +/- Signdecimal132
131TFK_RZARELFICA: Customizing Payment Release Repayments4BETRWAmount in Transaction Currency with +/- Signdecimal132
TOPFinancial Services Localization
132/GSINS/UPR_FKUPRUPR - Calculation of unearned insurance premium reserve8BETRWAmount in Transaction Currency with +/- Signdecimal132
TOPGeneric Contract Accounts Receivable and Payable
133DFSCIHISTIOBBalance Int. Calculation at Contract Account Level: History16BETRWAmount in Transaction Currency with +/- Signdecimal132
TOPIncentive and Commission Management ICM
134CACSFA_DOCFA_PDSettlement to FI-CA: Reference Document Line Items11BETRWAmount in Transaction Currency with +/- Signdecimal132
TOPIntercompany Data Exchange
135EPAYTHPIDE: transfer records for third party payments20BETRWAmount in Transaction Currency with +/- Signdecimal132
136EREMADVCTRL_IDOCIDE: control table - payment data6BETRWAmount in Transaction Currency with +/- Signdecimal132
137IUEEDPPLOTATHEADDistribution Lot Header9BETRWAmount in Transaction Currency with +/- Signdecimal132
138TINV_INV_LINE_APayment Advice Line4BETRWGross Amount in Transaction Currency with +/- Signdecimal132
139TINV_INV_LINE_BBill Line with Posting Information4BETRWGross Amount in Transaction Currency with +/- Signdecimal132
140TINV_INV_LINE_IBill Line Item with Information (Not Relevant to Posting)4BETRWGross Amount in Transaction Currency with +/- Signdecimal132
141TINV_INV_TRANSFTransfer Table for Bill Data to FI-CA15BETRWAmount in Transaction Currency with +/- Signdecimal132
142TINV_LINEB_SHORTExtract of Bill Receipt (Evaluation System): Bill Lines4BETRWGross Amount in Transaction Currency with +/- Signdecimal132
143TINV_TRANSF_HSTReversal: Historical TINV_INV_TRANSF Entries15BETRWAmount in Transaction Currency with +/- Signdecimal132
144TINV_TRNSF_SHORTExtract of Bill Receipt (Eval. System): FI-CA Transfer Data15BETRWAmount in Transaction Currency with +/- Signdecimal132
TOPInvoicing
145DBERDLPrint Document Line Items18BETRWAmount in Transaction Currency with +/- Signdecimal132
146DBERDTAXTax Indicator Information for a Print Document7BETRWAmount in Transaction Currency with +/- Signdecimal132
147DBERDZDB Table: Individ. Lines - Print Document16BETRWAmount in Transaction Currency with +/- Signdecimal132
148DEABPSCustomer change table: Logical view of BB amounts37BETRWAmount in Transaction Currency with +/- Signdecimal132
149EABPLSample Lines for Budget Billing Plan12BETRWFinal Amount from Extrapolationdecimal132
150EABPS_CORRSub Budget Billing Plan for Correspondence Print26BETRWAmount in Transaction Currency with +/- Signdecimal132
151ERDZ_SHORTInternal Table for Individual Print Doc.Lines -Extract Data11BETRWAmount in Transaction Currency with +/- Signdecimal132
152TEPYPMContract history for generating payment schedule4BETRWAmount in Transaction Currency with +/- Signdecimal132
153TEPYPM_TEMPLATETemplates for contract history, payment plan generation4BETRWAmount in Transaction Currency with +/- Signdecimal132
TOPInvoicing in Contract Accounts Receivable and Payable
154DFKKINVDOC_IItems of Invoicing Document23BETRWAmount in Transaction Currency with +/- Signdecimal132
TOPLease Accounting
155/LSIERP/WLI_ILItem List of Work Item7BETRWAmount in Transaction Currency with +/- Signdecimal132
TOPPublic Sector Contract Accounts Receivable and Payable
156DFMCAINVInvoice in IS-PS-CA: Header Data14BETRWAmount in Transaction Currency with +/- Signdecimal132
157DFMCAINVPOSInvoice in IS-PS-CA: Items8BETRWAmount in Transaction Currency with +/- Signdecimal132
158DFMCA_BRF150Text Parameters for Billing Line8BETRWBRF: Expressionnvarchar200
159DFMCA_CRPAApproval List for Document Changes7BETRWAmount in Transaction Currency with +/- Signdecimal132
160DFMCA_RETURNData Table for Tax Returns27BETRWTax Return Amountdecimal132
161DFMCA_RETURN_OData Table for Tax Returns30BETRWTax Return Amountdecimal132