sap bods file split
I have flat file as my target in sap bods jobs.
I need to split file each time it exceeds 500 MB.
what could be the best way to do this?
We handle the similar scenario by introducing row numbers to the target table and then split them into multiple files using While Loop.