C_ProjectVH
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 | Field |
|---|---|---|---|
| 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 Table | 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
}
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA