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

Former Member

Helpful Answer

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