select into internal table

[Former Member]

Hello abap-gurus,

I have a small problem when doing a select into an internal table. As i select and append into an internal table, the program dumps as there is not enough memory for the internal table. The SAP-table i'm selecting from is simply too big. So I'm wondering if there is a way to stop or set the max lines in the internal table to say 10000 rows? I would appreciate any example.. the statement looks like this:

SELECT * INTO l_bdcpv

FROM bdcpv

WHERE not process = 'X'

AND mestype = 'ISM_MATMAS'.

APPEND l_bdcpv TO i_bdcpv.

ENDSELECT.

Best regards Ballo

[Former Member]

HI,

DATA: I_BDPCV LIKE BDPCV OCCURS 0 WITH HEADER LINE.

SELECT * FROM BDPCV INTO I_BDPCV UP TO 100 ROWS WHERE PROCESS NE 'X' AND MESTYPE = 'ISM_MATMAS'.

APPEND I_BDPCV.

ENDSELECT.

Regards

CNU

[Former Member]

HI,

Change the statement like this:

SELECT * INTO <b>corresponding fields of table l_bdcpv</b>

FROM bdcpv

WHERE process <b><></b> 'X'

AND mestype = 'ISM_MATMAS'.

Regards

Subramanian

[Former Member]

You can also try the PACKAGE SIZE option of the SELECT statement.

Rob

[Former Member]

BDCPV is such a huge table view...

resrict the select for message type