I_CostCenterBudget

DDL: I_COSTCENTERBUDGET SQL: ICSTCNTRBDGT Type: view COMPOSITE

Cost Center Budget Report

I_CostCenterBudget (Composite)

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

Accounting and Financial Close

I_CostCenterBudget is a Composite CDS View that provides data about "Cost Center Budget Report" in SAP S/4HANA. It reads from 1 data source (P_CostCenterBudget) and exposes 80 fields. It has 2 associations to related views.

SAP Help Documentation

CategoryCDS Views for Overhead Cost Controlling
Purpose
You can use this CDS view to display information about budget, actual costs, commitments, and available budget for your budget-carrying cost centers. This CDS view provides the data to answer the following business questions: How much of the available cost center budget has been consumed? Which cost centers are over budget? What are the expected costs in comparison to the actual costs? What are the planned costs in comparison to actual costs and commitments?

Prerequisites
Authorizations: To use this CDS view, you must have the following authorization objects assigned: Field Name Description F_ACDOCA_C FIN Authorization Context for DCLs F_BKPF_BED Accounting Document: Account Authorization for Customers F_BKPF_BEK Accounting Document: Account Authorization for Vendors F_BKPF_BES Accounting Document: Account Authorization for G/L Accounts F_BKPF_BLA Accounting Document: Authorization for Document Types F_BKPF_BUK Accounting Document: Authorization for Company Codes F_BKPF_GSB Accounting Document: Authorization for Business Areas F_BKPF_KOA Accounting Document: Authorization for Account Types F_CC_HIER Authorization Object for Company Code Hierarchies F_FAGL_LDR General Ledger: Authorization for Ledger F_FAGL_SEG General Ledger: Authorization for Segment F_SKA1_BUK G/L Account: Authorization for Company Codes F_SKA1_KTP G/L Account: Authorization for Charts of Accounts F_UNI_HIER Universal Hierarchy Access K_ACDOCP_P Financials planning via table ACDOCP K_CCA_HIER CO-CCA: Authorization Object for Cost Center Hierarchies K_CSKS CO-CCA: Cost Center Master K_ORDER CO-OPA: General authorization object for internal orders K_PCA_HIER EC-PCA: Authorization Object for Profit Center Hierarchies K_PCAR_REP EC-PCA: Summary and Line Item Reports K_REPO_CCA CO-CCA: Reporting on Cost Centers/Cost Elements Configuration Budget availability control helps you avoid budget exceedances for cost centers and the Cost Center Budget Report app provides you with information about budget, actual costs, commitments, and available budget for your budget-carrying cost centers. To use budget availability control for your cost centers, you must maintain data in several configuration steps. For more information, refer to Configuration Activities or budget availability control in cost centers.

Structure
Parameters The parameters of the CDS view are as follows: P_InputPlanningCategory includes the plan data category for the comparison of plan, actuals, commitments, and budget. Fields used for filtering The main filters are as follows: Plan Category Fiscal Year Budget-Carrying Cost Center G/L Account Group Company Code Controlling Area Further important fields Important fields in this view include the following: Field Name Description BudgetCarryingCostCenter Budget-Carrying Cost Center GLAccountHierNodeSemanticKey G/L Account Group PlanAmountInCompanyCodeCrcy Plan Costs in Company Code Currency BudgetAmountInCompanyCodeCrcy Budget in Company Code Currency CmtmtCostInCCCrcy Commitments in Company Code Currency ActualCostAmtInCCCrcy Actual Costs in Company Code Currency TotAssgdAmtInCoCodeCurrency Assigned Value (Actual + Commitments) in Company Code Currency AvailableBdgtAmtInCoCodeCrcy Available Budget in Company Code Currency

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessAccounting and Financial Close
Application ComponentCO-OM-CCA-AVC
CapabilitiesData Source in SQL Select, Data Source for Defining CDS Entities
PackageAccounting and Financial Close for SAP S/4HANA Cloud Private Edition
Description <p>You can use this CDS view to display information about budget, actual costs, commitments, and available budget for your budget-carrying cost centers.</p> This CDS view provides the data to answer the following business questions:<ul> <li><p>How much of the available cost center budget has been consumed?</p></li> <li><p>Which cost centers are over budget?</p></li> <li><p>What are the expected costs in comparison to the actual costs?</p></li> <li><p>What are the planned costs in comparison to actual costs and commitments?</p></li> </ul>

Documentation

Data Sources (1)

SourceAliasJoin Type
P_CostCenterBudget P_CostCenterBudget from

Parameters (5)

NameTypeDefault
P_KeyDate vdm_v_key_date
P_BudgetPlanningCategory fcom_category
P_InputPlanningCategory fcom_category
P_LeadingLedger fins_ledger
P_Language spras

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_Currency _GlobalCurrency $projection.GlobalCurrency = _GlobalCurrency.Currency
[0..1] I_CostCenter _BudgetCarryingCostCenter $projection.ControllingArea = _BudgetCarryingCostCenter.ControllingArea and $projection.BudgetCarryingCostCenter = _BudgetCarryingCostCenter.CostCenter and _BudgetCarryingCostCenter.ValidityStartDate <= $session.system_date and _BudgetCarryingCostCenter.ValidityEndDate >= $session.system_date

Annotations (11)

NameValueLevelField
EndUserText.label Cost Center Budget Report view
AbapCatalog.sqlViewName ICSTCNTRBDGT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
Metadata.ignorePropagatedAnnotations true view

Fields (80)

KeyFieldSource TableSource FieldDescription
KeyDate KeyDate Maturity Key Date
ControllingArea ControllingArea Controlling Area
FiscalYear FiscalYear G/L Fiscal Year
FiscalPeriod FiscalPeriod Fiscal Period
BudgetCarryingCostCenter BudgetCarryingCostCenter Budget-Carrying Cost Center
GLAccountHierarchy GLAccountHierarchy Hierarchy ID
HierarchyNode HierarchyNode Hierarchy node
GLAccountHierNodeSemanticKey GLAccountHierNodeSemanticKey
CompanyCode CompanyCode Receiver Company Code
OrderID OrderID Order ID
AccountingDocumentType AccountingDocumentType Journal Entry Type
Customer Customer Customer Number
Segment Segment Segment for Segmental Reporting
BusinessArea BusinessArea Business Area
ProfitCenter ProfitCenter Profit Center
Supplier Supplier Supplier
SalesOrganization SalesOrganization Sales Organization
Plant Plant Valuation Area
ServiceDocumentType ServiceDocumentType Service Document Type
ValuationArea ValuationArea Valuation Area
SalesDocument SalesDocument Sales Document
CostCenter CostCenter Cost Center
GLAccount GLAccount General Ledger
Ledger Ledger Source Ledger
DistributionChannel DistributionChannel Distribution Channel
PlanningCategory PlanningCategory Plan Category
OrganizationDivision OrganizationDivision Org. Division
ServiceDocument ServiceDocument Service Document ID
FinancialAccountType FinancialAccountType Fin. Account Type
AssetClass AssetClass Asset Class
GlobalCurrency GlobalCurrency GM Billing Element: Global Currency
CompanyCodeCurrency CompanyCodeCurrency Company Code Currency
LedgerFiscalYear LedgerFiscalYear Fiscal Year of Ledger
FiscalYearVariant FiscalYearVariant Fiscal Year Variant
PredictionLedger PredictionLedger Ledger in General Ledger Accounting
PostingDate PostingDate Posting Date for GR
FunctionalArea FunctionalArea Sendr Fctl Area
BudgetCarryingCostCenterName BudgetCarryingCostCenterName Cost Center Name
CostCenterName CostCenterName Cost Center Name
GLAccountName GLAccountName G/L Account Name
HierarchyNodeText HierarchyNodeText Hierarchy node description
GLAccountHierarchyName GLAccountHierarchyName Hierarchy description
PlanningCategoryName PlanningCategoryName Planning Category
JointVenture JointVenture Joint venture
JointVentureName JointVentureName Joint Venture Name
JointVentureEquityGroup JointVentureEquityGroup Joint Venture Equity Group
JointVentureEquityGroupName JointVentureEquityGroupName Equity Group Description
JointVentureRecoveryCode JointVentureRecoveryCode Joint Venture Cost Recovery Code
JointVentureRecoveryCodeName JointVentureRecoveryCodeName Recovery Indicator Description
PlanAmountInCompanyCodeCrcy PlanAmountInCompanyCodeCrcy Amount in Global Currency
BudgetAmountInCompanyCodeCrcy BudgetAmountInCompanyCodeCrcy Amount in Global Currency
ActualCostAmtInCCCrcy ActualCostAmtInCCCrcy Amount in Company Code Currency
CmtmtCostInCCCrcy CmtmtCostInCCCrcy Amount in Global Currency
TotAssgdAmtInCoCodeCurrency TotAssgdAmtInCoCodeCurrency Amount in Company Code Currency
AvailableBdgtAmtInCoCodeCrcy AvailableBdgtAmtInCoCodeCrcy Local Crcy Amt
PlanAmountInGlobalCurrency PlanAmountInGlobalCurrency Amount in Global Currency
BudgetInGlobalCrcy BudgetInGlobalCrcy Amount in Global Currency
ActualCostInGlobalCrcy ActualCostInGlobalCrcy Amount in Global Currency
CmtmtCostInGlobalCurrency CmtmtCostInGlobalCurrency Amount in Global Currency
TotAssgdAmtInGlobalCurrency TotAssgdAmtInGlobalCurrency Amount in Global Currency
AvailableBudgetInGlobalCrcy AvailableBudgetInGlobalCrcy Amount in Global Currency
_ControllingArea _ControllingArea
_GlobalCurrency _GlobalCurrency
_FiscalYear _FiscalYear
_CompanyCode _CompanyCode
_FiscalPeriodForVariant _FiscalPeriodForVariant
_LedgerFiscalYearForVariant _LedgerFiscalYearForVariant
_FiscalYearVariant _FiscalYearVariant
_GLAccountHierarchyNode _GLAccountHierarchyNode
_BudgetCarryingCostCenter _BudgetCarryingCostCenter
_Ledger _Ledger
_Order _Order
_AccountingDocumentType _AccountingDocumentType
_Customer _Customer
_CurrentProfitCenter _CurrentProfitCenter
_CurrentCostCenter _CurrentCostCenter
_Supplier _Supplier
_GLAccountInCompanyCode _GLAccountInCompanyCode
_SalesDocument _SalesDocument
_ServiceDocument _ServiceDocument

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_CostCenterBudget.
-- 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: ICSTCNTRBDGT
-- Parameters: P_KeyDate : vdm_v_key_date, P_BudgetPlanningCategory : fcom_category, P_InputPlanningCategory : fcom_category, P_LeadingLedger : fins_ledger, P_Language : spras

CREATE VIEW I_CostCenterBudget AS
SELECT
  KeyDate,
  ControllingArea,
  FiscalYear,
  FiscalPeriod,
  BudgetCarryingCostCenter,
  GLAccountHierarchy,
  HierarchyNode,
  GLAccountHierNodeSemanticKey,
  CompanyCode,
  OrderID,
  AccountingDocumentType,
  Customer,
  Segment,
  BusinessArea,
  ProfitCenter,
  Supplier,
  SalesOrganization,
  Plant,
  ServiceDocumentType,
  ValuationArea,
  SalesDocument,
  CostCenter,
  GLAccount,
  Ledger,
  DistributionChannel,
  PlanningCategory,
  OrganizationDivision,
  ServiceDocument,
  FinancialAccountType,
  AssetClass,
  GlobalCurrency,
  CompanyCodeCurrency,
  LedgerFiscalYear,
  FiscalYearVariant,
  PredictionLedger,
  PostingDate,
  FunctionalArea,
  BudgetCarryingCostCenterName,
  CostCenterName,
  GLAccountName,
  HierarchyNodeText,
  GLAccountHierarchyName,
  PlanningCategoryName,
  JointVenture,
  JointVentureName,
  JointVentureEquityGroup,
  JointVentureEquityGroupName,
  JointVentureRecoveryCode,
  JointVentureRecoveryCodeName,
  PlanAmountInCompanyCodeCrcy,
  BudgetAmountInCompanyCodeCrcy,
  ActualCostAmtInCCCrcy,
  CmtmtCostInCCCrcy,
  TotAssgdAmtInCoCodeCurrency,
  AvailableBdgtAmtInCoCodeCrcy,
  PlanAmountInGlobalCurrency,
  BudgetInGlobalCrcy,
  ActualCostInGlobalCrcy,
  CmtmtCostInGlobalCurrency,
  TotAssgdAmtInGlobalCurrency,
  AvailableBudgetInGlobalCrcy
FROM P_CostCenterBudget
LEFT OUTER JOIN I_Currency AS _GlobalCurrency ON GlobalCurrency = _GlobalCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_CostCenter AS _BudgetCarryingCostCenter ON ControllingArea = _BudgetCarryingCostCenter.ControllingArea AND BudgetCarryingCostCenter = _BudgetCarryingCostCenter.CostCenter AND _BudgetCarryingCostCenter.ValidityStartDate <= $session.system_date AND _BudgetCarryingCostCenter.ValidityEndDate >= $session.system_date  -- association [0..1]
;