A_Allergen

Allergen | view: AALLERGEN | 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
AllergenVersIndepLstChgDate Version Independent Last Change Date
AllergenVersIndepLstChgTime Version Independent Last Change Time
AllergenValidityStartDate Valid-From Date
AllergenValidityEndDate Valid-To Date
Column Name Description
Column Name Description Domain name
Allergen Allergen /PLMB/SPC_EXT_ID_API
AllergenCreatedByUser Created By USNAM
AllergenChangedByUser Changed By USNAM
ListedSubstance Listed Substance EHFND_LISTEDSUBSTANCE_ID
Master Data Relations Join Conditions
Description of Authorization Group
  • Client
  • Description of Authorization Group
  • A_ALLERGEN.MANDT == TCG36.MANDT
  • A_ALLERGEN.ALLERGENAUTHZNGROUP == TCG36.AUTHGRP
Foreign key for substance type
  • Client
  • Specification Type
  • A_ALLERGEN.MANDT == TCG31.MANDT
  • A_ALLERGEN.ALLERGENTYPE == TCG31.SUBCAT