R_SpecCompositionDateIndep

Spec Value Assignment Instance with Comp Date Independent | view: RSPCCMPDATEINDEP | 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
SpecificationInternalID FK Sequential Number of Data Record
SpecValAssgmtChangeState Sequential Number of the Change State
SpecificationRating FK Rating
SpecificationValidityArea FK Validity Area
Column Name Description
Column Name Description
Column Name Description
SpecValAssgmtValidityStartDate Valid-From Date
SpecValAssgmtValidityEndDate Valid-To Date
SpecValAssgmtCreationDate Created On
SpecValAssgmtLastChangeDate Last Changed On
Column Name Description
SpecValAssgmtHdrIsDeleted Deletion Indicator Show values
SpecValAssgmtIsInhtncSource Truth Value Show values
InhtdSpecValAssgmtIsTmpChgd Indicator for Temporary Inheritance Overwriting Show values
InhtdSpecValAssgmtIsPermChgd Indicator for Permanent Inheritance Overwriting Show values
SpecValAssgmtIsDeleted Deletion Indicator Show values
SpecValAssgmtUsageIsExcluded Validity Area is Excluded Show values
SpecValAssgmtUsageIsRelevant Relevant Change Has Been Made Show values
CompSpecLowerLimitOperator Operator for Lower Limit Show values
CompSpecUpperLimitOperator Operator for Upper Limit Show values
Column Name Description Domain name
SpecValAssgmtCreatedByUser Created By USNAM
SpecValAssgmtLastChangedByUser Last Changed By USNAM
SpecValAssgmtSortSequence Sort Order NUMC4
SpecInheritanceTemplate Sequential Number of Data Record ESDRECN
SpecValAssgmtInheritanceParent Sequential Number of Data Record ESDRECN
SpecValAssgmtInheritanceRoot Sequential Number of Data Record ESDRECN
SpecValAssgmtRootSpecIntID Sequential Number of Data Record ESDRECN
SpecValAssgmtItem Sequential Number of Data Record ESDRECN
SpecValAssgmtItemChangeState Sequential Number of the Change State ESDACTN
CompSpecQuantity Target Value or Actual Value of a Component ESDDEC6_4
CompSpecLowerLimit Lower Limit of a Component Proportion ESDDEC6_4
CompSpecUpperLimit Upper limit of a component proportion ESDDEC6_4
Master Data Relations Join Conditions
Component Type
  • Client
  • Component Type
  • R_SPECCOMPOSITIONDATEINDEP.MANDT == TCG76.MANDT
  • R_SPECCOMPOSITIONDATEINDEP.COMPSPECCOMPONENTTYPE == TCG76.COMPCAT
Exception Value of a Component
  • Exception Value of a Component
  • Client
  • R_SPECCOMPOSITIONDATEINDEP.COMPSPECEXCEPTIONCODE == TCG78.COMPEXCVAL
  • R_SPECCOMPOSITIONDATEINDEP.MANDT == TCG78.MANDT
EHS: Foreign key for units of measurement
  • Unit for Quantity Specification
  • Client
  • R_SPECCOMPOSITIONDATEINDEP.COMPSPECUNIT == T006.MSEHI
  • R_SPECCOMPOSITIONDATEINDEP.MANDT == T006.MANDT
Rating
  • Rating
  • Client
  • R_SPECCOMPOSITIONDATEINDEP.SPECIFICATIONRATING == TCG86.VACLID
  • R_SPECCOMPOSITIONDATEINDEP.MANDT == TCG86.MANDT
Validity Area
  • Client
  • Validity Area
  • R_SPECCOMPOSITIONDATEINDEP.MANDT == TCG91.MANDT
  • R_SPECCOMPOSITIONDATEINDEP.SPECIFICATIONVALIDITYAREA == TCG91.RVLID
Change Number
  • Change Number
  • Client
  • R_SPECCOMPOSITIONDATEINDEP.SPECVALASSGMTCHANGENUMBER == AENR.AENNR
  • R_SPECCOMPOSITIONDATEINDEP.MANDT == AENR.MANDT
Value Assignment Type
  • Client
  • Value Assignment Type
  • R_SPECCOMPOSITIONDATEINDEP.MANDT == TCG11.MANDT
  • R_SPECCOMPOSITIONDATEINDEP.SPECVALASSGMTTYPE == TCG11.ESTCAT
Reference Value for Component Specification
  • Client
  • Reference Value for Component Specification
  • ?
  • R_SPECCOMPOSITIONDATEINDEP.MANDT == TCG74.MANDT
  • R_SPECCOMPOSITIONDATEINDEP.SPECVALASSGMTUNITREFDIMENSION == TCG74.COMPREL
  • R_SPECCOMPOSITIONDATEINDEP.[column in domain "ESECOMPDIMID"] == TCG74.COMPDIMID