Skip to Content
0
Jan 21, 2019 at 10:56 AM

How to set 0CALWEEK t othe current week if it is offsetted in a BEx prompt ?

132 Views

Hey There,

I have a small issue.

I have a riport which should take as a prompt 0CAL/WEEK. However I had to offset the week by 3 days cause the report runs from Thursday to Thursday (it is a weekly cashflow report). In BW I've offsetted the date and calculated a getweek so it works awsomely fine however I have a small issue.

In Bex when i set the currentweek sap exit as a default prompt value it is calculated not by the date+3 but the original dates from the calendar.

It would be nice to set the prompt as the last week that I have in my infoprovider but I am unable (I am no allowed to write Customer exit.

Do you how to get the max week ? or do you know a good solution for my problem ?

Thanks Andras