I had developed a report which takes records from an input excel file and depending on the choice made, uploads them to 5 different tables. There are many validations and code in place. The input excel file has multiple columns which defines the fields it should go into and then after validation, the report uploads them to the table.
The User now says that he is not able to upload more than 2000 lines at one go. They are definitely not using the old version of Excel, I am sure about that, which I guess had a limit till 65k records or so. Can anyone let me know what might be the solution to this or is it a standard behaviour of SAP? I tried finding a solution to this in the forum, but couldn't get one. Hence, thought to post it here.
Any approach or input would help. Thanks!