I_Allergen

Allergen | view: IALLERGEN | Extraction: Not supported | Component: Specification
Column Name Description
AllergenInternalID Allergen Internal ID
Column Name Description
Column Name Description
Column Name Description
AllergenCreationDate Created On
AllergenChangeDate Changed On
SpecificationValidityStartDate Valid-From Date
SpecificationValidityEndDate Valid-To Date
Column Name Description
Column Name Description Domain name
Allergen Allergen CHAR12
AllergenCreatedByUser Created By USNAM
AllergenChangedByUser Changed By USNAM
Master Data Relations Join Conditions
Description of Authorization Group
  • Client
  • Description of Authorization Group
  • I_ALLERGEN.MANDT == TCG36.MANDT
  • I_ALLERGEN.ALLERGENAUTHZNGROUP == TCG36.AUTHGRP
Foreign key for substance type
  • Client
  • Specification Type
  • I_ALLERGEN.MANDT == TCG31.MANDT
  • I_ALLERGEN.ALLERGENTYPE == TCG31.SUBCAT
Specification Category I_ALLERGEN.SPECIFICATIONCATEGORY == TCGOBJ.OBJTYPE
Foreign Key for Change Number
  • Change number
  • Client
  • I_ALLERGEN.SPECIFICATIONCHANGENUMBER == AENR.AENNR
  • I_ALLERGEN.MANDT == AENR.MANDT
Foreign Key for Substance Nature
  • Client
  • Substance Nature
  • I_ALLERGEN.MANDT == TCG34.MANDT
  • I_ALLERGEN.SPECIFICATIONSUBSTANCENATR == TCG34.SUBCHAR