cancel
Showing results for 
Search instead for 
Did you mean: 

Quantity and Amount conversions

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

RamanKorrapati
Active Contributor
0 Kudos

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

Answers (3)

Answers (3)

former_member182470
Active Contributor
0 Kudos

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.

Former Member
0 Kudos

Thanks for imdt response.

anshu_lilhori
Active Contributor
0 Kudos

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