P_POItem

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

CREATE VIEW P_POItem AS
SELECT
  PurchaseOrder,
  PurchaseOrderItem,
  PurchaseOrderType,
  Supplier,
  SupplierQuotation,
  SupplierQuotationItem,
  SupplyingPlant,
  PurchasingOrganization,
  PurchasingGroup,
  CompanyCode,
  DocumentCurrency,
  PurchaseOrderDate,
  CreationDate,
  CreatedByUser,
  PurchaseOrderItemText,
  Material,
  MaterialGroup,
  Plant,
  ProductType,
  PurchaseOrderItemCategory,
  cast('' as dtext) AS PurOrderItemExtCategory,
  AccountAssignmentCategory,
  ServicePerformer,
  IsReturnsItem,
  GoodsReceiptIsExpected,
  GoodsReceiptIsNonValuated,
  IsCompletelyDelivered,
  InvoiceIsExpected,
  InvoiceIsGoodsReceiptBased,
  IsFinallyInvoiced,
  cast('' as xfeld) AS IsCompleted,
  StorageLocation,
  PurchasingInfoRecord,
  IsInfoRecordUpdated,
  PurchaseContract,
  PurchaseContractItem,
  PurchaseRequisition,
  PurchaseRequisitionItem,
  RequestForQuotation,
  RequestForQuotationItem,
  RequirementTracking,
  RequisitionerName,
  case when (GoodsReceiptIsExpected <> 'X' or IsCompletelyDelivered = 'X' or PurchaseOrderItemCategory = 'A' or _NextOpenScheduleLine.ScheduleLineDeliveryDate is null) then cast( 0 as abap.quan(14,3)) when IsReturnsItem = 'X' then -abs(cast(_NextOpenScheduleLine.OpenPurchaseOrderQuantity as abap.quan(14,3))) else cast(_NextOpenScheduleLine.OpenPurchaseOrderQuantity as abap.quan(14,3)) end as NextDeliveryQuantity AS quan143endasNextDeliveryQuantity,
  _NextOpenScheduleLine.ScheduleLine AS ScheduleLine,
  case when PurchaseOrderItemCategory = 'A' then ExpectedOverallLimitAmount else cast (0 as abap.curr(21, 5)) end as ExpectedOverallLimitAmount AS curr215endasExpectedOverallLimitAmount,
  case when PurchaseOrderItemCategory = 'A' then OverallLimitAmount else cast (0 as abap.curr(21, 5)) end as OverallLimitAmount AS curr215endasOverallLimitAmount,
  NetPriceAmount,
  NetPriceQuantity,
  case when (GoodsReceiptIsExpected <> 'X' or IsCompletelyDelivered = 'X' or GoodsReceiptIsNonValuated = 'X' or (PurchaseOrderItemCategory = 'A' and ProductType = '1')) then cast(0 as abap.curr(21, 5)) when (PurchaseOrderItemCategory = 'A' and ProductType = '2') then case when GoodsReceiptAmount is null then NetAmount else NetAmount - GoodsReceiptAmount end when OrderQuantity is null or OrderQuantity = 0 or NetPriceQuantity = 0 then cast (0 as abap.curr(21, 5)) when IsReturnsItem = 'X' then case when GoodsReceiptQty is null or GoodsReceiptQty = 0 then -abs(NetAmount) else -abs(NetAmount - abs(-GoodsReceiptAmount ) ) end else case when GoodsReceiptQty is null or GoodsReceiptQty = 0 then NetAmount else cast( division(NetPriceAmount,NetPriceQuantity,5) * ( OrderQuantity - GoodsReceiptQty ) as abap.curr( 21, 5 ) ) end end as StillToBeDeliveredValue AS curr215endendasStillToBeDeliveredValue,
  PurchaseOrderQuantityUnit,
  OrderPriceUnit,
  cast('00000000' as abap.dats) AS NextDeliveryDate,
  cast( 0 as abap.quan(14,3)) AS NextDeliveryQuantity,
  '04' AS NextDeliveryStatus,
  cast(0 as abap.quan(13, 3)) AS StillToBeDeliveredQuantity,
  cast(0 as abap.curr(21, 5)) AS StillToBeDeliveredValue,
  cast(0 as abap.quan(13, 3)) AS StillToInvoiceQuantity,
  cast(0 as abap.curr(21, 5)) AS StillToInvoiceValue,
  $session.system_date AS today
FROM P_POItemCnvrtdAmounts
LEFT OUTER JOIN P_POItemNextOpenSchedLineQty AS _NextOpenScheduleLine ON PurchaseOrder = _NextOpenScheduleLine.PurchaseOrder AND PurchaseOrderItem = _NextOpenScheduleLine.PurchaseOrderItem  -- association [0..1]
-- UNION ALL with additional select branch(es): P_POItemCnvrtdAmounts
;