R_CustomerReturnItemTP

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 R_CustomerReturnItemTP.
-- 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 R_CustomerReturnItemTP AS
SELECT
  CustomerReturnItem.CustomerReturn AS CustomerReturn,
  CustomerReturnItem.CustomerReturnItem AS CustomerReturnItem,
  CustomerReturnItem.HigherLevelItem AS HigherLevelItem,
  CustomerReturnItem.CustomerReturnItemCategory AS CustomerReturnItemCategory,
  CustomerReturnItem.CustomerReturnItemText AS CustomerReturnItemText,
  CustomerReturnItem.PurchaseOrderByCustomer AS PurchaseOrderByCustomer,
  CustomerReturnItem.Product AS Product,
  CustomerReturnItem.Material AS Material,
  CustomerReturnItem.MaterialByCustomer AS MaterialByCustomer,
  CustomerReturnItem.ProductGroup AS ProductGroup,
  CustomerReturnItem.Batch AS Batch,
  CustomerReturnItem.RequestedQuantity AS RequestedQuantity,
  CustomerReturnItem.RequestedQuantityUnit AS RequestedQuantityUnit,
  CustomerReturnItem.ItemGrossWeight AS ItemGrossWeight,
  CustomerReturnItem.ItemNetWeight AS ItemNetWeight,
  CustomerReturnItem.ItemWeightUnit AS ItemWeightUnit,
  CustomerReturnItem.ItemVolume AS ItemVolume,
  CustomerReturnItem.ItemVolumeUnit AS ItemVolumeUnit,
  CustomerReturnItem.NetAmount AS NetAmount,
  CustomerReturnItem.TransactionCurrency AS TransactionCurrency,
  CustomerReturnItem.PricingDate AS PricingDate,
  CustomerReturnItem.TaxAmount AS TaxAmount,
  _CustomerReturn.SDPricingProcedure AS SDPricingProcedure,
  CustomerReturnItem.Plant AS ProductionPlant,
  CustomerReturnItem.StorageLocation AS StorageLocation,
  CustomerReturnItem.ShippingPoint AS ShippingPoint,
  CustomerReturnItem.DeliveryPriority AS DeliveryPriority,
  CustomerReturnItem.ShippingType AS ShippingType,
  CustomerReturnItem.SalesDocumentRjcnReason AS SalesDocumentRjcnReason,
  CustomerReturnItem.ItemBillingBlockReason AS ItemBillingBlockReason,
  CustomerReturnItem.ProfitCenter AS ProfitCenter,
  CustomerReturnItem.WBSElementInternalID AS WBSElementInternalID,
  CustomerReturnItem._WBSElementBasicData_2.WBSElementExternalID AS WBSElementExternalID,
  CustomerReturnItem.IncotermsClassification AS IncotermsClassification,
  CustomerReturnItem.IncotermsTransferLocation AS IncotermsTransferLocation,
  CustomerReturnItem.IncotermsLocation1 AS IncotermsLocation1,
  CustomerReturnItem.IncotermsLocation2 AS IncotermsLocation2,
  CustomerReturnItem.CustomerPaymentTerms AS CustomerPaymentTerms,
  CustomerReturnItem.RetsMgmtProcess AS RetsMgmtProcess,
  CustomerReturnItem.RetsMgmtProcessItem AS RetsMgmtProcessItem,
  CustomerReturnItem.ReturnReason AS ReturnReason,
  CustomerReturnItem.RetsMgmtProcessingBlock AS RetsMgmtProcessingBlock,
  CustomerReturnItem.CustRetItmFollowUpActivity AS CustRetItmFollowUpActivity,
  CustomerReturnItem.ReturnsMaterialHasBeenReceived AS ReturnsMaterialHasBeenReceived,
  cast ( '' as msr_cust_insp_comment ) AS CustRetItmCustomerText,
  cast ( '' as msr_insp_comment ) AS CustRetItmInspectionText,
  CustomerReturnItem.ReturnsRefundType AS ReturnsRefundType,
  cast(CustomerReturnItem.ReturnsRefundProcgMode as msr_refund_control preserving type) AS ReturnsRefundProcgMode,
  CustomerReturnItem.RetsProdValnIsSuspended AS RetsProdValnIsSuspended,
  CustomerReturnItem.ReturnsRefundExtent AS ReturnsRefundExtent,
  CustomerReturnItem.PrelimRefundIsDetermined AS PrelimRefundIsDetermined,
  CustomerReturnItem.ReturnsRefundRjcnReason AS ReturnsRefundRjcnReason,
  CustomerReturnItem.ReplacementMaterial AS ReplacementMaterial,
  CustomerReturnItem.ReplacementMaterialQuantity AS ReplacementMaterialQuantity,
  CustomerReturnItem.ReplacementMaterialQtyUnit AS ReplacementMaterialQtyUnit,
  CustomerReturnItem.ReplacementMaterialIsRequested AS ReplacementMaterialIsRequested,
  CustomerReturnItem.ReplacementMatlSupplyingPlant AS ReplacementMatlSupplyingPlant,
  CustomerReturnItem.NextPlantForFollowUpActivity AS NextPlantForFollowUpActivity,
  CustomerReturnItem.ReturnsTransshipmentPlant AS ReturnsTransshipmentPlant,
  CustomerReturnItem.Supplier AS Supplier,
  CustomerReturnItem._Supplier.SupplierName AS SupplierName,
  CustomerReturnItem.SupplierRetMatlAuthzn AS SupplierRetMatlAuthzn,
  CustomerReturnItem.AddressID AS ReturnToAddressID,
  CustomerReturnItem.SuplrRetMatlAuthznIsRequired AS SuplrRetMatlAuthznIsRequired,
  CustomerReturnItem.CustomerRetMatlInspResultCode AS CustomerRetMatlInspResultCode,
  CustomerReturnItem.NextFllwUpActivityForMatlInsp AS NextFllwUpActivityForMatlInsp,
  CustomerReturnItem.RetMatlInspResultCode AS RetMatlInspResultCode,
  CustomerReturnItem.ProductIsInspectedAtCustSite AS ProductIsInspectedAtCustSite,
  CustomerReturnItem.CustRetMatlAuthzn AS CustRetMatlAuthzn,
  CustomerReturnItem._SalesDocumentRjcnReason AS _SalesDocumentRjcnReason,
  CustomerReturnItem.ProductionVersion AS ProductionVersion,
  CustomerReturnItem.CRMLogicalSystem AS CRMLogicalSystem,
  CustomerReturnItem.CRMObjectUUID AS CRMObjectUUID,
  CustomerReturnItem.CRMObjectID AS CRMObjectID,
  CustomerReturnItem.CRMObjectType AS CRMObjectType,
  CustomerReturnItem.RetsMgmtItmLogProcgStatus AS RetsMgmtItmLogProcgStatus,
  CustomerReturnItem.RetsMgmtItmCompnProcgStatus AS RetsMgmtItmCompnProcgStatus,
  CustomerReturnItem.RetsMgmtItmProcgStatus AS RetsMgmtItmProcgStatus,
  CustomerReturnItem.ReturnsDocumentStatus AS ReturnsDocumentStatus,
  CustomerReturnItem.ReturnsDocumentApprovalStatus AS ReturnsDocumentApprovalStatus,
  CustomerReturnItem.ReferenceSDDocument AS ReferenceSDDocument,
  CustomerReturnItem.ReferenceSDDocumentItem AS ReferenceSDDocumentItem,
  CustomerReturnItem.ReferenceSDDocumentCategory AS ReferenceSDDocumentCategory,
  CustomerReturnItem.SDProcessStatus AS SDProcessStatus,
  CustomerReturnItem.SDDocumentRejectionStatus AS SDDocumentRejectionStatus,
  cast( _CustReturnSubsqntProcg.CustRetReleaseStatus as cust_ret_rel_status preserving type ) AS CustRetReleaseStatus,
  CustomerReturnItem.Subtotal1Amount AS Subtotal1Amount,
  CustomerReturnItem.Subtotal2Amount AS Subtotal2Amount,
  CustomerReturnItem.Subtotal3Amount AS Subtotal3Amount,
  CustomerReturnItem.Subtotal4Amount AS Subtotal4Amount,
  CustomerReturnItem.Subtotal5Amount AS Subtotal5Amount,
  CustomerReturnItem.Subtotal6Amount AS Subtotal6Amount,
  _CustomerReturn.CustomerReturnType AS CustomerReturnType,
  _CustomerReturn.OrganizationDivision AS OrganizationDivision,
  _CustomerReturn.SalesOrganization AS SalesOrganization,
  _CustomerReturn.DistributionChannel AS DistributionChannel,
  _CustomerReturn._SDPricingProcedure AS _SDPricingProcedure,
  CustomerReturnItem._ProductGroup AS _ProductGroup,
  CustomerReturnItem._WBSElementBasicData_2 AS _WBSElementBasicData_2,
  CustomerReturnItem._RequestedQuantityUnit AS _RequestedQuantityUnit,
  CustomerReturnItem._ItemWeightUnit AS _ItemWeightUnit,
  CustomerReturnItem._ItemVolumeUnit AS _ItemVolumeUnit
FROM I_CustomerReturnItemEnhanced AS CustomerReturnItem
LEFT OUTER JOIN I_CustomerReturnProcessStep AS _ReturnProcessStep ON RetsMgmtProcessItem = CustomerReturnItem.CustomerReturnItem AND RetsMgmtProcess = CustomerReturnItem.RetsMgmtProcess  -- association [0..*]
LEFT OUTER JOIN I_WBSElementByExternalID AS _WBSElementExternalID ON WBSElementExternalID = _WBSElementExternalID.WBSElementExternalID  -- association [0..1]
LEFT OUTER JOIN P_CustReturnSubsqntProcg AS _CustReturnSubsqntProcg ON CustomerReturn = _CustReturnSubsqntProcg.CustomerReturn AND CustomerReturnItem = _CustReturnSubsqntProcg.CustomerReturnItem  -- association [0..1]
LEFT OUTER JOIN E_SalesDocumentItemBasic AS _Extension ON CustomerReturn = _Extension.SalesDocument AND CustomerReturnItem = _Extension.SalesDocumentItem  -- association [1]
LEFT OUTER JOIN R_CustomerReturnItemPartnerTP AS _ItemPartner ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_CustomerReturnItemTextTP AS _ItemText ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_CustRetItemPricingElementTP AS _ItemPricingElement ON /* condition not available in parsed metadata */  -- association [0..*]
;