APS_IAM_BR_RES_DEF

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_RES_DEF.
-- 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_BRRES_D

CREATE VIEW APS_IAM_BR_RES_DEF AS
SELECT
  buc.bu_role_id AS BuRoleId,
  buc.bu_role_uuid AS BuRoleUUID,
  fld.field_name AS FieldName,
  case rt.aggregation_category when '1' then fld.rtype_id else 'GENERAL' end as restriction_type AS rtype_idelseGENERALendasrestriction_type,
  buc_rt.read_access AS ReadAccess,
  buc_rt.write_access AS WriteAccess,
  buc_rt.f4_access AS F4Access,
  buc_rt.read_access_status AS ReadAccessStatus,
  buc_rt.write_access_status AS WriteAccessStatus,
  buc_rt.f4_access_status AS F4AccessStatus,
  rt.aggregation_category as aggregation_category AS BroleIdasBuRoleId
FROM APS_IAM_BR_RES_CAT_ASIGN AS buc
INNER JOIN aps_iam_w_buc_rt AS buc_rt ON /* join condition not captured in parsed metadata */
INNER JOIN aps_iam_w_bu_cat AS bucat ON /* join condition not captured in parsed metadata */
INNER JOIN aps_iam_w_rt AS rt ON /* join condition not captured in parsed metadata */
INNER JOIN aps_iam_w_rtfld AS fld ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN p_aps_iam_feature_scope_c AS feature_toggle ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN aps_iam_w_bc_app AS app_cat ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN aps_iam_w_bu_cat AS cat ON /* join condition not captured in parsed metadata */
-- UNION with additional select branch(es): APS_IAM_BER_RES_APPS_ASS
;