- Home
- Resources
- SAP Tables
- THOL - Public Holidays
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.
Source: THOL (Public Holidays)
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 |
Possible values
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 |
Possible values
|
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 |
Possible values
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 |
Possible values
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 |