ESH_S_ESHDEMO8

Search view -ESHDEMO8 | view: ESH_U_ESHDEM8 | Extraction: Not supported | Component: HANA Search for Business Suite
Column Name Description
PRODUCT Product Number
Column Name Description
💲 Currency Key (CURRENCY):
CHARCFROMAMOUNT Lower Boundary for Currency Field
CHARCTOAMOUNT Upper Boundary for Currency Field
Column Name Description
📏 Base Unit of Measure (BASEUNITCODE):
GROSSWEIGHT Gross weight
NETWEIGHT Net weight
Column Name Description
CHARCFROMDATE Lower Boundary for Date-Interval
CHARCFROMTIME Lower Boundary for Time-Interval
CHARCTODATE Upper Boundary for Date-Interval
CHARCTOTIME Upper Boundary for Time-Interval
Column Name Description
PRODUCTCATEGORY Product Category Show values
Column Name Description Domain name
AUTHPROD Authorization Group BEGRU
AUTHPRODGROUP Authorization Group BEGRU
AUTHPRODTYPE Authorization group in the material master BEGRM
CHARACTERISTIC Characteristic Name
CHARCDESCRIPTION Characteristic Description
CHARCFROMDECIMALVALUE Lower Boundary for Numeric Field
CHARCTODECIMALVALUE Upper Boundary for Numeric Field
CHARCVALUE Characteristic Value
CHARCVALUEDESCRIPTION Characteristic value description
CLASS Class number
CLASSDESCRIPTION Class Description
CLASSKEYWORDTEXT Keywords
COUNTRYNAME Country/Region Name TEXT50
CREATEDBYUSER Name of Person Responsible for Creating the Object USNAM
DIVISIONNAME Division Description
ABCINDICATORDESCRIPTION Description
MATERIALGROUPNAME Product Group Description
MATERIALTYPENAME Description of product type
NAME Short Text for Fixed Values
OBJECTDESCRIPTION Object Description TEXT20
ORGANIZATIONBPNAME1 Name 1
PLAINLONGTEXT Long Text
PLANTNAME Plant Name TEXT30
PRODUCTEXTERNALID External Representation of Material Number
PRODUCTNAME Product Description TEXT40
PRODUCTOLDID Old Product Number BISMT
PRODUCTSTANDARDID Global Trade Item Number (EAN/UPC/GTIN) EAN11
PURCHASINGGROUPNAME Purchasing Group Name TEXT18
SALESORGANIZATIONNAME Sales Organization Description
SOURCEOFSUPPLYCATEGORYNAME Source of supply key description
STORAGELOCATIONNAME Storage Location Name
BASEUNIT Unit of Measurement Text (Maximum 30 Characters)
ORDERUNIT Unit of Measurement Text (Maximum 30 Characters)
WEIGHTUNIT External Unit of Measurement in Commercial Format (3-Char.)
UNITOFMEASURE_E External Unit of Measurement in Commercial Format (3-Char.)
Master Data Relations Join Conditions
Value Table for ABC Indicator
  • ABC Indicator
  • Client
  • ESH_S_ESHDEMO8.ABCINDICATOR == TMABC.MAABC
  • ESH_S_ESHDEMO8.MANDT == TMABC.MANDT
Unit of Measure
  • Client
  • Base Unit of Measure
  • ESH_S_ESHDEMO8.MANDT == T006.MANDT
  • ESH_S_ESHDEMO8.BASEUNITCODE == T006.MSEHI
Class Type
  • Client
  • Class Type
  • ESH_S_ESHDEMO8.MANDT == TCLA.MANDT
  • ESH_S_ESHDEMO8.CLASSTYPE == TCLA.KLART
Division
  • Client
  • Division
  • ESH_S_ESHDEMO8.MANDT == TSPA.MANDT
  • ESH_S_ESHDEMO8.DIVISION == TSPA.SPART
Document number
  • ?
  • ?
  • ?
  • Client
  • Document number
  • ESH_S_ESHDEMO8.[column in domain "DOKAR"] == DRAW.DOKAR
  • ESH_S_ESHDEMO8.[column in domain "DOKTL_D"] == DRAW.DOKTL
  • ESH_S_ESHDEMO8.[column in domain "DOKVR"] == DRAW.DOKVR
  • ESH_S_ESHDEMO8.MANDT == DRAW.MANDT
  • ESH_S_ESHDEMO8.DOCUMENTINFORECORDDOCNUMBER == DRAW.DOKNR
Plant
  • Client
  • Plant
  • ESH_S_ESHDEMO8.MANDT == T001W.MANDT
  • ESH_S_ESHDEMO8.PLANT == T001W.WERKS
Material Group
  • Client
  • Product Group
  • ESH_S_ESHDEMO8.MANDT == T023.MANDT
  • ESH_S_ESHDEMO8.PRODUCTGROUP == T023.MATKL
Sales organization
  • Client
  • Sales Organization
  • ESH_S_ESHDEMO8.MANDT == TVKO.MANDT
  • ESH_S_ESHDEMO8.PRODUCTSALESORG == TVKO.VKORG
Product Type
  • Client
  • Product Type
  • ESH_S_ESHDEMO8.MANDT == T134.MANDT
  • ESH_S_ESHDEMO8.PRODUCTTYPE == T134.MTART
Unit of Measure
  • Purchase Order Unit of Measure
  • Client
  • ESH_S_ESHDEMO8.PURCHASEORDERQUANTITYUNIT == T006.MSEHI
  • ESH_S_ESHDEMO8.MANDT == T006.MANDT
Purchasing Group
  • Client
  • Purchasing Group
  • ESH_S_ESHDEMO8.MANDT == T024.MANDT
  • ESH_S_ESHDEMO8.PURCHASINGGROUP == T024.EKGRP