I_EntProjectACLByUser

DDL: I_ENTPROJECTACLBYUSER Type: view_entity COMPOSITE

Determine Access to project by User ACL

I_EntProjectACLByUser is a Composite CDS View that provides data about "Determine Access to project by User ACL" in SAP S/4HANA. It reads from 2 data sources (I_PPM_AuthznByUsrH, I_PPM_Task) and exposes 3 fields with key fields ProjectUUID, UserID, ACLActivity.

2 data source(s) 3 fields

Data Sources (2)

SourceAliasJoin Type
I_PPM_AuthznByUsrH ACL inner
I_PPM_Task Proj from

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #NOT_ALLOWED 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
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
EndUserText.label Determine Access to project by User ACL view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY ProjectUUID I_PPM_Task ProjectUUID
KEY UserID I_PPM_AuthznByUsrH UserID
KEY ACLActivity I_PPM_AuthznByUsrH Activity 
@AccessControl: {
    authorizationCheck:      #NOT_ALLOWED,
    auditing: {
        type: #CUSTOM,
        specification: 'change documents on Enterprise Projects'
    },
    personalData.blocking:   #BLOCKED_DATA_EXCLUDED
}

@Metadata.ignorePropagatedAnnotations: true

@ObjectModel: {
   usageType: {
       serviceQuality:  #B,
       dataClass:       #MIXED,
       sizeCategory:    #L
   }
}

@VDM.viewType: #COMPOSITE
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API

@EndUserText.label: 'Determine Access to project by User ACL'
define view entity I_EntProjectACLByUser as select from I_PPM_Task as Proj
    inner join I_PPM_AuthznByUsrH as ACL 
        on  Proj.TaskUUID = ACL.ReferencedObjectUUID
{
    key Proj.ProjectUUID,
    key ACL.UserID,
    key ACL.Activity as ACLActivity
    
} where Proj.ObjectType = 'DPO'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PPM_AUTHZNBYUSRH",
"I_PPM_TASK"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More