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
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.