SAP Table THOL

Public Holidays

THOL (Public Holidays) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link THOL to other SAP tables.

THOL table fields

Field Data element Checktable Datatype Length Decimals
FTGID Public holiday key FTGID CHAR 3 0
REGEL Holiday rule KREGEL CHAR 1 0
MONAT Month for holiday calculation KMONAT NUMC 2 0
01 January
02 February
03 March
04 April
05 May
06 June
07 July
08 August
09 September
10 October
11 November
12 December
MOTAG Day of month for public holiday calculation KTAG NUMC 2 0
01 Days in month
WOTAG Day for public holiday calculation KWOTAG NUMC 1 0
ABSTD Distance of public holiday from Easter KABSTD DEC 3 0
KONFE Calendar religion key KKONFE T516T CHAR 2 0
KLASS Holiday class KKLASS CHAR 1 0
NULL Not a public holiday
1 ordinary public holiday
2 half-day holiday, e.g. 24.12. (Christmas Eve)
3 customer specific public holiday classes
GARANT Public holiday guaranteed flag FTGARANT CHAR 1 0
V move to previous day
M move from Sat/Sun to previous/next day
X move to next day after weekend (Sat/Sun)
S move to previous day
Y move to next day
D move to previous day
E move to next day
F move to previous day
G move to next day
Z move to next day after Friday/Saturday
A move to next day after Thursday/Friday
SORT Sort field for public holidays FTSORT CHAR 3 0

THOL foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
THOL KONFE SYST MANDT T516T Religious Denomination Texts MANDT
THOL KONFE SYST LANGU T516T Religious Denomination Texts SPRSL
THOL KONFE THOL KONFE T516T Religious Denomination Texts KONFE