C_ProjectBudgetConsumption

DDL: C_PROJECTBUDGETCONSUMPTION SQL: CPROJBDGTCONS Type: view CONSUMPTION
17 Fields 1 Data Sources 1 Associations

Project Budget Consumption

C_ProjectBudgetConsumption is a Consumption CDS View that provides data about "Project Budget Consumption" in SAP S/4HANA. It reads from 1 data source (I_ProjectBudgetConsumption) and exposes 17 fields with key fields Project, CompanyCode, ProfitCenter. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_ProjectBudgetConsumption ProjCostLineItems from

Associations (1)

CardinalityTargetAliasCondition
[1..1] E_PPM_Project _ProjectHeaderExtension $projection.ProjectUUID = _ProjectHeaderExtension.ProjectUUID

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CPROJBDGTCONS view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Project Budget Consumption view
VDM.viewType #CONSUMPTION view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
Search.searchable true view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY Project I_ProjectBudgetConsumption Project WBS Element
KEY CompanyCode I_ProjectBudgetConsumption CompanyCode Receiver Company Code
KEY ProfitCenter I_ProjectBudgetConsumption ProfitCenter Profit Center
ProjectUUID I_ProjectBudgetConsumption ProjectUUID Project UUID
ProjectInternalID I_ProjectBudgetConsumption ProjectInternalID Project Def.
ProjectDescription I_ProjectBudgetConsumption ProjectDescription Project Name
ControllingArea I_ProjectBudgetConsumption ControllingArea Controlling Area
BusinessPartnerFullName I_ProjectBudgetConsumption BusinessPartnerFullName Broker Name
BusinessPartnerUUID I_ProjectBudgetConsumption BusinessPartnerUUID UUID
BusinessPartner I_ProjectBudgetConsumption BusinessPartner Issuing Authority
GlobalCurrency I_ProjectBudgetConsumption GlobalCurrency GM Billing Element: Global Currency
ProjectType I_ProjectBudgetConsumption ProjectType Project Type
UnitOfMeasure
PlanCostComponentName1 Budget Text
PlanCostComponentName2 Actual & Commitment Text
BudgetConsumption BudgetConsumption Budget consumption
ActlCmtmtCumltvAmtInGlobCrcy ActlCmtmtCumltvAmtInGlobCrcy Actual Costs & Commitments

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_ProjectBudgetConsumption.
-- 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: CPROJBDGTCONS

CREATE VIEW C_ProjectBudgetConsumption AS
SELECT
  ProjCostLineItems.Project AS Project,
  ProjCostLineItems.CompanyCode AS CompanyCode,
  ProjCostLineItems.ProfitCenter AS ProfitCenter,
  ProjCostLineItems.ProjectUUID AS ProjectUUID,
  ProjCostLineItems.ProjectInternalID AS ProjectInternalID,
  ProjCostLineItems.ProjectDescription AS ProjectDescription,
  ProjCostLineItems.ControllingArea AS ControllingArea,
  ProjCostLineItems.BusinessPartnerFullName AS BusinessPartnerFullName,
  ProjCostLineItems.BusinessPartnerUUID AS BusinessPartnerUUID,
  ProjCostLineItems.BusinessPartner AS BusinessPartner,
  ProjCostLineItems.GlobalCurrency AS GlobalCurrency,
  ProjCostLineItems.ProjectType AS ProjectType,
  cast('%' as msehi) AS UnitOfMeasure,
  cast( '' as fins_sem_tag_name) AS PlanCostComponentName1,
  cast( '' as dpr_project_name) AS PlanCostComponentName2,
  BudgetConsumption,
  ActlCmtmtCumltvAmtInGlobCrcy
FROM I_ProjectBudgetConsumption AS ProjCostLineItems
LEFT OUTER JOIN E_PPM_Project AS _ProjectHeaderExtension ON ProjectUUID = _ProjectHeaderExtension.ProjectUUID  -- association [1..1]
;

Learn More