We have a bapi function that we want to run in the background job rather than stream mode. Is there a way in BODS to run the bapi call in the background? The reason is we have a 2 hour time limit to run a stream mode job and we are currently timing out. If it runs in the background job, it can run longer. Does anyone know if this can be done?
elainezaleski (BOB member since 2012-02-16)
Cannot be done.
Are you loading on a record by record basis or one huge nested table that SAP has to process in one go?
Johannes Vink 
(BOB member since 2012-03-20)
It is 1 huge nested table
elainezaleski (BOB member since 2012-02-16)
How about splitting it up into batches?
Werner Daehn 
(BOB member since 2004-12-17)
Did not check my config, but often with nested tables the data is offered in huge set to SAP.
Add a row_generation and join that at the header level. It is a carthesian join, but multiplied by 1 it does not matter. This forces to load on a record by record basis.
Johannes Vink (BOB member since 2012-03-20)
We ended up doing what you mentioned and now we have a new problem. The bapi goes against a cube for forecast and sales data. In the one job we only want to get the forecast data, so the sap developer changed the bapi to have an input parm. If the value of the input parm is ‘X’ it will read the forecast data. So in the function, we added the input parm value to be ‘X’ so it looks for the forecast data, and we are now getting the following error message:
Function has an input parameter that is a nested table type and it is not mapped to a column reference. A nested table input parameter can only be mapped to a column reference. I have no idea what this means. Could really use help on this.
elainezaleski (BOB member since 2012-02-16)