C_ProjOvrlBudgetConsumption

DDL: C_PROJOVRLBUDGETCONSUMPTION SQL: CPROVBDGTCONS Type: view CONSUMPTION
17 Fields 1 Data Sources 1 Associations

Projects with Overall Budget Costs

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

Data Sources (1)

SourceAliasJoin Type
P_ProjOvrlBudgetConsumption ProjCostLineItems from

Associations (1)

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

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CPROVBDGTCONS view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Projects with Overall Budget Costs 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
AbapCatalog.preserveKey true view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY Project P_ProjOvrlBudgetConsumption Project WBS Element
KEY CompanyCode P_ProjOvrlBudgetConsumption CompanyCode Receiver Company Code
KEY ProfitCenter P_ProjOvrlBudgetConsumption ProfitCenter Profit Center
ProjectUUID P_ProjOvrlBudgetConsumption ProjectUUID Project UUID
ProjectDescription P_ProjOvrlBudgetConsumption ProjectDescription Project Name
ProjectInternalID P_ProjOvrlBudgetConsumption ProjectInternalID Project Def.
ControllingArea P_ProjOvrlBudgetConsumption ControllingArea Controlling Area
BusinessPartnerFullName P_ProjOvrlBudgetConsumption BusinessPartnerFullName Broker Name
BusinessPartnerUUID P_ProjOvrlBudgetConsumption BusinessPartnerUUID UUID
BusinessPartner P_ProjOvrlBudgetConsumption BusinessPartner Issuing Authority
GlobalCurrency P_ProjOvrlBudgetConsumption GlobalCurrency GM Billing Element: Global Currency
ProjectType P_ProjOvrlBudgetConsumption 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_ProjOvrlBudgetConsumption.
-- 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: CPROVBDGTCONS

CREATE VIEW C_ProjOvrlBudgetConsumption AS
SELECT
  ProjCostLineItems.Project AS Project,
  ProjCostLineItems.CompanyCode AS CompanyCode,
  ProjCostLineItems.ProfitCenter AS ProfitCenter,
  ProjCostLineItems.ProjectUUID AS ProjectUUID,
  ProjCostLineItems.ProjectDescription AS ProjectDescription,
  ProjCostLineItems.ProjectInternalID AS ProjectInternalID,
  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 P_ProjOvrlBudgetConsumption AS ProjCostLineItems
LEFT OUTER JOIN E_PPM_Project AS _ProjectHeaderExtension ON ProjectUUID = _ProjectHeaderExtension.ProjectUUID  -- association [1..1]
;

Learn More