This document will explain how a key figure InfoObject which is a attribute of Master data can be used independently (As Navigational attributes) to perform calculation in BEx Query with the help of formula and replacement path variable.
Key Figures InfoObject which is a attribute of Master data InfoObject cannot be turned into Navigational attribute. What if there is a requirement to perform some calculation on Keyfigure InfoObject which is a attribute of master data and cannot be dragged into column section of Bex Query . This can be possible with the help of formula variable and replacement path type.
Note : Navigational attribute functional is associated with characteristic InfoObject and not with Keyfigure InfoObject
0PM_ORDER is a master data InfoObject and Maintenance Plan Cycle in days is key Figure attribute of 0PM_ORDER.
0PM_ORDER InfoObject is part of Multiprovider ZPM_MC11 (PM-4: Inspection Lot and Usage Decision)
The requirement is to show double of Maintenance Plan Cycle in column section and Maintenance Plan Cycle is not part of multiprovider.


Note: Maintenance Plan cycle in days is not present in Key Figures section of Multiprovider
To create a query on ZPM_MC11 open BEx Query Designer and click the created button. Select the Multiprovider ZPM_MC11 on which query is to be built.



Logic : Formula is created to include the Maintenance Plan cycle and then perfrom calculation on it

Logic : Formula variable is to be created on 0PM_ORDER and the processing type is Replacement Path. In our scenario 0PM_ORDER is to be replaced by its attribute which is Maintenance Plan cycle.






Click ok; the formula will appear in column.

Save the query and execute the see the result. As shown in below screen shot Maint Plan Cycle is 30 Days and Double of Maintenance Plan Cycle is 60 Days which

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
| User | Count |
|---|---|
| 3143 | |
| 1916 | |
| 1916 | |
| 1213 | |
| 1079 | |
| 757 | |
| 755 | |
| 742 |