Ansicht
Dokumentation

_ISPSFM_VC_TBPBWRET - Define Field Assignments

In this step you define which SAP-BW_Query fields are set in which Fund Management fields during the planned data transfer from the BW system. This reduces the amount of time spent on maintenance if the account assignments for each query of a BW system are the same. If an assignment was defined for a field at system and query level, the detailed assignment at query level applies. Note that key figures must always be assigned at query level.

There are two options for account assignment derivation that can be used for implementing additional functions, for example, for mapping customer-defined fields to SAP fields or post-processing query data:

• Derivation of Commitment/Actual Values
  
  You define derivation commitment/actual values in the Customizing of
  Funds Management Public Sector in the IMG activity "Define Account Assignment Derivation"
  
  Note: The derivation strategy defined there is used for account assignment derivation in Funds Management within the commitment/actual update. The derivation strategy cannot be changed for the planned data transfer.
  
  You can use this type of derivation for example, if the FM account assignments are determined from CO account assignments and you have carried out CO object planning (cost centers, orders and projects).

• Derivation of Budget Planning Values
  
  You define the derivation of budget planning values in the budgeting menu of Funds Management Public Sector. With this type of derivation you can define several derivation strategies. You can choose which derivation strategy should be used when the planned data transfer is executed.
  
  You can use this type of derivation, for example, if you want to test different scenarios for the derivation. You must use this derivation if you have to change the derivation of commitment/actual values.

If you want to use customer-defined fields, you must add them to this include CI_SBPBWRET.

If you are using derivation of commitment/actuals , you must also add the fields to the data base structure FMDERIVE in include CI_FMDERIVE under the same name.

You can find more information on which fields must be filled in Funds Management and which fixed values are valid in the documentation on the function module "Direct Input from Budget: Entry". Note, however, that the budget values cannot be transferred as pre-posted budget.

The fields value type (WRTTP) and budget type (VORGA) have a special feature.

• Value Type (WRTTP)
  
  Field WRTTP in Funds Management is determined from the characteristic of BW system Value Type in Funds Management (0FM_VTYPE) and Budget Category in Funds Management (0FM_BUCAT). You must fill the following fields in the field assignment so that the field WRTTP can be filled during the planned data transfer: Value Type from BW (FMBP_BW_VALTYPE) and Budget Category from BW(FMBP_BW_BUDCAT)

• Budget Type (VORGA)
  
  Field VORGA in Funds Management is determined from the characteristic of the BW system Detail of Budget in Funds Management (0FM_BUDDETL). You must make an entry in the field Detail of Budget in BW (FMBP_BW_BUDDETAIL) during field assignment, so that the field VORGA can be filled during the plan data transfer.

You can find further information on which fixed values must be defined in the fields to depict the value type and the budget type under Further Notes.

• The query must be RFC capable and the indicator Release for OLE DB for OLAP must be set.

• The query can contain a maximum of one structure.

1. Select the BW system from the existing RFC system from which the data should be transferred. Note that a dialog user must be used for the RFC connection.
2. Select the query from which data should be transferred.
3. You can assign the BW objects to the fields in Funds Management in the detail screen.
   BW objects are:

• all info objects of the query

• formulas defined in the query

• all attributes of the info objects

• info objects that define a restriction to a key figure, the restriction
  must be an single value.
  

Filter values defined in the query are not included. It is not possible to assign these values.

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

1. If a value cannot or should not be transferred from the BW system, you can specify a fixed value for a FM field. This may be necessary, for example for the field FM area if it does not exist in the query and cannot be determined by derivation.
2. If you use the option of defining a field assignment for the whole BW system, all BW system info objects and all fields of the structure SBPBWRET are available. An assignment here would be overridden by an assignment of the corresponding info object at query level.

Further notes