Skip to Content
0
Former Member
Oct 29, 2005 at 06:02 AM

group by please help

26 Views

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.