A_SpecCharByValueAssgmtInst

Specification Characteristic By Value Assignment Instance | view: ASPECCHARBYVAI | TRAN | Extraction: Not supported | Component: Specification
Tables used: CABNAUSPESTRHESTVAESTVHCLF_HDRESTDU/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
Column Name Description
💲 Currency Key (Currency):
CharcCurrencyMinimumValue Lower Boundary for Currency Field
CharcFromAmount Lower Boundary for Currency Field
CharcToAmount Upper Boundary for Currency Field
Column Name Description
Column Name Description
CharcValidityStartDate Valid-From Date
CharcValidityEndDate Valid-to date
CharcDateMinimumValue Lower Boundary for Date-Interval
CharcFromDate Lower Boundary for Date-Interval
CharcToDate Upper Boundary for Date-Interval
CharcTimeMinimumValue Lower Boundary for Time-Interval
CharcFromTime Lower Boundary for Time-Interval
CharcToTime Upper Boundary for Time-Interval
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
CharacteristicIsDeleted Deletion Indicator Show values
Column Name Description Domain name
SpecValAssgmtHdr Sequential Number of Data Record ESDRECN
SpecValAssgmt Sequential Number of Data Record ESDRECN
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
CharcDecimalMinimumValue Lower Boundary for Numeric Field
CharcDecimalMaximumValue Upper Boundary for Numeric Field
CharacteristicInternalID Characteristic Internal ID ATINN_NO_CONV
Master Data Relations Join Conditions
Unit of Measurement
  • Client
  • Unit of Measurement
  • A_SPECCHARBYVALUEASSGMTINST.MANDT == T006.MANDT
  • A_SPECCHARBYVALUEASSGMTINST.CHARACTERISTICMAXIMUMVALUEUNIT == T006.MSEHI
Unit of Measurement
  • Unit of Measurement
  • Client
  • A_SPECCHARBYVALUEASSGMTINST.CHARACTERISTICMINIMUMVALUEUNIT == T006.MSEHI
  • A_SPECCHARBYVALUEASSGMTINST.MANDT == T006.MANDT
Recipe Authorization Group
  • Recipe Authorization Group
  • Client
  • A_SPECCHARBYVALUEASSGMTINST.SPECIFICATIONAUTHZNGROUP == TCG36.AUTHGRP
  • A_SPECCHARBYVALUEASSGMTINST.MANDT == TCG36.MANDT
Rating
  • Rating
  • Client
  • A_SPECCHARBYVALUEASSGMTINST.SPECIFICATIONRATING == TCG86.VACLID
  • A_SPECCHARBYVALUEASSGMTINST.MANDT == TCG86.MANDT
Foreign key for substance type
  • Specification Type
  • Client
  • A_SPECCHARBYVALUEASSGMTINST.SPECIFICATIONTYPE == TCG31.SUBCAT
  • A_SPECCHARBYVALUEASSGMTINST.MANDT == TCG31.MANDT
Validity Area
  • Client
  • Validity Area
  • A_SPECCHARBYVALUEASSGMTINST.MANDT == TCG91.MANDT
  • A_SPECCHARBYVALUEASSGMTINST.SPECIFICATIONVALIDITYAREA == TCG91.RVLID
Value Assignment Type
  • Value Assignment Type
  • Client
  • A_SPECCHARBYVALUEASSGMTINST.SPECVALASSGMTTYPE == TCG11.ESTCAT
  • A_SPECCHARBYVALUEASSGMTINST.MANDT == TCG11.MANDT
Reference Value for Component Specification
  • ?
  • Reference Value for Component Specification
  • Client
  • A_SPECCHARBYVALUEASSGMTINST.[column in domain "ESECOMPDIMID"] == TCG74.COMPDIMID
  • A_SPECCHARBYVALUEASSGMTINST.SPECVALASSGMTUNITREFDIMENSION == TCG74.COMPREL
  • A_SPECCHARBYVALUEASSGMTINST.MANDT == TCG74.MANDT