Looping Problem-Index

[rahul2000]

Dear all,

I am unable to get the index read correctly for my IT_DISPLAY table.There are 2 values in plaf table and multible in display table.

how to get the correct index value for my display table?since currently it is on plaf table.due to this index problem,my values get moved incoreectly

code is as follows

SORT IT_AFPO BY PLNUM.

SORT IT_PLAF BY PLNUM.

LOOP AT IT_AFPO INTO WA_AFPO.

LOOP AT IT_PLAF INTO WA_PLAF.

W_INDEX = SY-TABIX.

IF WA_PLAF-PLNUM = WA_AFPO-PLNUM.

MOVE:WA_PLAF-GSMNG TO WA_DISPLAY-GAMNG.

MODIFY IT_DISPLAY INDEX W_INDEX FROM WA_DISPLAY TRANSPORTING GAMNG.

ENDIF.

CLEAR:WA_PLAF,WA_DISPLAY.

ENDLOOP.

CLEAR:WA_AFPO.

ENDLOOP.

[former_member156446]

Hai Rahul try like this..

SORT IT_AFPO BY PLNUM.

SORT IT_PLAF BY PLNUM.

LOOP AT IT_AFPO INTO WA_AFPO.

read table IT_PLAF INTO WA_PLAF with key PLNUM = WA_AFPO-PLNUM binary search.

if sy-subrc eq 0.

W_INDEX = SY-TABIX.

MOVE:WA_PLAF-GSMNG TO WA_DISPLAY-GAMNG.

MODIFY IT_DISPLAY INDEX W_INDEX FROM WA_DISPLAY TRANSPORTING GAMNG.

endif.

ENDIF.

CLEAR:WA_PLAF,WA_DISPLAY.

CLEAR:WA_AFPO.

ENDLOOP.

if you have to do a loop in a loop

SORT IT_AFPO BY PLNUM.

SORT IT_PLAF BY PLNUM.

LOOP AT IT_AFPO INTO WA_AFPO.

LOOP AT IT_PLAF INTO WA_PLAF where PLNUM = WA_AFPO-PLNUM .

W_INDEX = SY-TABIX.

MOVE:WA_PLAF-GSMNG TO WA_DISPLAY-GAMNG.

MODIFY IT_DISPLAY INDEX W_INDEX FROM WA_DISPLAY TRANSPORTING GAMNG.

CLEAR:WA_PLAF,WA_DISPLAY.

ENDLOOP.

CLEAR:WA_AFPO.

ENDLOOP.

[Former Member]

hi,

when ur reading the second internal table read this based on a where condition and that should link both ur tables first.

Reward points if helpful,

Regards,

Sumanjeet.

[Former Member]

Better take a variable and keep Incrementing in the inner loop and clear it in the outer loop.

• Awrd opints if useful*

Bhupal

[Former Member]

Hi Rahul ,

Could you please specify what exactly do you want to do.

Regards

Arun

[Former Member]

Hi,

In the given code, it is not clear about IT_DISPLAY internal table. What data does it contain and whether there is any link between WA_PLAF and IT_DISPLAY. It is not clear, why u are trying to use WA_PLAF index to modify IT_DISPLAY.

If this point is clear, i hope u can easily solve.

Let us know the relation.

[rahul2000]

Dear Arun/Ramesh,

IT_DISPLAY is the internal table which contains the data to be displayed.

My problem is that if there is a planned order quantity of 10,and production order quantity for that planned order is also 10,then no problem.

But if it is anything less than 10,then the problem is that it shows 0.

also when a planned order quantity is converted to planned order quantity completely (that is 10 out of 10)

then from PLAF TABLE no more contains that PLNUM.

bUT IF IT IS PARTIAL(ANYTHING LESS THAN 10),then that PLNUM IS COMMON in both PLAF AND AFPO.

[kesavadas_thekkillath]

SORT IT_AFPO BY PLNUM.

SORT IT_PLAF BY PLNUM.

LOOP AT IT_AFPO INTO WA_AFPO.

LOOP AT IT_PLAF INTO WA_PLAF.

W_INDEX = SY-TABIX.

IF WA_PLAF-PLNUM = WA_AFPO-PLNUM.

MOVE:WA_PLAF-GSMNG TO WA_DISPLAY-GAMNG.

MODIFY IT_DISPLAY INDEX W_INDEX FROMWA_DISPLAY TRANSPORTING GAMNG.*

ENDIF.

CLEAR:WA_PLAF,WA_DISPLAY.

ENDLOOP.

CLEAR:WA_AFPO.

ENDLOOP.

since IT_DISPLAY is a new table use append IT_DISPLAY.

[kesavadas_thekkillath]

as per u r code the wk_tabix will contain the index of IT_PLAF...

then how can u modify IT_DISPLAY with the index of IT_PLAF.

[rahul2000]

Dear Keshu,

How can i do this.yes you are correct.

Can uou tell me some alternative way out?

[Former Member]

Take a variable and keep Incrementing in the inner loop and clear it in the outer loop.

When ur loopng and modifying ur values consider the value of this variable as the index.

awrd points if useful

Bhupal