ESH_N_ESHDEMO1

Anchor view -ESHDEMO1 | view: ESH_L_ESHDEM1 | 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
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 ATNAM
CHARCDESCRIPTION Characteristic Description TEXT30
CHARCFROMDECIMALVALUE Lower Boundary for Numeric Field
CHARCTODECIMALVALUE Upper Boundary for Numeric Field
CHARCVALUE Characteristic Value ATWRT
CHARCVALUEDESCRIPTION Characteristic value description ATWRT
CLASS Class number KLASSE
CLASSDESCRIPTION Class Description TEXT40
CLASSKEYWORDTEXT Keywords TEXT40
COUNTRYNAME Country/Region Name TEXT50
CREATEDBYUSER Name of Person Responsible for Creating the Object USNAM
DIVISIONNAME Division Description TEXT20
ABCINDICATORDESCRIPTION Description TEXT30
MATERIALGROUPNAME Product Group Description TEXT20
MATERIALTYPENAME Description of product type TEXT25
NAME Short Text for Fixed Values DDTEXT
OBJECTDESCRIPTION Object Description TEXT20
ORGANIZATIONBPNAME1 Name 1 NAME
PLAINLONGTEXT Long Text
PLANTNAME Plant Name TEXT30
PRODUCTEXTERNALID External Representation of Material Number CHAR40
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 TEXT20
SOURCEOFSUPPLYCATEGORYNAME Source of supply key description TEXT40
STORAGELOCATIONNAME Storage Location Name TEXT16
BASEUNIT Unit of Measurement Text (Maximum 30 Characters) TEXT30
ORDERUNIT Unit of Measurement Text (Maximum 30 Characters) TEXT30
WEIGHTUNIT External Unit of Measurement in Commercial Format (3-Char.) MSEH3
UNITOFMEASURE_E External Unit of Measurement in Commercial Format (3-Char.) MSEH3
Master Data Relations Join Conditions
Value Table for ABC Indicator
  • ABC Indicator
  • Client
  • ESH_N_ESHDEMO1.ABCINDICATOR == TMABC.MAABC
  • ESH_N_ESHDEMO1.MANDT == TMABC.MANDT
Unit of Measure
  • Base Unit of Measure
  • Client
  • ESH_N_ESHDEMO1.BASEUNITCODE == T006.MSEHI
  • ESH_N_ESHDEMO1.MANDT == T006.MANDT
Class Type
  • Class Type
  • Client
  • ESH_N_ESHDEMO1.CLASSTYPE == TCLA.KLART
  • ESH_N_ESHDEMO1.MANDT == TCLA.MANDT
Division
  • Client
  • Division
  • ESH_N_ESHDEMO1.MANDT == TSPA.MANDT
  • ESH_N_ESHDEMO1.DIVISION == TSPA.SPART
Document number
  • ?
  • ?
  • Document number
  • ?
  • Client
  • ESH_N_ESHDEMO1.[column in domain "DOKAR"] == DRAW.DOKAR
  • ESH_N_ESHDEMO1.[column in domain "DOKTL_D"] == DRAW.DOKTL
  • ESH_N_ESHDEMO1.DOCUMENTINFORECORDDOCNUMBER == DRAW.DOKNR
  • ESH_N_ESHDEMO1.[column in domain "DOKVR"] == DRAW.DOKVR
  • ESH_N_ESHDEMO1.MANDT == DRAW.MANDT
Plant
  • Client
  • Plant
  • ESH_N_ESHDEMO1.MANDT == T001W.MANDT
  • ESH_N_ESHDEMO1.PLANT == T001W.WERKS
Material Group
  • Client
  • Product Group
  • ESH_N_ESHDEMO1.MANDT == T023.MANDT
  • ESH_N_ESHDEMO1.PRODUCTGROUP == T023.MATKL
Sales organization
  • Client
  • Sales Organization
  • ESH_N_ESHDEMO1.MANDT == TVKO.MANDT
  • ESH_N_ESHDEMO1.PRODUCTSALESORG == TVKO.VKORG
Product Type
  • Product Type
  • Client
  • ESH_N_ESHDEMO1.PRODUCTTYPE == T134.MTART
  • ESH_N_ESHDEMO1.MANDT == T134.MANDT
Unit of Measure
  • Purchase Order Unit of Measure
  • Client
  • ESH_N_ESHDEMO1.PURCHASEORDERQUANTITYUNIT == T006.MSEHI
  • ESH_N_ESHDEMO1.MANDT == T006.MANDT
Purchasing Group
  • Client
  • Purchasing Group
  • ESH_N_ESHDEMO1.MANDT == T024.MANDT
  • ESH_N_ESHDEMO1.PURCHASINGGROUP == T024.EKGRP