P_ProjProcmtPurReqnOrd

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 P_ProjProcmtPurReqnOrd.
-- 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: PPROJPROCMTPRPO

CREATE VIEW P_ProjProcmtPurReqnOrd AS
SELECT
  WBSElementInternalID,
  ProjectNetworkInternalID,
  NetworkActivityInternalID,
  _PR.PurchaseRequisition AS PurchaseRequisition,
  _PR.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  _PRDetails.PurchasingDocument AS PurchaseOrder,
  _PRDetails.PurchasingDocumentItem AS PurchaseOrderItem,
  PurReqnAcctAssgmtNmbr AS AccountAssignmentNumber,
  _PR.ProfitCenter AS ProfitCenter,
  case when _WBSElement.Project is not initial then _WBSElement.Project else _Network._Project.Project end as Project AS ProjectendasProject,
  _WBSElement.ProjectType AS ProjectType,
  _WBSElement._Project.ProjectProfileCode AS ProjectProfileCode,
  _WBSElement.CompanyCode AS CompanyCode,
  _WBSElement.ControllingArea AS ControllingArea,
  _WBSElement.ProfitCenter AS WBSElementProfitCenter,
  case when _WBSElement.WBSElement is not initial then _WBSElement.WBSElement when _NetworkActivity.WBSElement is not initial then _NetworkActivity.WBSElement else _Network._WBSElementData.WBSElement end as WBSElement AS WBSElementendasWBSElement,
  case when _WBSElement.WBSElement is not initial then _WBSElement.WBSDescription when _NetworkActivity.WBSElement is not initial then _NetworkActivity._WBSElement.WBSDescription else _Network._WBSElementData.WBSDescription end as WBSDescription AS WBSDescriptionendasWBSDescription,
  case when _WBSElement.ProjectInternalID is not initial then _WBSElement.ProjectInternalID else _NetworkActivity.ProjectInternalID end as ProjectInternalID AS ProjectInternalIDendasProjectInternalID,
  concat(concat(_PR.PurchaseRequisition, '/'), _PR.PurchaseRequisitionItem) AS FormattedPurchasingDocItem,
  _PRDetails.PurchaseRequisitionType AS PurchasingDocumentType,
  _PRDetails.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  _PRDetails.PurchaseRequisitionItemText AS PurchaseRequisitionItemText,
  _PRDetails.PurReqnReleaseStatus AS PurchasingReleaseStatus,
  _PRDetails.CreationDate AS CreationDate,
  _PRDetails.Supplier AS Supplier,
  _PRDetails.Material AS Material,
  _PRDetails.MaterialGroup AS MaterialGroup,
  _PRDetails.Plant AS Plant,
  _PRDetails.PurchasingOrganization AS PurchasingOrganization,
  _PRDetails.PurchasingGroup AS PurchasingGroup,
  _PRDetails.StorageLocation AS StorageLocation,
  _PRDetails.OrderedQuantity AS OrderedQuantity,
  _PRDetails.RequestedQuantity AS TotalQuantity,
  / _PO.Quantity as TotalQuantity AS QuantityasTotalQuantity,
  case when _PO.MultipleAcctAssgmtDistrPercent <> 0 then div(_PurchaseOrderItem.NetAmount * _PO.MultipleAcctAssgmtDistrPercent,100) when _PO.MultipleAcctAssgmtDistrPercent = 0 then _PurchaseOrderItem.NetAmount end as NetAmount AS NetAmountendasNetAmount,
  case when _PurchaseOrderItem.IsCompletelyDelivered = 'X' and _DelDate.DeliveryDate = '99991231' then _SchedLines.ScheduleLineDeliveryDate when _PurchaseOrderItem.IsCompletelyDelivered <> 'X' and _DelDate.DeliveryDate <> '99991231' then _DelDate.DeliveryDate end as DeliveryDate AS DeliveryDateendasDeliveryDate,
  _PurchaseOrderItem.DocumentCurrency AS DocumentCurrency,
  _PurchaseOrderItem.PurchaseOrderQuantityUnit AS OrderQuantityUnit,
  'PO' AS PurchasingDocumentPartnerType,
  _PurchaseOrderItem.IsCompletelyDelivered AS IsCompletelyDelivered,
  _SchedLines.ScheduleLineDeliveryDate AS ScheduleLineDeliveryDate,
  _DelDate.ScheduleLineLatestDeliveryDate AS ScheduleLineLatestDeliveryDate,
  _PurchaseOrderItem.AccountAssignmentCategory AS AccountAssignmentCategory,
  _Network.ProjectNetwork AS ProjectNetwork,
  _Network.ProjectNetworkDescription AS ProjectNetworkDescription,
  _NetworkActivity.NetworkActivity AS NetworkActivity,
  _NetworkActivity.NetworkActivityDescription AS NetworkActivityDescription
FROM I_PurchaseReqnAcctAssgmt AS _PR
LEFT OUTER JOIN I_Purchaserequisitionitem AS _PRDetails ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_WBSElement AS _WBSElement ON WBSElementInternalID = _WBSElement.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_PurchaseOrderItem AS _POStatus ON _PRDetails.PurchasingDocument = _POStatus.PurchaseOrder AND _PRDetails.PurchasingDocumentItem = _POStatus.PurchaseOrderItem  -- association [0..1]
LEFT OUTER JOIN I_ProjectNetworkBasicData AS _Network ON ProjectNetworkInternalID = _Network.ProjectNetworkInternalID OR _PR.ProjectNetwork = _Network.ProjectNetwork  -- association [0..1]
LEFT OUTER JOIN I_NetworkActivity AS _NetworkActivity ON ProjectNetworkInternalID = _NetworkActivity.ProjectNetworkInternalID AND NetworkActivityInternalID = _NetworkActivity.NetworkActivityInternalID  -- association [0..1]
;