Skip to Content
0

How do you upload an excel file into APO / SCM?

Dec 07, 2017 at 12:11 PM

79

avatar image
Former Member

Hello

I am trying to write a program with functionality to upload an excel file format 'XLS' or 'XLSX' into an internal table in the APO / SCM environment.

Some of the standard Function modules either do not exist or do not work in the APO environment.

KCD_EXCEL_OLE_TO_INT_CONVERT does not exist in APO, while GUI_UPLOAD brings back only gibberish. The same with some classes.

I found this post which made use of XML transformations and classes,

https://www.sap.com/documents/2015/07/ced1ac7f-527c-0010-82c7-eda71af511fa.html#

but not all the classes such as

CL_XLSX_DOCUMENT exist yet in the version I am working in , i.e.

SAP Netweaver 7.0. They only exist from 7.02.

Does anyone know any way to upload an excel spreadsheet into an internal table in a normal SE38 program in this environment?

Thank you.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Matthew Billingham
Dec 07, 2017 at 12:47 PM
0

Since you are on an old version of ABAP, it will be quite difficult for you to achieve your requirement. Technically it's possible - but effectively you'll have to write your parser or use OLE.

Simplest is to require the data as CSV. That's what was done until it became easy to handle XLSX directly.

Share
10 |10000 characters needed characters left characters exceeded