topic Re: read statement with key syntax in Application Development and Automation Discussions

read statement with key syntax

Former Member — Fri, 02 Jan 2009 06:15:16 GMT

Hi all,

In read statement, is there a possibility to use 'contains string (CS)' instead of '=' in with key?

I have a requirement to fetch from an internal table, the record whose field1 value contains a particular string.

Thanks,

David.

Re: read statement with key syntax

Former Member — Fri, 02 Jan 2009 06:18:17 GMT

Hi David,

The contain string operations cannot be used in the read statement.

instead you use it in the select clause.

for eg.

data: l_srch_str type string.

l_srch_str = 'ABC%'.

select *

from <table>

into table itab

where <fieldname> like l_srch_str.

regards,

Santosh Thorat

Re: read statement with key syntax

Former Member — Fri, 02 Jan 2009 06:19:07 GMT

Hi David,

LOOP AT <ITAB> where <Field> CS <VALUE>.

**********Do your work here.

EXIT.

ENDLOOP.

Hope it wors for you.

Re: read statement with key syntax

vinod_vemuru2 — Fri, 02 Jan 2009 06:20:54 GMT

HI,

There is no way u can use any operator other than = with read statement.

Instead u can use loop statement.

CLEAR wa.

LOOP AT itab INTO wa WHERE field CS ur value.

EXIT.

ENDLOOP.

now ur wa contains required data.

Thanks,

Vinod.

Re: read statement with key syntax

Former Member — Fri, 02 Jan 2009 06:22:37 GMT

hi,

You can have the String operation in READ statement. Instead you need to use the Loop ..Endloop statement.

LOOP AT itab WHERE field CS l_field.
* Do your Process.
ENDLOOP.

Re: read statement with key syntax

Former Member — Fri, 02 Jan 2009 06:23:38 GMT

Hi,

In Read Statement you cannot use like statement, you can use only =.

Thanks,

Sriram POnna.

Re: read statement with key syntax

Former Member — Fri, 02 Jan 2009 06:24:01 GMT

HI,

First try to read table with some other key field...

And then use if to check ur condition.

loop at itab.

read table itab1 with key f1 = itab-f1.

if sy-subrc = 0.

if itab1-f2 CS 'abc'.

move data.

endif.

endloop.

Try this.

Regards,

Mr.A

Re: read statement with key syntax

Former Member — Fri, 02 Jan 2009 06:25:00 GMT

Hi Sanket and Vinod,

Thanks for the reply.

Can you tell me the impact on performance when using loop with where condition instead of a read?

The scenario is:

I have a loop which will have thousands of record.

In this loop, I have to use my requirement of fetching from an internal table.

Thanks,

David.

Re: read statement with key syntax

Former Member — Fri, 02 Jan 2009 06:26:56 GMT

it won't accept CS in read table clause. syntax error will be displayed.

for more clarity just execute the falloing code.

DATA: BEGIN OF ITAB OCCURS 0,

MATNR LIKE MARA-MATNR,

ERSDA LIKE MARA-ERSDA,

ERNAM LIKE MARA-ERNAM,

END OF ITAB.

SELECT MATNR

ERSDA

ERNAM

FROM MARA

INTO TABLE ITAB

WHERE ERNAM = 'BOHNSTEDT'.

IF SY-SUBRC EQ 0.

SORT ITAB BY MATNR ASCENDING.

READ TABLE ITAB WITH KEY MATNR CS '3'.

IF SY-SUBRC EQ 0.

WRITE: ITAB.

ENDIF.

Re: read statement with key syntax

Former Member — Fri, 02 Jan 2009 06:41:28 GMT

Hi David,

As per the performence if u having a lot of record u will follow the Phani Krishna suggestion. Loop logic will fine with small no. of recocords.

Re: read statement with key syntax

Former Member — Fri, 02 Jan 2009 06:43:21 GMT

you cant use other than = in Read statement.

As you requirement is to find a singe record from a internal table, try these ways

1. Read the table with some other index and try using LOOP at where FROM INDEX

2. Make the table as SORTED with the column as key and then LOOP AT WHERE F1 CS 'XXX'.

for better performance only...

Edited by: Sumanth Nag Kristam on Jan 2, 2009 7:43 AM

Re: read statement with key syntax

vinod_vemuru2 — Fri, 02 Jan 2009 10:16:34 GMT

Hi David,

LOOP will definitely have impact on performance. But if there is no other way then we have to compromise.

SORT the table based on the field u want to check will help a lot when using LOOP with Where clause.

Thanks,

Vinod.

Re: read statement with key syntax

Former Member — Fri, 02 Jan 2009 10:25:25 GMT

Hi David..

Try using Wild card character % in READ to check for Contains string..



read table t_vbak into wa_vbak with key vbeln = '%53%'.

Check whether something like the above is givin any error............ i am trying to read the internal table where VBELN contains the string 53

Cheers..

Re: read statement with key syntax

Former Member — Fri, 02 Jan 2009 10:33:02 GMT

Hi,

fatching recordds with read statement.

READ TABLE <ITAB> INTO <WA> INDEX 1.

READ TABLE <ITAB> INTO <WA> WITH KEY <FIELD NAME> = 'VALUE'.

READ TABLE <ITAB> INTO <WA> INDEX 1 TRANSPORTING NO FIELDS.

Regards

Md.MahaboobKhan