on 01-19-2008 2:43 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
12 | |
11 | |
6 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.