C_PurReqItemByPurOrder

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 C_PurReqItemByPurOrder.
-- 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: CPREQITMBYPURORD

CREATE VIEW C_PurReqItemByPurOrder AS
SELECT
  I_Purchaserequisitionitem.PurchaseRequisition AS PurchaseRequisition,
  I_Purchaserequisitionitem.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  _PurchOrdSchedLine.PurchaseOrder AS PurchaseOrder,
  I_Purchaserequisitionitem.PurchaseRequisitionType AS PurchaseRequisitionType,
  I_Purchaserequisitionitem.Plant AS Plant,
  I_Purchaserequisitionitem.PurchasingOrganization AS PurchasingOrganization,
  I_Purchaserequisitionitem.PurchasingGroup AS PurchasingGroup,
  I_Purchaserequisitionitem.PurchaseRequisitionItemText AS PurchaseRequisitionItemText,
  I_Purchaserequisitionitem.MaterialGroup AS MaterialGroup,
  I_Purchaserequisitionitem.DeliveryDate AS DeliveryDate,
  I_Purchaserequisitionitem.RequestedQuantity AS RequestedQuantity,
  I_Purchaserequisitionitem.BaseUnit AS BaseUnit,
  I_Purchaserequisitionitem.PurReqnItemCurrency AS PurReqnItemCurrency,
  I_Purchaserequisitionitem.PurchaseRequisitionPrice AS PurchaseRequisitionPrice,
  cast( cast(_PurReqnTotalAmount.PurReqnItemTotalAmount as abap.curr(15,2) ) as mm_pur_requisition_item_amount) AS PurReqnItemTotalAmount,
  I_Purchaserequisitionitem.PurReqnPriceQuantity AS PurReqnPriceQuantity,
  I_Purchaserequisitionitem.Material AS Material
LEFT OUTER JOIN I_PurchaseOrderScheduleLine AS _PurchOrdSchedLine ON PurchaseRequisition = _PurchOrdSchedLine.PurchaseRequisition AND PurchaseRequisitionItem = _PurchOrdSchedLine.PurchaseRequisitionItem  -- association [1..*]
LEFT OUTER JOIN I_MaterialGroupText AS _MaterialGroupText ON MaterialGroup = _MaterialGroupText.MaterialGroup  -- association [0..*]
LEFT OUTER JOIN I_MaterialText AS _MaterialText ON Material = _MaterialText.Material  -- association [0..*]
LEFT OUTER JOIN P_PurReqnTotalAmount AS _PurReqnTotalAmount ON PurchaseRequisition = _PurReqnTotalAmount.PurchaseRequisition AND PurchaseRequisitionItem = _PurReqnTotalAmount.PurchaseRequisitionItem  -- association [1..1]
;