Test_Cds_Astcheck_24

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 Test_Cds_Astcheck_24.
-- 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: testcdsac24

CREATE VIEW Test_Cds_Astcheck_24 AS
SELECT
  node_key,
  so_id,
  created_by,
  created_at,
  changed_by,
  changed_at,
  note_guid,
  buyer_guid,
  gross_amount,
  net_amount,
  tax_amount,
  op_id,
  dummy,
  buyer,
  created,
  changed,
  note,
  currency
FROM snwd_so
LEFT OUTER JOIN qlast_sddl_bpa AS buyer ON buyer_guid = buyer.node_key  -- association [*]
LEFT OUTER JOIN qlast_sddl_texts AS note ON note_guid = note.parent_key  -- association [2]
LEFT OUTER JOIN qlast_sddl_bpa AS created_by_partner ON snwd_so.created_by = created_by_partner.node_key AND created_by_bp = 'X'  -- association [0..*]
LEFT OUTER JOIN qlast_sddl_bpa AS changed_by_partner ON snwd_so.changed_by = changed_by_partner.node_key AND changed_by_bp = 'X'  -- association [0..2]
LEFT OUTER JOIN qlast_sddl_employee AS created ON snwd_so.created_by = created.node_key AND created_by_bp = ' '  -- association [0..1]
LEFT OUTER JOIN qlast_sddl_employee AS changed ON snwd_so.changed_by = changed.node_key AND changed_by_bp = ' '  -- association [0..1]
LEFT OUTER JOIN tcurc AS currency ON currency_code = waers  -- association [2]
;