/SSB/REPORT_EXTENSION

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 /SSB/REPORT_EXTENSION.
-- 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: /SSB/REPEXT

CREATE VIEW /SSB/REPORT_EXTENSION AS
SELECT
  Reports.id AS id,
  Reports.is_active AS is_active,
  'S' AS namespace,
  Reports.type AS type,
  Reports.scaling AS scaling,
  Reports.odata_url AS odata_url,
  Reports.column_name AS column_name,
  Reports.owner_e_mail AS owner_e_mail,
  Reports.owner_id AS owner_id,
  Reports.owner_name AS owner_name,
  Reports.created_by AS created_by,
  Reports.created_on AS created_on,
  _CustomerEditrep.ref_id AS ref_rep_id,
  _CustomerEditrep.changed_on AS changed_on,
  _CustomerEditrep.changed_by AS changed_by,
  0 AS isCustomerEdited
FROM /ssb/rpt_conf_s AS Reports
LEFT OUTER JOIN /ssb/rpt_conf AS _CustomerEditrep ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): /ssb/rpt_conf
;