p_aps_iam_iag_br_app_auth_core

DDL: P_APS_IAM_IAG_BR_APP_AUTH_CORE Type: view_entity Package: SR_APS_IAM_PUB_BROLE_IAG
8 Fields 6 Data Sources

IAM IAG Business Role Authorizations

p_aps_iam_iag_br_app_auth_core is a CDS View that provides data about "IAM IAG Business Role Authorizations" in SAP S/4HANA. It reads from 6 data sources and exposes 8 fields with key fields BusinessRoleUUID, BusinessRoleID, IAMAppID, AuthorizationObject, AuthorizationID. Part of development package SR_APS_IAM_PUB_BROLE_IAG.

Data Sources (6)

SourceAliasJoin Type
agr_1250 agr_1250 inner
agr_1251 agr_1251 inner
aps_iam_w_appaui app_ai inner
aps_iam_w_appauo app_ao inner
aps_iam_d_brapp br_app inner
aps_iam_d_brpfcg br_pfcg inner

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label IAM IAG Business Role Authorizations view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY BusinessRoleUUID root uuid Waste Partner UUID
KEY BusinessRoleID root id WorklistID
KEY IAMAppID aps_iam_w_appaui app_id Identifier
KEY AuthorizationObject aps_iam_w_appauo auth_object Object
KEY AuthorizationID agr_1251 auth Authorization
FieldName agr_1251 field Logical Field
LowValue agr_1251 low Value from
HighValue agr_1251 high Value up to

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_core.
-- 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_core AS
SELECT
  root.uuid AS BusinessRoleUUID,
  root.id AS BusinessRoleID,
  app_ai.app_id AS IAMAppID,
  app_ao.auth_object AS AuthorizationObject,
  agr_1251.auth AS AuthorizationID,
  agr_1251.field AS FieldName,
  agr_1251.low AS LowValue,
  agr_1251.high AS HighValue
INNER JOIN aps_iam_d_brapp AS br_app ON /* join condition not captured in parsed metadata */
INNER JOIN aps_iam_d_brpfcg AS br_pfcg ON /* join condition not captured in parsed metadata */
INNER JOIN aps_iam_w_appauo AS app_ao ON /* join condition not captured in parsed metadata */
INNER JOIN aps_iam_w_appaui AS app_ai ON /* join condition not captured in parsed metadata */
INNER JOIN agr_1250 ON /* join condition not captured in parsed metadata */
INNER JOIN agr_1251 ON /* join condition not captured in parsed metadata */
;

Learn More