/ssb/designtime_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/designtime_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/DSGNTMEIND
-- Parameters: P_language : abap.lang, P_User : syuname

CREATE VIEW /ssb/designtime_Indicators AS
SELECT
  Indicators.id AS id,
  is_active,
  coalesce ( Indicators._Text( P_language:$parameters.P_language )[1: Language = :P_language].title, Indicators.id) as title AS idastitle,
  Indicators._Text( P_language:$parameters.P_language )[1: Language = :P_language ].description AS description,
  namespace,
  Indicators.type AS type,
  goal_type,
  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,
  action,
  Favourites.manual_entry AS manual_entry,
  case when EvalCount.eval_count is null then 0 else EvalCount.eval_count end as Evaluations_count AS eval_countendasEvaluations_count,
  case when created_by=:P_User then 1 else 0 end AS Self_Created,
  IndicatorCount.counter AS IndicatorCount,
  case when IndicatorCount.counter is not null then 0 else 1 end as IsDraft AS counterisnotnullthen0else1endasIsDraft,
  Indicators._Text AS _Text,
  Evaluations,
  Tags,
  CE_REP_Chips,
  REP_CHIPS,
  Properties,
  Associations,
  Tag_count.Tag AS PrimaryTag,
  Tag_count.tagcount AS TagsCount,
  case when ( Indicators.cds_view_name = '' or Indicators.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
FROM /ssb/Core_Indicators AS Indicators
LEFT OUTER JOIN /SSB/APPLICATION_COMPONENT AS AppComponent ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN /ssb/Indicator_Count AS IndicatorCount 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/evaluations_Count AS EvalCount ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN /ssb/CE_REP_Chips_Count AS CE_REP_Tile_Count ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN /SSB/REP_CHIPS_COUNT AS REP_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/designtime_Evaluations AS Evaluations ON id = Evaluations.indicator_id  -- association [0..*]
LEFT OUTER JOIN /ssb/designtime_Associations AS Associations ON id = Associations.source_indicator OR id = Associations.target_indicator  -- association [0..*]
LEFT OUTER JOIN /ssb/Association_Source_Count AS Associations_Source_Count ON id = Associations_Source_Count.source_indicator  -- association [0..*]
LEFT OUTER JOIN /ssb/Association_Target_Count AS Associations_Target_Count ON id = Associations_Target_Count.target_indicator  -- association [0..*]
LEFT OUTER JOIN /ssb/Core_Tags AS Tags ON id = Tags.id AND is_active = Tags.is_active AND Tags.type = 'IN'  -- association [0..*]
LEFT OUTER JOIN /ssb/Core_CE_REP_Chips AS CE_REP_Chips ON id = CE_REP_Chips.report_id AND CE_REP_Chips.is_active = '1'  -- association [0..*]
LEFT OUTER JOIN /SSB/CORE_REP_CHIPS AS REP_CHIPS ON id = REP_CHIPS.report_id AND REP_CHIPS.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 = 'IN'  -- association [0..*]
LEFT OUTER JOIN I_User AS UserName ON changed_by = UserName.UserID  -- association [0..1]
;