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 TypeLengthDecimalsSAP TypeDefault ValueNull AllowedCheckTableRollnameSQL Create Statement
1MANDTClientnvarchar30CLNT(N'000')NoT000MANDT Allow NULL? 
2YHVBARTExcise Duty Typenvarchar30CHAR(N' ')No/BEV2/EDART Allow NULL? 
3YHFLOORRound Down Alcoholic Strengthchar10CHAR(N' ')Yes/BEV2/EDFLOOR Allow NULL? 
4YHMINVOLMinimum Permitted Value for Alcoholic Strength/Degreedecimal52DEC((0))Yes/BEV2/EDMINVOL
5YHMAXVOLMaximum Permitted Value for Alcoholic Strength/Degreedecimal52DEC((0))Yes/BEV2/EDMAXVOL
6YH_SCHEMA_BESKZExcise Duty Procurement Types Schemanvarchar100CHAR(N' ')Yes/BEV2/ED951/BEV2/EDSCHEMA_BESKZ Allow NULL? 
7YH_STEUERWERT_KZMethod for Determining Tax Amountnvarchar30CHAR(N' ')Yes/BEV2/EDSTEUERWERT_KZ Allow NULL? 
8YH_ATTR_UMRSwitch On 'Alternative Conversion' Field for ED Typechar10CHAR(N' ')Yes/BEV2/EDATTR_UMR Allow NULL? 
9YH_ATTR_UMR_DEFPre-Assignment f. Altern. Conversion Field in ED Matl Masterchar10CHAR(N' ')Yes/BEV2/EDATTR_UMR_DEF Allow NULL? 
10YH_ATTR_GEFIndicator for Determining the Content of Containerchar10CHAR(N' ')Yes/BEV2/EDATTR_GEF Allow NULL? 
11YH_ATTR_MATGRPIndicator for Material Group (Tax Type Independent) Activechar10CHAR(N' ')Yes/BEV2/EDATTR_MATGRP Allow NULL? 
12YH_ATTR_MATGRP_SIndicator for Material Group (for Tax Type) Activechar10CHAR(N' ')Yes/BEV2/EDATTR_MATGRP_S Allow NULL? 
13YH_ATTR_GEF_MEINUnit of Measure for Container Contentsnvarchar30UNIT(N' ')YesT006/BEV2/EDATTR_GEF_MEIN Allow NULL? 
14YH_ATTR_GEF_DEZDecimal Places: Contentschar10NUMC(N'0')Yes/BEV2/EDDEZSTELLEN_INHALT Allow NULL? 
15YH_ATTR_GEF_BASEBase Unit of Measure for Calculating Container Contentschar10CHAR(N' ')Yes/BEV2/EDATTR_GEF_BASE Allow NULL? 
16YH_ATTR_ALKOField for Alcoholic Strength in ED Material Master Activechar10CHAR(N' ')Yes/BEV2/EDATTR_ALKO Allow NULL? 
17YH_ATTR_SPRITSpirits Indicator in ED Material Master Activechar10CHAR(N' ')Yes/BEV2/EDATTR_SPRIT Allow NULL? 
18YH_ATTR_LOSE'Non-Filled Goods' indicator active in ED material masterchar10CHAR(N' ')Yes/BEV2/EDATTR_LOSE Allow NULL? 
19YH_ATTR_ZUSATZ1Indicator Supplement 1 in ED Material Master Activechar10CHAR(N' ')Yes/BEV2/EDATTR_ZUSATZ1 Allow NULL? 
20YH_ATTR_YHMAAK1Show Customer-Specific Fields 1 in ED Matl Master Clientchar10CHAR(N' ')Yes/BEV2/EDATTR_YHMAAK1 Allow NULL? 
21YH_ATTR_YHMAAK2Show Customer-Specific Fields 2 in ED Matl Master Clientchar10CHAR(N' ')Yes/BEV2/EDATTR_YHMAAK2 Allow NULL? 
22YH_ATTR_YHMAAK1TShow Customer-Specific Text 1 in ED Matl Master Clientchar10CHAR(N' ')Yes/BEV2/EDATTR_YHMAAK1T Allow NULL? 
23YH_ATTR_YHMAAK2TShow Customer-Specific Text 2 in ED Matl Master Clientchar10CHAR(N' ')Yes/BEV2/EDATTR_YHMAAK2T Allow NULL? 
24YH_ATTR_YHMABMaintain Material Master Company Code Indicatorchar10CHAR(N' ')Yes/BEV2/EDATTR_YHMAB Allow NULL? 
25YH_ATTR_HERSTManufacturer ID f. External Products in ED Mat.Master Activechar10CHAR(N' ')Yes/BEV2/EDATTR_HERST Allow NULL? 
26YH_ATTR_AUSLANDField for Goods Produced Abroad in ED Material Master Activechar10CHAR(N' ')Yes/BEV2/EDATTR_AUSLAND Allow NULL? 
27YH_ATTR_ANTEILField for Proportion Qty is Active in ED Material Masterchar10CHAR(N' ')Yes/BEV2/EDATTR_ANTEIL Allow NULL? 
28YH_ATTR_YHMABK1Show Customer-Specific Fields 1 in ED Matl Master CoCdchar10CHAR(N' ')Yes/BEV2/EDATTR_YHMABK1 Allow NULL? 
29YH_ATTR_YHMABK2Show Customer-Specific Fields 2 in ED Matl Master CompanyCdchar10CHAR(N' ')Yes/BEV2/EDATTR_YHMABK2 Allow NULL? 
30YH_ATTR_YHMABK1TSwitch On Customer-Specific Text 1 in ED Matl Master CoCdchar10CHAR(N' ')Yes/BEV2/EDATTR_YHMABK1T Allow NULL? 
31YH_ATTR_YHMABK2TSwitch On Customer-Specific Text 2 in ED Matl Master CoCdchar10CHAR(N' ')Yes/BEV2/EDATTR_YHMABK2T Allow NULL? 
32YH_ATTR_YHMACMaintain Material Master Plant Indicatorchar10CHAR(N' ')Yes/BEV2/EDATTR_YHMAC Allow NULL? 
33YH_ATTR_SWRETROField for Retrograde Shrinkage Rate in ED Mat.Master Activechar10CHAR(N' ')Yes/BEV2/EDATTR_SWRETRO Allow NULL? 
34YH_ATTR_SWABFField for Filling Shrinkage in ED Material Master Activechar10CHAR(N' ')Yes/BEV2/EDATTR_SWABF Allow NULL? 
35YH_ATTR_SWHERField for Production Shrinkage in ED Material Master Activechar10CHAR(N' ')Yes/BEV2/EDATTR_SWHER Allow NULL? 
36YH_ATTR_ALKOABWField for Deviating Alcoholic Strength at Plant Level Activechar10CHAR(N' ')Yes/BEV2/EDATTR_ALKOABW Allow NULL? 
37YH_ATTR_YHMACK1Switch On Customer-Spec.Fields 1 in ED MatlMstr Plant CoCdchar10CHAR(N' ')Yes/BEV2/EDATTR_YHMACK1 Allow NULL? 
38YH_ATTR_YHMACK2Switch On Customer-Spec.Fields 2 in ED Material Master Plantchar10CHAR(N' ')Yes/BEV2/EDATTR_YHMACK2 Allow NULL? 
39YH_ATTR_YHMACK1TSwitch On Customer-Spec. Text 1 in ED Material Master Plantchar10CHAR(N' ')Yes/BEV2/EDATTR_YHMACK1T Allow NULL? 
40YH_ATTR_YHMACK2TSwitch On Customer-Spec.Text 2 in ED Material Master Plantchar10CHAR(N' ')Yes/BEV2/EDATTR_YHMACK2T Allow NULL? 
41SL_LISTTYPE_DEFAStock Ledger: List Format Default (ALV or Fixes List)char10CHAR(N' ')Yes/BEV2/ED_SL_LISTTYPE_DEFAULT Allow NULL? 
42EMCS_CAT_CODEProduct Category Codechar10CHAR(N' ')Yes/BEV2/CS_C_CCODE/BEV2/CS_CATEGORY_CODE Allow NULL? 
43YH_ATTR_CSA_EPCSwitch On 'EMCS: Excise Product Code' Field for ED Typechar10CHAR(N' ')Yes/BEV2/EDATTR_CSA_EPC Allow NULL? 
44YH_ATTR_CSA_ADASwitch On EMCS Addit.Alcoholic Strength Fields for ED Typechar10CHAR(N' ')Yes/BEV2/EDATTR_CSA_ADA Allow NULL? 
45YH_ATTR_CSA_DENSwitch On EMCS Density Fields for Excise Duty Typechar10CHAR(N' ')Yes/BEV2/EDATTR_CSA_DEN Allow NULL? 
46YH_ATTR_CSA_WINSwitch On EMCS Wine Specifics Fields for ED Typechar10CHAR(N' ')Yes/BEV2/EDATTR_CSA_WIN Allow NULL? 
47YH_ATTR_CSB_EPCSwitch On 'EMCS: Excise Product Code' Field for ED Typechar10CHAR(N' ')Yes/BEV2/EDATTR_CSB_EPC Allow NULL? 
48YH_ATTR_CSB_WINSwitch On EMCS Wine Specifics Fields for ED Typechar10CHAR(N' ')Yes/BEV2/EDATTR_CSB_WIN Allow NULL? 
49YH_ATTR_CSC_EPCSwitch On 'EMCS: Excise Product Code' Field for ED Typechar10CHAR(N' ')Yes/BEV2/EDATTR_CSC_EPC Allow NULL? 
50YH_ATTR_CSC_ADASwitch On 'EMCS: Addit.Alcoholic Strength' Field for ED Typechar10CHAR(N' ')Yes/BEV2/EDATTR_CSC_ADA Allow NULL? 
51YH_ATTR_CSC_DENSwitch On 'EMCS: Density' Field for ED Typechar10CHAR(N' ')Yes/BEV2/EDATTR_CSC_DEN Allow NULL? 
52YH_ATTR_CSC_WINSwitch On EMCS Wine Specifics Fields for ED Typechar10CHAR(N' ')Yes/BEV2/EDATTR_CSC_WIN 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