Package size in Submit statement

[Former Member]

Hi Everyone,

I have a requirement wherein I need to call the standard report MB5B using 'Submit' statement in my custom report.

Although, it works fine, but there are huge number of entries and hence the program is dumping. We have an option of 'package-size' for Select queries, but do we have a similar option using 'Submit' statement as well ?

Please advise.

Regards,

Meenakshi

[Sandra_Rossi]

What is the reason of this short dump?

Concerning the "Similar option using 'Submit'...": if you run MB5B with a long list of selection criteria, it should be easy to run MB5B multiple times, each run using a different part of the selection criteria.

[Former Member]

sandra.rossi The customer has huge data but low memory. Hence, the SELECT command sent to the database is too large, causing the memory dump. MB5B program fetches the data from BSIM table (screenshot attached) and this query leads to a dump.

[Former Member]

sandra.rossi Here, the requirement is to fetch data based on material type, posting date, company code and plant. This results into a huge volume of data.

[Sandra_Rossi]

You could run MB5B multiple times, each run with less data to process by using the selection criteria. like defining intervals for the material number (or whatever field you prefer).