What is I_WorkforcePersonPrimEmplymt in SAP S/4HANA?

I_WorkforcePersonPrimEmplymt is a composite CDS view in SAP S/4HANA. WorkForce Person Primary Employment It contains 6 fields.

Which tables does I_WorkforcePersonPrimEmplymt read from?

I_WorkforcePersonPrimEmplymt reads data from: I_WorkforceAssignmentDetails, I_WorkforceAssignmentKeyMap, P_WFD_GET_MINEPERNR.

What VDM layer is I_WorkforcePersonPrimEmplymt?

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

I_WorkforcePersonPrimEmplymt

DDL: I_WORKFORCEPERSONPRIMEMPLYMT SQL: IWRKPRSNPRIMEMP Type: view COMPOSITE Package: WFD_EMPLOYEE_FACTSHEET_BL

6 Fields 3 Data Sources

WorkForce Person Primary Employment

I_WorkforcePersonPrimEmplymt is a Composite CDS View that provides data about "WorkForce Person Primary Employment" in SAP S/4HANA. It reads from 3 data sources (I_WorkforceAssignmentDetails, I_WorkforceAssignmentKeyMap, P_WFD_GET_MINEPERNR) and exposes 6 fields with key field WorkforceAssignment. Part of development package WFD_EMPLOYEE_FACTSHEET_BL.

Data Sources (3)

Source	Alias	Join Type
I_WorkforceAssignmentDetails	assgmtdets	inner
I_WorkforceAssignmentKeyMap	keymap	inner
P_WFD_GET_MINEPERNR	mainEmployment	inner

Annotations (11)

Name	Value	Level
AbapCatalog.sqlViewName	IWRKPRSNPRIMEMP	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
AccessControl.authorizationCheck	#CHECK	view
ObjectModel.usageType.dataClass	#MASTER	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#L	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
VDM.viewType	#COMPOSITE	view
VDM.lifecycle.status	#DEPRECATED	view
EndUserText.label	WorkForce Person Primary Employment	view

Fields (6)

Key	Field	Source Table	Source Field	Description
KEY	WorkforceAssignment	I_WorkforceAssignmentDetails	WorkforceAssignment	WorkForce Assgmt ID
	WorkforceAssgmtStartDate	assgmt	WorkforceAssgmtStartDate	Valn start date
	CentralPerson	I_WorkforceAssignmentKeyMap	CentralPerson	WorkForce Master ID
	BusinessPartner	I_WorkforceAssignmentKeyMap	BusinessPartner	Issuing Authority
	WorkforceAssgmtEndDate	assgmt	WorkforceAssgmtEndDate	Valn End date
	WorkforceAssignmentStatus	I_WorkforceAssignmentDetails	WorkforceAssignmentStatus	Employment Status

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_WorkforcePersonPrimEmplymt.
-- 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.
-- SQL view name: IWRKPRSNPRIMEMP

CREATE VIEW I_WorkforcePersonPrimEmplymt AS
SELECT
  assgmtdets.WorkforceAssignment AS WorkforceAssignment,
  assgmt.WorkforceAssgmtStartDate AS WorkforceAssgmtStartDate,
  keymap.CentralPerson AS CentralPerson,
  keymap.BusinessPartner AS BusinessPartner,
  assgmt.WorkforceAssgmtEndDate AS WorkforceAssgmtEndDate,
  assgmtdets.WorkforceAssignmentStatus AS WorkforceAssignmentStatus
INNER JOIN I_WorkforceAssignmentDetails AS assgmtdets ON /* join condition not captured in parsed metadata */
INNER JOIN I_WorkforceAssignmentKeyMap AS keymap ON /* join condition not captured in parsed metadata */
INNER JOIN P_WFD_GET_MINEPERNR AS mainEmployment ON /* join condition not captured in parsed metadata */
;

Depth:

I_WorkforcePersonPrimEmplymt view