I_MngProjDmndMatlPurReqnOrd

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 I_MngProjDmndMatlPurReqnOrd.
-- 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.
-- SQL view name: IMNGPROJDMNDMA

CREATE VIEW I_MngProjDmndMatlPurReqnOrd AS
SELECT
  ProjDemandMaterialSupplyUUID,
  ProjectDemandUUID,
  PurchaseRequisition,
  PurchaseRequisitionItem,
  ProjectDemandReservation,
  ProjectDemandReservationItem,
  _ProjDmndPurchaseOrdersSum.InvoiceReceiptAmount AS InvoiceReceiptAmount,
  _ProjDmndPurchaseOrdersSum.NetValueAmountInDocCurrency AS NetValueAmountInDocCurrency,
  _ProjDmndPurchaseOrdersSum.DocumentCurrency AS DocumentCurrency,
  _ProjDmndPurchaseOrdersSum.ScheduleLineDeliveryDate AS ScheduleLineDeliveryDate,
  _ProjDmndPurchaseOrdersSum.SchedLineStscDeliveryDate AS SchedLineStscDeliveryDate,
  _ProjDmndPurchaseOrdersSum.BaseUnit AS BaseUnit,
  _ProjDmndPurchaseOrdersSum.GoodsReceiptAmount AS GoodsReceiptAmount,
  _PurchaseRequisitionItem.PurReqnReleaseStatus AS PurReqnReleaseStatus,
  case when (PurchaseRequisition = '' or PurchaseRequisition is null ) or (_PurchaseRequisitionItem.PurchasingDocument = '' or _PurchaseRequisitionItem.PurchasingDocument is null) then _Root.ProjDmndRequestedQuantity when (PurchaseRequisition <> '' or PurchaseRequisition is not null ) or (_PurchaseRequisitionItem.PurchasingDocument <> '' or _PurchaseRequisitionItem.PurchasingDocument is not null) then ( _Root.ProjDmndRequestedQuantity - _ProjDmndPurchaseOrdersSum.RequestedQuantity ) end as OpenQuantity AS RequestedQuantityendasOpenQuantity,
  case when ( _Root.ProjectDemandType = 'S205' ) then _ReservationItem.ResvnItmWithdrawnQtyInBaseUnit when ( _Root.ProjectDemandType <> 'S205' ) then ( _ProjDmndPurchaseOrdersSum.OrderedQuantity ) end as OrderedQuantity AS OrderedQuantityendasOrderedQuantity,
  case when ( _Root.ProjectDemandType = 'S205' ) then _ReservationItem.ResvnItmRequiredQtyInBaseUnit when ( _Root.ProjectDemandType <> 'S205' ) then ( _ProjDmndPurchaseOrdersSum.RequestedQuantity ) end as RequestedQuantity AS RequestedQuantityendasRequestedQuantity,
  _Root._WorkPackage.ControllingArea AS ControllingArea,
  _Root._WorkPackage.ProfitCenter AS ProfitCenter
FROM R_ProjectDemandMaterialSupply
LEFT OUTER JOIN I_Purchaserequisitionitem AS _PurchaseRequisitionItem ON PurchaseRequisition = _PurchaseRequisitionItem.PurchaseRequisition AND PurchaseRequisitionItem = _PurchaseRequisitionItem.PurchaseRequisitionItem  -- association [0..1]
LEFT OUTER JOIN I_ProjDmndPurchaseOrdersSum AS _ProjDmndPurchaseOrdersSum ON PurchaseRequisition = _ProjDmndPurchaseOrdersSum.PurchaseRequisition AND PurchaseRequisitionItem = _ProjDmndPurchaseOrdersSum.PurchaseRequisitionItem  -- association [0..*]
LEFT OUTER JOIN I_ReservationDocumentItem AS _ReservationItem ON ProjectDemandReservation = _ReservationItem.Reservation AND ProjectDemandReservationItem = _ReservationItem.ReservationItem  -- association [0..1]
;