Skip to Content
0
Former Member
Sep 14, 2007 at 08:10 PM

Group By

28 Views

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?