sales order report

[Former Member]

All,

I am looking for a sales order reprot which will show the sales orders and routes. Is there any standard report i can use or any query. If someone can guide me step by step to creating a query for this, that would be GREAT!!

thanks

[Former Member · Accepted solution]

As far as i know there is no standard report which shows the route along with the sales order number.

You may have to create a Query using

VBAK- sales order header and with VBAP table.

Link the VBAK-VBELN to VBAP-VBELN and get the details of VBAP-ROUTE

Or directly using the VBAP table and field VBAP-ROUTE you can get the details like sales order number (VBELN) and Route (ROUTE)

Thanks

Aman

[Former Member · Accepted solution]

Aman,

Thanks for your reply. I am new to queries. Can you give me step by step for this?

[Former Member · Accepted solution]

Go through the attached link.

http://www.saptraininghub.com/all-about-abap-query/

Thanks

Aman

[Shiva_Ram]

You can download this directly from table VBAP using t.code SE16.

Regards,