I_PubSecBdgtCnsmpnAvailyC

DDL: I_PUBSECBDGTCNSMPNAVAILYC SQL: IPSBDGTCNSMPNAV Type: view COMPOSITE Package: ODATA_PSM_S4C_FM_REPORTING
61 Fields 2 Data Sources

Budget consumption kpi tile - Cube

I_PubSecBdgtCnsmpnAvailyC is a Composite CDS View (Cube) that provides data about "Budget consumption kpi tile - Cube" in SAP S/4HANA. It reads from 2 data sources (I_FiscalYear, I_PubSecBdgtActlItemBasic) and exposes 61 fields with key fields SourceLedger, Ledger, CompanyCode, FiscalYear, AccountingDocument. Part of development package ODATA_PSM_S4C_FM_REPORTING.

Data Sources (2)

SourceAliasJoin Type
I_FiscalYear _FiscalYear inner
I_PubSecBdgtActlItemBasic AcItem from

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName IPSBDGTCNSMPNAV view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
AbapCatalog.buffering.status #NOT_ALLOWED view
EndUserText.label Budget consumption kpi tile - Cube view
VDM.viewType #COMPOSITE view
Analytics.dataCategory #CUBE view
Analytics.internalName #LOCAL view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view

Fields (61)

KeyFieldSource TableSource FieldDescription
KEY SourceLedger I_PubSecBdgtActlItemBasic SourceLedger Source Ledger
KEY Ledger I_PubSecBdgtActlItemBasic Ledger Ledger
KEY CompanyCode I_PubSecBdgtActlItemBasic CompanyCode Receiver Company Code
KEY FiscalYear I_PubSecBdgtActlItemBasic FiscalYear G/L Fiscal Year
KEY AccountingDocument I_PubSecBdgtActlItemBasic AccountingDocument Journal Entry
KEY FinancialPlanningReqTransSqnc I_PubSecBdgtActlItemBasic FinancialPlanningReqTransSqnc Request TSN
KEY FinancialPlanningDataPacket I_PubSecBdgtActlItemBasic FinancialPlanningDataPacket Data packet number
KEY ActualPlanJournalEntryItem I_PubSecBdgtActlItemBasic ActualPlanJournalEntryItem
ControllingArea I_PubSecBdgtActlItemBasic ControllingArea Controlling Area
ProfitCenter I_PubSecBdgtActlItemBasic ProfitCenter Profit Center
AccountingDocumentType I_PubSecBdgtActlItemBasic AccountingDocumentType Journal Entry Type
CompanyCodeCurrency I_PubSecBdgtActlItemBasic CompanyCodeCurrency Local Currency
GlobalCurrency I_PubSecBdgtActlItemBasic GlobalCurrency GM Billing Element: Global Currency
Segment I_PubSecBdgtActlItemBasic Segment Segment number
BusinessArea I_PubSecBdgtActlItemBasic BusinessArea Business Area
GLAccount I_PubSecBdgtActlItemBasic GLAccount General Ledger
SalesOrganization I_PubSecBdgtActlItemBasic SalesOrganization Sales Organization
CostCenter I_PubSecBdgtActlItemBasic CostCenter Cost Center
FiscalYearVariant I_PubSecBdgtActlItemBasic FiscalYearVariant FY Variant
ActualPlanCode I_PubSecBdgtActlItemBasic ActualPlanCode
Customer I_PubSecBdgtActlItemBasic Customer Sold-to Party
Supplier I_PubSecBdgtActlItemBasic Supplier Supplier
ServiceDocument I_PubSecBdgtActlItemBasic ServiceDocument Transaction ID
OrganizationDivision I_PubSecBdgtActlItemBasic OrganizationDivision Org. Division
DistributionChannel I_PubSecBdgtActlItemBasic DistributionChannel RefDistCh-Cust/Mat.
AssetClass I_PubSecBdgtActlItemBasic AssetClass Asset Class
ServiceDocumentType I_PubSecBdgtActlItemBasic ServiceDocumentType Transaction Type
PlanningCategory I_PubSecBdgtActlItemBasic PlanningCategory Plan Category
ValuationArea I_PubSecBdgtActlItemBasic ValuationArea Valuation Area
Plant I_PubSecBdgtActlItemBasic Plant Valuation Area
SalesDocument I_PubSecBdgtActlItemBasic SalesDocument SD Document
OrderID I_PubSecBdgtActlItemBasic OrderID Order ID
FinancialAccountType I_PubSecBdgtActlItemBasic FinancialAccountType Fin. Account Type
PostingDate I_PubSecBdgtActlItemBasic PostingDate Posting Date for GR
GrantID I_PubSecBdgtActlItemBasic GrantID Sender Grant
Fund I_PubSecBdgtActlItemBasic Fund Sender Fund
FinancialManagementArea I_PubSecBdgtActlItemBasic FinancialManagementArea FM Area
FunctionalArea I_PubSecBdgtActlItemBasic FunctionalArea Sendr Fctl Area
OrderCategory
GranteeMgmtSponsor
_Ledger I_PubSecBdgtActlItemBasic _Ledger
_FiscalYear I_PubSecBdgtActlItemBasic _FiscalYear
_JournalEntry I_PubSecBdgtActlItemBasic _JournalEntry
_Customer I_PubSecBdgtActlItemBasic _Customer
_Supplier I_PubSecBdgtActlItemBasic _Supplier
_GLAccountInCompanyCode I_PubSecBdgtActlItemBasic _GLAccountInCompanyCode
_ServiceDocument I_PubSecBdgtActlItemBasic _ServiceDocument
_Order I_PubSecBdgtActlItemBasic _Order
_ServiceDocumentType I_PubSecBdgtActlItemBasic _ServiceDocumentType
_SalesDocument I_PubSecBdgtActlItemBasic _SalesDocument
_Grant I_PubSecBdgtActlItemBasic _Grant
_Fund I_PubSecBdgtActlItemBasic _Fund
_AccountingDocumentType I_PubSecBdgtActlItemBasic _AccountingDocumentType
_CompanyCodeCurrency I_PubSecBdgtActlItemBasic _CompanyCodeCurrency
_CompanyCode I_PubSecBdgtActlItemBasic _CompanyCode
_GlobalCurrency I_PubSecBdgtActlItemBasic _GlobalCurrency
_CurrentProfitCenter I_PubSecBdgtActlItemBasic _CurrentProfitCenter
_CurrentCostCenter I_PubSecBdgtActlItemBasic _CurrentCostCenter
_Sponsor
FiscalYearEndDate I_FiscalYear FiscalYearEndDate
FiscalYearStartDate I_FiscalYear FiscalYearStartDate

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 I_PubSecBdgtCnsmpnAvailyC.
-- 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: IPSBDGTCNSMPNAV

CREATE VIEW I_PubSecBdgtCnsmpnAvailyC AS
SELECT
  AcItem.SourceLedger AS SourceLedger,
  AcItem.Ledger AS Ledger,
  AcItem.CompanyCode AS CompanyCode,
  AcItem.FiscalYear AS FiscalYear,
  AcItem.AccountingDocument AS AccountingDocument,
  AcItem.FinancialPlanningReqTransSqnc AS FinancialPlanningReqTransSqnc,
  AcItem.FinancialPlanningDataPacket AS FinancialPlanningDataPacket,
  AcItem.ActualPlanJournalEntryItem AS ActualPlanJournalEntryItem,
  AcItem.ControllingArea AS ControllingArea,
  AcItem.ProfitCenter AS ProfitCenter,
  AcItem.AccountingDocumentType AS AccountingDocumentType,
  AcItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  AcItem.GlobalCurrency AS GlobalCurrency,
  AcItem.Segment AS Segment,
  AcItem.BusinessArea AS BusinessArea,
  AcItem.GLAccount AS GLAccount,
  AcItem.SalesOrganization AS SalesOrganization,
  AcItem.CostCenter AS CostCenter,
  AcItem.FiscalYearVariant AS FiscalYearVariant,
  AcItem.ActualPlanCode AS ActualPlanCode,
  AcItem.Customer AS Customer,
  AcItem.Supplier AS Supplier,
  AcItem.ServiceDocument AS ServiceDocument,
  AcItem.OrganizationDivision AS OrganizationDivision,
  AcItem.DistributionChannel AS DistributionChannel,
  AcItem.AssetClass AS AssetClass,
  AcItem.ServiceDocumentType AS ServiceDocumentType,
  AcItem.PlanningCategory AS PlanningCategory,
  AcItem.ValuationArea AS ValuationArea,
  AcItem.Plant AS Plant,
  AcItem.SalesDocument AS SalesDocument,
  AcItem.OrderID AS OrderID,
  AcItem.FinancialAccountType AS FinancialAccountType,
  AcItem.PostingDate AS PostingDate,
  AcItem.GrantID AS GrantID,
  AcItem.Fund AS Fund,
  AcItem.FinancialManagementArea AS FinancialManagementArea,
  AcItem.FunctionalArea AS FunctionalArea,
  AcItem._Order.OrderCategory AS OrderCategory,
  AcItem._Grant.GranteeMgmtSponsor AS GranteeMgmtSponsor,
  AcItem._Ledger AS _Ledger,
  AcItem._FiscalYear AS _FiscalYear,
  AcItem._JournalEntry AS _JournalEntry,
  AcItem._Customer AS _Customer,
  AcItem._Supplier AS _Supplier,
  AcItem._GLAccountInCompanyCode AS _GLAccountInCompanyCode,
  AcItem._ServiceDocument AS _ServiceDocument,
  AcItem._Order AS _Order,
  AcItem._ServiceDocumentType AS _ServiceDocumentType,
  AcItem._SalesDocument AS _SalesDocument,
  AcItem._Grant AS _Grant,
  AcItem._Fund AS _Fund,
  AcItem._AccountingDocumentType AS _AccountingDocumentType,
  AcItem._CompanyCodeCurrency AS _CompanyCodeCurrency,
  AcItem._CompanyCode AS _CompanyCode,
  AcItem._GlobalCurrency AS _GlobalCurrency,
  AcItem._CurrentProfitCenter AS _CurrentProfitCenter,
  AcItem._CurrentCostCenter AS _CurrentCostCenter,
  AcItem._Grant._Sponsor AS _Sponsor,
  _FiscalYear.FiscalYearEndDate AS FiscalYearEndDate,
  _FiscalYear.FiscalYearStartDate AS FiscalYearStartDate
FROM I_PubSecBdgtActlItemBasic AS AcItem
INNER JOIN I_FiscalYear AS _FiscalYear ON /* join condition not captured in parsed metadata */
;

Learn More