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

Home | ERP 6.0  | /BEV2/ED901
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
Materials Management :: Inventory Management :: Excise Duty
ProductVersionTableColumnsIndexesDescriptionModule
1ERP EHP76.0/BEV2/ED901521Excise Duty Types/FunctionsExcise Duty
SQL:  selectupdate insert create

Use the column checkboxes to build your query. Header columns sets/unsets all columns

SELECT MANDT, YHVBART, YHFLOOR, YHMINVOL, YHMAXVOL, YH_SCHEMA_BESKZ, YH_STEUERWERT_KZ, YH_ATTR_UMR, YH_ATTR_UMR_DEF, YH_ATTR_GEF, YH_ATTR_MATGRP, YH_ATTR_MATGRP_S, YH_ATTR_GEF_MEIN, YH_ATTR_GEF_DEZ, YH_ATTR_GEF_BASE, YH_ATTR_ALKO, YH_ATTR_SPRIT, YH_ATTR_LOSE, YH_ATTR_ZUSATZ1, YH_ATTR_YHMAAK1, YH_ATTR_YHMAAK2, YH_ATTR_YHMAAK1T, YH_ATTR_YHMAAK2T, YH_ATTR_YHMAB, YH_ATTR_HERST, YH_ATTR_AUSLAND, YH_ATTR_ANTEIL, YH_ATTR_YHMABK1, YH_ATTR_YHMABK2, YH_ATTR_YHMABK1T, YH_ATTR_YHMABK2T, YH_ATTR_YHMAC, YH_ATTR_SWRETRO, YH_ATTR_SWABF, YH_ATTR_SWHER, YH_ATTR_ALKOABW, YH_ATTR_YHMACK1, YH_ATTR_YHMACK2, YH_ATTR_YHMACK1T, YH_ATTR_YHMACK2T, SL_LISTTYPE_DEFA, EMCS_CAT_CODE, YH_ATTR_CSA_EPC, YH_ATTR_CSA_ADA, YH_ATTR_CSA_DEN, YH_ATTR_CSA_WIN, YH_ATTR_CSB_EPC, YH_ATTR_CSB_WIN, YH_ATTR_CSC_EPC, YH_ATTR_CSC_ADA, YH_ATTR_CSC_DEN, YH_ATTR_CSC_WIN FROM /BEV2/ED901
ColumnFieldDescriptionSQL TypeLengthDecimalsRelationDefault ValueConstraintsSQL Create Statement
1MANDTClientnvarchar30 Allow NULL? 
2YHVBARTExcise Duty Typenvarchar30 Allow NULL? 
3YHFLOORRound Down Alcoholic Strengthchar10 Allow NULL? 
4YHMINVOLMinimum Permitted Value for Alcoholic Strength/Degreedecimal52
5YHMAXVOLMaximum Permitted Value for Alcoholic Strength/Degreedecimal52
6YH_SCHEMA_BESKZExcise Duty Procurement Types Schemanvarchar100 Allow NULL? 
7YH_STEUERWERT_KZMethod for Determining Tax Amountnvarchar30 Allow NULL? 
8YH_ATTR_UMRSwitch On 'Alternative Conversion' Field for ED Typechar10 Allow NULL? 
9YH_ATTR_UMR_DEFPre-Assignment f. Altern. Conversion Field in ED Matl Masterchar10 Allow NULL? 
10YH_ATTR_GEFIndicator for Determining the Content of Containerchar10 Allow NULL? 
11YH_ATTR_MATGRPIndicator for Material Group (Tax Type Independent) Activechar10 Allow NULL? 
12YH_ATTR_MATGRP_SIndicator for Material Group (for Tax Type) Activechar10 Allow NULL? 
13YH_ATTR_GEF_MEINUnit of Measure for Container Contentsnvarchar30 Allow NULL? 
14YH_ATTR_GEF_DEZDecimal Places: Contentschar10 Allow NULL? 
15YH_ATTR_GEF_BASEBase Unit of Measure for Calculating Container Contentschar10 Allow NULL? 
16YH_ATTR_ALKOField for Alcoholic Strength in ED Material Master Activechar10 Allow NULL? 
17YH_ATTR_SPRITSpirits Indicator in ED Material Master Activechar10 Allow NULL? 
18YH_ATTR_LOSE'Non-Filled Goods' indicator active in ED material masterchar10 Allow NULL? 
19YH_ATTR_ZUSATZ1Indicator Supplement 1 in ED Material Master Activechar10 Allow NULL? 
20YH_ATTR_YHMAAK1Show Customer-Specific Fields 1 in ED Matl Master Clientchar10 Allow NULL? 
21YH_ATTR_YHMAAK2Show Customer-Specific Fields 2 in ED Matl Master Clientchar10 Allow NULL? 
22YH_ATTR_YHMAAK1TShow Customer-Specific Text 1 in ED Matl Master Clientchar10 Allow NULL? 
23YH_ATTR_YHMAAK2TShow Customer-Specific Text 2 in ED Matl Master Clientchar10 Allow NULL? 
24YH_ATTR_YHMABMaintain Material Master Company Code Indicatorchar10 Allow NULL? 
25YH_ATTR_HERSTManufacturer ID f. External Products in ED Mat.Master Activechar10 Allow NULL? 
26YH_ATTR_AUSLANDField for Goods Produced Abroad in ED Material Master Activechar10 Allow NULL? 
27YH_ATTR_ANTEILField for Proportion Qty is Active in ED Material Masterchar10 Allow NULL? 
28YH_ATTR_YHMABK1Show Customer-Specific Fields 1 in ED Matl Master CoCdchar10 Allow NULL? 
29YH_ATTR_YHMABK2Show Customer-Specific Fields 2 in ED Matl Master CompanyCdchar10 Allow NULL? 
30YH_ATTR_YHMABK1TSwitch On Customer-Specific Text 1 in ED Matl Master CoCdchar10 Allow NULL? 
31YH_ATTR_YHMABK2TSwitch On Customer-Specific Text 2 in ED Matl Master CoCdchar10 Allow NULL? 
32YH_ATTR_YHMACMaintain Material Master Plant Indicatorchar10 Allow NULL? 
33YH_ATTR_SWRETROField for Retrograde Shrinkage Rate in ED Mat.Master Activechar10 Allow NULL? 
34YH_ATTR_SWABFField for Filling Shrinkage in ED Material Master Activechar10 Allow NULL? 
35YH_ATTR_SWHERField for Production Shrinkage in ED Material Master Activechar10 Allow NULL? 
36YH_ATTR_ALKOABWField for Deviating Alcoholic Strength at Plant Level Activechar10 Allow NULL? 
37YH_ATTR_YHMACK1Switch On Customer-Spec.Fields 1 in ED MatlMstr Plant CoCdchar10 Allow NULL? 
38YH_ATTR_YHMACK2Switch On Customer-Spec.Fields 2 in ED Material Master Plantchar10 Allow NULL? 
39YH_ATTR_YHMACK1TSwitch On Customer-Spec. Text 1 in ED Material Master Plantchar10 Allow NULL? 
40YH_ATTR_YHMACK2TSwitch On Customer-Spec.Text 2 in ED Material Master Plantchar10 Allow NULL? 
41SL_LISTTYPE_DEFAStock Ledger: List Format Default (ALV or Fixes List)char10 Allow NULL? 
42EMCS_CAT_CODEProduct Category Codechar10 Allow NULL? 
43YH_ATTR_CSA_EPCSwitch On 'EMCS: Excise Product Code' Field for ED Typechar10 Allow NULL? 
44YH_ATTR_CSA_ADASwitch On EMCS Addit.Alcoholic Strength Fields for ED Typechar10 Allow NULL? 
45YH_ATTR_CSA_DENSwitch On EMCS Density Fields for Excise Duty Typechar10 Allow NULL? 
46YH_ATTR_CSA_WINSwitch On EMCS Wine Specifics Fields for ED Typechar10 Allow NULL? 
47YH_ATTR_CSB_EPCSwitch On 'EMCS: Excise Product Code' Field for ED Typechar10 Allow NULL? 
48YH_ATTR_CSB_WINSwitch On EMCS Wine Specifics Fields for ED Typechar10 Allow NULL? 
49YH_ATTR_CSC_EPCSwitch On 'EMCS: Excise Product Code' Field for ED Typechar10 Allow NULL? 
50YH_ATTR_CSC_ADASwitch On 'EMCS: Addit.Alcoholic Strength' Field for ED Typechar10 Allow NULL? 
51YH_ATTR_CSC_DENSwitch On 'EMCS: Density' Field for ED Typechar10 Allow NULL? 
52YH_ATTR_CSC_WINSwitch On EMCS Wine Specifics Fields for ED Typechar10 Allow NULL? 
NamePrimaryUniqueTypeColumns
/BEV2/ED901~0YesYesCLUSTEREDYHVBART, MANDT

All references to SAP and SAP logo are trademarks of SAP AG in Germany, EU, USA and other territories.
No warranty is provided to data provided by this site. This website is not affiliated with, maintained, authorized, endorsed or sponsored by the SAP AG Company or any of its affiliates.
About :: Terms :: Privacy