topic Re: Read Statement with Single key with multiple values in Application Development and Automation Discussions

Read Statement with Single key with multiple values

Former Member — Sun, 17 Aug 2008 11:39:26 GMT

Dear Friends,

In ECC 4.6c, I wrote statement like this.

Read table message with key type = 'E' or 'S'.

if sy-subrc = 0.

Populated the message log to output internal table.

endif.

But when i transported to QA which is ECC 6.0, it is giving error.

Can any one help me in modifying this qurey.

Plse read my question thoroughly and reply me back.

Regards,

Santosh Kumar M

Re: Read Statement with Single key with multiple values

Former Member — Sun, 17 Aug 2008 12:02:34 GMT

> In ECC 4.6c, I wrote statement like this.

> Read table message with key type = 'E' or 'S'.

> if sy-subrc = 0.

> Populated the message log to output internal table.

> endif.

loop at message where key = 'E' or 
                                   key = 'S'.
"Populated the message log to output internal table. and now exit for first instance
exit.
endloop.

Re: Read Statement with Single key with multiple values

vinod_vemuru2 — Sun, 17 Aug 2008 12:36:23 GMT

Hi,

You can't use OR condition with READ table. it is always AND condition.

Here 2 ways for ur problem.

If u want to have just one message in the log then use multiple reads.

READ TABLE message WITH KEY type = 'E'.

If sy-subrc IS INITIAL.

populate log.

ELSE.

READ TABLE message WITH KEY type = 'S'.

If sy-subrc IS INITIAL.

populate log.

ENDIF.

If u want all messages then u have to loop through and populate the log as sugested by Vijay but

Without exit in loop.(Since u need all the messages)

LOOP AT message into wa WHERE type = 'E' or type = 'S'.

populate log.

ENDLOOP.

Thanks,

Vinod.

Re: Read Statement with Single key with multiple values

Former Member — Sun, 17 Aug 2008 13:14:15 GMT

Hi,

try this....

Read table itab with key type = 'E' or type = 'S'.

if sy-subrc = 0.

*****

endif.

Re: Read Statement with Single key with multiple values

Former Member — Sun, 17 Aug 2008 19:02:30 GMT

hiii

you can use like below code..it will work as same as you want with both key conditions.

READ TABLE message WITH KEY type = 'E'.

If sy-subrc EQ 0.

READ TABLE message WITH KEY type = 'S'.

if sy-subrc EQ 0.

perform ....

endif.

regards

twinkal

Re: Read Statement with Single key with multiple values

matt — Sun, 17 Aug 2008 20:04:14 GMT


> Dear Friends,
> 
> In ECC 4.6c, I wrote statement like this.
> 
> Read table message with key type = 'E' or 'S'.
> if sy-subrc = 0.
> 
> 
> Santosh Kumar M

Really? Are you sure? To the best of my 10+ years experience, this has never been part of the syntax of READ.