I_SpecValAssgmtItemForKeyDate

Specification Value Assignment Item for Key Date | view: ISPECVAITMKDATE | TRAN | Extraction: Not supported | Component: Specification
Tables used: ESTVP
Column Name Description
SpecValAssgmtItem Sequential Number of Data Record
SpecValAssgmtItemChangeState Sequential Number of the Change State
Column Name Description
Column Name Description
Column Name Description
SpecValAssgmtItemValdtyStrtDte Valid-From Date
SpecValAssgmtItemValdtyEndDte Valid-To Date
Column Name Description
SpecValAssgmtItemIsDeleted Deletion Indicator Show values
CompSpecLowerLimitOperator Operator for Lower Limit Show values
CompSpecUpperLimitOperator Operator for Upper Limit Show values
Column Name Description Domain name
SpecValAssgmt Reference to RECN for Tables ESTVA, ESTRH and ESTRI ESDRECN
ComponentSpecificationIntID Reference to Specification Header of a Component ESDRECN
CompSpecLowerLimit Lower Limit of a Component Proportion ESDDEC6_4
CompSpecUpperLimit Upper limit of a component proportion ESDDEC6_4
CompSpecQuantity Target Value or Actual Value of a Component ESDDEC6_4
CompSpecSortSequence Sort Order NUMC4
CompSpecDecimalQuantity Decimal Places for the Concentration of a Component INT4
Master Data Relations Join Conditions
Component Type
  • Component Type
  • Client
  • I_SPECVALASSGMTITEMFORKEYDATE.COMPSPECCOMPONENTTYPE == TCG76.COMPCAT
  • I_SPECVALASSGMTITEMFORKEYDATE.MANDT == TCG76.MANDT
Exception Value of a Component
  • Exception Value of a Component
  • Client
  • I_SPECVALASSGMTITEMFORKEYDATE.COMPSPECEXCEPTIONCODE == TCG78.COMPEXCVAL
  • I_SPECVALASSGMTITEMFORKEYDATE.MANDT == TCG78.MANDT
EHS: Foreign key for units of measurement
  • Unit for Quantity Specification
  • Client
  • I_SPECVALASSGMTITEMFORKEYDATE.COMPSPECUNIT == T006.MSEHI
  • I_SPECVALASSGMTITEMFORKEYDATE.MANDT == T006.MANDT