topic Re: using read statement in Application Development and Automation Discussions

using read statement

Former Member — Mon, 29 May 2006 09:47:12 GMT

Hi experts

how should i modify this statement

'select single parnr from ihpa into g_parnr' inorder to improve the performance.

can i use 'read' if yes can u plz give me the code for that

regards

siri

Re: using read statement

rahulkavuri — Mon, 29 May 2006 09:49:37 GMT

LOOP AT IHPA.

READ TABLE DTABLE WITH KEY PARNR = IHPA-PARNR.

IF SY-SUBRC = 0.

g_parnr = IHPA-PARNR.

ENDIF.

ENDLOOP.

Message was edited by: Rahul Kavuri

Re: using read statement

Former Member — Mon, 29 May 2006 09:50:09 GMT

Hi sireesha,

1. READ statement is for reading from

internal table (and not database table)

2. Your select statement is perfectly fine,

3. we can use where condition for this table ihpa,

for fields

OBJNR

PARVW

COUNTER

to improve the performance.

(bcos they are primary key fields of this table)

4. Other wise, there is no scope for improvement

for this simple select statement.

regards,

amit m.

Re: using read statement

Former Member — Mon, 29 May 2006 09:50:10 GMT

YOu cannot use a read statemkent to fetch records from database.

change your select single statement to this(Use the key fields in the where clause)

select single parnr from ihpa into g_parnr where OBJNR = p_OBJNR and PARVW = p_PARVW and COUNTER = p_COUNTER.

REgards,

Ravi

Re: using read statement

Former Member — Mon, 29 May 2006 09:51:11 GMT

Hii

use identical select statements.

Therefore, SORT the table and use READ TABLE WITH KEY BINARY SEARCH.

USE THE FOLLOWING

sort IT_VBAP BY MATNR .

LOOP AT IT_VBAP.

READ TABLE IT_MAKT KEY MATNR = IT_VBAP-MATNR

TRANSPORTING MAKTX binary search .

IF SY-SUBRC NE 0.

SELECT MATNR MAKTX FROM MAKT

APPENDING TABLE IT_MAKT-MAKTX

WHERE MATNR EQ IT_VBAP-MATNR.

ENDIF.

MOVE: IT_MAKT TO IT_VBAP-MAKTX.

ENDLOOP.

Instead of:

LOOP AT IT_VBAP.

SELECT SINGLE MAKTX INTO IT_VBAP-MAKTX

FROM MAKT

WHERE MATNR EQ IT_VBAP-MATNR.

ENDLOOP.

reward points if helpful .

Regards

Naresh

Re: using read statement

Former Member — Mon, 29 May 2006 09:51:30 GMT

Hi,

Using read :

read t_internal_tab with key matnr = wa_mara-matnr binar search....

but it's applicable to internal table only and not reading database table

Plz reward points and close the thread

regards

gunjan

Re: using read statement

Former Member — Mon, 29 May 2006 09:54:22 GMT

GOOD

THERE IS NO MISTAKE IN YOUR SELECT STATEMENT AND I DONT THINK IT WILL GIVE YOU A BAD PERFORMANCE.

THANKS

MRUTYUN

Re: using read statement

Former Member — Mon, 29 May 2006 09:54:48 GMT

Hi,

Your select single statement seems to be fine because it scans the table only for a single record which satisfies the condition. you can also use select upto 1 rows.

Regards,

Aswin

Re: using read statement

Former Member — Mon, 29 May 2006 09:55:16 GMT

if you are using the select single in side loop, then you can use for all entries and then use Read in side loop as suggested by Rahul.

Regards

vijay

Re: using read statement

abdul_hakim — Mon, 29 May 2006 10:00:29 GMT

hi,

READ is for reading from internal table.

you cannot use READ for reading from the database table.

Suppose if you want to fetch more than one record from a table then don't use select single instead use select field1 field2 from table1 into table itab variant this will improve your performance...

Cheers,

Abdul Hakim

Mark all useful answers

Re: using read statement

Former Member — Mon, 29 May 2006 10:03:23 GMT

Hi ,

First select all ur PARNR into on internale table , then use READ where ever u want

SELET PARNR FROM IHPA INTO TABLE IT_PARNR.

then u can use this table whereever u want

SORT IT_PARNR by PARNR.
eg : LOOP AT IT_FINAL.
         READ TABLE IT_PARNR WITH KEY PARNR = IT_FINAL-PARNR BINARY SEARCH.
 ENDLOOP.

Re: using read statement

Former Member — Mon, 29 May 2006 10:16:59 GMT

hi thank u

do we need to declare what is dtable in the code bcoz the code u gave is showing syntax error

regards

siri

Re: using read statement

Former Member — Mon, 29 May 2006 10:22:57 GMT

Hi Sireesha,

yes you need to declare it and then you need to select it before loop it self. check the above code.

Regards

vijay

Re: using read statement

Former Member — Mon, 29 May 2006 10:28:48 GMT

hi vijay

for suppose i want to select the data from IHPA data base table

how should i declare at begining

and how i should use the select statement.

regards

siri

Re: using read statement

Former Member — Mon, 29 May 2006 10:39:50 GMT

Hi,

it should be like this..

data: it_ihpa like ihpa occurs 0 with header line.

select * from ihpa into table it_ihpa.

then proceed...

Regards

vijay