ESH_S_PRODUCT

Search view -PRODUCT | view: ESH_U_PRODUCT | Extraction: Not supported | Component: Material Master

Tables used: ESH_SR_LTXT, DRAD, MARA, CABN, CABNT, CAWN, CAWNT, KLAH, SWOR, AUSP, KSSK, T005T, TSPAT, T001W, TMABCT, T023T, T023, MVKE, MAKT, T134, T134T, T024, TVKO, TVKOT, TMBWT, T001L, LFA1, T006A, MARC, MARD, CLF_HDR, DRAD_LAST_CHANGE, TDWOT

🔑 Keys (1)
💰 Amounts (2)
∑ Quantities (2)
📅 Dates (4)
☰ Categorical (1)
Other (36)
🔗 Relations (11)

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	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
CLASS	Class number
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
LASTCHANGEDBYUSER	Name of Person Who Changed Object	USNAM
ABCINDICATORDESCRIPTION	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
PRODUCTGROUPNAME	Product Group Description
PRODUCTNAME	Product Description	TEXT40
PRODUCTOLDID	Old Product Number	BISMT
PRODUCTSTANDARDID	Global Trade Item Number (EAN/UPC/GTIN)	EAN11
PURCHASINGGROUPNAME	Purchasing Group Name
SALESORGANIZATIONNAME	Sales Organization Description	TEXT20
SOURCEOFSUPPLYCATEGORYNAME	Source of supply key description
STORAGELOCATIONNAME	Storage Location Name	TEXT16
BASEUNIT	Unit of Measurement Text (Maximum 30 Characters)
ORDERUNIT	Unit of Measurement Text (Maximum 30 Characters)
UNITOFMEASURE_E	External Unit of Measurement in Commercial Format (3-Char.)
WEIGHTUNIT	External Unit of Measurement in Commercial Format (3-Char.)

Master Data Relations	Join Conditions
Value Table for ABC Indicator ABC Indicator Client	`ESH_S_PRODUCT.ABCINDICATOR == TMABC.MAABC` `ESH_S_PRODUCT.MANDT == TMABC.MANDT`
Unit of Measure Base Unit of Measure Client	`ESH_S_PRODUCT.BASEUNITCODE == T006.MSEHI` `ESH_S_PRODUCT.MANDT == T006.MANDT`
Class Type Class Type Client	`ESH_S_PRODUCT.CLASSTYPE == TCLA.KLART` `ESH_S_PRODUCT.MANDT == TCLA.MANDT`
Division Division Client	`ESH_S_PRODUCT.DIVISION == TSPA.SPART` `ESH_S_PRODUCT.MANDT == TSPA.MANDT`
Document number ? Document number ? ? Client	`ESH_S_PRODUCT.[column in domain "DOKAR"] == DRAW.DOKAR` `ESH_S_PRODUCT.DOCUMENTINFORECORDDOCNUMBER == DRAW.DOKNR` `ESH_S_PRODUCT.[column in domain "DOKTL_D"] == DRAW.DOKTL` `ESH_S_PRODUCT.[column in domain "DOKVR"] == DRAW.DOKVR` `ESH_S_PRODUCT.MANDT == DRAW.MANDT`
Plant Plant Client	`ESH_S_PRODUCT.PLANT == T001W.WERKS` `ESH_S_PRODUCT.MANDT == T001W.MANDT`
Material Group Product Group Client	`ESH_S_PRODUCT.PRODUCTGROUP == T023.MATKL` `ESH_S_PRODUCT.MANDT == T023.MANDT`
Sales organization Sales Organization Client	`ESH_S_PRODUCT.PRODUCTSALESORG == TVKO.VKORG` `ESH_S_PRODUCT.MANDT == TVKO.MANDT`
Product Type Product Type Client	`ESH_S_PRODUCT.PRODUCTTYPE == T134.MTART` `ESH_S_PRODUCT.MANDT == T134.MANDT`
Unit of Measure Purchase Order Unit of Measure Client	`ESH_S_PRODUCT.PURCHASEORDERQUANTITYUNIT == T006.MSEHI` `ESH_S_PRODUCT.MANDT == T006.MANDT`
Purchasing Group Purchasing Group Client	`ESH_S_PRODUCT.PURCHASINGGROUP == T024.EKGRP` `ESH_S_PRODUCT.MANDT == T024.MANDT`