C_EntProjTeamRoleStaffIntTP

DDL: C_ENTPROJTEAMROLESTAFFINTTP Type: view_entity CONSUMPTION
10 Fields 1 Data Sources 1 Associations

Enterprise Project Role Staffing Internal

C_EntProjTeamRoleStaffIntTP is a Consumption CDS View that provides data about "Enterprise Project Role Staffing Internal" in SAP S/4HANA. It reads from 1 data source (R_EntProjTeamRoleStaffIntTP) and exposes 10 fields with key field ProjectEntitlementUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
R_EntProjTeamRoleStaffIntTP R_EntProjTeamRoleStaffIntTP projection

Associations (1)

CardinalityTargetAliasCondition
[0..1] C_PPM_ProjectMemberContactCard _Manager _Manager.BusinessPartnerUUID = $projection.BusinessPartnerUUID

Annotations (8)

NameValueLevelField
EndUserText.label Enterprise Project Role Staffing Internal view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #CONSUMPTION view
Metadata.ignorePropagatedAnnotations true view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY ProjectEntitlementUUID ProjectEntitlementUUID Entitlement
ProjectUUID ProjectUUID Project UUID
TeamMemberUUID TeamMemberUUID Team Member
BusinessPartnerUUID BusinessPartnerUUID UUID
BusinessPartner BusinessPartner Issuing Authority
ProjectRoleType ProjectRoleType Role Type
PersonFullName _BusinessPartner PersonFullName Full Name
_BusinessPartner _BusinessPartner
_Manager _Manager
_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 C_EntProjTeamRoleStaffIntTP.
-- 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.

CREATE VIEW C_EntProjTeamRoleStaffIntTP AS
SELECT
  ProjectEntitlementUUID,
  ProjectUUID,
  TeamMemberUUID,
  BusinessPartnerUUID,
  BusinessPartner,
  ProjectRoleType,
  _BusinessPartner.PersonFullName AS PersonFullName
FROM R_EntProjTeamRoleStaffIntTP
LEFT OUTER JOIN C_PPM_ProjectMemberContactCard AS _Manager ON _Manager.BusinessPartnerUUID = BusinessPartnerUUID  -- association [0..1]
;

Learn More