For all entries is evil
It was not the first time that I was bitten by this. One time should have been enough to learn, but using for all entries in select queries really requires extra care. If you write
be sure to guarantee that lt_aufnr will never be empty, or else, you end up with an internal table with all data from the database table. Arggh.
select *
from afpo
into table lt_afpo
for all entries in lt_aufnr
where aufnr = lt_aufnr-aufnr.
be sure to guarantee that lt_aufnr will never be empty, or else, you end up with an internal table with all data from the database table. Arggh.
Labels: development
0 Comments:
Post a Comment
<< Home