Monday Knowledge Snippet (MKS) – 44 Distance Determination without Location Coordinates
Following up on post MKS 20, this MKS is an update on what happened in the meanwhile and brings live to a real example.
Remember, the requirement was to do a detailed and high quality distance determination between locations without the need to geo-code them (so basically all locations are geo-coded on country or country – region level meaning that a lot of locations share the same coordiantes). For example having a distance matrix at hand based on postal codes, or location SCAC codes, it is in standard SAP TM still required to have the locations enriched with distinct coordinates to access the data source. The suggestions made in MKS 20 worked for some customers, but we thought it would be great to enhance the framework.
Going for the approach to use artificial coordinates seemed to be the most efficient way to solve this issue. But this required some adjustments to the GIS integration framework. First of all it answered location pairs having the same coordinates very early with a distance of zero, what is good for performance. But as this can now lead to other results, it was necessary to pass all of those requests through the framework. Next step was enabling the adjustment of the location data. So far only the distance requests and results where passed, but to add artificial coordinates requires to have this data within the determination method.
Those adjustments are available with the SCMB notes:
1997058 Distance Determination not possible for locations with same coordinates
1999615 Distance Determination: Location data can not be adjusted
In my test scenario, I have created locations spread all over Germany, gave them postal codes (~9000), but left the geo-coordinates on country level. Then I implemented the access to a postal code based distance matrix having results for all combinations.
I setup a custom distance determination strategy and assigned it to my means-of-transport. For each location I added unique artifical coordinates (simply a counter 1,2,3…) and added this information to the location data passed through the framework. Then I determined my results, mapped this back into the standard result table based on coordiantes using my just created coordinates, and here we go – the distance was used all over SAP TM!
How it can be done is covered in a solution concept attached to note 2001921 – Distance Determination for SAP Transportation Management using
Location Attributes (always newest up-to-date version).
Feedback is very welcome!
Marcus
Here is the LinkedIn Discussion: Monday Knowledge Snippet (MKS) - 44 Distance Determination without Location Coordinates | LinkedIn
Hello Marcus,
It seems like the note is not available yet...
Rgs, Marcelo Lauria
Document is not released
Was released today, not sure how much time that takes through...
Hello Marcus, it´s available now!
Rgs, Marcelo Lauria
we wanted to decide the duration based on the service level, how can we do this ?
For example: distance is fixed , same Means of transport
Standard - 3 days
Express - 1 day
This must be done on business document level. The distance determination is a generic framework woring on locations and some means of transport attributes, but no business document information.
An alternative would be to use 2 MTRs.
I´d suggest the use of 2 MTRs like Marcus said...Best Regards. Marcelo