WFD_D_ASSGMTDETS

Transparent Table Application Table
19 Fields 36 CDS Views

Workforce Assignment Details

WFD_D_ASSGMTDETS is an SAP database table in S/4HANA. Workforce Assignment Details. It contains 19 fields. 36 CDS views read from this table.

CDS Views using this table (36)

ViewTypeJoinVDMDescription
E_WorkforceAssignmentDetails view from EXTENSION Extended view for workforce assignment details
I_WorkAssgmtDetsDEX view_entity from BASIC Workforce Person Assignment Details
I_WorkAssignmentDetail_1 view_entity from BASIC Details for Work Assignment
I_WorkAssignmentDetails view_entity from BASIC Work Assignment details
I_WorkAssignmentDetailsAll view_entity from BASIC Work Assignment Details
I_WorkforceAssignmentDetails view from BASIC Workforce Assignment Details
I_WrkAssgmtSrvcCostLvlDEX view_entity inner BASIC Service Cost Level of Work Assignment
P_EmployeeLineManager view union_all BASIC
P_EmploymentManagerOP view inner BASIC
P_Employmentminpernrstop_001 view inner BASIC
P_EmploymentOp_001 view union_all BASIC
P_EmployOrgDetOp view union_all BASIC
P_EmployStatDet view union_all BASIC
P_EmployWSDet view inner BASIC
P_EMPLREPORTINGSTRUCTUREOP view inner BASIC
P_N_EmployDetOp view left_outer BASIC
P_N_Employment view from BASIC
P_N_Employmentcostlevel view inner BASIC
P_N_EmploymentManager view inner BASIC
P_N_EmploymentMgrForKeyDate view inner COMPOSITE
P_N_EmploymentMinPernr view from BASIC
P_N_EmployOrgDetOp view from BASIC
P_N_EmployStatDet view from BASIC
P_N_EmployWSDet view inner BASIC
P_N_PERSONWORKAGREEMENTTYPE view_entity inner BASIC
P_N_PersWrkAgrmtMgrForKeyDte view from BASIC
P_N_PersWrkAgrmtPosDet view from BASIC
P_PERSNWRKAGRMTROLEFOROPG view inner BASIC
P_PersnWrkAgrmtSrvcCostLvl_VR view inner BASIC
P_PERSONWORKAGREEMENTTYPE view inner BASIC
P_PersonWorkAgrmtPlndWrkgTime view from BASIC
P_PersonWorkAgrmtStatus view from BASIC
P_PersWrkAgrmtMinForOPg view inner BASIC
P_PersWrkAgrmtPosDet view union_all BASIC
P_wfd_d_assgmtdets view from BASIC
P_WorkforceAssignmentDetails view from BASIC

Fields (19)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY workforce_assgmt_id WFD_WORKFORCE_ASSGMT WorkForce Assgmt ID
KEY start_date WFD_START_DATE Start Date
end_date WFD_END_DATE End Date
employment_status WFD_EMPLYMT_STATUS Employment Status
employment_percent WFD_EMPLYMT_PERCENT Emplymt Percentage
company_code BUKRS Company Code
cost_center KOSTL Cost Center
controlling_area KOKRS CO Area
weekly_working_hours WFD_WEEKLY_WRKG_HRS Working Hours
weekly_working_days WFD_WEEKLY_WRKG_DAYS Working Days
job_title WFD_JOBTITLE Job Title
job_code WFD_JOB_CODE Job Code
manager_work_assgmt WFD_MANAGER_WORK_ASSGMT Manager Assgmt ID
country INTCA ISO Code
manager_work_assignment_ext_id WFD_MANAGER_ASSGMT_EXT_ID Manager External ID
main_employment_indicator WFD_MAIN_EMPLYMT_IND Primary Emplymt Ind.
block_ind WFD_BLOCKED Blocked Indicator
dummy_wfd_asgtdets_incl_eew_ps CFD_DUMMY Dummy

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 Details
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE WFD_D_ASSGMTDETS (
    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]
    EMPLOYMENT_STATUS,               -- Employment Status [WFD_EMPLYMT_STATUS]
    EMPLOYMENT_PERCENT,              -- Emplymt Percentage [WFD_EMPLYMT_PERCENT]
    COMPANY_CODE,                    -- Company Code [BUKRS]
    COST_CENTER,                     -- Cost Center [KOSTL]
    CONTROLLING_AREA,                -- CO Area [KOKRS]
    WEEKLY_WORKING_HOURS,            -- Working Hours [WFD_WEEKLY_WRKG_HRS]
    WEEKLY_WORKING_DAYS,             -- Working Days [WFD_WEEKLY_WRKG_DAYS]
    JOB_TITLE,                       -- Job Title [WFD_JOBTITLE]
    JOB_CODE,                        -- Job Code [WFD_JOB_CODE]
    MANAGER_WORK_ASSGMT,             -- Manager Assgmt ID [WFD_MANAGER_WORK_ASSGMT]
    COUNTRY,                         -- ISO Code [INTCA]
    MANAGER_WORK_ASSIGNMENT_EXT_ID,  -- Manager External ID [WFD_MANAGER_ASSGMT_EXT_ID]
    MAIN_EMPLOYMENT_INDICATOR,       -- Primary Emplymt Ind. [WFD_MAIN_EMPLYMT_IND]
    BLOCK_IND,                       -- Blocked Indicator [WFD_BLOCKED]
    DUMMY_WFD_ASGTDETS_INCL_EEW_PS,  -- Dummy [CFD_DUMMY]
    PRIMARY KEY (CLIENT, WORKFORCE_ASSGMT_ID, START_DATE)
);

Learn More