R_EnterpriseProjectDraft

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_EnterpriseProjectDraft.
-- 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_EnterpriseProjectDraft AS
SELECT
  EnterpriseProjectDraft.projectuuid AS ProjectUUID,
  EnterpriseProjectDraft.projectsummarytaskuuid AS ProjectSummaryTaskUUID,
  EnterpriseProjectDraft.projectinternalid AS ProjectInternalID,
  EnterpriseProjectDraft.project AS Project,
  EnterpriseProjectDraft.projectcategory AS ProjectCategory,
  EnterpriseProjectDraft.projectdescription AS ProjectDescription,
  EnterpriseProjectDraft.enterpriseprojecttype AS EnterpriseProjectType,
  EnterpriseProjectDraft.prioritycode AS PriorityCode,
  EnterpriseProjectDraft.projectstartdate AS ProjectStartDate,
  EnterpriseProjectDraft.projectenddate AS ProjectEndDate,
  EnterpriseProjectDraft.actualstartdate AS ActualStartDate,
  EnterpriseProjectDraft.actualenddate AS ActualEndDate,
  EnterpriseProjectDraft.customeruuid AS CustomerUUID,
  EnterpriseProjectDraft.enterpriseprojectserviceorg AS EnterpriseProjectServiceOrg,
  EnterpriseProjectDraft.entprojectisconfidential AS EntProjectIsConfidential,
  EnterpriseProjectDraft.restrictedtimeposting AS RestrictedTimePosting,
  EnterpriseProjectDraft.processingstatus AS ProcessingStatus,
  EnterpriseProjectDraft.responsiblecostcenter AS ResponsibleCostCenter,
  EnterpriseProjectDraft.profitcenter AS ProfitCenter,
  EnterpriseProjectDraft.projectprofilecode AS ProjectProfileCode,
  EnterpriseProjectDraft.functionalarea AS FunctionalArea,
  EnterpriseProjectDraft.companycode AS CompanyCode,
  EnterpriseProjectDraft.controllingarea AS ControllingArea,
  EnterpriseProjectDraft.plant AS Plant,
  EnterpriseProjectDraft.location AS Location,
  EnterpriseProjectDraft.taxjurisdiction AS TaxJurisdiction,
  EnterpriseProjectDraft.projectcurrency AS ProjectCurrency,
  EnterpriseProjectDraft.availabilitycontrolprofile AS AvailabilityControlProfile,
  EnterpriseProjectDraft.availabilitycontrolisactive AS AvailabilityControlIsActive,
  EnterpriseProjectDraft.functionallocation AS FunctionalLocation,
  EnterpriseProjectDraft.investmentprofile AS InvestmentProfile,
  EnterpriseProjectDraft.isbillingrelevant AS IsBillingRelevant,
  EnterpriseProjectDraft.lastchangedatetime AS LastChangeDateTime,
  EnterpriseProjectDraft.lastchangedbyuser AS LastChangedByUser,
  EnterpriseProjectDraft.projectlastchangeddatetime AS ProjectLastChangedDateTime,
  EnterpriseProjectDraft.projectlastchangedbyuser AS ProjectLastChangedByUser,
  EnterpriseProjectDraft.entprojismultislsorditmsenbld AS EntProjIsMultiSlsOrdItmsEnbld,
  EnterpriseProjectDraft.entprojdemandcopyisrequested AS EntProjDemandCopyIsRequested,
  EnterpriseProjectDraft.entprojsettlmtrulecpyisreqd AS EntProjSettlmtRuleCpyIsReqd,
  EnterpriseProjectDraft.entprojhasprojectstockenabled AS EntProjHasProjectStockEnabled,
  EnterpriseProjectDraft.entprojectsettlementtype AS EntProjectSettlementType,
  EnterpriseProjectDraft.entprojectsettlementelement AS EntProjectSettlementElement,
  EnterpriseProjectDraft.createdbyuser AS CreatedByUser,
  EnterpriseProjectDraft.creationdatetime AS CreationDateTime,
  EnterpriseProjectDraft.leadingsalesorder AS LeadingSalesOrder,
  EnterpriseProjectDraft.leadingsalesorderitem AS LeadingSalesOrderItem,
  EnterpriseProjectDraft.resultanalysisinternalid AS ResultAnalysisInternalID,
  EnterpriseProjectDraft.wbselementinternalid AS WBSElementInternalID,
  EnterpriseProjectDraft.factorycalendar AS FactoryCalendar,
  EnterpriseProjectDraft.wbselementobject AS WBSElementObject,
  EnterpriseProjectDraft.projectobject AS ProjectObject,
  EnterpriseProjectDraft.costingsheet AS CostingSheet,
  EnterpriseProjectDraft.costcenter AS CostCenter,
  EnterpriseProjectDraft.isstatistical AS IsStatistical,
  EnterpriseProjectDraft.projecttemplateuuid AS ProjectTemplateUUID,
  EnterpriseProjectDraft.projectmanager AS ProjectManager,
  EnterpriseProjectDraft.draftentitycreationdatetime AS DraftEntityCreationDateTime,
  EnterpriseProjectDraft.draftentitylastchangedatetime AS DraftEntityLastChangeDateTime,
  EnterpriseProjectDraft.draftadministrativedatauuid AS DraftAdministrativeDataUUID,
  EnterpriseProjectDraft.draftfieldchanges AS DraftFieldChanges,
  EnterpriseProjectDraft.hasactiveentity AS HasActiveEntity,
  EnterpriseProjectDraft.draftentityoperationcode AS DraftEntityOperationCode
FROM entproj_d AS EnterpriseProjectDraft
INNER JOIN sdraft_admin ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN R_EnterpriseProject AS _Project ON ProjectUUID = _Project.ProjectUUID  -- association [1..1]
LEFT OUTER JOIN I_EnterpriseProjectForUser AS _EnterpriseProjectForUser ON _EnterpriseProjectForUser.ProjectUUID = ProjectUUID  -- association [0..1]
LEFT OUTER JOIN E_EnterpriseProjectDraft AS _ProjectExtension ON ProjectUUID = _ProjectExtension.ProjectUUID  -- association [1..1]
LEFT OUTER JOIN E_CommercialProjectDraft AS _CommercialProjectExtension ON ProjectUUID = _CommercialProjectExtension.ProjectUUID  -- association [1..1]
;