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