Application Development 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
Showing results for 
Search instead for 
Did you mean: 

FM MB_ADD_TRANSFER_QUANTITY giving exception CX_SY_OPEN_SQL_DB

rah3
Participant
0 Kudos

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.

1 REPLY 1

DoanManhQuynh
Active Contributor

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.