topic Re: select into internal table in Application Development and Automation Discussions

select into internal table

Former Member — Thu, 25 Jan 2007 14:21:20 GMT

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

Re: select into internal table

Former Member — Thu, 25 Jan 2007 14:24:46 GMT

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

Re: select into internal table

Former Member — Thu, 25 Jan 2007 14:25:00 GMT

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

Re: select into internal table

Former Member — Thu, 25 Jan 2007 14:27:17 GMT

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

Rob

Re: select into internal table

Former Member — Thu, 25 Jan 2007 14:31:48 GMT

BDCPV is such a huge table view...

resrict the select for message type