I_ProjectByProjMgrVH

DDL: I_PROJECTBYPROJMGRVH SQL: IPPROJVH Type: view COMPOSITE Package: ODATA_PS_COS_PROJFIN_MNTR

Project Definition Value Help

I_ProjectByProjMgrVH is a Composite CDS View that provides data about "Project Definition Value Help" in SAP S/4HANA. It reads from 1 data source (I_ProjectBasicData) and exposes 16 fields with key field Project. It has 1 association to related views. Part of development package ODATA_PS_COS_PROJFIN_MNTR.

Data Sources (1)

SourceAliasJoin Type
I_ProjectBasicData _Project from

Associations (1)

CardinalityTargetAliasCondition
[0..1] R_EnterpriseProject _ProjectSummary _ProjectSummary.ProjectInternalID = $projection.ProjectInternalID

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IPPROJVH view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Project Definition Value Help view
ObjectModel.representativeKey Project view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
Metadata.ignorePropagatedAnnotations true view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY Project I_ProjectBasicData Project
ProjectUUID _ProjectSummary ProjectUUID
ProjectDescription I_ProjectBasicData ProjectDescription
ProjectInternalID ProjectInternalID
ProjectObject ProjectObject
ProjectProfileCode ProjectProfileCode
PlannedStartDate PlannedStartDate
PlannedEndDate PlannedEndDate
ProjectSummaryTaskUUID _ProjectSummary ProjectSummaryTaskUUID
ProjectCategory _ProjectSummary ProjectCategory
CompanyCode I_ProjectBasicData CompanyCode
ProfitCenter I_ProjectBasicData ProfitCenter
ControllingArea I_ProjectBasicData ControllingArea
ProjectProcessingStatus _ProjectSummary ProcessingStatus
Plant I_ProjectBasicData Plant
FunctionalArea I_ProjectBasicData FunctionalArea
@AbapCatalog.sqlViewName: 'IPPROJVH'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Project Definition Value Help'
@ObjectModel.representativeKey: 'Project'
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #MASTER
@AccessControl.personalData.blocking: #NOT_REQUIRED
@VDM.viewType: #COMPOSITE
@Metadata.ignorePropagatedAnnotations: true
@VDM.lifecycle.contract.type:  #SAP_INTERNAL_API


define view I_ProjectByProjMgrVH // change the name of this view because it is should not end with VH

  //as select from I_ProjectBasicData as _Project // costcenter field is missing.

  as select from I_ProjectBasicData as _Project
  association [0..1] to R_EnterpriseProject  as _ProjectSummary on _ProjectSummary.ProjectInternalID = $projection.ProjectInternalID
{
      @ObjectModel.text.element: 'ProjectDescription'
//  key _Project.ProjectExternalID as Project,                 //changed in CE 2602: Read Project field from PSPID_EDIT instead of PSPID 

  key _Project.Project,                 //changed in CE 2602: Read Project field from PSPID_EDIT instead of PSPID 

      _ProjectSummary.ProjectUUID,
      @Semantics.text: true
      _Project.ProjectDescription,
      ProjectInternalID,
      ProjectObject,
      ProjectProfileCode,
      PlannedStartDate,
      PlannedEndDate,
      _ProjectSummary.ProjectSummaryTaskUUID,
      _ProjectSummary.ProjectCategory,
      _Project.CompanyCode,
      _Project.ProfitCenter,
      _Project.ControllingArea,
      @UI.hidden: true
      _ProjectSummary.ProcessingStatus as ProjectProcessingStatus, 
      // CE2402: /S4PPM/PR1 changes - Begin

      _Project.Plant, 
      _Project.FunctionalArea
//    Cost center and project type are not added as part of this change as these fields are supposed to be fetched from PRPS table but wbs element related data is not shown in cost prediction.  

      // CE2402: /S4PPM/PR1 changes - End

}