09-21-2006 12:08 PM
How to get Transportation Zone from the ZIP code / Postal Code and Country code
09-21-2006 12:13 PM
Hi,
Based on country code you could get it from TZONE table.You can also get transportation Code from Table KNA1 also.
Hope this helps.
09-21-2006 12:58 PM
Hi,
Thanks for replay.
A cournty may have more than one transportation zone, In that I need one Transportation Zone based on the ZIP/Postal code.
BR//
Ajay.G
09-21-2006 12:15 PM
Get it from ADRC table. You can find the TRANSPZONE (Transportation zone), POST_CODE1 and COUNTRY.
Based on the Country code u can get the Transportation zone from TZONE and TZONT will store the short text of it.
Prakash,
Message was edited by: Prakash Ramu
09-21-2006 12:16 PM
09-21-2006 12:18 PM
09-21-2006 12:59 PM
Hi,
Thanks for replay.
We are not maintain the ADRCITY table.
Could you please suggest one more IDEA.
BR//
Ajay.G
09-21-2006 1:13 PM
Transportation zone is not directly linked to Postal code. Better option is to go for a Z table where u can store all the value.
Regards
Prakash.
09-21-2006 12:21 PM