p_aps_iam_iag_br_app_auth_fld

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 p_aps_iam_iag_br_app_auth_fld.
-- 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 p_aps_iam_iag_br_app_auth_fld AS
SELECT
  root.id AS BusinessRoleID,
  auth.IAMAppID AS IAMAppID,
  auth.AuthorizationObject AS AuthorizationObject,
  auth.AuthorizationID AS AuthorizationID,
  auth.FieldName AS FieldName,
  fld.field_name AS RestrictionField
INNER JOIN p_aps_iam_iag_br_app_auth_core AS auth ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN aps_iam_w_fld AS fld ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN p_aps_iam_iag_br_app_auth_val AS _AuthorizationValues ON _AuthorizationValues.BusinessRoleID = BusinessRoleID AND _AuthorizationValues.IAMAppID = IAMAppID AND _AuthorizationValues.AuthorizationObject = AuthorizationObject AND _AuthorizationValues.AuthorizationID = AuthorizationID AND _AuthorizationValues.FieldName = FieldName  -- association [0..*]
;