Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Incorrect UK DST Rule

Ash_ok
Contributor
0 Kudos
648

Hello SAP !

The syntax of

CONVERT TIME STAMP time stamp TIME ZONE tz INTO [DATE dat] [TIME tim] [DAYLIGHT SAVING TIME dst].

is a nice way of identifying if a given timestamp is a `DST` timestamp or not by looking at variable 'dst'. CL_ABAP_TSTMP has some methods to use this variable value (dst), to calculate the number of hours between two timestamps, even when clocks change. These methods are dependent on standard SAP entries in tables TTZZ, TTZD, TTZDV, etc.

But, there is a bug in these standard SAP tables for SAP_BASIS 750 / 022 for the UK entry of 'GMTUK'. Timezone 'GMTUK' is linked to the DST rule of 'EUROPE' and not 'UK'. This is fine, as the clocks in the UK and in Europe change during the same weekends. However, the clocks change at 03:00:00 in Europe, whereas the clocks change at 02:00:00 in the UK. That would mean that it would've been better to have the DST rule of 'GMTUK' linked to 'UK' instead of 'EUROPE'. But, then again, the sting in the tail - the DST rule of 'UK', in table TTZDV, has the clocks changing at 03:00:00 instead of at 02:00:00.

Could the privileged class of ABAP developers, in the UK, lookup the entries for 'GMTUK' in table TTZD and it's DST rule entry in table TTZDV to see if there are any anomalies in their respective systems, be it ECC or S/4 HANA ?

TIA,

Ash_ok.

1 ACCEPTED SOLUTION

Sandra_Rossi
Active Contributor
552

You must apply the latest time zone data from the note 198411 - Current data and information on time zones - SAP for Me.

With the latest data, transaction code STZBC shows this data, GMTUK is linked to EUROP0 instead of EUROPE:

4 REPLIES 4

Sandra_Rossi
Active Contributor
552

That currently doesn't look like a question corresponding to the title. With the current title, you could post it in two parts, one being a question, one being an answer (it's what I do when I want to share a question and answer). Or change the title of your question "please SAP support fix this bug".

Ash_ok
Contributor
552

The correct answer would be for the 'GMTUK' record in table TTZD to hold the DST rule column entry as 'UK' and the DST rule record of 'UK' in table TTZDV hold the column values to read as the last occurrence of [5] Sunday [1] of March [3] and the last occurrence of [5] Sunday [1] of October [10] with the times being '01:00:00' and '02:00:00' respectively, for a SAP_BASIS 750 / 022 system

Ash_ok
Contributor
0 Kudos
552

<nudge-SAP_Support>
Please help fix this bug
</nudge-SAP_Support>

Sandra_Rossi
Active Contributor
553

You must apply the latest time zone data from the note 198411 - Current data and information on time zones - SAP for Me.

With the latest data, transaction code STZBC shows this data, GMTUK is linked to EUROP0 instead of EUROPE: