R_AccControlIsUserAuthorized

DDL: R_ACCCONTROLISUSERAUTHORIZED Type: view_entity BASIC Package: VDM_PPM_OBJECTS_AUTHORIZATION

ACL Check for user

R_AccControlIsUserAuthorized is a Basic CDS View that provides data about "ACL Check for user" in SAP S/4HANA. It reads from 1 data source (/s4ppm/obj_auth) and exposes 8 fields with key fields AccCtrlObjAuthorizationUUID, UserID, AccCtrlReferencedObjectUUID, AccessControlRestrictionCode. It has 3 associations to related views. Part of development package VDM_PPM_OBJECTS_AUTHORIZATION.

Data Sources (1)

SourceAliasJoin Type
/s4ppm/obj_auth Auth from

Associations (3)

CardinalityTargetAliasCondition
[1] I_AccessControlRestriction _Restriction $projection.AccessControlRestrictionCode = _Restriction.AccessControlRestrictionCode
[1] I_User _User $projection.UserID = _User.UserID
[1] R_AccCtrlObjectAuthorization _Auth $projection.AccCtrlObjAuthorizationUUID = _Auth.AccCtrlObjAuthorizationUUID

Annotations (12)

NameValueLevelField
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.representativeKey AccCtrlReferencedObjectUUID view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.auditing.type #CUSTOM view
AccessControl.auditing.specification change documents on Enterprise Projects view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label ACL Check for user view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY AccCtrlObjAuthorizationUUID /s4ppm/obj_auth accctrlobjauthorizationuuid
KEY UserID User userid
KEY AccCtrlReferencedObjectUUID Object accctrlreferencedobjectuuid
KEY AccessControlRestrictionCode /s4ppm/obj_auth accesscontrolrestrictioncode
AccCntrlReferencedObjectID Object acccntrlreferencedobjectid
_Restriction _Restriction
_User _User
_Auth _Auth
@VDM: {
  viewType: #BASIC,
  lifecycle.contract.type: #SAP_INTERNAL_API
}
@ObjectModel: {
    representativeKey: 'AccCtrlReferencedObjectUUID',

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

@AccessControl: {
    authorizationCheck:      #NOT_REQUIRED, // not permitted on this view, this is access control

    auditing: {
        type: #CUSTOM,
        specification: 'change documents on Enterprise Projects'
    },
    personalData.blocking:   #BLOCKED_DATA_EXCLUDED
}
@Consumption.dbHints: [ 'USE_HEX_PLAN' ]

@Metadata.ignorePropagatedAnnotations: true
@EndUserText.label: 'ACL Check for user'
define view entity R_AccControlIsUserAuthorized
  as select from /s4ppm/obj_auth        as Auth
    inner to many join /s4ppm/usr_grp   as User             on Auth.accesscontrolgroupuuid      = User.accesscontrolheaderuuid
    inner to many join /s4ppm/obj_ref   as Object           on Auth.accctrlreferencedobjectuuid = Object.accesscontrolheaderuuid
  /* FK */
  association [1] to I_AccessControlRestriction   as _Restriction on $projection.AccessControlRestrictionCode = _Restriction.AccessControlRestrictionCode
  association [1] to I_User                       as _User        on $projection.UserID = _User.UserID
  association [1] to R_AccCtrlObjectAuthorization as _Auth        on $projection.AccCtrlObjAuthorizationUUID = _Auth.AccCtrlObjAuthorizationUUID
{
      @ObjectModel.foreignKey.association: '_Auth'
  key Auth.accctrlobjauthorizationuuid      as AccCtrlObjAuthorizationUUID,
      @ObjectModel.foreignKey.association: '_User'
  key User.userid                           as UserID,     
  key Object.accctrlreferencedobjectuuid    as AccCtrlReferencedObjectUUID,      // we do not know what this points to, this field is the framework specific object guid 

      @ObjectModel.foreignKey.association: '_Restriction'
  key Auth.accesscontrolrestrictioncode     as AccessControlRestrictionCode,

      Object.acccntrlreferencedobjectid     as AccCntrlReferencedObjectID,       // we do not know what this points to, this field is framework specific object id when present


  _Restriction,
  _User,
  _Auth
  
}