I_Specification

Specification | view: ISPECIFICATION | Extraction: Not supported | Component: Specification
Tables used: ESTRH/PLMI/SPC_TYPVAL
Column Name Description
SpecificationInternalID Sequential Number of Data Record
SpecificationChangeState Sequential Number of the Change State
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
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_SPECIFICATION.SPECIFICATIONAUTHZNGROUP == TCG36.AUTHGRP
  • I_SPECIFICATION.MANDT == TCG36.MANDT
Foreign Key for Change Number
  • Client
  • Change number
  • I_SPECIFICATION.MANDT == AENR.MANDT
  • I_SPECIFICATION.SPECIFICATIONCHANGENUMBER == AENR.AENNR
Foreign Key for Substance Nature
  • Client
  • Substance Nature
  • I_SPECIFICATION.MANDT == TCG34.MANDT
  • I_SPECIFICATION.SPECIFICATIONSUBSTANCENATR == TCG34.SUBCHAR
Foreign key for substance type
  • Client
  • Specification Type
  • I_SPECIFICATION.MANDT == TCG31.MANDT
  • I_SPECIFICATION.SPECIFICATIONTYPE == TCG31.SUBCAT