topic Re: how to give read statement checking condition in Application Development and Automation Discussions

how to give read statement checking condition

Former Member — Wed, 25 Jan 2006 14:12:41 GMT

hi,

i am trying to give like this, but it throws an error can u tell me how to give a read statement checking two conditions.

READ TABLE I_RSEG INTO WA_TAB_RSEG WITH KEY BELNR = WA_TAB_RBCO-BELNR

AND GJAHR = WA_TAB_RBCO-GJAHR

AND BUZEI = WA_TAB_RBCO-BUZEI.

Re: how to give read statement checking condition

Former Member — Wed, 25 Jan 2006 14:15:07 GMT

Remove 'AND'

<b>thanks for the reward!</b>

Re: how to give read statement checking condition

Former Member — Wed, 25 Jan 2006 14:15:27 GMT

Hi Anitha,

READ statement wont have 'AND's in them. Your statement will work fine without having 'AND's. Lets try by omitting 'AND's in ur statement.

Please change the code as follows.

READ TABLE I_RSEG INTO WA_TAB_RSEG WITH KEY BELNR = WA_TAB_RBCO-BELNR

GJAHR = WA_TAB_RBCO-GJAHR

BUZEI = WA_TAB_RBCO-BUZEI.

2)sort i_resg by belnr gjahr buzei.

READ TABLE I_RSEG INTO WA_TAB_RSEG WITH KEY BELNR = WA_TAB_RBCO-BELNR

GJAHR = WA_TAB_RBCO-GJAHR

BUZEI = WA_TAB_RBCO-BUZEI binary search.

The above statement will fetch u particular record faster than the above READ statement.

Thanks,

Vinay

Message was edited by: Vinaykumar Gorrela

Re: how to give read statement checking condition

suresh_datti — Wed, 25 Jan 2006 14:15:33 GMT

Pl change it to


sort I_rseg by belnr gjahr buzei.
READ TABLE I_RSEG INTO WA_TAB_RSEG WITH KEY 
BELNR = WA_TAB_RBCO-BELNR
GJAHR = WA_TAB_RBCO-GJAHR
BUZEI = WA_TAB_RBCO-BUZEI
binary search.

Regards,

Suresh Datti

Re: how to give read statement checking condition

Former Member — Wed, 25 Jan 2006 14:16:01 GMT

Hi Anitha,

1. AND

Dont use AND keyword.

regards,

amit m.

Re: how to give read statement checking condition

Former Member — Wed, 25 Jan 2006 14:16:03 GMT

Hi Anitha,

Please change the code as shown below :

READ TABLE I_RSEG INTO WA_TAB_RSEG WITH KEY BELNR = WA_TAB_RBCO-BELNR

GJAHR = WA_TAB_RBCO-GJAHR

BUZEI = WA_TAB_RBCO-BUZEI.

Lanka

Re: how to give read statement checking condition

Former Member — Wed, 25 Jan 2006 14:17:11 GMT

Hi Anitha,

Do use it like this.

READ TABLE I_RSEG

INTO WA_TAB_RSEG WITH KEY BELNR = WA_TAB_RBCO-BELNR

GJAHR = WA_TAB_RBCO-GJAHR

BUZEI = WA_TAB_RBCO-BUZEI.

if sy-subrc eq 0.

else.

endif.

Cheers

PS: Award points if this helps you

Re: how to give read statement checking condition

Former Member — Wed, 25 Jan 2006 14:21:25 GMT

read table i_rseg into wa_tab_rseg with key belnr = wa_tab_rbco-belnr

gjahr = wa_tab_rbco-gjahr

buzei = wa_tab_rbco-buzei.