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.OriginallyRequestedMaterial AS OriginallyRequestedMaterial,
  CustomerReturnItem.MaterialByCustomer AS MaterialByCustomer,
  CustomerReturnItem.InternationalArticleNumber AS InternationalArticleNumber,
  CustomerReturnItem.PurchaseOrderByCustomer AS PurchaseOrderByCustomer,
  CustomerReturnItem.PurchaseOrderByShipToParty AS PurchaseOrderByShipToParty,
  CustomerReturnItem.CorrespncExternalReference AS CorrespncExternalReference,
  CustomerReturnItem.CorrespncExtRefByShipToParty AS CorrespncExtRefByShipToParty,
  CustomerReturnItem.UnderlyingPurchaseOrderItem AS UnderlyingPurchaseOrderItem,
  CustomerReturnItem.UndrlgPurOrdItmByShipToParty AS UndrlgPurOrdItmByShipToParty,
  CustomerReturnItem.CustomerPurchaseOrderType AS CustomerPurchaseOrderType,
  CustomerReturnItem.CustPurOrdTypeByShipToParty AS CustPurOrdTypeByShipToParty,
  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.CustomerPriceGroup AS CustomerPriceGroup,
  CustomerReturnItem.MaterialPricingGroup AS MaterialPricingGroup,
  CustomerReturnItem.MatlAccountAssignmentGroup AS MatlAccountAssignmentGroup,
  CustomerReturnItem.IncotermsClassification AS IncotermsClassification,
  CustomerReturnItem.IncotermsLocation1 AS IncotermsLocation1,
  CustomerReturnItem.IncotermsLocation2 AS IncotermsLocation2,
  CustomerReturnItem.IncotermsVersion AS IncotermsVersion,
  CustomerReturnItem.BusinessArea AS BusinessArea,
  CustomerReturnItem.ProfitCenter AS ProfitCenter,
  CustomerReturnItem.WBSElementExternalID AS WBSElementExternalID,
  CustomerReturnItem.SalesDocumentRjcnReason AS SalesDocumentRjcnReason,
  CustomerReturnItem.ItemBillingBlockReason AS ItemBillingBlockReason,
  CustomerReturnItem.ServicesRenderedDate AS ServicesRenderedDate,
  CustomerReturnItem.BillingDocumentDate AS BillingDocumentDate,
  CustomerReturnItem.FixedValueDate AS FixedValueDate,
  CustomerReturnItem.Plant AS Plant,
  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.CustomerGroup AS CustomerGroup,
  CustomerReturnItem.CustRetMatlAuthzn AS CustRetMatlAuthzn,
  CustomerReturnItem.ProductConfiguration AS ProductConfiguration,
  CustomerReturnItem.VarConfigurationBusObjectKey AS VarConfigurationBusObjectKey,
  CustomerReturnItem.VarConfigurationBusObjectType AS VarConfigurationBusObjectType,
  CustomerReturnItem.ReplacementMaterial AS ReplacementProduct,
  CustomerReturnItem.ReplacementMaterialQuantity AS ReplacementProductQuantity,
  CustomerReturnItem.ReplacementMaterialQtyUnit AS RplcmtProdQtySAPUnit,
  cast(_RplcmtProdQuantityUnit.UnitOfMeasureISOCode as msr_rplcmt_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.RetsInspIsCrtedAutomly AS RetsInspIsCrtedAutomly,
  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.Subtotal1Amount AS Subtotal1Amount,
  CustomerReturnItem.Subtotal2Amount AS Subtotal2Amount,
  CustomerReturnItem.Subtotal3Amount AS Subtotal3Amount,
  CustomerReturnItem.Subtotal4Amount AS Subtotal4Amount,
  CustomerReturnItem.Subtotal5Amount AS Subtotal5Amount,
  CustomerReturnItem.Subtotal6Amount AS Subtotal6Amount,
  CustomerReturnItem.ReferenceSDDocument AS ReferenceSDDocument,
  CustomerReturnItem.ReferenceSDDocumentItem AS ReferenceSDDocumentItem,
  CustomerReturnItem.ReferenceSDDocumentCategory AS ReferenceSDDocumentCategory,
  CustomerReturnItem.BusinessSolutionOrderItem AS BusinessSolutionOrderItem,
  CustomerReturnItem.BusSolnOrdItemBundleItem AS BusSolnOrdItemBundleItem,
  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.ItemGeneralIncompletionStatus AS ItemGeneralIncompletionStatus,
  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..*]
;