A_CustomerReturnItem_2

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 A_CustomerReturnItem_2.
-- 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 A_CustomerReturnItem_2 AS
SELECT
  CustomerReturnItem.CustomerReturn AS CustomerReturn,
  CustomerReturnItem.CustomerReturnItem AS CustomerReturnItem,
  CustomerReturnItem.HigherLevelItem AS HigherLevelItem,
  CustomerReturnItem.CustomerReturnItemCategory AS CustomerReturnItemCategory,
  CustomerReturnItem.CustomerReturnItemText AS CustomerReturnItemText,
  CustomerReturnItem.Product AS Product,
  CustomerReturnItem.ProductGroup AS ProductGroup,
  CustomerReturnItem.MaterialByCustomer AS MaterialByCustomer,
  CustomerReturnItem.PurchaseOrderByCustomer AS PurchaseOrderByCustomer,
  CustomerReturnItem.RequestedQuantity AS RequestedQuantity,
  CustomerReturnItem.RequestedQuantityUnit AS RequestedQuantitySAPUnit,
  cast(_RequestedQuantityUnit.UnitOfMeasureISOCode as sd_reqd_qty_isounit preserving type) AS RequestedQuantityISOUnit,
  CustomerReturnItem.ItemGrossWeight AS ItemGrossWeight,
  CustomerReturnItem.ItemNetWeight AS ItemNetWeight,
  CustomerReturnItem.ItemWeightUnit AS ItemWeightSAPUnit,
  cast(_ItemWeightUnit.UnitOfMeasureISOCode as sd_itm_wgt_isounit preserving type) AS ItemWeightISOUnit,
  CustomerReturnItem.ItemVolume AS ItemVolume,
  CustomerReturnItem.ItemVolumeUnit AS ItemVolumeSAPUnit,
  cast(_ItemVolumeUnit.UnitOfMeasureISOCode as sd_itm_vol_isounit preserving type) AS ItemVolumeISOUnit,
  CustomerReturnItem.PricingDate AS PricingDate,
  CustomerReturnItem.CustomerPaymentTerms AS CustomerPaymentTerms,
  CustomerReturnItem.IncotermsClassification AS IncotermsClassification,
  CustomerReturnItem.IncotermsLocation1 AS IncotermsLocation1,
  CustomerReturnItem.IncotermsLocation2 AS IncotermsLocation2,
  CustomerReturnItem.ProfitCenter AS ProfitCenter,
  CustomerReturnItem.WBSElementExternalID AS WBSElementExternalID,
  CustomerReturnItem.SalesDocumentRjcnReason AS SalesDocumentRjcnReason,
  CustomerReturnItem.ItemBillingBlockReason AS ItemBillingBlockReason,
  CustomerReturnItem.ProductionPlant AS ProductionPlant,
  CustomerReturnItem.ShippingType AS ShippingType,
  CustomerReturnItem.StorageLocation AS StorageLocation,
  CustomerReturnItem.ShippingPoint AS ShippingPoint,
  CustomerReturnItem.DeliveryPriority AS DeliveryPriority,
  CustomerReturnItem.ReplacementMaterialIsRequested AS RplcmtProdFrmSuplrIsReqd,
  CustomerReturnItem.ReplacementMatlSupplyingPlant AS RplcmtProdSupplyingPlant,
  CustomerReturnItem.Supplier AS Supplier,
  CustomerReturnItem.SupplierRetMatlAuthzn AS SupplierRetMatlAuthzn,
  CustomerReturnItem.Batch AS Batch,
  CustomerReturnItem.CustRetMatlAuthzn AS CustRetMatlAuthzn,
  CustomerReturnItem.ReplacementMaterial AS ReplacementProduct,
  CustomerReturnItem.ReplacementMaterialQuantity AS ReplacementProductQuantity,
  CustomerReturnItem.ReplacementMaterialQtyUnit AS RplcmtProdQtySAPUnit,
  cast(_RequestedQuantityUnit.UnitOfMeasureISOCode as sd_reqd_qty_isounit preserving type) AS RplcmtProdQtyISOUnit,
  CustomerReturnItem.ReturnReason AS ReturnReason,
  CustomerReturnItem.RetMatlInspResultCode AS ReturnsInspectionCode,
  CustomerReturnItem.CustRetItmFollowUpActivity AS CustRetItmFollowUpActivity,
  CustomerReturnItem.NextFllwUpActivityForMatlInsp AS NextFllwUpActivityForMatlInsp,
  CustomerReturnItem.PrelimRefundIsDetermined AS PrelimRefundIsDetermined,
  CustomerReturnItem.ReturnsMaterialHasBeenReceived AS ReturnsProductHasBeenReceived,
  CustomerReturnItem.ReturnsRefundExtent AS ReturnsRefundCode,
  CustomerReturnItem.ReturnsRefundProcgMode AS ReturnsRefundProcgMode,
  CustomerReturnItem.ReturnsRefundRjcnReason AS ReturnsRefundRjcnReason,
  CustomerReturnItem.ReturnsRefundType AS ReturnsRefundType,
  CustomerReturnItem.RetsProdValnIsSuspended AS RetsProdValnIsSuspended,
  CustomerReturnItem.SuplrRetMatlAuthznIsRequired AS SuplrRetMatlAuthznIsRequired,
  CustomerReturnItem.ProductIsInspectedAtCustSite AS ProductIsInspectedAtCustSite,
  CustomerReturnItem.RetsMgmtProcessingBlock AS RetsMgmtProcessingBlock,
  CustomerReturnItem.NetAmount AS NetAmount,
  CustomerReturnItem.TaxAmount AS TaxAmount,
  CustomerReturnItem.TransactionCurrency AS TransactionCurrency,
  CustomerReturnItem.ProductionVersion AS ProductionVersion,
  CustomerReturnItem.Subtotal1Amount AS Subtotal1Amount,
  CustomerReturnItem.Subtotal2Amount AS Subtotal2Amount,
  CustomerReturnItem.Subtotal3Amount AS Subtotal3Amount,
  CustomerReturnItem.Subtotal4Amount AS Subtotal4Amount,
  CustomerReturnItem.Subtotal5Amount AS Subtotal5Amount,
  CustomerReturnItem.Subtotal6Amount AS Subtotal6Amount,
  CustomerReturnItem.RetsMgmtProcess AS RetsMgmtProcess,
  CustomerReturnItem.RetsMgmtProcessItem AS RetsMgmtProcessItem,
  CustomerReturnItem.RetsMgmtItmCompnProcgStatus AS RetsMgmtItmCompnProcgStatus,
  CustomerReturnItem.RetsMgmtItmLogProcgStatus AS RetsMgmtItmLogProcgStatus,
  CustomerReturnItem.RetsMgmtItmProcgStatus AS RetsMgmtItmProcgStatus,
  CustomerReturnItem.SDProcessStatus AS SDProcessStatus,
  CustomerReturnItem.SDDocumentRejectionStatus AS SDDocumentRejectionStatus,
  CustomerReturnItem.CustomerReturnType AS CustomerReturnType,
  CustomerReturnItem.OrganizationDivision AS OrganizationDivision,
  CustomerReturnItem.SalesOrganization AS SalesOrganization,
  CustomerReturnItem.DistributionChannel AS DistributionChannel
FROM R_CustomerReturnItemTP
LEFT OUTER JOIN A_CustRetItemProcessStep AS _ItemProcessStep ON CustomerReturn = _ItemProcessStep.CustomerReturn AND CustomerReturnItem = _ItemProcessStep.CustomerReturnItem  -- association [0..*]
;