I_MCHierNodeCVRstrn

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_MCHierNodeCVRstrn.
-- 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.

CREATE VIEW I_MCHierNodeCVRstrn AS
SELECT
  cast(MrchdsCatHierNode.class as rfm_mrchdcathiernode preserving type ) AS MrchdsCategoryHierarchyNode,
  Characteristic.atnam AS Characteristic,
  CharcValRestriction.CharcValuePositionNumber AS ClfnCharcValuePositionNumber,
  cast (Characteristic.atinn as atinn_no_conv preserving type ) AS CharcInternalID,
  CharcValRestriction.ClfnObjectID AS ClfnObjectID,
  CharcValRestriction.CharcValue AS CharcValue,
  CharcValRestriction.CharcFromNumericValue AS CharcFromNumericValue,
  CharcValRestriction.CharcFromNumericValueUnit AS CharcFromNumericValueUnit,
  CharcValRestriction.CharcToNumericValue AS CharcToNumericValue,
  CharcValRestriction.CharcToNumericValueUnit AS CharcToNumericValueUnit,
  CharcValRestriction.CharcValueIntervalType AS CharcValueIntervalType,
  CharcValRestriction.IsDeleted AS IsDeleted,
  CharcValRestriction.CharcFromDecimalValue AS CharcFromDecimalValue,
  CharcValRestriction.CharcToDecimalValue AS CharcToDecimalValue,
  CharcValRestriction.CharcFromAmount AS CharcFromAmount,
  CharcValRestriction.CharcToAmount AS CharcToAmount,
  CharcValRestriction.Currency AS Currency,
  CharcValRestriction.CharcFromDate AS CharcFromDate,
  CharcValRestriction.CharcToDate AS CharcToDate,
  CharcValRestriction.CharcFromTime AS CharcFromTime,
  CharcValRestriction.CharcToTime AS CharcToTime
FROM klah AS MrchdsCatHierNode
INNER JOIN I_ClfnObjectCharcValueBasic AS CharcValRestriction ON /* join condition not captured in parsed metadata */
INNER JOIN cabn AS Characteristic ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ClfnCharacteristic AS _Characteristic ON CharcInternalID = _Characteristic.CharcInternalID AND _Characteristic.TimeIntervalNumber = '0000'  -- association [1..1]
LEFT OUTER JOIN I_ClfnCharcDesc AS _CharacteristicDesc ON CharcInternalID = _CharacteristicDesc.CharcInternalID  -- association [0..*]
LEFT OUTER JOIN I_MrchdsCategoryHierarchyNode AS _MrchdsCategoryHierarchyNode ON MrchdsCategoryHierarchyNode = _MrchdsCategoryHierarchyNode.MrchdsCategoryHierarchyNode  -- association [1..1]
LEFT OUTER JOIN I_MrchdsCatHierNodeCharc AS _MrchdsCatHierNodeCharc ON MrchdsCategoryHierarchyNode = _MrchdsCatHierNodeCharc.MrchdsCategoryHierarchyNode AND Characteristic = _MrchdsCatHierNodeCharc.Characteristic  -- association [1..1]
;