Skip to Content

How to upload line items in ME51N from an Excel

Hi Experts,

Our users want to upload line items in PR (ME51N) by importing data from Excel to SAP by staying in ME51N screen itself.

Is there a way in ME51N to import (not to copy) data from excel to SAP.

Copying data from Excel and pasting into SAP is a very time consuming job for users. Kindly suggest a workaround for it.

PS: I don't want to go by BAPI's to upload it because if I could get it in ME51N itself then it would be an add-on feature for us all.

Thanks & Regards

Saurabh

Add a comment
10|10000 characters needed characters exceeded

Related questions

11 Answers

  • Posted on Dec 03, 2014 at 02:35 PM

    Hi,

    I do not see option to simply do it in ME51N - if you have all data in excel why would you like to run ME51N at all?

    In our landscape we created LSMW based on this BAPI object:

    Business Object BUS2105

    Method CREATEFROMDATA1

    Message Type PREQCR1

    Basic Type PREQCR101

    and create batch of requisitions with it (it produces idocs which are processed into requisitions)

    BR,

    Tomek

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 03, 2014 at 03:17 PM

    Hi,

    Up to EHP6, there is no direct import option in Enjoy transactions, as of my knowledge. You may either maintain the user specific and parameters in personal settings in ME51N itself (or through parameter ID), so that user doesnt need to enter these data every time. For the remaining data, hide the header and item details in ME51N, so that maximum items can be displayed in ME51N and then copy paste from excel.

    If you need to import directly from excel, then the option would be direct upload using BAPI.

    Regards,

    AKPT

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 03, 2014 at 03:59 PM

    Upload a file is not possible with any creation / change transaction code. It is possible only with recording method LSMW or a bapi method.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 03, 2014 at 07:04 PM

    Dear Saurabh,

    As far as your question regarding "Copying data from Excel and pasting into SAP is a very time consuming job for users." and you don't want to used BAPI as well, than you have no other option other than AKPT, and DEV mention in earlier comments i.e. either go for LSMW or for BAPI.

    Best Regards

    Mohsin Abbasi

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 04, 2014 at 12:19 AM

    Hi,

    ME51N is enjoy transaction and LSMW and BDC don't work with enjoy transaction. You have only one option to create PR from excel is BAPI

    Regards,

    Ashish

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 04, 2014 at 02:08 AM

    This may be possible from EHP6 via transaction MEMASSRQ. From EHP6 you should have access to an "Upload Data from File" button.

    This document gives directions for material changes but the same process should apply for requisitions http://scn.sap.com/docs/DOC-59636

    For materials it appears only change is supported but this may not be the case for requisitions. Sorry I don't have access to EHP6 system to verify.

    Add a comment
    10|10000 characters needed characters exceeded

    • The document explains upload function for mass changes, the discussion here is about creation of items, which is not possible with a upload in MEMASSRQ.

      Honestly, Isn't it a wrong approach to maintain anything in Excel instead of directly going into SAP? You actually have to type the same info into Excel if the data should be ready for an upload into ME51N as requested. So where is the benefit in doing it with Excel?

  • author's profile photo Former Member
    Former Member
    Posted on Dec 04, 2014 at 09:12 AM

    Hello All,

    There are indeed various options to try to use standard features, I just would like to add here, that it is possible to implement exactly the requirement from the OP, below a screenshot for a similar functionality that we realized :

    There are 2 options, the Paste clipboard is generally used when there are only a couple lines to copy-paste from somewhere whereas the "Import Excel" is exactly update the line items from an excel spreadsheet.

    The file format replicates the item layout and imported, investigate how to integrate the function in your design, some starting point could be


    CALL METHOD cl_gui_frontend_services=>file_open_dialog

    CALL FUNCTION 'TEXT_CONVERT_XLS_TO_SAP'


    and so on, now the integration from XLSX is also possible.


    Discuss the various options with your ABAP team and .... go ahead !!


    Alexandre


    Capture.PNG (7.2 kB)
    Capture.PNG (1.5 kB)
    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 05, 2014 at 09:42 PM

    This message was moderated.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 06, 2014 at 06:28 AM

    Hi,

    Pls maintain the data sequence like sap ME51N in excel sheet and copy all line items and then open ME51N and click on customize local layout->clipboard and then do paste button.So,whatever you have copied in excel sheet data ,they will be copied into ME51N.

    Note:1. Pls keep cursor in field item before you click on button paste.

    2.The above way will work for header level only not for item level.

    BR's,

    KNR


    1.png (139.8 kB)
    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 06, 2014 at 06:59 AM

    Hi, in EHP 6 only save as template and load from template is possible.


    ME51N.PNG (4.0 kB)
    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.