Mapping the Data in XML to the corresponding fields in R/3 Database Table.

[Former Member]

Hi all,

My requirement is to read an XML file and the data in it is coverted to R/3 Data fields.Where the corresponding fields are mapped to a Database Table created in R/3.

Can anybody tell me the process how to read the data from xml file and mapping the fields in xml to the fields in R/3 Database Tables..?

Thanks in Advance.

Thanks,

Prakash.

[Former Member · Accepted solution]

u can go for file to proxy scenario.

read the file using file adapter

Do the mpaping in XI

Pass the data using XI adapter to R3 system using proxy

Write a abap program which will update the data in R3 table.

Now clarify few things

Wat is the file format if its csv or fixed length then u have to go for file content conversion.

Follow the below blog:

Server Proxy -

File to Inbound Proxy:

chirag

[Former Member]

Hi Surya

Can anybody tell me the process how to read the data from xml file and mapping the fields in xml to the fields in R/3 Database Tables..?

This depends on where exactly the XML resides. You can use File adapter and use FTP to read this XML, HTTP adapter to get it posted from the source server. Bring in as a webservice using SOAP adapter.

To deliver it to R/3. You can use RFC (preferred if no changes or processing required before delivering to database) or ABAP proxy.

IDOC is also one option that depends on your business requirement.

Whats the business requirement exactly?

Thanks

Gaurav

[agasthuri_doss]

Hello,

It depends on the system from where you are getting the XML file, Depending on that you can use anything like Http, Soap, JMS,File Adapters,

To Post the data to R/3, You can use IDOC if it available, BAPI , Proxy as per the requirement

Cheers

Agasthuri Doss