topic Re: Sequential read instead of array fetch in Application Development and Automation Discussions

Sequential read instead of array fetch

Former Member — Tue, 26 Sep 2006 09:33:44 GMT

Hi Guys,

Im banging my head by trying to figure out why my SQL statement always turned up with sequential read(check against ST05) instead of array fetch eventhough i put INTO TABLE statement. FYI, im extracting data from table BSET(under cluster RFBLG). This is the code:

    SELECT bukrs belnr gjahr buzei bupla mwskz hkont  
           txgrp shkzg hwbas hwste ktosl knumh kbetr 
           mlddt stbkz 
      INTO TABLE LT_TEMP 
      FROM bset 
      PACKAGE SIZE 3000
      FOR ALL ENTRIES IN lt_bkpf
      WHERE bukrs  =  lt_bkpf-bukrs            
      AND   belnr  =  lt_bkpf-belnr     
      AND   gjahr  =  lt_bkpf-gjahr.                 
    ENDSELECT

Pls comment whats wrong with the above code.

Thanks in advance.

Re: Sequential read instead of array fetch

Former Member — Tue, 26 Sep 2006 09:35:10 GMT

You have to change your statement like this :

SELECT bukrs belnr gjahr buzei bupla mwskz hkont

txgrp shkzg hwbas hwste ktosl knumh kbetr

mlddt stbkz

INTO corresponding fields of TABLE LT_TEMP

FROM bset

PACKAGE SIZE 3000

FOR ALL ENTRIES IN lt_bkpf

WHERE bukrs = lt_bkpf-bukrs

AND belnr = lt_bkpf-belnr

AND gjahr = lt_bkpf-gjahr.

Re: Sequential read instead of array fetch

Former Member — Tue, 26 Sep 2006 09:35:21 GMT

Why do you need a ENDSELECT?

Regards,

Raj

Re: Sequential read instead of array fetch

Former Member — Tue, 26 Sep 2006 10:03:58 GMT

Hi Ravi,

FYI, your statement will not solve the prob. thank for your comment.

Hi Raj,

Why i used ENDSELECT? Please press F1 on SELECT. PACKAGE SIZE does the matter.

Any other ideas, guys?

Re: Sequential read instead of array fetch

Former Member — Tue, 26 Sep 2006 13:48:23 GMT

I think your code is correct. But remember that you have to process the internal table insice the SELECT/ENDSELECT:


   SELECT bukrs belnr gjahr buzei bupla mwskz hkont  
           txgrp shkzg hwbas hwste ktosl knumh kbetr 
           mlddt stbkz 
      INTO TABLE LT_TEMP 
      FROM bset 
      PACKAGE SIZE 3000
      FOR ALL ENTRIES IN lt_bkpf
      WHERE bukrs  =  lt_bkpf-bukrs            
      AND   belnr  =  lt_bkpf-belnr     
      AND   gjahr  =  lt_bkpf-gjahr. 
*  LOOP AT lt_temp.
*  ENDLOOP.
*    or
*  APPEND LINES OF lt_temp
*    TO lt_new.
    ENDSELECT

Rob

Re: Sequential read instead of array fetch

Former Member — Tue, 26 Sep 2006 15:14:37 GMT

Hi Rob,

May i know why i have to code LOOP_{ENLOOP within my SELECT}ENDSELECT !!!??? Please give your comment here.

As i stated clearly on my first post, my problem now is happening on the sequential read.

Thanks anyway.

Re: Sequential read instead of array fetch

Former Member — Tue, 26 Sep 2006 15:30:05 GMT

Because each package will overlay the previous one. If you don't process the internal table for each package, it will be lost.

I don't get what you mean by the problem is now on the sequential read. The code you posted is for an array fetch.

Rob

Re: Sequential read instead of array fetch

christian_wohlfahrt — Tue, 26 Sep 2006 15:43:54 GMT

Hi!

BSET is 'just' a cluster table. The fields of BSET are not mapped 1:1 to the fields of the 'real' DB-table.

Now it seems, that only the complete primary key can be accessed directly in the cluster, not parts.

Your program might get much faster, when you add the line numbers (BUZEI) into lt_temp. Of course you have a bigger select statement (executed, not in source!), but this might be compensated by index access.

Regards,

Christian