Showing results for 
Search instead for 
Did you mean: 

How to see all sales orders above order value 10000 usd

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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 .



Answers (2)

Answers (2)

Former Member
0 Kudos

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.


0 Kudos

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


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)