/ssb/designtime_Evaluations

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_Evaluations.
-- 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/DSGNTMEEVAL
-- Parameters: P_language : abap.lang, P_User : syuname

CREATE VIEW /ssb/designtime_Evaluations AS
SELECT
  Evaluations.id AS id,
  is_active,
  coalesce( Evaluations._Text( P_language:$parameters.P_language )[1: Language = :P_language ].title, Evaluations.id ) as title AS idastitle,
  Evaluations._Text( P_language:$parameters.P_language )[1: Language = :P_language ].description AS description,
  indicator_id,
  namespace,
  scaling,
  scaling_ext,
  odata_url,
  view_name,
  column_name,
  owner_name,
  owner_e_mail,
  owner_id,
  created_by,
  created_on,
  changed_by,
  case when Favourites.manual_entry is not null then Favourites.last_worked_on else changed_on end AS changed_on,
  case when Favourites_KPI.manual_entry is not null then Favourites_KPI.last_worked_on else Indicators.changed_on end AS changed_on_KPI,
  Favourites.manual_entry AS manual_entry,
  Favourites_KPI.manual_entry AS manual_entry_KPI,
  Favourites_KPI.last_worked_on AS last_worked_on_KPI,
  action,
  goal_type,
  case when created_by=:P_User then 1 else 0 end AS Self_Created,
  _ViewCount.views_count AS views_count,
  Tile_Count_old.chips_count AS tiles_count,
  Evaluations._Text AS _Text,
  Chips,
  CE_Chips,
  OP_APPS,
  CE_APPS,
  Filters,
  Values,
  Tags,
  DD_Views,
  DD_Config,
  Rep_Config,
  DD_Filters,
  DD_Tiles,
  Properties,
  _EvaluationsCount.counter AS evaluationsCount,
  case when _EvaluationsCount.counter is not null then 0 else 1 end as IsDraft AS counterisnotnullthen0else1endasIsDraft,
  _HeaderCount.header_count AS header_count,
  Evaluations.isCustomerEdited AS isCustomerEdited,
  Evaluations.isNavIntCustEdited AS isNavIntCustEdited,
  Evaluations.isThresholdChanged AS isThresholdChanged,
  Nav_Intents,
  Tag_count.Tag AS PrimaryTag,
  Tag_count.tagcount AS TagsCount,
  case when ( Evaluations.cds_view_name = '' or Evaluations.cds_view_name is null ) then '' when ( released_cds_views.state is not null ) then released_cds_views.state else 'NOT_RELEASED' end as release_state AS stateelseNOT_RELEASEDendasrelease_state,
  Evaluations.application_component AS ApplicationComponent,
  AppComponent.ApplicationComponentKey AS ApplicationComponentKey,
  AppComponent.ApplicationComponentText AS ApplicationComponentText
FROM /ssb/Core_Evaluations AS Evaluations
LEFT OUTER JOIN /SSB/APPLICATION_COMPONENT AS AppComponent ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN /ssb/Core_Favourites AS Favourites ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN /ssb/Core_Favourites AS Favourites_KPI ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN /ssb/Chips_Count AS Tile_Count ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN /ssb/CE_Chips_Count AS CE_Tile_Count ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN /SSB/PRIMARY_TAG_AND_COUNT AS Tag_count ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN ARS_APIS_RELEASED_C1_OR_GROUPS AS released_cds_views ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN /ssb/Evaluation_Count AS _EvaluationsCount ON id = _EvaluationsCount.id AND is_active = _EvaluationsCount.isActive  -- association [0..1]
LEFT OUTER JOIN /ssb/DD_Views_Count AS _ViewCount ON id = _ViewCount.evaluation_id  -- association [0..1]
LEFT OUTER JOIN /ssb/Core_Indicators AS Indicators ON indicator_id = Indicators.id AND Indicators.is_active = '1'  -- association [1..1]
LEFT OUTER JOIN /ssb/Core_Chips AS Chips ON id = Chips.evaluation_id AND Evaluations.is_active = '1'  -- association [0..*]
LEFT OUTER JOIN /ssb/Core_CE_Chips AS CE_Chips ON id = CE_Chips.evaluation_id AND Evaluations.is_active = '1'  -- association [0..*]
LEFT OUTER JOIN /ssb/Core_Evaluation_Filters AS Filters ON id = Filters.id AND Evaluations.is_active = Filters.is_active  -- association [0..*]
LEFT OUTER JOIN /ssb/Core_Evaluation_Values AS Values ON id = Values.id AND Evaluations.is_active = Values.is_active  -- association [0..*]
LEFT OUTER JOIN /ssb/Core_Tags AS Tags ON id = Tags.id AND is_active = Tags.is_active AND Tags.type = 'EV'  -- association [0..*]
LEFT OUTER JOIN /ssb/Designtime_DD_View AS DD_Views ON id = DD_Views.evaluation_id AND is_active = '1' AND DD_Views.is_active = '1'  -- association [0..*]
LEFT OUTER JOIN /ssb/Core_DD_Config AS DD_Config ON id = DD_Config.evaluation_id AND is_active = '1' AND DD_Config.is_active = '1'  -- association [1..1]
LEFT OUTER JOIN /SSB/DESIGNTIME_REPORT_CONFIGS AS Rep_Config ON id = Rep_Config.evaluation_id AND is_active = '1' AND Rep_Config.is_active = '1'  -- association [0..*]
LEFT OUTER JOIN /ssb/Core_DD_Filter AS DD_Filters ON id = DD_Filters.evaluation_id AND is_active = '1' AND DD_Filters.is_active = '1'  -- association [0..*]
LEFT OUTER JOIN /ssb/Core_DD_Tile AS DD_Tiles ON id = DD_Tiles.evaluation_id AND is_active = '1' AND DD_Tiles.is_active = '1'  -- association [0..*]
LEFT OUTER JOIN /ssb/Core_Properties AS Properties ON id = Properties.id AND is_active = Properties.is_active AND Properties.type = 'EV'  -- association [0..*]
LEFT OUTER JOIN /ssb/Core_Nav_Intent AS Nav_Intents ON id = Nav_Intents.id AND is_active = Nav_Intents.is_active AND Nav_Intents.type = 'EV'  -- association [0..*]
LEFT OUTER JOIN /ssb/DD_Header_Count AS _HeaderCount ON id = _HeaderCount.evaluation_id  -- association [0..1]
LEFT OUTER JOIN /SSB/EVAL_ASSOC_ODATA AS _AssociatedEval ON Evaluations.id = _AssociatedEval.evaluation_id  -- association [0..*]
LEFT OUTER JOIN I_User AS UserName ON changed_by = UserName.UserID  -- association [0..1]
LEFT OUTER JOIN /ssb/core_cds_Views AS _CDSView ON Evaluations.cds_view_name = _CDSView.DDLSourceName  -- association [0..1]
LEFT OUTER JOIN /SSB/OP_CHIPS AS OP_APPS ON id = OP_APPS.evaluation_id AND Evaluations.is_active = '1'  -- association [0..*]
LEFT OUTER JOIN /SSB/CLOUD_CHIPS AS CE_APPS ON id = CE_APPS.evaluation_id AND Evaluations.is_active = '1'  -- association [0..*]
LEFT OUTER JOIN /SSB/CHIPS_COUNT_OLD AS Tile_Count_old ON Evaluations.id = Tile_Count_old.evaluation_id  -- association [0..1]
LEFT OUTER JOIN /SSB/CE_CHIPS_COUNT_OLD AS CE_Tile_Count_old ON Evaluations.id = CE_Tile_Count_old.evaluation_id  -- association [0..1]
;