Retrieving zones for a set of locations

[petra_just]

Dear experts,

we need to retrieve zones for a set of locations. Which helper class or retrieve would you advise? in the existing coding, a query is used "root-querybylocation-locationid". is there another way or can I use it for several Locations?
In which data base table can I find Location and Zone(s)? Which retrieve would you advise? I need the most speedy way performance wise and I need to be able to select zones for several Locations.

Thanks a lot in advance

Petra

[petra_just · Accepted solution]

Hi,

found the following link from Marcus Zahn. You can retrieve the data from /SCMTMS/D_SHLOC and /SCHMTMS/D_SHZON.

http://scn.sap.com/community/scm/transportation-management/blog/2012/10/08/monday-knowledge-snippet-...

Thanks, Marcus. That has helped us.

Petraa

[former_member186731]

In case you do not want to rely on the TM shadow tables, you can use class /SCTM/CL_GEOGRAPHY_ACCESS_SQL and method /SCTM/IF_GEOGRAPHY_ACCESS_SQL~GET_LOCATION_ZONES.

[Former Member]

Hi,

I dont recollect the exact helper class but may be you can give it a try in SE24 and typing in /scmtms/*helper* and have a look .Once I am into the system I will try to have a look