What is C_PubSecBdgtCnsmpnAnalysis in SAP S/4HANA?

C_PubSecBdgtCnsmpnAnalysis is a consumption CDS view in SAP S/4HANA. Public Sector Budget Consumption Analysis It contains 79 fields.

Which tables does C_PubSecBdgtCnsmpnAnalysis read from?

C_PubSecBdgtCnsmpnAnalysis reads data from: I_PubSecBdgtCnsmpnAnalysisCube.

What VDM layer is C_PubSecBdgtCnsmpnAnalysis?

C_PubSecBdgtCnsmpnAnalysis is classified as a Consumption view optimized for specific business scenarios and reporting.

C_PubSecBdgtCnsmpnAnalysis

DDL: C_PUBSECBDGTCNSMPNANALYSIS SQL: CPSBDGTCNSMPNC Type: view CONSUMPTION

79 Fields 1 Data Sources 1 Fiori Apps

Public Sector Budget Consumption Analysis

C_PubSecBdgtCnsmpnAnalysis (Consumption)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Cross Applications

C_PubSecBdgtCnsmpnAnalysis is a Consumption CDS View (Cube) that provides data about "Public Sector Budget Consumption Analysis" in SAP S/4HANA. It reads from 1 data source (I_PubSecBdgtCnsmpnAnalysisCube) and exposes 79 fields with key fields Ledger, CompanyCode, FinancialManagementArea, ControllingArea, FiscalYear. It is used in 1 Fiori application: My Budget Overview.

SAP API Hub

State	C1
Line of Business	Cross Applications
Application Component	PSM-FM-IS
Capabilities	Data Provider for Analytical Queries
Package	Cross Applications for SAP S/4HANA Cloud Private Edition

Documentation

Analytics with CDS Views — Build Analytics for S/4HANA Cloud Private Edition ABAP CDS views replicated to SAP Cloud Platform
CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA Cloud Private Edition CDS Views on SAP Business Accelerator Hub
Create CDS View as API — Create CDS views in SAP S/4HANA Cloud Private Edition and consume them as APIs
Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
SAP Extensibility Explorer for SAP S/4HANA Cloud Private Edition — Explore SAP S/4HANA Cloud Private Edition Extensibility options by leveraging the sample scenarios from SAP
SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
VDM View Types — The Virtual Data Model in SAP S/4HANA Cloud Private Edition
View Browser — Search, browse and tag CDS Views

Data Sources (1)

Source	Alias	Join Type
I_PubSecBdgtCnsmpnAnalysisCube	Cube	from

Annotations (18)

Name	Value	Level
AbapCatalog.sqlViewName	CPSBDGTCNSMPNC	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
AccessControl.authorizationCheck	#CHECK	view
AccessControl.personalData.blocking	#BLOCKED_DATA_EXCLUDED	view
EndUserText.label	Public Sector Budget Consumption Analysis	view
VDM.viewType	#CONSUMPTION	view
Search.searchable	false	view
Metadata.allowExtensions	true	view
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#XXL	view
Analytics.internalName	#LOCAL	view
Analytics.dataCategory	#CUBE	view
ObjectModel.modelingPattern	#ANALYTICAL_CUBE	view
Metadata.ignorePropagatedAnnotations	true	view
OData.publish	true	view

Fiori Apps (1)

App ID	App Name	Type	Description
F2163	My Budget Overview	Analytical	My Budget Overview is an analytical app based on Smart Business to display personalized budget and spend information based on Funds Management Availability Control data

My Budget Overview

Business Role: Budget Responsible - Funds Management

This feature enables you to have an overview of the of the budget and spending status (consumable, consumed, available amount) within your area of responsibility.You mayDrill down to the underlying data at various flexible summarization levelsAdjust the predefined budget dataFocus on specific areas of your budget by creating additional tiles

Fields (79)

Key	Field	Source Table	Source Field	Description
KEY	Ledger	I_PubSecBdgtCnsmpnAnalysisCube	Ledger	Ledger in General Ledger Accounting
KEY	CompanyCode	I_PubSecBdgtCnsmpnAnalysisCube	CompanyCode	Receiver Company Code
KEY	FinancialManagementArea	I_PubSecBdgtCnsmpnAnalysisCube	FinancialManagementArea	Financial Management Area
KEY	ControllingArea	I_PubSecBdgtCnsmpnAnalysisCube	ControllingArea	Controlling Area
KEY	FiscalYear	I_PubSecBdgtCnsmpnAnalysisCube	FiscalYear	G/L Fiscal Year
KEY	CtrlObjForFund	I_PubSecBdgtCnsmpnAnalysisCube	CtrlObjForFund	Control Object for a Fund
KEY	CtrlObjForFunctionalArea	I_PubSecBdgtCnsmpnAnalysisCube	CtrlObjForFunctionalArea	Control Object for a Functional Area
KEY	CtrlObjForBudgetPeriod	I_PubSecBdgtCnsmpnAnalysisCube	CtrlObjForBudgetPeriod	Control Object for a Budget Period
KEY	CtrlObjForCostCenter	I_PubSecBdgtCnsmpnAnalysisCube	CtrlObjForCostCenter	Control Object for a Cost Center
KEY	CtrlObjForWBSElement	I_PubSecBdgtCnsmpnAnalysisCube	CtrlObjForWBSElement	Control Object for a WBS Element
KEY	CtrlObjForBudgetAccount	I_PubSecBdgtCnsmpnAnalysisCube	CtrlObjForBudgetAccount	Control Object for a Budget Account
KEY	CtrlObjForGrant			Control Object for a Grant
KEY	CtrlObjForSponsoredClass	I_PubSecBdgtCnsmpnAnalysisCube	CtrlObjForSponsoredClass	Control Object for a Sponsored Class
KEY	CtrlObjForSponsoredProgram	I_PubSecBdgtCnsmpnAnalysisCube	CtrlObjForSponsoredProgram	Control Object for a Sponsored Program
KEY	CtrlObjForBdgtValidityNmbr	I_PubSecBdgtCnsmpnAnalysisCube	CtrlObjForBdgtValidityNmbr	Control Object for a Budget Validity Number
KEY	GranteeMgmtSponsor			Grant Sponsor
KEY	GlobalCurrency	I_PubSecBdgtCnsmpnAnalysisCube	GlobalCurrency	GM Billing Element: Global Currency
KEY	PubSecBdgtAcctRevnExpnCode	I_PubSecBdgtCnsmpnAnalysisCube	PubSecBdgtAcctRevnExpnCode	Expense or Revenue on Budget Account
KEY	AvailabilityControlProfile	I_PubSecBdgtCnsmpnAnalysisCube	AvailabilityControlProfile	Budget Availability Control Profile for Public Sector Mgmt
KEY	Fund	I_PubSecBdgtCnsmpnAnalysisCube	Fund	Sender Fund
KEY	CostCenter	I_PubSecBdgtCnsmpnAnalysisCube	CostCenter	Cost Center
KEY	FinancialAccountType	I_PubSecBdgtCnsmpnAnalysisCube	FinancialAccountType	Fin. Account Type
KEY	BusinessArea	I_PubSecBdgtCnsmpnAnalysisCube	BusinessArea	Business Area
KEY	Segment	I_PubSecBdgtCnsmpnAnalysisCube	Segment	Segment for Segmental Reporting
KEY	GLAccount	I_PubSecBdgtCnsmpnAnalysisCube	GLAccount	General Ledger
KEY	Supplier	I_PubSecBdgtCnsmpnAnalysisCube	Supplier	Supplier
KEY	Customer	I_PubSecBdgtCnsmpnAnalysisCube	Customer	Customer Number
KEY	AccountingDocumentType	I_PubSecBdgtCnsmpnAnalysisCube	AccountingDocumentType	Journal Entry Type
KEY	ProfitCenter	I_PubSecBdgtCnsmpnAnalysisCube	ProfitCenter	Profit Center
KEY	GrantID	I_PubSecBdgtCnsmpnAnalysisCube	GrantID	Sender Grant
KEY	SponsoredClass	I_PubSecBdgtCnsmpnAnalysisCube	SponsoredClass	Sponsored Class
KEY	SponsoredProgram	I_PubSecBdgtCnsmpnAnalysisCube	SponsoredProgram	Sponsored Program
KEY	GteeMBudgetValidityNumber	I_PubSecBdgtCnsmpnAnalysisCube	GteeMBudgetValidityNumber	Budget Validity Number
KEY	FunctionalArea	I_PubSecBdgtCnsmpnAnalysisCube	FunctionalArea	Sendr Fctl Area
	BdgtConsumableExpnAmtInGCrcy			Consumable Expense Amount in Global Currency
	BdgtConsumedExpnAmtInGCrcy			Consumed Expense Amount in Global Currency
	BdgtAvailableExpnAmtInGCrcy			Available Expense Amount in Global Currency
	HierarchyIDForFund	I_PubSecBdgtCnsmpnAnalysisCube	HierarchyIDForFund	Hierarchy ID for Fund
	HierarchyIDForFunctionalArea	I_PubSecBdgtCnsmpnAnalysisCube	HierarchyIDForFunctionalArea	Hierarchy ID for Functional Area
	HierarchyIDForBudgetPeriod	I_PubSecBdgtCnsmpnAnalysisCube	HierarchyIDForBudgetPeriod	Hierarchy ID for Budget Period
	HierarchyIDForCostCenter	I_PubSecBdgtCnsmpnAnalysisCube	HierarchyIDForCostCenter	Hierarchy ID for Cost Center
	HierarchyIDForWBSElement	I_PubSecBdgtCnsmpnAnalysisCube	HierarchyIDForWBSElement	Hierarchy ID for WBS Element
	HierarchyIDForBudgetAccount	I_PubSecBdgtCnsmpnAnalysisCube	HierarchyIDForBudgetAccount	Hierarchy ID for Budget Account Element
	GrantHierarchy	I_PubSecBdgtCnsmpnAnalysisCube	GrantHierarchy	Grant Hierarchy
	SponsoredClassHierarchy	I_PubSecBdgtCnsmpnAnalysisCube	SponsoredClassHierarchy	Sponsored Class Hierarchy
	SponsoredProgramHierarchy	I_PubSecBdgtCnsmpnAnalysisCube	SponsoredProgramHierarchy	Sponsored Program Hierarchy
	CtrlObjNameForFund			Name of a Control Object for a Fund
	CtrlObjNameForFunctionalArea			Name of a Control Object for a Functional Area
	CtrlObjNameForBudgetPeriod			Name of a Control Object for a Budget Period
	CtrlObjNameForCostCenter			Name of a Control Object for a Cost Center
	CtrlObjNameForWBSElement			Name of a Control Object for a WBS Element
	CtrlObjNameForBudgetAccount			Name of a Control Object for a Budget Account
	CtrlObjForGrantName			Control Object for a Grant
	CtrlObjForSponsoredClassName			Control Object for a Sponsored Class
	CtrlObjForSponsoredProgramName			Control Object for a Sponsored Program
	BusinessPartnerName
	PubSecBdgtAcctRevnExpnCodeText			Description of Expense or Revenue on Budget Account
	AvailabilityControlProfileName			Budget Availability Control: Profile Name
	CompanyCodeName			Name of Company Code or Company
	CurrencyName			Description
	_CompanyCode	I_PubSecBdgtCnsmpnAnalysisCube	_CompanyCode
	_ControllingArea	I_PubSecBdgtCnsmpnAnalysisCube	_ControllingArea
	_FinancialManagementArea	I_PubSecBdgtCnsmpnAnalysisCube	_FinancialManagementArea
	_Fund	I_PubSecBdgtCnsmpnAnalysisCube	_Fund
	_Grant	I_PubSecBdgtCnsmpnAnalysisCube	_Grant
	_CostCenter	I_PubSecBdgtCnsmpnAnalysisCube	_CostCenter
	_CurrentCostCenter	I_PubSecBdgtCnsmpnAnalysisCube	_CurrentCostCenter
	_PubSecBdgtAcctRevnExpnCode	I_PubSecBdgtCnsmpnAnalysisCube	_PubSecBdgtAcctRevnExpnCode
	_PubSecAvailyCtrlProfile	I_PubSecBdgtCnsmpnAnalysisCube	_PubSecAvailyCtrlProfile
	_FinancialAccountType	I_PubSecBdgtCnsmpnAnalysisCube	_FinancialAccountType
	_BusinessArea	I_PubSecBdgtCnsmpnAnalysisCube	_BusinessArea
	_Segment	I_PubSecBdgtCnsmpnAnalysisCube	_Segment
	_GLAccountInCompanyCode	I_PubSecBdgtCnsmpnAnalysisCube	_GLAccountInCompanyCode
	_Supplier	I_PubSecBdgtCnsmpnAnalysisCube	_Supplier
	_Customer	I_PubSecBdgtCnsmpnAnalysisCube	_Customer
	_AccountingDocumentType	I_PubSecBdgtCnsmpnAnalysisCube	_AccountingDocumentType
	_ProfitCenter	I_PubSecBdgtCnsmpnAnalysisCube	_ProfitCenter
	_CurrentProfitCenter	I_PubSecBdgtCnsmpnAnalysisCube	_CurrentProfitCenter
	_FunctionalArea	I_PubSecBdgtCnsmpnAnalysisCube	_FunctionalArea

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_PubSecBdgtCnsmpnAnalysis.
-- 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: CPSBDGTCNSMPNC

CREATE VIEW C_PubSecBdgtCnsmpnAnalysis AS
SELECT
  Cube.Ledger AS Ledger,
  Cube.CompanyCode AS CompanyCode,
  Cube.FinancialManagementArea AS FinancialManagementArea,
  Cube.ControllingArea AS ControllingArea,
  Cube.FiscalYear AS FiscalYear,
  Cube.CtrlObjForFund AS CtrlObjForFund,
  Cube.CtrlObjForFunctionalArea AS CtrlObjForFunctionalArea,
  Cube.CtrlObjForBudgetPeriod AS CtrlObjForBudgetPeriod,
  Cube.CtrlObjForCostCenter AS CtrlObjForCostCenter,
  Cube.CtrlObjForWBSElement AS CtrlObjForWBSElement,
  Cube.CtrlObjForBudgetAccount AS CtrlObjForBudgetAccount,
  cast( ltrim(Cube.CtrlObjForGrant,'0') as psm_s4c_fm_avc_ctrl_obj_gr preserving type ) AS CtrlObjForGrant,
  Cube.CtrlObjForSponsoredClass AS CtrlObjForSponsoredClass,
  Cube.CtrlObjForSponsoredProgram AS CtrlObjForSponsoredProgram,
  Cube.CtrlObjForBdgtValidityNmbr AS CtrlObjForBdgtValidityNmbr,
  Cube._Grant.GranteeMgmtSponsor AS GranteeMgmtSponsor,
  Cube.GlobalCurrency AS GlobalCurrency,
  Cube.PubSecBdgtAcctRevnExpnCode AS PubSecBdgtAcctRevnExpnCode,
  Cube.AvailabilityControlProfile AS AvailabilityControlProfile,
  Cube.Fund AS Fund,
  Cube.CostCenter AS CostCenter,
  Cube.FinancialAccountType AS FinancialAccountType,
  Cube.BusinessArea AS BusinessArea,
  Cube.Segment AS Segment,
  Cube.GLAccount AS GLAccount,
  Cube.Supplier AS Supplier,
  Cube.Customer AS Customer,
  Cube.AccountingDocumentType AS AccountingDocumentType,
  Cube.ProfitCenter AS ProfitCenter,
  Cube.GrantID AS GrantID,
  Cube.SponsoredClass AS SponsoredClass,
  Cube.SponsoredProgram AS SponsoredProgram,
  Cube.GteeMBudgetValidityNumber AS GteeMBudgetValidityNumber,
  Cube.FunctionalArea AS FunctionalArea,
  cast( Cube.BdgtConsumableAmtInGlobalCrcy as psm_amt_expn_cbdgt_grp_curr preserving type ) AS BdgtConsumableExpnAmtInGCrcy,
  cast( Cube.BdgtConsumedAmtInGlobalCrcy as psm_amt_expn_cpost_grp_curr preserving type ) AS BdgtConsumedExpnAmtInGCrcy,
  cast( Cube.BdgtAvailableAmtInGlobalCrcy as psm_amt_expn_avail_grp_curr preserving type ) AS BdgtAvailableExpnAmtInGCrcy,
  Cube.HierarchyIDForFund AS HierarchyIDForFund,
  Cube.HierarchyIDForFunctionalArea AS HierarchyIDForFunctionalArea,
  Cube.HierarchyIDForBudgetPeriod AS HierarchyIDForBudgetPeriod,
  Cube.HierarchyIDForCostCenter AS HierarchyIDForCostCenter,
  Cube.HierarchyIDForWBSElement AS HierarchyIDForWBSElement,
  Cube.HierarchyIDForBudgetAccount AS HierarchyIDForBudgetAccount,
  Cube.GrantHierarchy AS GrantHierarchy,
  Cube.SponsoredClassHierarchy AS SponsoredClassHierarchy,
  Cube.SponsoredProgramHierarchy AS SponsoredProgramHierarchy,
  Cube._CtrlObjFund.CtrlObjNameForFund AS CtrlObjNameForFund,
  Cube._CtrlObjFuncArea.CtrlObjNameForFunctionalArea AS CtrlObjNameForFunctionalArea,
  Cube._CtrlObjBdgtPeriod.CtrlObjNameForBudgetPeriod AS CtrlObjNameForBudgetPeriod,
  Cube._CtrlObjCostCenter.CtrlObjNameForCostCenter AS CtrlObjNameForCostCenter,
  Cube._CtrlObjWBSElement.CtrlObjNameForWBSElement AS CtrlObjNameForWBSElement,
  Cube._CtrlObjBdgtAccount.CtrlObjNameForBudgetAccount AS CtrlObjNameForBudgetAccount,
  Cube._CtrlObjGrant.CtrlObjForGrantName AS CtrlObjForGrantName,
  Cube._CtrlObjSpnsrdClass.CtrlObjForSponsoredClassName AS CtrlObjForSponsoredClassName,
  Cube._CtrlObjSpnsrdProg.CtrlObjForSponsoredProgramName AS CtrlObjForSponsoredProgramName,
  Cube._Grant._Sponsor.BusinessPartnerName AS BusinessPartnerName,
  Cube._PubSecBdgtAcctRevnExpnCode._Text[1:Language = $session.system_language].PubSecBdgtAcctRevnExpnCodeText AS PubSecBdgtAcctRevnExpnCodeText,
  Cube._PubSecAvailyCtrlProfile._Text[1:Language = $session.system_language].AvailabilityControlProfileName AS AvailabilityControlProfileName,
  Cube._CompanyCode.CompanyCodeName AS CompanyCodeName,
  Cube._GlobalCurrency._Text[1:Language = $session.system_language].CurrencyName AS CurrencyName,
  Cube._CompanyCode AS _CompanyCode,
  Cube._ControllingArea AS _ControllingArea,
  Cube._FinancialManagementArea AS _FinancialManagementArea,
  Cube._Fund AS _Fund,
  Cube._Grant AS _Grant,
  Cube._CostCenter AS _CostCenter,
  Cube._CurrentCostCenter AS _CurrentCostCenter,
  Cube._PubSecBdgtAcctRevnExpnCode AS _PubSecBdgtAcctRevnExpnCode,
  Cube._PubSecAvailyCtrlProfile AS _PubSecAvailyCtrlProfile,
  Cube._FinancialAccountType AS _FinancialAccountType,
  Cube._BusinessArea AS _BusinessArea,
  Cube._Segment AS _Segment,
  Cube._GLAccountInCompanyCode AS _GLAccountInCompanyCode,
  Cube._Supplier AS _Supplier,
  Cube._Customer AS _Customer,
  Cube._AccountingDocumentType AS _AccountingDocumentType,
  Cube._ProfitCenter AS _ProfitCenter,
  Cube._CurrentProfitCenter AS _CurrentProfitCenter,
  Cube._FunctionalArea AS _FunctionalArea
FROM I_PubSecBdgtCnsmpnAnalysisCube AS Cube
;

Depth:

C_PubSecBdgtCnsmpnAnalysis view

I_PubSecBdgtCnsmpnAnalysisCube view