C_PurReturnDelItem

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_PurReturnDelItem.
-- 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: CPURRETDELITM

CREATE VIEW C_PurReturnDelItem AS
SELECT
  concat(PurReqItem.PurchaseRequisition, PurchOrdItem.PurchasingDocument) AS ReturnDelivery,
  PurReqItem.PurchaseRequisitionItem AS PurchaseRequisitionItem,
  PurchOrdItem.PurchasingDocumentItem AS PurchasingDocumentItem,
  PurReqItem.ExtCompanyCodeForPurg AS ExtCompanyCodeForPurg,
  PurReqItem.PurchaseRequisition AS PurchaseRequisition,
  PurchOrdItem.PurchasingDocument AS PurchasingDocument,
  PurchOrdSch.ScheduleLine AS ScheduleLine,
  PurReqItem.PurchaseRequisitionType AS PurchaseRequisitionType,
  PurchOrdHdr.Supplier AS Supplier,
  PurReqItem.PurchaseRequisitionItemText AS PurchaseRequisitionItemText,
  PurReqItem.CreatedByUser AS CreatedByUser,
  PurReqItem.CreationDate AS CreationDate,
  PurchOrdItem.PurchasingDocumentDeletionCode AS PurchasingDocumentDeletionCode,
  PurchOrdItem.PurchasingDocumentItemText AS PurchasingDocumentItemText,
  _Text[1: Language = $session.system_language].MaterialName AS MaterialName,
  PurchOrdItem.Material AS Material,
  PurchOrdItem.OrderQuantityUnit AS OrderQuantityUnit,
  PurchOrdItem.NetPriceQuantity AS NetPriceQuantity,
  PurchOrdItem.BaseUnit AS BaseUnit,
  PurchOrdItem.OrderPriceUnit AS OrderPriceUnit,
  PurchOrdItem.NetAmount AS NetAmount,
  PurchOrdItem.NetPriceAmount AS NetPriceAmount,
  PurchOrdItem.DocumentCurrency AS DocumentCurrency,
  PurchOrdSch.PurchaseOrderQuantityUnit AS PurchaseOrderQuantityUnit,
  PurchOrdSch.RoughGoodsReceiptQty AS RoughGoodsReceiptQty,
  cast ( 0 as mb_erfmg ) AS ReturnQuantity,
  cast ( '' as mb_grbew ) AS ReasonforReturn
FROM P_PurReqItmforReturnDel AS PurReqItem
INNER JOIN I_PurchaseOrder AS PurchOrdHdr ON /* join condition not captured in parsed metadata */
INNER JOIN P_PurDocItmforReturnDel AS PurchOrdItem ON /* join condition not captured in parsed metadata */
INNER JOIN P_POScheduleLineforReturnDel AS PurchOrdSch ON /* join condition not captured in parsed metadata */
INNER JOIN C_POItemDeliveryScheduleCount AS POItemDelScheduleCount ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MaterialText AS _Text ON Material = _Text.Material  -- association [0..*]
LEFT OUTER JOIN E_Purchaserequisitionitem AS _PRItemExtension ON PurchaseRequisition = _PRItemExtension.PurchaseRequisition AND PurchaseRequisitionItem = _PRItemExtension.PurchaseRequisitionItem  -- association [0..1]
LEFT OUTER JOIN E_PurchasingDocument AS _PurDocHeaderExtension ON PurchasingDocument = _PurDocHeaderExtension.PurchasingDocument  -- association [0..1]
LEFT OUTER JOIN E_PurchasingDocumentItem AS _PurDocItemExtension ON PurchasingDocument = _PurDocItemExtension.PurchasingDocument AND PurchasingDocumentItem = _PurDocItemExtension.PurchasingDocumentItem  -- association [0..1]
;