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.
Hello,
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
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
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 a comment