C_PurDocListOverview

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_PurDocListOverview.
-- 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: CPDOCLOVERVIEW

CREATE VIEW C_PurDocListOverview AS
SELECT
  pr_itm.PurchaseRequisition AS PurchaseRequisition,
  pr_itm.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  pr_itm.PurchasingDocument AS PurchaseOrder,
  pr_itm.PurchasingDocumentItem AS PurchaseOrderItem,
  pr_itm.PurchaseOrderItemCategory AS PurchaseOrderItemCategory,
  cast('' as abap.char(10)) AS InvoiceReference,
  cast('' as abap.numc(4)) AS InvoiceReferenceFiscalYear,
  cast('' as abap.numc(6)) AS AccountingDocumentItem,
  cast('' as abap.char(2)) AS AccountingDocumentType,
  cast('' as abap.char(10)) AS MaterialDocument,
  pr_itm.PurchasingDocumentType AS PurchasingDocumentType,
  pr_itm.PurchasingGroup AS PurchasingGroup,
  pr_itm.SupplyingPlant AS SupplyingPlant,
  pr_itm.SupplyingPlantName AS SupplyingPlantName,
  pr_itm.Material AS Material,
  pr_itm.ManufacturerMaterial AS ManufacturerMaterial,
  pr_itm.MaterialGroup AS MaterialGroup,
  COALESCE( pr_itm.Plant , '' ) AS Plant,
  pr_itm.PlantName AS PlantName,
  pr_itm.PurchaseRequisitionItemText AS PurchasingDocumentItemText,
  pr_itm.PurchasingGroupName AS PurchasingGroupName,
  pr_itm.status AS Status,
  cast(0 as abap.quan(13)) AS GoodsMovementQuantity,
  pr_itm.PurgDocTransactionCurrency AS Currency,
  pr_itm.MaterialBaseUnit AS QuantityUnit,
  pr_itm.Quantity AS PurchasingDocumentItemQuantity,
  pr_itm.vendor AS Supplier,
  pr_itm.vendorName AS SupplierName,
  pr_itm.SupplierAddressCity AS SupplierAddressCity,
  pr_itm.SupplierAddressCountry AS SupplierAddressCountry,
  pr_itm.PurchasingOrganization AS PurchasingOrganization,
  pr_itm.PurchasingOrganizationName AS PurchasingOrganizationName,
  COALESCE( pr_itm.ServicePerformer, '' ) AS ServicePerformer,
  pr_itm.ServicePerformerName AS ServicePerformerName,
  cast('' as abap.char(10)) AS WorkItem,
  pr_itm.DeliveryDate AS DeliveryDate,
  cast('' as abap.char(40)) AS MaterialName,
  cast('' as abap.char(20)) AS MaterialGroupName,
  cast('' as abap.char(40)) AS StatusDescription,
  cast(0 as abap.int4) AS cntf,
  cntb,
  cast(0 as abap.int4) AS cnts,
  cast(0 as abap.int4) AS cntg,
  pr_itm.WBSElementExternalID AS WBSElementExternalID,
  cast ('' as abap.char(10)) AS SalesOrder,
  cast('' as abap.numc(6)) AS SalesOrderItem,
  pr_itm.WorkPackageFullName AS WorkPackageFullName,
  COALESCE( pr_itm.CostCenter, '' ) AS CostCenter,
  COALESCE( pr_itm.CostCenterName, '' ) AS CostCenterName,
  COALESCE( pr_itm.ControllingArea, '' ) AS ControllingArea,
  pr_itm.AcctAssignmentCategory AS AccountAssignmentCategory,
  IsEndOfPurposeBlocked
LEFT OUTER JOIN I_WorkItemText AS _WorkItemText ON WorkItem = _WorkItemText.WorkItem  -- association [0..*]
;