R_AccControlIsUserAuthorized
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)
| Source | Alias | Join Type |
|---|---|---|
| /s4ppm/obj_auth | Auth | from |
Associations (3)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [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)
| Name | Value | Level | Field |
|---|---|---|---|
| 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)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| 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
}
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA