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