/SSB/CORE_SAC_STORY_TILES

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_STORY_TILES.
-- 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/COSACTILES

CREATE VIEW /SSB/CORE_SAC_STORY_TILES AS
SELECT
  SACTiles.id AS id,
  chip_id,
  type,
  SACStory.Namespace AS namespace,
  SACTilesText[1: IsLogonLanguage = 1].title AS title,
  SACTilesText[1: IsLogonLanguage = 1].subtitle AS subtitle,
  catalog_id,
  variant_id,
  chip_config,
  fiori_id,
  SACTiles.created_by AS created_by,
  SACTiles.created_on AS created_on,
  SACTiles.changed_by AS changed_by,
  SACTiles.changed_on AS changed_on,
  SACStory,
  SACTilesText,
  SACNavIntents,
  Evaluations
FROM /ssb/sactile_s AS SACTiles
LEFT OUTER JOIN /SSB/DESIGNTIME_SAC_STORIES AS SACStory ON SACTiles.id = SACStory.Id  -- association [1..1]
LEFT OUTER JOIN /SSB/CORE_SAC_STORY_TILES_TEXT AS SACTilesText ON SACTiles.id = SACTilesText.id AND SACTiles.chip_id = SACTilesText.chip_id  -- association [0..*]
LEFT OUTER JOIN /SSB/UNION_SAC_NAV_INTENTS AS SACNavIntents ON SACTiles.id = SACNavIntents.id AND SACTiles.chip_id = SACNavIntents.chip_id  -- association [0..*]
LEFT OUTER JOIN /ssb/designtime_Evaluations AS Evaluations ON evaluation_id = Evaluations.id AND Evaluations.is_active = '1'  -- association [0..1]
LEFT OUTER JOIN /SSB/CORE_DEFAULT_PARAMS AS _DefaultParams ON id = _DefaultParams.id AND chip_id = _DefaultParams.chip_id  -- association [0..*]
;