SAP WFD_D_ASSGMT Workforce Assignment Table

Overview

WFD_D_ASSGMT is a standard SAP S/4HANA table that stores Workforce Assignment data. There are total 8 fields in the WFD_D_ASSGMT table. The following is a list of the fields that make up this table. Key fields are marked in blue.

The table WFD_D_ASSGMT 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_ASSGMT to other SAP tables and standard CDS views available based on WFD_D_ASSGMT table in S/4HANA 2020.

Techincal Settings of WFD_D_ASSGMT

Below are technical details of the table WFD_D_ASSGMT

  • Buffering not allowed
  • No buffering
  • Storage type is Column Store

List of WFD_D_ASSGMT Fields

The following table gives you an overview of the fields available in WFD_D_ASSGMT

FieldDescriptionData ElementCheck TableData TypeLength
CLIENTClientMANDTCLNT3
WORKFORCE_ASSGMT_IDWorkForce Assignment IDWFD_WORKFORCE_ASSGMTNUMC8
START_DATEStart DateWFD_START_DATEDATS8
END_DATEEnd DateWFD_END_DATEDATS8
BUSINESS_PARTNER_IDBusiness Partner NumberBU_PARTNERCHAR10
EXT_WORKFORCE_ASSGMT_UUIDExternal WorkForce Assignment IDWFD_EXT_WORKFORCE_ASSGMTCHAR100
BLOCK_INDBlocked IndicatorWFD_BLOCKEDCHAR1
IS_CONTINGENT_WORKERContingent Worker FlagWFD_CONTINGENT_WORKERCHAR1

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_ASSGMT

Other References