P_ProjOvrlBudgetConsAgg

DDL: P_PROJOVRLBUDGETCONSAGG SQL: PPROJBDGTCONSA Type: view CONSUMPTION Package: ODATA_PS_COS_PROJ_OVERVIEW
31 Fields 1 Data Sources

Project Budget Consumption

P_ProjOvrlBudgetConsAgg is a Consumption CDS View that provides data about "Project Budget Consumption" in SAP S/4HANA. It reads from 1 data source (I_ProjectCostLineItemsOvw) and exposes 31 fields with key fields Project, CompanyCode, ProfitCenter. Part of development package ODATA_PS_COS_PROJ_OVERVIEW.

Data Sources (1)

SourceAliasJoin Type
I_ProjectCostLineItemsOvw ProjCostLineItems from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName PPROJBDGTCONSA view
VDM.viewType #CONSUMPTION view
VDM.private true view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #D view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.buffering.status #NOT_ALLOWED view
AccessControl.personalData.blocking #REQUIRED view

Fields (31)

KeyFieldSource TableSource FieldDescription
KEY Project I_ProjectCostLineItemsOvw Project WBS Element
KEY CompanyCode I_ProjectCostLineItemsOvw CompanyCode Receiver Company Code
KEY ProfitCenter I_ProjectCostLineItemsOvw ProfitCenter Profit Center
ProjectUUID I_ProjectCostLineItemsOvw ProjectUUID Project UUID
ProjectInternalID I_ProjectCostLineItemsOvw ProjectInternalID Project Def.
ProjectDescription I_ProjectCostLineItemsOvw ProjectDescription Project Name
ControllingArea I_ProjectCostLineItemsOvw ControllingArea Controlling Area
BusinessPartnerFullName I_ProjectCostLineItemsOvw BusinessPartnerFullName Broker Name
BusinessPartnerUUID I_ProjectCostLineItemsOvw BusinessPartnerUUID UUID
BusinessPartner I_ProjectCostLineItemsOvw BusinessPartner Issuing Authority
ProjectType I_ProjectCostLineItemsOvw ProjectType Project Type
GlobalCurrency I_ProjectCostLineItemsOvw GlobalCurrency GM Billing Element: Global Currency
ControllingObjectCurrency I_ProjectCostLineItemsOvw ControllingObjectCurrency CO Object Currency
BudgetCurrencyRole I_ProjectCostLineItemsOvw BudgetCurrencyRole
AvailyCtrlTimeRangeType I_ProjectCostLineItemsOvw AvailyCtrlTimeRangeType
AvailabilityControlProfile I_ProjectCostLineItemsOvw AvailabilityControlProfile Budget Availability Control Profile
CriticalityCode
UnitOfMeasure
PlanCostComponentName1
PlanCostComponentName2
AmountInObjectCurrency
AmountInGlobalCurrency
BudgetConsumption
BudgetInGlobalCrcy
ActlCmtmtCumltvAmtInGlobCrcy
BudgetInProjCrcy
AssgdValForBudgetInProjCrcy
FunctionalArea I_ProjectCostLineItemsOvw FunctionalArea Sendr Fctl Area
ProjectProfileCode I_ProjectCostLineItemsOvw ProjectProfileCode Project Profile
Plant I_ProjectCostLineItemsOvw Plant Valuation Area
ResponsibleCostCenter I_ProjectCostLineItemsOvw ResponsibleCostCenter Responsible Cost 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 P_ProjOvrlBudgetConsAgg.
-- 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: PPROJBDGTCONSA

CREATE VIEW P_ProjOvrlBudgetConsAgg 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.ProjectType AS ProjectType,
  ProjCostLineItems.GlobalCurrency AS GlobalCurrency,
  ProjCostLineItems.ControllingObjectCurrency AS ControllingObjectCurrency,
  ProjCostLineItems.BudgetCurrencyRole AS BudgetCurrencyRole,
  ProjCostLineItems.AvailyCtrlTimeRangeType AS AvailyCtrlTimeRangeType,
  ProjCostLineItems.AvailabilityControlProfile AS AvailabilityControlProfile,
  '0' AS CriticalityCode,
  cast('%' as msehi) AS UnitOfMeasure,
  cast( '' as fins_sem_tag_name) AS PlanCostComponentName1,
  cast( '' as dpr_project_name) AS PlanCostComponentName2,
  sum(ProjCostLineItems.AmountInObjectCurrency) AS AmountInObjectCurrency,
  sum(ProjCostLineItems.AmountInGlobalCurrency) AS AmountInGlobalCurrency,
  cast(1 as abap.dec(28)) AS BudgetConsumption,
  sum(ProjCostLineItems.PlanAmountInGlobalCurrency) AS BudgetInGlobalCrcy,
  sum(ProjCostLineItems.ActlCmtmtCumltvAmtInGlobCrcy) AS ActlCmtmtCumltvAmtInGlobCrcy,
  sum(ProjCostLineItems.PlndCostAmtInProjCrcy) AS BudgetInProjCrcy,
  sum(ProjCostLineItems.AssgdValForBudgetInProjCrcy) AS AssgdValForBudgetInProjCrcy,
  ProjCostLineItems.FunctionalArea AS FunctionalArea,
  ProjCostLineItems.ProjectProfileCode AS ProjectProfileCode,
  ProjCostLineItems.Plant AS Plant,
  ProjCostLineItems.ResponsibleCostCenter AS ResponsibleCostCenter
FROM I_ProjectCostLineItemsOvw AS ProjCostLineItems
;

Learn More