/SSB/CORE_REPORT_CONFIGS

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/CORE_REPORT_CONFIGS.
-- 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/_CRCS

CREATE VIEW /SSB/CORE_REPORT_CONFIGS AS
SELECT
  RepsOnKPI.id AS id,
  RepsOnKPI.is_active AS is_active,
  RepsOnKPI.namespace AS namespace,
  RepsOnKPI.type AS type,
  Evaluations.indicator_id AS indicator_id,
  RepsOnKPI.created_by AS created_by,
  RepsOnKPI.created_on AS created_on,
  RepsOnKPI.changed_by AS changed_by,
  RepsOnKPI.changed_on AS changed_on,
  RepsOnKPI.owner_e_mail AS owner_e_mail,
  RepsOnKPI.owner_id AS owner_id,
  RepsOnKPI.owner_name AS owner_name,
  RepsOnKPI.ref_rep_id AS ref_rep_id,
  RepsOnKPI.isCustomerEdited AS isCustomerEdited,
  Evaluations.scaling AS scaling,
  Evaluations.odata_url AS odata_url,
  Evaluations.column_name AS column_name
FROM /SSB/REPORT_EXTENSION AS RepsOnKPI
INNER JOIN /ssb/Union_Evaluations AS Evaluations ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): /SSB/REPORT_EXTENSION
;