Loop At Group By | Real Time Example | Where to use | Recommended over Control Break Statement

[@bollywooduptonow306]

Thank you Sir🙏

[@Gaming_station93]

In ATP check, it gives priority 1 check 'LOOP INSIDE LOOP'. will it has a performance issue just like loop inside loop?

[@pankajkumaram]

Yes, it looks like a loop inside the loop but not exactly. Grouping happens at the kernel level in an optimized way so No performance issue. this approach is recommended by SAP. In Horst Keller's words"Looks like dreaded nested LOOPs, but it isn’t quite that - no quadratic behavior! What happens here is that the first LOOP statement is executed over all internal table lines in one go and the new GROUP BY addition groups the lines. Technically, the lines are bound internally to a group that belongs to a group key that is specified behind GROUP BY. The group key is calculated for each loop pass. And the best is, it need not be as simple as using only column values, but you can use any expressions here that normally depend on the contents of the current line, e.g. comparisons, method calls, …. The LOOP body is not evaluated in this phase!" Reference: blogs.sap.com/2014/10/02/abap-news-for-740-sp08-grouping-internal-tables/

[@Gaming_station93]

@@pankajkumaram Thought as much. Insightful explanation. Aur sir Hindi mein bnao videos. Majaa aa jayega

[@sapabaponhana-training5607]

Sir.. you are awesome :)