topic Re: Group By in Application Development and Automation Discussions

Group By

Former Member — Fri, 14 Sep 2007 20:10:40 GMT

I have an internal table that needs to be processed in a way that is

similar to a select statement with a "where" and "group by" condition, like:

SELECT objid gjahr accrule acrtype effdate INTO CORRESPONDING FIELDS OF

TABLE parent_class->acepsoit_table_ FROM acepsoit

WHERE bukrs IN parent_class->company_code_range

AND acrtype IN parent_class->accrual_type_range

AND accrule IN parent_class->acct_principle_range

AND effdate IN parent_class->key_date_range

AND poyear IN parent_class->fiscal_yr_range

GROUP BY effdate objid gjahr accrule acrtype.

Is it possible to duplicate the "group by" functionality in a loop?

Former Member — Fri, 14 Sep 2007 20:13:02 GMT

Sort and use AT NEW.

Rob

Former Member — Fri, 14 Sep 2007 20:13:44 GMT

I have used "Collect". This works fine

Former Member — Fri, 14 Sep 2007 20:16:02 GMT

Hi,

I don't think it is possible to duplicate the "group by" functionality in a loop.

Perhaps you can use sort and control break statement within the loop.

Regards,

Ferry Lianto

Former Member — Fri, 14 Sep 2007 20:17:07 GMT

ON CHANGE OF will also work.

Rob