aps_iam_br_apps_nocat

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 aps_iam_br_apps_nocat.
-- 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.

CREATE VIEW aps_iam_br_apps_nocat AS
SELECT
  app.app_id AS AppId,
  appt.text AS Description,
  app.app_type AS AppType,
  app.abap_language_version AS AbapLanguageVersion,
  app.read_only AS ReadOnly,
  app.scope_dependent AS ScopeDependent,
  app.tcode AS Tcode,
  app.ui_app_id AS UiAppId,
  _PriceTag.PriceCategoryText AS PriceCategoryText,
  _PriceTag.Weight AS PriceWeight
FROM aps_iam_w_app AS app
INNER JOIN aps_iam_c_app AS appscp ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN aps_iam_w_appt AS appt ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_APS_IAM_APP_PRICE_TAG AS _PriceTag ON app.app_id = _PriceTag.AppID  -- association [0..1]
;