Which tables does C_ProjectVH use?

C_ProjectVH reads from 1 data source(s): I_ProjectByProjMgr.

How many fields does C_ProjectVH have?

C_ProjectVH has 12 fields. Key fields: Project.

C_ProjectVH

DDL: C_PROJECTVH SQL: CPROJVH Type: view CONSUMPTION

Project Definition Value Help

C_ProjectVH is a Consumption CDS View that provides data about "Project Definition Value Help" in SAP S/4HANA. It reads from 1 data source (I_ProjectByProjMgr) and exposes 12 fields with key field Project. It has 4 associations to related views. It is used in 1 Fiori application: Project Cost Report - Overview.

Data Sources (1)

Source	Alias	Join Type
I_ProjectByProjMgr	I_ProjectByProjMgr	from

Associations (4)

Cardinality	Target	Alias	Condition
[0..*]	I_PPM_AuthznByUsrH	_AuthUser	`$projection.ProjectSummaryTaskUUID = _AuthUser.ReferencedObjectUUID and _AuthUser.UserID = $session.user and ( _AuthUser.Activity = 'Admin' or _AuthUser.Activity = 'Write' or _AuthUser.Activity = 'Read' )`
[0..*]	I_PPM_AuthznBySubstitH	_AuthSubst	`_AuthSubst.ReferencedObjectUUID = $projection.ProjectSummaryTaskUUID and _AuthSubst.UserID = $session.user and ( _AuthSubst.Activity = 'Admin' or _AuthSubst.Activity = 'Write' or _AuthSubst.Activity = 'Read' )`
[0..*]	I_PPM_AuthznByUserRoleH	_AuthRole	`_AuthRole.ReferencedObjectUUID = $projection.ProjectSummaryTaskUUID and _AuthRole.UserID = $session.user and ( _AuthRole.Activity = 'Admin' or _AuthRole.Activity = 'Write' or _AuthRole.Activity = 'Read' )`
[0..*]	I_PPM_AuthznByUsrGrpH	_AuthGroup	`_AuthGroup.ReferencedObjectUUID = $projection.ProjectSummaryTaskUUID and _AuthGroup.UserID = $session.user and ( _AuthGroup.Activity = 'Admin' or _AuthGroup.Activity = 'Write' or _AuthGroup.Activity = 'Read' )`

Annotations (14)

Name	Value	Level
AbapCatalog.sqlViewName	CPROJVH	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	#REQUIRED	view
VDM.viewType	#CONSUMPTION	view
OData.publish	true	view
Search.searchable	true	view
ObjectModel.dataCategory	#VALUE_HELP	view
Consumption.ranked	true	view

Fiori Apps (1)

App ID	App Name	Type	Description
F2513	Project Cost Report - Overview	Analytical	An application to compare the plan versus actual costs of a project.

Project Cost Report - Overview

Business Role: Project Financial Controller

This feature enables you to easily monitor aggregated and non-aggregated project costs by allowing you to compare plan costs with actual costs. You can also monitor the variance and costs at individual line item level, configure two cost planning categories and use one category for calculation of variance. You can also enter the level to which a project tree has to be expanded, and view cost details of multiple projects or WBS elements from different projects and hierarchies.

Fields (12)

Key	Field	Source Field	Description
KEY	Project	Project
	ProjectDescription	ProjectDescription
	ProjectSummaryTaskUUID	ProjectSummaryTaskUUID
	ProjectManagerUUID	ProjectManagerUUID
	BusinessPartnerFullName	BusinessPartnerFullName	Project Manager
	CompanyCode	CompanyCode
	ProfitCenter	ProfitCenter
	ControllingArea	ControllingArea
	_AuthUser	_AuthUser
	_AuthSubst	_AuthSubst
	_AuthRole	_AuthRole
	_AuthGroup	_AuthGroup

@AbapCatalog.sqlViewName: 'CPROJVH'
@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: #REQUIRED
@VDM.viewType: #CONSUMPTION
@OData.publish: true
@Search.searchable: true
@ObjectModel.dataCategory: #VALUE_HELP
@Consumption.ranked: true

define view C_ProjectVH
  as select from I_ProjectByProjMgr
  association [0..*] to I_PPM_AuthznByUsrH         as _AuthUser    on  $projection.ProjectSummaryTaskUUID = _AuthUser.ReferencedObjectUUID
                                                                   and _AuthUser.UserID                   = $session.user
                                                                   and (
                                                                      _AuthUser.Activity                  = 'Admin'
                                                                      or _AuthUser.Activity               = 'Write'
                                                                      or _AuthUser.Activity               = 'Read'
                                                                    )
  association [0..*] to I_PPM_AuthznBySubstitH     as _AuthSubst   on  _AuthSubst.ReferencedObjectUUID = $projection.ProjectSummaryTaskUUID
                                                                   and _AuthSubst.UserID               = $session.user
                                                                   and (
                                                                      _AuthSubst.Activity              = 'Admin'
                                                                      or _AuthSubst.Activity           = 'Write'
                                                                      or _AuthSubst.Activity           = 'Read'
                                                                    )
  association [0..*] to I_PPM_AuthznByUserRoleH    as _AuthRole    on  _AuthRole.ReferencedObjectUUID = $projection.ProjectSummaryTaskUUID
                                                                   and _AuthRole.UserID               = $session.user
                                                                   and (
                                                                      _AuthRole.Activity              = 'Admin'
                                                                      or _AuthRole.Activity           = 'Write'
                                                                      or _AuthRole.Activity           = 'Read'
                                                                    )
  association [0..*] to I_PPM_AuthznByUsrGrpH      as _AuthGroup   on  _AuthGroup.ReferencedObjectUUID = $projection.ProjectSummaryTaskUUID
                                                                   and _AuthGroup.UserID               = $session.user
                                                                   and (
                                                                      _AuthGroup.Activity              = 'Admin'
                                                                      or _AuthGroup.Activity           = 'Write'
                                                                      or _AuthGroup.Activity           = 'Read'
                                                                    )
{
      @ObjectModel.text.element: 'ProjectDescription'
      @Search: { defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 0.8 }
  key Project,

      @Semantics.text: true
      @Search: { defaultSearchElement: true, ranking: #LOW, fuzzinessThreshold: 0.8 }
      ProjectDescription,

      //@Consumption.filter.hidden: true

      @Consumption.hidden: true
      ProjectSummaryTaskUUID,


      
//      @EndUserText.label: 'Project Internal ID'

//      @Search: { defaultSearchElement: true, ranking: #HIGH }

//      @Search.fuzzinessThreshold: 0.8 

//      ProjectInternalID,

//      

//      @EndUserText.label: 'Project Object Root Node'

//      @Search: { defaultSearchElement: true, ranking: #HIGH }

//      @Search.fuzzinessThreshold: 0.8

//      ProjectObjectRootNode,

    
      @UI.hidden: true
      @Consumption.hidden: true
      ProjectManagerUUID,
// changes for CPM Value help in MPP

      @EndUserText.label: 'Project Manager'
      @Search: { defaultSearchElement: true, ranking: #LOW, fuzzinessThreshold: 0.8 }
      BusinessPartnerFullName,
//      case

//      when BusinessPartnerFullName is null

//      then cast ( ResponsiblePersonName as ps_verna)

//      else cast ( BusinessPartnerFullName as ps_verna)

//      end                              as BusinessPartnerFullName,

//      

      
      
//      _ResPerson.ResponsiblePersonName as BusinessPartnerFullName,


      @Search: { defaultSearchElement: true, ranking: #MEDIUM, fuzzinessThreshold: 0.8 }
      CompanyCode,

      @Search: { defaultSearchElement: true, ranking: #MEDIUM, fuzzinessThreshold: 0.8 }
      ProfitCenter,

      @Search: { defaultSearchElement: true, ranking: #MEDIUM, fuzzinessThreshold: 0.8 }
      ControllingArea,

      @UI.hidden: true
      @Consumption.hidden: true
      _AuthUser,
      @UI.hidden: true
      @Consumption.hidden: true
      _AuthSubst,
      @UI.hidden: true
      @Consumption.hidden: true
      _AuthRole,
      @UI.hidden: true
      @Consumption.hidden: true
      _AuthGroup
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PROJECTBYPROJMGR"
],
"ASSOCIATED":
[
"I_PPM_AUTHZNBYSUBSTITH",
"I_PPM_AUTHZNBYUSERROLEH",
"I_PPM_AUTHZNBYUSRGRPH",
"I_PPM_AUTHZNBYUSRH"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Depth:

C_ProjectVH view

I_ProjectByProjMgr view