We are hiring and constantly growing! Have a look through our vacancies to find the right role for you!
If you manage budget categories on investment programs, then you also have to assign the actual values on subordinate measures of the investment program to budget categories, so that the program budget and program plan can be compared correctly in reporting.
In the standard system, the system separates these two categories:
The separation of the two categories is made using InfoObject 0BUD_CAT. In the standard system, this InfoObject contains the following constants from TYPE-POOL IMBW1 as default values:
If you want to define your own assignment of actual values to budget categories you have defined yourself, you have to make this assignment using SAP enhancement AIBW0001. This enhancement corresponds to SAP enhancement AAIP0001 for R/3 OLTP Reporting for Investment Management.
SAP enhancement AIBW0001 is called from the update rules of InfoCubes 0IMFA_1. It supplies all actual, commitment and down payment values (debits and credits resulting from settlement) of orders and projects to the investment program.
Proceed as follows:
The following parameters are available in program ZXAIBU01:
Assume that two budget categories are defined, in order to have separate budgets for internal and external activity:
Internal activity is recognized by cost element 0000412000.
The sample code in the enhancement component reflects this scenario.
Assume that a measure with the following values is assigned to the investment program:
0DB_CR_IND 0COSTELMNT 0AMOUNT
D 415000 400 Debit 1
D 412000 600 Debit 2
C 415000 100 Settlement to fixed asset
C 412000 200 Settlement to cost center
In the Customer Exit, programmed as specified, the result is the following assignments to budget category for the values (breakdown according to capital and expense is carried out automatically by the system):
0DB_CR_IND 0COSTELMNT 0AMOUNT 0CAP_EXP 0BUD_CAT
D 415000 400 # Internal activity
D 412000 600 # External activity
C 415000 100 Capital #
C 412000 200 Expense #.
The values are then updated as follows in the InfoCube:
0DB_CR_IND 0AMOUNT 0CAP_EXP 0BUD_CAT
D 400 # Internal activity
D 600 # External activity
D 100 - # #
D 200 - # #
C 100 Capital #
C 200 Expense #
The following breakdowns are then possible in the queries:
# 700 (= 400 + 600 - 100 - 200)
# 0 (= 100 + 200 - 100 - 200)