Skip to Content
0
Jul 14, 2008 at 02:18 PM

keeping performance but itab runs to maximum

38 Views

I have a selection through bsak but I think I can optimize it but don't know how.

is it possible that the ta_cred is indexed on lifnr so it cannot append duplicate keys from bsak ?

it wil dump If I have the period to big on maximum exceeded 😔

TYPES:
      BEGIN OF ty_cred,
        lifnr TYPE lfa1-lifnr,
      END OF ty_cred.

DATA: ta_cred  TYPE TABLE OF ty_cred WITH HEADER LINE.

  SELECT lifnr FROM bsak
           INTO TABLE ta_cred
           FOR ALL ENTRIES IN ta_bkpf
           WHERE bukrs EQ ta_bkpf-bukrs
           AND belnr EQ ta_bkpf-belnr
           AND gjahr EQ ta_bkpf-gjahr.

 SORT ta_cred BY lifnr.
  DELETE ADJACENT DUPLICATES FROM ta_cred
            COMPARING lifnr.

kind regards

arthur de smidt