I_EngagementProjectItem

DDL: I_ENGAGEMENTPROJECTITEM SQL: IEPPROJITEM Type: view BASIC

Item of Engagement Project

I_EngagementProjectItem is a Basic CDS View that provides data about "Item of Engagement Project" in SAP S/4HANA. It reads from 1 data source (P_EngagementProjectItem) and exposes 6 fields with key fields EngagementProject, EngagementProjectItemType, EngagementProjectItem. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
P_EngagementProjectItem EngagementProjectItem from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_EngagementProject _EngagementProject $projection.EngagementProject = _EngagementProject.EngagementProject
[0..1] I_SalesOrder _SalesOrder $projection.EngagementProjectItem = _SalesOrder.SalesOrder and $projection.EngagementProjectItemType = '0SOH'

Annotations (12)

NameValueLevelField
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName IEPPROJITEM view
EndUserText.label Item of Engagement Project view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
Metadata.ignorePropagatedAnnotations true view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY EngagementProject P_EngagementProjectItem EngagementProject
KEY EngagementProjectItemType P_EngagementProjectItem EngagementProjectItemType
KEY EngagementProjectItem P_EngagementProjectItem EngagementProjectItem
EngagementProjectUUID
_EngagementProject _EngagementProject
_SalesOrder _SalesOrder
@AbapCatalog.preserveKey: true
@AbapCatalog.compiler.compareFilter: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'IEPPROJITEM'
@EndUserText.label: 'Item of Engagement Project'
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #BASIC
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@Metadata.ignorePropagatedAnnotations:true
@ObjectModel.supportedCapabilities: [#CDS_MODELING_ASSOCIATION_TARGET,
                                     #CDS_MODELING_DATA_SOURCE,
                                     #SQL_DATA_SOURCE]
define view I_EngagementProjectItem
  as select from P_EngagementProjectItem as EngagementProjectItem

  association [1..1] to I_EngagementProject as _EngagementProject on  $projection.EngagementProject = _EngagementProject.EngagementProject
  association [0..1] to I_SalesOrder        as _SalesOrder        on  $projection.EngagementProjectItem     = _SalesOrder.SalesOrder
                                                                 and $projection.EngagementProjectItemType = '0SOH'
{
  key EngagementProjectItem.EngagementProject                                                   as EngagementProject,
  key EngagementProjectItem.EngagementProjectItemType                                           as EngagementProjectItemType,
  key EngagementProjectItem.EngagementProjectItem                                               as EngagementProjectItem,
      cast(EngagementProjectItem.EngagementProjectUUID  as /cpd/eng_db_key preserving type )    as EngagementProjectUUID,
      _EngagementProject,
      _SalesOrder
}      
  
  
  
  
  
  
  
  
  
  
  
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"P_ENGAGEMENTPROJECTITEM"
],
"ASSOCIATED":
[
"I_ENGAGEMENTPROJECT",
"I_SALESORDER"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/