back to top

SAP TTZZ Table – Time zones

TTZZ table in SAP ERP or S/4HANA stores Time zones data. There are total 5 fields in TTZZ table. The Time zones table is available in all major of SAP S/4HANA versions and is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of TTZZ table. It is in Time Zones (SZTZ) ABAP package and is part of the Time Zones (BC-SRV-TIM-TZ) module.

SAP TTZZ Table Fields

Following is the list of fields that are available in SAP TTZZ table. The primary key fields of Time zones table in SAP are CLIENT (Client), TZONE (Time Zone).

Field Description Data Element Check Table Data Type
CLIENT Client MANDT T000 CLNT(3)
TZONE Time Zone TZNZONE CHAR(6)
ZONERULE Time Zone Rule TZNZONERUL TTZR CHAR(6)
DSTRULE Daylight Saving Time Rule TZNDSTRUL TTZD CHAR(6)
FLAGACTIVE Time zones active TZNFLACTIV CHAR(1)