Skip to Content
0
Former Member
Mar 24, 2009 at 03:20 PM

Display current month records only

28 Views

Hi Experts,

I have the following requirement.

Report should display current month records only.

For example If the report is run on 20090324, It should display records from 20090301 to 20090324.

That means, report may run on any date of that month, It should display from 01 (of that month) to current date.

I have a select statement saying

SELECT * FROM likp

WHERE wadat_ist BETWEEN month_start_date AND sy-datum

AND vkorg IN s_vkorg

AND vkbur IN s_vkbur

AND kunnr IN s_kunnr.

How to calculate date for month_start_date, so that it can display only current month records.

Thanks in advance

Rohan