APS_IAM_REP_RES_SELECTION

DDL: APS_IAM_REP_RES_SELECTION SQL: APS_IAM_REP_SE Type: view Package: SR_APS_IAM_REP_ODATA

IAM Key Figures App Restrictions select

APS_IAM_REP_RES_SELECTION is a CDS View that provides data about "IAM Key Figures App Restrictions select" in SAP S/4HANA. It reads from 3 data sources (aps_iam_d_br, aps_iam_d_brcrv, aps_iam_d_brcres) and exposes 4 fields with key field field. Part of development package SR_APS_IAM_REP_ODATA.

Data Sources (3)

SourceAliasJoin Type
aps_iam_d_br _brole left_outer
aps_iam_d_brcrv _fields from
aps_iam_d_brcres _restrictions left_outer

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName APS_IAM_REP_SE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label IAM Key Figures App Restrictions select view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY field aps_iam_d_brcrv field_name VAT Declaration Fld
brole_id aps_iam_d_br id WorklistID
brole_uuid aps_iam_d_br uuid Waste Partner UUID
category access_category Short Description

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_REP_RES_SELECTION.
-- 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_IAM_REP_SE

CREATE VIEW APS_IAM_REP_RES_SELECTION AS
SELECT
  _fields.field_name AS field,
  _brole.id AS brole_id,
  _brole.uuid AS brole_uuid,
  access_category AS category
FROM aps_iam_d_brcrv AS _fields
LEFT OUTER JOIN aps_iam_d_brcres AS _restrictions ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN aps_iam_d_br AS _brole ON /* join condition not captured in parsed metadata */
;