I_StreamSubstance

Stream Substance | view: ISTREAMSUBSTANCE | Extraction: Not supported | Component: Specification
Column Name Description
StreamSubstanceInternalID Sequential Number of Data Record
Column Name Description
Column Name Description
Column Name Description
StreamSubstanceCreationDate Created On
StreamSubstanceChangeDate Changed On
SpecificationValidityStartDate Valid-From Date
SpecificationValidityEndDate Valid-To Date
Column Name Description
Column Name Description Domain name
StreamSubstance Stream Substance CHAR12
StreamSubstanceCreatedByUser Created By USNAM
StreamSubstanceChangedByUser Changed By USNAM
Master Data Relations Join Conditions
Specification Category I_STREAMSUBSTANCE.SPECIFICATIONCATEGORY == TCGOBJ.OBJTYPE
Foreign Key for Change Number
  • Client
  • Change number
  • I_STREAMSUBSTANCE.MANDT == AENR.MANDT
  • I_STREAMSUBSTANCE.SPECIFICATIONCHANGENUMBER == AENR.AENNR
Foreign Key for Substance Nature
  • Client
  • Substance Nature
  • I_STREAMSUBSTANCE.MANDT == TCG34.MANDT
  • I_STREAMSUBSTANCE.SPECIFICATIONSUBSTANCENATR == TCG34.SUBCHAR
Description of Authorization Group
  • Client
  • Description of Authorization Group
  • I_STREAMSUBSTANCE.MANDT == TCG36.MANDT
  • I_STREAMSUBSTANCE.STREAMSUBSTANCEAUTHZNGROUP == TCG36.AUTHGRP
Foreign key for substance type
  • Client
  • Specification Type
  • I_STREAMSUBSTANCE.MANDT == TCG31.MANDT
  • I_STREAMSUBSTANCE.STREAMSUBSTANCETYPE == TCG31.SUBCAT