Dear All,
I am tryinf group by in my select statement which is not working . please correct the code.
thanks
Vinayak
tables : ekko,ekpo,lfa1.
data : begin of itab occurs 0,
ebeln like ekko-ebeln,
bedat like ekko-bedat,
lifnr like ekko-lifnr,
netwr like ekpo-netwr,
name1 like lfa1-name1,
count type i,
end of itab.
select-options: s_bedat for ekko-bedat.
select aebeln alifnr abedat sum( bnetwr )
into corresponding fields of itab
from ekko as a inner join ekpo as b on bebeln = aebeln
where abedat in s_bedat group by aebeln alifnr abedat.
select single name1 from lfa1 into itab-name1
where lifnr = itab-lifnr.
append itab.
endselect.
endselect.
loop at itab.
on change of itab-lifnr.
skip.
write :/ itab-lifnr, itab-name1.
endon.
write :/ itab-ebeln, itab-bedat,itab-netwr.
endloop.