SAP ABAP IMG Activity _ISPSFM_VC_TBPBWRET (Define Field Assignments)
Hierarchy
☛ EA-PS (Software Component) SAP Enterprise Extension Public Services
   ⤷ PSM-FM-MD (Application Component) Master Data
     ⤷ FMCC (Package) FIFM: Cash budget management customizing
IMG Activity
ID _ISPSFM_VC_TBPBWRET Define Field Assignments  
Transaction Code S_ALN_01000033   (empty) 
Created on 20010911    
Customizing Attributes _ISPSFM_VC_TBPBWRET   Define Field Assignments 
Customizing Activity _ISPSFM_VC_TBPBWRET   Define Field Assignments 
Document
Document Class SIMG   Hypertext: Object Class - Class to which a document belongs.
Document Name _ISPSFM_VC_TBPBWRET    

Use

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.

Requirements

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

Activities

  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.

  4. 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.
  5. 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

Fixed values for depicting value type in the SAP system (WRTTP)

Budget category from BW    value type from BW    value type in SAP system

0    10    43 Payment Budget (PB)

0    30    46 Release PB

1    10    70 Commitment budget (CB)

1    30    72 Release CB

Fixed values for depicting the budget art in the SAP system (VORGA):

Detail BW    budget type in the SAP system.

010    Original budget (KBUD)

020    Supplement (KBN0)

030    Return (KBR0)

130    Release (KBFR)

Business Attributes
ASAP Roadmap ID 252   Prepare Data Transfer Fields 
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_VC_TBPBWRET 0 KI48000001 Basic Functions of 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 C - View cluster SM34  
History
Last changed by/on SAP  20020411 
SAP Release Created in 110