APS_IAM_RSTR_APP_UI

DDL: APS_IAM_RSTR_APP_UI SQL: APS_IAMRSTRA_UI Type: view Package: SR_APS_IAM_RSTR_ODATA
11 Fields 1 Data Sources 1 Associations

Restriction Type where used in Apps

APS_IAM_RSTR_APP_UI is a CDS View that provides data about "Restriction Type where used in Apps" in SAP S/4HANA. It reads from 1 data source (aps_iam_w_appt) and exposes 11 fields with key fields AppId, RestrictionTypeId. It has 1 association to related views. Part of development package SR_APS_IAM_RSTR_ODATA.

Data Sources (1)

SourceAliasJoin Type
aps_iam_w_appt appDetail left_outer

Associations (1)

CardinalityTargetAliasCondition
[0..1] r_aps_iam_app_core_apptype _app_type_text _app_type_text.AppID = restrictionType.OrigAppID

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName APS_IAMRSTRA_UI view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Restriction Type where used in Apps view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY AppId restrictionType OrigAppID
KEY RestrictionTypeId restrictionType RestrictionTypeID
ReadAccess restrictionType ReadAccess
WriteAccess restrictionType WriteAccess
F4Access restrictionType F4Access
ReadAccessStatus restrictionType ReadAccessStatus
WriteAccessStatus restrictionType WriteAccessStatus
F4AccessStatus restrictionType F4AccessStatus
Title aps_iam_w_appt text User Group
AppType restrictionType AppType Application Type
AppTypeText _app_type_text AppTypeText

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_RSTR_APP_UI.
-- 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_IAMRSTRA_UI

CREATE VIEW APS_IAM_RSTR_APP_UI AS
SELECT
  restrictionType.OrigAppID AS AppId,
  restrictionType.RestrictionTypeID AS RestrictionTypeId,
  restrictionType.ReadAccess AS ReadAccess,
  restrictionType.WriteAccess AS WriteAccess,
  restrictionType.F4Access AS F4Access,
  restrictionType.ReadAccessStatus AS ReadAccessStatus,
  restrictionType.WriteAccessStatus AS WriteAccessStatus,
  restrictionType.F4AccessStatus AS F4AccessStatus,
  appDetail.text AS Title,
  restrictionType.AppType AS AppType,
  _app_type_text.AppTypeText AS AppTypeText
LEFT OUTER JOIN aps_iam_w_appt AS appDetail ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN r_aps_iam_app_core_apptype AS _app_type_text ON _app_type_text.AppID = restrictionType.OrigAppID  -- association [0..1]
;

Learn More