APS_IAM_BR_APP_Migr_BC

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_APP_Migr_BC.
-- 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: APS_APP_MIGR_BC

CREATE VIEW APS_IAM_BR_APP_Migr_BC AS
SELECT
  app.AppID AS AppID,
  app.ReadOnly AS ReadOnly,
  app.TransactionCode AS TransactionCode,
  app.UIAppID AS UIAppID,
  app.ChangedOn AS ChangedOn,
  app.ChangedBy AS ChangedBy,
  app.ForbiddenWithSuccessors AS ForbiddenWithSuccessors,
  app.AppType AS AppType,
  app.ABAPLanguageVersion AS ABAPLanguageVersion,
  app_text.text AS Description,
  bc_app.bu_catalog_id AS BusinessCatalogID
FROM aps_iam_app_core AS app
LEFT OUTER JOIN aps_iam_w_bc_app AS bc_app ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN aps_iam_w_appt AS app_text ON /* join condition not captured in parsed metadata */
;