C_EntProjectBriefHeaderTP

DDL: C_ENTPROJECTBRIEFHEADERTP Type: view_entity CONSUMPTION Package: ODATA_PPM_PRO_PROJECT_BRIEF

Enterprise Project Brief Header

C_EntProjectBriefHeaderTP is a Consumption CDS View that provides data about "Enterprise Project Brief Header" in SAP S/4HANA. It reads from 1 data source (I_EnterpriseProjectTP_2) and exposes 53 fields with key field ProjectUUID. It has 2 associations to related views. It is exposed through 2 OData services (ASQL_F2602, UI_ENTPROJECTBRIEF). It is used in 1 Fiori application: Project Briefs. Part of development package ODATA_PPM_PRO_PROJECT_BRIEF.

Data Sources (1)

SourceAliasJoin Type
I_EnterpriseProjectTP_2 I_EnterpriseProjectTP_2 projection

Associations (2)

CardinalityTargetAliasCondition
[0..*] C_EnterpriseProjectBriefCost _ProjectCostLineItem _ProjectCostLineItem.ProjectInternalID = $projection.ProjectInternalID
[0..1] C_PPM_ProjectMemberContactCard _Manager _Manager.BusinessPartnerUUID = $projection.ProjectManagerUUID

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
EndUserText.label Enterprise Project Brief Header view
Metadata.allowExtensions true view
VDM.viewType #CONSUMPTION view
ObjectModel.representativeKey ProjectUUID view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
Search.searchable true view

OData Services (2)

ServiceBindingVersionContractRelease
ASQL_F2602 ASQL_F2602 C2 NOT_RELEASED
UI_ENTPROJECTBRIEF UI_ENTPROJECTBRIEF V2 C1 NOT_RELEASED

Fiori Apps (1)

App IDApp NameTypeDescription
F2602 Project Briefs Transactional

Project Briefs

Business Role: Project Manager

With this app, you can edit and display key attributes of the enterprise projects that you are authorized to access or maintain either as a project financial controller or because you are assigned to the project. You can display an overview with summary information about all your projects, and drill down to obtain further details about individual projects. As the project manager or financial controller of a project, you can plan milestones, staff the project, and document its progress and performance in the project brief. In this way, you summarize the information essential for project reviews in steering committee meetings. As a member of the project steering committee, you can display this information in the project brief.

Key Features: You can use this app to do the following: Get an overview of your projects and their most important attributes at a glance, for example: Name and ID of the project Project manager Planned finish of the earliest main milestone defined for the project and its WBS elements In active projects, the planned finish of the earliest upcoming or overdue milestone defined for the project and its active WBS elements. A milestone is upcoming or overdue if no actual date has been recorded for it yet. A project or WBS element is active if it has the processing status Partially Released or Released. Overall project status Actual versus planned project cost up to the current date By default, the projects are sorted by their overall status and its current trend. Drill down to a specific project brief to display further details, such as: A summary of the most important project attributes as listed above General project information, such as project dates, type and priority Detailed status information, such as: The overall project status with its current trend and related comments All detailed status areas active in your solution, such as Schedule or Cost, with their status values, trend and comments Information about all milestones, including the main milestones, that are defined at project level, such as: Their planned, forecasted, and actual finish Their approval status Information about project costs: View a chart showing the actual cost of the project excluding assigned orders in relation to the planned cost per period. Drill further down to the Project Cost Report app to display cost details of the selected project. Note, however, that resources assigned to the Team Member role are not authorized to display project costs. The responsibilities defined for the project by assigning resources to project roles, such as Project Financial Controller or Steering Committee Member Information about objects that are related to the project. Currently, only one object of type Collaborative Project in SAP Project and Resource Management or type Collaboration in SAP Intelligent Product Design can be linked to a project as a related object. You can access the related object from the project brief. For more information, see Project Collaboration. The documents and URLs attached to the project You can open the attachments from the project brief. Navigate to the Change Documents - Projects app to display the changes made to a project. Open related apps, such as the Monitor Project Progress app or the My Projects - Key Figures app, for one or more projects. As the financial controller or project manager assigned to a project, or as a financial controller whose area of responsibility includes maintenance rights for the project, you can also use this app to: Edit data of projects that are neither locked nor completed or closed: Change project name and dates Enter or change a project type and priority to categorize projects for reporting purposes Enter or change status values, trends, and comments. Create new milestones at project level, change existing milestones, and record their current approval status. Record actual dates for milestones in active projects. A project is active if it has the processing status Partially Released or Released. Note When you set the actual finish date for a milestone that is used in a billing plan, the billing block for the relevant billing plan item is automatically removed. The entry in the Used for Billing column indicates if the milestone is used in a billing plan. Define project responsibilities by assigning resources to project roles except the Project Manager role. Create a related object of type Collaborative Project in SAP Project and Resource Management or type Collaboration in SAP Intelligent Product Design for the project. For more information, see Project Collaboration. Add documents or URLs as attachments to a projects, and manage existing attachments. For more information, see Attachments. Change the processing status of a project when it has reached a new stage in its lifecycle. For more information, see Processing Status for Projects and WBS Elements. Navigate to the Project Planning or Project Control - Enterprise Projects app to maintain the work breakdown structure of a project or to edit the master data of the project and its WBS elements. Delete projects that have not yet been released. With this feature, you delete the entire project including its WBS elements and links to related objects. Note, however, that the linked object itself is not automatically deleted along with the project.

Fields (53)

KeyFieldSource TableSource FieldDescription
KEY ProjectUUID ProjectUUID Project UUID
ProjectSummaryTaskUUID ProjectSummaryTaskUUID Entity GUID
ProjectInternalID ProjectInternalID Project Def.
WBSElementInternalID WBSElementInternalID WBS Internal ID
Project PROJECT Project WBS Element
ProjectName ProjectDescription Project Name
ProjectProfileCode ProjectProfileCode Project Profile
OverallProjectStatus
StatusTrend
OverallProjectStsCriticality
StatusTrendCriticality
OverallProjectStatusSort
StatusTrendSort
StatusDescription
StatusTrendDescription
NextRelevantMlstnDate _NextRlvtMilestone NextRelevantMlstnDate
NextRelevantMlstnName _NextRlvtMilestone NextRelevantMlstnName
NextEssentialMlstnDate _NextEsnlMilestone NextEssentialMlstnDate
NextEssentialMlstnName _NextEsnlMilestone NextEssentialMlstnName
ProjectStartDate ProjectStartDate Latest Planned Start
ProjectEndDate ProjectEndDate Ltst Planned Finish
ActualStartDate ActualStartDate Actual Start
ActualEndDate ActualEndDate Actual Finish
ProcessingStatus ProcessingStatus Worklist Status
PriorityCode PriorityCode Priority
PriorityCodeName
EnterpriseProjectType EnterpriseProjectType Proj.type
EntProjectObjectWorkflowStatus _EntProjWorkflowOverview EntProjectObjectWorkflowStatus Workflow Status
EntProjObjWorkflowStatusText _EntProjWorkflowOverview EntProjObjWorkflowStatusText
GlobalCurrency _ControllingArea ControllingAreaCurrency
ProjectManagerUUID
PersonFullName
IsMyProject _EntProjUserRoleAssignment IsMyProject
IsProjectSteeringCommitteeMbr _EntProjUserRoleAssignment IsProjectSteeringCommitteeMbr
curr252
curr252
curr252
curr252
curr252
char1
ProjectCategory ProjectCategory Proj. Category
EntProjectIsConfidential EntProjectIsConfidential Confidential
EnterpriseProjectServiceOrg EnterpriseProjectServiceOrg Service Org.
CompanyCode CompanyCode Receiver Company Code
Plant Plant Valuation Area
FunctionalArea FunctionalArea Sendr Fctl Area
ResponsibleCostCenter ResponsibleCostCenter Responsible Cost Center
ProfitCenter ProfitCenter Profit Center
ControllingArea ControllingArea Controlling Area
_Manager _Manager
_ProjectCostLineItem _ProjectCostLineItem
_EnterpriseProjectTypeText _EnterpriseProjectTypeText
_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_EntProjectBriefHeaderTP.
-- 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_EntProjectBriefHeaderTP AS
SELECT
  ProjectUUID,
  ProjectSummaryTaskUUID,
  ProjectInternalID,
  WBSElementInternalID,
  PROJECT.Project AS Project,
  ProjectDescription AS ProjectName,
  ProjectProfileCode,
  _StatusAreaData[ IsOverallStatus = 'X' ].StatusAreaStatus AS OverallProjectStatus,
  _StatusAreaData[ IsOverallStatus = 'X' ].StatusTrend AS StatusTrend,
  _StatusAreaData[ IsOverallStatus = 'X' ]._StatusAreaStatus.Criticality AS OverallProjectStsCriticality,
  _StatusAreaData[ IsOverallStatus = 'X' ]._StatusAreaTrend.Criticality AS StatusTrendCriticality,
  _StatusAreaData[ IsOverallStatus = 'X' ]._StatusAreaCode.SortField AS OverallProjectStatusSort,
  _StatusAreaData[ IsOverallStatus = 'X' ]._StatusAreaTrend.SortField AS StatusTrendSort,
  _StatusAreaData[ IsOverallStatus = 'X' ]._StatusAreaStatus.StatusDescription AS StatusDescription,
  _StatusAreaData[ IsOverallStatus = 'X' ]._StatusAreaTrend.StatusTrendDescription AS StatusTrendDescription,
  _NextRlvtMilestone.NextRelevantMlstnDate AS NextRelevantMlstnDate,
  _NextRlvtMilestone.NextRelevantMlstnName AS NextRelevantMlstnName,
  _NextEsnlMilestone.NextEssentialMlstnDate AS NextEssentialMlstnDate,
  _NextEsnlMilestone.NextEssentialMlstnName AS NextEssentialMlstnName,
  ProjectStartDate,
  ProjectEndDate,
  ActualStartDate,
  ActualEndDate,
  ProcessingStatus,
  PriorityCode,
  _PriorityText[1: LanguageCode = $session.system_language].PriorityCodeName AS PriorityCodeName,
  EnterpriseProjectType,
  _EntProjWorkflowOverview.EntProjectObjectWorkflowStatus AS EntProjectObjectWorkflowStatus,
  _EntProjWorkflowOverview.EntProjObjWorkflowStatusText AS EntProjObjWorkflowStatusText,
  _ControllingArea.ControllingAreaCurrency AS GlobalCurrency,
  _EntProjRoleStaffing[1:ProjectRoleType = 'YP_RL_0001'].BusinessPartnerUUID AS ProjectManagerUUID,
  _EntProjRoleStaffing[1:ProjectRoleType = 'YP_RL_0001']._BusinessPartner.PersonFullName AS PersonFullName,
  _EntProjUserRoleAssignment.IsMyProject AS IsMyProject,
  _EntProjUserRoleAssignment.IsProjectSteeringCommitteeMbr AS IsProjectSteeringCommitteeMbr,
  virtual ActualCost : abap.curr( 25, 2 ) AS curr252,
  virtual CostDvtnUpToCurPerdCritlty : abap.char( 1 ) AS char1,
  ProjectCategory,
  EntProjectIsConfidential,
  EnterpriseProjectServiceOrg,
  CompanyCode,
  Plant,
  FunctionalArea,
  ResponsibleCostCenter,
  ProfitCenter,
  ControllingArea
FROM I_EnterpriseProjectTP_2
LEFT OUTER JOIN C_EnterpriseProjectBriefCost AS _ProjectCostLineItem ON _ProjectCostLineItem.ProjectInternalID = ProjectInternalID  -- association [0..*]
LEFT OUTER JOIN C_PPM_ProjectMemberContactCard AS _Manager ON _Manager.BusinessPartnerUUID = ProjectManagerUUID  -- association [0..1]
;