Recorded Time (=GMT) in ME Database and Time Zone Conversion

[Former Member]

Dear All,

according to this thread http://forums.sdn.sap.com/thread.jspa?messageID=9797128#9797128 , time stamps (on SFCs for instance) always are recorded as GMT with no offset. Offset is applied in ME UI, say ME Standard Reports.

My question is: How is this conversion done? Is there a table describing Offset according to Site location, Java logic or something else?

I am doing reports in BO and would like to have time zone conversion applied in accordance to Site location if possible without duplicating an allocation table.

Thanks and Regards,

Stefan

[alexander_teslyuk · Accepted solution]

Hello Stefan,

There is no any Offset table in ME database. You can find Site specific timezone in SITE table, TIME_ZONE field.

Regards,

Alex.

[Former Member · Accepted solution]

Hi Alex,

thanks - yes but how do ME Reports etc. know how much Offset is required?

Let's say we had a Site 1000 in Time Zone 'Europe/Berlin', how does ME know how much Offset to apply (GMT1) to show results correct in terms of Timestamps (=GMT1 in this case) in the User Interface? As I couldn't find a respective query in the trace files I would assume it is hard coded logic. But I don't know.

Many Thanks, Stefan

[Former Member · Accepted solution]

ME uses the timzone offsets provided by Java. They are built into the Java environment. Typically these are accessed through standard Java APIs.

[Former Member]

Thank you, Mike and Alex!