R_AccessControlUser

DDL: R_ACCESSCONTROLUSER Type: view_entity BASIC

Access Control User Details

R_AccessControlUser is a Basic CDS View that provides data about "Access Control User Details" in SAP S/4HANA. It reads from 1 data source (/s4ppm/usr_grp) and exposes 8 fields with key field AccessControlUserUUID. It has 1 association to related views.

1 data source(s) 8 fields

Data Sources (1)

SourceAliasJoin Type
/s4ppm/usr_grp UGT from

Associations (1)

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

Annotations (8)

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

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY AccessControlUserUUID accesscontroluseruuid
AccessControlHeaderUUID accesscontrolheaderuuid
UserID userid
CreationDateTime creationdatetime
CreatedByUser createdby
LastChangeDateTime lastchangedon
LastChangedByUser lastchangedby
_Root _Root 
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #NOT_ALLOWED
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@ObjectModel: {
    representativeKey: 'AccessControlUserUUID',

    usageType: {
      dataClass:       #TRANSACTIONAL,
      serviceQuality:  #A,
      sizeCategory:    #L
    }
}
@EndUserText.label: 'Access Control User Details'
define view entity R_AccessControlUser
  as select from /s4ppm/usr_grp as UGT
  association [1] to R_AccessControlList as _Root on $projection.AccessControlHeaderUUID = _Root.AccessControlHeaderUUID
  /* root of the reason */

{
  key accesscontroluseruuid   as AccessControlUserUUID,
      accesscontrolheaderuuid as AccessControlHeaderUUID,
      userid                  as UserID,

     @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