P_PubSecBdgtCnsmpnAnalysis

DDL: P_PUBSECBDGTCNSMPNANALYSIS SQL: PPSBDGTCNSMPN Type: view COMPOSITE
91 Fields 2 Data Sources

P_PubSecBdgtCnsmpnAnalysis is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_PubSecBdgtConsumedAnalysis, I_PubSecBdgtConsumableAnalysis) and exposes 91 fields with key fields Ledger, CompanyCode, FinancialManagementArea, ControllingArea, FiscalYear.

Data Sources (2)

SourceAliasJoin Type
I_PubSecBdgtConsumedAnalysis _A from
I_PubSecBdgtConsumableAnalysis _P union

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName PPSBDGTCNSMPN view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
AbapCatalog.buffering.status #NOT_ALLOWED view
VDM.viewType #COMPOSITE view
VDM.private true view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #P view
ObjectModel.usageType.sizeCategory #XL view

Fields (91)

KeyFieldSource TableSource FieldDescription
KEY Ledger I_PubSecBdgtConsumedAnalysis Ledger Ledger
KEY CompanyCode I_PubSecBdgtConsumedAnalysis CompanyCode Receiver Company Code
KEY FinancialManagementArea I_PubSecBdgtConsumedAnalysis FinancialManagementArea FM Area
KEY ControllingArea I_PubSecBdgtConsumedAnalysis ControllingArea Controlling Area
KEY FiscalYear I_PubSecBdgtConsumedAnalysis FiscalYear G/L Fiscal Year
KEY CtrlObjForFund I_PubSecBdgtConsumedAnalysis CtrlObjForFund Control Object Fund
KEY CtrlObjForFunctionalArea I_PubSecBdgtConsumedAnalysis CtrlObjForFunctionalArea Control Object Functional Area
KEY CtrlObjForBudgetPeriod I_PubSecBdgtConsumedAnalysis CtrlObjForBudgetPeriod Control Object Budget Period
KEY CtrlObjForCostCenter I_PubSecBdgtConsumedAnalysis CtrlObjForCostCenter Control Object Cost Center
KEY CtrlObjForWBSElement I_PubSecBdgtConsumedAnalysis CtrlObjForWBSElement Control Object WBS Element
KEY CtrlObjForBudgetAccount I_PubSecBdgtConsumedAnalysis CtrlObjForBudgetAccount Control Object Budget Account
KEY CtrlObjForGrant I_PubSecBdgtConsumedAnalysis CtrlObjForGrant Control Object Grant
KEY CtrlObjForSponsoredClass I_PubSecBdgtConsumedAnalysis CtrlObjForSponsoredClass Control Object Sponsored Class
KEY CtrlObjForSponsoredProgram I_PubSecBdgtConsumedAnalysis CtrlObjForSponsoredProgram Control Object Sponsored Program
KEY CtrlObjForBdgtValidityNmbr I_PubSecBdgtConsumedAnalysis CtrlObjForBdgtValidityNmbr
KEY GlobalCurrency I_PubSecBdgtConsumedAnalysis GlobalCurrency GM Billing Element: Global Currency
KEY PubSecBudgetAccount I_PubSecBdgtConsumedAnalysis PubSecBudgetAccount Budget Account
KEY PubSecBdgtAcctRevnExpnCode I_PubSecBdgtConsumedAnalysis PubSecBdgtAcctRevnExpnCode Expense/Revenue
KEY AvailabilityControlProfile I_PubSecBdgtConsumedAnalysis AvailabilityControlProfile Budget Availability Control Profile
KEY Fund I_PubSecBdgtConsumedAnalysis Fund Sender Fund
KEY GrantID I_PubSecBdgtConsumedAnalysis GrantID Sender Grant
KEY SponsoredClass I_PubSecBdgtConsumedAnalysis SponsoredClass Sponsored Class
KEY SponsoredProgram I_PubSecBdgtConsumedAnalysis SponsoredProgram Sponsored Program
KEY GteeMBudgetValidityNumber I_PubSecBdgtConsumedAnalysis GteeMBudgetValidityNumber Bdgt Validty No.
KEY CostCenter I_PubSecBdgtConsumedAnalysis CostCenter Cost Center
KEY FinancialAccountType I_PubSecBdgtConsumedAnalysis FinancialAccountType Fin. Account Type
KEY BusinessArea I_PubSecBdgtConsumedAnalysis BusinessArea Business Area
KEY Segment I_PubSecBdgtConsumedAnalysis Segment Segment number
KEY GLAccount I_PubSecBdgtConsumedAnalysis GLAccount General Ledger
KEY Supplier I_PubSecBdgtConsumedAnalysis Supplier Supplier
KEY Customer I_PubSecBdgtConsumedAnalysis Customer Sold-to Party
KEY AccountingDocumentType I_PubSecBdgtConsumedAnalysis AccountingDocumentType Journal Entry Type
KEY ProfitCenter I_PubSecBdgtConsumedAnalysis ProfitCenter Profit Center
KEY FunctionalArea I_PubSecBdgtConsumedAnalysis FunctionalArea Sendr Fctl Area
BdgtConsumedAmtInGlobalCrcy
BdgtConsumableAmtInGlobalCrcy
BdgtAvailableAmtInGlobalCrcy
HierarchyIDForFund I_PubSecBdgtConsumedAnalysis HierarchyIDForFund
HierarchyIDForFunctionalArea I_PubSecBdgtConsumedAnalysis HierarchyIDForFunctionalArea
HierarchyIDForBudgetPeriod I_PubSecBdgtConsumedAnalysis HierarchyIDForBudgetPeriod
HierarchyIDForCostCenter I_PubSecBdgtConsumedAnalysis HierarchyIDForCostCenter
HierarchyIDForWBSElement I_PubSecBdgtConsumedAnalysis HierarchyIDForWBSElement
HierarchyIDForBudgetAccount I_PubSecBdgtConsumedAnalysis HierarchyIDForBudgetAccount
GrantHierarchy I_PubSecBdgtConsumedAnalysis GrantHierarchy
SponsoredClassHierarchy I_PubSecBdgtConsumedAnalysis SponsoredClassHierarchy
Ledger Ledger
KEY CompanyCode I_PubSecBdgtConsumableAnalysis CompanyCode Receiver Company Code
KEY FinancialManagementArea I_PubSecBdgtConsumableAnalysis FinancialManagementArea FM Area
KEY ControllingArea I_PubSecBdgtConsumableAnalysis ControllingArea Controlling Area
KEY FiscalYear I_PubSecBdgtConsumableAnalysis FiscalYear G/L Fiscal Year
KEY CtrlObjForFund I_PubSecBdgtConsumableAnalysis CtrlObjForFund Control Object Fund
KEY CtrlObjForFunctionalArea I_PubSecBdgtConsumableAnalysis CtrlObjForFunctionalArea Control Object Functional Area
KEY CtrlObjForBudgetPeriod I_PubSecBdgtConsumableAnalysis CtrlObjForBudgetPeriod Control Object Budget Period
KEY CtrlObjForCostCenter I_PubSecBdgtConsumableAnalysis CtrlObjForCostCenter Control Object Cost Center
KEY CtrlObjForWBSElement I_PubSecBdgtConsumableAnalysis CtrlObjForWBSElement Control Object WBS Element
KEY CtrlObjForBudgetAccount I_PubSecBdgtConsumableAnalysis CtrlObjForBudgetAccount Control Object Budget Account
KEY CtrlObjForGrant I_PubSecBdgtConsumableAnalysis CtrlObjForGrant Control Object Grant
KEY CtrlObjForSponsoredClass I_PubSecBdgtConsumableAnalysis CtrlObjForSponsoredClass Control Object Sponsored Class
KEY CtrlObjForSponsoredProgram I_PubSecBdgtConsumableAnalysis CtrlObjForSponsoredProgram Control Object Sponsored Program
KEY CtrlObjForBdgtValidityNmbr I_PubSecBdgtConsumableAnalysis CtrlObjForBdgtValidityNmbr
KEY GlobalCurrency I_PubSecBdgtConsumableAnalysis GlobalCurrency GM Billing Element: Global Currency
KEY PubSecBudgetAccount I_PubSecBdgtConsumableAnalysis PubSecBudgetAccount Budget Account
KEY PubSecBdgtAcctRevnExpnCode I_PubSecBdgtConsumableAnalysis PubSecBdgtAcctRevnExpnCode Expense/Revenue
KEY AvailabilityControlProfile I_PubSecBdgtConsumableAnalysis AvailabilityControlProfile Budget Availability Control Profile
KEY Fund I_PubSecBdgtConsumableAnalysis Fund Sender Fund
KEY GrantID I_PubSecBdgtConsumableAnalysis GrantID Sender Grant
KEY SponsoredClass I_PubSecBdgtConsumableAnalysis SponsoredClass Sponsored Class
KEY SponsoredProgram I_PubSecBdgtConsumableAnalysis SponsoredProgram Sponsored Program
KEY GteeMBudgetValidityNumber I_PubSecBdgtConsumableAnalysis GteeMBudgetValidityNumber Bdgt Validty No.
KEY CostCenter I_PubSecBdgtConsumableAnalysis CostCenter Cost Center
KEY FinancialAccountType Fin. Account Type
KEY BusinessArea I_PubSecBdgtConsumableAnalysis BusinessArea Business Area
KEY Segment I_PubSecBdgtConsumableAnalysis Segment Segment number
KEY GLAccount I_PubSecBdgtConsumableAnalysis GLAccount General Ledger
KEY Supplier Supplier
KEY Customer I_PubSecBdgtConsumableAnalysis Customer Sold-to Party
KEY AccountingDocumentType Journal Entry Type
KEY ProfitCenter I_PubSecBdgtConsumableAnalysis ProfitCenter Profit Center
KEY FunctionalArea I_PubSecBdgtConsumableAnalysis FunctionalArea Sendr Fctl Area
BdgtConsumedAmtInGlobalCrcy
BdgtConsumableAmtInGlobalCrcy
BdgtAvailableAmtInGlobalCrcy
HierarchyIDForFund I_PubSecBdgtConsumableAnalysis HierarchyIDForFund
HierarchyIDForFunctionalArea I_PubSecBdgtConsumableAnalysis HierarchyIDForFunctionalArea
HierarchyIDForBudgetPeriod I_PubSecBdgtConsumableAnalysis HierarchyIDForBudgetPeriod
HierarchyIDForCostCenter I_PubSecBdgtConsumableAnalysis HierarchyIDForCostCenter
HierarchyIDForWBSElement I_PubSecBdgtConsumableAnalysis HierarchyIDForWBSElement
HierarchyIDForBudgetAccount I_PubSecBdgtConsumableAnalysis HierarchyIDForBudgetAccount
GrantHierarchy I_PubSecBdgtConsumableAnalysis GrantHierarchy
SponsoredClassHierarchy I_PubSecBdgtConsumableAnalysis SponsoredClassHierarchy
SponsoredProgramHierarchy I_PubSecBdgtConsumableAnalysis SponsoredProgramHierarchy

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_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: PPSBDGTCNSMPN

CREATE VIEW P_PubSecBdgtCnsmpnAnalysis AS
SELECT
  _A.Ledger AS Ledger,
  _A.CompanyCode AS CompanyCode,
  _A.FinancialManagementArea AS FinancialManagementArea,
  _A.ControllingArea AS ControllingArea,
  _A.FiscalYear AS FiscalYear,
  _A.CtrlObjForFund AS CtrlObjForFund,
  _A.CtrlObjForFunctionalArea AS CtrlObjForFunctionalArea,
  _A.CtrlObjForBudgetPeriod AS CtrlObjForBudgetPeriod,
  _A.CtrlObjForCostCenter AS CtrlObjForCostCenter,
  _A.CtrlObjForWBSElement AS CtrlObjForWBSElement,
  _A.CtrlObjForBudgetAccount AS CtrlObjForBudgetAccount,
  _A.CtrlObjForGrant AS CtrlObjForGrant,
  _A.CtrlObjForSponsoredClass AS CtrlObjForSponsoredClass,
  _A.CtrlObjForSponsoredProgram AS CtrlObjForSponsoredProgram,
  _A.CtrlObjForBdgtValidityNmbr AS CtrlObjForBdgtValidityNmbr,
  _A.GlobalCurrency AS GlobalCurrency,
  _A.PubSecBudgetAccount AS PubSecBudgetAccount,
  _A.PubSecBdgtAcctRevnExpnCode AS PubSecBdgtAcctRevnExpnCode,
  _A.AvailabilityControlProfile AS AvailabilityControlProfile,
  _A.Fund AS Fund,
  _A.GrantID AS GrantID,
  _A.SponsoredClass AS SponsoredClass,
  _A.SponsoredProgram AS SponsoredProgram,
  _A.GteeMBudgetValidityNumber AS GteeMBudgetValidityNumber,
  _A.CostCenter AS CostCenter,
  _A.FinancialAccountType AS FinancialAccountType,
  _A.BusinessArea AS BusinessArea,
  _A.Segment AS Segment,
  _A.GLAccount AS GLAccount,
  _A.Supplier AS Supplier,
  _A.Customer AS Customer,
  _A.AccountingDocumentType AS AccountingDocumentType,
  _A.ProfitCenter AS ProfitCenter,
  _A.FunctionalArea AS FunctionalArea,
  cast( _A.AmountInGlobalCurrency as psm_amt_cpost_grp_curr ) AS BdgtConsumedAmtInGlobalCrcy,
  cast( '0' as psm_amt_revn_cbdgt_grp_curr ) AS BdgtConsumableAmtInGlobalCrcy,
  cast( 0 - _A.AmountInGlobalCurrency as psm_amt_avail_grp_curr ) AS BdgtAvailableAmtInGlobalCrcy,
  _A.HierarchyIDForFund AS HierarchyIDForFund,
  _A.HierarchyIDForFunctionalArea AS HierarchyIDForFunctionalArea,
  _A.HierarchyIDForBudgetPeriod AS HierarchyIDForBudgetPeriod,
  _A.HierarchyIDForCostCenter AS HierarchyIDForCostCenter,
  _A.HierarchyIDForWBSElement AS HierarchyIDForWBSElement,
  _A.HierarchyIDForBudgetAccount AS HierarchyIDForBudgetAccount,
  _A.GrantHierarchy AS GrantHierarchy,
  _A.SponsoredClassHierarchy AS SponsoredClassHierarchy,
  _P.SponsoredProgramHierarchy AS SponsoredProgramHierarchy
FROM I_PubSecBdgtConsumedAnalysis AS _A
-- UNION with additional select branch(es): I_PubSecBdgtConsumableAnalysis
;

Learn More