P_ENGAGEMENTPROJECTRESOURCE

CDS View

Engagement Project Resource

P_ENGAGEMENTPROJECTRESOURCE is a CDS View in S/4HANA. Engagement Project Resource. It contains 2 fields. 1 CDS views read from this table.

Used by 1 CDS view(s) 2 fields

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_EngagementProjectResource view from BASIC Resource in Engagement Project

Fields (2)

KeyField CDS FieldsUsed in Views
KEY EngagementProjectResource EngagementProjectResource 1
KEY EngagementProjectResourceType EngagementProjectResourceType 1 
@AbapCatalog.sqlViewName: 'PEPRESOURCE'
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.private: true
@VDM.viewType: #BASIC
@AbapCatalog.compiler.compareFilter: true
define view P_EngagementProjectResource as select from I_EngagementProjectExpenseType as ExpenseType
{

key ExpenseType.EngagementProjectExpenseType    as EngagementProjectResource,
    cast( '    ' as fis_kokrs preserving type ) as ControllingArea,
    '0EXP'  as EngagementProjectResourceType 

}

union all

select distinct from I_CostCenterActivityType as ActivityType
inner join I_EngmntProjRsceType as ResourceType on ResourceType.EngagementProjectResource = ActivityType.CostCtrActivityType
                                                and ResourceType.EngagementProjectResourceType <> '0EXP'

{
key ActivityType.CostCtrActivityType          as EngagementProjectResource,
   // As CSLA table we ae selecting from is a DPP relevant table, all the CDS views on top this table must have DCL

   // this field has been added to create DCL for A_EngmntProjResource view which is used in external API

    ActivityType.ControllingArea,
    ResourceType.EngagementProjectResourceType    as EngagementProjectResourceType

}

Learn More