APS_IAM_DIFF_VALUES

DDL: APS_IAM_DIFF_VALUES Type: view_entity Package: SR_APS_IAM_BROLE

Get differences to actual role values

APS_IAM_DIFF_VALUES is a CDS View that provides data about "Get differences to actual role values" in SAP S/4HANA. It reads from 4 data sources (aps_iam_d_brcres, aps_iam_d_br, aps_iam_d_brcrv, APS_IAM_READ_DIFF_VALUES) and exposes 11 fields. Part of development package SR_APS_IAM_BROLE.

Data Sources (4)

SourceAliasJoin Type
aps_iam_d_brcres restr left_outer
aps_iam_d_br role left_outer
aps_iam_d_brcrv val left_outer
APS_IAM_READ_DIFF_VALUES values from

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Get differences to actual role values view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view

Fields (11)

KeyFieldSource TableSource FieldDescription
BroleId APS_IAM_READ_DIFF_VALUES BroleId WorklistID
BroleUuid aps_iam_d_br uuid Waste Partner UUID
RestrictionType APS_IAM_READ_DIFF_VALUES RestrictionType
RestrictionUuuid aps_iam_d_brcres uuid Waste Partner UUID
AccessCategory APS_IAM_READ_DIFF_VALUES AccessCategory Short Description
AccessRestrictionCode APS_IAM_READ_DIFF_VALUES AccessRestrictionCode
FieldName APS_IAM_READ_DIFF_VALUES FieldName UI Group FieldName
LowValue APS_IAM_READ_DIFF_VALUES LowValue Low Value
HighValue APS_IAM_READ_DIFF_VALUES HighValue High Value
uuid aps_iam_d_brcrv uuid Waste Partner UUID
ToDelete APS_IAM_READ_DIFF_VALUES ToDelete

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_DIFF_VALUES.
-- 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_DIFF_VALUES AS
SELECT
  values.BroleId AS BroleId,
  role.uuid AS BroleUuid,
  values.RestrictionType AS RestrictionType,
  restr.uuid AS RestrictionUuuid,
  values.AccessCategory AS AccessCategory,
  values.AccessRestrictionCode AS AccessRestrictionCode,
  values.FieldName AS FieldName,
  values.LowValue AS LowValue,
  values.HighValue AS HighValue,
  val.uuid AS uuid,
  values.ToDelete AS ToDelete
FROM APS_IAM_READ_DIFF_VALUES AS values
LEFT OUTER JOIN aps_iam_d_br AS role ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN aps_iam_d_brcres AS restr ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN aps_iam_d_brcrv AS val ON /* join condition not captured in parsed metadata */
;