I_CustomerProjectItem

DDL: I_CUSTOMERPROJECTITEM SQL: ICUSTPROJITEM Type: view BASIC

Item of Customer Project

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

1 data source(s) 6 fields

Data Sources (1)

SourceAliasJoin Type
I_EngagementProjectItem CustomerProjectItem from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_CustomerProject _CustomerProject $projection.CustomerProject = _CustomerProject.CustomerProject
[1..1] I_EngagementProject _EngagementProject $projection.CustomerProject = _EngagementProject.EngagementProject

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName ICUSTPROJITEM view
EndUserText.label Item of Customer Project view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MIXED view
Metadata.ignorePropagatedAnnotations true view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY CustomerProject I_EngagementProjectItem EngagementProject
KEY CustomerProjectItemType
KEY CustomerProjectItem
CustomerProjectUUID
_CustomerProject _CustomerProject
_EngagementProject _EngagementProject 
@AbapCatalog.sqlViewName: 'ICUSTPROJITEM'
@EndUserText.label: 'Item of Customer Project'
@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.dataClass: #MIXED
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.supportedCapabilities: [#CDS_MODELING_ASSOCIATION_TARGET,
                                     #CDS_MODELING_DATA_SOURCE,
                                     #SQL_DATA_SOURCE]
define view I_CustomerProjectItem
  as select from I_EngagementProjectItem as CustomerProjectItem

  association [1..1] to I_CustomerProject as _CustomerProject         on $projection.CustomerProject = _CustomerProject.CustomerProject
  association [1..1] to I_EngagementProject as _EngagementProject     on $projection.CustomerProject = _EngagementProject.EngagementProject
{
  key CustomerProjectItem.EngagementProject                                                       as  CustomerProject,
  key cast(CustomerProjectItem.EngagementProjectItemType    as /cpd/ss_cp_itm_type )              as  CustomerProjectItemType,
  key cast(CustomerProjectItem.EngagementProjectItem   as /cpd/ss_cp_item )                       as  CustomerProjectItem,
      cast(CustomerProjectItem.EngagementProjectUUID   as  /cpd/cust_db_key preserving type )     as  CustomerProjectUUID,
      _CustomerProject,
      _EngagementProject

}    

  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ENGAGEMENTPROJECTITEM"
],
"ASSOCIATED":
[
"I_CUSTOMERPROJECT",
"I_ENGAGEMENTPROJECT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More