topic Re: loop problem in Application Development and Automation Discussions

loop problem

Former Member — Thu, 28 Jan 2010 07:09:51 GMT

hi masters,

i have requirment where i need to fetch all the classification data.

i used a function moudle to get it and i got it into a table OBJECT_DATA.

so for a single characterisctic there are 3 values assinged to it.

ex : characteristic : CC-NOTES

|--

|
|
|
|--

1 | CommodityNotes | 002 | 303 | CC-NOTES | 001

1 | CommodityNotes | 003 | 333 | CC-NOTES | 001

1 | CommodityNotes | 001 | TAR083| CC-NOTES | 001

For CC-NOTES I have 3 values as we see. so i have to display 3 of them on my screen

so when i issue statement like this

ex : loop at object_data into wa.

READ TABLE object_data INTO wa WITH KEY atnam = 'CC-NOTES'.

it always looks only the first record so HOW CAN I MAKE MY STATEMENT TO READ THE SECOND RECORD?

CAN ANYONE HELP ME PLS?

THANK YOU,

PASALA.

Re: loop problem

Former Member — Thu, 28 Jan 2010 07:13:44 GMT

Hi,

In the read statement you give all the primary keys.

Regards,

pravin

Re: loop problem

Former Member — Thu, 28 Jan 2010 07:14:11 GMT

Hello,

READ statement will read only the first record it satisfies. But i dont see a reason why you are using a READ statement on the same internal table you are looping at . Either try the following


loop at object_data into wa.
if object_data-atnam = 'CC-NOTES'.
---
endif.
endloop.

else


loop at object_data into wa where atnam = 'CC-NOTES' .
---
-----
endloop.

Vikranth

Re: loop problem

Former Member — Thu, 28 Jan 2010 07:15:21 GMT

Try this

loop at object_data into wa.

loop at object_data into wa where where atnam = 'CC-NOTES' .

endloop.

Re: loop problem

Former Member — Thu, 28 Jan 2010 07:16:42 GMT

use loop and endloop statement

Re: loop problem

Former Member — Thu, 28 Jan 2010 07:17:22 GMT

You only have to use

Loop at OBJECT_DATA  into wa where atnam = 'CC-NOTES' .
...
....
Endloop.

Re: loop problem

Former Member — Thu, 28 Jan 2010 07:17:25 GMT

Hi,

Why ru looping the same internal table.

If u want to print the 3 records just

loop the interanal table where characteristic value is CC-NOTES

write the what ever fields u require.

endloop.

Regards

Jai

Re: loop problem

Former Member — Thu, 28 Jan 2010 07:20:07 GMT

Hi,

In this case you need to loop on ur table.

Use parallel cursor concept, to enhance the performance.

Re: loop problem

Former Member — Thu, 28 Jan 2010 07:20:27 GMT

Please specify uour requirement.

You are looping table 'OBJECT_DATA' and reading the same table.

if you use the loop like below then you will get all the 3 records sequentially in the work area.

Loop at OBJECT_DATA into wa where atnam = 'CC-NOTES'.

---

endloop.

Hope this helps.

Re: loop problem

Former Member — Thu, 28 Jan 2010 07:36:48 GMT

hey if u want to read only second record then u can add 1 more condition ...

READ TABLE object_data INTO wa WITH KEY atnam = 'CC-NOTES'

zaehl = '003' .

else do loop for all 3 record ...

Regards,

Prakash Patel

Re: loop problem

Former Member — Thu, 28 Jan 2010 08:38:19 GMT

Hello,

Use loop endloop instead of read.

Re: loop problem

Former Member — Thu, 28 Jan 2010 09:12:20 GMT

Hi,

The only solution for this is

loop at object_data into wa where atnam = 'CC-NOTES'

endloop.

Re: loop problem

Former Member — Thu, 28 Jan 2010 11:14:15 GMT

answered by self

Re: loop problem

Former Member — Thu, 28 Jan 2010 11:18:38 GMT

Could you please tell us how you did ?

Re: loop problem

Former Member — Thu, 28 Jan 2010 11:36:42 GMT

Hello

This will remain great secret for us