The TTZR table in SAP ERP or S/4HANA stores Time zone rules data. There are total 5 fields in TTZR table. The Time zone rules 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 TTZR table. It is in Time Zones (SZTZ) ABAP package and is part of the Time Zones (BC-SRV-TIM-TZ) module.
SAP TTZR Table Fields
Following is the list of fields that are available in SAP TTZR table. The primary key fields of Time zone rules table in SAP are CLIENT (Client), ZONERULE (Time Zone Rule).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| CLIENT | Client | MANDT | T000 | CLNT (3) |
| ZONERULE | Time Zone Rule | TZNZONERUL | CHAR (6) | |
| UTCDIFF | Difference of time zone from UTC (w/o Summer time) | TZNUTCDIFF | TIMS (6) | |
| UTCSIGN | Sign of the Difference from UTC (+ or -) | TZNUTCSIGN | CHAR (1) | |
| FLAGACTIVE | Time zones active | TZNFLACTIV | CHAR (1) |
