C_MstrProjTeamRespy

DDL: C_MSTRPROJTEAMRESPY SQL: CMPTEAMRESP Type: view CONSUMPTION
12 Fields 1 Data Sources 1 Associations

Master Project Team Responsibility

C_MstrProjTeamRespy is a Consumption CDS View that provides data about "Master Project Team Responsibility" in SAP S/4HANA. It reads from 1 data source (I_MstrProjTeamRespy) and exposes 12 fields with key fields WBSElementObject, ProjectRole, PersonnelNumber, UserID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_MstrProjTeamRespy Responsibilities from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_MstrProjRoleID _ProjectRole $projection.ProjectRole = _ProjectRole.ProjectRole

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CMPTEAMRESP view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #CONSUMPTION 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 (12)

KeyFieldSource TableSource FieldDescription
KEY WBSElementObject I_MstrProjTeamRespy WBSElementObject Object number
KEY ProjectRole I_MstrProjTeamRespy ProjectRole
KEY PersonnelNumber I_MstrProjTeamRespy PersonnelNumber Personnel No.
KEY UserID I_MstrProjTeamRespy UserID User Name
WBSElementExternalID I_MstrProjTeamRespy WBSElementExternalID WBS Element External ID
RoleText I_MstrProjTeamRespy RoleText
FirstName I_MstrProjTeamRespy FirstName First Name
LastName I_MstrProjTeamRespy LastName Last Name
_Text _ProjectRole _Text
MasterProjectTeamRole _ProjectRole ProjectRole
BusinessPartner I_MstrProjTeamRespy BusinessPartnerUUID UUID
_Employee I_MstrProjTeamRespy _Employee

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 C_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: CMPTEAMRESP

CREATE VIEW C_MstrProjTeamRespy AS
SELECT
  Responsibilities.WBSElementObject AS WBSElementObject,
  Responsibilities.ProjectRole AS ProjectRole,
  Responsibilities.PersonnelNumber AS PersonnelNumber,
  Responsibilities.UserID AS UserID,
  Responsibilities.WBSElementExternalID AS WBSElementExternalID,
  Responsibilities.RoleText AS RoleText,
  Responsibilities.FirstName AS FirstName,
  Responsibilities.LastName AS LastName,
  _ProjectRole._Text AS _Text,
  _ProjectRole.ProjectRole AS MasterProjectTeamRole,
  Responsibilities.BusinessPartnerUUID AS BusinessPartner,
  Responsibilities._Employee AS _Employee
FROM I_MstrProjTeamRespy AS Responsibilities
LEFT OUTER JOIN I_MstrProjRoleID AS _ProjectRole ON ProjectRole = _ProjectRole.ProjectRole  -- association [0..1]
;

Learn More