P_PurchaseRequisitionItem

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_PurchaseRequisitionItem.
-- 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: PPURREQITEM
-- Parameters: P_DisplayCurrency : displaycurrency, P_StartDate : badat, P_EndDate : badat

CREATE VIEW P_PurchaseRequisitionItem AS
SELECT
  PurchaseReqItem.PurchaseRequisition AS PurchaseRequisition,
  PurchaseReqItem.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  PurchasingDocument,
  PurchasingDocumentItem,
  PurchaseReqItem.PurchasingGroup AS PurchasingGroup,
  PurchaseReqItem.PurchasingOrganization AS PurchasingOrganization,
  cast(PurchaseReqItem.FixedSupplier as md_supplier) AS Supplier,
  PurchaseReqItem.Material AS Material,
  PurchaseReqItem.MaterialGroup AS MaterialGroup,
  PurchaseReqItem.Plant AS Plant,
  PurchaseReqItem.ReleaseCode AS ReleaseCode,
  PurchaseReqItem.PurchaseRequisitionStatus AS PurchaseRequisitionStatus,
  PurchaseReqItem.ReleaseStrategy AS ReleaseStrategy,
  PurchaseReqItem.AccountAssignmentCategory AS AccountAssignmentCategory,
  PurchaseReqItem.MultipleAcctAssgmtDistribution AS MultipleAcctAssgmtDistribution,
  PurReqCreationDate,
  PurchaseReqItem.CreatedByUser AS CreatedByUser,
  _PurchaseOrder.CreationDate AS CreationDate,
  _PurchaseOrder.PurchaseOrderDate AS PurchaseOrderDate,
  PurchaseRequisitionType,
  PurchaseReqItem.PurReqnItemCurrency AS PurReqnItemCurrency,
  PurchaseRequisitionPrice,
  PurchaseReqItem.PurReqnPriceQuantity AS PurReqnPriceQuantity,
  PurchaseReqItem.RequestedQuantity AS RequestedQuantity,
  case when PurReqnPriceQuantity >0 and PurReqnItemCurrency != '' then cast ( Division (currency_conversion( amount => PurchaseRequisitionPrice , source_currency => PurReqnItemCurrency, target_currency => :P_DisplayCurrency, exchange_rate_date => PurchaseReqItem.PurReqCreationDate, exchange_rate_type => 'M', error_handling => 'FAIL_ON_ERROR' ), PurchaseReqItem.PurReqnPriceQuantity,5) as abap.curr(21,5) ) else 0 end as PurReqnPerUnitPrice AS curr215else0endasPurReqnPerUnitPrice
FROM I_PurchaseRequisitionItemBasic AS PurchaseReqItem
LEFT OUTER JOIN I_PurchaseOrder AS _PurchaseOrder ON PurchasingDocument = _PurchaseOrder.PurchaseOrder  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Supplier ON Supplier = _Supplier.Supplier  -- association [0..1]
;