Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Report based on Calweek

Hi All,

I have seen many post in scn regarding week conversion from date, but i have this requirement that i struck upon.

In my report i have 2 manual entry variables called "Planned week from and planned week to". Here the user enters from week number say '21' and To week number say '24'. So then the data executed should be between those 3 weeks.

In my modelling i have calday and if i map it to calweek or i use a FM DATE_GET_WEEK i will get week number like 21, 22 etc. But as i have only one week number field, how do i create 2 user entry variables from calweek like "from week" and "To week".



Former Member


you can create variable with values range.

create the variable on the 0CALWEEK  -> give the value ranges -> select the mandatory option.

now run the query give the 21 in 'from week' and 25 in 'to week'

now you will get the desired report.



1 View this answer in context

Helpful Answer

Not what you were looking for? View more on this topic or Ask a question