TIME_ZONE of a state?

[former_member202077]

Hello

I need to find the link between REGIO (state) and TIME_ZONE (example, US East time, US Central time, Central Europe Time), pls. let me know in which SAP table these 2 values are stored? or is there any FM/BAPI?

Thank you

[Former Member]

Hi

Check the table TTZ5S, pass the country and state to it, it will give you the timezone. Then take the time zone, pass it to function module TZ_SYSTEM_TO_LOCAL. Then you will get the Region time.

Pass the system time and date.

DATE_SYSTEM 15.09.2011

TIMESTAMP_SYSTEM 00000000000000

TIMEZONE EST " from TTZ5S

TIME_SYSTEM 05:04:20

Export parameters Value

DATE_LOCAL 14.09.2011

TIMESTAMP_LOCAL 20110914230420

TIME_LOCAL 23:04:20

Shiva

Shiva

[sjeevan]

Check out the following Function Modules

CIF_GEN3_TIMEZONE_4_PLANT_GET

CIF_GEN4_TIMEZONE_4_PLANT_GET

CIF_GEN_TIMEZONE_FOR_PLANT_GET

SD_TZONE_COMPANY

SD_TZONE_CUSTOBJECT

SD_TZONE_PLANT

SD_TZONE_SALESORG

SD_TZONE_SHIPPOINT

TZ_SYSTEM_GET_TZONE

The names themselves are kinda self explanatory

.Tables related to time zones.

TTZ5 Assign Time Tones to Countries

TTZ5S Assign time zones to regions

TTZ5Z Assign time zones to postal codes in gener

TTZAPPOBJ Time Zones: Objects for Local Date

TTZAPPOBJT Time Zones: Object Texts for Local Date

TTZCU Customizing time zones

TTZD Summer time rules

TTZDF Summer time rules (fixed annual dates)

TTZDT Summer time rules texts

TTZDV Summer time rules (variable dates)

TTZEX Convert Time Zone ID from External to Inte

TTZIN Convert Time Zone ID from Internal to Exte

TTZR Time zone rules

TTZRT Time zone rule texts

TTZZ Time zones

TTZZT Time Zones