topic Re: Processing some records from internal table. in Application Development and Automation Discussions

Processing some records from internal table.

Former Member — Wed, 04 Nov 2009 10:08:15 GMT

Hi,

My internal table contains material in lakhs.After fetching the record from database table MARA,i process each material to find out its characteristics.As there are too much records it is taking time, resulting in time out error abap dump. If i want to process first 5000 material then remaining 5000 and so on...what logic should i apply?or can there be any alternative solution?

Re: Processing some records from internal table.

Former Member — Wed, 04 Nov 2009 10:14:28 GMT

Hi Nilam,

You can increase the abap dump time.

Thanks

leelakrishna.

Re: Processing some records from internal table.

former_member404244 — Wed, 04 Nov 2009 10:26:46 GMT

Hi,

Please find my suggestions.

1>Have a parameter field in the selection screen for "NO OF records"...so while retrieving data from mara you can select upto the <No of records> specified in the selection screen.

2>Specify the materials in the selection screen to get lless records.

3>Run the report in background and check the output.

Regards,

Nagaraj

Re: Processing some records from internal table.

Former Member — Wed, 04 Nov 2009 10:36:30 GMT

Hi,

You can also check if the read statement has BInary Serach.

By Adding this it will improve performance.

Read statement will occupy lots of time to read the records.

Sort the Internal table with some key field and the use Binary Search for an internal table.

Ex :

SORT T_PRGEN by ATTR20A.

READ TABLE T_V_TCAV201 INTO WA_V_TCAV201 WITH KEY ATTRV20 = WA_PRGEN-ATTR20A BINARY SEARCH.

This should fix the issue.

Regards,

Kittu

Re: Processing some records from internal table.

SuhaSaha — Wed, 04 Nov 2009 10:38:50 GMT

Hello Nilam,

I think if you want to process the Materials in batches of 5000, you need to make use of PACKAGE SIZE concept.

Search in SDN for further details, this type of req. has been discussed many a times before.

BR,

Suhas