I_EngagementProjectResource

DDL: I_ENGAGEMENTPROJECTRESOURCE SQL: IEPRESOURCE Type: view BASIC Package: CPD_CDS

Resource in Engagement Project

I_EngagementProjectResource is a Basic CDS View (Dimension) that provides data about "Resource in Engagement Project" in SAP S/4HANA. It reads from 1 data source (P_EngagementProjectResource) and exposes 5 fields with key fields EngagementProjectResourceType, EngagementProjectResource. It has 2 associations to related views. Part of development package CPD_CDS.

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
P_EngagementProjectResource P_EngagementProjectResource from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_EngmntProjResourceType _EngagementProjectResourceType $projection.EngagementProjectResourceType = _EngagementProjectResourceType.EngagementProjectResourceType
[0..*] I_EngmntProjResourceText _Text $projection.EngagementProjectResourceType = _Text.EngagementProjectResourceType and $projection.EngagementProjectResource = _Text.EngagementProjectResource

Annotations (15)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName IEPRESOURCE view
EndUserText.label Resource in Engagement Project view
VDM.viewType #BASIC view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
ObjectModel.representativeKey EngagementProjectResource view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.sapObjectNodeType.name EngagementProjectResource view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY EngagementProjectResourceType P_EngagementProjectResource EngagementProjectResourceType
KEY EngagementProjectResource P_EngagementProjectResource EngagementProjectResource
ControllingArea ControllingArea
_EngagementProjectResourceType _EngagementProjectResourceType
_Text _Text 
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'IEPRESOURCE'
@EndUserText.label: 'Resource in Engagement Project'
@VDM.viewType:#BASIC
@Analytics:{ dataCategory:#DIMENSION , dataExtraction.enabled:true }
@ObjectModel.representativeKey: 'EngagementProjectResource'
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.sapObjectNodeType.name:'EngagementProjectResource'
@Metadata.allowExtensions:true
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel: {modelingPattern: #ANALYTICAL_DIMENSION, 
               supportedCapabilities: [#ANALYTICAL_DIMENSION,
                                       #CDS_MODELING_ASSOCIATION_TARGET,
                                       #CDS_MODELING_DATA_SOURCE,
                                       #SQL_DATA_SOURCE,
                                       #EXTRACTION_DATA_SOURCE]
}
define view I_EngagementProjectResource
  as select from P_EngagementProjectResource
  association [0..1] to I_EngmntProjResourceType as _EngagementProjectResourceType on  $projection.EngagementProjectResourceType = _EngagementProjectResourceType.EngagementProjectResourceType
  association [0..*] to I_EngmntProjResourceText as _Text                          on  $projection.EngagementProjectResourceType = _Text.EngagementProjectResourceType
                                                                                   and $projection.EngagementProjectResource     = _Text.EngagementProjectResource
{
       @ObjectModel.foreignKey.association: '_EngagementProjectResourceType'
  key  P_EngagementProjectResource.EngagementProjectResourceType as EngagementProjectResourceType,
       @ObjectModel.text.association: '_Text'
  key  P_EngagementProjectResource.EngagementProjectResource     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

       @Consumption.hidden: true
       ControllingArea, 
       _EngagementProjectResourceType,
       _Text

}

Learn More