/SSB/AQWG_APPS

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/AQWG_APPS.
-- 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/AQWGAPPS

CREATE VIEW /SSB/AQWG_APPS AS
SELECT
  report_chips.app_id AS AppId,
  report_chips.ddlsourcename AS QueryName,
  coalesce(dd02b.strucobjn_raw, report_chips.ddlsourcename) AS DataSourceName,
  Texts.title AS AppTitle,
  report_chips.title AS AppDefaultTitle,
  Texts.subtitle AS AppSubtitle,
  report_chips.subtitle AS AppDefaultSubtitle,
  CDSViews.SQLViewName AS SQLViewName,
  report_chips.app_type AS ReportType,
  report_chips.ina1_service_id AS ServiceID,
  report_chips.ina1_service_name AS ServiceName,
  report_chips.variant_id AS VariantId,
  AQWGAppTexts
FROM report_chips
LEFT OUTER JOIN report_chips_t AS Texts ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN Cds_Views AS CDSViews ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN /SSB/AQWG_APPS_TEXTS AS AQWGAppTexts ON report_chips.app_id = AQWGAppTexts.AppId  -- association [0..*]
;