Function module for Excel file upload

[Former Member]

Hi,

I am new to APO technical. My requirement is upload excel file data. However commonly used FM in R/3 for uploading excel files from presentation server are not avaliable ( KCD_EXCEL_OLE_TO_INT_CONVERT , ALSM_EXCEL_TO_INTERNAL_TABLE , TEXT_CONVERT_XLS_TO_SAP etc) in APO system(SCM 4.0 version).

Let me know if there are any other FM avaliable and procedure to upload the excel files in APO?

Please let me know if you require any further details.

Regards

Reddy

[Former Member]

Hi

The data structures in APO differ from R/3 (e.g. data is held in livecache tables) and hence the FM's you mention will not work in APO.

Try looking at the Wiki pages as there is a lot of useful information there for you, e.g. this example code to download and upload data between Excel and APO:

Link: [Download SCM data into Excel|http://wiki.sdn.sap.com/wiki/display/SCM/DownloadPlanningdataintoexcel]

Have a look around the Wiki, hopefully it will help you out

Regards

Ian

[Former Member]

Hello,

There is a standard functionality available within APO to load data from excel to APO. This is through loading excel data to an info cube and then using RTSINPUT_cube program to load data in a planning area.

Ashutosh