A_SpecAssignedMatlForKeyDate

Specification Assigned Material For Key Date | view: ASPECMATASSIGN | Extraction: Not supported | Component: Specification
Tables used: T001WESTMJESTRH/PLMI/SPC_TYPVAL
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
SpecMaterialAssgmtChangeDate Last Changed On
SpecMaterialAssgmtCreationDate Created On
SpecMatlAssgmtValdtyEndDate Valid-To Date
SpecMatlAssgmtValdtyStartDate Valid-From Date
Column Name Description
SpecMaterialAssgmtIsDeleted Deletion Indicator Show values
Column Name Description Domain name
PlantName Plant Name TEXT30
SpecMaterialAssgmtCreatedByUsr Created By USNAM
SpecMatlAssgmtLastChangedByUsr Last Changed By USNAM
Master Data Relations Join Conditions
Foreign key for material
  • Client
  • Material Number
  • A_SPECASSIGNEDMATLFORKEYDATE.MANDT == MARA.MANDT
  • A_SPECASSIGNEDMATLFORKEYDATE.MATERIAL == MARA.MATNR
Foreign key for plant
  • Client
  • Plant
  • A_SPECASSIGNEDMATLFORKEYDATE.MANDT == T001W.MANDT
  • A_SPECASSIGNEDMATLFORKEYDATE.PLANT == T001W.WERKS
Recipe Authorization Group
  • Client
  • Recipe Authorization Group
  • A_SPECASSIGNEDMATLFORKEYDATE.MANDT == TCG36.MANDT
  • A_SPECASSIGNEDMATLFORKEYDATE.SPECIFICATIONAUTHZNGROUP == TCG36.AUTHGRP
Foreign key for substance type
  • Specification Type
  • Client
  • A_SPECASSIGNEDMATLFORKEYDATE.SPECIFICATIONTYPE == TCG31.SUBCAT
  • A_SPECASSIGNEDMATLFORKEYDATE.MANDT == TCG31.MANDT
Foreign Key for Change Number
  • Change Number
  • Client
  • A_SPECASSIGNEDMATLFORKEYDATE.SPECMATERIALASSGMTCHANGENUMBER == AENR.AENNR
  • A_SPECASSIGNEDMATLFORKEYDATE.MANDT == AENR.MANDT