topic Re: Regarding read statement in Application Development and Automation Discussions

Regarding read statement

Former Member — Wed, 07 Jan 2009 02:45:40 GMT

Hi ,

this read is not working as expected any suggestions????

SELECT * FROM cdpos INTO TABLE t_cdpos

WHERE objectid = t_cdhdr1-objectid AND

objectclas = 'EINKBELEG' AND

changenr = t_cdhdr1-changenr and

tabname = 'EKPO' .

IF sy-subrc = 0.

read table t_cdpos with

key tabkey+16(2) = tbl_output-ebelp binary search.

if sy-subrc = 0 .

l_ponum = t_cdpos-tabkey+3(10).

l_poline = t_cdpos-tabkey+16(2).

endif.

ENDIF.

Re: Regarding read statement

Former Member — Wed, 07 Jan 2009 02:49:49 GMT

hi,

You need to use the sort on table t_cdpos before using Binary search in the Read Statement.

And check value exists in tbl_output-ebelp .

Edited by: avinash kodarapu on Jan 7, 2009 8:22 AM

Re: Regarding read statement

Former Member — Wed, 07 Jan 2009 04:19:58 GMT

Hi,

U need to sort the table before applying Read using binary search,

Chk this

http://help.sap.com/saphelp_nw04s/helpdata/en/fa/e8a9c30c1711d5b38a0050dadfafba/frameset.htm

Regards,

Manish

Re: Regarding read statement

former_member156446 — Wed, 07 Jan 2009 04:25:09 GMT

> SELECT * FROM cdpos INTO TABLE t_cdpos
>              WHERE objectid = t_cdhdr1-objectid AND
>                    objectclas = 'EINKBELEG' AND
>              changenr = t_cdhdr1-changenr and
>              tabname = 'EKPO' .
>  sort table t_cdpos with key key tabkey. "<<<addition
>       IF sy-subrc = 0.
>   read table t_cdpos with
>                 key tabkey+16(2) = tbl_output-ebelp binary search.
>        if sy-subrc = 0 .
>         l_ponum = t_cdpos-tabkey+3(10).
>         l_poline = t_cdpos-tabkey+16(2).
>         endif.
>       ENDIF.
>     ENDIF.

Re: Regarding read statement

Former Member — Wed, 07 Jan 2009 04:30:14 GMT

always sort the internal table with the filelds that you used in read statement key ....when u use binary search ...that's it .

Re: Regarding read statement

Former Member — Wed, 07 Jan 2009 04:51:36 GMT

Hi Revanth,

One liner from my side i.e. Sort the table before deleting the adjacent duplicate records.

regards

Sachin Sharma

Re: Regarding read statement

Former Member — Wed, 07 Jan 2009 04:55:33 GMT

hi,

SELECT * FROM cdpos

INTO TABLE t_cdpos

WHERE objectid = t_cdhdr1-objectid AND

objectclas = 'EINKBELEG' AND

changenr = t_cdhdr1-changenr and

tabname = 'EKPO' .

IF sy-subrc = 0.

read table t_cdpos with

key tabkey+16(2) = tbl_output-ebelp binary search.

if sy-subrc = 0 .

l_ponum = t_cdpos-tabkey+3(10).

l_poline = t_cdpos-tabkey+16(2).

endif.

ENDIF.

after select sort the internal table with key.

Re: Regarding read statement

Former Member — Wed, 07 Jan 2009 04:58:20 GMT

hi,

SELECT * FROM cdpos

INTO TABLE t_cdpos

WHERE objectid = t_cdhdr1-objectid AND

objectclas = 'EINKBELEG' AND

changenr = t_cdhdr1-changenr and

tabname = 'EKPO' .

sort t_cdpos by ebelp. "with ur key

IF sy-subrc = 0.

read table t_cdpos with key tabkey+16(2) = tbl_output-ebelp binary search.

if sy-subrc = 0 .

l_ponum = t_cdpos-tabkey+3(10).

l_poline = t_cdpos-tabkey+16(2).

endif.

ENDIF.

Re: Regarding read statement

Former Member — Wed, 07 Jan 2009 05:08:57 GMT

Hi,

When you are using binary search in the read statement you want to sort the table before itself.

Have you checked the SY-SUBRC = 0 after the select statement.

Regards,

Joan