C_CustomerReturnItemRefund

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_CustomerReturnItemRefund.
-- 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.

CREATE VIEW C_CustomerReturnItemRefund AS
SELECT
  cast (Refund.CustomerReturn as msr_returns_order preserving type) AS CustomerReturn,
  Refund.CustomerReturnItem AS CustomerReturnItem,
  Refund.InspectionDocument AS InspectionDocument,
  cast('' as msr_fin_status) AS RetsMgmtItmCompnProcgStatus,
  Refund.CustomerReturnItemCategory AS CustomerReturnItemCategory,
  Refund.OrderQuantity AS OrderQuantity,
  Refund.OrderQuantityUnit AS OrderQuantityUnit,
  cast(0 as msr_rep_refunded) AS CustReturnItmRefundedQty,
  cast('' as char1) AS CustReturnItmIsCmpltlyRefunded,
  cast(0 as refunding_quantity) AS CustReturnItmOpenRefundQty,
  Refund.ReturnsRefundExtent AS ReturnsRefundExtent,
  Refund.ReturnsRefundType AS ReturnsRefundType,
  Refund.HigherLevelItem AS HigherLevelItem,
  Refund.RetsMgmtProcessStep AS RetsMgmtProcessStep,
  Refund.RetsMgmtProcess AS RetsMgmtProcess,
  Refund.RetsMgmtProcessItem AS RetsMgmtProcessItem,
  _CustRetItemCategory.BillingRelevanceCode AS BillingRelevanceCode,
  Refund.ReturnsRefundProcgMode AS ReturnsRefundProcgMode,
  Refund.Material AS Material,
  Refund.ReturnsRefundRjcnReason AS ReturnsRefundRjcnReason,
  Refund.NetAmount AS NetAmount,
  Refund.TransactionCurrency AS TransactionCurrency,
  Refund.RetMatlInspResultCode AS RetMatlInspResultCode,
  Refund.SalesOrganization AS SalesOrganization,
  Refund.DistributionChannel AS DistributionChannel,
  Refund.OrganizationDivision AS OrganizationDivision,
  Refund.CustomerReturnType AS CustomerReturnType,
  Refund.Plant AS Plant,
  Refund.Batch AS Batch,
  cast( $session.system_language as spras ) AS Language,
  Refund.ReplacementMaterial AS ReplacementMaterial,
  cast(0 as refunding_quantity) AS ReplacementMaterialQuantity,
  Refund.ReplacementMaterialQtyUnit AS ReplacementMaterialQtyUnit,
  Refund.ReplacementMatlSupplyingPlant AS ReplacementMatlSupplyingPlant,
  Refund.BillOfMaterial AS BillOfMaterial,
  Refund.CustRetItmFollowUpActivity AS CustRetItmFollowUpActivity,
  Refund.InspectedProductQtyInBaseUnit AS InspectedProductQtyInBaseUnit,
  Refund.BaseUnit AS BaseUnit,
  cast ('' as msr_insp_itm_is_splt) AS InspectionItemIsSplit,
  _ScheduleLine.GoodsMovementType AS GoodsMovementType
FROM P_ReturnsDocumentItemRefund AS Refund
LEFT OUTER JOIN I_SalesDocumentItemCategory AS _CustRetItemCategory ON CustomerReturnItemCategory = _CustRetItemCategory.SalesDocumentItemCategory  -- association [0..1]
LEFT OUTER JOIN C_CustomerReturnRefundDetail AS _CustomerReturnRefundDetail ON CustomerReturn = _CustomerReturnRefundDetail.CustomerReturn AND CustomerReturnItem = _CustomerReturnRefundDetail.CustomerReturnItem AND InspectionDocument = _CustomerReturnRefundDetail.InspectionDocument  -- association [0..*]
LEFT OUTER JOIN C_CreditMemoRequestItem AS _CreditMemoRequestItem ON CustomerReturn = _CreditMemoRequestItem.ReferenceSDDocument AND CustomerReturnItem = _CreditMemoRequestItem.ReferenceSDDocumentItem  -- association [0..*]
LEFT OUTER JOIN C_SalesOrderWithoutChargeItem AS _OrderWOCharge ON CustomerReturn = _OrderWOCharge.ReferenceSDDocument AND CustomerReturnItem = _OrderWOCharge.ReferenceSDDocumentItem  -- association [0..*]
LEFT OUTER JOIN C_CustRetSubsqntCrdtMemo AS _CreditMemo ON CustomerReturn = _CreditMemo.ReferenceSDDocument AND CustomerReturnItem = _CreditMemo.ReferenceSDDocumentItem  -- association [0..*]
LEFT OUTER JOIN I_AdvncdRetsMgmtProcExecuted AS _OutboundDeliveryOrder ON RetsMgmtProcess = _OutboundDeliveryOrder.RetsMgmtProcess AND RetsMgmtProcessItem = _OutboundDeliveryOrder.RetsMgmtProcessItem AND _OutboundDeliveryOrder.ReturnsDocumentType = '18'  -- association [0..*]
LEFT OUTER JOIN P_RefundedQuantitySum AS _RefundedQuantity ON CustomerReturn = _RefundedQuantity.CustomerReturn AND CustomerReturnItem = _RefundedQuantity.CustomerReturnItem  -- association [0..1]
LEFT OUTER JOIN P_RefundingQuantity AS _RefundingQuantity ON CustomerReturn = _RefundingQuantity.CustomerReturn AND CustomerReturnItem = _RefundingQuantity.CustomerReturnItem  -- association [0..1]
LEFT OUTER JOIN I_ReturnsRefundType AS _ReturnsRefundType ON ReturnsRefundType = _ReturnsRefundType.ReturnsRefundType  -- association [0..1]
LEFT OUTER JOIN I_ReturnsRefundExtent AS _ReturnsRefundExtent ON ReturnsRefundExtent = _ReturnsRefundExtent.ReturnsRefundExtent  -- association [0..1]
LEFT OUTER JOIN I_SalesDocumentRjcnReason AS _SalesDocumentRjcnReason ON ReturnsRefundRjcnReason = _SalesDocumentRjcnReason.SalesDocumentRjcnReason  -- association [0..1]
LEFT OUTER JOIN C_CustomerReturnProductUoMVH AS _CustomerReturnProductUoMVH ON Material = _CustomerReturnProductUoMVH.Product  -- association [0..*]
LEFT OUTER JOIN I_AdvncdReturnsMgmtProcessItem AS _RetsMgmtProcItmWthProcgSts ON RetsMgmtProcess = _RetsMgmtProcItmWthProcgSts.RetsMgmtProcess AND CustomerReturnItem = _RetsMgmtProcItmWthProcgSts.RetsMgmtProcessItem  -- association [0..1]
LEFT OUTER JOIN I_MaterialText AS _MaterialText ON Material = _MaterialText.Material  -- association [0..*]
LEFT OUTER JOIN I_MaterialText AS _RepMaterialText ON ReplacementMaterial = _RepMaterialText.Material  -- association [0..*]
LEFT OUTER JOIN I_Plant AS _SupplyingPlant ON ReplacementMatlSupplyingPlant = _SupplyingPlant.Plant  -- association [0..1]
LEFT OUTER JOIN I_RetMatlInspResultCodeText AS _RetMatlInspResultCodeText ON RetMatlInspResultCode = _RetMatlInspResultCodeText.RetMatlInspResultCode  -- association [0..*]
LEFT OUTER JOIN I_ReturnsRefundExtentText AS _ReturnsRefundExtentText ON ReturnsRefundExtent = _ReturnsRefundExtentText.ReturnsRefundExtent  -- association [0..*]
LEFT OUTER JOIN I_ReturnsRefundTypeText AS _ReturnsRefundTypeText ON ReturnsRefundType = _ReturnsRefundTypeText.ReturnsRefundType  -- association [0..*]
LEFT OUTER JOIN I_SalesDocumentRjcnReasonText AS _SalesDocumentRjcnReasonT ON ReturnsRefundRjcnReason = _SalesDocumentRjcnReasonT.SalesDocumentRjcnReason  -- association [0..*]
LEFT OUTER JOIN I_SalesDocumentTypeText AS _SalesDocumentTypeText ON CustomerReturnType = _SalesDocumentTypeText.SalesDocumentType AND _SalesDocumentTypeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_FollowUpActivityText AS _FollowUpActivityText ON CustRetItmFollowUpActivity = _FollowUpActivityText.CustRetItmFollowUpActivity  -- association [0..*]
LEFT OUTER JOIN E_SalesDocumentItemBasic AS _Extension ON CustomerReturnItem = _Extension.SalesDocumentItem AND CustomerReturn = _Extension.SalesDocument  -- association [0..1]
LEFT OUTER JOIN P_CustRetItemScheduleLine AS _ScheduleLine ON CustomerReturn = _ScheduleLine.SalesDocument AND CustomerReturnItem = _ScheduleLine.SalesDocumentItem  -- association [0..1]
;