I_UtilsProdCharValue

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_UtilsProdCharValue.
-- 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: IUILPRDCHARVAL

CREATE VIEW I_UtilsProdCharValue AS
SELECT
  _V.ClfnObjectID AS ClfnObjectID,
  _V.ClfnObjectTable AS ClfnObjectTable,
  _V.CharcInternalID AS CharcInternalID,
  _V.CharcValuePositionNumber AS CharcValuePositionNumber,
  _V.ClfnObjectType AS ClfnObjectType,
  _V.ClassType AS ClassType,
  _P.ProductType AS ProductType,
  _P.ProductGroup AS ProductGroup,
  _P.AuthorizationGroup AS ProductAuthorizationGroup,
  _V.ValidityStartDate AS ValidityStartDate,
  _V.ValidityEndDate AS ValidityEndDate,
  _Characteristic.Characteristic AS Characteristic,
  _Characteristic.CharcDataType AS CharcDataType,
  _V.CharcValue AS CharcValue,
  _V.CharcFromAmount AS CharcFromAmount,
  _V.CharcToAmount AS CharcToAmount,
  _V.Currency AS Currency,
  _V.CharcFromDecimalValue AS CharcFromDecimalValue,
  _V.CharcToDecimalValue AS CharcToDecimalValue,
  _V.CharcFromDate AS CharcFromDate,
  _V.CharcToDate AS CharcToDate,
  _V.CharcFromNumericValue AS CharcFromNumericValue,
  _V.CharcToNumericValue AS CharcToNumericValue,
  _V.CharcFromNumericValueUnit AS CharcFromNumericValueUnit,
  _V.CharcToNumericValueUnit AS CharcToNumericValueUnit,
  _V.CharcFromTime AS CharcFromTime,
  _V.CharcToTime AS CharcToTime,
  _Characteristic.CharcValueUnit AS CharcValueUnit,
  _Characteristic.CharcDecimals AS CharcDecimals,
  _Characteristic.CharcLength AS CharcLength,
  _Characteristic.CharcCheckTable AS CharcCheckTable,
  _Characteristic.CharcReferenceTable AS CharcReferenceTable,
  _Characteristic.CharcReferenceTableField AS CharcReferenceTableField,
  _Characteristic.CharcConversionRoutine AS CharcConversionRoutine,
  _Characteristic.ValueIntervalIsAllowed AS ValueIntervalIsAllowed,
  _Characteristic.AdditionalValueIsAllowed AS AdditionalValueIsAllowed,
  _Characteristic.MultipleValuesAreAllowed AS MultipleValuesAreAllowed,
  cast( 5 as vch_hl_assignment_type ) AS VarConfignValueAssignmentType,
  _P._ProductType AS _ProductType,
  _P._ProductGroup AS _ProductGroup,
  _Characteristic.EntryIsRequired AS EntryIsRequired,
  _Characteristic.NegativeValueIsAllowed AS NegativeValueIsAllowed,
  _Characteristic.ValueIsCaseSensitive AS ValueIsCaseSensitive,
  _Characteristic.CharcIsHidden AS CharcIsHidden,
  _Characteristic.CharcIsReadOnly AS CharcIsReadOnly,
  _Characteristic.CharcIsRestrictable AS CharcIsRestrictable,
  _Characteristic.CharcStatus AS CharcStatus,
  _Characteristic.CharcTemplate AS CharcTemplate,
  _Characteristic.CharcExponentFormat AS CharcExponentFormat,
  _Characteristic.CharcExponentValue AS CharcExponentValue,
  _Characteristic.CharcMaintAuthGrp AS CharcMaintAuthGrp,
  cast( '' as atstd preserving type ) AS IsDefaultValue
FROM I_ClfnObjectCharcValForKeyDate
INNER JOIN I_Product AS _P ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ClfnObjectCharcValue AS _CharacteristicValue ON _CharacteristicValue.CharcInternalID = CharcInternalID AND _CharacteristicValue.CharcValue = CharcValue  -- association [0..*]
LEFT OUTER JOIN I_ClfnCharacteristic AS _Characteristic ON CharcInternalID = _Characteristic.CharcInternalID AND ValidityStartDate <= _Characteristic.ValidityEndDate AND ValidityEndDate >= _Characteristic.ValidityStartDate  -- association [1..1]
;