Use

Using this function, you can retract or transfer planning data that was created or maintained using, for example, the SAP BW-BPS (Business Planning and Simulation) functionality in the Business Information Warehouse System (SAP BW) to the Budget Control System.

Integration

If no derivation is necessary to determine the FM account assignment elements that should contain budget, the account assignments from the field assignment for an SAP BW Query to the Funds Management fields defined in Customizing are determined during the transfer of planning data.

If a derivation strategy is necessary to determine the budget structure elements, for example, during the mapping of user-specific fields to SAP system fields, you have the following two options for deriving FM account assignment data:

Derivation of commitment/actual data

You define the derivation of commitment/actual data in the Customizing of Funds Management in the IMG activity ( Master Data → Allocations to Account Assignments → Define Account Assignment Derivation

The derivation strategy defined is used for account assignment derivation in Funds Management for the update of commitment/actual data. The derivation strategy cannot be changed for the planning data transfer.

Derivation of budget planning data

You create a derivation strategy for budgetplanning in the SAP main menu under Public Sector Management → Funds Management → Budget Control System → Tools → Plan Data Transfer from SAP BW → Derivation Strategy → Create .

You can define various derivation strategies, depending on the purpose, and then select the derivation strategy to be used during the transfer of planning data from BW.

For more information on creating derivation strategies, see the documentation on the IMG activity Define Account Assignment Derivation

Prerequisites

The BW system you are using must have release status 2.0A or above.

The following IMG activity must have been carried out in the Customizing of Funds Management:

Define Field Assignments ( Budget Control System → BCS Budgeting → Budget Entry → Transfer of Plan Data to BCS → Define Field Assignments for Plan Data Transfer from SAP BW )

Features

You must define query variants if you want to carry out a background transfer queries containing variables from the BW system to Funds Management. In a query variant, you define the values that are to fill the variables, and then enter the variant in the plan data transfer screen.

Activities

In order to transfer your planning data from SAP BW, proceed as follows:

In the SAP main menu, select Accounting → Public Sector Management → Funds Management → Budgeting → Budget Control System (BCS) → Tools → Planning → Plan Data Transfer from SAP BW → Transfer Plan Data

In the box called Source , enter the BW system and the query name, which must start with “I_XXXX/YYY”. Here, “XXXX” is the name of the InfoCube and “YYY” is the technical name of your query defined in SAP BW). Enter the query variant if necessary.

In the box called Target , enter the target transfer data (FM area, budget category, target version and budget type).

Run the program. The output is in SAP List Viewer format and contains the results of the program run.

Example

You can use this type of derivation, for example, if the FM account assignments are determined from the CO account assignments and if you have decided on planning for CO objects (cost center, orders and projects).