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.