Investigating Budget Preparation

Let's continue with Sarah and Daniel as they discuss budget preparation and budget entries! Select the following video!

A traditional increment-based budget is prepared for the upcoming cycles based on the previous year's budget and also actuals and commitments.

The high-level procedures are outlined here:

• Import Master data using APIs
• Import budget and also actuals and commitment using APIs
• Prepare budget 
• Export budget using APIs

The following figure provides an overview of how to do the following:

• The master data, budget, and actuals and commitment are transferred between SAP Analytics Cloud and SAP S/4HANA Cloud
• The budget is prepared in SAP Analytics Cloud

This figure provides you with information about data connectivity using a communication scenario:

The SAP_COM_0761 communication scenario offers the integration of Public Sector Management (PSM) on SAP SAP S/4HANA Cloud as a data provider with SAP Analytics Cloud (SAC).

This scenario offers OData services for the following:

• Fund and hierarchy
• Grant and hierarchy
• Budget period and hierarchy
• Actuals and Commitment

The scope item 6UC, Government Budget Planning  is a prerequisite for this communication scenario.

 The connectivity between SAP S/4HANA Cloud and SAP Analytics Cloud is based on the SAP S/4HANA import connection.

This figure, Data model, shows the following:

• The SAP_PSM_BP_IM_OPERATIONALEXPENSEPLANNING template model is delivered with the SAP Content library package - Public Sector Management Planning.
• Import has to be performed for the following public dimensions (for master data, including hierarchies that are part of the SAP_PSM_BP_IM_OPERATIONALEXPENSEPLANNING model):
  • SAP_ALL_FUND
  • SAP_ALL_COSTCENTER
  • SAP_ALL_BUSGETPERIOD
  • SAP_ALL_FUNCTIONALAREA
  • SAP_ALL_BUDGETACCOUNT
  • SAP_ALL_PROFITCENTER
  • SAP_ALL_COMPANYCODE

The data sources show transactional data -  budget and also actuals and commitment for this model.

Import jobs in SAP Analytics Cloud can be used to call the OData services for importing the data. The import jobs can also be scheduled.

The figure, Import Jobs - Fund Dimension, shows the standard import jobs delivered for one of public dimensions - Fund.

Details about the import job are as follows:

• Name of the import job: Fund
• Technical name of the query: FundQuery

The figure, Import Jobs - Budget, Actuals, and Commitment, shows the following:

• The standard import job delivered for importing actuals and commitment is Import Actual and the API is API_PUBSECCMTMTACTLITEM.
• The standard import job delivered for importing budget is Import Budget and the API is A_FINPLANNINGENTRYITEM.

The following figure shows the SAP_PSM_BP_PLANNING_HOME template story, which is delivered with the SAP Content library package - Public Sector Management Planning, to access all the public sector planning modules.

The following public sector planning templates are offered with the standard content, which can be then adapted and enriched by the end users.

Operational Expense Planning

Operational Expense Planning allows you to analyze OPEX expenses based on actual or budget data from previous years. You can then plan the expense based on the actual or budget data for public sector account assignments. You can further analyze the comparison on budget, plan, and forecast details and also create sample data for Actuals and Budget.

Operational Revenue Planning

Operational Revenue Planning allows you to analyze revenue details based on the data from the previous years. You can then plan the revenue for the upcoming cycles. You can further analyze the comparison on budget, plan, and forecast details and also create sample data for Actuals and Budget.

Project Planning

Project Planning allows you to analyze projects that were planned, budgeted, and executed in the previous years. You can then plan the budget for the projects for the upcoming cycles. You can further analyze the comparison on budget, plan, and forecast details and also create sample data for Actuals and Budget.

Workforce Planning

Workforce Planning allows you to perform operational head count and FTE planning.

The figure, Budget Planning Form, shows you the SAP_PSM_BP_OPERATIONAL_EXPENSE_PLANNING template story, which is delivered with the SAP Content library package - Public Sector Management Planning, to perform planning.

Key features in the form are as follows:

• Budget - An estimate of how much money you can spend which is a legally endorsed intended expenditure.
• Actual - The budget amount that has already been consumed.
• Plan - An estimate of how much money you will spend.
• Forecast - The budget amount that has been forecasted.
• Copy action - The data action is used to copy data from Budget, Actuals, or Forecast.
• Execute Forecast - The data action is used to initiate and update forecast details.

The budget data can be exported to the ACDOCP table in SAP S/4HANA using the API_FINANCIALPLANDATA_SRV OData service by configuring an export job in SAP Analytics Cloud.

You should now be able to prepare a budget in SAP Analytics Cloud and integrate it with SAP S/4HANA Cloud, Public Edition for Public Sector Budget Management.

The key takeaways are as follows:

• Budget, and also actuals and commitment, can be imported from SAP S/4HANA Cloud, Public Edition for Public Sector to SAP Analytics Cloud, using a communication scenario and the import jobs feature.
• The new budget can be prepared in SAP Analytics Cloud and also exported back to SAP S/4HANA Cloud, Public Edition for Public Sector.
• It is possible to import the Public Sector Budget data from SAP S/4HANA Cloud, Public Edition for Public Sector to SAP Analytics Cloud using the SAP_COM_0761 communication scenario.