update travel duration by shipping type wise for particular route

[Former Member]

Dear All,

Business wants to update standard transit time from a route for a particular mode in the system. This can be called as EDD (Expected date of delivery). Ideally this would be a master where business maintains at ROUTE wise, Mode of transport (Parcel, LCV, FTL, TAU, RAIL, AIR or Express etc.,) for a ROUTE.

Example:

ABCD (route)>>>PARCEL>>>3 DAYS

ABCD (route) >>>LCV>>>2 DAYS

ABCD (route) >>>FTL>>>1 DAY

ABCD (route) >>>TAU>>>1 DAY

ABCD (route) >>>RAIL>>>2 DAYS

Can we use route stages to update travel duration by shipping type wise for particular route?  We have created a dummy connection point. Will this get impact any other functionality?

Business wants to use this master for reporting purpose only. Like to compare with actual transit time taken to deliver the goods.

Is the above process ok to implement? Please suggests

Thanks in advance

Regards,

Nagesh

[Former Member · Accepted solution]

Dear All,

Please suggests

[reazuddin_md · Accepted solution]

Hi,

As i understood from your post,

You want to maintain EDD wrt: Route/Shipping type. This data will be used when developing report & compare with actual del date.

     Dont understand why  you want to go with transportation connection point. Creata a Ztable to maintain this master data with relevant fields as mentioned. Hope you are going to develop a zreport to calculate EDD & actual.

Regards,

Reazuddin MD

[reazuddin_md · Accepted solution]

As give in your example,

for single route you have multiple shipping types. Where as in SAP, Route is key field, hence you cant have same route with multiple shipping types. Hence suggested to have Ztable.

Regards,

Reazuddin MD

[Former Member · Accepted solution]

Dear Reazuddin,

Thanks alot for your input, we will go for ztable only

[Lakshmipathi]

Yes in TCode 0vtc, there is a field "Travel duration" which you can make use of this as it will have no impact in delivery scheduling.  There is another field "Transit duration" but that will have impact in your delivery scheduling and since your requirement is just to compare with some master data, you can very well maintain in Travel duration.  This is stored in Table TVRO

G. Lakshmipathi