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

43 columns | Print definition?ERP 6.0  | SBASW

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1DFKKHUREPDSRecording Data for Domestic Sales Hungary14SBASWAmount Subject to Tax in Transaction Currency (Tax Base Amt)decimal132
2DFKKOPK_USTPDHelp Table for Taxes When Writing Off US SALES TAXES6SBASWAmount Subject to Tax in Transaction Currency (Tax Base Amt)decimal132
3DFKKOP_DPDown Payments: Tax Data for Business Partner Item16SBASWAmount Subject to Tax in Transaction Currency (Tax Base Amt)decimal132
4FKKSK_VATLEDFI-CA Slovakia: VAT Ledger Exported Data20SBASWAmount Subject to Tax in Transaction Currency (Tax Base Amt)decimal132
TOPCollectionsDisbursements
5VVKKTAXREPTax Reporting ITA: Data for Tax Report19SBASWAmount Subject to Tax in Transaction Currency (Tax Base Amt)decimal132
6VVSCPOSPayment Plan Item156SBASWAmount Subject to Tax in Transaction Currency (Tax Base Amt)decimal132
7VVSCPOSETAXPayment Plan Items Supplement: Ext. Calculated Tax Data10SBASWAmount Subject to Tax in Transaction Currency (Tax Base Amt)decimal132
TOPContract Accounts Receivable and Payable
8DFKKITVATMVAT monthly report for Italy: history table7SBASWAmount Subject to Tax in Transaction Currency (Tax Base Amt)decimal132
9DFKKITVATQVAT quarterly report for Italy: history table7SBASWAmount Subject to Tax in Transaction Currency (Tax Base Amt)decimal132
10DFKKMOPKItems in contract account document36SBASWAmount Subject to Tax in Transaction Currency (Tax Base Amt)decimal132
11DFKKOPAADistribution Items with Account Assignment10SBASWAmount Subject to Tax in Transaction Currency (Tax Base Amt)decimal132
12DFKKOPKItems in contract account document36SBASWAmount Subject to Tax in Transaction Currency (Tax Base Amt)decimal132
13DFKKOPUSTAXIN00Basic Data for Tax Calculation - Telco Tax (U.S.A.)12SBASWTax Base Amountdecimal115
14DFKKOPUSTAXIN01Basic Data for Tax Calculation - Telco Tax (U.S.A.)12SBASWTax Base Amountdecimal115
15DFKKOPUSTAXIN02Basic Data for Tax Calculation - Telco Tax (U.S.A.)12SBASWTax Base Amountdecimal115
16DFKKOPUSTAXIN03Basic Data for Tax Calculation - Telco Tax (U.S.A.)12SBASWTax Base Amountdecimal115
17DFKKOPUSTAXIN04Basic Data for Tax Calculation - Telco Tax (U.S.A.)12SBASWTax Base Amountdecimal115
18DFKKOPUSTAXIN05Basic Data for Tax Calculation - Telco Tax (U.S.A.)12SBASWTax Base Amountdecimal115
19DFKKOPUSTAXIN06Basic Data for Tax Calculation - Telco Tax (U.S.A.)12SBASWTax Base Amountdecimal115
20DFKKOPUSTAXIN07Basic Data for Tax Calculation - Telco Tax (U.S.A.)12SBASWTax Base Amountdecimal115
21DFKKOPUSTAXIN08Basic Data for Tax Calculation - Telco Tax (U.S.A.)12SBASWTax Base Amountdecimal115
22DFKKOPUSTAXIN09Basic Data for Tax Calculation - Telco Tax (U.S.A.)12SBASWTax Base Amountdecimal115
23DFKKOPUSTAXIN10Basic Data for Tax Calculation - Telco Tax (U.S.A.)12SBASWTax Base Amountdecimal115
24DFKKOPUSTAXIN11Basic Data for Tax Calculation - Telco Tax (U.S.A.)12SBASWTax Base Amountdecimal115
25DFKKOPUSTAXIN12Basic Data for Tax Calculation - Telco Tax (U.S.A.)12SBASWTax Base Amountdecimal115
26DFKKORDERPOSRequests: Items59SBASWAmount Subject to Tax in Transaction Currency (Tax Base Amt)decimal132
27DFKKQSRIndividual Records for Withholding Tax Report16SBASWAmount Subject to Tax in Transaction Currency (Tax Base Amt)decimal132
28DFKKREP06Tax Report Data (Invoicing Time or Triggered)15SBASWAmount Subject to Tax in Transaction Currency (Tax Base Amt)decimal132
29DFKKREP06_STax Report Data - Shadow Table for Posting Date15SBASWAmount Subject to Tax in Transaction Currency (Tax Base Amt)decimal132
30DFKKREP07Tax Report Data (Clearing Time)16SBASWAmount Subject to Tax in Transaction Currency (Tax Base Amt)decimal132
31DFKKREP07_TTax Report Data (Additional Data for Transfer Posting)8SBASWAmount Subject to Tax in Transaction Currency (Tax Base Amt)decimal132
32DFKKREPTDAdjusted Tax Data (Currently Not Used)11SBASWAmount Subject to Tax in Transaction Currency (Tax Base Amt)decimal132
33DFKKSUMPosting totals from FI-CA53SBASWAmount Subject to Tax in Transaction Currency (Tax Base Amt)decimal132
TOPIntercompany Data Exchange
34TINV_INV_LINE_BBill Line with Posting Information30SBASWAmount Subject to Tax in Transaction Currency (Tax Base Amt)decimal132
35TINV_INV_LINE_IBill Line Item with Information (Not Relevant to Posting)30SBASWAmount Subject to Tax in Transaction Currency (Tax Base Amt)decimal132
36TINV_INV_TRANSFTransfer Table for Bill Data to FI-CA43SBASWAmount Subject to Tax in Transaction Currency (Tax Base Amt)decimal132
37TINV_LINEB_SHORTExtract of Bill Receipt (Evaluation System): Bill Lines27SBASWAmount Subject to Tax in Transaction Currency (Tax Base Amt)decimal132
38TINV_TRANSF_HSTReversal: Historical TINV_INV_TRANSF Entries17SBASWAmount Subject to Tax in Transaction Currency (Tax Base Amt)decimal132
39TINV_TRNSF_SHORTExtract of Bill Receipt (Eval. System): FI-CA Transfer Data25SBASWAmount Subject to Tax in Transaction Currency (Tax Base Amt)decimal132
TOPInvoicing
40DBERDLPrint Document Line Items20SBASWAmount Subject to Tax in Transaction Currency (Tax Base Amt)decimal132
41DBERDZDB Table: Individ. Lines - Print Document8SBASWAmount Subject to Tax in Transaction Currency (Tax Base Amt)decimal132
42ERDZ_SHORTInternal Table for Individual Print Doc.Lines -Extract Data22SBASWAmount Subject to Tax in Transaction Currency (Tax Base Amt)decimal132
TOPInvoicing in Contract Accounts Receivable and Payable
43DFKKINVDOC_IItems of Invoicing Document41SBASWAmount Subject to Tax in Transaction Currency (Tax Base Amt)decimal132