aps_iam_info_br_app_basic

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_info_br_app_basic.
-- 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_info_br_app_basic AS
SELECT
  BRBCBasic.BusinessRoleID AS BusinessRoleID,
  BCAPP.ChipID AS ChipID,
  BCAPP.ApplicationText AS ApplicationText,
  BRBCBasic.BusinessRoleUUID AS BusinessRoleUUID,
  BCAPP.Subtitle AS Subtitle,
  BCAPP.AppAuthVariantID AS AppAuthVariantID,
  BCAPP.FioriID AS FioriID,
  BRBCBasic.description AS BusinessRoleName,
  BCAPP.IsCustomerApp AS IsCustomerApp,
  BCAPP.AppCategory AS AppCategory,
  BCAPP.AppType AS AppType,
  BCAPP.BusinessCatalogID AS BusinessCatalogID,
  BCAPP.AppComponent AS AppComponent,
  BCAPP.IsMigrated AS IDasBusinessRoleID,
  'X' AS IsMigrated
FROM C_APS_IAM_BR_APP AS br_app
LEFT OUTER JOIN APS_IAM_INFO_BC_APP_BASIC AS BCAPP ON /* join condition not captured in parsed metadata */
INNER JOIN p_aps_iam_feature_scope_c AS feature_toggle ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN aps_iam_w_app AS app ON /* join condition not captured in parsed metadata */
-- UNION with additional select branch(es): C_APS_IAM_BR_APP
;