i_aps_iam_app_auth

DDL: I_APS_IAM_APP_AUTH Type: view_entity Package: SR_APS_IAM_APP_DAPP
11 Fields 1 Data Sources 1 Associations

IAM: App - Authorizations

i_aps_iam_app_auth is a CDS View that provides data about "IAM: App - Authorizations" in SAP S/4HANA. It reads from 1 data source (i_aps_iam_app_core_auth) and exposes 11 fields with key fields OrigAppID, ID. It has 1 association to related views. Part of development package SR_APS_IAM_APP_DAPP.

Data Sources (1)

SourceAliasJoin Type
i_aps_iam_app_core_auth i_aps_iam_app_core_auth from

Associations (1)

CardinalityTargetAliasCondition
[0..1] i_aps_iam_app_auth _Parent $projection.ParentID = _Parent.ID and $projection.OrigAppID = _Parent.OrigAppID

Annotations (2)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label IAM: App - Authorizations view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY OrigAppID OrigAppID Identifier
KEY ID ID WorklistID
ParentID ParentID UUID
Idx Idx Table Row
AuthObject AuthObject Object
AuthInstance AuthInstance
AuthField AuthField Authorization Fld
LowValue LowValue Low Value
HighValue HighValue High Value
_Root _Root
_Parent _Parent

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 i_aps_iam_app_auth.
-- 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 i_aps_iam_app_auth AS
SELECT
  OrigAppID,
  ID,
  ParentID,
  Idx,
  AuthObject,
  AuthInstance,
  AuthField,
  LowValue,
  HighValue
FROM i_aps_iam_app_core_auth
LEFT OUTER JOIN i_aps_iam_app_auth AS _Parent ON ParentID = _Parent.ID AND OrigAppID = _Parent.OrigAppID  -- association [0..1]
;

Learn More