How to see all sales orders above order value 10000 usd

[Former Member]

Dear all,

We wanted to create a report which shows all sales order those are having more than 10000 USD order value.

I have tried to list using SE16-->VBAK table, but I have not succeeded.

can any of you suggest me how to list sales orders those are more than a specific amount of order value.

Is there any standard report for this kind of requirement?. Your suggestions will be highly appreciated.

Thank you

[Former Member · Accepted solution]

Hi Raghu,

Absolutly you can create a report . take the field VBAK- NETWR ( Header) VBAP -NETWR ( Item) based on the sales order. you can create simply. with these fields.

if you give me brief i can help you out more.

if helpful REWARD points

Thank you .

Regards

Ramana

[Former Member]

I think it can be done using VA05 or VA05N in case of ECC. Enter selection parameters & Select radio button for All Orders.

The list is displayed in ALV where columns can be sorted or filtered. Select net value and then click on filter icon here u can provide doc currency USD and choose multiple options for net value and select gretaer than equal to snd it will display the repective sale orders.

Anya

[chaitanya_deodhar]

Dear Raghu,

Goto transaction SE16

Select table VBAK and enter

Select Menu>> Settings

Select --Field for Slection

Select NETWR ( Net Value) and VBLEN Sles Doccument

Enter

Selct Net Value : Multiple secetion Arrow

Select Function F and selct greater than

Put value as 10000

Execute the transaction you get all the orders having value more than 10000. If you are using multi currency select the currency filed and put it as dollers( Filed VBAK_WAERK)

Regards,

Chaitanya