topic Re: Regarding READ Statement in Application Development and Automation Discussions

Regarding READ Statement

Former Member — Thu, 27 Apr 2006 07:55:10 GMT

Hi All,

I have a issue while using READ statement.

Issue IS:

In following Code

SORT i_konv BY knumv.

LOOP AT i_ekbe INTO wa_ekbe.

CLEAR wa_konv.

READ TABLE i_konv WITH KEY knumv = wa_ekbe-knumv

kschl <> space

lifnr <> space

kwert <> space

BINARY SEARCH.

IF sy-subrc EQ 0.

ENDIF.

ENDLOOP.

When i am checking syntax for above code it is giving error as KSCHL <> SPACE LIFNR <> SPACE is not expected.

Can anybody tell me what is the issue over here!

Thanks in advance.

Thanks & Regards,

Prasad.

Re: Regarding READ Statement

Former Member — Thu, 27 Apr 2006 08:01:02 GMT

Hi,

Ok i got the issue,

Only = can be used in READ.

Thanks,

Prasad.

Re: Regarding READ Statement

Former Member — Thu, 27 Apr 2006 08:02:09 GMT

ya u r rite

Re: Regarding READ Statement

nishanthbhandar — Thu, 27 Apr 2006 08:02:29 GMT

A negative condition does not work with a read statement.Please try for a better option with the read.

Cheers

Nishanth

Re: Regarding READ Statement

Former Member — Thu, 27 Apr 2006 08:02:38 GMT

Hi prasad,

I dont think you can do <> comparison in READ statment.

Try

READ TABLE i_konv WITH KEY knumv = wa_ekbe-knumv BINARY SEARCH.

use IF after reading, for this comparison.

Regards,

Tanveer.

Mark helpful answers.

Re: Regarding READ Statement

Former Member — Thu, 27 Apr 2006 08:05:24 GMT

Hi,

I got the solution as:

SORT i_konv BY knumv.

LOOP AT i_ekbe INTO wa_ekbe.

CLEAR wa_konv.

READ TABLE i_konv INTO wa_konv

WITH KEY

knumv = wa_ekbe-knumv

BINARY SEARCH.

IF sy-subrc EQ 0.

IF wa_konv-kschl NE space OR

wa_konv-lifnr NE space OR

wa_konv-kwert NE space.

some code

ENDIF.

ENDLOOP.

Thanks,

Prasad.

Re: Regarding READ Statement

Former Member — Thu, 27 Apr 2006 08:05:39 GMT

I idea is to get only one record using the READ statement.

Regards,

Ravi

NOte : Please mark all the helpful answers

Re: Regarding READ Statement

Former Member — Thu, 27 Apr 2006 08:07:45 GMT

Hi Prasad,

You can only use = in Read statement while using WITH clause.

Solution to your problem :

Declare three variables of the type that you want to use in the Read Statement.

lv_kschl type kschl.

lv_lifnr type lifnr.

lv_kwert type kwert.

Don't clear the variables and use like this.

READ TABLE i_konv WITH KEY knumv = wa_ekbe-knumv

kschl = lv_kschl

lifnr = lv_lifnr

kwert = lv_kwert

BINARY SEARCH.

Please mark helpful answer and close this thread.

Regards,

Amit Mishra

Re: Regarding READ Statement

nishanthbhandar — Thu, 27 Apr 2006 08:28:04 GMT

Prasad,

Please close the thread and award points for helpful answers if your query has been solved.

Cheers

Nishanth