How to avoid loop inside loop?

[former_member207873]

Hi Experts,

                    I have come across a scenario like below. I have achieved the result using loop inside loop and it is quite time consuming.

My internal table after the select query looks like below. I have to get the final internal table from this internal table with some change in the order in which the data is displayed. My first internal table looks like below.

VBELN	PSTYV	POSNR	MATNR	FKIMG	LFIMG

[Former Member]

do a inner join in the select statement

[joao_sousa2]

I believe you have to provide more detail.