SAP ABAP IMG Activity _ISPSFM_TBPBWRET_BCS (Define Field Assignments for Plan Data Transfer from SAP BW)
Hierarchy
☛ EA-PS (Software Component) SAP Enterprise Extension Public Services
   ⤷ PSM-FM (Application Component) Funds Management
     ⤷ BPREP_BWRET (Package) Retraction: BW -> R/3
IMG Activity
ID _ISPSFM_TBPBWRET_BCS Define Field Assignments for Plan Data Transfer from SAP BW  
Transaction Code S_ALN_01000834   (empty) 
Created on 20020130    
Customizing Attributes _ISPSFM_TBPBWRET_BCS   Define Field Assignments for Plan Data Transfer from SAP BW 
Customizing Activity _ISPSFM_TBPBWRET_BCS   Define Field Assignments for Plan Data Transfer from SAP BW 
Document
Document Class SIMG   Hypertext: Object Class - Class to which a document belongs.
Document Name _ISPSFM_TBPBWRET_BCS    

Use

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 are also able to 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 on both a system and a query level, the more detailed assignment takes place on a query level. Note that key figures must always be assigned on the query level.

Two 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 IMG 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 carried out 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. For this derivation type, you can define several derivation strategies. You can decide which derivation strategy to use when carrying out the plan data transfer.

    This derivation type can be used when you want to test different derivation scenarios. You must use this derivation when having to change the commitment/actual derivation for the data transfer.

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.

You can find additional information about the fields that need to be filled in Funds Management and about valid fixed values in the documentation for the "Creating a Budget Entry Document"function module.

Requirements

  • 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.

Activities

  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.
  2. Select a query from which the data is to be transferred.
  3. In 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.

      In Funds Management, all fields for the structure SBPBWRET and, if applicable, for all customer fields, are available in the CI_SBPBWRET_BCS include.

  4. 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 when this field does not exist in the query and cannot be obtained via derivation.
  5. When selecting the option of setting up a field assignment for the whole 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 on the 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

Fixed values for the modeling of a budget category in the SAP system

Budget Cat.in the BW (0FM_BUCAT)    Budget Cat. in SAP (BUDCAT)

0 Payment Budget    9F Payment Budget

1 Commitment Budget    9G Commitment Budget

Business Attributes
ASAP Roadmap ID 105   Define functions and processes 
Mandatory / Optional 2   Optional activity 
Critical / Non-Critical 2   Non-critical 
Country-Dependency A   Valid for all countries 
Assigned Application Components
Documentation Object Class Documentation Object Name Current line number Application Component Application Component Name
SIMG _ISPSFM_TBPBWRET_BCS 0 ALN0000195 Budgeting 
Maintenance Objects
Maintenance object type C   Customizing Object 
Assigned objects
Customizing Object Object Type Transaction Code Sub-object Do not Summarize Skip Subset Dialog Box Description for multiple selections
VC_TBPBWRET_BCS C - View cluster SM34  
History
Last changed by/on SAP  20040311 
SAP Release Created in 110