C_EntProjWBSElementOPgTP

DDL: C_ENTPROJWBSELEMENTOPGTP Type: view_entity CONSUMPTION
54 Fields 1 Data Sources 1 Associations

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 54 fields with key field ProjectElementUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_EnterpriseProjectElementTP_2 I_EnterpriseProjectElementTP_2 projection

Associations (1)

CardinalityTargetAliasCondition
[0..1] C_EntProjWrkPckgProjectStatus _QuickViewStatus _QuickViewStatus.TaskUUID = $projection.ProjectElementUUID

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ObjectModel.representativeKey ProjectElementUUID view
ObjectModel.usageType.serviceQuality #D 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

Fields (54)

KeyFieldSource TableSource FieldDescription
KEY ProjectElementUUID 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
CreatedByUser CreatedByUser User Name
CreatedByUserName _CreatedByUser FullName Name
CreationDateTime CreationDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
LastChangedByUserName _LastChangedByUser FullName Name
LastChangeDateTime LastChangeDateTime Timestamp
ProcessingStatus ProcessingStatus Worklist Status
IsProjectMilestone IsProjectMilestone Milestone
char2
_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 ProjectElementUUID,
  _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,
  CreatedByUser,
  _CreatedByUser.FullName AS CreatedByUserName,
  CreationDateTime,
  LastChangedByUser,
  _LastChangedByUser.FullName AS LastChangedByUserName,
  LastChangeDateTime,
  ProcessingStatus,
  IsProjectMilestone,
  virtual EntProjectDataModelVersion : abap.char(2) AS char2
FROM I_EnterpriseProjectElementTP_2
LEFT OUTER JOIN C_EntProjWrkPckgProjectStatus AS _QuickViewStatus ON _QuickViewStatus.TaskUUID = ProjectElementUUID  -- association [0..1]
;

Learn More