R_AccessControlReason

DDL: R_ACCESSCONTROLREASON Type: view_entity BASIC
10 Fields 1 Data Sources 1 Associations

Access Control Reason Details

R_AccessControlReason is a Basic CDS View that provides data about "Access Control Reason Details" in SAP S/4HANA. It reads from 1 data source (/s4ppm/acl_reasn) and exposes 10 fields with key field AccessControlReasonUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
/s4ppm/acl_reasn ART from

Associations (1)

CardinalityTargetAliasCondition
[1] R_AccessControlList _Root $projection.AccessControlHeaderUUID = _Root.AccessControlHeaderUUID

Annotations (8)

NameValueLevelField
VDM.viewType #BASIC view
EndUserText.label Access Control Reason Details view
AccessControl.authorizationCheck #NOT_ALLOWED view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.representativeKey AccessControlReasonUUID view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY AccessControlReasonUUID accesscontrolreasonuuid Reason Reference
AccessControlHeaderUUID accesscontrolheaderuuid Root Key UUID
AccessControlFrameworkCode accesscontrolframeworkcode Framework Code
AccessControlFrameworkUUID accesscontrolframeworkuuid Framework UUID
AccessControlFrameworkID accesscontrolframeworkid Framework ID
CreationDateTime creationdatetime Timestamp
CreatedByUser createdby User Name
LastChangeDateTime lastchangedon Time Stamp
LastChangedByUser lastchangedby User Name
_Root _Root

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 R_AccessControlReason.
-- 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 R_AccessControlReason AS
SELECT
  AccessControlReasonUUID,
  AccessControlHeaderUUID,
  AccessControlFrameworkCode,
  AccessControlFrameworkUUID,
  AccessControlFrameworkID,
  CreationDateTime,
  createdby AS CreatedByUser,
  lastchangedon AS LastChangeDateTime,
  lastchangedby AS LastChangedByUser
FROM /s4ppm/acl_reasn AS ART
LEFT OUTER JOIN R_AccessControlList AS _Root ON AccessControlHeaderUUID = _Root.AccessControlHeaderUUID  -- association [1]
;

Learn More