I_SpecificationForKeyDate

Specification on a Key Date | view: ISPECFORKDATE | Extraction: Not supported | Component: Specification
Tables used: ESTRH/PLMI/SPC_TYPVAL
Column Name Description
SpecificationInternalID Sequential Number of Data Record
Column Name Description
Column Name Description
Column Name Description
SpecificationValidityStartDate Valid-From Date
SpecificationValidityEndDate Valid-To Date
SpecificationCreationDate Date of Creation
SpecificationLastChangeDate Changed Date
Column Name Description
SpecificationIsDeleted Deletion Indicator Show values
Column Name Description Domain name
SpecificationChangeState Sequential Number of the Change State ESDACTN
Specification Specification /PLMB/SPC_EXT_ID_API
SpecificationCreatedByUser Created By USNAM
SpecificationLastChangedByUser Changed By USNAM
SpecificationNote Note TEXT60
Master Data Relations Join Conditions
Recipe Authorization Group
  • Recipe Authorization Group
  • Client
  • I_SPECIFICATIONFORKEYDATE.SPECIFICATIONAUTHZNGROUP == TCG36.AUTHGRP
  • I_SPECIFICATIONFORKEYDATE.MANDT == TCG36.MANDT
Foreign Key for Change Number
  • Change number
  • Client
  • I_SPECIFICATIONFORKEYDATE.SPECIFICATIONCHANGENUMBER == AENR.AENNR
  • I_SPECIFICATIONFORKEYDATE.MANDT == AENR.MANDT
Foreign Key for Substance Nature
  • Substance Nature
  • Client
  • I_SPECIFICATIONFORKEYDATE.SPECIFICATIONSUBSTANCENATR == TCG34.SUBCHAR
  • I_SPECIFICATIONFORKEYDATE.MANDT == TCG34.MANDT
Foreign key for substance type
  • Client
  • Specification Type
  • I_SPECIFICATIONFORKEYDATE.MANDT == TCG31.MANDT
  • I_SPECIFICATIONFORKEYDATE.SPECIFICATIONTYPE == TCG31.SUBCAT