Skip to Content
Jun 09 at 05:24 PM

Multiple executions when calling BAPI using Data services


Hi All,

I am working on POC to execute call to BAPI from data services.

SCENARIO: For this scenario the source is a text file with 8 lines representing 8 unique records that need to eventually update a custom( Y) table in SAP via BAPI.


This is how the Data Flow looks like.

This is the source file with 8 records

The first Query Transform (QUERY_NEST). This is just creating a dummy table structure with one to one mapping to the data coming from the file ( source).

Next Query transform maps the table data from QUERY_NEST to table input I_MISC_SETTING_RECS of BAPI ( YDSF_LOAD_SETTINGS.

RFC: Only TABLE parameters defined no IMPORT/EXPORT

The RETURN structure from BAPI call query transport is mapped to another Query transform ( QUERY_UNNEST) to map data to another dummy structure which is eventually pushed to a flat file.

ISSUE: In this POC the BAPI is getting executed 8 times ( corresponding to the number of rows in the source file ) when the DATA FLOW (DF) executes from data services.

I have looked at below blog but still don't know where i am going wrong.

Thanks in advance.



pwwrw.png (20.8 kB)
l8yti.png (13.2 kB)
1i6ea.png (71.5 kB)
63jek.png (43.3 kB)
esglw.png (34.2 kB)
6qhi8.png (70.3 kB)