A_PureSubstance

Pure Substance | view: APURESUB | Extraction: Not supported | Component: Specification
Column Name Description
PureSubstanceInternalID Pure Substance Internal ID
Column Name Description
Column Name Description
Column Name Description
PureSubstanceCreationDate Created On
PureSubstanceChangeDate Changed On
PureSubstanceValidityStartDate Valid-From Date
PureSubstanceValidityEndDate Valid-To Date
PureSubstVersIndepLstChgDate Version Independent Last Change Date
PureSubstVersIndepLstChgTime Version Independent Last Change Time
Column Name Description
Column Name Description Domain name
PureSubstance Pure Substance /PLMB/SPC_EXT_ID_API
PureSubstanceCreatedByUser Created By USNAM
PureSubstanceChangedByUser Last Changed By USNAM
ListedSubstance Listed Substance EHFND_LISTEDSUBSTANCE_ID
Master Data Relations Join Conditions
Description of Authorization Group
  • Description of Authorization Group
  • Client
  • A_PURESUBSTANCE.PURESUBSTANCEAUTHZNGROUP == TCG36.AUTHGRP
  • A_PURESUBSTANCE.MANDT == TCG36.MANDT
Foreign key for substance type
  • Client
  • Specification Type
  • A_PURESUBSTANCE.MANDT == TCG31.MANDT
  • A_PURESUBSTANCE.PURESUBSTANCETYPE == TCG31.SUBCAT