/SSB/DESIGNTIME_SAC_STORIES

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/DESIGNTIME_SAC_STORIES.
-- 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/DTSACSTRY

CREATE VIEW /SSB/DESIGNTIME_SAC_STORIES AS
SELECT
  SACStories.id AS Id,
  SACStories.resource_id AS Resource_Id,
  SACStories.resource_type AS Resource_Type,
  SACStories.resource_subtype AS Resource_SubType,
  SACStories.namespace AS Namespace,
  coalesce ( SACStoryTexts[1: IsLogonLanguage = 1].Title, SACStories.id) as Title AS idasTitle,
  SACStoryTexts[1: IsLogonLanguage = 1].Description AS Description,
  devclass AS PackageName,
  Packages.ApplicationComponent AS Application_Component,
  Packages.ApplicationComponentText AS Application_Component_Text,
  SACStories.owner AS Owner,
  Users.UserName AS OwnerName,
  Users.UserEmail AS OwnerEmail,
  coalesce( UserName.UserDescription, SACStories.changed_by ) AS ChangedByUser,
  SACStories.created_by AS Created_By,
  SACStories.created_on AS Created_On,
  SACStories.changed_by AS Changed_By,
  SACStories.changed_on AS Changed_On,
  TagsCount.PrimaryTag AS PrimaryTag,
  TagsCount.TagsCount AS TagsCount,
  ModelsCount.PrimaryDataSource AS PrimaryDataSource,
  ModelsCount.DataSourceCount AS DataSourceCount,
  StoryTilesCount.TilesCount AS ApplicationCount,
  Favourites.manual_entry AS ManualEntry,
  StoryLatestJobInfo.job_status AS JobStatus,
  StoryLatestJobInfo.job_type AS JobType,
  SACStoryTexts,
  Tags,
  Models,
  SAC_CHIPS
FROM /SSB/CORE_SAC_STORIES AS SACStories
LEFT OUTER JOIN /SSB/CORE_SAC_STORIES_TEXTS AS SACStoryTexts ON SACStories.id = SACStoryTexts.Id  -- association [0..*]
LEFT OUTER JOIN /SSB/CORE_SAC_STORIES_TAGS AS Tags ON SACStories.id = Tags.Id  -- association [0..*]
LEFT OUTER JOIN /SSB/SAC_TAG_COUNT AS TagsCount ON SACStories.id = TagsCount.id  -- association [0..1]
LEFT OUTER JOIN /SSB/CORE_SAC_STORIES_MODELS AS Models ON SACStories.id = Models.id  -- association [0..*]
LEFT OUTER JOIN /SSB/SAC_MODEL_COUNT AS ModelsCount ON SACStories.id = ModelsCount.id  -- association [0..1]
LEFT OUTER JOIN I_User AS UserName ON SACStories.changed_by = UserName.UserID  -- association [0..1]
LEFT OUTER JOIN /ssb/Core_Favourites AS Favourites ON SACStories.id = Favourites.id AND Favourites.type = 'AC' AND Favourites.user_id = $session.user  -- association [0..1]
LEFT OUTER JOIN /SSB/CORE_SAC_STORY_TILES AS SAC_CHIPS ON SACStories.id = SAC_CHIPS.id  -- association [0..*]
LEFT OUTER JOIN /SSB/SAC_STORY_TILES_COUNT AS StoryTilesCount ON SACStories.id = StoryTilesCount.id  -- association [0..1]
LEFT OUTER JOIN /SSB/CORE_USERS AS Users ON SACStories.owner = Users.UserId  -- association [0..1]
LEFT OUTER JOIN /SSB/STORIES_LATEST_JOB_STATUS AS StoryLatestJobInfo ON SACStories.id = StoryLatestJobInfo.id  -- association [0..1]
LEFT OUTER JOIN /SSB/PACKAGES AS Packages ON Packages.PackageName = SACStories.devclass  -- association [1..1]
;