I_ProjectByProjMgrVH

DDL: I_PROJECTBYPROJMGRVH SQL: IPPROJVH Type: view COMPOSITE

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 14 fields with key field Project. It has 1 association to related views.

1 data source(s) 14 fields

Data Sources (1)

SourceAliasJoin Type
I_ProjectBasicData _Project from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_PPM_ProjectSummaryTask _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 (14)

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 ProjectProcessingStatus 
@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 I_PPM_ProjectSummaryTask as _ProjectSummary on _ProjectSummary.ProjectInternalID = $projection.ProjectInternalID
{
      @ObjectModel.text.element: 'ProjectDescription'
  key _Project.Project,
      _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.ProjectProcessingStatus    
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PPM_PROJECTSUMMARYTASK",
"I_PROJECTBASICDATA"
],
"ASSOCIATED":
[
"I_PPM_PROJECTSUMMARYTASK"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More