FHC_C_HCAL

Transparent Table Customizing Table

Holiday Calendars

FHC_C_HCAL is an SAP database table in S/4HANA. Holiday Calendars. It contains 7 fields. 5 CDS views read from this table.

CDS Views using this table (5)

ViewTypeJoinVDMDescription
I_FHC_HCAL view from Interface view
I_FHC_HCAL_RUNTIME view from Holiday Calendar runtime view
R_FHC_HCAL_COMBINED view_entity union Combined Holiday Calendar View
R_FHC_HCAL_COMBINED_ASSGN view_entity left_outer Combined Holiday Calendar Assgn View
R_FHC_HCAL_COMBINED_TEXT view_entity left_outer Combined Holiday Calendar Text View

Fields (7)

KeyField Data ElementDescription DomainTypeLength
KEY client abap.clnt
KEY holidaycalendar_id FHC_HCALID Holiday Cal. ID
legacy_holidaycalendar_id FHC_LEGACY_HCALID Legacy HCAL ID
valid_from FHC_VALID_FROM Valid from
valid_to FHC_VALID_TO Valid to
changer FHC_CHANGER Changed by
changed FHC_CHANGED Created at

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.

-- Holiday Calendars
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FHC_C_HCAL (
    CLIENT,                     -- abap.clnt
    HOLIDAYCALENDAR_ID,         -- Holiday Cal. ID [FHC_HCALID]
    LEGACY_HOLIDAYCALENDAR_ID,  -- Legacy HCAL ID [FHC_LEGACY_HCALID]
    VALID_FROM,                 -- Valid from [FHC_VALID_FROM]
    VALID_TO,                   -- Valid to [FHC_VALID_TO]
    CHANGER,                    -- Changed by [FHC_CHANGER]
    CHANGED,                    -- Created at [FHC_CHANGED]
    PRIMARY KEY (CLIENT, HOLIDAYCALENDAR_ID)
);