topic Re: report in Application Development and Automation Discussions

report

Former Member — Fri, 04 Jul 2008 10:39:27 GMT

can we use OR between primary key in READ TABLE command of abp

Re: report

Former Member — Fri, 04 Jul 2008 10:40:48 GMT

hi,

Read table itab with key k1 k2.

thats it . No or conditions.

Re: report

Former Member — Fri, 04 Jul 2008 10:41:29 GMT

you can not use OR

Re: report

Former Member — Fri, 04 Jul 2008 10:42:09 GMT

you can't use anything else apart from '=' in the READ table statement. Even 'EQ' is not allowed..

read table itab with key <field> = <value>.

Re: report

Former Member — Fri, 04 Jul 2008 10:44:10 GMT

hi,

There is no way that we can specify an OR condition with Primary Key of the Table.

We can read in this way:

READ TABLE itab WITH TABLE KEY k1 = <value>

Hope this will help.

Reward if helpful.

Sumit Agarwal

Re: report

bpawanchand — Fri, 04 Jul 2008 10:44:15 GMT

No you cannot use it

check out this code buddy

TABLES :

spfli.

DATA :

t_tab LIKE TABLE OF spfli.

SELECT

carrid connid FROM spfli INTO CORRESPONDING FIELDS OF TABLE t_tab.

READ TABLE t_tab INTO spfli WITH KEY carrid = 'AA' or carrid = 'UA'.

Regards

Pavan

Re: report

Former Member — Fri, 04 Jul 2008 10:44:19 GMT

Hi Anurag,

We cannot use OR between primary key in READ statement.

The READ statement look like this:

READ TABLE itab WITH TABLE KEY k1 = f1 ... kn = fn

Regards,

Chandra Sekhar

Re: report

Former Member — Fri, 04 Jul 2008 11:03:48 GMT

You cannot use OR with the READ Statement. it wll give Syntax error.

If you want to read an internal table sunch that f1 = 'A' or f2 ='B' then check the code below.

Clear flag.
read table itab with key f1 ='A'.
if sy-subrc <> 0.
   read table itab with key f2 = 'B'.
   if sy-subrc = 0.
    flag = 'X'.
   endif.
else.
  flag = 'X'.
endif.
If flag = 'X'.
* Do your processing.
endif.

reward if useful.

Re: report

Former Member — Fri, 04 Jul 2008 11:09:37 GMT

Directly Noooooooooo, u cannt use. But u can do like using two read staement and setting a flag.

read table itab with key f1 ='A'.

if sy-subrc = 0.

flag = 'X'.

endif.

read table itab with key f2 ='X'.

if sy-subrc = 0.

flag = 'X'.

endif.

NOw CHECK the value of flag nd do the coding

Hope this ll be helpful.

Thanks & Regards

vinsee

Re: report

Former Member — Fri, 04 Jul 2008 11:23:49 GMT

Hi,

No, you cannot OR in Read statement.

THanks,

Sriram POnna.