topic Re: Interfacing SAP with PLC in Application Development and Automation Discussions

Interfacing SAP with PLC

Former Member — Thu, 13 Nov 2008 14:33:26 GMT

Hi all,

Is it possible to interface SAP R/3 with PLC?

My requirement is to collect data from PLC into SAP..

If it is possible, kindly let me know some hints to proceed further.

Regards,

Prem

Re: Interfacing SAP with PLC

Former Member — Tue, 16 Dec 2008 11:58:56 GMT

Yes this is possible to interface PLC with SAP.

But need details of which type of data is to be transfered and time of refresh.

Also the model number of PLC, manufacturer and SAP version are very specific.

I searched on the internet for the same and found some good examples

Since i have studied PLC and SAP so i understood most of it.

But if some one is not familiar with either then it need bit effort and team work.

Step by step

The steps involved in the implementation are:

1. Identifying data required for the daily production report.

2. Identifying which data was polled and stored in the PLC system. Some were available as totalised tags predefined in the PLC system. In some cases, they had to be created and totalised for the dayu2019s value.

3. Mapping these tag numbers to the fields in the temporary database.

4. Developing the RFC in SAP which could collect data in a process message format for further processing in SAP.

5. Setting up and configuring SQL agent to pick up data from PLC and dump it into an SQL database.

6. Setting up a SAP agent to push data from SQL database to SAP tables.

7. Developing an application interface to:

Download process recipe from SAP once a month or as and when there is a change.

Develop a data-entry screen to display data from PLC temporarily stored in a database, for users to edit and enter additional data that is not collected by the instruments (stoppages, reasons for stoppage, etc).

8. Saving and sending data to SAP.

Please discuss more details of the requirement to continue the discussion.

i would be glad to help

Re: Interfacing SAP with PLC

Former Member — Wed, 12 Feb 2014 12:05:11 GMT

could u pls elaborate further each step with suitable example.

It will be a big favour if there is any practical document sharing for the same

thanks and regards

nikhil chawla (9717775857)

Re: Interfacing SAP with PLC

Former Member — Fri, 21 Feb 2014 09:06:34 GMT

Hi every one

Please suggest me how to interface the SQL server database with the SAP ECC especially in PP

Production consumption and there movements need to be tracked and that data fields are required to be tranfered from and to the SQL database.

Response will be highly appreciated

Thanks and regards

Nikhil Chawla