SAP WFD_D_ASSGMTDETS Workforce Assignment Details Table
Overview
WFD_D_ASSGMTDETS is a standard SAP S/4HANA table that stores Workforce Assignment Details data. There are total 18 fields in the WFD_D_ASSGMTDETS table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table WFD_D_ASSGMTDETS belongs to Business Logic in Workforce Domain (CA-WFD-BL) module and is located in the package Work Force Domain Persistence (WFD_BL_PERSISTENCE).
In addition, following links provide an overview of foreign key relationships, if any, that link WFD_D_ASSGMTDETS to other SAP tables and standard CDS views available based on WFD_D_ASSGMTDETS table in S/4HANA 2020.
Techincal Settings of WFD_D_ASSGMTDETS
Below are technical details of the table WFD_D_ASSGMTDETS
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of WFD_D_ASSGMTDETS Fields
The following table gives you an overview of the fields available in WFD_D_ASSGMTDETS
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| CLIENT | Client | MANDT | CLNT | 3 | |
| WORKFORCE_ASSGMT_ID | WorkForce Assignment ID | WFD_WORKFORCE_ASSGMT | WFD_D_ASSGMT | NUMC | 8 |
| START_DATE | Start Date | WFD_START_DATE | DATS | 8 | |
| END_DATE | End Date | WFD_END_DATE | DATS | 8 | |
| EMPLOYMENT_STATUS | Employment Status | WFD_EMPLYMT_STATUS | CHAR | 1 | |
| EMPLOYMENT_PERCENT | Employment Percentage | WFD_EMPLYMT_PERCENT | DEC | 5 | |
| COMPANY_CODE | Company Code | BUKRS | CHAR | 4 | |
| COST_CENTER | Cost Center | KOSTL | CHAR | 10 | |
| CONTROLLING_AREA | Controlling Area | KOKRS | CHAR | 4 | |
| WEEKLY_WORKING_HOURS | Working Hours in a Week | WFD_WEEKLY_WRKG_HRS | DEC | 5 | |
| WEEKLY_WORKING_DAYS | Working Days in a Week | WFD_WEEKLY_WRKG_DAYS | DEC | 4 | |
| JOB_TITLE | Job Title | WFD_JOBTITLE | CHAR | 256 | |
| JOB_CODE | Job Code | WFD_JOB_CODE | CHAR | 128 | |
| MANAGER_WORK_ASSGMT | Manager Assignment ID | WFD_MANAGER_WORK_ASSGMT | NUMC | 8 | |
| COUNTRY | Country ISO code | INTCA | CHAR | 2 | |
| MANAGER_WORK_ASSIGNMENT_EXT_ID | Manager External ID | WFD_MANAGER_ASSGMT_EXT_ID | CHAR | 100 | |
| MAIN_EMPLOYMENT_INDICATOR | Primary Employment Indicator | WFD_MAIN_EMPLYMT_IND | CHAR | 1 | |
| BLOCK_IND | Blocked Indicator | WFD_BLOCKED | CHAR | 1 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for WFD_D_ASSGMTDETS
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| WFD_D_ASSGMTDETS | WORKFORCE_ASSGMT_ID | 1: N | WFD_D_ASSGMT |