on 04-10-2010 6:24 AM
Dear SDN,
I need to generate the report Fiscal year wise GR Value.
Example:
Selection Parameters:
Material number:
Fiscal Year(Apr to March):
Output ... like this.
Fiscal Year GR Value in cr
2006 100
2007 200
2008 300
2009 400
In the cube time chars are Calender Year,Calender Year/Month,Calender Year/Quarter,Fiscal Year/Period but Fiscal Year is not
availabe......
I need customer exit code for to covert fiscal period to Current Fiscal Year.
waiting for reply
Thanks & Regards,
Praveen.K
Hi,
This is not possible unless you use virtual characteristics.
-Vikram
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi.
It is not impossible.
You wrote you have NO fiscal year in your cube, BUT you do want to show this (non existing) characteristic !!!
You should do one of 2:
1. use virtaul chars
2. add fiscal year to the cube and populate it at cube load process.
Regards.
[Uryukin Andrey|http://il.linkedin.com/in/andreyuryukin]
SAP-BI Consultant, [Advantech|http://advantech.co.il/en/index.asp]
[My Blog|http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/u/252016769] [original link is broken] [original link is broken];
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear,
Thank u for all replies.
My requirement is simple.
Rows:
Fiscal Year
Columns
GR Value
Filters
Material Number
Input Paramters:
Material No.
Fiscal Year
Using customer exit if we populate current fiscal year in the selection screen output be like this....
FISCAL YEAR GR Value(in crores)
2009 4000
2008 3000
2007 2000
2006 1000
The cube name Custom Cube ZBBP_C03.
But I dont have time char 0FISCYEAR in my Cube.In my cube avaiable chars are Calender Year,Calender Year/Month,Calender Year/Quarter,Fiscal Period
Please let me know if you need any information.
Waiting for replies,
Thanks & Regards,
Praveen.K
Hi.
Again, you HAVE NO such characteristic 0FISCYEAR in your cube, so how you want to show it in report ?
You should extend your cube with such characteristic.
Then you should be able to show it in report.
Or versa use virtual characteristic ...
Regards.
[Uryukin Andrey|http://il.linkedin.com/in/andreyuryukin]
SAP-BI Consultant, [Advantech|http://advantech.co.il/en/index.asp]
[My Blog|http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/u/252016769] [original link is broken] [original link is broken];
Hi,
If you have fiscal period then we can convert it to year and Month using some Function Modules.
Using Customer Exit Code we can do it, if you have correct required Inputs.
Please let me know the scenario with example. i..e What is there in Cube/Report and What you want?
Mean time you can see the Customer Exit Codes in the following URL
http://wiki.sdn.sap.com/wiki/display/profile/Surendra+Reddy
Pls give simple example.
Thanks
Reddy
Edited by: Surendra Reddy on Apr 12, 2010 6:04 AM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
82 | |
10 | |
10 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.