C_EntProjectBriefHeaderTP
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)
| Source | Alias | Join Type |
|---|---|---|
| I_EnterpriseProjectTP_2 | I_EnterpriseProjectTP_2 | projection |
Associations (2)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..*] | C_EnterpriseProjectBriefCost | _ProjectCostLineItem | _ProjectCostLineItem.ProjectInternalID = $projection.ProjectInternalID |
| [0..1] | C_PPM_ProjectMemberContactCard | _Manager | _Manager.BusinessPartnerUUID = $projection.ProjectManagerUUID |
Annotations (10)
| Name | Value | Level | Field |
|---|---|---|---|
| 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)
| Service | Binding | Version | Contract | Release |
|---|---|---|---|---|
| ASQL_F2602 | ASQL_F2602 | C2 | NOT_RELEASED | |
| UI_ENTPROJECTBRIEF | UI_ENTPROJECTBRIEF | V2 | C1 | NOT_RELEASED |
Fiori Apps (1)
| App ID | App Name | Type | Description |
|---|---|---|---|
| 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)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| 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]
;
Learn More
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- OData Services in SAP S/4HANA Explained
- Service Bindings and Service Definitions in SAP S/4HANA
- SAP Fiori Apps Architecture — How Fiori Apps Connect to Data
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA