I_EntProjProjectRespPersn

DDL: I_ENTPROJPROJECTRESPPERSN SQL: IEPRJPRJRESPPRSN Type: view BASIC
16 Fields 2 Data Sources 1 Associations

Responsible Person for Project Header

I_EntProjProjectRespPersn is a Basic CDS View that provides data about "Responsible Person for Project Header" in SAP S/4HANA. It reads from 2 data sources (I_EnterpriseProject, I_EntProjectResponsiblePerson) and exposes 16 fields with key field EntProjResponsiblePersonUUID. It has 1 association to related views.

Data Sources (2)

SourceAliasJoin Type
I_EnterpriseProject _EnterpriseProject inner
I_EntProjectResponsiblePerson RespPerson from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_EnterpriseProjectForUser _EnterpriseProjectForUser _EnterpriseProjectForUser.ProjectUUID = $projection.ProjectUUID

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IEPRJPRJRESPPRSN view
VDM.viewType #BASIC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.representativeKey EntProjResponsiblePersonUUID view
EndUserText.label Responsible Person for Project Header view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY EntProjResponsiblePersonUUID I_EntProjectResponsiblePerson EntProjResponsiblePersonUUID Entity GUID
ProjectUUID I_EntProjectResponsiblePerson ProjectUUID Project UUID
ReferencedObjectUUID I_EntProjectResponsiblePerson ReferencedObjectUUID Referenced Object
BusinessPartnerUUID I_EntProjectResponsiblePerson BusinessPartnerUUID UUID
PersonWorkAgreement I_EntProjectResponsiblePerson PersonWorkAgreement Personnel No.
ProjectInternalID I_EntProjectResponsiblePerson ProjectInternalID Project Def.
WBSElementInternalID I_EntProjectResponsiblePerson WBSElementInternalID WBS Internal ID
CreatedByUser I_EntProjectResponsiblePerson CreatedByUser User Name
CreationDateTime I_EntProjectResponsiblePerson CreationDateTime Timestamp
LastChangedByUser I_EntProjectResponsiblePerson LastChangedByUser User Name
LastChangeDateTime I_EntProjectResponsiblePerson LastChangeDateTime Timestamp
_EnterpriseProject I_EntProjectResponsiblePerson _EnterpriseProject
_WorkforcePerson I_EntProjectResponsiblePerson _WorkforcePerson
_BusinessPartner I_EntProjectResponsiblePerson _BusinessPartner
_PersonWorkAgreement_1 I_EntProjectResponsiblePerson _PersonWorkAgreement_1
_EnterpriseProjectForUser _EnterpriseProjectForUser

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_EntProjProjectRespPersn.
-- 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: IEPRJPRJRESPPRSN

CREATE VIEW I_EntProjProjectRespPersn AS
SELECT
  RespPerson.EntProjResponsiblePersonUUID AS EntProjResponsiblePersonUUID,
  RespPerson.ProjectUUID AS ProjectUUID,
  RespPerson.ReferencedObjectUUID AS ReferencedObjectUUID,
  RespPerson.BusinessPartnerUUID AS BusinessPartnerUUID,
  RespPerson.PersonWorkAgreement AS PersonWorkAgreement,
  RespPerson.ProjectInternalID AS ProjectInternalID,
  RespPerson.WBSElementInternalID AS WBSElementInternalID,
  RespPerson.CreatedByUser AS CreatedByUser,
  RespPerson.CreationDateTime AS CreationDateTime,
  RespPerson.LastChangedByUser AS LastChangedByUser,
  RespPerson.LastChangeDateTime AS LastChangeDateTime,
  RespPerson._EnterpriseProject AS _EnterpriseProject,
  RespPerson._WorkforcePerson AS _WorkforcePerson,
  RespPerson._BusinessPartner AS _BusinessPartner,
  RespPerson._PersonWorkAgreement_1 AS _PersonWorkAgreement_1
FROM I_EntProjectResponsiblePerson AS RespPerson
INNER JOIN I_EnterpriseProject AS _EnterpriseProject ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_EnterpriseProjectForUser AS _EnterpriseProjectForUser ON _EnterpriseProjectForUser.ProjectUUID = ProjectUUID  -- association [0..1]
;

Learn More