SAP事务和数据库更新

Question

I would like to start off by saying that am new to SAP and I've done my research but I just couldn't find a solution.

I have to update my database once a transaction has been entered on SAP. The output of this transaction is a txt file and I would like to automatically inject it into my database. I know the structure of the file and the directory where it's supposed to be. I also have a database where to inject it. What am supposed to do is once the customer enters a transaction and the directory is updated with the latest txt file my script has to fetch that file and update database

Is there a way to do that?

Answer 1

I would go with SAP sending data to the webserver. Possible and easy solution:

1, Create a receiver script on the webserver for example accepting POST request (with appropriate auth method). Accept file or array format. This script should insert / update entries to the database.

2, Create a program on the SAP side which fetches the right file from that directory and sends the file or formatted data in array to the webserver. Define a job for periodic processing.