R_EntProjectElementDraft

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_EntProjectElementDraft.
-- 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_EntProjectElementDraft AS
SELECT
  EnterpriseProjectElementDraft.projectelementuuid AS ProjectElementUUID,
  EnterpriseProjectElementDraft.projectelement AS ProjectElement,
  EnterpriseProjectElementDraft.wbselementinternalid AS WBSElementInternalID,
  EnterpriseProjectElementDraft.projectuuid AS ProjectUUID,
  EnterpriseProjectElementDraft.projectelementdescription AS ProjectElementDescription,
  EnterpriseProjectElementDraft.parentobjectuuid AS ParentObjectUUID,
  EnterpriseProjectElementDraft.tasktemplateuuid AS TaskTemplateUUID,
  EnterpriseProjectElementDraft.projectelementordinalnumber AS ProjectElementOrdinalNumber,
  EnterpriseProjectElementDraft.processingstatus AS ProcessingStatus,
  EnterpriseProjectElementDraft.isprojectmilestone AS IsProjectMilestone,
  EnterpriseProjectElementDraft.plannedstartdate AS PlannedStartDate,
  EnterpriseProjectElementDraft.plannedenddate AS PlannedEndDate,
  EnterpriseProjectElementDraft.actualstartdate AS ActualStartDate,
  EnterpriseProjectElementDraft.actualenddate AS ActualEndDate,
  EnterpriseProjectElementDraft.responsiblecostcenter AS ResponsibleCostCenter,
  EnterpriseProjectElementDraft.companycode AS CompanyCode,
  EnterpriseProjectElementDraft.profitcenter AS ProfitCenter,
  EnterpriseProjectElementDraft.functionalarea AS FunctionalArea,
  EnterpriseProjectElementDraft.controllingarea AS ControllingArea,
  EnterpriseProjectElementDraft.plant AS Plant,
  EnterpriseProjectElementDraft.location AS Location,
  EnterpriseProjectElementDraft.taxjurisdiction AS TaxJurisdiction,
  EnterpriseProjectElementDraft.functionallocation AS FunctionalLocation,
  EnterpriseProjectElementDraft.entprojectelementtype AS EntProjectElementType,
  EnterpriseProjectElementDraft.factorycalendar AS FactoryCalendar,
  EnterpriseProjectElementDraft.costingsheet AS CostingSheet,
  EnterpriseProjectElementDraft.investmentprofile AS InvestmentProfile,
  EnterpriseProjectElementDraft.wbsisstatisticalwbselement AS WBSIsStatisticalWBSElement,
  EnterpriseProjectElementDraft.costcenter AS CostCenter,
  EnterpriseProjectElementDraft.wbselementisbillingelement AS WBSElementIsBillingElement,
  EnterpriseProjectElementDraft.resultanalysisinternalid AS ResultAnalysisInternalID,
  EnterpriseProjectElementDraft.leadingsalesorder AS LeadingSalesOrder,
  EnterpriseProjectElementDraft.leadingsalesorderitem AS LeadingSalesOrderItem,
  EnterpriseProjectElementDraft.entprojectelementobjecttype AS EntProjectElementObjectType,
  EnterpriseProjectElementDraft.createdbyuser AS CreatedByUser,
  EnterpriseProjectElementDraft.creationdatetime AS CreationDateTime,
  EnterpriseProjectElementDraft.lastchangedbyuser AS LastChangedByUser,
  EnterpriseProjectElementDraft.lastchangedatetime AS LastChangeDateTime,
  EnterpriseProjectElementDraft.milestoneapprovalstatus AS MilestoneApprovalStatus,
  EnterpriseProjectElementDraft.ismainmilestone AS IsMainMilestone,
  EnterpriseProjectElementDraft.hierarchynode AS HierarchyNode,
  EnterpriseProjectElementDraft.hierarchyparentnode AS HierarchyParentNode,
  EnterpriseProjectElementDraft.hierarchydistancefromroot AS HierarchyDistanceFromRoot,
  EnterpriseProjectElementDraft.hierarchydescendantcount AS HierarchyDescendantCount,
  EnterpriseProjectElementDraft.hierarchydrillstate AS HierarchyDrillState,
  EnterpriseProjectElementDraft.hierarchyrank AS HierarchyRank,
  EnterpriseProjectElementDraft.hierarchylevel AS HierarchyLevel,
  EnterpriseProjectElementDraft.entprojelmntdmndcpyisreqd AS EntProjElmntDmndCpyIsReqd,
  EnterpriseProjectElementDraft.entprojelmntsettlmtcpyisreqd AS EntProjElmntSettlmtCpyIsReqd,
  EnterpriseProjectElementDraft.entprojissettlmtruleinherited AS EntProjIsSettlmtRuleInherited,
  EnterpriseProjectElementDraft.entprojectsettlementelement AS EntProjectSettlementElement,
  EnterpriseProjectElementDraft.entprojprofitabilitysegment AS EntProjProfitabilitySegment,
  EnterpriseProjectElementDraft.projectcategory AS ProjectCategory,
  EnterpriseProjectElementDraft.enterpriseprojectserviceorg AS EnterpriseProjectServiceOrg,
  EnterpriseProjectElementDraft.draftentitycreationdatetime AS DraftEntityCreationDateTime,
  EnterpriseProjectElementDraft.draftentitylastchangedatetime AS DraftEntityLastChangeDateTime,
  EnterpriseProjectElementDraft.draftadministrativedatauuid AS DraftAdministrativeDataUUID,
  EnterpriseProjectElementDraft.draftfieldchanges AS DraftFieldChanges,
  EnterpriseProjectElementDraft.hasactiveentity AS HasActiveEntity,
  EnterpriseProjectElementDraft.draftentityoperationcode AS DraftEntityOperationCode,
  EnterpriseProjectElementDraft.entprojelmntdistributionoption AS EntProjElmntDistributionOption,
  _ProjectElement.ControllingArea AS ProjElmntCtrlgAreaForDisplay,
  _ProjectElement.ProfitCenter AS ProjElmntPrftCtrForDisplay,
  _ProjectElement.CompanyCode AS ProjElmntCoCodeForDisplay,
  _ProjectElement.ResponsibleCostCenter AS ProjElmntRespCostCtrForDisplay,
  _ProjectElement.Plant AS ProjectElementPlantForDisplay,
  _ProjectElement.FunctionalArea AS ProjElmntFuncnlAreaForDisplay,
  _EnterpriseProject.ProjectProfileCode AS ProjectProfileCode,
  _EnterpriseProject.EnterpriseProjectType AS EnterpriseProjectType,
  _ParentElement.ControllingArea AS EntProjParCtrlgAreaForDisplay,
  _ParentElement.ProfitCenter AS EntProjParPrftCtrForDisplay,
  _ParentElement.CompanyCode AS EntProjParCoCodeForDisplay,
  _ParentElement.ResponsibleCostCenter AS EntProjParRespCostCtrForDsp,
  _ParentElement.Plant AS EntProjParentPlantForDisplay,
  _ParentElement.FunctionalArea AS EntProjParFuncnlAreaForDisplay,
  _EnterpriseProject.EntProjectIsConfidential AS EntProjectIsConfidential
FROM entprojelem_d AS EnterpriseProjectElementDraft
LEFT OUTER JOIN R_EnterpriseProject AS _EnterpriseProject ON _EnterpriseProject.ProjectUUID = ProjectUUID  -- association [1..1]
LEFT OUTER JOIN R_EnterpriseProjectElement AS _ProjectElement ON _ProjectElement.ProjectElementUUID = ProjectElementUUID  -- association [1..1]
LEFT OUTER JOIN I_EnterpriseProjectForUser AS _EnterpriseProjectForUser ON _EnterpriseProjectForUser.ProjectUUID = ProjectUUID  -- association [0..1]
LEFT OUTER JOIN E_EntProjectElementDraft AS _ProjectElementExtension ON ProjectElementUUID = _ProjectElementExtension.ProjectElementUUID  -- association [1..1]
LEFT OUTER JOIN E_CommlProjWorkPackageDraft AS _CommlProjWorkPackageExtension ON ProjectElementUUID = _CommlProjWorkPackageExtension.ProjectElementUUID  -- association [1..1]
LEFT OUTER JOIN R_EnterpriseProjectElement AS _ParentElement ON ParentObjectUUID = _ParentElement.ProjectElementUUID  -- association [0..1]
;