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
6FIQAC_PART8Reporting Parameters Text for Company Code ( Qatar)
7/ISDFPS/CHVW_E34External Batch Where-Used List
8/1RA/0SD010MI170Items for Class SD01 - Raw Data
9FMARCPAR4Parallelization of FMARC_BATCH
10CEKRS5Movement type parameters for automatic ERS

B1 9.2: Top 10 requests

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

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
9OSRN20Serial Numbers Master Data
10OBOT10Bill Of Exchang Transaction

46 columns | Print definition?ERP 6.0  | HWBAS

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BGLOCS/VATMAITMVAT Margin Items17HWBASTax Base Amount in Local Currencydecimal152
2/CCEE/SIFI_UMSITTax items applied for decrease/increase of input VAT10HWBASTax Base Amount in Local Currencydecimal152
3/CEECV/BEFI_VATDVAT Report Estonia - document processed from RFUMSV0021HWBASTax Base Amount in Local Currencydecimal132
4/CEECV/BVFI_PVNDocuments for VAT Declaration19HWBASTax Base Amount in Local Currencydecimal132
5BSEGAccounting Document Segment40HWBASTax Base Amount in Local Currencydecimal132
6BSESDocument Control Data (Obsolete)9HWBASTax Base Amount in Local Currencydecimal152
7BSETTax Data Document Segment10HWBASTax Base Amount in Local Currencydecimal152
8BSSEGAccounting Document Segment29HWBASTax Base Amount in Local Currencydecimal132
9DFKKHUREPDSRecording Data for Domestic Sales Hungary13HWBASTax Base Amount in Local Currencydecimal132
10FIEUD_GOODS_ISAFT-XML:Goods Movement Line Items52HWBASTax Base Amount in Local Currencydecimal152
11FIEUD_MMINVTAXSAFT:MM: TAX Information for E-XML MM invoice for LU13HWBASTax Base Amount in Local Currencydecimal152
12FIEUD_MMINV_ISAFT:MM: Item Details for XML Purchase Invoice30HWBASTax Base Amount in Local Currencydecimal152
13FISKD_VATCNTRLDocument's information reported to SK authorities16HWBASTax Base Amount in Local Currencydecimal132
14FUDT_VDOCBSEGVerification Document Item with Additional Info29HWBASTax Base Amount in Local Currencydecimal132
15FUDT_VDOCBSEGEVVerification Document Item in the Entry View29HWBASTax Base Amount in Local Currencydecimal132
16FUDT_VDOCBSEGHVerification Document Segment with Additional Info(History)29HWBASTax Base Amount in Local Currencydecimal132
17FUDT_VDOCBSETTax Data Document Segment of Verification Document10HWBASTax Base Amount in Local Currencydecimal152
18FUDT_VDOCBSETHTax Data Document Segment of Verification Document(History)10HWBASTax Base Amount in Local Currencydecimal152
TOPAccounting Interface
19GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)457HWBASTax Base Amount in Local Currencydecimal132
20GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)457HWBASTax Base Amount in Local Currencydecimal132
TOPContract Accounts Receivable and Payable
21DFKKREPZMRecording Data for EC Sales List14HWBASTax Base Amount in Local Currencydecimal132
TOPData Retention Tool
22TXW_S_BSEGRetrieve BSEG from archive58HWBASTax base amount in local currencynvarchar160
TOPFinancial Accounting
23/CEECV/ROFIUMSVTax Balances per Comp.Code, Tax Code and Process.Key9HWBASTax Base Amount in Local Currencydecimal152
24PARCTReceipt Log Table11HWBASTax Base Amount in Local Currencydecimal132
25VBSEGADocument Segment for Document Parking - Asset Database17HWBASTax Base Amount in Local Currencydecimal132
26VBSEGDDocument Segment for Customer Document Parking24HWBASTax Base Amount in Local Currencydecimal132
27VBSEGKDocument Segment for Vendor Document Parking24HWBASTax Base Amount in Local Currencydecimal132
28VBSEGSDocument Segment for Document Parking - G/L Account Database18HWBASTax Base Amount in Local Currencydecimal132
TOPFunds Management-Specific Postings
29FMBGACORRSHistory for Input Tax Adjustments PCOs17HWBASTax Base Amount in Local Currencydecimal132
30FMBGADCTAXData from Backdated Tax Calculation for PCOs16HWBASTax Base Amount in Local Currencydecimal132
31FMFUNDTRANSYEARAdditional Documents for Funds Transfer to Diff. Years20HWBASTax Base Amount in Local Currencydecimal132
32PSOSEGADocument Segment for Assets Document Parking18HWBASTax Base Amount in Local Currencydecimal132
33PSOSEGDDocument Segment: Recurring Request, Customer25HWBASTax Base Amount in Local Currencydecimal132
34PSOSEGKRecurring Request Document Segment, Vendors25HWBASTax Base Amount in Local Currencydecimal132
35PSOSEGSRecurring Request Document Segment, G/L Accounts19HWBASTax Base Amount in Local Currencydecimal132
TOPInformation System
36DKKOPBalance Audit Trail52HWBASTax Base Amount in Local Currencydecimal132
37DKOKPOpen Item Account Balance Audit Trail54HWBASTax Base Amount in Local Currencydecimal132
38DSKOPBalance Audit Trail54HWBASTax Base Amount in Local Currencydecimal132
39UMSVTax Balances per Comp.Code, Tax Code and Process.Key9HWBASTax Base Amount in Local Currencydecimal152
TOPInvoice Verification
40RBCODocument Item, Incoming Invoice, Account Assignment70HWBASTax Base Amount in Local Currencydecimal132
41RBTXTaxes: Incoming Invoice11HWBASTax Base Amount in Local Currencydecimal152
TOPLocalization
42J_1ISER_BSEGTransaction table having the Invoices with Service Category21HWBASTax Base Amount in Local Currencydecimal132
43J_3RFSEC_ITEMData for Secondary events for deferred tax23HWBASTax Base Amount in Local Currencydecimal152
44J_3RUMSVTax Balances per Comp.Code, Tax Code and Process.Key+ client11HWBASTax Base Amount in Local Currencydecimal152
45RFUMSV00_BAL_BEAdvance Tax Return Belgium: Total balances8HWBASTax Base Amount in Local Currencydecimal132
TOPRemaining Beverage - Obsolete Objects
46/BEV3/CH1030BSG1Document Segment CH Event Ledger Part131HWBASTax Base Amount in Local Currencydecimal132