FHC_C_FCAL

Transparent Table Customizing Table

Factory Calendars

FHC_C_FCAL is an SAP database table in S/4HANA. Factory Calendars. It contains 17 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
/APE/C_FactoryCalenderIDfhc_VH view from CONSUMPTION Factory Calender ID
I_FHC_FCAL view from Interface view
I_FHC_FCAL_RUNTIME view from Factory Calendar runtime interface
R_FHC_FCAL_COMBINED view_entity union Combined Factory Calendar View
R_FHC_FCAL_COMBINED_EXC view_entity left_outer Combined Factory Calendar EXC View
R_FHC_FCAL_COMBINED_TEXT view_entity left_outer Combined Factory Calendar Text View

Fields (17)

KeyField Data ElementDescription DomainTypeLength
KEY client abap.clnt
KEY factorycalendar_id FHC_FCALID Factory Cal. ID
legacy_factorycalendar_id FHC_LEGACY_FCALID Legacy FCAL ID
holidaycalendar_id FHC_HCALID Holiday Cal. ID
work_monday FHC_WORK_MONDAY Work Monday
work_tuesday FHC_WORK_TUESDAY Work Tuesday
work_wednesday FHC_WORK_WEDNESDAY Work Wednesday
work_thursday FHC_WORK_THURSDAY Work Thursday
work_friday FHC_WORK_FRIDAY Work Friday
work_saturday FHC_WORK_SATURDAY Work Saturday
work_sunday FHC_WORK_SUNDAY Work Sunday
work_holiday FHC_WORK_HOLIDAY Work Holiday
valid_from FHC_VALID_FROM Valid from
valid_to FHC_VALID_TO Valid to
factorydate_start FHC_FACTORYDATE Factory Date
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.

-- Factory Calendars
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FHC_C_FCAL (
    CLIENT,                     -- abap.clnt
    FACTORYCALENDAR_ID,         -- Factory Cal. ID [FHC_FCALID]
    LEGACY_FACTORYCALENDAR_ID,  -- Legacy FCAL ID [FHC_LEGACY_FCALID]
    HOLIDAYCALENDAR_ID,         -- Holiday Cal. ID [FHC_HCALID]
    WORK_MONDAY,                -- Work Monday [FHC_WORK_MONDAY]
    WORK_TUESDAY,               -- Work Tuesday [FHC_WORK_TUESDAY]
    WORK_WEDNESDAY,             -- Work Wednesday [FHC_WORK_WEDNESDAY]
    WORK_THURSDAY,              -- Work Thursday [FHC_WORK_THURSDAY]
    WORK_FRIDAY,                -- Work Friday [FHC_WORK_FRIDAY]
    WORK_SATURDAY,              -- Work Saturday [FHC_WORK_SATURDAY]
    WORK_SUNDAY,                -- Work Sunday [FHC_WORK_SUNDAY]
    WORK_HOLIDAY,               -- Work Holiday [FHC_WORK_HOLIDAY]
    VALID_FROM,                 -- Valid from [FHC_VALID_FROM]
    VALID_TO,                   -- Valid to [FHC_VALID_TO]
    FACTORYDATE_START,          -- Factory Date [FHC_FACTORYDATE]
    CHANGER,                    -- Changed by [FHC_CHANGER]
    CHANGED,                    -- Created at [FHC_CHANGED]
    PRIMARY KEY (CLIENT, FACTORYCALENDAR_ID)
);