Periodic LSMW or RPA?

[ando1692]

Hello there,

In our company we use LSMW transaction for uploading a .txt file (from local computer) that updates some master data. Currently the SOP for this is:

1. Master data .txt file is generated and sent to a person
2. This person opens SAP GUI and using LSMW uploads the file and data is updated in SAP

We definitely want to automate this. I have couple of ideas about this (I am no SAP expert at all):

• Idea 1: Use RPA software (e.g. Power Automate Desktop) and automate the process
• Idea 2 (my instinct says that this one is better): Can this LSMW object be scheduled to be run somehow? I mean, we could make an automation to place this input .txt file in SAP application server and this job could be run (e.g. every 1h) and upload those files via LSMW automatically. Is this possible? How can I do this? (also, it would be great that the team could see the status of the upload somehow, receiving emails or some kind of notification about the successful/unsuccessful transactions)

Thank you!

[wuttichai_s]

Yes, it's possible to use RPA to automate this process. We can leverage software such as Power Automate Desktop or other RPA tools to create bots that handle the file upload (.txt) and data update in SAP automatically. This will help reduce the time and effort required by individuals and can also operate during non-working hours, enhancing overall efficiency.

[ando1692]

Is it better than using the period option in LSMW? In my head it's more efficient setting up a periodic ingestion, where another middleware could place this input .txt file in the SAP server