I_SpecAssignedMatlForKeyDate

Specification Material Assignment for Key Date | view: ISPECMATASSGMTKD | Extraction: Not supported | Component: Specification
Tables used: ESTMJ
Column Name Description
SpecMaterialAssgmtInternalID Sequential Number of Data Record
SpecMaterialAssgmtChangeState Sequential Number of the Change State
Column Name Description
Column Name Description
Column Name Description
SpecMatlAssgmtValdtyStartDate Valid-From Date
SpecMatlAssgmtValdtyEndDate Valid-To Date
SpecMaterialAssgmtCreationDate Created On
SpecMaterialAssgmtChangeDate Last Changed On
Column Name Description
SpecMaterialAssgmtIsDeleted Deletion Indicator Show values
Column Name Description Domain name
SpecMaterialAssgmtCreatedByUsr Created By USNAM
SpecMatlAssgmtLastChangedByUsr Last Changed By USNAM
Master Data Relations Join Conditions
Foreign key for material
  • Client
  • Material Number
  • I_SPECASSIGNEDMATLFORKEYDATE.MANDT == MARA.MANDT
  • I_SPECASSIGNEDMATLFORKEYDATE.MATERIAL == MARA.MATNR
Foreign key for plant
  • Client
  • Plant
  • I_SPECASSIGNEDMATLFORKEYDATE.MANDT == T001W.MANDT
  • I_SPECASSIGNEDMATLFORKEYDATE.PLANT == T001W.WERKS
Foreign Key for Change Number
  • Change Number
  • Client
  • I_SPECASSIGNEDMATLFORKEYDATE.SPECMATERIALASSGMTCHANGENUMBER == AENR.AENNR
  • I_SPECASSIGNEDMATLFORKEYDATE.MANDT == AENR.MANDT