topic Re: Read statement not working inspite Internal tables having data in Application Development and Automation Discussions

Read statement not working inspite Internal tables having data

former_member765394 — Tue, 07 Sep 2021 04:46:50 GMT

Hi all,

I have two select queries on QBEW and PRPS table and both the selects have data.

QBEW - matnr,bwkey,bwtar,sobkz,pspnr

PRPS - pspnr,objnr,psphi

Now do a read statement:

READ TABLE lt_qbew INTO DATA(lw_qbew) WITH KEY pspnr = lw_prps-pspnr
bwkey = so_werks BINARY SEARCH.

I have sorted lt_qbew with both pspnr and bwkey.

Yet my read statement is failing. Pls Help.

Re: Read statement not working inspite Internal tables having data

satvik_panchal — Tue, 07 Sep 2021 05:07:10 GMT

Please refer the below link :

Read Statement with Select Options

Re: Read statement not working inspite Internal tables having data

FredericGirod — Tue, 07 Sep 2021 05:41:09 GMT

READ TABLE lt_qbew INTO DATA(lw_qbew) 
     WITH KEY pspnr = lw_prps-pspnr
              bwkey = so_werks 
     BINARY SEARCH

Next time use the [CODE] button to put ABAP Code.

It is a non-sens to make a single read, with binary access, and to specify a range of plant (werks). Because you could have several value in plant, the binary reading is not possible.

Change the way of doing it with a LOOP and and EXIT:

LOOP AT lt_qbew 
     INTO DATA(lw_qbew)
     WHERE pspnr EQ lw_prps-pspnr
     AND   bwkey IN so_werks.
  EXIT.
ENDLOOP.

Re: Read statement not working inspite Internal tables having data

Sandra_Rossi — Tue, 07 Sep 2021 06:09:34 GMT

That is a link with the right answer, but that makes the forum a jungle for future search https://blogs.sap.com/2013/11/08/posting-links-and-the-jungle-you-end-up-in/

Re: Read statement not working inspite Internal tables having data

matt — Tue, 07 Sep 2021 06:12:38 GMT

1. Use a SORTED table.

2. Use ORDER BY in the select.