A_SpecValAssgmtInstanceWthComp

Specification Value Assignment Instance with Composition | view: ASPECVAINSTWCOMP | Extraction: Not supported | Component: Specification
Tables used: ESTRH, ESTVA, ESTVH, ESTVP, ESTDU, /PLMI/SPC_TYPVAL
Column Name Description
SpecificationInternalID FK Sequential Number of Data Record
SpecValAssgmtType FK Value Assignment Type
SpecificationRating FK Rating
SpecificationValidityArea FK Validity Area
ComponentSpecificationIntID Reference to Specification Header of a Component
Column Name Description
Column Name Description
Column Name Description
Column Name Description
CompSpecLowerLimitOperator Operator for Lower Limit Show values
CompSpecUpperLimitOperator Operator for Upper Limit Show values
Column Name Description Domain name
ComponentSpecification Specification ESDSUBID
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
Master Data Relations Join Conditions
Component Type
  • Component Type
  • Client
  • A_SPECVALASSGMTINSTANCEWTHCOMP.COMPSPECCOMPONENTTYPE == TCG76.COMPCAT
  • A_SPECVALASSGMTINSTANCEWTHCOMP.MANDT == TCG76.MANDT
Exception Value of a Component
  • Exception Value of a Component
  • Client
  • A_SPECVALASSGMTINSTANCEWTHCOMP.COMPSPECEXCEPTIONCODE == TCG78.COMPEXCVAL
  • A_SPECVALASSGMTINSTANCEWTHCOMP.MANDT == TCG78.MANDT
EHS: Foreign key for units of measurement
  • Unit for Quantity Specification
  • Client
  • A_SPECVALASSGMTINSTANCEWTHCOMP.COMPSPECUNIT == T006.MSEHI
  • A_SPECVALASSGMTINSTANCEWTHCOMP.MANDT == T006.MANDT
Recipe Authorization Group
  • Recipe Authorization Group
  • Client
  • A_SPECVALASSGMTINSTANCEWTHCOMP.SPECIFICATIONAUTHZNGROUP == TCG36.AUTHGRP
  • A_SPECVALASSGMTINSTANCEWTHCOMP.MANDT == TCG36.MANDT
Rating
  • Client
  • Rating
  • A_SPECVALASSGMTINSTANCEWTHCOMP.MANDT == TCG86.MANDT
  • A_SPECVALASSGMTINSTANCEWTHCOMP.SPECIFICATIONRATING == TCG86.VACLID
Foreign key for substance type
  • Client
  • Specification Type
  • A_SPECVALASSGMTINSTANCEWTHCOMP.MANDT == TCG31.MANDT
  • A_SPECVALASSGMTINSTANCEWTHCOMP.SPECIFICATIONTYPE == TCG31.SUBCAT
Validity Area
  • Validity Area
  • Client
  • A_SPECVALASSGMTINSTANCEWTHCOMP.SPECIFICATIONVALIDITYAREA == TCG91.RVLID
  • A_SPECVALASSGMTINSTANCEWTHCOMP.MANDT == TCG91.MANDT
Value Assignment Type
  • Value Assignment Type
  • Client
  • A_SPECVALASSGMTINSTANCEWTHCOMP.SPECVALASSGMTTYPE == TCG11.ESTCAT
  • A_SPECVALASSGMTINSTANCEWTHCOMP.MANDT == TCG11.MANDT