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.
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: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.
| User | Count |
|---|---|
| 6 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |