ESH_S_NUTR_GRP

Column Name Description
NUTRIENTGROUPINTERNALID Sequential Number of Data Record
Column Name Description
Column Name Description
Column Name Description
NUTRIENTGROUPCREATIONDATE Created On
SPECIFICATIONVALIDITYENDDATE Valid-To Date
SPECIFICATIONVALIDITYSTARTDATE Valid-From Date
Column Name Description
LOGACCMOBJECTTYPEISACTIVE Access Control Activated for Object Type Show values
Column Name Description Domain name
LOGACCMOBJECTTYPE Object Type /PLMB/GOS_OBJECT_TYPE
NUTRIENTGROUP Nutrient Group CHAR12
NUTRIENTGROUPCREATEDBYUSER Created By USNAM
PLAINLONGTEXT Long Text
PRODUCTNAME Product Description TEXT40
SPECIDFGDESCTEXT Identifier
SPECIFICATIONAUTHZNGROUPDESC Authorization Group Description TEXT40
SPECIFICATIONHEADERSTATUS Status Identification
SPECIFICATIONHEADERSTATUSDESC Status Description
SPECIFICATIONTYPEDESCRIPTION Specification Type Description
USERDESCRIPTION User Description
Master Data Relations Join Conditions
Document number
  • Document number
  • ?
  • Client
  • ?
  • ?
  • ESH_S_NUTR_GRP.DOCUMENTINFORECORDDOCNUMBER == DRAW.DOKNR
  • ESH_S_NUTR_GRP.[column in domain "DOKTL_D"] == DRAW.DOKTL
  • ESH_S_NUTR_GRP.MANDT == DRAW.MANDT
  • ESH_S_NUTR_GRP.[column in domain "DOKAR"] == DRAW.DOKAR
  • ESH_S_NUTR_GRP.[column in domain "DOKVR"] == DRAW.DOKVR
Foreign key for material
  • Client
  • Material Number
  • ESH_S_NUTR_GRP.MANDT == MARA.MANDT
  • ESH_S_NUTR_GRP.MATERIAL == MARA.MATNR
Description of Authorization Group
  • Description of Authorization Group
  • Client
  • ESH_S_NUTR_GRP.NUTRIENTGROUPAUTHZNGROUP == TCG36.AUTHGRP
  • ESH_S_NUTR_GRP.MANDT == TCG36.MANDT
Foreign key for substance type
  • Client
  • Specification Type
  • ESH_S_NUTR_GRP.MANDT == TCG31.MANDT
  • ESH_S_NUTR_GRP.NUTRIENTGROUPTYPE == TCG31.SUBCAT
Specification Category ESH_S_NUTR_GRP.SPECIFICATIONCATEGORY == TCGOBJ.OBJTYPE
Foreign Key for Change Number
  • Client
  • Change number
  • ESH_S_NUTR_GRP.MANDT == AENR.MANDT
  • ESH_S_NUTR_GRP.SPECIFICATIONCHANGENUMBER == AENR.AENNR
Foreign Key for Substance Nature
  • Client
  • Substance Nature
  • ESH_S_NUTR_GRP.MANDT == TCG34.MANDT
  • ESH_S_NUTR_GRP.SPECIFICATIONSUBSTANCENATR == TCG34.SUBCHAR