topic Package size in Submit statement in Application Development and Automation Discussions

Package size in Submit statement

Former Member — Sat, 29 Oct 2022 11:22:57 GMT

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

Re: Package size in Submit statement

Sandra_Rossi — Sat, 29 Oct 2022 12:45:50 GMT

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.

Re: Package size in Submit statement

Former Member — Sat, 29 Oct 2022 13:08:42 GMT

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.

Re: Package size in Submit statement

Former Member — Sat, 29 Oct 2022 13:14:16 GMT

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.

Re: Package size in Submit statement

Sandra_Rossi — Sat, 29 Oct 2022 13:51:09 GMT

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).