topic Re: Use commit when calling RFC in enhancement in Application Development and Automation Discussions

Use commit when calling RFC in enhancement

bin-general — Thu, 09 Nov 2023 05:59:34 GMT

HI！

When I use MIGO~MB_DOCUMENT_BADI~MB_DOCUMENT_BEFORE_UPDATE,

CALL RFC:

CALL FUNCTION 'ZSD_MIGO' STARTING NEW TASK 'NONE' DESTINATION lv_system
   TABLES
      t_item = lt_item.

AND I Need to store log tables in RFC: ZSD_MIGO. When not using COMMIT WORK, there is no guarantee that data will be saved to the log table every time. Can I use COMMIT WORK in RFC when enhancing it?

Re: Use commit when calling RFC in enhancement

Sandra_Rossi — Thu, 09 Nov 2023 09:42:17 GMT

Did you try it?

Re: Use commit when calling RFC in enhancement

bin-general — Thu, 09 Nov 2023 10:21:38 GMT

Hi Sandra,
Yes, I have tried and there were no mistakes. But I'm not sure if doing so will affect the use of the tcode MIGO.

Re: Use commit when calling RFC in enhancement

Sandra_Rossi — Thu, 09 Nov 2023 12:46:34 GMT

Thanks. So it works as you wish, but you're asking for general recommendations about asynchronous and MIGO.

This kind of solution may not be good because of the LUW concept. You should commit all data which are interdependent at the same time (save all or none). Data committed in RFC and data committed in MIGO are not linked, so you'll get save partially instead of save all or none.

But maybe you don't mind having data saved by RFC (in ZSD_MIGO) while data is not saved by MIGO (RBKP, etc.) and vice versa.

Re: Use commit when calling RFC in enhancement

bin-general — Fri, 10 Nov 2023 03:45:11 GMT

Thank you. I see your point,thank you for your answer

Re: Use commit when calling RFC in enhancement

matt — Fri, 10 Nov 2023 08:12:27 GMT

For logging, rather than use an RFC you could a service connection

INSERT demo_update CONNECTION R/3*service_conn
  FROM @( VALUE #( id = 'X'  col1 = 1 col2 = 2 col3 = 3 col4 = 4 ) ).
COMMIT CONNECTION R/3*service_conn.

Re: Use commit when calling RFC in enhancement

Sandra_Rossi — Fri, 10 Nov 2023 18:28:24 GMT

NB: updating via a secondary database connection is exactly the same question, they are both completely independent: the primary commit won't commit the secondary database updates and vice versa.

Re: Use commit when calling RFC in enhancement

chaouki_akir — Mon, 13 Nov 2023 19:56:26 GMT

What do you have in lv_system ? Is it really an other SAP system ?

Re: Use commit when calling RFC in enhancement

bin-general — Tue, 14 Nov 2023 02:21:02 GMT

HI！The lv_system is not an other SAP system,Is the current system.The use of lv_system is to avoid permission verification