Ansicht
Dokumentation

_ISPSFM_TBPBWRET_BCS - Define Field Assignments for Plan Data Transfer from SAP BW

In this operation, you determine which fields in a SAP BW query are transferred to which fields in Funds Management when transferring plan data from the BW system. You can also set up a field assignment for all queries in the BW system. This reduces the maintenance load when the assignment is the same for all queries in the BW system. If a field assignment has been made at both system and query level, the more detailed assignment is made at query level. Note that key figures must always be assigned at query level.

The following account assignment derivation options are available in the SAP system to implement additional functions, for example, to map customer fields to SAP fields or to postprocess query data.

• Commitment/Actual Derivation

You determine commitment/actual derivation in Customizing for Funds Management Government, in the Customizing activity "Defining Account Assignment Derivation".

Caution: The derivation strategy you set here is for account assignment in Funds Management for commitment/actual update. You are not allowed to change the derivation strategy for the plan data transfer.

You can change this derivation type where, in the derivation strategy, the Funds Management account assignments are obtained from CO account assignments, and when you have performed planning for CO objects (cost centers, orders and projects).

• Budget Planning Derivation

You set budget planning derivation in the budget menu in the Funds Management Government. You can define several derivation strategies using this type of derivation. You can decide which derivation strategy to use when performing the plan data transfer.

This derivation type can be used when you want to test different derivation scenarios. You must use this derivation if you have to change the derivation of commitment/actual values.

If you want to use your own fields, add these in the CI_SBPBWRET include.

When using the commitment/actual derivation, you also need to add the fields, under the same name, to the CI_FMDERIVE include in the FMDERIVE database structure.

For more information about the fields that need to be filled in Funds Management and about valid fixed values, see the documentation for the "Creating a Budget Entry Document" function module.

• The query must be RFC-enabled; The Release for OLE DB for OLAP indicator must be set.

• The query must not contain more than one structure.

1. From the available RFC systems, select the BW system from which the data is to be transferred. Note that a dialog user must be used for the RFC connection.

Note

If you are using several BW systems, you must make these Customizing settings for each BW system with an RFC connection. If you are for example using one system for the implementation, one for quality control and one for operational purposes, you must make these settings three times.

1. Select a query from which the data is to be transferred.
2. On the detail screen, you can assign the BW objects to the fields in Funds Management.
   BW objects include:

• All query InfoObjects

• Formulas defined in the query

• All InfoObject attributes

• InfoObjects that define a restriction to a key figure.
  The prerequisite is that the restriction contains a single value.
  

Not included are filter values defined in the query. These values cannot be assigned.

All fields in the structure SBPBWRET and, if applicable, the customer-defined fields in the include CI_SBPBWRET_BCS are available in Funds Management.

1. If a value cannot or is not to be transferred from the BW system, you can specify a fixed value for the FM field. This may apply to the FM area field if this field does not exist in the query and cannot be obtained using a derivation.
2. When selecting the option of setting up a field assignment for the entire BW system, all BW system InfoObjects are made available as are all fields for the SBPBWRET_BCS structure. An assignment in this case is overridden by the assignment of the corresponding Info Objects at query level.

Note
Note that all the data required for posting in FM must be specified by a fixed value or a BW object.

Further notes