topic Re: Looping Problem-Index in Application Development and Automation Discussions

Looping Problem-Index

rahul2000 — Mon, 07 Jan 2008 06:02:10 GMT

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.

Re: Looping Problem-Index

former_member156446 — Mon, 07 Jan 2008 06:06:16 GMT

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.

Re: Looping Problem-Index

Former Member — Mon, 07 Jan 2008 06:06:54 GMT

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.

Re: Looping Problem-Index

Former Member — Mon, 07 Jan 2008 06:08:00 GMT

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

Awrd opints if useful*

Bhupal

Re: Looping Problem-Index

Former Member — Mon, 07 Jan 2008 06:08:01 GMT

Hi Rahul ,

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

Regards

Arun

Re: Looping Problem-Index

Former Member — Mon, 07 Jan 2008 06:10:31 GMT

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.

Re: Looping Problem-Index

kesavadas_thekkillath — Mon, 07 Jan 2008 06:12:16 GMT

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.

Re: Looping Problem-Index

kesavadas_thekkillath — Mon, 07 Jan 2008 06:13:31 GMT

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.

Re: Looping Problem-Index

rahul2000 — Mon, 07 Jan 2008 06:18:36 GMT

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.

Re: Looping Problem-Index

rahul2000 — Mon, 07 Jan 2008 06:30:01 GMT

Dear Keshu,

How can i do this.yes you are correct.

Can uou tell me some alternative way out?

Re: Looping Problem-Index

Former Member — Mon, 07 Jan 2008 07:09:21 GMT

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