P_PurOrdMaintainItemList

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_PurOrdMaintainItemList.
-- 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: PPOMAINTITMLIST

CREATE VIEW P_PurOrdMaintainItemList AS
SELECT
  ekpo.PurchaseOrder AS PurchaseOrder,
  ekpo.PurchaseOrderItem AS PurchaseOrderItem,
  ekpo.PurchaseOrderItemText AS PurchasingDocumentItemText,
  ekpo.Material AS Material,
  ekpo.MaterialType AS MaterialType,
  ekpo.MaterialGroup AS MaterialGroup,
  ekpo.Plant AS Plant,
  ekpo.StorageLocation AS StorageLocation,
  ekpo.PurchaseOrderQuantityUnit AS PurchaseOrderQuantityUnit,
  ekpo.OrderQuantity AS PurchaseOrderQty,
  ekpo.NetPriceAmount AS PurchaseOrderNetPriceAmount,
  ekpo.NetAmount AS PurchaseOrderNetAmount,
  '' AS NetPriceIsDerived,
  ekpo.EffectiveAmount AS PurOrderEffectiveItemAmount,
  ekpo.NetPriceQuantity AS PurchaseOrderNetPriceQuantity,
  ekpo.OrderPriceUnit AS PurchaseOrderPriceUnit,
  ekpo.Customer AS Customer,
  ekpo.TaxCode AS TaxCode,
  ekpo.TaxJurisdiction AS TaxJurisdiction,
  ekpo.GoodsReceiptIsExpected AS GoodsReceiptIsExpected,
  ekpo.GoodsReceiptIsNonValuated AS GoodsReceiptIsNonValuated,
  ekpo.InvoiceIsExpected AS InvoiceIsExpected,
  ekpo.InvoiceIsGoodsReceiptBased AS InvoiceIsGoodsReceiptBased,
  ekpo.OverdelivTolrtdLmtRatioInPct AS OverdelivTolrtdLmtRatioInPct,
  ekpo.UnlimitedOverdeliveryIsAllowed AS UnlimitedOverdeliveryIsAllowed,
  ekpo.UnderdelivTolrtdLmtRatioInPct AS UnderdelivTolrtdLmtRatioInPct,
  ekpo.OrderItemQtyToBaseQtyNmrtr AS OrderItemQtyToBaseQtyNmrtr,
  ekpo.OrderItemQtyToBaseQtyDnmntr AS OrderItemQtyToBaseQtyDnmntr,
  ekpo.PurchasingInfoRecord AS RefPurOrderInfoRecord,
  ekpo.PurchaseContract AS RefPurchaseOutlineAgreement,
  ekpo.PurchaseContractItem AS RefPurchOutlineAgrmtItem,
  ekpo.PurchaseOrderItemCategory AS PurchaseOrderItemCategory,
  ekpo.AccountAssignmentCategory AS AcctAssignmentCategory,
  ekpo.PurchasingDocumentDeletionCode AS IsDeleted,
  ekpo.SupplierMaterialNumber AS SupplierMaterialNumber,
  ekpo.IncotermsClassification AS IncotermsClassification,
  ekpo.IncotermsTransferLocation AS IncotermsTransferLocation,
  ekpo.IncotermsLocation1 AS IncotermsLocation1,
  ekpo.IncotermsLocation2 AS IncotermsLocation2,
  ekpo.OrderPriceUnitToOrderUnitNmrtr AS OrderPriceUnitToOrderUnitNmrtr,
  ekpo.OrdPriceUnitToOrderUnitDnmntr AS OrdPriceUnitToOrderUnitDnmntr,
  ekpo.IsCompletelyDelivered AS IsCompletelyDelivered,
  ekpo.IsFinallyInvoiced AS IsFinallyInvoiced,
  ekpo.ServicePerformer AS ServicePerformer,
  ekpo.ProductType AS ProductType,
  ekpo.ServicePackage AS ServicePackage,
  cast('0' as abap.dec(13,2)) AS OverallLimitAmount,
  cast('' as abap.char(1)) AS OverallLimitAmountIsUnlimited,
  cast('0' as abap.dec(13,2)) AS ExpectedOverallLimitAmount,
  _PurOrdMaintainHeaderActive.Currency AS Currency,
  _PurOrdMaintainHeaderActive.PricingProcedure AS PricingProcedure,
  _PurOrdMaintainHeaderActive.PurchasingDocumentType AS PurchasingDocumentType,
  _PurOrdMaintainHeaderActive.PurchasingOrganization AS PurchasingOrganization,
  _PurOrdMaintainHeaderActive.PurchasingGroup AS PurchasingGroup,
  _PurOrdMaintainHeaderActive.Supplier AS Supplier,
  _PurOrdMaintainHeaderActive.IncotermsVersion AS IncotermsVersion,
  case when _PurOrdMaintainItemDraft.PurchaseOrderItem is null then cast ('0' as abap.char(1)) else cast ('2' as abap.char(1)) end as EditState AS char1endasEditState,
  case when _PurOrdMaintainItemDraft.PurchaseOrderItem is null then cast('' as abap.char(1)) else cast('X' as abap.char(1)) end as HasTwin AS char1endasHasTwin,
  cast('' as abap.char(12)) AS CreatedByUser,
  cast('' as abap.char(12)) AS LastChangeUser,
  cast('19000101120000' as abap.dec(21,7)) AS LastChangeDateTime
FROM I_PurchaseOrderItem AS ekpo
LEFT OUTER JOIN P_PurOrdMaintainHeadersList AS _PurOrdMaintainHeaderActive ON ekpo.PurchaseOrder = _PurOrdMaintainHeaderActive.PurchaseOrder  -- association [1..1]
LEFT OUTER JOIN P_PurOrdMaintainItemDraft AS _PurOrdMaintainItemDraft ON ekpo.PurchaseOrder = _PurOrdMaintainItemDraft.PurchaseOrder AND ekpo.PurchaseOrderItem = _PurOrdMaintainItemDraft.PurchaseOrderItem  -- association [0..1]
;