WFD_D_AVAIL_TIME

Transparent Table Application Table
12 Fields 1 CDS Views

Workforce Availability Time Intervals

WFD_D_AVAIL_TIME is an SAP database table in S/4HANA. Workforce Availability Time Intervals. It contains 12 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_WorkforceAvailabilityIntvl view_entity from BASIC Workforce Availability Time Interval

Fields (12)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY work_assignment_id WFD_WORKFORCE_ASSGMT WorkForce Assgmt ID
KEY availability_date WFD_AVAILABILITY_DATE Availability Date
KEY sequence_number WFD_AVAIL_SEQ_NUM Sequence number
KEY work_assignment_ext_id WFD_EXT_ASSGMT_ID WA Ext ID
category WFD_AVAIL_TIME_CATEGORY Time Category
interval_start WFD_AVAIL_TIME_INTERVAL_START Interval Start
interval_end WFD_AVAIL_TIME_INTERVAL_END Interval End
contribution WFD_AVAIL_TIME_CONTRIBUTION Time Contribution
starts_on_subsequent_day WFD_AVAIL_START_SUBSE_DAY Start Subsequent Day
starts_on_preceding_day WFD_AVAIL_START_PRECED_DAY Start Preceeding Day
block_ind WFD_BLOCKED Blocked Indicator

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.

-- Workforce Availability Time Intervals
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE WFD_D_AVAIL_TIME (
    CLIENT,                    -- Client [MANDT]
    WORK_ASSIGNMENT_ID,        -- WorkForce Assgmt ID [WFD_WORKFORCE_ASSGMT]
    AVAILABILITY_DATE,         -- Availability Date [WFD_AVAILABILITY_DATE]
    SEQUENCE_NUMBER,           -- Sequence number [WFD_AVAIL_SEQ_NUM]
    WORK_ASSIGNMENT_EXT_ID,    -- WA Ext ID [WFD_EXT_ASSGMT_ID]
    CATEGORY,                  -- Time Category [WFD_AVAIL_TIME_CATEGORY]
    INTERVAL_START,            -- Interval Start [WFD_AVAIL_TIME_INTERVAL_START]
    INTERVAL_END,              -- Interval End [WFD_AVAIL_TIME_INTERVAL_END]
    CONTRIBUTION,              -- Time Contribution [WFD_AVAIL_TIME_CONTRIBUTION]
    STARTS_ON_SUBSEQUENT_DAY,  -- Start Subsequent Day [WFD_AVAIL_START_SUBSE_DAY]
    STARTS_ON_PRECEDING_DAY,   -- Start Preceeding Day [WFD_AVAIL_START_PRECED_DAY]
    BLOCK_IND,                 -- Blocked Indicator [WFD_BLOCKED]
    PRIMARY KEY (CLIENT, WORK_ASSIGNMENT_ID, AVAILABILITY_DATE, SEQUENCE_NUMBER, WORK_ASSIGNMENT_EXT_ID)
);

Learn More