Overview
WFD_D_ASSGMTDETS is a standard SAP S/4HANA table that stores Workforce Assignment Details data. The following is a list of CDS Views for WFD_D_ASSGMTDETS table.
A CDS view is a CDS entity that implmenets a view and is defined in a CDS data definition. They are defined for existing database tables, views, or other non-abstract CDS entities.
Using CDS views, you can rearrange and rename table fields to meet application-specific requirements. They are used to define rich semantic data models.
WFD_D_ASSGMTDETS CDS Views
The following table gives you an overview of the released standard CDS views for WFD_D_ASSGMTDETS table in S/4HANA 2020.
| CDS View Name | SQL View Name | Description |
|---|---|---|
| E_WORKFORCEASSIGNMENTDETAILS | EWRKFORCEASGMTDT | Extended view for workforce assignment details |
| I_WORKERSEARCH | IWORKERSEARCH | Workforce CDS view for OP |
| I_WORKFORCEASSIGNMENTDETAILS | IWRKFCASSGMTDETS | Workforce Assignment Details |
| P_EMPLOYMENTMANAGEROP | PEMPLMANAGEROP | Employment Manager for OnPremise |
| P_EMPLOYMENTMINPERNRSTOP_001 | PEMPLMINPERSTOP1 | Main Employment with Active Status |
| P_EMPLOYMENTOP_001 | PEMPLOYMENTOP001 | Employment for OnPremise |
| P_EMPLOYORGDETOP | PEMPLOYORGDETOP | Employment org details for onPremise |
| P_EMPLOYSTATDET | PEMPLOYSTATDET | Employment status |
| P_EMPLOYWSDET | PEMPLOYWSDET | Employment working time details |
| P_EMPLREPORTINGSTRUCTUREOP | PEMPLREPSTROP | Employment Reporting Structure for OnPremise |
| P_EMPLOYEELINEMANAGER | PLINEMANAGER | Employee Line Manager |
| P_N_EMPLOYMENTMINPERNR | PNEMPLMINPERNR | Main Employment |
| P_N_EMPLOYDETOP | PNEMPLOYDETOP | Employment details for OnPremise |
| P_N_EMPLOYMENT | PNEMPLOYMENT | Employment |
| P_N_EMPLOYORGDETOP | PNEMPLOYORGDETOP | Employment org details for onPremise |
| P_N_EMPLOYSTATDET | PNEMPLOYSTATDET | Employment status |
| P_N_EMPLOYWSDET | PNEMPLOYWSDET | Employment working time details |
| P_N_PERSWRKAGRMTPOSDET | PNPERSWRKAGRMTPS | Person Work Agreement Details with Position |
| P_N_PERSWRKAGRMTMGRFORKEYDTE | PNPERWRKAGRMTMGR | Retrieve manager for given date |
| P_PERSNWRKAGRMTROLEFOROPG | PPERSWKAGRMTROLE | Person Work Agreement Role Details for Object Page |
| P_PERSWRKAGRMTMINFOROPG | PPERSWKAGROBJ | Person Work Agreement Details for Object Page |
| P_PERSONWORKAGREEMENTTYPE | PPERSWKAGRTYPE | Person Work Agreement Type |
| P_PERSWRKAGRMTPOSDET | PPERSWRKAGRMTPOS | Person Work Agreement Details with Position |
| P_PERSONWORKAGRMTTOEXTERNALID | PPERWKAGREXT | Mapping Wrk agrmnt internal&External IDs |
| P_PERSONWORKAGRMTPLNDWRKGTIME | PPERWKAGRPLWTIME | Work Agreement Planned Working time |
| P_PERSONWORKAGRMTSTATUS | PPERWKAGRSTATUS | Work Agreement Status |
| P_WFD_D_ASSGMTDETS | PWFDDASSGMTDETS | Read wfd_d_assgmtdets table |
| P_WORKFORCEASSIGNMENTDETAILS | PWRKFCASSGMTDETS | Private view for workforce assignment details |