‎2007 Apr 24 10:17 AM
Hello All,
There is a requirement in my application, where in
i have to find the timezone of a location based on the zip code
entered for that location.
Kindly let me know whether any function module exists for the same.
Thanks in advance,
Rashmi.
‎2007 Apr 24 10:21 AM
Query the table T5UZC to get the Coutry and Region for a zip code.
Then you can use the FM TZ_LOCATION_TIMEZONE to get you the time zone for a country and region combination.
Regards,
Ravi
‎2007 Apr 24 10:22 AM
‎2007 Apr 24 12:43 PM
Hi,
thanks, but am not able to find any data in this table, i gave data in all
the 3 input parameters.
Thanks,
RAshmi.
‎2007 Apr 24 12:51 PM
Query the table T5UZC to get the Coutry and Region for a zip code.
Then you can use the FM TZ_LOCATION_TIMEZONE to get you the time zone for a country and region combination.
U have the zipcode. goto T5UZC and try the below ways... one will work...
1) enter zipcode in <b>T5UZC-ZIPHI</b> and fetch <b>LAND1 & REGIO</b> fields. Using <b>TZ_LOCATION_TIMEZONE</b> get the time zone by passing LAND1 & REGIO fields.
2) enter zipcode in <b>T5UZC-ZIPLO</b> and fetch <b>LAND1 & REGIO</b> fields. Using <b>TZ_LOCATION_TIMEZONE</b> get the time zone by passing LAND1 & REGIO fields.
of these 2 combinations 1 of them will work fine in ur case.