P_ReturnsDocumentItemRefund

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_ReturnsDocumentItemRefund.
-- 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: PCRTITMRFND

CREATE VIEW P_ReturnsDocumentItemRefund AS
SELECT
  Refund.CustomerReturn AS CustomerReturn,
  Refund.CustomerReturnItem AS CustomerReturnItem,
  AdvncdRetsMgmtMatlInspection.InspectionDocument AS InspectionDocument,
  Refund.CustomerReturnItemCategory AS CustomerReturnItemCategory,
  cast(Refund.OrderQuantity as returned_quantity) AS OrderQuantity,
  Refund.OrderQuantityUnit AS OrderQuantityUnit,
  Refund.ReturnsRefundExtent AS ReturnsRefundExtent,
  Refund.ReturnsRefundType AS ReturnsRefundType,
  Refund.HigherLevelItem AS HigherLevelItem,
  Refund.ProductConfiguration AS ProductConfiguration,
  AdvncdRetsMgmtCompnStatus.RetsMgmtProcessStep AS RetsMgmtProcessStep,
  Refund.RetsMgmtProcess AS RetsMgmtProcess,
  Refund.RetsMgmtProcessItem AS RetsMgmtProcessItem,
  Refund.ReturnsRefundProcgMode AS ReturnsRefundProcgMode,
  cast(Refund.Product as productnumber preserving type) AS Material,
  Refund.ReturnsRefundRjcnReason AS ReturnsRefundRjcnReason,
  Refund.NetAmount AS NetAmount,
  Refund.TransactionCurrency AS TransactionCurrency,
  cast(AdvncdRetsMgmtMatlInspection.RetMatlInspResultCode as msr_inspection_code) AS RetMatlInspResultCode,
  Refund._CustomerReturn.SalesOrganization AS SalesOrganization,
  Refund._CustomerReturn.DistributionChannel AS DistributionChannel,
  Refund._CustomerReturn.OrganizationDivision AS OrganizationDivision,
  Refund._CustomerReturn.CustomerReturnType AS CustomerReturnType,
  Refund.Plant AS Plant,
  Refund.Batch AS Batch,
  Refund.BillOfMaterial AS BillOfMaterial,
  AdvncdRetsMgmtMatlInspection.ReturnsDelivery AS ReturnsDelivery,
  AdvncdRetsMgmtMatlInspection.ReturnsDeliveryItem AS ReturnsDeliveryItem,
  AdvncdRetsMgmtMatlInspection.InspectedProductQtyInBaseUnit AS InspectedProductQtyInBaseUnit,
  Refund.CustRetItmFollowUpActivity AS CustRetItmFollowUpActivity,
  cast('' as meins) AS BaseUnit
FROM P_CustomerReturnItemEnhanced AS Refund
INNER JOIN I_AdvncdRetsMgmtMatlInspection AS AdvncdRetsMgmtMatlInspection ON /* join condition not captured in parsed metadata */
-- UNION ALL with additional select branch(es): P_CustomerReturnItemEnhanced
;