THOCS

Transparent Table Customizing Table
18 Fields 1 CDS Views

Public holiday calendar (display)

THOCS is an SAP database table in S/4HANA. Public holiday calendar (display). It contains 18 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_PublHolidayCalHolidaysPerYr view from BASIC Public Holidays Per Year

Fields (18)

KeyField Data ElementDescription DomainTypeLength
KEY ident HIDENT Holiday Cal. ID
KEY jahr KJAHR Year stored
mon01 MON00 Days in month
mon02 MON00 Days in month
mon03 MON00 Days in month
mon04 MON00 Days in month
mon05 MON00 Days in month
mon06 MON00 Days in month
mon07 MON00 Days in month
mon08 MON00 Days in month
mon09 MON00 Days in month
mon10 MON00 Days in month
mon11 MON00 Days in month
mon12 MON00 Days in month
fenum FTNUM Number of days
samfe SAMFE Pub.hols.on Sat.
sonfe SONFE Pub.hols.on Sunday
load CLOAD Buffer flag

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.

-- Public holiday calendar (display)
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE THOCS (
    IDENT,  -- Holiday Cal. ID [HIDENT]
    JAHR,   -- Year stored [KJAHR]
    MON01,  -- Days in month [MON00]
    MON02,  -- Days in month [MON00]
    MON03,  -- Days in month [MON00]
    MON04,  -- Days in month [MON00]
    MON05,  -- Days in month [MON00]
    MON06,  -- Days in month [MON00]
    MON07,  -- Days in month [MON00]
    MON08,  -- Days in month [MON00]
    MON09,  -- Days in month [MON00]
    MON10,  -- Days in month [MON00]
    MON11,  -- Days in month [MON00]
    MON12,  -- Days in month [MON00]
    FENUM,  -- Number of days [FTNUM]
    SAMFE,  -- Pub.hols.on Sat. [SAMFE]
    SONFE,  -- Pub.hols.on Sunday [SONFE]
    LOAD,   -- Buffer flag [CLOAD]
    PRIMARY KEY (IDENT, JAHR)
);

Learn More