R_AccCtrlObjectAuthorization

DDL: R_ACCCTRLOBJECTAUTHORIZATION Type: view_entity BASIC Package: VDM_PPM_OBJECTS_AUTHORIZATION

Access Control Object Authorization

R_AccCtrlObjectAuthorization is a Basic CDS View that provides data about "Access Control Object Authorization" in SAP S/4HANA. It reads from 1 data source (/s4ppm/obj_auth) and exposes 13 fields with key field AccCtrlObjAuthorizationUUID. It has 4 associations to related views. Part of development package VDM_PPM_OBJECTS_AUTHORIZATION.

Data Sources (1)

SourceAliasJoin Type
/s4ppm/obj_auth OAT from

Associations (4)

CardinalityTargetAliasCondition
[1] R_AccessControlList _Root $projection.AccessControlHeaderUUID = _Root.AccessControlHeaderUUID
[1] R_AccessControlList _UserGroup $projection.AccessControlGroupUUID = _UserGroup.AccessControlHeaderUUID
[1] R_AccessControlList _ObjectReference $projection.AccCtrlReferencedObjectUUID = _ObjectReference.AccessControlHeaderUUID
[1] I_AccessControlRestriction _Restriction $projection.AccessControlRestrictionCode = _Restriction.AccessControlRestrictionCode

Annotations (8)

NameValueLevelField
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.representativeKey AccCtrlObjAuthorizationUUID view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Access Control Object Authorization view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY AccCtrlObjAuthorizationUUID accctrlobjauthorizationuuid
AccessControlHeaderUUID accesscontrolheaderuuid
AccCtrlReferencedObjectUUID accctrlreferencedobjectuuid
AccessControlRestrictionCode accesscontrolrestrictioncode
AccessControlGroupUUID accesscontrolgroupuuid
CreationDateTime creationdatetime
CreatedByUser createdby
LastChangeDateTime lastchangedon
LastChangedByUser lastchangedby
_Root _Root
_UserGroup _UserGroup
_ObjectReference _ObjectReference
_Restriction _Restriction
@VDM.viewType: #BASIC
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@ObjectModel: {
    representativeKey: 'AccCtrlObjAuthorizationUUID',

    usageType: {
      dataClass:       #TRANSACTIONAL,
      serviceQuality:  #A,
      sizeCategory:    #L
    }
}
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Access Control Object Authorization'
define view entity R_AccCtrlObjectAuthorization
  as select from /s4ppm/obj_auth as OAT
  /* my Parent */
  association [1] to R_AccessControlList as _Root            on $projection.AccessControlHeaderUUID = _Root.AccessControlHeaderUUID
  /* root of a user group */
  association [1] to R_AccessControlList as _UserGroup       on $projection.AccessControlGroupUUID = _UserGroup.AccessControlHeaderUUID
  /* root of a user group */
  association [1] to R_AccessControlList as _ObjectReference on $projection.AccCtrlReferencedObjectUUID = _ObjectReference.AccessControlHeaderUUID
  
  /* FK */
  association [1] to I_AccessControlRestriction as _Restriction on $projection.AccessControlRestrictionCode = _Restriction.AccessControlRestrictionCode

{
  key accctrlobjauthorizationuuid  as AccCtrlObjAuthorizationUUID,
      @ObjectModel.foreignKey.association: '_Root'
      accesscontrolheaderuuid      as AccessControlHeaderUUID,

      /* this reference is framework (use case) specifc */
      // root object this ACL belongs to, not used in evaluation, in PPM it is the top node

      accctrlreferencedobjectuuid  as AccCtrlReferencedObjectUUID,
      
      @ObjectModel.foreignKey.association: '_Restriction'
      accesscontrolrestrictioncode as AccessControlRestrictionCode,

      accesscontrolgroupuuid       as AccessControlGroupUUID,

      //accesscontrolobjectuuid        as AccessControlObjectUUID,

      @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,
      _UserGroup,
      _ObjectReference,
      _Restriction
}