I_RawSubstance

Raw Substance | view: IRAWSUBSTANCE | Extraction: Not supported | Component: Specification
Column Name Description
RawSubstanceInternalID Sequential Number of Data Record
Column Name Description
Column Name Description
Column Name Description
RawSubstanceCreationDate Created On
RawSubstanceChangeDate Changed On
SpecificationValidityStartDate Valid-From Date
SpecificationValidityEndDate Valid-To Date
Column Name Description
Column Name Description Domain name
RawSubstance Raw Substance CHAR12
RawSubstanceCreatedByUser Created By USNAM
RawSubstanceChangedByUser Last Changed By USNAM
SpecificationNote Note TEXT60
Master Data Relations Join Conditions
Description of Authorization Group
  • Description of Authorization Group
  • Client
  • I_RAWSUBSTANCE.RAWSUBSTANCEAUTHZNGROUP == TCG36.AUTHGRP
  • I_RAWSUBSTANCE.MANDT == TCG36.MANDT
Foreign key for substance type
  • Client
  • Specification Type
  • I_RAWSUBSTANCE.MANDT == TCG31.MANDT
  • I_RAWSUBSTANCE.RAWSUBSTANCETYPE == TCG31.SUBCAT
Specification Category I_RAWSUBSTANCE.SPECIFICATIONCATEGORY == TCGOBJ.OBJTYPE
Foreign Key for Change Number
  • Client
  • Change number
  • I_RAWSUBSTANCE.MANDT == AENR.MANDT
  • I_RAWSUBSTANCE.SPECIFICATIONCHANGENUMBER == AENR.AENNR
Foreign Key for Substance Nature
  • Client
  • Substance Nature
  • I_RAWSUBSTANCE.MANDT == TCG34.MANDT
  • I_RAWSUBSTANCE.SPECIFICATIONSUBSTANCENATR == TCG34.SUBCHAR