APS_IAM_INFO_RAP_IAM_APP_RE

DDL: APS_IAM_INFO_RAP_IAM_APP_RE Type: view_entity Package: SR_APS_IAM_INFO_RAP
15 Fields 2 Data Sources 1 Associations 1 OData Services

IAM App - Restriction

APS_IAM_INFO_RAP_IAM_APP_RE is a CDS View that provides data about "IAM App - Restriction" in SAP S/4HANA. It reads from 2 data sources (i_aps_iam_app_core, i_aps_iam_app_core_rt) and exposes 15 fields with key fields AppID, ID. It has 1 association to related views. It is exposed through 1 OData service (APS_IAM_INFO_SD). Part of development package SR_APS_IAM_INFO_RAP.

Data Sources (2)

SourceAliasJoin Type
i_aps_iam_app_core core from
i_aps_iam_app_core_rt rt inner

Associations (1)

CardinalityTargetAliasCondition
[0..*] APS_IAM_INFO_APP_TYPE _app_type_text _app_type_text.KeyValue = $projection.AppType

Annotations (4)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label IAM App - Restriction view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view

OData Services (1)

ServiceBindingVersionContractRelease
APS_IAM_INFO_SD APS_IAM_INFO_V4 V4 C1 NOT_RELEASED

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY AppID i_aps_iam_app_core AppID Transaction code
KEY ID i_aps_iam_app_core_rt ID WorklistID
AppDescription i_aps_iam_app_core AppDescription User Group
TransactionCode i_aps_iam_app_core TransactionCode Transaction Code
TransactionText i_aps_iam_app_core TransactionText Text
Component i_aps_iam_app_core Component Softw. Comp.
AppType i_aps_iam_app_core AppType Application Type
RestrictionTypeID i_aps_iam_app_core_rt RestrictionTypeID
RestrictionType i_aps_iam_app_core_rt Description Well Code Des.
WriteAccess i_aps_iam_app_core_rt WriteAccess
ReadAccess i_aps_iam_app_core_rt ReadAccess
F4Access i_aps_iam_app_core_rt F4Access
RestrictionTypeStatus i_aps_iam_app_core_rt RestrictionTypeStatus
FieldName i_aps_iam_app_core_rt FieldName UI Group FieldName
FieldDescription i_aps_iam_app_core_rt FieldDescription User Group

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_INFO_RAP_IAM_APP_RE.
-- 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 APS_IAM_INFO_RAP_IAM_APP_RE AS
SELECT
  core.AppID AS AppID,
  rt.ID AS ID,
  core.AppDescription AS AppDescription,
  core.TransactionCode AS TransactionCode,
  core.TransactionText AS TransactionText,
  core.Component AS Component,
  core.AppType AS AppType,
  rt.RestrictionTypeID AS RestrictionTypeID,
  rt.Description AS RestrictionType,
  rt.WriteAccess AS WriteAccess,
  rt.ReadAccess AS ReadAccess,
  rt.F4Access AS F4Access,
  rt.RestrictionTypeStatus AS RestrictionTypeStatus,
  rt.FieldName AS FieldName,
  rt.FieldDescription AS FieldDescription
FROM i_aps_iam_app_core AS core
INNER JOIN i_aps_iam_app_core_rt AS rt ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN APS_IAM_INFO_APP_TYPE AS _app_type_text ON _app_type_text.KeyValue = AppType  -- association [0..*]
;

Learn More