THOL

Transparent Table Customizing Table
10 Fields 2 CDS Views

Feiertage

THOL is an SAP database table in S/4HANA. Feiertage. It contains 10 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_PublicHolidayCode view from BASIC Public Holiday Code
R_FHC_HOL_COMBINED view_entity from Combined Holiday View

Fields (10)

KeyField Data ElementDescription DomainTypeLength
KEY ftgid ftgid Public hol. ID
regel kregel Holiday rule
monat kmonat Month
motag ktag Day
wotag kwotag Day
abstd kabstd From Easter
konfe kkonfe Religion
klass kklass Holiday class
garant ftgarant Guaranteed
sort ftsort Sort criterion

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.

-- Feiertage
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE THOL (
    FTGID,   -- Public hol. ID [ftgid]
    REGEL,   -- Holiday rule [kregel]
    MONAT,   -- Month [kmonat]
    MOTAG,   -- Day [ktag]
    WOTAG,   -- Day [kwotag]
    ABSTD,   -- From Easter [kabstd]
    KONFE,   -- Religion [kkonfe]
    KLASS,   -- Holiday class [kklass]
    GARANT,  -- Guaranteed [ftgarant]
    SORT,    -- Sort criterion [ftsort]
    PRIMARY KEY (FTGID)
);

Learn More