1. Home
  2. Resources
  3. SAP Tables
  4. TZONECHECK - Time zone structure for consistency checks

SAP Table TZONECHECK

Time zone structure for consistency checks

TZONECHECK (Time zone structure for consistency checks) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link TZONECHECK to other SAP tables.

TZONECHECK table fields

Field Data element Checktable Datatype Length Decimals
CLIENT Client MANDT T000 CLNT 3 0
UTZONESYS System Time Zone TZNZONESYS CHAR 6 0
UTZONEDEF Default Time Zone for User TZNZONEDEF CHAR 6 0
UFLACTIVE Time zones active TZNFLACTIV CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
UFLCHANGE Changes allowed TZNFLCHANG CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
UFLDELETE Deletion Allowed TZNFLDELET CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
ZTZONE Time Zone TZNZONE CHAR 6 0
ZONERULE Time Zone Rule TZNZONERUL CHAR 6 0
ZDSTRULE Daylight Saving Time Rule TZNDSTRUL CHAR 6 0
ZFLACTIVE Time zones active TZNFLACTIV CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
RZONERULE Time Zone Rule TZNZONERUL CHAR 6 0
RUTCDIFF Difference of time zone from UTC (w/o Summer time) TZNUTCDIFF TIMS 6 0
RUTCSIGN Sign of the Difference from UTC (+ or -) TZNUTCSIGN CHAR 1 0
NULL Positive
+ Positive
- Negative
RFLACTIVE Time zones active TZNFLACTIV CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
DDSTRULE Daylight Saving Time Rule TZNDSTRUL CHAR 6 0
DDSTDIFF Difference Between Daylight Saving Time and Winter Time TZNDSTDIFF TIMS 6 0
DFLACTIVE Time zones active TZNFLACTIV CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set
DFDSTRULE Daylight Saving Time Rule TZNDSTRUL CHAR 6 0
DFYEARACT Valid for Year TZNYEARACT NUMC 4 0
DFDATEFR Start of Daylight Saving Time: Date TZNDATEFR DATS 8 0
DFTIMEFR Start of Daylight Saving Time (Time) TZNTIMEFR TIMS 6 0
DFDATETO End of Daylight Saving Time: Date TZNDATETO DATS 8 0
DFTIMETO End of Daylight Saving Time (Time) TZNTIMETO TIMS 6 0
DVDSTRULE Daylight Saving Time Rule TZNDSTRUL CHAR 6 0
DVYEARFR Valid from year TZNYEARFR NUMC 4 0
DVMONTHFR Start of Daylight Saving Time (Month) TZNMONTHFR NUMC 2 0
01 January
02 February
03 March
04 April
05 May
06 June
07 July
08 August
09 September
10 October
11 November
12 December
DVWEEKDFR Start of Daylight Saving Time: Day of the Week TZNWEEKDFR NUMC 1 0
1 Sunday
2 Monday
3 Tuesday
4 Wednesday
5 Thursday
6 Friday
7 Saturday
DVWEEKDCFR Start of Daylight Saving Time: Weekday in Month TZNWEEKDCF NUMC 1 0
1 1st occurrence of a given day of the week in the month
2 2nd occurrence of a given day of the week in the month
3 3rd occurrence of a given day of the week in the month
4 4th occurrence of a given day of the week in the month
5 Last occurrence of a given day of the week in the month
DVTIMEFR Start of Daylight Saving Time (Time) TZNTIMEFR TIMS 6 0
DVMONTHTO End of Daylight Saving Time (Month) TZNMONTHTO NUMC 2 0
01 January
02 February
03 March
04 April
05 May
06 June
07 July
08 August
09 September
10 October
11 November
12 December
DVWEEKDTO End of Daylight Saving Time: Day of Week TZNWEEKDTO NUMC 1 0
1 Sunday
2 Monday
3 Tuesday
4 Wednesday
5 Thursday
6 Friday
7 Saturday
DVWEEKDCTO End of Daylight Saving Time: Day of the Week in Month TZNWEEKDCT NUMC 1 0
1 1st occurrence of a given day of the week in the month
2 2nd occurrence of a given day of the week in the month
3 3rd occurrence of a given day of the week in the month
4 4th occurrence of a given day of the week in the month
5 Last occurrence of a given day of the week in the month
DVTIMETO End of Daylight Saving Time (Time) TZNTIMETO TIMS 6 0
DTDESCRIPT Daylight Saving Time Rule TZNDESCDST CHAR 20 0
RTDESCRIPT Name of Time Zone Rule (Difference from UTC) TZNDESCTZR CHAR 20 0

TZONECHECK foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
TZONECHECK CLIENT TZONECHECK CLIENT T000 Clients MANDT