doubts in query ..

Hi Genius,

I have a doupts in Report..

<b> budat = 01.04.2007 to 30.04.2007</b>

<b> matnr = a001</b>

SELECT * FROM zs_mkpf_mseg

into corresponding fields of table it_opbal

WHERE werks = itmat-werks

AND matnr = itmat-matnr

AND budat LT s_budat-low.

Now iam getting the opening balance..that is the closing balance of up to

30-3-2007.

My req is..between 1st month to 30th, i have to calculate the opbal of every day wise(1-4-07 to 30-4-07) for that how i should write the query statement.

please suggest me.