cancel
Showing results for 
Search instead for 
Did you mean: 

Transfer data from CSV file to SAP database table using SAP PI

Former Member
0 Kudos

Dear Experts,

I have a scenario where I want to transfer data using SAP PI.

The source file is a Standard CSV file
The target is SAP Data Dictionary Table

I believe I can achieve this using ABAP to read the CSV file to internal tables and insert data in SAP tables but the scenario needs the use of SAP PI.

How could this be achieved? Can it be achieved directly using SAP PI? or do I need to convert file to another format first?

Thanks in advance.

Best regards,

Omar EL Halawany

Accepted Solutions (1)

Accepted Solutions (1)

arunneerolil
Contributor
0 Kudos

Omar,

You can achieve this easily using PI.

Configure file content conversion in PI file sender adapter to convert CSV to XML.

Refer the links below for details.

http://wiki.scn.sap.com/wiki/display/XI/Step-by-step+FTP+to+ABAP+Proxy

http://www.riyaz.net/sap/xipi-file-content-conversion-for-simple-structure/75/

regards,

Arun

Former Member
0 Kudos

Dear Arun,

Thanks for your quick reply.

Yes, I found many solution to this scenario but I wasn't sure which one to use.

Thank you so much for your help. I will follow the one you mentioned.

Best regards,

Omar El Halawany

Answers (1)

Answers (1)

former_member186851
Active Contributor
0 Kudos

Hello Omar,

You can configure file to Proxy scenario in sap PI.

Do a FCC to read files and map it to targer proxy structure.

http://wiki.scn.sap.com/wiki/display/XI/Step-by-step+FTP+to+ABAP+Proxy