I am getting dump while data is huge.
TYPES : BEGIN OF tt_itab,
matnr TYPE matnr ,
END OF tt_tab.
DATA : itab TYPE STANDARD TABLE OF tt_itab,
wa_tab LIKE LINE OF itab.
SELECT-OPTIONS : S_MATNR FOR MARA-MATNR . "Material Code
select * from mara
INTO CORRESPONDING FIELDS OF TABLE itab
WHERE MATNR in S_MATNR.
Now the problem is if in s_matnr i give small data its running ok. But in the range option if i give material more than 10000, on the select statement i am having the error ...
_The maximum size of an SQL statement was exceeded.
The statement contains too many input variables.
The input data requires more space than is available._
So how to decleare the internal table to avoid these types of error.
Regards,
Kaushik