topic Re: Read table statement in Application Development and Automation Discussions

Read table statement

Former Member — Thu, 25 Jan 2007 18:58:27 GMT

Hi all ,

I have written select statement extracted values in itab.iam uding read table like this.

read table itab with key a = b.

but filed a contains multiple records how to get those multiple records.with read statement iam getting single value ( I dont want to use loop statement and select statement ). Please let me know.

Re: Read table statement

Former Member — Thu, 25 Jan 2007 18:59:47 GMT

HI Priya..

READ statement gives a single record which satisfies the condition first.

U have to use LOOP....ENDLOOP for multiple records for internal table

u cna write as..

Loop at itab where a = b.

......

..... ur code as per requirement.

Endloop.

Regards

CNU

Re: Read table statement

Former Member — Thu, 25 Jan 2007 19:00:43 GMT

HI,

You will get only one row..If you use READ TABLE..You have to use LOOP AT to get multiple records..

Thanks,

Naren

Re: Read table statement

Former Member — Thu, 25 Jan 2007 19:00:59 GMT

Check this:

/people/rob.burbank/blog/2006/02/07/performance-of-nested-loops

No need to LOOP. You can read an entire table using READ.

Rob

Message was edited by:

Rob Burbank

Re: Read table statement

Former Member — Thu, 25 Jan 2007 19:04:46 GMT

Hi priya.

to REAd all the records in itab u have to use LOOP ...ENdloop.

may i know why u dont want loop??

Re: Read table statement

Former Member — Thu, 25 Jan 2007 19:12:32 GMT

Through read statement you can get only single record.

you have to loop ... endloop. for more than 1 record.

regds,

kiran

Re: Read table statement

Former Member — Thu, 25 Jan 2007 19:21:19 GMT

Try running this (not terribly efficient, but no loops):


REPORT ztest NO STANDARD PAGE HEADING LINE-SIZE 80
  MESSAGE-ID 00.

PARAMETERS p_bukrs LIKE bkpf-bukrs.

DATA: BEGIN OF bkpf_int OCCURS 0.
        INCLUDE STRUCTURE bkpf.
DATA: END   OF bkpf_int.

DATA: no_lines  TYPE i,
      tab_index TYPE i.

SELECT * FROM bkpf
  INTO TABLE bkpf_int
  WHERE bukrs = p_bukrs.

DESCRIBE TABLE bkpf_int LINES no_lines.

tab_index = 1.

DO no_lines TIMES.
  READ TABLE bkpf_int INDEX tab_index.
  tab_index = tab_index + 1.

  WRITE: /001 bkpf_int-belnr.

ENDDO.

Rob

Re: Read table statement

Former Member — Thu, 25 Jan 2007 19:30:29 GMT

Hi Priya,

If you dont need the records in the future which doesn't match those condition.

Then write the statement :

Delete table itab where a <> b.

Then all the records whose key is a <> b are deleted, Remaining are the records which are matching the key a = b.

Points Reward , If helpful.

Regards

Kannu