ESH_N_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 TEXT132
SPECIFICATIONAUTHZNGROUPDESC Authorization Group Description TEXT40
SPECIFICATIONHEADERSTATUS Status Identification /PLMB/SAM_STATUS_ID_D
SPECIFICATIONHEADERSTATUSDESC Status Description /PLMB/SAM_ACTION_DESCRIPTION_D
SPECIFICATIONTYPEDESCRIPTION Specification Type Description TEXT40
USERDESCRIPTION User Description SUIDTECHDESC
Master Data Relations Join Conditions
Document number
  • Document number
  • Client
  • ?
  • ?
  • ?
  • ESH_N_NUTR_GRP.DOCUMENTINFORECORDDOCNUMBER == DRAW.DOKNR
  • ESH_N_NUTR_GRP.MANDT == DRAW.MANDT
  • ESH_N_NUTR_GRP.[column in domain "DOKAR"] == DRAW.DOKAR
  • ESH_N_NUTR_GRP.[column in domain "DOKTL_D"] == DRAW.DOKTL
  • ESH_N_NUTR_GRP.[column in domain "DOKVR"] == DRAW.DOKVR
Foreign key for material
  • Material Number
  • Client
  • ESH_N_NUTR_GRP.MATERIAL == MARA.MATNR
  • ESH_N_NUTR_GRP.MANDT == MARA.MANDT
Description of Authorization Group
  • Client
  • Description of Authorization Group
  • ESH_N_NUTR_GRP.MANDT == TCG36.MANDT
  • ESH_N_NUTR_GRP.NUTRIENTGROUPAUTHZNGROUP == TCG36.AUTHGRP
Foreign key for substance type
  • Client
  • Specification Type
  • ESH_N_NUTR_GRP.MANDT == TCG31.MANDT
  • ESH_N_NUTR_GRP.NUTRIENTGROUPTYPE == TCG31.SUBCAT
Specification Category ESH_N_NUTR_GRP.SPECIFICATIONCATEGORY == TCGOBJ.OBJTYPE
Foreign Key for Change Number
  • Change number
  • Client
  • ESH_N_NUTR_GRP.SPECIFICATIONCHANGENUMBER == AENR.AENNR
  • ESH_N_NUTR_GRP.MANDT == AENR.MANDT
Foreign Key for Substance Nature
  • Client
  • Substance Nature
  • ESH_N_NUTR_GRP.MANDT == TCG34.MANDT
  • ESH_N_NUTR_GRP.SPECIFICATIONSUBSTANCENATR == TCG34.SUBCHAR