I_WorkAssignmentDEX

DDL: I_WORKASSIGNMENTDEX Type: view_entity BASIC
8 Fields 2 Data Sources 2 Associations

Work Assignments

I_WorkAssignmentDEX (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

WorkAssignment · Human Resources

I_WorkAssignmentDEX is a Basic CDS View that provides data about "Work Assignments" in SAP S/4HANA. It reads from 2 data sources (wfd_d_assgmt, wfd_d_keymap) and exposes 8 fields with key field WorkAssignment. It has 2 associations to related views.

SAP Help Documentation

CategoryCDS Views for Human Resources
Purpose
You can use this CDS view to retrieve the data related to the work assignments of the workforce person. This CDS view is enabled for data extraction. This CDS view provides the data to answer the following business questions: What are the work assignments related to workforce person? What is the validity of the work assignment? Whether the work assignment has the Is Contingent flag true? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations To use this CDS view, the following business catalogs need to be assigned to a user: SAP_WFD_BC_WRK_DSP_PC (Worker – Display) SAP_CMD_BC_BP_DISP_PC (is dependent catalog)

Structure
Further Important Fields Important fields in this view include: Field Name Description WorkAssignment ID for Work Assignment WorkAssignmentStartDate Start Date of Work Assignment WorkAssignmentEndDate End Date of Work Assignment WorkforcePersonExternalID External ID of the Workforce Person WorkAssignmentExternalID External ID of Work Assignment BusinessPartner Business Partner Number IsContingentWorker Flag for Contingent Worker

SAP Business Warehouse (SAP BW) Extraction
Data Extraction Type Full Delta (Delta-enabled with change data capture)

Data Integration and Extraction
Extracting data from SAP S/4HANA Cloud Public Edition to data consumers is supported via CDS views that are enabled for data extraction based on ABAP CDS technology. These extraction views are part of the virtual data model (VDM) and provide a stable and consistent interface to the data. The data extraction capabilities of the ABAP CDS views are organized by specific CDS annotations. These determine whether a CDS view is enabled for data extraction and which type of data extraction it supports (full or delta). For more information, see Data Integration .

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessHuman Resources
Application ComponentCA-WFD-BL
CapabilitiesData Source for Data Extraction
PackageHuman Resources for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (2)

SourceAliasJoin Type
wfd_d_assgmt assgmt inner
wfd_d_keymap keymap from

Associations (2)

CardinalityTargetAliasCondition
[1] I_WorkforcePersonDEX _WorkforcePerson $projection.BusinessPartner = _WorkforcePerson.BusinessPartner
[1..*] I_WorkAssgmtDetsDEX _WorkAssgmtDets $projection.BusinessPartner = _WorkAssgmtDets.BusinessPartner

Annotations (11)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
VDM.viewType #BASIC view
Analytics.dataExtraction.enabled true view
ObjectModel.modelingPattern #NONE view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.sapObjectNodeType.name WorkAssignment view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Work Assignments view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY WorkAssignment wfd_d_keymap workforce_assgmt_id WorkForce Assignment ID
WorkAssignmentStartDate wfd_d_assgmt start_date Valn start date
WorkAssignmentEndDate wfd_d_assgmt end_date Valn End date
WorkforcePersonExternalID wfd_d_keymap person_id_external External Person ID
WorkAssignmentExternalID wfd_d_keymap user_id User Scope
BusinessPartner wfd_d_keymap business_partner_id Business Partner Number
_WorkforcePerson _WorkforcePerson
_WorkAssgmtDets _WorkAssgmtDets

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_WorkAssignmentDEX.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_WorkAssignmentDEX AS
SELECT
  keymap.workforce_assgmt_id AS WorkAssignment,
  assgmt.start_date AS WorkAssignmentStartDate,
  assgmt.end_date AS WorkAssignmentEndDate,
  keymap.person_id_external AS WorkforcePersonExternalID,
  keymap.user_id AS WorkAssignmentExternalID,
  keymap.business_partner_id AS BusinessPartner
FROM wfd_d_keymap AS keymap
INNER JOIN wfd_d_assgmt AS assgmt ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_WorkforcePersonDEX AS _WorkforcePerson ON BusinessPartner = _WorkforcePerson.BusinessPartner  -- association [1]
LEFT OUTER JOIN I_WorkAssgmtDetsDEX AS _WorkAssgmtDets ON BusinessPartner = _WorkAssgmtDets.BusinessPartner  -- association [1..*]
;

Learn More