topic Re: Read Substring in Application Development and Automation Discussions

Read Substring

Former Member — Fri, 27 Jun 2014 14:47:07 GMT

Hi All,

I have a calue Communication in the internal table .

When i use READ TABLE it into wa where name = 'Comm%' is not working.

How to use a substring for read table?

Thanks

Vijay

Re: Read Substring

Former Member — Fri, 27 Jun 2014 15:00:55 GMT

This message was moderated.

Re: Read Substring

Mohamed_Mukhtar — Fri, 27 Jun 2014 15:58:35 GMT

Hello Gowtham,

Are you trying to ready first 4 characters of name filed in read statement.

Try like below

READ TABLE it into wa where name+0(4) = 'Comm'. or

delete it where name+0(4) NE Comm'.

Thanks

Re: Read Substring

Former Member — Fri, 27 Jun 2014 16:18:16 GMT

sorry for the earlier reply

can we use where with read

Re: Read Substring

Mohamed_Mukhtar — Fri, 27 Jun 2014 16:20:43 GMT

Hello Gowtham

My mistake , I gave incorrect syntax. use 'with key'

READ TABLE it into wa with key name+0(4) = 'Comm'.

Re: Read Substring

rajkumarnarasimman — Fri, 27 Jun 2014 16:25:57 GMT

Hi Vijay,

String Comparison won't work in Read statement, instead of that, we can use the same in Loop statement as shown below.


REPORT  zread_internal_table.

 "Structure Declaration
 TYPES: BEGIN OF ty_makt,
         matnr  TYPE matnr,
         maktx TYPE maktx,
        END OF ty_makt.

 "Data Declaration 
 DATA: it_makt TYPE TABLE OF ty_makt,  "Internal Table
       wa_makt TYPE ty_makt.           "Work Area  

 "Retrive the Records from Database Tabble
 SELECT matnr
        maktx
        FROM makt
        INTO TABLE it_makt
        UP TO 10 ROWS.

 "Compare String
 LOOP AT it_makt INTO wa_makt WHERE maktx CA '%this%'.
   
   "Write Statment
   WRITE wa_makt-maktx.
   
   "Exit from the Loop after 1st Record Read from Internal Table
   EXIT.
   
ENDLOOP.

Regards

Rajkumar Narasimman

Re: Read Substring

former_member730258 — Mon, 30 Jun 2014 07:03:30 GMT

Try this:

READ TABLE itab WITH KEY low(4) = 'COMM' INTO l_val.

Re: Read Substring

Former Member — Mon, 14 Jul 2014 15:15:07 GMT

Thanks for reply.. I found out that since READ can read a single value , we cannot use sub strings for READ .

Thanks

Vijay