Deletion of Saleorders

[Former Member]

Dear All,

Can any one tell me how to delete the sale orders, we are having 5000 open sale orders, we need to delete all those sale orders at a shot, is there any standard transaction for deleting all the sale orders at a time.

Thanks in advance

Regards

Karunakaran

[Former Member · Accepted solution]

There is no such standard T code available. You can create your own program for putting reason of rejection in all 5000 open sales order so that they will become canceled.

But if you want to delete all sales order from database tables permanently then in your program use Delete query.

choice is yours.

[Former Member]

Hi Karunakaran

You can do another method. If SAP Archiving is implement in your company. You can use archive those sales document so, it will be permanently removed from database

Regards

Nagendra P Boggarapu

[former_member217082]

Hi Karunakaran

First option is , If you have 5000 open sales orders then go to VA05 and maintain the Reason for Rejection for all the open

orders in mass.

Second Option is , using t.code MASS you can put reason for Rejection for all the Open sales orders

Regards

Srinath

[Former Member]

Hi,

There is no T.Code to delete the number of sales orders at a time.

If you want to delete one by one,we can use the T.Code:VA02

Enter the order number.

Click on Sales document in the menu bar.Click on Delete.

For for your requirement you have to use "LSMW".

It is one of the option.

As per my suggestion,it is not advisable to delete a sales order.But we can close it by assigning the "Reason for Rejection".

For this Goto T.Code:MASS

Enter the Object type as "BUS2032".

Click on "Fields".

Check/search for the field name "MASSVBAP-ABGRU".

Select the line.

Press F8 or click on Execute.

Enter your order numbers and item numbers too.

Execute.

After doing this the over all status will be changed to "Completed" only.

We can go for this instead of deleting.

Regards,

Krishna.

[Former Member]

Hi,

Do you want to "DELETE" all sales orders permanently from the data base? In that case you don't have Tx code to do that. You can create a LSMW program to do that.

If you don't want to delete them from the data base & if you satisfy by giving a "Rejection Reason" to those 5000 sales orders, You can do a MASS Change.

To add a Rejection Reason for all Line items in those 5000 sales orders.

Go to Tx: MASS

select object: BUS2032

Then "Sales Order Item Data" table

Execute

Enter all sales order numbers there.

execute again

From "Select Fields" option select "Reason for Rejection"

And enter a new "Reason for Rejection" under new values.

Then press "Carry Out Mass Change" button.

Save

this will reject all line items in those sales orders

Hope this helps you!

Best regards,

Anupa