Skip to Content
0
Dec 03, 2008 at 05:20 AM

Error in module RSQL of the database interface.

34 Views

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