C_EntProjBriefRoleStaffingTP

DDL: C_ENTPROJBRIEFROLESTAFFINGTP Type: view_entity CONSUMPTION
26 Fields 1 Data Sources

Enterprise Project Brief role staffing

C_EntProjBriefRoleStaffingTP is a Consumption CDS View that provides data about "Enterprise Project Brief role staffing" in SAP S/4HANA. It reads from 1 data source (R_EntProjTeamRoleStaffIntTP) and exposes 26 fields with key field ProjectEntitlementUUID.

Data Sources (1)

SourceAliasJoin Type
R_EntProjTeamRoleStaffIntTP R_EntProjTeamRoleStaffIntTP projection

Annotations (12)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
VDM.viewType #CONSUMPTION view
ObjectModel.representativeKey ProjectEntitlementUUID view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
UI.headerInfo.typeName Responsibilities view
UI.headerInfo.typeNamePlural Resource Assignments view
UI.headerInfo.title.value PersonFullName view
UI.headerInfo.description.value PersonFullName view
EndUserText.label Enterprise Project Brief role staffing view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY ProjectEntitlementUUID ProjectEntitlementUUID Entitlement
ProjectUUID ProjectUUID Project UUID
TeamMemberUUID TeamMemberUUID Team Member
ProjectRoleUUID ProjectRoleUUID Role
ProjectRoleType ProjectRoleType Role
ProjectRoleTypeText _ProjectRoleTypeText ObjectName Object name
BusinessPartner BusinessPartner Issuing Authority
BusinessPartnerUUID BusinessPartnerUUID UUID
PersonFullName
EmailByBusinessPartnerUUID BusinessPartnerUUID UUID
DefaultEmailAddress _WorkplaceAddress DefaultEmailAddress
PhoneByBusinessPartnerUUID BusinessPartnerUUID UUID
NormalizedPhoneNumber _WorkplaceAddress NormalizedPhoneNumber
BuildingByBusinessPartnerUUID BusinessPartnerUUID UUID
WorkplaceBuilding _WorkplaceAddress Building Building code
RoomNmbrByBusinessPartnerUUID BusinessPartnerUUID UUID
RoomNumber _WorkplaceAddress RoomNumber Room Number
CreatedByUser CreatedByUser User Name
CreationDateTime CreationDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
LastChangeDateTime LastChangeDateTime Timestamp
_TeamMember _TeamMember
_Role _Role
_ProjectRoleTypeText _ProjectRoleTypeText
_WorkplaceAddress _WorkplaceAddress
_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_EntProjBriefRoleStaffingTP.
-- 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_EntProjBriefRoleStaffingTP AS
SELECT
  ProjectEntitlementUUID,
  ProjectUUID,
  TeamMemberUUID,
  ProjectRoleUUID,
  ProjectRoleType,
  _ProjectRoleTypeText.ObjectName AS ProjectRoleTypeText,
  BusinessPartner,
  BusinessPartnerUUID,
  _TeamMember._BusinessPartner.PersonFullName AS PersonFullName,
  BusinessPartnerUUID AS EmailByBusinessPartnerUUID,
  _WorkplaceAddress.DefaultEmailAddress AS DefaultEmailAddress,
  BusinessPartnerUUID AS PhoneByBusinessPartnerUUID,
  _WorkplaceAddress.NormalizedPhoneNumber AS NormalizedPhoneNumber,
  BusinessPartnerUUID AS BuildingByBusinessPartnerUUID,
  _WorkplaceAddress.Building AS WorkplaceBuilding,
  BusinessPartnerUUID AS RoomNmbrByBusinessPartnerUUID,
  _WorkplaceAddress.RoomNumber AS RoomNumber,
  CreatedByUser,
  CreationDateTime,
  LastChangedByUser,
  LastChangeDateTime
FROM R_EntProjTeamRoleStaffIntTP
;

Learn More