C_PurReturnDel

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_PurReturnDel.
-- 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: CPURRETDEL

CREATE VIEW C_PurReturnDel AS
SELECT
  concat(pur_return_del.PurchaseRequisition, pur_return_del.PurchasingDocument) AS ReturnDelivery,
  pur_return_del.PurchasingDocument AS PurchasingDocument,
  pur_return_del.PurchaseRequisition AS PurchaseRequisition,
  count(*) AS NumberOfItems,
  sum(pur_return_del.NetAmount) AS PartialPurReqnAmt,
  pur_return_del.DocumentCurrency AS Currency,
  pur_return_del.CreatedByUser AS CreatedByUser,
  pur_return_del.Supplier AS Supplier,
  pur_return_del.ExtCompanyCodeForPurg AS ExtCompanyCodeForPurg,
  cast ( pur_return_del.CreationDate as abap.dats) AS CreationDate,
  cast ( '00000000' as abap.dats) AS DocumentDate,
  cast ( '00000000' as abap.dats) AS PostingDate,
  cast ('' as abap.char( 16 )) AS DeliveryNote,
  cast ('' as abap.char( 40 )) AS PurchaseRequisitionText
FROM C_PurReturnDelItem AS pur_return_del
LEFT OUTER JOIN C_PurReturnDelItem AS _PurReturnDelItem ON ReturnDelivery = _PurReturnDelItem.ReturnDelivery  -- association [1..*]
;