Report which showing with routes along with sales order number

[Former Member]

Hi Experts,

What report will show the routes along with sales order number.

Regards

Anand

[jpfriends079]

From sales order line item you should link Delivery item i.e. VBAP - to LIPS where VGBEL in LIPS is sales order no.

You may get no. of deliveries for an item which is correct.

Then from LIPS you will get to LIKP table and get ship to party for these deliveries.

And using VBFA you can check shipments for this order line item using document category(VBTYP ) Field.

Thanks & Regards

JP

[Former Member]

Hi Thank You All,

I will try the same what are all you said and i will get back for any clarifications.

Anand

[Former Member]

Dear,

Please refer VL06O ---> For Loading / For Goods Issue ---> Item Level (Route / Purchasing Document).

Regards,

Sandip

[Former Member]

Hi VIswanathan,

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)

regards

SAP SD