topic Re: Internal table size in Application Development and Automation Discussions

Internal table size

Former Member — Thu, 16 Apr 2009 07:17:35 GMT

Hi,

I am fetching data from MSEG table based on MKPF using for all entries.

But the data is more so its getting dump with message input table size has no space.

I am using syntax like

Data : itab type table of .....

How can i increase the table size.

can anybody suggest me..

thanks

kumar

Re: Internal table size

Former Member — Thu, 16 Apr 2009 07:21:35 GMT

Hi Kumar,

while fetching data..

use the PACKET SIZE in the SELECT query..

you can get more details about the PACKET SIZE on the F1 help of the SELECT qurey.

Thanks!

Re: Internal table size

amit_khare — Thu, 16 Apr 2009 07:21:59 GMT

size limit of the internal table is 2GB

So, the best possibility is to decrease the amount of data you are selecting instead of increasing the size of the table.

Re: Internal table size

Former Member — Thu, 16 Apr 2009 07:23:32 GMT

Hi,

Add keyword 'PACKAGE SIZE n' in select statement. where n specifies number of rows ur fetching at a time. With inclusion of package size u have to include 'ENDSELECT' also

Re: Internal table size

Former Member — Thu, 16 Apr 2009 07:32:29 GMT

Hi,

If I understood correctly, it's not matter that you have to increase the size of the table.

Every Internal Table could hold the data up to 2GB; It's too high.

this issue usually comes when your code is executing under a infinite loop. Please check for you code.

And However,

TYPES : BEGIN OF ig_itab,

lifnr(010),

END OF ig_itab.

DATA: it_itab TYPE STANDARD TABLE OF ig_itab size n WITH HEADER LINE.

The Size u can declare as 10 etc...

Re: Internal table size

Former Member — Thu, 16 Apr 2009 08:30:10 GMT

Hi,

Mseg is a cluster like BSEG Table. As there is no date specification is in MSEG we have to give maximum where condition for such tables. What I think you are fetching your Material Document from MKPF according to that fetching entries against MSEG.

As Mseg contains all the histories against Material Document so you have to give Material Document Year in your selection critaria. I think that might reduce the size of internal table data.

Regards,

Himanshu

Re: Internal table size

Former Member — Thu, 16 Apr 2009 08:33:43 GMT

Hi,

Internal tabel zsize limit is 2GB.

Add PACKET SIZE in the select query to retrieve data

Regards,

Jyothi CH.

Re: Internal table size

Former Member — Thu, 16 Apr 2009 08:42:23 GMT

hi,

please give your select query...

regards,

kushagra sharma

Re: Internal table size

Former Member — Thu, 16 Apr 2009 09:21:22 GMT

Hi My code is as below :

TYPES : BEGIN OF TTY_MKPF, " Types for MKPF

MBLNR TYPE MBLNR,

MJAHR TYPE MJAHR,

BUDAT TYPE BUDAT,

END OF TTY_MKPF.

TYPES : BEGIN OF TTY_MSEG, " Types for MSEG

MBLNR TYPE MBLNR,

MJAHR TYPE MJAHR,

BWART TYPE BWART,

MATNR TYPE MATNR,

WERKS TYPE WERKS_D,

DMBTR TYPE DMBTR,

MENGE TYPE MENGE_D,

END OF TTY_MSEG.

DATA : I_MKPF TYPE TABLE OF TTY_MKPF, "Internal table for MKPF Table

WA_MKPF TYPE TTY_MKPF.

DATA : I_MSEG TYPE TABLE OF TTY_MSEG, "Internal table for MSEG Table

WA_MSEG TYPE TTY_MSEG.

SELECT MBLNR

MJAHR

BUDAT FROM MKPF INTO TABLE I_MKPF WHERE BUDAT IN S_DATE.

IF I_MKPF[] IS NOT INITIAL.

SELECT MBLNR

MJAHR

BWART

MATNR

WERKS

DMBTR

MENGE FROM MSEG INTO TABLE I_MSEG FOR ALL ENTRIES IN I_MKPF WHERE

MBLNR = I_MKPF-MBLNR AND

MJAHR = I_MKPF-MJAHR AND

BWART IN ('251','252','561','562','601','602','701','702') AND

WERKS IN S_WERKS AND

LGORT = C_LGORT.

endif.

Suggest me what to do ?

Thanks

kumar

Re: Internal table size

Former Member — Thu, 16 Apr 2009 09:23:32 GMT

Please make a database view on the 2 tables based on the maximum number of filtering conditions.

Now fire your query on this view...

Hope it helps,

Raj

Re: Internal table size

Former Member — Thu, 16 Apr 2009 17:53:00 GMT

do select query on mseg first then on mkpf

Regards,

Lalit Mohan Gupta.