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

28 columns | Print definition?ERP 6.0  | HWSTE

TableTable DescriptionColumn#AliasColumn DescriptionData TypeLengthDecimalsDefault ValueConstraints
1/BGLOCS/VATMAITMVAT Margin Items19HWSTETax Amount in Local Currencydecimal132
2/CCEE/SIFI_UMSITTax items applied for decrease/increase of input VAT11HWSTETax Amount in Local Currencydecimal132
3/CEECV/BEFI_VATDVAT Report Estonia - document processed from RFUMSV0022HWSTETax Amount in Local Currencydecimal132
4/CEECV/BVFI_PVNDocuments for VAT Declaration20HWSTETax Amount in Local Currencydecimal132
5BSESDocument Control Data (Obsolete)11HWSTETax Amount in Local Currencydecimal132
6BSETTax Data Document Segment12HWSTETax Amount in Local Currencydecimal132
7FIEUD_GOODS_ISAFT-XML:Goods Movement Line Items55HWSTETax Amount in Local Currencydecimal132
8FIEUD_MMINVTAXSAFT:MM: TAX Information for E-XML MM invoice for LU16HWSTETax Amount in Local Currencydecimal132
9FIEUD_MMINV_ISAFT:MM: Item Details for XML Purchase Invoice32HWSTETax Amount in Local Currencydecimal132
10FISKD_VATCNTRLDocument's information reported to SK authorities17HWSTETax Amount in Local Currencydecimal132
11FUDT_VDOCBSETTax Data Document Segment of Verification Document12HWSTETax Amount in Local Currencydecimal132
12FUDT_VDOCBSETHTax Data Document Segment of Verification Document(History)12HWSTETax Amount in Local Currencydecimal132
TOPAccounting Interface
13GLE_FI_ITEM_MODFECS: Modified FI Line Items (Header/Item/Currency Data)456HWSTETax Amount in Local Currencydecimal132
14GLE_FI_ITEM_ORIGECS: Original FI Line Items (Header/Line Item/Crcy Actg I/F)456HWSTETax Amount in Local Currencydecimal132
TOPContract Accounts Receivable and Payable
15DFKKFMBGAINFOTax Information for Public-Owned Commercial Operations21HWSTEAmount in Local Currencydecimal132
TOPFinancial Accounting
16/CEECV/ROFIUMSVTax Balances per Comp.Code, Tax Code and Process.Key10HWSTETax Amount in Local Currency with +/- Signdecimal132
17DEFTAX_ITEMData for Deferred Taxes19HWSTETax Amount in Local Currencydecimal132
18VBSETDocument Segment for Taxes Document Parking10HWSTETax Amount in Local Currencydecimal132
TOPFunds Management-Specific Postings
19FMBGACORRSHistory for Input Tax Adjustments PCOs18HWSTETax Amount in Local Currencydecimal132
20FMBGADCTAXData from Backdated Tax Calculation for PCOs17HWSTETax Amount in Local Currencydecimal132
21PSOSETDocument Segment for Standing Request Taxes11HWSTETax Amount in Local Currencydecimal132
TOPInformation System
22UMSVTax Balances per Comp.Code, Tax Code and Process.Key10HWSTETax Amount in Local Currency with +/- Signdecimal132
TOPInvoice Verification
23RBTXTaxes: Incoming Invoice10HWSTETax Amount in Local Currencydecimal132
TOPLocalization
24J_1ISER_BSEGTransaction table having the Invoices with Service Category22HWSTETax Amount in Local Currencydecimal132
25J_3RFSEC_ITEMData for Secondary events for deferred tax25HWSTETax Amount in Local Currencydecimal132
26J_3RUMSVTax Balances per Comp.Code, Tax Code and Process.Key+ client12HWSTETax Amount in Local Currency with +/- Signdecimal132
27RFIDPTAAVPro-Rata Asset Acquisition Value11HWSTETax Amount in Local Currencydecimal132
28RFUMSV00_BAL_BEAdvance Tax Return Belgium: Total balances9HWSTETax Amount in Local Currencydecimal132