I_SpecCharByValueAssgmtInst

Specification Characteristic by VAI | view: ISPECCHARBYVAI | TRAN | Extraction: Not supported | Component: Specification
Tables used: CABNAUSPESTVAESTVHCLF_HDRESTDU
Column Name Description
SpecValAssgmtHdr Sequential Number of Data Record
SpecValAssgmt Sequential Number of Data Record
CharacteristicInternalID Characteristic Internal ID
CharcValuePositionNumber Characteristic value counter
Column Name Description
💲 Currency Key (Currency):
CharcFromAmount Lower Boundary for Currency Field
CharcToAmount Upper Boundary for Currency Field
Column Name Description
Column Name Description
CharcFromDate Lower Boundary for Date-Interval
CharcToDate Upper Boundary for Date-Interval
CharcFromTime Lower Boundary for Time-Interval
CharcToTime Upper Boundary for Time-Interval
CharcValidityStartDate Valid-From Date
CharcValidityEndDate Valid-to date
Column Name Description
SpecValAssgmtIsInhtncSource Truth Value Show values
InhtdSpecValAssgmtIsTmpChgd Indicator for Temporary Inheritance Overwriting Show values
InhtdSpecValAssgmtIsPermChgd Indicator for Permanent Inheritance Overwriting Show values
SpecValAssgmtUsageIsExcluded Validity Area is Excluded Show values
SpecValAssgmtUsageIsActive Activate Usage Show values
SpecValAssgmtUsageIsRelevant Relevant Change Has Been Made Show values
CharacteristicFormat Data type of characteristic Show values
CharacteristicValueDpndcyCode Code for value dependency 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
SpecValAssgmtSortSequence Sort Order NUMC4
ValueAssignmentSource null
Characteristic Characteristic Name ATNAM
CharacteristicValue Characteristic Value ATWRT
CharcFromDecimalValue Lower Boundary for Numeric Field
CharcToDecimalValue Upper Boundary for Numeric Field
Master Data Relations Join Conditions
Unit of Measurement
  • Unit of Measurement
  • Client
  • I_SPECCHARBYVALUEASSGMTINST.CHARACTERISTICMAXIMUMVALUEUNIT == T006.MSEHI
  • I_SPECCHARBYVALUEASSGMTINST.MANDT == T006.MANDT
Unit of Measurement
  • Client
  • Unit of Measurement
  • I_SPECCHARBYVALUEASSGMTINST.MANDT == T006.MANDT
  • I_SPECCHARBYVALUEASSGMTINST.CHARACTERISTICMINIMUMVALUEUNIT == T006.MSEHI
Rating
  • Client
  • Rating
  • I_SPECCHARBYVALUEASSGMTINST.MANDT == TCG86.MANDT
  • I_SPECCHARBYVALUEASSGMTINST.SPECIFICATIONRATING == TCG86.VACLID
Validity Area
  • Client
  • Validity Area
  • I_SPECCHARBYVALUEASSGMTINST.MANDT == TCG91.MANDT
  • I_SPECCHARBYVALUEASSGMTINST.SPECIFICATIONVALIDITYAREA == TCG91.RVLID
Value Assignment Type
  • Client
  • Value Assignment Type
  • I_SPECCHARBYVALUEASSGMTINST.MANDT == TCG11.MANDT
  • I_SPECCHARBYVALUEASSGMTINST.SPECVALASSGMTTYPE == TCG11.ESTCAT
Reference Value for Component Specification
  • Client
  • ?
  • Reference Value for Component Specification
  • I_SPECCHARBYVALUEASSGMTINST.MANDT == TCG74.MANDT
  • I_SPECCHARBYVALUEASSGMTINST.[column in domain "ESECOMPDIMID"] == TCG74.COMPDIMID
  • I_SPECCHARBYVALUEASSGMTINST.SPECVALASSGMTUNITREFDIMENSION == TCG74.COMPREL