Problem Calling SAP RFC with input parameter of type TABLE

dataservices sap-erp-bw
1

Hi,

Currently it calls the RFC once for each record in the input table parameter. How can I make it call the RFC ONLY once… passing all data in table parameter?

Thanks!

jff (BOB member since 2012-12-20)

2

Your query where you prepare the nested data, there you have the different From clauses for each nested level. In the root level (query) it seems to be the table, in the nested schema a Row_Gen. Hence you call it query times with one Row_Gen row each.
Swap the From clauses, then you call the function Row_Gen times with Query many rows.

Werner Daehn :de: (BOB member since 2004-12-17)

3

Thanks Werner - got it working. As you suggested, I made the changes in the QT prior to the QT that calls the RFC. In this QT I activated only the row_gen in the FROM clause of the parent node and in the child node (table) I activated only the table in the FROM clause.

Thanks again!

jff (BOB member since 2012-12-20)