R_ProjectDemandDraft

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_ProjectDemandDraft.
-- 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_ProjectDemandDraft AS
SELECT
  ProjectDemandUUID,
  ProjectDemand,
  ProjectDemandName,
  ProjectDemandDescription,
  ProjectDemandCategory,
  ProjectDemandType,
  ProjectUUID,
  ReferencedObjectUUID,
  ProjectDemandStatus,
  ProjectDemandDateMaintenance,
  ProjectDemandStartDate,
  ProjectDemandEndDate,
  ProjectDemandReleasedDateTime,
  ProjDmndActualSupplyDate,
  ProjectDemandPerUnitAmount,
  ProjectDemandRequestCurrency,
  ProjectDemandRequestNetAmount,
  ProjDmndReqNetAmountCurrency,
  ProjectDemandOverallAmount,
  ProjDmndRequestedQuantity,
  ProjDmndRequestedQuantityUnit,
  PriceUnitQty,
  Plant,
  PurchasingGroup,
  PurchasingOrganization,
  ProjectDemandLastUpdateSource,
  CreatedByUser,
  CreationDateTime,
  LastChangedByUser,
  LastChangeDateTime,
  ProjDemandLastChangeDateTime,
  ProjectDemandLastChangedByUser,
  ProjDmndExternalReferenceUUID,
  DraftEntityCreationDateTime,
  DraftEntityLastChangeDateTime,
  DraftAdministrativeDataUUID,
  DraftEntityOperationCode,
  HasActiveEntity,
  DraftFieldChanges,
  ProjectDemandOverallRevenue,
  ProjDmndOverallRevenueCurrency,
  ProjDmndDataModelVersion
FROM projdemand_d AS ProjectDemandDraft
LEFT OUTER JOIN I_EnterpriseProject AS _Project ON ProjectUUID = _Project.ProjectUUID  -- association [1..1]
LEFT OUTER JOIN I_EnterpriseProjectElement AS _WorkPackage ON ReferencedObjectUUID = _WorkPackage.ProjectElementUUID  -- association [0..1]
LEFT OUTER JOIN E_ProjectDemandDraft AS _ProjectDemandExtension ON ProjectDemandUUID = _ProjectDemandExtension.ProjectDemandUUID  -- association [1..1]
LEFT OUTER JOIN I_EnterpriseProjectForUser AS _EnterpriseProjectForUser ON ProjectUUID = _EnterpriseProjectForUser.ProjectUUID  -- association [0..1]
;