When selecting data from db into internal tables it is often wise to work with an upper limit, like in SE16.
This upper limit can be configured per user: Goto SE16, Settings--> User's Parameters
parameter p_mxsel type tbmaxsel obligatory default '1000'.
initialization.
select single tbmaxsel
from rseumod into p_mxsel
where uname = sy-uname.
[...]
select [...]
up to iv_tbmaxsel rows
where [...] .
SELECT ...
ReplyDeleteUP TO @l_mxsel ROWS
...
" check number of selected lines and show message
DATA(l_lines) = lines( mt_list ).
IF l_lines > p_mxsel.
MESSAGE s016(es) WITH p_mxsel.
ELSE.
MESSAGE s007(rj) WITH l_lines.
ENDIF.