Integration between third party software and SAP

[Former Member]

Hi all,

I have requirement in which i have to integrate SAP with third party software. My third party software will be generating material no as we generate in SAP then after the generation of the Material No by the third party software again i have to pull the material no generated and corresponding information into SAP .Please tell me how to do this as i am new to these concepts and if possible please send links from where i can download study materials.

Thanks and Regards

Manu.

[Former Member]

Hello Manvendra,

There are many approches for solving this integration issue:

But before solving this issue there are few questions which need to be known:

1. In what form the material no list is generated? i.e. some flat file, in database table, or shared memory

2. What is the language for 3rd party software? C, Java, .Net etc

3. What is the frequency of material number generation? i.e. is it on demand, batch processing etc

Considering 3rd party software is generating flat file or csv files for material number we can have this integration in

following way:

1. Save file at particular location.

2. You can configure logical path in FILE transaction

3. Write ABAP report to read that file using logical path and file name.

Refer following link for Link: [logical path creation|http://help.sap.com/saphelp_nw04/helpdata/en/8d/3e4ec2462a11d189000000e8323d3a/content.htm]

4. Read file into internal table using Link: [GUI_UPLOAD|http://saplab.blogspot.com/2007/10/sample-abap-program-to-upload-table.html].

5. Create BDC recording for MM01 transaction for material creation using Link: [SHDB|http://abaplovers.blogspot.com/2008/02/recording-bdc-using-transaction-shdb.html] transaction code.

6. Using data from internal table and BDC recording create all the materials in SAP systems.

In this step you need to loop at internal table and fill data variables in BDC recording with the internal table data

and call the transaction MM01 for creating material.

Above steps are very high level guidelines and it is one way of integration but concept wise more or less integration will be in same way!

You can definetly fine tune it by exploring SAP help!

Enjoy SAP!

Thanks,

Augustin.

[Former Member]

Hi Augustarian

Thanks for the reply. Can you exlpalain me the scenario if we use bapi and the other thing is if my data is getting saved in the third party software database table. We are using dotnet to develop our third party software.

Please suggest if step by step procedure for BAPI. And also the case if data is stored in Database table of third party software.

Waiting for ur reply.

[Former Member]

Hello Manvendra,

In case material no's are getting stored in 3rd party database table then there are following approaches:

1. Writing BAPI in SAP to call BDC recording in SAP for creating material.

In this case you need to create .Net proxy in your .Net code.

SAP .Net connector provides facility to create proxy of the remote enabled function module.

So, Once you create remote enabled function module then call that RFC using .Net proxy and post material data into SAP

2. Writing Web Service in .Net that will read all the material numbers from data base and return to SAP system.

In this case normal .Net web service will be written, which will output all the material numbers from the database.

Create proxy of this .Net web service in SAP system using SPROXY transaction using WSDL of .Net proxy.

Now, ABAP program will consist of following steps:

a. Call proxy to get the list of material numbers.

b. Load material internal table with the out put of web service.

c. Loop at internal table and call BDC recording to post material using material data from internal table.

Now good thing about this approach is you can schedule background JOB for this report for a particular interval

if your requirement allows.

Let me know in case you have more questions.

Hope this helps!

Thanks,

Augustin.

Edited by: Augustarian on Aug 20, 2009 8:41 PM

[Former Member]

HI,

If we save the data in csv format in third party software.then can we use bapi to update material in sap master tables.

Please suggest me how to do these step by step.

[Former Member]

Hello Manvendra,

Please refer to my first post in this thread. Step 1 to 6 are given for using csv file approch.

Also the link's for require study material is already provided.

Apart from that, you can remove logical file path time being and hard code the file path in bapi for reading CSV file.

Steps for writing BAPI

1. Create remote enable function module in SE37 transaction.

2. First read csv file using GUI_UPLOAD into internal table.

3. start loop at internal table

4. load BDC recording variables with the internal table record values

5. execute BDC for posting material

6. go for next loop of internal table

You simply need to call this BAPI from .Net proxy.

Also, it is possible to update material master tables directly but I would suggest to use BDC recording so that it will

cover most of the views of material master.

Let me know if any specific question you have?

Thanks,

Augustin.

Edited by: Augustarian on Aug 20, 2009 10:17 PM