topic Re: read command in Application Development and Automation Discussions

read command

Former Member — Fri, 18 May 2007 22:25:16 GMT

hello abap gurus,

can i know, what is the difference between select and read commands.

in what cases is read good to use.

plz dont give me links, just tell which is good for what.

thank you.

Re: read command

Former Member — Fri, 18 May 2007 22:28:49 GMT

select command is used to get fields from database. on the other hand, read command is working on internal table where we already have records.

ex. read table itab index 1.

Hope this will help you

Regards

Re: read command

Former Member — Fri, 18 May 2007 22:30:43 GMT

thanks manish

Re: read command

Former Member — Fri, 18 May 2007 22:32:07 GMT

so what is the difference between , loop and read,

LOOP AT WHERE ........

LOOPAT.

READ ITAB WHERE...

WHAT IS THE DIFFERENCE

Re: read command

Former Member — Fri, 18 May 2007 22:35:46 GMT

LOOP AT WHERE ........

ENDLOOP.

Here you are looping at internal table, you will have the infomration in the loop and endloop record by record. (again it should match the where condition)

READ ITAB WHERE...

Here you are reading internal table with where condition, you will get a record which matches that condition.

Reward if this answer is helpful

Re: read command

Former Member — Fri, 18 May 2007 22:36:27 GMT

Loop works with bunch of records but read works with one record.

When we do loop at itab

endloop. We will go with each records for exceution but read will explicity work with records you want to work with

like read table itab with key matnr = itab-matnr.

Hope this help.

Regards

Re: read command

Former Member — Fri, 18 May 2007 22:58:13 GMT

Hello Saritha,

Select command - get the data from data base table

read command will be using for reading the data from internal table only one record at a time.

Thanks

Seshu