Show TOC

  Plan Data Transfer from SAP BW Locate this document in the navigation structure

Use

Using this function, you can transfer plan data that was created or maintained using, for example, a SAP SEM system from a Business Information Warehouse System (BW system) to Funds Management.

Integration

If no derivation is necessary to determine the budget structure elements (BS elements) that should contain budget, the account assignments from the field assignment of fields of a SAP BW Query to Funds Management fields defined in Customizing are determined during plan data transfer.

If a derivation is necessary to determine the BS elements, for example in mapping of user-specific fields to SAP fields, you have the following two options for defining the account assignment derivation:

Derivation commitments/actual

You define the derivation commitment/actual in Customizing of Funds Management in the IMG activity Define Account Assignment Derivation .

This graphic is explained in the accompanying text.

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

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 to CO objects (cost center, orders and projects).

Derivation Budget Planning

You create derivation budget planning in the SAP menu under Public Sector Management ® Funds Management ® Budgeting ® Former Budgeting ® Tools ® Plan Data Transfer from SAP BW ® Derivation Strategy ® Create . With this type of derivation, you can define a number of derivation strategies. You can choose which derivation strategy should be used during the plan data transfer.

You can find more information on creating derivation strategies in the documentation on the IMG Define Account Assignment Derivation .

You can use this type of derivation, for example, if you want to test different derivation scenarios. You must use this derivation if you had to change the derivation commitment/actual for the data transfer.

Prerequisites

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

The following IMG activities must be carried out in Customizing of Funds Management.

Create Number Ranges for Plan Data Transfer from BW System

Define Field Assignment

Features

You can navigate to additional functions from the initial screen of plan data transfer:

Reversal

Using this function you can delete the Funds Management budget data (for a FM area, version and fiscal year) that was transferred from the BW system to Funds Management in the last plan data transfer.

Variants

You require query variants if you want to transfer queries which contain variables from the BW system to Funds Management in the background. In a query variant, you define which values are to fill the variables, and then enter the variant in the plan data transfer.

Logs

You can also call up these functions separately in the SAP menu - Public Sector Management ® Funds Management ® Budgeting ® Former Budgeting ® Tools ® Plan Data Transfer from SAP BW and then select the function you require.

Activities

To execute the plan data transfer, choose Public Sector Management ® Funds Management ® Budgeting ® Former Budgeting ® Tools ®   Plan Data Transfer from SAP BW ® Transfer Plan Data

See also:

For more information on executing this program, see the program documentation.

Plan Data Transfer from the BW System (BPREP_RETRAKTOR_OB)

Reversing the Plan Data Transfer from the BW System (BPREP_RETRAKTOR_REVERSE_OB)

Query Variant for Plan Data Transfer from the BW System (BPREP_CREATE_QUERY_VARNT)

Log of Plan Data Transfer from the BW System (BPREP_RETRAKTOR_SHOW_LOG)