R_PPM_ProjectTask

DDL: R_PPM_PROJECTTASK Type: view_entity BASIC
51 Fields 1 Data Sources 1 Associations

Enterprise Project Element Internal

R_PPM_ProjectTask is a Basic CDS View that provides data about "Enterprise Project Element Internal" in SAP S/4HANA. It reads from 1 data source (P_EnterpriseProjectElement) and exposes 51 fields with key field ProjectElementUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
P_EnterpriseProjectElement ProjectElement from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_EnterpriseProjectForUser _EnterpriseProjectForUser _EnterpriseProjectForUser.ProjectUUID = $projection.ProjectUUID

Annotations (9)

NameValueLevelField
EndUserText.label Enterprise Project Element Internal view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ObjectModel.representativeKey ProjectElementUUID view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (51)

KeyFieldSource TableSource FieldDescription
KEY ProjectElementUUID P_EnterpriseProjectElement ProjectElementUUID Obj Link Entity GUID
ProjectElement P_EnterpriseProjectElement ProjectElement Proj Element ID
ProjectUUID P_EnterpriseProjectElement ProjectUUID Project UUID
ProjectElementDescription P_EnterpriseProjectElement ProjectElementDescription Name
ProcessingStatus P_EnterpriseProjectElement ProcessingStatus Worklist Status
PlannedStartDate P_EnterpriseProjectElement PlannedStartDate Latest Planned Start
PlannedEndDate P_EnterpriseProjectElement PlannedEndDate Ltst Planned Finish
ActualStartDate P_EnterpriseProjectElement ActualStartDate Actual Start
ActualFinishDate P_EnterpriseProjectElement ActualFinishDate Actual Finish
SortingNumber P_EnterpriseProjectElement SortingNumber Field of length 16
EntProjectElementObjectType P_EnterpriseProjectElement EntProjectElementObjectType Object Category
EntProjectElementType P_EnterpriseProjectElement EntProjectElementType Task Type
TaskTemplateUUID P_EnterpriseProjectElement TaskTemplateUUID Entity GUID
IsProjectMilestone P_EnterpriseProjectElement IsProjectMilestone Milestone
TaxJurisdiction P_EnterpriseProjectElement TaxJurisdiction Tax Jurisdiction
FunctionalLocation P_EnterpriseProjectElement FunctionalLocation Object ID
WBSElementIsBillingElement P_EnterpriseProjectElement WBSElementIsBillingElement Billing elem.
WBSElementInternalID P_EnterpriseProjectElement WBSElementInternalID WBS Internal ID
ProjectInternalID P_EnterpriseProjectElement ProjectInternalID Project Def.
WBSIsStatisticalWBSElement P_EnterpriseProjectElement WBSIsStatisticalWBSElement Statistical
CompanyCode P_EnterpriseProjectElement CompanyCode Receiver Company Code
ControllingArea P_EnterpriseProjectElement ControllingArea Controlling Area
ProfitCenter P_EnterpriseProjectElement ProfitCenter Profit Center
FactoryCalendar P_EnterpriseProjectElement FactoryCalendar Factory Calendar
CostCenter P_EnterpriseProjectElement CostCenter Cost Center
CostingSheet P_EnterpriseProjectElement CostingSheet Costing Sheet
FunctionalArea P_EnterpriseProjectElement FunctionalArea Sendr Fctl Area
InvestmentProfile P_EnterpriseProjectElement InvestmentProfile Investment Measure Profile
AssetLocation P_EnterpriseProjectElement AssetLocation Location
Plant P_EnterpriseProjectElement Plant Valuation Area
ResponsibleCostCenter P_EnterpriseProjectElement ResponsibleCostCenter Responsible Cost Center
ResultAnalysisInternalID P_EnterpriseProjectElement ResultAnalysisInternalID Results Analysis Key
LeadingSalesOrder P_EnterpriseProjectElement LeadingSalesOrder Sales Document
LeadingSalesOrderItem P_EnterpriseProjectElement LeadingSalesOrderItem Item
CreatedByUser P_EnterpriseProjectElement CreatedByUser User Name
CreationDateTime P_EnterpriseProjectElement CreationDateTime Timestamp
LastChangedByUser P_EnterpriseProjectElement LastChangedByUser User Name
LastChangeDateTime P_EnterpriseProjectElement LastChangeDateTime Timestamp
_CompanyCode P_EnterpriseProjectElement _CompanyCode
_ControllingArea P_EnterpriseProjectElement _ControllingArea
_CostCenter P_EnterpriseProjectElement _CostCenter
_EnterpriseProject P_EnterpriseProjectElement _EnterpriseProject
_FactoryCalendar P_EnterpriseProjectElement _FactoryCalendar
_FunctionalArea P_EnterpriseProjectElement _FunctionalArea
_Hierarchy P_EnterpriseProjectElement _Hierarchy
_Plant P_EnterpriseProjectElement _Plant
_ProcessingStatus P_EnterpriseProjectElement _ProcessingStatus
_ProfitCenter P_EnterpriseProjectElement _ProfitCenter
_Project P_EnterpriseProjectElement _Project
_ResponsibleCostCenter P_EnterpriseProjectElement _ResponsibleCostCenter
_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 R_PPM_ProjectTask.
-- 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 R_PPM_ProjectTask AS
SELECT
  ProjectElement.ProjectElementUUID AS ProjectElementUUID,
  ProjectElement.ProjectElement AS ProjectElement,
  ProjectElement.ProjectUUID AS ProjectUUID,
  ProjectElement.ProjectElementDescription AS ProjectElementDescription,
  ProjectElement.ProcessingStatus AS ProcessingStatus,
  ProjectElement.PlannedStartDate AS PlannedStartDate,
  ProjectElement.PlannedEndDate AS PlannedEndDate,
  ProjectElement.ActualStartDate AS ActualStartDate,
  ProjectElement.ActualFinishDate AS ActualFinishDate,
  ProjectElement.SortingNumber AS SortingNumber,
  ProjectElement.EntProjectElementObjectType AS EntProjectElementObjectType,
  ProjectElement.EntProjectElementType AS EntProjectElementType,
  ProjectElement.TaskTemplateUUID AS TaskTemplateUUID,
  ProjectElement.IsProjectMilestone AS IsProjectMilestone,
  ProjectElement.TaxJurisdiction AS TaxJurisdiction,
  ProjectElement.FunctionalLocation AS FunctionalLocation,
  ProjectElement.WBSElementIsBillingElement AS WBSElementIsBillingElement,
  ProjectElement.WBSElementInternalID AS WBSElementInternalID,
  ProjectElement.ProjectInternalID AS ProjectInternalID,
  ProjectElement.WBSIsStatisticalWBSElement AS WBSIsStatisticalWBSElement,
  ProjectElement.CompanyCode AS CompanyCode,
  ProjectElement.ControllingArea AS ControllingArea,
  ProjectElement.ProfitCenter AS ProfitCenter,
  ProjectElement.FactoryCalendar AS FactoryCalendar,
  ProjectElement.CostCenter AS CostCenter,
  ProjectElement.CostingSheet AS CostingSheet,
  ProjectElement.FunctionalArea AS FunctionalArea,
  ProjectElement.InvestmentProfile AS InvestmentProfile,
  ProjectElement.AssetLocation AS AssetLocation,
  ProjectElement.Plant AS Plant,
  ProjectElement.ResponsibleCostCenter AS ResponsibleCostCenter,
  ProjectElement.ResultAnalysisInternalID AS ResultAnalysisInternalID,
  ProjectElement.LeadingSalesOrder AS LeadingSalesOrder,
  ProjectElement.LeadingSalesOrderItem AS LeadingSalesOrderItem,
  ProjectElement.CreatedByUser AS CreatedByUser,
  ProjectElement.CreationDateTime AS CreationDateTime,
  ProjectElement.LastChangedByUser AS LastChangedByUser,
  ProjectElement.LastChangeDateTime AS LastChangeDateTime,
  ProjectElement._CompanyCode AS _CompanyCode,
  ProjectElement._ControllingArea AS _ControllingArea,
  ProjectElement._CostCenter AS _CostCenter,
  ProjectElement._EnterpriseProject AS _EnterpriseProject,
  ProjectElement._FactoryCalendar AS _FactoryCalendar,
  ProjectElement._FunctionalArea AS _FunctionalArea,
  ProjectElement._Hierarchy AS _Hierarchy,
  ProjectElement._Plant AS _Plant,
  ProjectElement._ProcessingStatus AS _ProcessingStatus,
  ProjectElement._ProfitCenter AS _ProfitCenter,
  ProjectElement._Project AS _Project,
  ProjectElement._ResponsibleCostCenter AS _ResponsibleCostCenter
FROM P_EnterpriseProjectElement AS ProjectElement
LEFT OUTER JOIN I_EnterpriseProjectForUser AS _EnterpriseProjectForUser ON _EnterpriseProjectForUser.ProjectUUID = ProjectUUID  -- association [0..1]
;

Learn More