Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Oct 18, 2015 at 10:48 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      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

  • Oct 18, 2015 at 04:44 PM

    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

    Add comment
    10|10000 characters needed characters exceeded