cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

Display dates interval by selecting a week

Former Member
0 Likes
188

Hi SAPers,

I have the following requirement for a query: In the selection screen must appear week (0calweek) and Employee. They could select a week interval or different weeks that don't belong to an interval, for example: 01.2006, 10.2006 and 50.2006. That is for me no problem, but, in the report, the layout must be the following:

WEEK...........! From date...! To date......! Working hours ! Absence hours !

01.2006..........! 02.01.2006 ! 08.01.2006 !..........36..........!.............4............!

10.2006..........! 06.03.2006 ! 12.03.2006 !..........40..........!.............0............!

50.2006..........! 11.12.2006 ! 17.12.2006 !..........20..........!.............20..........!

So, I must show the first and the last days of the respective week, plus extra information as the working hours and the cost center to where the worker belongs, etc. I have in my cubus 0calweek, 0calday and well, I could display this interval. I got to display this dates interval but then I have 5 extra rows for every week (each with the correspondent working day of the week). But that was by adding the date in the rows, otherwise the interval would just don't appear. And this is not what I need.

Does anyone could give me a hand?

Thanks in advance!

Samira.

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Likes

I have found the solution myself. Thanks.