ESH_N_ESHDEMO7

Anchor view -ESHDEMO7 | view: ESH_L_ESHDEM7 | 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
AUTHPRODTYPE Authorization group in the material master BEGRM
AUTHPRODGROUP Authorization Group BEGRU
AUTHPROD Authorization Group BEGRU
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
ORDERUNIT Unit of Measurement Text (Maximum 30 Characters) TEXT30
BASEUNIT Unit of Measurement Text (Maximum 30 Characters) TEXT30
UNITOFMEASURE_E External Unit of Measurement in Commercial Format (3-Char.) MSEH3
WEIGHTUNIT 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_ESHDEMO7.ABCINDICATOR == TMABC.MAABC
  • ESH_N_ESHDEMO7.MANDT == TMABC.MANDT
Unit of Measure
  • Client
  • Base Unit of Measure
  • ESH_N_ESHDEMO7.MANDT == T006.MANDT
  • ESH_N_ESHDEMO7.BASEUNITCODE == T006.MSEHI
Class Type
  • Client
  • Class Type
  • ESH_N_ESHDEMO7.MANDT == TCLA.MANDT
  • ESH_N_ESHDEMO7.CLASSTYPE == TCLA.KLART
Division
  • Client
  • Division
  • ESH_N_ESHDEMO7.MANDT == TSPA.MANDT
  • ESH_N_ESHDEMO7.DIVISION == TSPA.SPART
Document number
  • ?
  • ?
  • Client
  • ?
  • Document number
  • ESH_N_ESHDEMO7.[column in domain "DOKAR"] == DRAW.DOKAR
  • ESH_N_ESHDEMO7.[column in domain "DOKVR"] == DRAW.DOKVR
  • ESH_N_ESHDEMO7.MANDT == DRAW.MANDT
  • ESH_N_ESHDEMO7.[column in domain "DOKTL_D"] == DRAW.DOKTL
  • ESH_N_ESHDEMO7.DOCUMENTINFORECORDDOCNUMBER == DRAW.DOKNR
Plant
  • Client
  • Plant
  • ESH_N_ESHDEMO7.MANDT == T001W.MANDT
  • ESH_N_ESHDEMO7.PLANT == T001W.WERKS
Material Group
  • Client
  • Product Group
  • ESH_N_ESHDEMO7.MANDT == T023.MANDT
  • ESH_N_ESHDEMO7.PRODUCTGROUP == T023.MATKL
Sales organization
  • Client
  • Sales Organization
  • ESH_N_ESHDEMO7.MANDT == TVKO.MANDT
  • ESH_N_ESHDEMO7.PRODUCTSALESORG == TVKO.VKORG
Product Type
  • Client
  • Product Type
  • ESH_N_ESHDEMO7.MANDT == T134.MANDT
  • ESH_N_ESHDEMO7.PRODUCTTYPE == T134.MTART
Unit of Measure
  • Purchase Order Unit of Measure
  • Client
  • ESH_N_ESHDEMO7.PURCHASEORDERQUANTITYUNIT == T006.MSEHI
  • ESH_N_ESHDEMO7.MANDT == T006.MANDT
Purchasing Group
  • Client
  • Purchasing Group
  • ESH_N_ESHDEMO7.MANDT == T024.MANDT
  • ESH_N_ESHDEMO7.PURCHASINGGROUP == T024.EKGRP