C_PurDocListPOAll

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_PurDocListPOAll.
-- 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: CDOCLPOALL

CREATE VIEW C_PurDocListPOAll AS
SELECT
  I_PurchaseOrderItem.PurchaseOrderItem AS PurchaseOrderItem,
  wbsobj.AccountAssignmentNumber AS AccountAssignmentNumber,
  I_PurchaseOrderItem.Material AS Material,
  I_PurchaseOrderItem.MaterialGroup AS MaterialGroup,
  I_PurchaseOrderItem.Plant AS Plant,
  I_PurchaseOrderItem.BaseUnit AS BaseUnit,
  I_PurchaseOrderItem.StorageLocation AS StorageLocation,
  I_PurchaseOrderItem.CompanyCode AS CompanyCode,
  I_PurchaseOrderItem.PurchaseOrderQuantityUnit AS PurchaseOrderQuantityUnit,
  I_PurchaseOrderItem.OrderPriceUnit AS PurchaseOrderPriceUnit,
  I_PurchaseOrderItem.AccountAssignmentCategory AS AcctAssignmentCategory,
  I_PurchaseOrderItem.PurchasingDocumentDeletionCode AS IsDeletedItem,
  I_PurchaseOrderItem.ManufacturerMaterial AS ManufacturerMaterial,
  I_PurchaseOrderItem.ManufacturerPartNmbr AS MfrPartNumber,
  I_PurchaseOrderItem.OrderQuantity AS PurchaseOrderQty,
  I_PurchaseOrderItem.NetPriceQuantity AS PurchaseOrderNetPriceQuantity,
  I_PurchaseOrderItem.NetPriceAmount AS PurchaseOrderNetPriceAmount,
  I_PurchaseOrderItem.NetAmount AS PurchaseOrderNetAmount,
  I_PurchaseOrderItem.PurchaseOrderItemCategory AS PurchaseOrderItemCategory,
  I_PurchaseOrderItem.IsStatisticalItem AS ItemIsStatistical,
  I_PurchaseOrderItem.IsReturnsItem AS IsReturnsItem,
  I_PurchaseOrderItem.OrderItemQtyToBaseQtyDnmntr AS OrderItemQtyToBaseQtyDnmntr,
  I_PurchaseOrderItem.OrderItemQtyToBaseQtyNmrtr AS OrderItemQtyToBaseQtyNmrtr,
  I_PurchaseOrderItem.IsCompletelyDelivered AS IsCompletelyDelivered,
  I_PurchaseOrderItem.IsFinallyInvoiced AS IsFinallyInvoiced,
  I_PurchaseOrderItem.GoodsReceiptIsExpected AS GoodsReceiptIsExpected,
  I_PurchaseOrderItem.InvoiceIsGoodsReceiptBased AS InvoiceIsGoodsReceiptBased,
  I_PurchaseOrderItem.InvoiceIsExpected AS InvoiceIsExpected,
  I_PurchaseOrderItem.ServicePerformer AS ServicePerformer,
  _PurgDocScheduleLine.DeliveryDate AS DeliveryDate,
  COALESCE( wbsobj.WBSElementExternalID, '') AS WBSElementExternalID,
  wbsobj.SalesOrder AS SalesOrder,
  wbsobj.SalesOrderItem AS SalesOrderItem,
  COALESCE( wbsobj.WorkPackageFullName, '') AS WorkPackageFullName,
  wbsobj.WBSDescription AS WBSDescription,
  COALESCE( wbsobj.CostCenter, '' ) AS CostCenter,
  wbsobj.ControllingArea AS ControllingArea,
  cast ('F' as abap.char( 1 )) AS PurchasingDocumentCategory,
  ekko.PurchaseOrderType AS purchasingDocumentType,
  ekko.CreationDate AS LastChangeDate,
  ekko.CreatedByUser AS CreatedByUser,
  ekko.Supplier AS Supplier,
  ekko.PaymentTerms AS PaymentTerms,
  ekko.PurchasingOrganization AS PurchasingOrganization,
  ekko.PurchasingGroup AS PurchasingGroup,
  ekko.DocumentCurrency AS Currency,
  cast( ekko.PurchaseOrderDate as abap.char(8)) AS PurchaseOrderDate,
  ekko.SupplyingPlant AS SupplyingPlant,
  ekko.PurchasingDocumentDeletionCode AS IsDeletedHeader,
  _Suppl.name1 AS SupplyingVendorName,
  ekko._PurchasingGroup.PurchasingGroupName AS PurchasingGroupName,
  ekko._PurchasingOrganization.PurchasingOrganizationName AS PurchasingOrganizationName,
  ekko._CompanyCode.CompanyCodeName AS CompanyCodeName,
  I_PurchaseOrderItem._Plant.PlantName AS PlantName,
  ekko.SupplyingPlant AS name1_sp,
  ekko.IsEndOfPurposeBlocked AS IsEndOfPurposeBlocked,
  pdi_calc.wemng AS GoodsReceiptQuantity,
  pdi_calc.wewrt AS GoodsReceiptValue,
  pdi_calc.remng AS InvoiceReceiptQuantity,
  pdi_calc.rewrt AS InvoiceReceiptValue,
  pdi_calc.DocumentCurrency AS DocumentCurrency,
  pdi_calc.qtymismatch AS qtymismatch,
  pdi_calc.confmiss AS confmiss,
  pdi_calc.wesbs AS wesbs,
  cast(0 as abap.int4) AS cntk,
  cast(0 as abap.int4) AS cntl,
  cast(0 as abap.curr(19,2)) AS releasevalue
LEFT OUTER JOIN I_PurchaseOrder AS ekko ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN lfa1 AS _Suppl ON Supplier = _Suppl.lifnr  -- association [0..1]
LEFT OUTER JOIN C_Purdoclistcalfieldspo AS pdi_calc ON PurchaseOrder = pdi_calc.PurchasingDocument AND I_PurchaseOrderItem.PurchaseOrderItem = pdi_calc.PurchasingDocumentItem  -- association [1..1]
LEFT OUTER JOIN C_PURDOCLISTWBSELEMENT AS wbsobj ON PurchaseOrder = wbsobj.PurchaseOrder AND I_PurchaseOrderItem.PurchaseOrderItem = wbsobj.PurchaseOrderItem  -- association [1..*]
LEFT OUTER JOIN P_PurOrditemDeliveryDate AS _PurgDocScheduleLine ON PurchaseOrder = _PurgDocScheduleLine.PurchasingDocument AND PurchaseOrderItem = _PurgDocScheduleLine.PurchasingDocumentItem  -- association [1..1]
;