WFD_D_ASSGMTDETS

Transparent Table Application Table
19 Fields 41 CDS Views

Workforce Assignment Details

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

CDS Views using this table (41)

ViewTypeJoinVDMDescription
E_WorkforceAssignmentDetails view from EXTENSION Extended view for workforce assignment details
I_EmployDetOp view inner BASIC Employment details for OnPremise
I_EmployOrgDetOp view from BASIC Employment org details for onPremise
I_EmployStatDet view from BASIC Employment status
I_EmployWSDet view inner BASIC Employment working time details
I_PersnWrkAgrmtRoleForOPg view inner BASIC Person Work Agreement Role Details for Object Page
I_PersonWorkAgrmtOrglDetails view from BASIC Person Work Agreement Organization Details
I_PersonWorkAgrmtPlndWrkgTime view from BASIC Work Agreement Planned Working time
I_PersonWorkAgrmtSrvcCostLevel view inner BASIC Work Agreement Service Cost Level
I_PersonWorkAgrmtStatus view from BASIC Work Agreement Status
I_PersWrkAgrmtPosDet view from BASIC Person Work Agreement Details with Position
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_EmploymentManagerOP view inner BASIC Employment Manager for OnPremise
P_EMPLREPORTINGSTRUCTUREOP view inner BASIC Employment Reporting Structure for OnPremise
P_N_EmployDetOp view left_outer BASIC Employment details for OnPremise
P_N_Employment view from BASIC Employment
P_N_Employmentcostlevel view inner BASIC Employment Service Cost Level
P_N_EmploymentManager view inner BASIC Manager related to Employment
P_N_EmploymentMgrForKeyDate view inner COMPOSITE Employment Manager
P_N_EmploymentMinPernr view from BASIC Main Employment
P_N_EmployOrgDetOp view from BASIC Employment org details for onPremise
P_N_EmployStatDet view from BASIC Employment status
P_N_EmployWSDet view inner BASIC Employment working time details
P_N_PERSONWORKAGREEMENTTYPE view_entity inner BASIC Private View for Person Work Agrmnt Type
P_N_PersWrkAgrmtMgrForKeyDte view from BASIC Retrieve manager for given date
P_N_PersWrkAgrmtPosDet view from BASIC Person Work Agreement Details with Position
P_PERSNWRKAGRMTROLEFOROPG view inner BASIC Person Work Agreement Role Details for Object Page
P_PersnWrkAgrmtSrvcCostLvl_VR view inner BASIC Employment Service Cost Level
P_PersonWorkAgrmtPlndWrkgTime view from BASIC Work Agreement Planned Working time
P_PersonWorkAgrmtStatus view from BASIC Work Agreement Status
P_wfd_d_assgmtdets view from BASIC Read wfd_d_assgmtdets table
P_WORKASSIGNMENTDETAILS view_entity from BASIC Work Assignment Details
P_WorkforceAssignmentDetails view from BASIC Private view for workforce assignment details
R_WorkAssignmentDetailsActive view_entity from BASIC Work assignment Active WA Details
R_WorkAssignmentDetailsAll view_entity from BASIC Work assignment Details All
R_WorkAssignmentDetailsAll view_entity union BASIC Work assignment Details All

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
technical_inactive_ind wfd_technical_inactive_ind

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]
    TECHNICAL_INACTIVE_IND,          -- wfd_technical_inactive_ind
    PRIMARY KEY (CLIENT, WORKFORCE_ASSGMT_ID, START_DATE)
);

Learn More