PI Daily extract of data from ERP?

[Phil_Southall]

Hello,

We have a scenario where we need to send a csv file full of data through to a third party customer. We were hoping to use PI as the middleware to convert the data from SAP into a CSV file. Does anyone know what we should be using in SAP E.G. IDOC, RFC etc. to distribute the data to PI?

Cheers

[Former Member]

Hi ,

if you need to extract the idoc daily from r/3 side means in r/3 side you need to job scheduling using T.code :SM37. and it will come to XI and covert to the CSV format using receiver file adapter.

Cheers

Meera

[rajasekhar_reddy14]

You can extract IDoc from SAP and convert in to CSV file, using PI you can easily do it.

search in sdn...

[former_member207622]

HI Phil

Go thru the link

http://www.saptechies.com/sap-pdf-books-download/IDOC_to_File_Beginner_Guide_2009061511245120405.pdf

saptechnical web site -

---

Tutorials----/XI/IDocToFile/IDocToFile1

regards

Ninad

[Phil_Southall]

HI,

The IDOC was only an example, what if the data needs to happen once a day and the data is grouped. E.g. sending several sales orders all together, not just one at a time?

Cheers

[former_member207622]

You have three options

1 Idocs

2 proxies

3 RFCs

now depending upon your business requirement lest say you have huge data and you need to select data ouot of few tables do some business transformations on them and the want to send to third party , you can go with proxies

If there is financial data or data which can be addressed by standard IDocs , you can go with IDocs

same is case with RFC's but RFC;s also you need to call in registerd server programs

So searcha ccording to what is your need , all scenarios alre availble on SDN

regards

Ninad