P_PurchaseOrderItemMntr

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_PurchaseOrderItemMntr.
-- 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: PPURORDITEMMNTR
-- Parameters: P_DisplayCurrency : abap.cuky(5)

CREATE VIEW P_PurchaseOrderItemMntr AS
SELECT
  PurchaseOrder,
  PurchaseOrderItem,
  cast ('X' as migration_completed) AS PurgDocMigrtnIsCmpltdForAnlyts,
  PurchaseOrderType,
  Supplier,
  SupplyingPlant,
  PurchasingOrganization,
  PurchasingGroup,
  CompanyCode,
  DocumentCurrency,
  PurchaseOrderDate,
  CreationDate,
  CreatedByUser,
  _PurchaseOrderStatus.PurchasingDocumentStatus AS PurchaseOrderStatus,
  _PurchaseOrderItemStatus.PurchasingDocumentStatus AS PurchaseOrderItemStatus,
  PurchaseOrderItemText,
  Material,
  MaterialGroup,
  Plant,
  ProductType,
  PurchaseOrderItemCategory,
  AccountAssignmentCategory,
  ServicePerformer,
  IsReturnsItem,
  GoodsReceiptIsExpected,
  GoodsReceiptIsNonValuated,
  IsCompletelyDelivered,
  InvoiceIsExpected,
  InvoiceIsGoodsReceiptBased,
  IsFinallyInvoiced,
  IsCompleted,
  StorageLocation,
  PurchasingInfoRecord,
  IsInfoRecordUpdated,
  PurchaseContract,
  PurchaseContractItem,
  PurchaseRequisition,
  PurchaseRequisitionItem,
  RequestForQuotation,
  RequestForQuotationItem,
  RequirementTracking,
  RequisitionerName,
  NextDeliveryDate,
  NextDeliveryQuantity,
  NextDeliveryStatus,
  case when PurchaseOrderItemCategory = 'A' then currency_conversion(amount => ExpectedOverallLimitAmount, source_currency => DocumentCurrency, target_currency => $parameters.P_DisplayCurrency, exchange_rate_date => PurchaseOrderDate, error_handling => 'SET_TO_NULL' ) else cast (0 as abap.curr(21, 5)) end as ExpectedOverallLimitAmount AS curr215endasExpectedOverallLimitAmount,
  case when PurchaseOrderItemCategory = 'A' then currency_conversion(amount => OverallLimitAmount, source_currency => DocumentCurrency, target_currency => $parameters.P_DisplayCurrency, exchange_rate_date => PurchaseOrderDate, error_handling => 'SET_TO_NULL' ) else cast (0 as abap.curr(21, 5)) end as OverallLimitAmount AS curr215endasOverallLimitAmount,
  OrderQuantity,
  case $parameters.P_DisplayCurrency when AnalyticalReportingCurrency then NetPriceInReportingCurrency when AnalyticalReportingCurrency2 then NetPriceInReportingCurrency2 when DocumentCurrency then NetPriceAmount else cast(currency_conversion ( amount => NetPriceAmount, source_currency => DocumentCurrency, round => 'X', target_currency => :P_DisplayCurrency, exchange_rate_date => PurchaseOrderDate, exchange_rate_type => 'M', error_handling => 'SET_TO_NULL' )as abap.curr(21,5)) end as NetPriceAmount AS curr215endasNetPriceAmount,
  NetPriceQuantity,
  case $parameters.P_DisplayCurrency when AnalyticalReportingCurrency then NetAmountInReportingCurrency when AnalyticalReportingCurrency2 then NetAmountInReportingCurrency2 when DocumentCurrency then NetAmount else cast(currency_conversion ( amount => NetAmount, source_currency => DocumentCurrency, round => 'X', target_currency => :P_DisplayCurrency, exchange_rate_date => PurchaseOrderDate, exchange_rate_type => 'M', error_handling => 'SET_TO_NULL' )as abap.curr(21,5)) end as NetAmount AS curr215endasNetAmount,
  GoodsReceiptQuantity,
  cast( currency_conversion(amount => GoodReceiptAmount, source_currency => DocumentCurrency, target_currency => $parameters.P_DisplayCurrency, exchange_rate_date => PurchaseOrderDate, round => 'X', error_handling => 'SET_TO_NULL' ) as abap.curr(21,5)) as GoodReceiptAmount AS curr215asGoodReceiptAmount,
  StillToBeDeliveredQuantity,
  cast(currency_conversion(amount => StillToBeDeliveredValue, source_currency => DocumentCurrency, target_currency => $parameters.P_DisplayCurrency, exchange_rate_date => PurchaseOrderDate, round => 'X', error_handling => 'SET_TO_NULL' ) as abap.curr(21,5)) as StillToBeDeliveredValue AS curr215asStillToBeDeliveredValue,
  InvoiceReceiptQty,
  cast(currency_conversion(amount => InvoiceReceiptAmount, source_currency => DocumentCurrency, target_currency => $parameters.P_DisplayCurrency, exchange_rate_date => PurchaseOrderDate, round => 'X', error_handling => 'SET_TO_NULL' ) as abap.curr(21,5)) as InvoiceReceiptAmount AS curr215asInvoiceReceiptAmount,
  StillToInvoiceQuantity,
  cast(currency_conversion(amount => StillToInvoiceValue, source_currency => DocumentCurrency, target_currency => $parameters.P_DisplayCurrency, exchange_rate_date => PurchaseOrderDate, round => 'X', error_handling => 'SET_TO_NULL' ) as abap.curr(21,5)) as StillToInvoiceValue AS curr215asStillToInvoiceValue,
  PurchaseOrderQuantityUnit,
  OrderPriceUnit,
  SupplierQuotation,
  SupplierQuotationItem,
  ScheduleLine,
  _PredictedDelivery.PredictedDaysOfDelivDeviation AS PredictedDaysOfDelivDeviation,
  _PredictedDelivery.SuplrNextDeliveryPredictionDte AS SuplrNextDeliveryPredictionDte,
  cast ( case when (GoodsReceiptIsExpected <> 'X' or IsCompletelyDelivered = 'X' or ScheduleLine is null or IsReturnsItem = 'X' or PurchaseOrderItemCategory <> '0') then 'NA' when _PredictedDelivery.PredictedDaysOfDelivDeviation < 0 then '-1' when _PredictedDelivery.PredictedDaysOfDelivDeviation > 0 then '1' when _PredictedDelivery.PredictedDaysOfDelivDeviation = 0 then '0' else 'N' end as vdm_mm_suplrdelvryforecast preserving type ) as PredictedDelDaysRltnPOPostDate AS PurchaseorderitemkeyPurchaseOrder,
  ExpectedOverallLimitAmount,
  OverallLimitAmount,
  NetPriceAmount,
  NetAmount,
  GoodReceiptAmount,
  cast(StillToBeDeliveredValue as abap.curr(21,5)) AS StillToBeDeliveredValue,
  InvoiceReceiptAmount,
  cast(StillToInvoiceValue as abap.curr(21,5)) AS StillToInvoiceValue
FROM P_POItemEnhanced
INNER JOIN I_PurgAnalyticsConfiguration AS AnalyticalConfiguration ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_PurchaseOrderStatus AS _PurchaseOrderStatus ON PurchaseOrder = _PurchaseOrderStatus.PurchaseOrder  -- association [0..1]
LEFT OUTER JOIN I_SuplrDeliveryPredictionCache AS _PredictedDelivery ON PurchaseOrder = _PredictedDelivery.PurchaseOrder AND PurchaseOrderItem = _PredictedDelivery.PurchaseOrderItem AND ScheduleLine = _PredictedDelivery.ScheduleLine  -- association [0..1]
LEFT OUTER JOIN P_PurchaseOrderItemStatus AS _PurchaseOrderItemStatus ON PurchaseOrder = _PurchaseOrderItemStatus.PurchaseOrder AND PurchaseOrderItem = _PurchaseOrderItemStatus.Purchaseorderitem  -- association [0..1]
-- UNION ALL with additional select branch(es): P_POItem
;