Skip to Content
author's profile photo
Former Member

Uploading excell into SAP

Hi jedi masters

Does SAP have a facility that allows the upload of spreadsheets e.g. excell?

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Best Answer
    author's profile photo
    Former Member
    Posted on Aug 20, 2007 at 05:15 PM

    Hi,

    Yes, SAP does facilitate excel upload.

    Please go through the following links to find details about excel upload to SAP:

    /people/kathirvel.balakrishnan2/blog/2006/05/08/data-upload-into-sap-from-microsoft-excel-150-abap-part

    /people/subramanian.venkateswaran2/blog/2006/10/02/enhanced-file-upload--uploading-and-processing-excel-sheets

    /people/sap.user72/blog/2006/01/19/upload-data-from-multiple-worksheets-within-a-single-excel-file-into-internal-table-from-abap

    <b>Reward if helpful.</b>

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Aug 20, 2007 at 05:42 PM

    Spread Sheets like Excel can be easily loaded into SAP by using LSMW or BDC.

    LSMW: Legacy System Migration WorkBench.

    BDC: Batch Data Communication.

    All the master data is provided by the client in form of spread sheets and the role of the consultants is to upload it using LSMW, BDC etc. If you need further info about LSMW, post your mail ID. I will send material on it.

    Regards

    AK

    Reward points if helpful.

    Add comment
    10|10000 characters needed characters exceeded

  • author's profile photo
    Former Member
    Posted on Aug 20, 2007 at 06:05 PM

    Their are many mathods to uploade the exel sheet but it matter why and what you nee to upoade the exel **** .

    Posible way are LSMW,SCAT, or write a BDC with the help of abaper

    please send the senerio for

    If master uploade LSMW or BDC is good option or you can use SCAT also

    Reward points if helpfull

    RG Ajit

    Add comment
    10|10000 characters needed characters exceeded