WFD_D_AVAIL_SUPL

Transparent Table Application Table
13 Fields 1 CDS Views

Workforce Availability Supplement

WFD_D_AVAIL_SUPL is an SAP database table in S/4HANA. Workforce Availability Supplement. It contains 13 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_WorkforceAvailabilitySuplmnt view_entity from BASIC Workforce Availability Supplement

Fields (13)

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_supl_category Availabilty category
is_worker_approachable wfd_avail_worker_approachble Worker Approachable
type wfd_avail_supl_type Availability type
interval_start wfd_avail_supl_interval_start Interval start
interval_end wfd_avail_supl_interval_end Interval end
contribution wfd_avail_supl_contribution Contribution
contribution_numeric wfd_avail_supl_contrbn_nmrc Numeric Contribution
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 Supplement
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE WFD_D_AVAIL_SUPL (
    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,                -- Availabilty category [wfd_avail_supl_category]
    IS_WORKER_APPROACHABLE,  -- Worker Approachable [wfd_avail_worker_approachble]
    TYPE,                    -- Availability type [wfd_avail_supl_type]
    INTERVAL_START,          -- Interval start [wfd_avail_supl_interval_start]
    INTERVAL_END,            -- Interval end [wfd_avail_supl_interval_end]
    CONTRIBUTION,            -- Contribution [wfd_avail_supl_contribution]
    CONTRIBUTION_NUMERIC,    -- Numeric Contribution [wfd_avail_supl_contrbn_nmrc]
    BLOCK_IND,               -- Blocked Indicator [wfd_blocked]
    PRIMARY KEY (CLIENT, WORK_ASSIGNMENT_ID, AVAILABILITY_DATE, SEQUENCE_NUMBER, WORK_ASSIGNMENT_EXT_ID)
);

Learn More