APS_IAM_RSTR_BUC_UI

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_RSTR_BUC_UI.
-- 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_IAM_RSTR_BUC

CREATE VIEW APS_IAM_RSTR_BUC_UI AS
SELECT
  bu_rt.read_access AS read_access,
  bu_rt.write_access AS write_access,
  bu_rt.f4_access AS f4_access,
  C_Aps_Business_Catalog.BusinessCatalogDescription AS BusinessCatalogDescription,
  C_Aps_Business_Catalog.BusinessCatalogID AS BusinessCatalogID,
  C_Aps_Business_Catalog._BusinessRoleAssignment AS BusinessRoleAssignment
FROM aps_iam_w_buc_rt AS bu_rt
LEFT OUTER JOIN aps_iam_w_bu_cat AS bu_cat 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_c_bu_cat AS scope ON scope.bu_catalog_id = bu_catalog_id  -- association [0..1]
;