I_ClfnCharcValue

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_ClfnCharcValue.
-- 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: INGCCHR17

CREATE VIEW I_ClfnCharcValue AS
SELECT
  cast ( CharacteristicValue.atinn as atinn_no_conv preserving type ) AS CharcInternalID,
  CharacteristicValue.atzhl AS CharcValuePositionNumber,
  CharacteristicValue.adzhl AS TimeIntervalNumber,
  CharacteristicValue.atzhh AS CharcValueParentPositionNumber,
  CharacteristicValue.atwhi AS CharcValueHasChild,
  CharacteristicValue.atcod AS CharcValueIntervalType,
  CharacteristicValue.atwrt AS CharcValue,
  CharacteristicValue.atflv AS CharcFromNumericValue,
  CharacteristicValue.atflb AS CharcToNumericValue,
  CharacteristicValue.atstd AS IsDefaultValue,
  CharacteristicValue.atawe AS CharcFromNumericValueUnit,
  CharacteristicValue.ataw1 AS CharcToNumericValueUnit,
  CharacteristicValue.dec_from AS CharcFromDecimalValue,
  CharacteristicValue.dec_to AS CharcToDecimalValue,
  CharacteristicValue.date_from AS CharcFromDate,
  CharacteristicValue.date_to AS CharcToDate,
  CharacteristicValue.time_from AS CharcFromTime,
  CharacteristicValue.time_to AS CharcToTime,
  CharacteristicValue.curr_from AS CharcFromAmount,
  CharacteristicValue.curr_to AS CharcToAmount,
  CharacteristicValue.currency AS Currency,
  CharacteristicValue.txtnr AS LongTextID,
  CharacteristicValue.aennr AS ChangeNumber,
  CharacteristicValue.datuv AS ValidityStartDate,
  CharacteristicValue.datub AS ValidityEndDate,
  CharacteristicValue.lkenz AS IsDeleted,
  CharacteristicValue.doknr AS DocumentInfoRecordDocNumber,
  CharacteristicValue.doktl AS DocumentInfoRecordDocPart,
  CharacteristicValue.dokvr AS DocumentInfoRecordDocVersion,
  CharacteristicValue.dokar AS DocumentInfoRecordDocType,
  CharacteristicValue.atidn AS CharcIdentificationCode
FROM cawn AS CharacteristicValue
LEFT OUTER JOIN I_Currency AS _Currency ON Currency = _Currency.Currency  -- association [0..1]
;