C_EntProjWBSElementOPgTP

DDL: C_ENTPROJWBSELEMENTOPGTP Type: view_entity CONSUMPTION Package: ODATA_PPM_PRO_WORKPACKAGE

Enterprise Project WBS element object page

C_EntProjWBSElementOPgTP is a Consumption CDS View that provides data about "Enterprise Project WBS element object page" in SAP S/4HANA. It reads from 1 data source (I_EnterpriseProjectElementTP_2) and exposes 59 fields with key field TaskUUID. It has 1 association to related views. It is exposed through 2 OData services (ASQL_F3799, UI_ENTPROJECTWBSELEMENT). It is used in 1 Fiori application: WBS Element. Part of development package ODATA_PPM_PRO_WORKPACKAGE.

Data Sources (1)

SourceAliasJoin Type
I_EnterpriseProjectElementTP_2 I_EnterpriseProjectElementTP_2 projection

Associations (1)

CardinalityTargetAliasCondition
[0..1] C_EntProjWrkPckgProjectStatus _QuickViewStatus _QuickViewStatus.TaskUUID = Task.ProjectElementUUID

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ObjectModel.representativeKey TaskUUID view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #CONSUMPTION view
Metadata.allowExtensions true view
EndUserText.label Enterprise Project WBS element object page view

OData Services (2)

ServiceBindingVersionContractRelease
ASQL_F3799 ASQL_F3799 C2 NOT_RELEASED
UI_ENTPROJECTWBSELEMENT UI_ENTPROJECTWBSELEMENT V2 C1 NOT_RELEASED

Fiori Apps (1)

App IDApp NameTypeDescription
F3799 WBS Element Transactional This app is used to maintain detailed information for each WBS Element.

WBS Element

Business Role: Project Financial Controller

With this app, you can display and edit detailed master data for a work breakdown structure element (WBS element). A WBS element is a structure element of a specific enterprise project. This app enables you to edit the essential characteristics of a WBS element as well as parameters that control subsequent process steps, such as actual cost collection or period end closing.

Key Features: View the header data of a WBS element, such as its planned and actual dates, its processing status, and the associated project. Edit the organizational assignments of the WBS element, such as cost center, plant, and tax jurisdiction. Edit the planned start and finish of the WBS element and display its actual dates. Create milestones for the WBS element, maintain their current status, and enter dates. To set an actual finish date, the WBS element needs to have 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. Edit parameters that control subsequent process steps. Depending on the project profile, you can, for example, define the costing sheet used for overhead calculation, specify whether the WBS element is to be used as a billing element, or assign the default cost center for statistical postings. For more information on project profiles, see Project Profiles. Assign a profitability segment to WBS elements of projects with revenue, provided that the WBS element has been marked as billing element. For more information, see Assign Profitability Segment Open the Maintain Settlement Rule app to create and edit settlement rules for WBS elements of overhead projects and investment projects. Block specific functions for the WBS element, such as time recording or purchasing activities. Add or display attachments. Enter a detailed description of the WBS element. Receive information if budget consumption for the WBS element exceeds the thresholds defined in the availability control profile of the project. For more information, see Budget Threshold Exceeded.

Fields (59)

KeyFieldSource TableSource FieldDescription
KEY TaskUUID Task ProjectElementUUID Obj Link Entity GUID
ProcessingStatusText _ProcessingStatusText ProcessingStatusText
ProjectUUID Task ProjectUUID Project UUID
virtualEntProjIsPubSecMgmtActiveboolean
virtualEntProjElmntParIsBillgRlvtboolean
ProjectElement ProjectElement Proj Element ID
ProjectElementDescription ProjectElementDescription Name
PlannedStartDate PlannedStartDate Latest Planned Start
PlannedEndDate PlannedEndDate Ltst Planned Finish
ActualStartDate ActualStartDate Actual Start
ActualEndDate ActualEndDate Actual Finish
WBSElementInternalID Task WBSElementInternalID WBS Internal ID
virtualProjects4ppmtv_external_id
virtualProjectNames4ppmtv_name
virtualProjectProfileCodeprofidproj
ResponsibleCostCenter ResponsibleCostCenter Responsible Cost Center
ResponsibleCostCenterName _ResponsibleCostCenter CostCenterName Name
ProfitCenter ProfitCenter Profit Center
ProfitCenterName _ProfitCenter ProfitCenterName Profit Center Name
CompanyCode CompanyCode Receiver Company Code
CompanyCodeName _CompanyCode CompanyCodeName Company Name
Plant Plant Valuation Area
PlantName _Plant PlantName Plant Name
Location Location Text
WBSElementIsBillingElement WBSElementIsBillingElement Billing elem.
LeadingSalesOrder Task LeadingSalesOrder Sales Document
LeadingSalesOrderItem Task LeadingSalesOrderItem Item
ResultAnalysisInternalID Task ResultAnalysisInternalID Results Analysis Key
TaxJurisdiction TaxJurisdiction Tax Jurisdiction
FunctionalLocation Object ID
FunctionalLocationName _FunctionalLocationText FunctionalLocationName Functional Loc.
FunctionalArea FunctionalArea Sendr Fctl Area
FunctionalAreaName _FunctionalAreaText FunctionalAreaName Long Text
FactoryCalendar FactoryCalendar Factory Calendar
FactoryCalendarName _FactoryCalendarText FactoryCalendarName
CostingSheet CostingSheet Costing Sheet
InvestmentProfile InvestmentProfile Investment Measure Profile
InvestmentProfileName _InvestmentProfileText InvestmentProfileName
ControllingArea ControllingArea Controlling Area
ControllingAreaName _ControllingArea ControllingAreaName Long Text
CostCenter CostCenter Cost Center
CostCenterName _CostCenter CostCenterName Name
WBSIsStatisticalWBSElement WBSIsStatisticalWBSElement Statistical
EntProjectSettlementElement EntProjectSettlementElement settlementElement
EntProjIsSettlmtRuleInherited EntProjIsSettlmtRuleInherited Sttle Rule Inherited
EntProjProfitabilitySegment EntProjProfitabilitySegment
CreatedByUser CreatedByUser User Name
CreationDateTime CreationDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
LastChangeDateTime LastChangeDateTime Timestamp
ProcessingStatus ProcessingStatus Worklist Status
IsProjectMilestone IsProjectMilestone Milestone
char2
ParentObjectUUID ParentObjectUUID UUID Parent GO
MilestoneApprovalStatus MilestoneApprovalStatus Milestone Apprvl Sts
MilestoneApprovalStatusText _MilestoneApprovalStatusText MilestoneApprovalStatusText
IsMainMilestone IsMainMilestone Main Milestone
_QuickViewStatus _QuickViewStatus
_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_EntProjWBSElementOPgTP.
-- 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_EntProjWBSElementOPgTP AS
SELECT
  Task.ProjectElementUUID AS TaskUUID,
  _ProcessingStatusText.ProcessingStatusText AS ProcessingStatusText,
  Task.ProjectUUID AS ProjectUUID,
  virtual EntProjIsPubSecMgmtActive : boolean AS virtualEntProjIsPubSecMgmtActiveboolean,
  virtual EntProjElmntParIsBillgRlvt : boolean AS virtualEntProjElmntParIsBillgRlvtboolean,
  ProjectElement,
  ProjectElementDescription,
  PlannedStartDate,
  PlannedEndDate,
  ActualStartDate,
  ActualEndDate,
  Task.WBSElementInternalID AS WBSElementInternalID,
  virtual Project : /s4ppm/tv_external_id AS virtualProjects4ppmtv_external_id,
  virtual ProjectName : /s4ppm/tv_name AS virtualProjectNames4ppmtv_name,
  virtual ProjectProfileCode : profidproj AS virtualProjectProfileCodeprofidproj,
  ResponsibleCostCenter,
  _ResponsibleCostCenter.CostCenterName AS ResponsibleCostCenterName,
  ProfitCenter,
  _ProfitCenter.ProfitCenterName AS ProfitCenterName,
  CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  Plant,
  _Plant.PlantName AS PlantName,
  Location,
  WBSElementIsBillingElement,
  Task.LeadingSalesOrder AS LeadingSalesOrder,
  Task.LeadingSalesOrderItem AS LeadingSalesOrderItem,
  Task.ResultAnalysisInternalID AS ResultAnalysisInternalID,
  TaxJurisdiction,
  cast ( FunctionalLocation as functionallocation preserving type ) AS FunctionalLocation,
  _FunctionalLocationText.FunctionalLocationName AS FunctionalLocationName,
  FunctionalArea,
  _FunctionalAreaText.FunctionalAreaName AS FunctionalAreaName,
  FactoryCalendar,
  _FactoryCalendarText.FactoryCalendarName AS FactoryCalendarName,
  CostingSheet,
  InvestmentProfile,
  _InvestmentProfileText.InvestmentProfileName AS InvestmentProfileName,
  ControllingArea,
  _ControllingArea.ControllingAreaName AS ControllingAreaName,
  CostCenter,
  _CostCenter.CostCenterName AS CostCenterName,
  WBSIsStatisticalWBSElement,
  EntProjectSettlementElement,
  EntProjIsSettlmtRuleInherited,
  EntProjProfitabilitySegment,
  CreatedByUser,
  CreationDateTime,
  LastChangedByUser,
  LastChangeDateTime,
  ProcessingStatus,
  IsProjectMilestone,
  virtual EntProjectDataModelVersion : abap.char(2) AS char2,
  ParentObjectUUID,
  MilestoneApprovalStatus,
  _MilestoneApprovalStatusText.MilestoneApprovalStatusText AS MilestoneApprovalStatusText,
  IsMainMilestone
FROM I_EnterpriseProjectElementTP_2
LEFT OUTER JOIN C_EntProjWrkPckgProjectStatus AS _QuickViewStatus ON _QuickViewStatus.TaskUUID = Task.ProjectElementUUID  -- association [0..1]
;