Skip to Content
avatar image
Former Member

Uploading Excel file to SAP

Hello Experts,

My requirement is to upload excel file to SAP.

I don't want to copy the data of excel file to my internal table instead I want to upload excel file to SAP.

Is it possible,if yes, How?

Please help.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

5 Answers

  • Best Answer
    Jul 26, 2011 at 02:28 PM

    Follow the steps below:

    1 ) Go to transaction OAOR

    2 ) Give Classname as sofficeintegration and class type as OT

    3 ) Select Table temple from the create option ( located at the bottom of tcode, labelled under select a document type or

    application).

    4 ) Right Click on Table Template and click on Import File

    5 ) Locate the file you want to upload

    6) Give the description and press OK

    7 ) Your Document is uploaded into SAP, you can find the same in SOFFICEINTEGRATION->TABLETEMPLATE->(your file name).

    the above path is located in the upper part of the tcode.

    This technology is known as the BDS( Business Document Services)

    Hope this helps

    Regards

    Mishra

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 26, 2011 at 11:22 AM

    Transaction CG3Z. I think you can upload CSV files but not XLS.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 26, 2011 at 11:33 AM

    So, after you upload that file (with GUI_UPLOAD, perhaps) what are you going to do with it if you don't want it put into an internal table? If you're not going to use the data in SAP, there's no need to upload the file. On the other hand, Excel and perahps Open Office and a few other desktop spreadsheets might recognize the data in Excel file. That's certainly not in a format that SAP can utilize.

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 26, 2011 at 10:56 AM

    Hey,

    Do let me know in case you find this direct solution.

    Currently we need PI/XI team to upload the data from application server to a particular shared folder in excel format.

    Regards,

    Kumud

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 23, 2011 at 05:01 AM

    solved.

    Thank you all.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi shubh_ag,

      sorry I did not follow this thread very close.

      By the way, to whom it may concern: I remember a project where a colleague created a 'template handling' class that allowed to store, retrieve and create versions of almost any kind of file - preferredly used for excel files used for special reports. He used the SAP business document services (which is used inside OAER and others). We used class methods

      cl_gui_frontend_services=>file_open_dialog
      cl_bds_document_set=>create_with_files
      cl_bds_document_set=>create_version_with_files
      cl_bds_document_set=>get_info
      cl_bds_document_set=>get_info_newest_only
      cl_bds_document_set=>get_with_files

      and

      FUNCTION 'BDS_BUSINESSDOCUMENT_GET_URL'
      FUNCTION '/SAPDMC/LSM_PATH_FILE_SPLIT'
      FUNCTION 'SKWF_MIMETYPE_OF_FILE_GET'

      and interface

      I_OI_OLE_CONTAINER_CONTROL 
      I_OI_DOCUMENT_PROXY

      for desktop office integration document display

      This was kind of a small document handling system integrated in an own user class object that could be integrated in anyone's program.

      cl_bds_document_set is comparably easy to integrate but extremely powerful tool - warmly recommended.

      Regards

      Clemens