topic Re: read table issue in Application Development and Automation Discussions

read table issue

Former Member — Fri, 28 Sep 2007 20:42:16 GMT

Hi Experts,

I have an issue with 'READ TABLE' statement in a program. I am reading an internal table "i_output". The issue here is, it is working fine with some

customers(kunnr) but not for others.

The code:

do.

clear i_output.

read line sy-index.

if sy-subrc <> 0.

exit.

endif.

check not i_output is initial.

read table i_output with key kunnr = i_output-kunnr

vbeln = i_output-vbeln

posnr = i_output-posnr binary search.

check sy-subrc = 0.

Here in 'sy-subrc' it's returning '0' for some customers and sometimes '8'.

Can anybody please let me know what is wrong with this.

Thanks much.

Re: read table issue

Former Member — Fri, 28 Sep 2007 20:45:46 GMT

SORT Table i_output first...since you are using binary search.

SORT i_output BY KUNNR VBELN POSNR.

read table i_output with key kunnr = i_output-kunnr

vbeln = i_output-vbeln

posnr = i_output-posnr binary search.

Sri

Message was edited by:

Sri Tayi

Re: read table issue

Former Member — Fri, 28 Sep 2007 20:50:50 GMT

SORTing of Internal is a must to use the BINARY search in read statement

So first SORT ITAB by KUNNR VBELN POSNR first

then use the READ statement as you wrote

then it will fetch the right records always

Regards

Anji

Re: read table issue

Former Member — Fri, 28 Sep 2007 20:57:00 GMT

try this:

sort i_output by kunnr vbeln posnr.

read table i_output with key kunnr = i_output-kunnr

vbeln = i_output-vbeln

posnr = i_output-posnr .

check sy-subrc = 0.

This is something strange... how are you reading the same table with same conditions!!!!

Thanks,

SKJ

Re: read table issue

Former Member — Fri, 28 Sep 2007 21:02:13 GMT

I have already sorted the internal table. It's not working.

Re: read table issue

Former Member — Fri, 28 Sep 2007 21:03:46 GMT

Paste your code completely then it is easy to solve

Regards

Anji

Re: read table issue

Former Member — Fri, 28 Sep 2007 21:20:08 GMT

Thanks all. It works.

null

Re: read table issue

Former Member — Fri, 28 Sep 2007 21:25:18 GMT

Other folks have coverd the need to sort.

Another issue can occur if the value you are using for kunnr is not properly formatted.

You may have to call

  CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT'
    EXPORTING
      input  = i_output-kunnr
    IMPORTING
      output = i_output-kunnr.

to ensure kunnr is properly formatted before doing the read.

As noted above, I think you need to post more of your code to put things in context.

Good luck

Brian