WFD_D_AVAIL_HDR

Transparent Table Application Table
15 Fields 1 CDS Views

Workforce Availability Header

WFD_D_AVAIL_HDR is an SAP database table in S/4HANA. Workforce Availability Header. It contains 15 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_WorkforceAvailability view_entity from BASIC Workforce Availability Header Details

Fields (15)

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 work_assignment_ext_id wfd_ext_assgmt_id WA Ext ID
workforce_availability_id wfd_avail_id WFD Avail ID
workforce_person_id wfd_worker_id Worker ID
data_source wfd_avail_data_source Data Source
normal_working_time wfd_avail_normal_working_time Working Time
normal_working_time_numeric wfd_avail_normal_wrkg_tme_nmrc Time in numeric
scheduled_time wfd_avail_scheduled_time Scheduled Time
shift_code wfd_avail_shift_code Shift Code
holiday_code wfd_avail_holiday_code Holiday Code
block_ind wfd_blocked Blocked Indicator
last_changed_at wfd_avail_lstchg_at_timestamp Last Changed Tmestmp
last_changed_by wfd_avail_lstchg_by_user_name Last Changed UName

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 Header
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE WFD_D_AVAIL_HDR (
    CLIENT,                       -- Client [mandt]
    WORK_ASSIGNMENT_ID,           -- WorkForce Assgmt ID [wfd_workforce_assgmt]
    AVAILABILITY_DATE,            -- Availability Date [wfd_availability_date]
    WORK_ASSIGNMENT_EXT_ID,       -- WA Ext ID [wfd_ext_assgmt_id]
    WORKFORCE_AVAILABILITY_ID,    -- WFD Avail ID [wfd_avail_id]
    WORKFORCE_PERSON_ID,          -- Worker ID [wfd_worker_id]
    DATA_SOURCE,                  -- Data Source [wfd_avail_data_source]
    NORMAL_WORKING_TIME,          -- Working Time [wfd_avail_normal_working_time]
    NORMAL_WORKING_TIME_NUMERIC,  -- Time in numeric [wfd_avail_normal_wrkg_tme_nmrc]
    SCHEDULED_TIME,               -- Scheduled Time [wfd_avail_scheduled_time]
    SHIFT_CODE,                   -- Shift Code [wfd_avail_shift_code]
    HOLIDAY_CODE,                 -- Holiday Code [wfd_avail_holiday_code]
    BLOCK_IND,                    -- Blocked Indicator [wfd_blocked]
    LAST_CHANGED_AT,              -- Last Changed Tmestmp [wfd_avail_lstchg_at_timestamp]
    LAST_CHANGED_BY,              -- Last Changed UName [wfd_avail_lstchg_by_user_name]
    PRIMARY KEY (CLIENT, WORK_ASSIGNMENT_ID, AVAILABILITY_DATE, WORK_ASSIGNMENT_EXT_ID)
);

Learn More