I_MstrProjTeamRespy

DDL: I_MSTRPROJTEAMRESPY SQL: IMPTEAMRESP Type: view COMPOSITE
20 Fields 3 Data Sources 2 Associations

Master Project Team Responsibility

I_MstrProjTeamRespy is a Composite CDS View that provides data about "Master Project Team Responsibility" in SAP S/4HANA. It reads from 3 data sources (I_WBSElement, I_MstrProjTeamMbrRespy, I_MstrProjTeamMember) and exposes 20 fields with key fields MasterProjectUUID, MstrProjTeamMemberUUID, ControllingObject, BusinessPartnerUUID, ProjectRole. It has 2 associations to related views.

Data Sources (3)

SourceAliasJoin Type
I_WBSElement _WBSElementDetails inner
I_MstrProjTeamMbrRespy MPRespy from
I_MstrProjTeamMember MPTeamMember inner

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_MstrProjRoleID _ProjectRole $projection.ProjectRole = _ProjectRole.ProjectRole
[0..1] I_WorkforcePerson _Employee $projection.BusinessPartnerUUID = _Employee.Person

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IMPTEAMRESP view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Master Project Team Responsibility view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY MasterProjectUUID I_MstrProjTeamMbrRespy MasterProjectUUID NodeID
KEY MstrProjTeamMemberUUID I_MstrProjTeamMbrRespy MstrProjTeamMemberUUID UUID
KEY ControllingObject I_MstrProjTeamMbrRespy ControllingObject Object number
KEY BusinessPartnerUUID I_MstrProjTeamMember BusinessPartner Issuing Authority
KEY ProjectRole I_MstrProjTeamMember MasterProjectTeamRole
KEY PersonnelNumber I_MstrProjTeamMember EmployeePersonnelNumber
WBSElementExternalID I_WBSElement WBSElement WBS Internal ID
WBSElementObject I_WBSElement WBSElementObject Object number
RoleText
Name I_MstrProjTeamMember ProjectResponsiblePerson
FirstName I_MstrProjTeamMember FirstName First Name
LastName I_MstrProjTeamMember LastName Last Name
UserID I_MstrProjTeamMember UserID User Name
CreationDate I_MstrProjTeamMember CreationDate Time Stamp
ChangedDateTime I_MstrProjTeamMember ChangedDateTime Time Stamp
ChangedBy I_MstrProjTeamMember ChangedBy User Name
CreatedByUser I_MstrProjTeamMember CreatedByUser User Name
_ProjectRole _ProjectRole
_Employee _Employee
_MasterProject _MasterProject

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_MstrProjTeamRespy.
-- 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: IMPTEAMRESP

CREATE VIEW I_MstrProjTeamRespy AS
SELECT
  MPRespy.MasterProjectUUID AS MasterProjectUUID,
  MPRespy.MstrProjTeamMemberUUID AS MstrProjTeamMemberUUID,
  MPRespy.ControllingObject AS ControllingObject,
  MPTeamMember.BusinessPartner AS BusinessPartnerUUID,
  MPTeamMember.MasterProjectTeamRole AS ProjectRole,
  MPTeamMember.EmployeePersonnelNumber AS PersonnelNumber,
  _WBSElementDetails.WBSElement AS WBSElementExternalID,
  _WBSElementDetails.WBSElementObject AS WBSElementObject,
  _ProjectRole._Text[1:Language = $session.system_language].ProjectRoleName AS RoleText,
  MPTeamMember.ProjectResponsiblePerson AS Name,
  MPTeamMember.FirstName AS FirstName,
  MPTeamMember.LastName AS LastName,
  MPTeamMember.UserID AS UserID,
  MPTeamMember.CreationDate AS CreationDate,
  MPTeamMember.ChangedDateTime AS ChangedDateTime,
  MPTeamMember.ChangedBy AS ChangedBy,
  MPTeamMember.CreatedByUser AS CreatedByUser
FROM I_MstrProjTeamMbrRespy AS MPRespy
INNER JOIN I_MstrProjTeamMember AS MPTeamMember ON /* join condition not captured in parsed metadata */
INNER JOIN I_WBSElement AS _WBSElementDetails ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MstrProjRoleID AS _ProjectRole ON ProjectRole = _ProjectRole.ProjectRole  -- association [0..1]
LEFT OUTER JOIN I_WorkforcePerson AS _Employee ON BusinessPartnerUUID = _Employee.Person  -- association [0..1]
;

Learn More