How to get Transportation Zone form postal code and Country code

[Former Member]

How to get Transportation Zone from the ZIP code / Postal Code and Country code

[Former Member]

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.

[Former Member]

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

[Former Member]

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

[Former Member]

you can get them from table TZONE and the texts from table TZONT

[Former Member]

this table should serve u better

ADRCITY

[Former Member]

Hi,

Thanks for replay.

We are not maintain the ADRCITY table.

Could you please suggest one more IDEA.

BR//

Ajay.G

[Former Member]

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.

[anversha_s]

hi,

use this table - > ADRCITY

rgds

anver

mark all hlpful answers