How to get State name based on City name in HR

[former_member515329]

Hello All,

I have city name - based on it can i get state name in SAP HR table or any FM or BAPI available?

for example : i have Austin in my program and i need to Print it's state - TX

thanks in advance.

[ArthurParisius]

I don't think there is a way to do it based on city name. If there is something it will most like be based on zip code. I know that something like that is there for the Netherlands. I don't know which tables though.

[former_member515329]

I have hardcoded few city names based on the state names in a Ztable.