/ssb/core_sac_op_app

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_sac_op_app.
-- 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/OPSACAPPS

CREATE VIEW /ssb/core_sac_op_app AS
SELECT
  SacApp.chip_id AS chip_id,
  SacApp.resource_id AS resource_id,
  SacApp.system_alias AS system_alias,
  SacApp.catalog_id AS catalog_id,
  SacApp.chip_type AS chip_type,
  SacApp.variant_id AS variant_id,
  SacApp.created_by AS created_by,
  SacApp.created_on AS created_on,
  SacApp.changed_by AS changed_by,
  SacApp.changed_on AS changed_on,
  coalesce( _Evaluations._Text( P_language:$session.system_language )[1: Language = $session.system_language ].title, _Evaluations.id ) as Evaluation_Title AS idasEvaluation_Title
FROM /ssb/sac_app AS SacApp
LEFT OUTER JOIN /ssb/Core_Evaluations AS _Evaluations ON evaluation_id = _Evaluations.id AND _Evaluations.is_active = '1'  -- association [0..1]
LEFT OUTER JOIN /SSB/UNION_SAC_NAV_INTENTS AS _OPSACNavIntents ON chip_id = _OPSACNavIntents.chip_id AND resource_id = _OPSACNavIntents.id AND _OPSACNavIntents.type = 'SS'  -- association [0..*]
;