C_EnterpriseProjectBriefCost

DDL: C_ENTERPRISEPROJECTBRIEFCOST Type: view_entity CONSUMPTION Package: ODATA_PPM_PRO_PROJECT_BRIEF

Project Brief Cost line chart

C_EnterpriseProjectBriefCost is a Consumption CDS View that provides data about "Project Brief Cost line chart" in SAP S/4HANA. It reads from 1 data source (R_EnterpriseProject) and exposes 24 fields with key fields ProjectUUID, ProjectInternalID, YearMonth. It has 1 association to related views. It is exposed through 1 OData service (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
R_EnterpriseProject Project from

Associations (1)

CardinalityTargetAliasCondition
[1] I_CalendarMonth _CalendarMonth $projection.CalendarMonth = _CalendarMonth.CalendarMonth

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #CONSUMPTION view
EndUserText.label Project Brief Cost line chart view
ObjectModel.query.implementedBy ABAP:CL_EPPM_PROJ_COST_LINEITEM view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view

OData Services (1)

ServiceBindingVersionContractRelease
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 (24)

KeyFieldSource TableSource FieldDescription
KEY ProjectUUID R_EnterpriseProject ProjectUUID Project UUID
KEY ProjectInternalID R_EnterpriseProject ProjectInternalID Project Def.
KEY YearMonth Period YearMonth Year Month
CalendarYear Period CalendarYear Year
CalendarMonth Period CalendarMonth Calendar Month
CalendarMonthName
GlobalCurrency Global Currency
ActualAmountInGlobalCurrency Actual
PlanAmountInGlobalCurrency Plan
_ProfitCenter R_EnterpriseProject _ProfitCenter
ProfitCenter R_EnterpriseProject ProfitCenter Profit Center
_ControllingArea R_EnterpriseProject _ControllingArea
ControllingArea R_EnterpriseProject ControllingArea Controlling Area
_CalendarMonth _CalendarMonth
CompanyCode R_EnterpriseProject CompanyCode Receiver Company Code
EnterpriseProjectServiceOrg R_EnterpriseProject EnterpriseProjectServiceOrg Service Org.
EnterpriseProjectType R_EnterpriseProject EnterpriseProjectType Proj.type
EntProjectIsConfidential R_EnterpriseProject EntProjectIsConfidential Confidential
FunctionalArea R_EnterpriseProject FunctionalArea Sendr Fctl Area
Plant R_EnterpriseProject Plant Valuation Area
ProjectCategory
ProjectProfileCode R_EnterpriseProject ProjectProfileCode Project Profile
ResponsibleCostCenter R_EnterpriseProject ResponsibleCostCenter Responsible Cost Center
_EnterpriseProjectForUser R_EnterpriseProject _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_EnterpriseProjectBriefCost.
-- 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_EnterpriseProjectBriefCost AS
SELECT
  Project.ProjectUUID AS ProjectUUID,
  Project.ProjectInternalID AS ProjectInternalID,
  Period.YearMonth AS YearMonth,
  Period.CalendarYear AS CalendarYear,
  Period.CalendarMonth AS CalendarMonth,
  _CalendarMonth._Text[1:Language = $session.system_language].CalendarMonthName AS CalendarMonthName,
  cast( 'EUR' as abap.cuky ) AS GlobalCurrency,
  cast( 0 as /s4ppm/ovr_act_cos_in_glo_curr) AS ActualAmountInGlobalCurrency,
  cast( 0 as /s4ppm/ovr_act_cos_in_glo_curr) AS PlanAmountInGlobalCurrency,
  Project._ProfitCenter AS _ProfitCenter,
  Project.ProfitCenter AS ProfitCenter,
  Project._ControllingArea AS _ControllingArea,
  Project.ControllingArea AS ControllingArea,
  Project.CompanyCode AS CompanyCode,
  Project.EnterpriseProjectServiceOrg AS EnterpriseProjectServiceOrg,
  Project.EnterpriseProjectType AS EnterpriseProjectType,
  Project.EntProjectIsConfidential AS EntProjectIsConfidential,
  Project.FunctionalArea AS FunctionalArea,
  Project.Plant AS Plant,
  Project. ProjectCategory AS ProjectCategory,
  Project.ProjectProfileCode AS ProjectProfileCode,
  Project.ResponsibleCostCenter AS ResponsibleCostCenter,
  Project._EnterpriseProjectForUser AS _EnterpriseProjectForUser
FROM R_EnterpriseProject AS Project
LEFT OUTER JOIN I_CalendarMonth AS _CalendarMonth ON CalendarMonth = _CalendarMonth.CalendarMonth  -- association [1]
;