2023 Nov 03 4:30 PM
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.
2023 Nov 04 4:37 PM
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:
2023 Nov 03 6:42 PM
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".
2023 Nov 04 2:25 PM
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
2023 Nov 04 2:27 PM
<nudge-SAP_Support>
Please help fix this bug
</nudge-SAP_Support>
2023 Nov 04 4:37 PM
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: