I_EngmntProjResourceText

DDL: I_ENGMNTPROJRESOURCETEXT SQL: IEPRESCTEXT Type: view BASIC

Resource in Engagement Project - Text

I_EngmntProjResourceText is a Basic CDS View that provides data about "Resource in Engagement Project - Text" in SAP S/4HANA. It reads from 1 data source (P_Engagementprojresourcetext) and exposes 8 fields with key fields EngagementProjectResourceType, EngagementProjectResource, Language. It has 3 associations to related views.

1 data source(s) 8 fields

Data Sources (1)

SourceAliasJoin Type
P_Engagementprojresourcetext P_Engagementprojresourcetext from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_EngmntProjResourceType _EngagementProjectResourceType $projection.EngagementProjectResourceType = _EngagementProjectResourceType.EngagementProjectResourceType
[0..1] I_EngagementProjectResource _EngagementProjectResource $projection.EngagementProjectResourceType = _EngagementProjectResource.EngagementProjectResourceType and $projection.EngagementProjectResource = _EngagementProjectResource.EngagementProjectResource
[0..1] I_Language _Language $projection.Language = _Language.Language

Annotations (14)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName IEPRESCTEXT view
EndUserText.label Resource in Engagement Project - Text view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.dataCategory #TEXT view
ObjectModel.representativeKey EngagementProjectResource view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
Analytics.dataExtraction.enabled true view
ObjectModel.modelingPattern #LANGUAGE_DEPENDENT_TEXT view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY EngagementProjectResourceType P_Engagementprojresourcetext EngagementProjectResourceType
KEY EngagementProjectResource P_Engagementprojresourcetext EngagementProjectResource
KEY Language P_Engagementprojresourcetext Language
EngagementProjResourceText P_Engagementprojresourcetext EngagementProjResourceText
ControllingArea ControllingArea
_EngagementProjectResourceType _EngagementProjectResourceType
_EngagementProjectResource _EngagementProjectResource
_Language _Language 
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'IEPRESCTEXT'
@EndUserText.label: 'Resource in Engagement Project - Text'
@VDM.viewType:#BASIC
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.dataCategory: #TEXT
@ObjectModel.representativeKey: 'EngagementProjectResource'
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations: true
@Analytics.dataExtraction.enabled: true
@ObjectModel: {modelingPattern: #LANGUAGE_DEPENDENT_TEXT, 
               supportedCapabilities: [#LANGUAGE_DEPENDENT_TEXT,
                                       #CDS_MODELING_ASSOCIATION_TARGET,
                                       #CDS_MODELING_DATA_SOURCE,
                                       #SQL_DATA_SOURCE]
}
define view I_EngmntProjResourceText
  as select from P_Engagementprojresourcetext
  association [0..1] to I_EngmntProjResourceType    as _EngagementProjectResourceType on  $projection.EngagementProjectResourceType = _EngagementProjectResourceType.EngagementProjectResourceType
  association [0..1] to I_EngagementProjectResource as _EngagementProjectResource     on  $projection.EngagementProjectResourceType = _EngagementProjectResource.EngagementProjectResourceType
                                                                                      and $projection.EngagementProjectResource     = _EngagementProjectResource.EngagementProjectResource
  association [0..1] to I_Language                  as _Language                      on  $projection.Language = _Language.Language
{
      @ObjectModel.foreignKey.association: '_EngagementProjectResourceType'
  key P_Engagementprojresourcetext.EngagementProjectResourceType as EngagementProjectResourceType,

      @ObjectModel.foreignKey.association: '_EngagementProjectResource'
  key P_Engagementprojresourcetext.EngagementProjectResource     as EngagementProjectResource,

      @ObjectModel.foreignKey.association: '_Language'
      @Semantics.language : true
  key P_Engagementprojresourcetext.Language                      as Language,
     
      @Semantics.text: true
      P_Engagementprojresourcetext.EngagementProjResourceText    as EngagementProjResourceText,
      
      // 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,
      _EngagementProjectResource,
      _Language
}

Learn More