R_ACCESSCONTROLREASON

CDS View

Access Control Reason Details

R_ACCESSCONTROLREASON is a CDS View in S/4HANA. Access Control Reason Details. 2 CDS views read from this table.

Used by 2 CDS view(s)

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_EntProjAccCtrlListCompare view_entity left_outer COMPOSITE Compare old and new ACL
R_AccessControlReasonTP view_entity from TRANSACTIONAL Reason Entries 
@VDM.viewType: #BASIC
@EndUserText.label: 'Access Control Reason Details'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@ObjectModel: {
    representativeKey: 'AccessControlReasonUUID',

    usageType: {
      dataClass:       #TRANSACTIONAL,
      serviceQuality:  #A,
      sizeCategory:    #L
    }
}

define view entity R_AccessControlReason
  as select from /s4ppm/acl_reasn as ART 
  /* my Parent */
  association [1] to R_AccessControlList as _Root on $projection.AccessControlHeaderUUID = _Root.AccessControlHeaderUUID
{
  key accesscontrolreasonuuid as AccessControlReasonUUID,
      accesscontrolheaderuuid    as AccessControlHeaderUUID,
      accesscontrolframeworkcode as AccessControlFrameworkCode,
      accesscontrolframeworkuuid as AccessControlFrameworkUUID,
      accesscontrolframeworkid   as AccessControlFrameworkID,

      @Semantics.systemDateTime.createdAt: true
      creationdatetime            as CreationDateTime,
      @Semantics.user.createdBy: true
      createdby                   as CreatedByUser,
      @Semantics.systemDateTime.localInstanceLastChangedAt: true
      lastchangedon               as LastChangeDateTime,
      @Semantics.user.localInstanceLastChangedBy: true
      lastchangedby               as LastChangedByUser,

      _Root
}

Learn More