I_Diet

Diet | view: IDIET | Extraction: Not supported | Component: Specification
Column Name Description
DietInternalID Sequential Number of Data Record
Column Name Description
Column Name Description
Column Name Description
DietCreationDate Created On
DietChangeDate Changed On
SpecificationValidityStartDate Valid-From Date
SpecificationValidityEndDate Valid-To Date
Column Name Description
Column Name Description Domain name
Diet Diet CHAR12
DietCreatedByUser Created By USNAM
DietChangedByUser Last Changed By USNAM
Master Data Relations Join Conditions
Description of Authorization Group
  • Client
  • Description of Authorization Group
  • I_DIET.MANDT == TCG36.MANDT
  • I_DIET.DIETAUTHZNGROUP == TCG36.AUTHGRP
Foreign key for substance type
  • Client
  • Specification Type
  • I_DIET.MANDT == TCG31.MANDT
  • I_DIET.DIETTYPE == TCG31.SUBCAT
Specification Category I_DIET.SPECIFICATIONCATEGORY == TCGOBJ.OBJTYPE
Foreign Key for Change Number
  • Client
  • Change number
  • I_DIET.MANDT == AENR.MANDT
  • I_DIET.SPECIFICATIONCHANGENUMBER == AENR.AENNR
Foreign Key for Substance Nature
  • Client
  • Substance Nature
  • I_DIET.MANDT == TCG34.MANDT
  • I_DIET.SPECIFICATIONSUBSTANCENATR == TCG34.SUBCHAR