I_PureSubstance

Pure Substance | view: IPURESUBSTANCE | 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
SpecificationValidityStartDate Valid-From Date
SpecificationValidityEndDate Valid-To Date
Column Name Description
Column Name Description Domain name
PureSubstance Pure Substance CHAR12
PureSubstanceCreatedByUser Created By USNAM
PureSubstanceChangedByUser Last Changed By USNAM
Master Data Relations Join Conditions
Description of Authorization Group
  • Client
  • Description of Authorization Group
  • I_PURESUBSTANCE.MANDT == TCG36.MANDT
  • I_PURESUBSTANCE.PURESUBSTANCEAUTHZNGROUP == TCG36.AUTHGRP
Foreign key for substance type
  • Client
  • Specification Type
  • I_PURESUBSTANCE.MANDT == TCG31.MANDT
  • I_PURESUBSTANCE.PURESUBSTANCETYPE == TCG31.SUBCAT
Specification Category I_PURESUBSTANCE.SPECIFICATIONCATEGORY == TCGOBJ.OBJTYPE
Foreign Key for Change Number
  • Client
  • Change number
  • I_PURESUBSTANCE.MANDT == AENR.MANDT
  • I_PURESUBSTANCE.SPECIFICATIONCHANGENUMBER == AENR.AENNR
Foreign Key for Substance Nature
  • Substance Nature
  • Client
  • I_PURESUBSTANCE.SPECIFICATIONSUBSTANCENATR == TCG34.SUBCHAR
  • I_PURESUBSTANCE.MANDT == TCG34.MANDT