/SSB/DESIGNTIME_REPORT_CONFIGS

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_REPORT_CONFIGS.
-- 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/DSGNTMEREPC

CREATE VIEW /SSB/DESIGNTIME_REPORT_CONFIGS AS
SELECT
  reports.id AS id,
  reports.is_active AS is_active,
  coalesce( _Text[1: IsLogonLanguage = 1].title, reports.id ) AS title,
  _Text[1: IsLogonLanguage = 1].sub_title AS sub_title,
  _Text[1: IsLogonLanguage = 1].description AS description,
  namespace,
  reports.type AS type,
  reports.indicator_id AS indicator_id,
  reports.service AS ServiceName,
  reports.service_type AS ServiceType,
  scaling,
  view_name,
  odata_url,
  column_name,
  created_by,
  created_on,
  coalesce(UserName.UserDescription, changed_by ) AS changed_by,
  owner_id,
  owner_name,
  owner_e_mail,
  Tag_count.Tag AS PrimaryTag,
  Tag_count.tagcount AS TagsCount,
  0 AS VisualFiltersCount,
  ReportType,
  isCustomerEdited
FROM /SSB/CORE_REPORT_DD_CONFIG AS reports
LEFT OUTER JOIN /SSB/PRIMARY_TAG_AND_COUNT AS Tag_count ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN /ssb/Core_Tags AS _Tags ON ( id = _Tags.id AND is_active = _Tags.is_active AND _Tags.type = 'RP' ) OR ( indicator_id = _Tags.id AND is_active = _Tags.is_active AND _Tags.type = 'IN' AND type = '1' AND ReportType = 'DD_CONFIG' )  -- association [0..*]
LEFT OUTER JOIN /SSB/CORE_REPORT_CONFIG_TEXTS AS _Text ON id = _Text.id AND is_active = _Text.is_active  -- association [0..*]
LEFT OUTER JOIN I_User AS UserName ON changed_by = UserName.UserID  -- association [0..1]
LEFT OUTER JOIN /SSB/DESIGNTIME_APPLICATIONS AS _Applications ON ( id = _Applications.parentId OR indicator_id = _Applications.parentId ) AND ( is_active = _Applications.is_active )  -- association [0..*]
LEFT OUTER JOIN /ssb/designtime_Evaluations AS _Evaluations ON evaluation_id = _Evaluations.id AND is_active = _Evaluations.is_active  -- association [0..1]
LEFT OUTER JOIN /ssb/Core_DD_Filter AS _DDFilters ON id = _DDFilters.evaluation_id AND is_active = _DDFilters.is_active  -- association [0..*]
LEFT OUTER JOIN /ssb/Core_DD_Tile AS _DDTiles ON id = _DDTiles.evaluation_id AND is_active = _DDTiles.is_active  -- association [0..*]
LEFT OUTER JOIN /ssb/Designtime_DD_View AS _DDViews ON id = _DDViews.evaluation_id AND is_active = _DDViews.is_active  -- association [0..*]
LEFT OUTER JOIN /ssb/Core_Chips AS _Chips ON id = _Chips.evaluation_id AND is_active = _Chips.is_active  -- association [0..*]
LEFT OUTER JOIN /ssb/Core_CE_Chips AS _CEChips ON id = _CEChips.evaluation_id AND is_active = _CEChips.is_active  -- association [0..*]
LEFT OUTER JOIN /ssb/Core_Nav_Intent AS _NavIntents ON id = _NavIntents.id AND is_active = _NavIntents.is_active  -- association [0..*]
LEFT OUTER JOIN /SSB/CORE_REPORT_FILTERS AS _Filters ON id = _Filters.id AND is_active = _Filters.is_active  -- association [0..*]
LEFT OUTER JOIN /ssb/Core_Evaluation_Texts AS _EvalTexts ON id = _EvalTexts.id AND is_active = _EvalTexts.is_active  -- association [0..*]
LEFT OUTER JOIN /SSB/CORE_ALP_REPORT_TEXTS AS _ReportTexts ON id = _ReportTexts.id AND is_active = _ReportTexts.is_active  -- association [0..*]
LEFT OUTER JOIN /SSB/DESIGNTIME_KPI_TAGS AS _KPITags ON id = _KPITags.id AND is_active = _KPITags.is_active  -- association [0..*]
LEFT OUTER JOIN /SSB/CORE_VISUAL_FILTERS AS _VisualFilters ON id = _VisualFilters.report_id AND is_active = _VisualFilters.is_active  -- association [0..*]
LEFT OUTER JOIN /ssb/core_cds_Views AS _CDSSqlView ON reports.view_name = _CDSSqlView.DDLSourceName  -- association [0..1]
;