I_SpecValAssgmtInstanceWthComp

Specification Value Assignment Instance with Composition | view: ISPECVAINSTWCOMP | TRAN | Extraction: Not supported | Component: Specification
Tables used: ESTVAESTVHESTVPESTDU
Column Name Description
SpecValAssgmtHdr Sequential Number of Data Record
SpecValAssgmt Sequential Number of Data Record
ComponentSpecificationIntID Reference to Specification Header of a Component
Column Name Description
Column Name Description
Column Name Description
Column Name Description
SpecValAssgmtIsInhtncSource Truth Value Show values
InhtdSpecValAssgmtIsTmpChgd Indicator for Temporary Inheritance Overwriting Show values
InhtdSpecValAssgmtIsPermChgd Indicator for Permanent Inheritance Overwriting Show values
CompSpecLowerLimitOperator Operator for Lower Limit Show values
CompSpecUpperLimitOperator Operator for Upper Limit Show values
Column Name Description Domain name
SpecInheritanceTemplate Sequential Number of Data Record ESDRECN
SpecValAssgmtInheritanceParent Sequential Number of Data Record ESDRECN
SpecValAssgmtInheritanceRoot Sequential Number of Data Record ESDRECN
SpecValAssgmtChangeState Sequential Number of the Change State ESDACTN
SpecValAssgmtSortSequence Sort Order NUMC4
ValueAssignmentSource null
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_SPECVALASSGMTINSTANCEWTHCOMP.COMPSPECCOMPONENTTYPE == TCG76.COMPCAT
  • I_SPECVALASSGMTINSTANCEWTHCOMP.MANDT == TCG76.MANDT
Exception Value of a Component
  • Exception Value of a Component
  • Client
  • I_SPECVALASSGMTINSTANCEWTHCOMP.COMPSPECEXCEPTIONCODE == TCG78.COMPEXCVAL
  • I_SPECVALASSGMTINSTANCEWTHCOMP.MANDT == TCG78.MANDT
EHS: Foreign key for units of measurement
  • Unit for Quantity Specification
  • Client
  • I_SPECVALASSGMTINSTANCEWTHCOMP.COMPSPECUNIT == T006.MSEHI
  • I_SPECVALASSGMTINSTANCEWTHCOMP.MANDT == T006.MANDT
Rating
  • Client
  • Rating
  • I_SPECVALASSGMTINSTANCEWTHCOMP.MANDT == TCG86.MANDT
  • I_SPECVALASSGMTINSTANCEWTHCOMP.SPECIFICATIONRATING == TCG86.VACLID
Validity Area
  • Validity Area
  • Client
  • I_SPECVALASSGMTINSTANCEWTHCOMP.SPECIFICATIONVALIDITYAREA == TCG91.RVLID
  • I_SPECVALASSGMTINSTANCEWTHCOMP.MANDT == TCG91.MANDT
Value Assignment Type
  • Value Assignment Type
  • Client
  • I_SPECVALASSGMTINSTANCEWTHCOMP.SPECVALASSGMTTYPE == TCG11.ESTCAT
  • I_SPECVALASSGMTINSTANCEWTHCOMP.MANDT == TCG11.MANDT
Reference Value for Component Specification
  • ?
  • Reference Value for Component Specification
  • Client
  • I_SPECVALASSGMTINSTANCEWTHCOMP.[column in domain "ESECOMPDIMID"] == TCG74.COMPDIMID
  • I_SPECVALASSGMTINSTANCEWTHCOMP.SPECVALASSGMTUNITREFDIMENSION == TCG74.COMPREL
  • I_SPECVALASSGMTINSTANCEWTHCOMP.MANDT == TCG74.MANDT