Uploading Data Daily

[Former Member]

Dear SAP Gurus,

I would like to have some information from you.

I have 3 upload program , which i have to upload daily in SAP to create customers, Invoices and Payments.

This data comes from another non-sap system. And the file format is excel.

What will be the best options to do this ?

like BDC, IDOC ..etc ...

Can you please give me some info.

Thanks

Kunaseelan.

[Former Member · Accepted solution]

Hi Venkat,

If you are using SAP XI as a middleware, then you can go for File to IDOC scenario.

Regards,

Venu V

[Former Member]

Venkat,

These are three different interfaces. You cannot read an excel file directly into XI. Best options ask your end customer to save the excel file in an csv file so that you can read it through file adapter. Once you pick up this file you can send them to sap as an idoc.

Else if csv file is not possible then you may need to come up with adapter module which does this conversion for you.

Or first you can do java mapping which will convert your excel file into xml. Then you can read your xml file and read it into xi.

You can see this help for some information:

/people/michal.krawczyk2/blog/2005/12/10/xi-generating-excel-files-without-the-java-nor-the-conversion-agent-not-possible

/people/sap.user72/blog/2005/07/04/read-excel-instead-of-xml-through-fileadapter

Regards,

---Satish