I want copy all line items from VA22

[ajuk]

I want copy all line items from VA22

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

[rajeshk_bhat]

Dear Aju,

Did you try to copy as mentioned in Mr Krishna Kumar's first reply (Apr 16, 2013 8:35 AM )....I think it would be helpfull and solve your issue..if not let me know what was the issue there?

Rajesh K Bhat,

<Moderator Remarks: As per SCN Rule of Engagement, you are not allowed to share your personal details. like email, contact numbers in your post . Please review & adhere SCN Rule of Engagement in your future post & conduct in SCN.>

Message was edited by: Jyoti Prakash

[ajuk]

Yes it is ok now as per Krishnas reply

[ajuk]

Amaraha It is also useful but how i get ABAPER?

[Former Member]

Dear,

Well ABAPER means developer, the person who is involved in programming against various modules of SAP. By the way you're working over Client side?

[ajuk]

Me working as a estimating engineer in a firm and material control through SAP also in my hand.

[Former Member]

Rite. I hope above suggestions can help you out if you've authorization of SE16N or SE11, in case you need further help in this regard do lemme know. Thanks.

[ajuk]

Thanks Ammarah. If I need any help in future i will contact yu. Hope your best response. Thank you soo much

[former_member204407]

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.

[ajuk]

Hai Mr. Krishna I think it is useful but again problem i have no authorization for SE16N. Thank u

[former_member204407]

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.

[ajuk]

This message was moderated.

[ajuk]

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.

[Former Member]

Dear Nair,

For that you've to fetch the data from the table directly VBAK (Header Data) and VBAP (Item Data). Go to SE11 give table name as 'VBAP' (for Item data) in VBELN field give quotation number and execute, there you'll get MATNR (Material number) and all the necessary item details against the given quotation. Export the same to excel sheet for future references. I would suggest you to work over SQVI by using VBAP table in order to read and export the records directly. Let me know if you need more help in this regard. Thanks.

[ajuk]

Ammarah Thanks for information. I have again doubt about this SE11 is same as VA22? I tried but that is not getting in my access. If you give some screenshots for this operation it is very useful.

[Former Member]

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.

[ajuk]

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

[ajuk]

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

[Former Member]

Dear,

For that execute VA22, give Quotation number then go to Environment --> Status Overview then in Overview screen go to System--> List --> Save --> Local File. Here you'll see Header and Item level status of the Quotation. Hope its clear now, lemme know if you need more clarification in this. Thanks.

[Former Member]

Dear  Ammarah

Thanks a lot .....it was working ...once again i am very thankful to u  for sharing ur knowledge

[siva_vasireddy2]

Hi,

   you can also copy all items from the Quotation Directly

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

[Former Member]

Dear  siva  one problem

Va22-- system---list-- save --- but excel and remaining fields are dim mode so if want to activate what we do

I think this process is helpful for all documents right bz i have checked in va02 and va03

plz tell me why excel and all

[Former Member]

Dear check

[former_member184080]

Hi Venu,

I am not sure at VA22 or VA02 level. But, if you want to save VA22 in an excel generate VA25 which will give you list of quotations then you can save them in excel. Similar way, for orders use VA05 or VA05N.

Regards, Sai Krishna.

[Former Member]

Dear sai krishna sir i have tryed in va25 and va05 also but same results

i think some thing i am missing plz share ur knowledge

thank you so much sir

[siva_vasireddy2]

Please check this screen shots

The Best way is to Fetch the Data from the Tables.

[Former Member]

Dear siva

thank you for sharing but i don't  know  in my system , it is showing dim last one

[Former Member]

Dear siva vasi reddy

plz provide how to solve the issue plz bz last one is dim mode

we are thank full to you

[former_member184080]

Hi Venu / AJU,

I am not sure how Siva is getting this info from VA22. But, you can try from VA25. Check the screenshot.

Or the best way is use tables.

Regards, Sai Krishna.

[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

[sarthak_mohantysd]

Hello Nair,

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

Thanks,

Sarthak

[former_member518143]

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.

[former_member184080]

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.