I_WorkAssgmtToExtIDDEX

DDL: I_WORKASSGMTTOEXTIDDEX Type: view_entity BASIC
5 Fields 2 Data Sources

Ext IDs of Work Assgmt and Wrkfrc Person

I_WorkAssgmtToExtIDDEX (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_WorkAssgmtToExtIDDEX is a Basic CDS View that provides data about "Ext IDs of Work Assgmt and Wrkfrc Person" in SAP S/4HANA. It reads from 2 data sources (wfd_d_assgmt, wfd_d_keymap) and exposes 5 fields with key field WorkAssignment.

SAP Help Documentation

CategoryCDS Views for Human Resources
Purpose
You can use this CDS view to retrieve the data related to the external IDs of a work assignment and a workforce person. This CDS view is enabled for data extraction. This CDS view provides the data you need to answer the following business question: How do you get the data related to the external IDs of the work assignment and workforce person? 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

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

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 #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.sapObjectNodeType.name WorkAssignment view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Ext IDs of Work Assgmt and Wrkfrc Person view

Fields (5)

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

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_WorkAssgmtToExtIDDEX.
-- 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_WorkAssgmtToExtIDDEX 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
FROM wfd_d_keymap AS keymap
INNER JOIN wfd_d_assgmt AS assgmt ON /* join condition not captured in parsed metadata */
;

Learn More