Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

FM MB_ADD_TRANSFER_QUANTITY giving exception CX_SY_OPEN_SQL_DB

rah3
Participant

‎2018 Sep 13 4:28 PM

0 Kudos
950

Hi there!

I am getting runtime error from the FM MB_ADD_TRANSFER_QUANTITY when considerably large amount of data is passed to it's tables.

Below are the two cases, first when I am getting dump and second when I am not.
Just trying to understand the best way to understand this. Is it only because the data is large or something can actually be done to make it work with that amount of data?

Case 1 - No dump

Case 2 - Dump

Dump:

Your comments would be helpful. Thanks!

Rahul.

Preview file
62 KB
Preview file
79 KB
Preview file
90 KB
1 REPLY 1

DoanManhQuynh
Active Contributor

‎2018 Sep 14 7:13 AM

557

That dump is not about the result have too many data. Its because your range table you passed to function module have more records than an WHERE clause can handle. this limit are set in sap parameter (i dont remember which one).

you can also read about this in abapdocu:

The conditions specified in the selection table are passed by the database interface to the database as SQL statement input values. The maximum number of input values depends on the database system and is usually between 2000 and 10000. If the maximum number is exceeded an exception of the class CX_SY_OPEN_SQL_DB is raised.

I think the way to fix it is separate your input (lt_werks and lt_matnr) in properly amount of records.