group by ODS table
Some doubts, please advice.
I am trying to send aggregate value of one column in ODS table into an internal table. I am using the following code.
select carrid connid AVG( seatsocc ) as seatsocc
into corresponding fields of table itab
where fldate = sy-datum group by carrid connid
But either because there is no header line in ODS table, or because I did use right column names in the internal table itab, I got "0" in all rows. Could anyone please tell me which is the reason of my error?
I tried to skip "corresponding fields of table itab ", and using internal table, however, i got an syntax error.
I saw some ABAP book using working area. Is it the only solution? I am not familiar with working area and someone told me I should be very careful of working area. what's the deal with working area? Can I append working area to an internal table?
Any suggestion will be really appreciated.