C_WBSElementVH

DDL: C_WBSELEMENTVH SQL: CWBSELEMENTVH Type: view CONSUMPTION
8 Fields 1 Data Sources 1 Fiori Apps

WBSElement Value Help

C_WBSElementVH is a Consumption CDS View that provides data about "WBSElement Value Help" in SAP S/4HANA. It reads from 1 data source (I_WBSElement) and exposes 8 fields with key field WBSElement. It is used in 1 Fiori application: Project Cost Report - Overview.

Data Sources (1)

SourceAliasJoin Type
I_WBSElement WBSElement from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CWBSELEMENTVH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label WBSElement Value Help view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
VDM.viewType #CONSUMPTION view
OData.publish true view
ObjectModel.representativeKey WBSElement view
Search.searchable true 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 (8)

KeyFieldSource TableSource FieldDescription
KEY WBSElement I_WBSElement WBSElement WBS Internal ID
WBSDescription I_WBSElement WBSDescription WBS Element Name
Project I_WBSElement Project WBS Element
ProjectDescription
CompanyCode I_WBSElement CompanyCode Receiver Company Code
RespCostCenterControllingArea RespCostCenterControllingArea CA Resp. Cost Center
ResponsibleCostCenter I_WBSElement ResponsibleCostCenter Responsible Cost Center
ProfitCenter ProfitCenter Profit Center

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_WBSElementVH.
-- 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: CWBSELEMENTVH

CREATE VIEW C_WBSElementVH AS
SELECT
  WBSElement.WBSElement AS WBSElement,
  WBSElement.WBSDescription AS WBSDescription,
  WBSElement.Project AS Project,
  WBSElement._Project.ProjectDescription AS ProjectDescription,
  WBSElement.CompanyCode AS CompanyCode,
  RespCostCenterControllingArea,
  WBSElement.ResponsibleCostCenter AS ResponsibleCostCenter,
  ProfitCenter
FROM I_WBSElement AS WBSElement
;

Learn More