I_CostCenterBudget
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
| Category | CDS 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
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
SAP API Hub
| State | C1 |
|---|---|
| Line of Business | Accounting and Financial Close |
| Application Component | CO-OM-CCA-AVC |
| Capabilities | Data Source in SQL Select, Data Source for Defining CDS Entities |
| Package | Accounting 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
- 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 |
|---|---|---|
| P_CostCenterBudget | P_CostCenterBudget | from |
Parameters (5)
| Name | Type | Default |
|---|---|---|
| P_KeyDate | vdm_v_key_date | |
| P_BudgetPlanningCategory | fcom_category | |
| P_InputPlanningCategory | fcom_category | |
| P_LeadingLedger | fins_ledger | |
| P_Language | spras |
Associations (2)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [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)
| Name | Value | Level | Field |
|---|---|---|---|
| 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)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| 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]
;
Learn More
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA