Invoking RFC Enabled BDC from Data Services

dataservices sap-erp-bw
1

Hi,

I am trying to load data into the SAP system by invoking RFC enabled BDC from data services. Records are gettng duplicated in the target, since BDC is called multiple times during job exection. How to restrict the BDC execution only once for all records.

Pls guide.

Thanks

DbUoRdAsI :india: (BOB member since 2012-05-08)

2

waiting for response…

DbUoRdAsI :india: (BOB member since 2012-05-08)

3

There is no reason why one input row would call an RFC multiple times or why one RFC call creates multiple rows. So there is something wrong.

Could be that you generate a Cartesian product because of incorrectly nesting things, maybe?

Can you attach some screenshots so we have a starting point at least? You haven’t provided much input to run with…

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

4

Hi Werner, Thanks for the response… For this scenario we referred this link http://scn.sap.com/docs/DOC-30164. As per this doc, to avoid calling BDC for each record, we can restrict the function to execute only once by using WHERE clause of query transform. i have no idea how to restrict the function call using WHERE clause. Pls suggest. Thanks

DbUoRdAsI :india: (BOB member since 2012-05-08)

5

I resolved the issue using Row_Gen_Transform…

DbUoRdAsI :india: (BOB member since 2012-05-08)

6

Hi DbUoRdAsI,

Can you please elaborate on how you resolved your issue? I have the same.

Thank you

jff (BOB member since 2012-12-20)