can we send .csv file from sap srm system to sap pi?

[Former Member]

Hi Experts,

we have 3 options send the data from sap systems to sap pi.i. e.proxy,idoc and rfc only

How can we send .csv file from sap srm to sap pi?

Regards,

Anjan

[Former Member · Accepted solution]

Hi anjan,

Out of curiousity, why do you want to send .csv file when you have good options like Idoc, RFD and Proxy.

What is your target system? From PI where are you sending it back.

If the target system requires only .csv file, you can still use proxy to send the data to PI and using Receiver FCC, you can convert and send it across to the target systems.

I would always recommend using SAP's propreitory methods like RFD, Idoc and Proxy.

Regards

Krish

[Former Member · Accepted solution]

Hi Mr.Raj,

Thank you for updating,

As mentioned in your answer is option 1&2 are not cleared,

Please some eloborate the answer,

Warm Regards

Anjan.D

[Former Member · Accepted solution]

Anjan

As you know SAP SRM and SAP PI are different boxes.

 *_Option 1:_* 
we need a shared AL11 directory in between SAP SRM and SAP PI (Ask basis to setup shared folder). Place / Populate the file in the folder from SAP SRM and then it can be picked through sender file communication channel.

In this case you (Basis team) will share one folder which is visible from the AL11 transaction of both the systems (SRM and PI). You will drop .csv file using some report or program from SRM at this location and from PI you can read that file using File communication channel (NFS mode).

Option 2: 
Setup a FTP at SRM environment and expose some folder which can be accessible from PI. Use sender file communication channel at PI end to pick the file.

You can use this option incase sharing of folder is not possible (due to network / other constrains). Here FTP server is required to expose any folder as FTP so as it can be accessible from internet (remote location). You need to expose some folder at SRM machine. You will drop .csv file using some report or program from SRM at this location. Now PI can fetch the file from that location using sender file communication channel (FTP Mode) providing user credentials.

Hope it clears now.

Regards

Raj

[Former Member · Accepted solution]

Hi,

My problem is solved,

Thanks to Raj,Naveen and Spantaleoni.

Regards,

Anjan.D

[Former Member]

You can follow this simple solution:

SRM Create .csv file -> Sap PI pickup the file with FTP Sender Channel -> Message Mapping -> Sap PI write the file in the destination System with FTP Receiver Channel

[naveen_chichili]

Hi,

As you need to send .csv file from SRM system you have to use file adapter which will pick the file from some location from SRM system.

Regards,

Naveen

[Former Member]

Anjan

To send .csv file from sap srm to sap PI, You can go like this:

Option 1:

we need a shared AL11 directory in between SAP SRM and SAP PI (Ask basis to setup shared folder). Place / Populate the file in the folder from SAP SRM and then it can be picked through sender file communication channel.

Option 2:

Setup a FTP at SRM environment and expose some folder which can be accessible from PI. Use sender file communication channel at PI end to pick the file.

Regards

Raj