TTZR

Transparent Table Control Table (SAP+Cust)
5 Fields 2 CDS Views

Time zone rules

TTZR is an SAP database table in S/4HANA. Time zone rules. It contains 5 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
Fac_Opp_Cds_Scheduled_Job view left_outer CDS View For Scheduled Jobs
I_TimeZoneRule view from BASIC Time Zone Rule

Fields (5)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY zonerule TZNZONERUL Time Zone Rule
utcdiff TZNUTCDIFF Diff. from UTC
utcsign TZNUTCSIGN Sign of Difference
flagactive TZNFLACTIV Active

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Time zone rules
-- Category TRANSPARENT · Delivery class E
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TTZR (
    CLIENT,      -- Client [MANDT]
    ZONERULE,    -- Time Zone Rule [TZNZONERUL]
    UTCDIFF,     -- Diff. from UTC [TZNUTCDIFF]
    UTCSIGN,     -- Sign of Difference [TZNUTCSIGN]
    FLAGACTIVE,  -- Active [TZNFLACTIV]
    PRIMARY KEY (CLIENT, ZONERULE)
);

Learn More