What is I_WorkforcePersonDEX in SAP S/4HANA?

I_WorkforcePersonDEX is a composite CDS view in SAP S/4HANA. Workforce Person It contains 14 fields.

Which tables does I_WorkforcePersonDEX read from?

I_WorkforcePersonDEX reads data from: wfd_d_keymap.

What VDM layer is I_WorkforcePersonDEX?

I_WorkforcePersonDEX is classified as a Composite view that combines data from multiple basic views.

I_WorkforcePersonDEX

DDL: I_WORKFORCEPERSONDEX Type: view_entity COMPOSITE

14 Fields 1 Data Sources 3 Associations

Workforce Person

I_WorkforcePersonDEX (Composite)

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

Workforce Person · Human Resources

I_WorkforcePersonDEX is a Composite CDS View that provides data about "Workforce Person" in SAP S/4HANA. It reads from 1 data source (wfd_d_keymap) and exposes 14 fields with key field BusinessPartner. It has 3 associations to related views.

SAP Help Documentation

Category	CDS Views for Human Resources

Purpose
You can use this CDS view to retrieve the data related to a workforce person. This CDS view is enabled for data extraction. This CDS view provides the data to answer the following business question: How can I retrieve the data related to the workforce person based on the external ID of the 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 BusinessPartner Business Partner Number WorkforcePersonExternalID WorkforcePersonExternalID FirstName First Name of Workforce Person LastName Last Name of Workforce Person MiddleName Middle Name or Second Forename of Workforce Person PersonFullName Full Name of Workforce Person BirthName Name at birth of Workforce Person Initials "Middle Initial" or personal initials of Workforce Person NativePreferredLanguage Correspondence Language of Workforce Person LastNamePrefix Name Prefix of Workforce Person BusinessPartnerUUID Business Partner GUID UserID User ID of Workforce Person

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 . Note During the conversion of an employee to a service performer or vice versa, preference is given to the Employee role over the Service Performer role when it comes to displaying the Identification Type. This is because the duration of the role is not taken into consideration during conversion.

View on SAP Help Portal →

SAP API Hub

State	C1
Line of Business	Human Resources
Application Component	CA-WFD-BL
Capabilities	Data Source for Data Extraction
Package	Human Resources for SAP S/4HANA Cloud Private Edition

Documentation

Analytics with CDS Views — Build Analytics for S/4HANA Cloud Private Edition ABAP CDS views replicated to SAP Cloud Platform
CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA Cloud Private Edition Private Edition CDS Views on SAP Business Accelerator Hub
Create CDS View as API — Create CDS views in SAP S/4HANA Cloud Private Edition and consume them as APIs
Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
SAP Extensibility Explorer for SAP S/4HANA Cloud Private Edition — Explore SAP S/4HANA Cloud Private Edition Extensibility options by leveraging the sample scenarios from SAP
SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
VDM View Types — The Virtual Data Model in SAP S/4HANA Cloud Private Edition
View Browser — Search, browse and tag CDS Views

Data Sources (1)

Source	Alias	Join Type
wfd_d_keymap	keymap	inner

Associations (3)

Cardinality	Target	Alias	Condition
[0..*]	I_ServicePerformerToSuplr	_ServicePerformerToSupplier	`$projection.BusinessPartner = _ServicePerformerToSupplier.Person`
[0..1]	I_WorkplaceAddress	_WorkplaceAddress	`bp.BusinessPartnerUUID = _WorkplaceAddress.BusinessPartnerUUID`
[1..*]	I_WorkAssgmtDetsDEX	_WorkAssgmtDets	`$projection.BusinessPartner = _WorkAssgmtDets.BusinessPartner`

Annotations (11)

Name	Value	Level
AccessControl.authorizationCheck	#MANDATORY	view
AccessControl.personalData.blocking	#BLOCKED_DATA_EXCLUDED	view
VDM.viewType	#COMPOSITE	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	WorkforcePerson	view
Metadata.ignorePropagatedAnnotations	true	view
EndUserText.label	Workforce Person	view

Fields (14)

Key	Field	Source Table	Source Field	Description
KEY	BusinessPartner	bp	BusinessPartner	Business Partner Number
	FirstName	bp	FirstName	First Name of Business Partner (Person)
	LastName	bp	LastName	Last Name of Business Partner (Person)
	MiddleName	bp	MiddleName	Middle name or second forename of a person
	PersonFullName	bp	PersonFullName	Full Name
	BirthName	bp	BusinessPartnerBirthName	Name at birth of business partner
	Initials	bp	Initials	"Middle Initial" or personal initials
	NativePreferredLanguage	bp	CorrespondenceLanguage	Business Partner: Correspondence Language
	LastNamePrefix	bp	LastNamePrefix	Name Prefix (Key)
	BusinessPartnerUUID	bp	BusinessPartnerUUID	Business Partner GUID
	UserID	user	UserID	User Name
	_ServicePerformerToSupplier		_ServicePerformerToSupplier
	_WorkplaceAddress		_WorkplaceAddress
	_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_WorkforcePersonDEX.
-- 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_WorkforcePersonDEX AS
SELECT
  bp.BusinessPartner AS BusinessPartner,
  bp.FirstName AS FirstName,
  bp.LastName AS LastName,
  bp.MiddleName AS MiddleName,
  bp.PersonFullName AS PersonFullName,
  bp.BusinessPartnerBirthName AS BirthName,
  bp.Initials AS Initials,
  bp.CorrespondenceLanguage AS NativePreferredLanguage,
  bp.LastNamePrefix AS LastNamePrefix,
  bp.BusinessPartnerUUID AS BusinessPartnerUUID,
  user.UserID AS UserID
INNER JOIN wfd_d_keymap AS keymap ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ServicePerformerToSuplr AS _ServicePerformerToSupplier ON BusinessPartner = _ServicePerformerToSupplier.Person  -- association [0..*]
LEFT OUTER JOIN I_WorkplaceAddress AS _WorkplaceAddress ON bp.BusinessPartnerUUID = _WorkplaceAddress.BusinessPartnerUUID  -- association [0..1]
LEFT OUTER JOIN I_WorkAssgmtDetsDEX AS _WorkAssgmtDets ON BusinessPartner = _WorkAssgmtDets.BusinessPartner  -- association [1..*]
;

Depth:

I_WorkforcePersonDEX view_entity

wfd_d_keymap