Skip to Content

I want copy all line items from VA22

I want copy all line items from VA22

SCN Moderator: Discussion moved from About SCN to SAP ERP Sales and Distribution (SAP SD)

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

11 Answers

  • Apr 18, 2013 at 07:43 AM

    Hi,

    go to T-code: SE16n, give  Quotation numbers in from value and  To value (if you want to check multiple) or you want to check single document give only one document in in "from value"

    click on Execute.

    it will display list of quotation with item details.

    click in "export" button choose "local file"

    select "spread sheet" radio button press enter.

    provide details where you want to save

    click on "Generate" button

    it will display message like below based on your file size.

    now check your excel where you mentioned the path (because I mentioned excel file path to Desktop).

    I hope it helps to you.

    Regards,

    Krishna.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 11, 2013 at 06:35 AM

    Hi,

    Use SD community for this: https://scn.sap.com/community/erp/sd

    And you have to explain what you want to copy from where to where?

    Regards, Sai Krishna.

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 11, 2013 at 10:23 AM

    Hello,

    Quotation document items are available from table VBAP as they are sales document. You can also use table view VIVEDA which combines both VBAP and VBAK information.

    Have a nice extraction.

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 12, 2013 at 09:59 AM

    Hello Nair,

    Could you be more clear in terms of Question "I want copy all line items from VA22" ???

    Thanks,

    Sarthak

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 13, 2013 at 07:24 AM

    Hi,

       you can also copy all items from the Quotation Directly

    VA22--  (Cntrl+Shift+F2)---system--list---save---Excel

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Yes sai sir it is working in va25 but what siva told it is not working

      may i know in ur system is is working .... thank you so much

  • Apr 14, 2013 at 12:18 PM

    Dear Siva sir it is the same VA22 screen? Then the same problem me too hve which Mr. Venu said above the last one is dim

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 14, 2013 at 12:37 PM

    Please give solution for the above as Mr. Venu said becoz the option is not active it is inactive in the screen

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 15, 2013 at 07:03 AM

    Ammarah

    Thanks but it is saving only the sales document details. In sales documents i entered several items. I want copy that to excel. If do like that we can use that items later in similar sales document.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member AJU K. NAIR

      Dear,

      Try this, i'm sharing snapshots. One more thing if you dont've authorization for SE11 over your PRD server ask ABAPER to provide you desired info by exporting the same to excel file.


      1.jpg (46.4 kB)
      2.jpg (78.7 kB)
      3.jpg (46.0 kB)
      4.jpg (85.7 kB)
  • Apr 16, 2013 at 06:35 AM

    Hi,

    did you try like this??

    Go to T-code: VA22

    Place the cursor in line item 10 (center of the box)


    Press "Ctrl + Y" then drag it by using "shift" then press "Ctrl + C"


    open New excel sheet then Press "Ctrl+V"

    Regards,

    Krishna.


    Add comment
    10|10000 characters needed characters exceeded

  • Apr 18, 2013 at 02:43 PM

    Amaraha It is also useful but how i get ABAPER?

    Add comment
    10|10000 characters needed characters exceeded