WFD_D_ASSGMT

Transparent Table Application Table
8 Fields 30 CDS Views

Workforce Assignment

WFD_D_ASSGMT is an SAP database table in S/4HANA. Workforce Assignment. It contains 8 fields. 30 CDS views read from this table.

CDS Views using this table (30)

ViewTypeJoinVDMDescription
E_WorkforceAssignment view from EXTENSION Extended view for workforce assignment details
I_Employee view inner BASIC Employee
I_Employmentcostlevel view inner BASIC Employment Service Cost Level
I_EmployStatDet view inner BASIC Employment status
I_EmployWSDet view from BASIC Employment working time details
I_HrPersWrkAgrmt view from BASIC Internal for HCM : Donot Use
I_HrRelation view inner BASIC Read HRP1001 relation table
I_PersnWrkAgrmtRoleForOPg view from BASIC Person Work Agreement Role Details for Object Page
I_PersonWorkAgreement view inner COMPOSITE Retrieve the work agreements of the Person
I_WorkAssgmtToExtIDDEX view_entity inner BASIC Ext IDs of Work Assgmt and Wrkfrc Person
I_WorkAssignment view_entity inner BASIC Work Assignments
I_WorkAssignmentDEX view_entity inner BASIC Work Assignments
I_WorkAssignmentKeyMapping view_entity inner BASIC Work Assignment Key Mappings
I_WorkforceAssignment view from BASIC Workforce Assignment
I_WorkforceAssignment_1 view_entity from BASIC Work Assignment for Worker
P_HrRelation view inner BASIC Read HRP1001 relation table and wfd_d_keymap table
P_HrRelation_CP_P view inner BASIC Read HRP1001 relation table and wfd_d_keymap table
P_HrRelation_P_CP view inner BASIC Read HRP1001 relation table and wfd_d_keymap table
P_N_Employee view inner BASIC Employee
P_N_EmployeeOp view inner BASIC Employee view for OnPremise
P_N_EmployStatDet view inner BASIC Employment status
P_N_EmployWSDet view from BASIC Employment working time details
P_N_HrPersWrkAgrmt view from BASIC Internal for HCM : Donot Use
P_N_PersonWorkAgreement view inner BASIC Retrieve the work agreements of the Person
P_N_PERSONWORKAGREEMENTTYPE view_entity from BASIC Private View for Person Work Agrmnt Type
P_PDRELATION_001 view inner BASIC PD Relation
P_PERSNWRKAGRMTROLEFOROPG view union_all BASIC Person Work Agreement Role Details for Object Page
P_PERSONWORKAGREEMENTVR view inner BASIC Retrieve the work agreements of the Person
P_WORKASSIGNMENT view_entity from BASIC Work Assignments
P_WorkforceAssignment view from BASIC Private view for workforce assignment

Fields (8)

KeyField Data ElementDescription DomainTypeLength
KEY client mandt Client
KEY workforce_assgmt_id wfd_workforce_assgmt WorkForce Assgmt ID
start_date wfd_start_date Start Date
end_date wfd_end_date End Date
business_partner_id bu_partner Busn. Partner
ext_workforce_assgmt_uuid wfd_ext_workforce_assgmt Ext Workforce Assgmt
block_ind wfd_blocked Blocked Indicator
is_contingent_worker wfd_contingent_worker Contingent Worker

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 Assignment
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE WFD_D_ASSGMT (
    CLIENT,                     -- Client [mandt]
    WORKFORCE_ASSGMT_ID,        -- WorkForce Assgmt ID [wfd_workforce_assgmt]
    START_DATE,                 -- Start Date [wfd_start_date]
    END_DATE,                   -- End Date [wfd_end_date]
    BUSINESS_PARTNER_ID,        -- Busn. Partner [bu_partner]
    EXT_WORKFORCE_ASSGMT_UUID,  -- Ext Workforce Assgmt [wfd_ext_workforce_assgmt]
    BLOCK_IND,                  -- Blocked Indicator [wfd_blocked]
    IS_CONTINGENT_WORKER,       -- Contingent Worker [wfd_contingent_worker]
    PRIMARY KEY (CLIENT, WORKFORCE_ASSGMT_ID)
);

Learn More