C_ProjectTypeVH

DDL: C_PROJECTTYPEVH SQL: CPROJECTTYPEVH Type: view CONSUMPTION
2 Fields 1 Data Sources 1 Associations 1 Fiori Apps

Project Type Value Help

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

Data Sources (1)

SourceAliasJoin Type
I_Projecttype I_Projecttype from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_Projecttypetext _Text $projection.ProjectType = _Text.ProjectType

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName CPROJECTTYPEVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Project Type Value Help view
ObjectModel.representativeKey ProjectType view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.resultSet.sizeCategory #XS view
ObjectModel.dataCategory #VALUE_HELP view
OData.publish true view
VDM.viewType #CONSUMPTION view

Fiori Apps (1)

App IDApp NameTypeDescription
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 (2)

KeyFieldSource TableSource FieldDescription
KEY ProjectType ProjectType Project Type
ProjectTypeName

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_ProjectTypeVH.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: CPROJECTTYPEVH

CREATE VIEW C_ProjectTypeVH AS
SELECT
  ProjectType,
  _Text[1:Language = $session.system_language].ProjectTypeName AS ProjectTypeName
FROM I_Projecttype
LEFT OUTER JOIN I_Projecttypetext AS _Text ON ProjectType = _Text.ProjectType  -- association [0..*]
;

Learn More