What is I_DevProjRoleEntityLink in SAP S/4HANA?

I_DevProjRoleEntityLink is a basic CDS view in SAP S/4HANA. PPM Entity Link Table Details It contains 9 fields.

Which tables does I_DevProjRoleEntityLink read from?

I_DevProjRoleEntityLink reads data from: dpr_entity_link.

What VDM layer is I_DevProjRoleEntityLink?

I_DevProjRoleEntityLink is classified as a Basic (interface) view providing a 1:1 representation of a database table.

I_DevProjRoleEntityLink

DDL: I_DEVPROJROLEENTITYLINK SQL: IROLEENTITY Type: view BASIC

9 Fields 1 Data Sources

PPM Entity Link Table Details

I_DevProjRoleEntityLink (Basic)

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

DevelopmentProjectEntityLink · R&D Engineering

I_DevProjRoleEntityLink is a Basic CDS View (Dimension) that provides data about "PPM Entity Link Table Details" in SAP S/4HANA. It reads from 1 data source (dpr_entity_link) and exposes 9 fields with key field ReferencedObjectUUIDRaw.

SAP Help Documentation

Category	CDS Views for Project Management
Data Category	Dimension
Status	Released

Purpose
This CDS view provides the prerequisites for answering the following business questions: Which tasks are assigned to a project role? How much work of a task is assigned to a business partner that is staffed to a role? It is not intended for use in SAP S/4HANA cloud.

Structure
Measures and Attributes Some important attributes are ReferencedObjectUUIDRaw, DevProjElmntUUID, BusinessPartnerUUID, DevProjElmntObjectType, IsBusinessPartnerResponsible, BusinessPartnerShadowRole and so on.

View on SAP Help Portal →

SAP API Hub

State	C1
Line of Business	R&D Engineering
Application Component	PPM-PRO-EXT-API
Capabilities	Data Source for Defining CDS Entities, Data Source in SQL Select, Analytical Dimension, Association Target for Defining CDS Entities, Data Source for Data Extraction
Package	R&D Engineering 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
dpr_entity_link	dpr_entity_link	from

Annotations (19)

Name	Value	Level
AbapCatalog.sqlViewName	IROLEENTITY	view
AbapCatalog.compiler.compareFilter	true	view
VDM.viewType	#BASIC	view
VDM.lifecycle.contract.type	#PUBLIC_LOCAL_API	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
ObjectModel.usageType.serviceQuality	#A	view
ObjectModel.usageType.sizeCategory	#XL	view
ObjectModel.representativeKey	ReferencedObjectUUIDRaw	view
ObjectModel.sapObjectNodeType.name	DevelopmentProjectEntityLink	view
ObjectModel.modelingPattern	#NONE	view
Analytics.internalName	#LOCAL	view
Analytics.dataCategory	#DIMENSION	view
Analytics.dataExtraction.enabled	true	view
Analytics.dataExtraction.delta.changeDataCapture.automatic	true	view
Metadata.ignorePropagatedAnnotations	true	view
Metadata.allowExtensions	true	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
AccessControl.authorizationCheck	#MANDATORY	view
EndUserText.label	PPM Entity Link Table Details	view

Fields (9)

Key	Field	Source Field	Description
KEY	ReferencedObjectUUIDRaw	guid	Application Object GUID
	DevProjElmntUUID	entity_guid	Application Object GUID
	BusinessPartnerUUID	participant_guid	Application Object GUID
	DevProjElmntObjectType	entity_type	Object Type in Project Planning
	IsBusinessPartnerResponsible	responsible	Responsibility
	BusinessPartnerShadowRole	concrete_role	Shadow Role (= Concrete Role)
	clientNULLasPlannedStartDate		Planned Start Date
	PlannedWorkQuantity	work_effort	Assigned Work
	PlannedWorkQuantityUnit	work_unit	Unit for Work

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_DevProjRoleEntityLink.
-- 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: IROLEENTITY

CREATE VIEW I_DevProjRoleEntityLink AS
SELECT
  guid AS ReferencedObjectUUIDRaw,
  entity_guid AS DevProjElmntUUID,
  participant_guid AS BusinessPartnerUUID,
  entity_type AS DevProjElmntObjectType,
  responsible AS IsBusinessPartnerResponsible,
  concrete_role AS BusinessPartnerShadowRole,
  tstmp_to_dats( beg_tmstmp , abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as PlannedStartDate AS clientNULLasPlannedStartDate,
  work_effort AS PlannedWorkQuantity,
  work_unit AS PlannedWorkQuantityUnit
FROM dpr_entity_link
;

Depth:

I_DevProjRoleEntityLink view

dpr_entity_link

I_DevRoleTaskAssignment view