/ssb/Core_Indicators

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_Indicators.
-- 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/_CINS

CREATE VIEW /ssb/Core_Indicators AS
SELECT
  Union_Indicator.id AS id,
  Union_Indicator.is_active AS is_active,
  Union_Indicator.namespace AS namespace,
  Union_Indicator.type AS type,
  Union_Indicator.goal_type AS goal_type,
  Union_Indicator.odata_url AS odata_url,
  Union_Indicator.view_name AS view_name,
  Union_Indicator.column_name AS column_name,
  Union_Indicator.owner_name AS owner_name,
  Union_Indicator.owner_e_mail AS owner_e_mail,
  Union_Indicator.owner_id AS owner_id,
  Union_Indicator.created_by AS created_by,
  Union_Indicator.created_on AS created_on,
  Union_Indicator.changed_by AS changed_by,
  Union_Indicator.changed_on AS changed_on,
  Union_Indicator.action AS action,
  Union_Indicator.description AS description
FROM /ssb/union_Indicators AS Union_Indicator
LEFT OUTER JOIN /SSB/UNION_REPORT_CONFIGS AS UnionReportConfig ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN /ssb/Core_Indicator_Texts AS _Text ON id = _Text.id AND is_active = _Text.is_active  -- association [*]
;