Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

group by ODS table

Hi experts,

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

from /BIC/ODSTable

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.

Jenny

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question