Sycm_Simplification_Item

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 Sycm_Simplification_Item.
-- 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: SYCMVSITEM

CREATE VIEW Sycm_Simplification_Item AS
SELECT
  header.id AS id,
  header.version AS version,
  header.title AS title,
  header.note AS note
FROM sycm_sitem AS header
LEFT OUTER JOIN Sycm_S_Item_Areas AS _Areas ON header.id = _Areas.id AND header.version = _Areas.version  -- association [0..*]
LEFT OUTER JOIN Sycm_S_Item_Entry_Points AS _Entry_Points ON header.id = _Entry_Points.id AND header.version = _Entry_Points.version  -- association [0..*]
LEFT OUTER JOIN Sycm_S_Item_Packages AS _Packages ON header.id = _Packages.id AND header.version = _Packages.version  -- association [0..*]
LEFT OUTER JOIN Sycm_S_Item_Piece_Lists AS _Piece_Lists ON header.id = _Piece_Lists.id AND header.version = _Piece_Lists.version  -- association [0..*]
LEFT OUTER JOIN Sycm_S_Item_Status AS _Status ON header.id = _Status.id AND header.version = _Status.version  -- association [0..*]
LEFT OUTER JOIN sycm_simplification_item AS _Replacement ON _Replacement.id = header.replacement_id  -- association [0..*]
;