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