Help is needed in Sales order User Exits

[Former Member]

Hi

Please Can anybody show the solution to my problem.

My problem is:

Using Table having 2 columns(Customer,Route), we have to display Route(present under shipping tab in Sales Order) in Sales Order. Route has to be displayed based on the customer present in the table.

[Former Member]

hi,

Please try table VBFA with fields VBELV = <sales order> and VBTYP_N = 'J' (Shipping/Delivery).

and also try this also

if you know delivery number for order ,then you could use FM VTTP_READ

if you need delivery number from sales order then use VBAP-VGBEL

pass delivery number to FM or pass the value to VTTP Table

thanks,

<b><REMOVED BY MODERATOR></b>

Message was edited by:

Alvaro Tejada Galindo

[Former Member]

Hi

ROUTE field is present in VBAP and LIKP tables

you can take the KUNNR or KUNAG fields from VBAK/LIKP and copmpare the Partner and Route with the Z table and display that route

<b><REMOVED BY MODERATOR></b>

regards

Anji

Message was edited by:

Alvaro Tejada Galindo