topic Re: OR condition in key while reading internal table.. in Application Development and Automation Discussions

OR condition in key while reading internal table..

Former Member — Thu, 03 Jul 2008 15:53:00 GMT

Hello,

I want to reading internal table as follows:

READ TABLE i_cust WITH KEY domvalue = it_kna1-NAME1.

I want to read the same table with or condition in key like

domvalue = it_kna1-name1 or domvalue = it_kna1-name2.

How can I do or condition for Keys ?

Regards,

Rajesh

Re: OR condition in key while reading internal table..

Former Member — Thu, 03 Jul 2008 15:54:00 GMT

You can only use READ TABLE statement with equality condition.

You can achieve the desired result in the following way:


READ TABLE i_cust WITH KEY domvalue = it_kna1-NAME1.
if sy-subrc ne 0.
READ TABLE i_cust WITH KEY domvalue = it_kna1-NAME2.
 if sy-subrc = 0.
    PERFORM subroutine1.
 endif.
else.
  PERFORM subroutine1.
endif.

Re: OR condition in key while reading internal table..

RichHeilman — Thu, 03 Jul 2008 15:56:02 GMT

You must use a LOOP in this case.

loop at i_cust 
        where domvalue = it_kna1-NAME1
             or  domvalue = it_kna1-name2.
* Do something
exit.  " now exit if at least one line has been read
endif.

Regards,

Rich Heilman

Re: OR condition in key while reading internal table..

Former Member — Thu, 03 Jul 2008 15:58:35 GMT

In my case I will have value in either of fields, so I want to read the table with that key which has the value..

Re: OR condition in key while reading internal table..

Former Member — Thu, 03 Jul 2008 16:00:46 GMT

You can achieve the desired result in the following way:



READ TABLE i_cust WITH KEY domvalue = it_kna1-NAME1.
if sy-subrc ne 0.
READ TABLE i_cust WITH KEY domvalue = it_kna1-NAME2.
 if sy-subrc = 0.
    PERFORM subroutine1.
 endif.
else.
  PERFORM subroutine1.
endif.

Re: OR condition in key while reading internal table..

RichHeilman — Thu, 03 Jul 2008 16:14:55 GMT

Ok, then you could use a field symbol.

field-symbols: <fs_name> type any.

if it_kna1-NAME1 is not initial.
 assign it_kna1-NAME1 to <fs_name>.
elseif it_kna1-NAME2 is not initial.
 assign it_kna1-NAME2 to <fs_name>.
endif.

READ TABLE i_cust WITH KEY domvalue = <fs_name>.
if sy-subrc = 0.

endif.

Regards,

Rich Heilman