I_DietGroup

Diet Group | view: IDIETGROUP | Extraction: Not supported | Component: Specification
Column Name Description
DietGroupInternalID Sequential Number of Data Record
Column Name Description
Column Name Description
Column Name Description
DietGroupCreationDate Created On
DietGroupChangeDate Changed On
SpecificationValidityStartDate Valid-From Date
SpecificationValidityEndDate Valid-To Date
Column Name Description
Column Name Description Domain name
DietGroup Diet Group CHAR12
DietGroupCreatedByUser Created By USNAM
DietGroupChangedByUser Last Changed By USNAM
Master Data Relations Join Conditions
Description of Authorization Group
  • Description of Authorization Group
  • Client
  • I_DIETGROUP.DIETGROUPAUTHZNGROUP == TCG36.AUTHGRP
  • I_DIETGROUP.MANDT == TCG36.MANDT
Foreign key for substance type
  • Client
  • Specification Type
  • I_DIETGROUP.MANDT == TCG31.MANDT
  • I_DIETGROUP.DIETGROUPTYPE == TCG31.SUBCAT
Specification Category I_DIETGROUP.SPECIFICATIONCATEGORY == TCGOBJ.OBJTYPE
Foreign Key for Change Number
  • Change number
  • Client
  • I_DIETGROUP.SPECIFICATIONCHANGENUMBER == AENR.AENNR
  • I_DIETGROUP.MANDT == AENR.MANDT
Foreign Key for Substance Nature
  • Client
  • Substance Nature
  • I_DIETGROUP.MANDT == TCG34.MANDT
  • I_DIETGROUP.SPECIFICATIONSUBSTANCENATR == TCG34.SUBCHAR