I_SpecCharByValueAssgmtInst

DDL: I_SPECCHARBYVALUEASSGMTINST SQL: ISPECCHARBYVAI Type: view COMPOSITE
42 Fields 3 Data Sources

Specification Characteristic by VAI

I_SpecCharByValueAssgmtInst is a Composite CDS View that provides data about "Specification Characteristic by VAI" in SAP S/4HANA. It reads from 3 data sources (I_ClfnCharacteristic, I_ClfnObjectCharcValue, I_SpecValAssgmtInstance) and exposes 42 fields with key fields SpecValAssgmtHdr, SpecValAssgmt, CharacteristicInternalID, CharcValuePositionNumber.

Data Sources (3)

SourceAliasJoin Type
I_ClfnCharacteristic characteristic inner
I_ClfnObjectCharcValue charvalue inner
I_SpecValAssgmtInstance I_SpecValAssgmtInstance from

Parameters (1)

NameTypeDefault
P_KeyDate sydate

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ISPECCHARBYVAI view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #COMPOSITE view
EndUserText.label Specification Characteristic by VAI view

Fields (42)

KeyFieldSource TableSource FieldDescription
KEY SpecValAssgmtHdr vainst SpecValAssgmtHdr
KEY SpecValAssgmt vainst SpecValAssgmt
KEY CharacteristicInternalID I_ClfnObjectCharcValue CharcInternalID Characteristic Internal ID
KEY CharcValuePositionNumber I_ClfnObjectCharcValue CharcValuePositionNumber
SpecValAssgmtIsInhtncSource vainst SpecValAssgmtIsInhtncSource
SpecificationInternalID vainst SpecificationInternalID Specification
InhtdSpecValAssgmtIsTmpChgd vainst InhtdSpecValAssgmtIsTmpChgd
InhtdSpecValAssgmtIsPermChgd vainst InhtdSpecValAssgmtIsPermChgd
SpecInheritanceTemplate vainst SpecInheritanceTemplate
SpecValAssgmtInheritanceParent vainst SpecValAssgmtInheritanceParent
SpecValAssgmtInheritanceRoot vainst SpecValAssgmtInheritanceRoot
SpecValAssgmtRootSpecIntID vainst SpecValAssgmtRootSpecIntID
SpecValAssgmtType vainst SpecValAssgmtType Val. Asst Type
SpecValAssgmtSortSequence vainst SpecValAssgmtSortSequence
SpecValAssgmtUnitRefDimension vainst SpecValAssgmtUnitRefDimension
ValueAssignmentSource vainst ValueAssignmentSource
SpecificationRating vainst SpecificationRating Rating
SpecificationValidityArea vainst SpecificationValidityArea Validity Area
SpecValAssgmtUsageIsExcluded vainst SpecValAssgmtUsageIsExcluded
SpecValAssgmtUsageIsActive vainst SpecValAssgmtUsageIsActive
SpecValAssgmtUsageIsRelevant vainst SpecValAssgmtUsageIsRelevant
CharcValueUnit I_ClfnCharacteristic CharcValueUnit Internal UoM
Characteristic I_ClfnCharacteristic Characteristic Field Name
CharacteristicFormat I_ClfnCharacteristic CharcDataType Format
CharacteristicValue I_ClfnObjectCharcValue CharcValue Char. Value
CharacteristicMinimumValueUnit I_ClfnObjectCharcValue CharcFromNumericValueUnit Internal UoM
CharacteristicMaximumValueUnit I_ClfnObjectCharcValue CharcToNumericValueUnit Internal UoM
CharcFromDecimalValue I_ClfnObjectCharcValue CharcFromDecimalValue LowrBndry Nmrc
CharcToDecimalValue I_ClfnObjectCharcValue CharcToDecimalValue UprBndry Nmrc
CharcFromAmount I_ClfnObjectCharcValue CharcFromAmount LowrBndry Crcy
CharcToAmount I_ClfnObjectCharcValue CharcToAmount UprBndry Crcy
Currency I_ClfnObjectCharcValue Currency Valuation Crcy
CharcFromDate I_ClfnObjectCharcValue CharcFromDate LowrBndry Date
CharcToDate I_ClfnObjectCharcValue CharcToDate UprBndry Date
CharcFromTime I_ClfnObjectCharcValue CharcFromTime LowrBndry Time
CharcToTime I_ClfnObjectCharcValue CharcToTime UprBndry Time
CharacteristicValueDpndcyCode I_ClfnObjectCharcValue CharcValueIntervalType Code
CharcValidityStartDate I_ClfnObjectCharcValue ValidityStartDate Validity Start Date
CharcValidityEndDate I_ClfnObjectCharcValue ValidityEndDate ValidTo
_Rating _Rating
_ValidityArea _ValidityArea
_SpecificationForKeyDate _SpecificationForKeyDate

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_SpecCharByValueAssgmtInst.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: ISPECCHARBYVAI
-- Parameters: P_KeyDate : sydate

CREATE VIEW I_SpecCharByValueAssgmtInst AS
SELECT
  vainst.SpecValAssgmtHdr AS SpecValAssgmtHdr,
  vainst.SpecValAssgmt AS SpecValAssgmt,
  charvalue.CharcInternalID AS CharacteristicInternalID,
  charvalue.CharcValuePositionNumber AS CharcValuePositionNumber,
  vainst.SpecValAssgmtIsInhtncSource AS SpecValAssgmtIsInhtncSource,
  vainst.SpecificationInternalID AS SpecificationInternalID,
  vainst.InhtdSpecValAssgmtIsTmpChgd AS InhtdSpecValAssgmtIsTmpChgd,
  vainst.InhtdSpecValAssgmtIsPermChgd AS InhtdSpecValAssgmtIsPermChgd,
  vainst.SpecInheritanceTemplate AS SpecInheritanceTemplate,
  vainst.SpecValAssgmtInheritanceParent AS SpecValAssgmtInheritanceParent,
  vainst.SpecValAssgmtInheritanceRoot AS SpecValAssgmtInheritanceRoot,
  vainst.SpecValAssgmtRootSpecIntID AS SpecValAssgmtRootSpecIntID,
  vainst.SpecValAssgmtType AS SpecValAssgmtType,
  vainst.SpecValAssgmtSortSequence AS SpecValAssgmtSortSequence,
  vainst.SpecValAssgmtUnitRefDimension AS SpecValAssgmtUnitRefDimension,
  vainst.ValueAssignmentSource AS ValueAssignmentSource,
  vainst.SpecificationRating AS SpecificationRating,
  vainst.SpecificationValidityArea AS SpecificationValidityArea,
  vainst.SpecValAssgmtUsageIsExcluded AS SpecValAssgmtUsageIsExcluded,
  vainst.SpecValAssgmtUsageIsActive AS SpecValAssgmtUsageIsActive,
  vainst.SpecValAssgmtUsageIsRelevant AS SpecValAssgmtUsageIsRelevant,
  characteristic.CharcValueUnit AS CharcValueUnit,
  characteristic.Characteristic AS Characteristic,
  characteristic.CharcDataType AS CharacteristicFormat,
  charvalue.CharcValue AS CharacteristicValue,
  charvalue.CharcFromNumericValueUnit AS CharacteristicMinimumValueUnit,
  charvalue.CharcToNumericValueUnit AS CharacteristicMaximumValueUnit,
  charvalue.CharcFromDecimalValue AS CharcFromDecimalValue,
  charvalue.CharcToDecimalValue AS CharcToDecimalValue,
  charvalue.CharcFromAmount AS CharcFromAmount,
  charvalue.CharcToAmount AS CharcToAmount,
  charvalue.Currency AS Currency,
  charvalue.CharcFromDate AS CharcFromDate,
  charvalue.CharcToDate AS CharcToDate,
  charvalue.CharcFromTime AS CharcFromTime,
  charvalue.CharcToTime AS CharcToTime,
  charvalue.CharcValueIntervalType AS CharacteristicValueDpndcyCode,
  charvalue.ValidityStartDate AS CharcValidityStartDate,
  charvalue.ValidityEndDate AS CharcValidityEndDate
FROM I_SpecValAssgmtInstance
INNER JOIN I_ClfnObjectCharcValue AS charvalue ON /* join condition not captured in parsed metadata */
INNER JOIN I_ClfnCharacteristic AS characteristic ON /* join condition not captured in parsed metadata */
;

Learn More