HOLIDAY
Holidays (in Business Data)
Description
The HOLIDAY table contains the holidays used by the SAP CC Core Server system when
executing the pricing logic during the charging or refilling operations.
You use this list when configuring some charges
or refill logic objects in SAP CC.
Notes
- This business data is defined in the complete SAP CC system. It is not restricted
to a pricing catalog. It is shared by all the service providers.
- To customize or maintain the holidays, see the Core Tool Online Help.
Technical Data
Summary
The HOLIDAY table is defined by the
following columns.
See the column details for more information.
Column Details
CODE
| Definition |
The identification code of the holiday |
| Type |
NVARCHAR(256), NOT NULL |
TYPE
| Definition |
The type of holiday |
| Format |
The possible values are:
0: a fixed day. Example: New Year's day, January the 1st
1: a relative day. Example: Thanksgiving, the fourth thursday of November
2: a day relative to Easter
3: a list of days
|
| Type |
DECIMAL(1), NULL |
MONTH
| Definition |
The month when the holiday occurs |
| Description |
The month when the holiday occurs. This field is only used if the holiday type (see
TYPE) is a fixed day or a day relative to Easter.
|
| Format |
The possible numerical values are in the range from 1 (January) to 12 (December).
|
| Type |
DECIMAL(2), NULL |
DAY
| Definition |
The day when the holiday occurs in the month |
| Description |
The day when the holiday occurs in the month. This field is only used if the holiday
type (see TYPE) is a fixed day.
|
| Type |
DECIMAL(2), NULL |
DAYS
| Definition |
The list of the days when the holiday occurs |
| Description |
The list of the days when the holiday occurs. This field is only used if the holiday
type (see TYPE) is a list of days.
|
| Format |
Use the ISO 8601 format for the dates (YYYY-MM-DD) and separate them with commas.
|
| Type |
NVARCHAR(2000), NULL |
WEEKDAY
| Definition |
The day in the week when the holiday occurs |
| Description |
The day in the week when the holiday occurs. This field is only used if the TYPE is
relative.
|
| Format |
Values range from 1 (sunday) to 7 (saturday)
|
| Type |
DECIMAL(1), NULL |
POSITION
| Definition |
The position of the weekday in the month |
| Description |
The position of the weekday in the month. This field is only used if the TYPE is relative. |
| Format |
The possible values are:
0: the last
1: the first
2: the second
3: the third
4: the fourth
5: the fifth
Note
Combined with the WEEKDAY and the MONTH fields, the POSITION field enables to define
the fourth thursday of november for example.
|
| Type |
DECIMAL(1), NULL |
INCR
| Definition |
The number of the days between the holiday and Easter |
| Description |
The number of the days between the holiday and Easter. This field is only used
if the TYPE is Easter relative.
|
| Type |
DECIMAL(3), NULL |
COUNTRIES
| Definition |
The csv list of the countries where the holiday occurs |
| Description |
The csv list of the countries where the holiday occurs.
The countries are identified by their ISO 3166 code. See also the CODE field of
the HOLIDAYS_GROUP_DESCRIPTION table.
|
| Type |
NVARCHAR(2000), NULL |
DESCRIPTIONS
| Definition |
The CSV list of the descriptions of the holiday |
| Description |
The CSV list of the descriptions of the holiday. Each element in the list is a pair
language/label.
|
| Type |
NVARCHAR(2000), NULL |
