TFACD

Transparent Table Customizing Table
20 Fields 3 CDS Views

Factory calendar definition

TFACD is an SAP database table in S/4HANA. Factory calendar definition. It contains 20 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
FAC_OPP_CDS_FACTORY_CALENDAR view from CDS View for Factory Calendar
I_FactoryCalendar view from BASIC Factory Calendar
R_FHC_FCAL_COMBINED view_entity from Combined Factory Calendar View

Fields (20)

KeyField Data ElementDescription DomainTypeLength
KEY ident WFCID Factory Cal. ID
vjahr VJAHR Valid from year
bjahr BJAHR Valid to year
motag KBIT Bit for workday
ditag KBIT Bit for workday
miwch KBIT Bit for workday
dotag KBIT Bit for workday
frtag KBIT Bit for workday
satag KBIT Bit for workday
sotag KBIT Bit for workday
fetag KBIT Bit for workday
hocid HIDENT Holiday Cal. ID
basis KFTAG First workday
abbr KABBR Termination flg
crusr KUSER User
crdat FABDAT Date
crtime CRTIME Changed At
interv KABBR Termination flg
aktvjahr AKTVJAHR Curr.from year
aktbjahr AKTBJAHR Curr.until year

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 calendar definition
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TFACD (
    IDENT,     -- Factory Cal. ID [WFCID]
    VJAHR,     -- Valid from year [VJAHR]
    BJAHR,     -- Valid to year [BJAHR]
    MOTAG,     -- Bit for workday [KBIT]
    DITAG,     -- Bit for workday [KBIT]
    MIWCH,     -- Bit for workday [KBIT]
    DOTAG,     -- Bit for workday [KBIT]
    FRTAG,     -- Bit for workday [KBIT]
    SATAG,     -- Bit for workday [KBIT]
    SOTAG,     -- Bit for workday [KBIT]
    FETAG,     -- Bit for workday [KBIT]
    HOCID,     -- Holiday Cal. ID [HIDENT]
    BASIS,     -- First workday [KFTAG]
    ABBR,      -- Termination flg [KABBR]
    CRUSR,     -- User [KUSER]
    CRDAT,     -- Date [FABDAT]
    CRTIME,    -- Changed At [CRTIME]
    INTERV,    -- Termination flg [KABBR]
    AKTVJAHR,  -- Curr.from year [AKTVJAHR]
    AKTBJAHR,  -- Curr.until year [AKTBJAHR]
    PRIMARY KEY (IDENT)
);

Learn More