on 05-08-2005 5:45 AM
Hi All,
I want to try an example for creating a virtual keyfigure. For this, I want to create a virtual keyfigure Sales Revenue and want to model price as an attribute of product(product id). Can anyone please tell me what code should i write in userexit to populate the data in reports.
Infocube name - <b>VCube</b>
<u>Characteristics:</u>
ProductID - <b>Pid</b>(has master data)
CustomerID - <b>Cid</b> (some other characteristic)
<u>ProductID has following infoobjects as master data.</u>
Price - <b>price</b>
Product name - <b>pname</b> (someother attribute)
<u>Keyfigures:</u>
SalesQuantity - <b>Sid</b>
SalesRevenue(defined as virtual keyfigure and it doesn't have any data in the fact table) - <b>Srev</b>
Using the infoobject names stated in bold letters and also the infocube name can anyone please tell me what code should i write in the user exit. Please follow the infoobject names stated in bold letters so that I can understand easily. I want to multiply the
sales quantity *price.
Please let me know....
Thanks,
Sabrina.
The document given below explains creating virtual key figures. If you do a F1 on the enhancement there also you can see some sample code.
https://websmp106.sap-ag.de/~sapdownload/011000358700009299362001E/HOWTOIDENTIFYCOMPRESULTS.DOC
Thanks.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello,
thirst of all documentations are available as a how to paper as well as in the documentation if the exit itself in transaction CMOD.
In addition I would like to inform you that such kind of calculation needs to be done in the Bex with a formula variable. If you are not doing this in the Query definition itself you will have problems if you aggregate the virtulal keyfigure.
kind reg.
Michael
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sabrina,
Please look at "How to... Use variable time references in currency conversions" white paper:
https://www.sdn.sap.com/sdn/developerareas/bi.sdn?page=BW_How_To.htm
It has a code for a virtual KF.
Best regards,
Eugene
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi
Pls send a test mail to this Id
I will send u the document
chivukula_kk@hotmail.com
rgds.
kk
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.