on 08-28-2013 5:52 AM
Hi All,
Please suggest me how to handle following requirement,
I have a key figure infoobject of type amount and other key figure of type quantity .I want to upload the result of Quantity*Amount in Revenue infoobject of type amount.
How to handle this in transformation using routines.
Quantity Sold (Key figure of type Quantity)
Rate (Key figure of type amount)
Revenue(Key figure of type amount)= Quantity Sold * Rate
Thanks
Hi Yoges,
Take abap expert and ask him to develop above logic. try to use end routine.
if you need to bex level then easily you can get with help of calculation keyfigure.
You can give inputs abaper amount and quantity bw names, Ex. /BIC/ZAMOUNT and /BIC/ZQNTY.
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
In Bex level, you have to use NODIM(Qty Sold * Rate ). You can achieve in transformation field routine for your final KF with the help of ABAPer.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks for imdt response.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
I would suggest you to do this type of calculations at BEx level as suggested by Raman also.
Any specific reason to do at transformation level ?
Regards,
AL
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
74 | |
9 | |
7 | |
6 | |
6 | |
6 | |
6 | |
6 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.