Experts - Please advise.
My query accepts user entry for a fiscal week range - a from value and a to value. I am currently using a variable with range for this query. Now, the problem is that the user does not want to input the company's fiscal week. Instead, he wants to input just 2 numbers - say n1 and n2. My fiscal week range should then be
(current week - n1) to (current week + n2).
Has anyone done this before - accept 2 numbers (which are not modeled in the info cube) and pass it on to the user exit (or otherwise ?) and calculate the date range. Please advise.
3 Answers
-
Former MemberJul 06, 2004 at 07:34 PMHello,
sounds interesting... there are more then one possible solution. One way could be to create an info object (num. 2) with master data. There you can store your 2-sign week-entries (F4-selektion on masterdata). Then include this object into the cube (without filling/mapping them). Within your query you can create a selection on this object. Create a exit-variable on the fiscal-week-objekt.
Within the Bex-exit you have the possibility (within STEP 2) do read the entries from the selektion of the first object. With this entries you could fill (and modify) your fiscal-week-object.
Bye, Joerg
Add comment
-
Former MemberJul 06, 2004 at 08:31 PM
Deepak,
Create formula variable for N1 & N2.
Then create a variable each for 'From' & 'To' and use customer exit to calculate the the from week & to week.
which version of BC are you on ? check the variables for DM, they have a similar scenario for aging bucket.
Cheers
Tushar
Add comment
-
Former MemberJul 10, 2004 at 08:02 PM
Mr. Deepak,
Do you have an yahoo account... I work for SAP in India, Bangalore, Please let me know if you got the answer for your question... or still looking for it...
or send me an email to vijay_chowdary76@yahoo.com.... for any questions....
Thank you
Have a nice time.
Add comment
Add comment