I_ClfnObjectCharcValueBasic

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_ClfnObjectCharcValueBasic.
-- 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: INGCCLFN23

CREATE VIEW I_ClfnObjectCharcValueBasic AS
SELECT
  Valuation.objek AS ClfnObjectID,
  cast ( Valuation.atinn as atinn_no_conv preserving type ) AS CharcInternalID,
  Valuation.atzhl AS CharcValuePositionNumber,
  Valuation.mafid AS ClfnObjectType,
  Valuation.klart AS ClassType,
  Valuation.adzhl AS TimeIntervalNumber,
  Valuation.atcod AS CharcValueIntervalType,
  Valuation.atwrt AS CharcValue,
  Valuation.atflv AS CharcFromNumericValue,
  Valuation.atawe AS CharcFromNumericValueUnit,
  Valuation.atflb AS CharcToNumericValue,
  Valuation.ataw1 AS CharcToNumericValueUnit,
  Valuation.dec_value_from AS CharcFromDecimalValue,
  Valuation.dec_value_to AS CharcToDecimalValue,
  Valuation.curr_value_from AS CharcFromAmount,
  Valuation.curr_value_to AS CharcToAmount,
  Valuation.currency AS Currency,
  Valuation.date_from AS CharcFromDate,
  Valuation.date_to AS CharcToDate,
  Valuation.time_from AS CharcFromTime,
  Valuation.time_to AS CharcToTime,
  Valuation.ataut AS CharacteristicAuthor,
  Valuation.aennr AS ChangeNumber,
  Valuation.atsrt AS CharcValueSortPosition,
  Valuation.datuv AS ValidityStartDate,
  Valuation.datub AS ValidityEndDate,
  Valuation.lkenz AS IsDeleted
FROM ausp AS Valuation
;