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
Your comments would be helpful. Thanks!
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.