I_CustomerReturnItemEnhanced

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 I_CustomerReturnItemEnhanced.
-- 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 I_CustomerReturnItemEnhanced AS
SELECT
  Item.CustomerReturn AS CustomerReturn,
  Item.CustomerReturnItem AS CustomerReturnItem,
  Item.CustomerReturnItemUUID AS CustomerReturnItemUUID,
  Item.CustomerReturnItemCategory AS CustomerReturnItemCategory,
  Item.CustomerReturnItemType AS CustomerReturnItemType,
  Item.IsReturnsItem AS IsReturnsItem,
  Item.CreatedByUser AS CreatedByUser,
  Item.CreationDate AS CreationDate,
  Item.CreationTime AS CreationTime,
  Item.LastChangeDate AS LastChangeDate,
  Item.Division AS Division,
  Item.Material AS Material,
  Item._Material AS _Material,
  Item.Product AS Product,
  Item._Product AS _Product,
  Item.MaterialGroup AS MaterialGroup,
  Item._MaterialGroup AS _MaterialGroup,
  Item.ProductGroup AS ProductGroup,
  Item._ProductGroup AS _ProductGroup,
  Item.OriginallyRequestedMaterial AS OriginallyRequestedMaterial,
  Item.MaterialByCustomer AS MaterialByCustomer,
  Item.InternationalArticleNumber AS InternationalArticleNumber,
  Item.Batch AS Batch,
  Item.ProductHierarchyNode AS ProductHierarchyNode,
  Item.ProductCatalog AS ProductCatalog,
  Item.AdditionalMaterialGroup1 AS AdditionalMaterialGroup1,
  Item.AdditionalMaterialGroup2 AS AdditionalMaterialGroup2,
  Item.AdditionalMaterialGroup3 AS AdditionalMaterialGroup3,
  Item.AdditionalMaterialGroup4 AS AdditionalMaterialGroup4,
  Item.AdditionalMaterialGroup5 AS AdditionalMaterialGroup5,
  Item.MatlAccountAssignmentGroup AS MatlAccountAssignmentGroup,
  Item.Plant AS Plant,
  Item.StorageLocation AS StorageLocation,
  Item.ProductConfiguration AS ProductConfiguration,
  Item.BillOfMaterial AS BillOfMaterial,
  Item.BOMExplosionDate AS BOMExplosionDate,
  Item.CustomerReturnItemText AS CustomerReturnItemText,
  Item.PurchaseOrderByCustomer AS PurchaseOrderByCustomer,
  Item.PurchaseOrderByShipToParty AS PurchaseOrderByShipToParty,
  Item.CorrespncExternalReference AS CorrespncExternalReference,
  Item.CorrespncExtRefByShipToParty AS CorrespncExtRefByShipToParty,
  Item.UnderlyingPurchaseOrderItem AS UnderlyingPurchaseOrderItem,
  Item.UndrlgPurOrdItmByShipToParty AS UndrlgPurOrdItmByShipToParty,
  Item.CustPurOrdTypeByShipToParty AS CustPurOrdTypeByShipToParty,
  Item.CustomerPurchaseOrderType AS CustomerPurchaseOrderType,
  Item.OrderQuantity AS OrderQuantity,
  Item.ConfdDelivQtyInOrderQtyUnit AS ConfdDelivQtyInOrderQtyUnit,
  Item.TargetDelivQtyInOrderQtyUnit AS TargetDelivQtyInOrderQtyUnit,
  Item.OrderQuantityUnit AS OrderQuantityUnit,
  Item.ConfdDeliveryQtyInBaseUnit AS ConfdDeliveryQtyInBaseUnit,
  Item.BaseUnit AS BaseUnit,
  Item.OrderToBaseQuantityDnmntr AS OrderToBaseQuantityDnmntr,
  Item.OrderToBaseQuantityNmrtr AS OrderToBaseQuantityNmrtr,
  Item.RequestedQuantity AS RequestedQuantity,
  Item.RequestedQuantityUnit AS RequestedQuantityUnit,
  Item.RequestedQuantityInBaseUnit AS RequestedQuantityInBaseUnit,
  Item.ItemGrossWeight AS ItemGrossWeight,
  Item.ItemNetWeight AS ItemNetWeight,
  Item.ItemWeightUnit AS ItemWeightUnit,
  Item.ItemVolume AS ItemVolume,
  Item.ItemVolumeUnit AS ItemVolumeUnit,
  Item.ServicesRenderedDate AS ServicesRenderedDate,
  Item.SalesDistrict AS SalesDistrict,
  Item.SalesDeal AS SalesDeal,
  Item.CustomerGroup AS CustomerGroup,
  Item.SalesDocumentRjcnReason AS SalesDocumentRjcnReason,
  Item.NetAmount AS NetAmount,
  Item.PricingDate AS PricingDate,
  Item.TransactionCurrency AS TransactionCurrency,
  Item.ExchangeRateDate AS ExchangeRateDate,
  Item.PriceDetnExchangeRate AS PriceDetnExchangeRate,
  Item.NetPriceAmount AS NetPriceAmount,
  Item.NetPriceQuantity AS NetPriceQuantity,
  Item.NetPriceQuantityUnit AS NetPriceQuantityUnit,
  Item.StatisticalValueControl AS StatisticalValueControl,
  Item.TaxAmount AS TaxAmount,
  Item.CostAmount AS CostAmount,
  Item.Subtotal1Amount AS Subtotal1Amount,
  Item.Subtotal2Amount AS Subtotal2Amount,
  Item.Subtotal3Amount AS Subtotal3Amount,
  Item.Subtotal4Amount AS Subtotal4Amount,
  Item.Subtotal5Amount AS Subtotal5Amount,
  Item.Subtotal6Amount AS Subtotal6Amount,
  Item.ShippingPoint AS ShippingPoint,
  Item.ShippingType AS ShippingType,
  Item.InventorySpecialStockType AS InventorySpecialStockType,
  Item.DeliveryPriority AS DeliveryPriority,
  Item.Route AS Route,
  Item.DeliveryDateQuantityIsFixed AS DeliveryDateQuantityIsFixed,
  Item.PartialDeliveryIsAllowed AS PartialDeliveryIsAllowed,
  Item.MaxNmbrOfPartialDelivery AS MaxNmbrOfPartialDelivery,
  Item.UnlimitedOverdeliveryIsAllowed AS UnlimitedOverdeliveryIsAllowed,
  Item.OverdelivTolrtdLmtRatioInPct AS OverdelivTolrtdLmtRatioInPct,
  Item.UnderdelivTolrtdLmtRatioInPct AS UnderdelivTolrtdLmtRatioInPct,
  Item.MinDeliveryQtyInBaseUnit AS MinDeliveryQtyInBaseUnit,
  Item.IncotermsClassification AS IncotermsClassification,
  Item.IncotermsTransferLocation AS IncotermsTransferLocation,
  Item.IncotermsLocation1 AS IncotermsLocation1,
  Item.IncotermsLocation2 AS IncotermsLocation2,
  Item.IncotermsVersion AS IncotermsVersion,
  Item.ItemIsDeliveryRelevant AS ItemIsDeliveryRelevant,
  Item.BillingDocumentDate AS BillingDocumentDate,
  Item.ItemIsBillingRelevant AS ItemIsBillingRelevant,
  Item.ItemBillingBlockReason AS ItemBillingBlockReason,
  Item.CustomerPaymentTerms AS CustomerPaymentTerms,
  Item.PaymentMethod AS PaymentMethod,
  Item.CustomerPriceGroup AS CustomerPriceGroup,
  Item.MaterialPricingGroup AS MaterialPricingGroup,
  Item.FixedValueDate AS FixedValueDate,
  Item.ProductTaxClassification1 AS ProductTaxClassification1,
  Item.ProductTaxClassification2 AS ProductTaxClassification2,
  Item.ProductTaxClassification3 AS ProductTaxClassification3,
  Item.ProductTaxClassification4 AS ProductTaxClassification4,
  Item.ProductTaxClassification5 AS ProductTaxClassification5,
  Item.ProductTaxClassification6 AS ProductTaxClassification6,
  Item.ProductTaxClassification7 AS ProductTaxClassification7,
  Item.ProductTaxClassification8 AS ProductTaxClassification8,
  Item.ProductTaxClassification9 AS ProductTaxClassification9,
  Item.FiscalYear AS FiscalYear,
  Item.FiscalPeriod AS FiscalPeriod,
  Item.CustomerAccountAssignmentGroup AS CustomerAccountAssignmentGroup,
  Item.BusinessArea AS BusinessArea,
  Item.ProfitCenter AS ProfitCenter,
  Item.ControllingArea AS ControllingArea,
  Item.WBSElementInternalID AS WBSElementInternalID,
  Item.OrderID AS OrderID,
  Item.ControllingObject AS ControllingObject,
  Item.ProfitabilitySegment AS ProfitabilitySegment,
  Item.ProfitabilitySegment_2 AS ProfitabilitySegment_2,
  Item.OriginSDDocument AS OriginSDDocument,
  Item.OriginSDDocumentItem AS OriginSDDocumentItem,
  Item.ReferenceSDDocument AS ReferenceSDDocument,
  Item.ReferenceSDDocumentItem AS ReferenceSDDocumentItem,
  Item.ReferenceSDDocumentCategory AS ReferenceSDDocumentCategory,
  Item.HigherLevelItem AS HigherLevelItem,
  Item.BusinessSolutionOrderItem AS BusinessSolutionOrderItem,
  Item.BusSolnOrdItemBundleItem AS BusSolnOrdItemBundleItem,
  Item.RetsMgmtProcess AS RetsMgmtProcess,
  AdvncdRetsMgmtProcessItem.RetsMgmtProcessItem AS RetsMgmtProcessItem,
  Item.ReturnReason AS ReturnReason,
  Item.ReturnsRefundExtent AS ReturnsRefundExtent,
  Item.RetsMgmtProcessingBlock AS RetsMgmtProcessingBlock,
  AdvncdRetsMgmtProcessItem.ReturnsRefundRjcnReason AS ReturnsRefundRjcnReason,
  AdvncdRetsMgmtProcessItem.CustRetMatlAuthzn AS CustRetMatlAuthzn,
  AdvncdRetsMgmtProcessItem.CustomerRetMatlInspResultCode AS CustomerRetMatlInspResultCode,
  AdvncdRetsMgmtProcessItem.NextFllwUpActivityForMatlInsp AS NextFllwUpActivityForMatlInsp,
  AdvncdRetsMgmtProcessItem.RetsMgmtItmLogProcgStatus AS RetsMgmtItmLogProcgStatus,
  AdvncdRetsMgmtProcessItem.RetsMgmtItmCompnProcgStatus AS RetsMgmtItmCompnProcgStatus,
  AdvncdRetsMgmtProcessItem.RetsMgmtItmProcgStatus AS RetsMgmtItmProcgStatus,
  ItemWithReleaseStatus.CustRetReleaseStatus AS CustRetReleaseStatus,
  AdvncdRetsMgmtProcessItem.CRMLogicalSystem AS CRMLogicalSystem,
  AdvncdRetsMgmtProcessItem.CRMObjectUUID AS CRMObjectUUID,
  AdvncdRetsMgmtProcessItem.CRMObjectID AS CRMObjectID,
  AdvncdRetsMgmtProcessItem.CRMObjectType AS CRMObjectType,
  AdvncdRetsMgmtProcessStep.RetsMgmtProcItmQtySplit AS RetsMgmtProcItmQtySplit,
  AdvncdRetsMgmtProcessStep.RetsMgmtProcessStep AS RetsMgmtProcessStep,
  AdvncdRetsMgmtProcessStep.ReturnsDocumentType AS ReturnsDocumentType,
  AdvncdRetsMgmtProcessStep.ReturnsDocument AS ReturnsDocument,
  AdvncdRetsMgmtProcessStep.ReturnsDocumentItem AS ReturnsDocumentItem,
  AdvncdRetsMgmtProcessStep.ReturnsReferenceDocumentType AS ReturnsReferenceDocumentType,
  AdvncdRetsMgmtProcessStep.ReturnsReferenceDocument AS ReturnsReferenceDocument,
  AdvncdRetsMgmtProcessStep.ReturnsReferenceDocumentItem AS ReturnsReferenceDocumentItem,
  AdvncdRetsMgmtProcessStep.ReturnsDocumentStatus AS ReturnsDocumentStatus,
  AdvncdRetsMgmtProcessStep.ReturnsDocumentApprovalStatus AS ReturnsDocumentApprovalStatus,
  AdvncdRetsMgmtProcessStep.RetsMgmtProcItmExectdSequence AS RetsMgmtProcItmExectdSequence,
  AdvncdRetsMgmtProcessStep.CustRetItmChainID AS CustRetItmChainID,
  AdvncdRetsMgmtProcessStep.CustRetItmFollowUpActivity AS CustRetItmFollowUpActivity,
  AdvncdRetsMgmtProcessStep.ReturnsMaterialHasBeenReceived AS ReturnsMaterialHasBeenReceived,
  AdvncdRetsMgmtProcessStep.NextPlantForFollowUpActivity AS NextPlantForFollowUpActivity,
  AdvncdRetsMgmtProcessStep.ReturnsTransshipmentPlant AS ReturnsTransshipmentPlant,
  AdvncdRetsMgmtProcessStep.ReturnsRefundType AS ReturnsRefundType,
  AdvncdRetsMgmtProcessStep.ReturnsRefundProcgMode AS ReturnsRefundProcgMode,
  AdvncdRetsMgmtProcessItem.RetsProdValnIsSuspended AS RetsProdValnIsSuspended,
  AdvncdRetsMgmtProcessItem.RetsInspIsCrtedAutomly AS RetsInspIsCrtedAutomly,
  AdvncdRetsMgmtProcessItem.RetsProdIsVltdWithRef AS RetsProdIsVltdWithRef,
  AdvncdRetsMgmtProcessStep.PrelimRefundIsDetermined AS PrelimRefundIsDetermined,
  AdvncdRetsMgmtProcessStep.ReplacementMaterial AS ReplacementMaterial,
  AdvncdRetsMgmtProcessStep.ReplacementMaterialQuantity AS ReplacementMaterialQuantity,
  AdvncdRetsMgmtProcessStep.ReplacementMaterialQtyUnit AS ReplacementMaterialQtyUnit,
  AdvncdRetsMgmtProcessStep.ReplacementMaterialIsRequested AS ReplacementMaterialIsRequested,
  AdvncdRetsMgmtProcessStep.ReplacementMatlSupplyingPlant AS ReplacementMatlSupplyingPlant,
  AdvncdRetsMgmtProcessStep.Supplier AS Supplier,
  AdvncdRetsMgmtProcessStep.AddressID AS AddressID,
  AdvncdRetsMgmtProcessStep.SupplierRetMatlAuthzn AS SupplierRetMatlAuthzn,
  AdvncdRetsMgmtProcessStep.SuplrRetMatlAuthznIsRequired AS SuplrRetMatlAuthznIsRequired,
  AdvncdRetsMgmtProcessStep.RetMatlInspResultCode AS RetMatlInspResultCode,
  AdvncdRetsMgmtProcessStep.ProductIsInspectedAtCustSite AS ProductIsInspectedAtCustSite,
  Item.SDProcessStatus AS SDProcessStatus,
  Item.TotalDeliveryStatus AS TotalDeliveryStatus,
  Item.DeliveryStatus AS DeliveryStatus,
  Item.DeliveryBlockStatus AS DeliveryBlockStatus,
  Item.OrderRelatedBillingStatus AS OrderRelatedBillingStatus,
  Item.BillingBlockStatus AS BillingBlockStatus,
  Item.ItemGeneralIncompletionStatus AS ItemGeneralIncompletionStatus,
  Item.ItemBillingIncompletionStatus AS ItemBillingIncompletionStatus,
  Item.PricingIncompletionStatus AS PricingIncompletionStatus,
  Item.ItemDeliveryIncompletionStatus AS ItemDeliveryIncompletionStatus,
  Item.SDDocumentRejectionStatus AS SDDocumentRejectionStatus,
  Item.TotalSDDocReferenceStatus AS TotalSDDocReferenceStatus,
  Item.SoldToParty AS SoldToParty,
  Item.CustomerReturnType AS CustomerReturnType,
  Item.SalesOrganization AS SalesOrganization,
  Item.DistributionChannel AS DistributionChannel,
  Item.OrganizationDivision AS OrganizationDivision,
  Item._ScheduleLine AS _ScheduleLine,
  Item._Partner AS _Partner,
  Item._ItemCategory AS _ItemCategory,
  Item._HigherLevelItem AS _HigherLevelItem,
  Item._CreatedByUser AS _CreatedByUser,
  Item._Division AS _Division,
  Item._OriginallyRequestedMaterial AS _OriginallyRequestedMaterial,
  Item._ProductHierarchyNode AS _ProductHierarchyNode,
  Item._AdditionalMaterialGroup1 AS _AdditionalMaterialGroup1,
  Item._AdditionalMaterialGroup2 AS _AdditionalMaterialGroup2,
  Item._AdditionalMaterialGroup3 AS _AdditionalMaterialGroup3,
  Item._AdditionalMaterialGroup4 AS _AdditionalMaterialGroup4,
  Item._AdditionalMaterialGroup5 AS _AdditionalMaterialGroup5,
  Item._Plant AS _Plant,
  Item._StorageLocation AS _StorageLocation,
  Item._OrderQuantityUnit AS _OrderQuantityUnit,
  Item._BaseUnit AS _BaseUnit,
  Item._RequestedQuantityUnit AS _RequestedQuantityUnit,
  Item._ItemWeightUnit AS _ItemWeightUnit,
  Item._ItemVolumeUnit AS _ItemVolumeUnit,
  Item._SalesDistrict AS _SalesDistrict,
  Item._SalesDeal AS _SalesDeal,
  Item._CustomerGroup AS _CustomerGroup,
  Item._SalesDocumentRjcnReason AS _SalesDocumentRjcnReason,
  Item._NetPriceQuantityUnit AS _NetPriceQuantityUnit,
  Item._TransactionCurrency AS _TransactionCurrency,
  Item._StatisticalValueControl AS _StatisticalValueControl,
  Item._ShippingPoint AS _ShippingPoint,
  Item._DeliveryPriority AS _DeliveryPriority,
  Item._IncotermsClassification AS _IncotermsClassification,
  Item._IncotermsVersion AS _IncotermsVersion,
  Item._ItemBillingBlockReason AS _ItemBillingBlockReason,
  Item._ItemIsBillingRelevant AS _ItemIsBillingRelevant,
  Item._CustomerPaymentTerms AS _CustomerPaymentTerms,
  Item._CustomerPurchaseOrderType AS _CustomerPurchaseOrderType,
  Item._CustPurOrdTypeByShipToParty AS _CustPurOrdTypeByShipToParty,
  Item._CustomerAccountAssgmtGroup AS _CustomerAccountAssgmtGroup,
  Item._BusinessArea AS _BusinessArea,
  Item._WBSElementBasicData_2 AS _WBSElementBasicData_2,
  Item._MatlAccountAssignmentGroup AS _MatlAccountAssignmentGroup,
  Item._ProfitCenter AS _ProfitCenter,
  Item._ControllingArea AS _ControllingArea,
  Item._ReferenceSDDocument AS _ReferenceSDDocument,
  Item._ReferenceSDDocumentItem AS _ReferenceSDDocumentItem,
  Item._ReferenceSDDocumentCategory AS _ReferenceSDDocumentCategory,
  Item._ReturnReason AS _ReturnReason,
  Item._ReturnsRefundExtent AS _ReturnsRefundExtent,
  AdvncdRetsMgmtProcessStep._ReturnsReferenceDocumentType AS _ReturnsReferenceDocumentType,
  AdvncdRetsMgmtProcessItem._ReturnsRefundRjcnReason AS _ReturnsRefundRjcnReason,
  AdvncdRetsMgmtProcessItem._RetsMgmtItmLogProcgStatus AS _RetsMgmtItmLogProcgStatus,
  AdvncdRetsMgmtProcessItem._RetsMgmtItmCompnProcgStatus AS _RetsMgmtItmCompnProcgStatus,
  AdvncdRetsMgmtProcessItem._RetsMgmtItmProcgStatus AS _RetsMgmtItmProcgStatus,
  AdvncdRetsMgmtProcessStep._ReturnsRefundType AS _ReturnsRefundType,
  AdvncdRetsMgmtProcessStep._ReturnsRefundProcgMode AS _ReturnsRefundProcgMode,
  AdvncdRetsMgmtProcessStep._ReplacementMaterialQtyUnit AS _ReplacementMaterialQtyUnit,
  AdvncdRetsMgmtProcessStep._Supplier AS _Supplier,
  AdvncdRetsMgmtProcessStep._Address AS _Address,
  AdvncdRetsMgmtProcessStep._DfltAddrRprstn AS _DfltAddrRprstn,
  AdvncdRetsMgmtProcessStep._RetMatlInspResultCode AS _RetMatlInspResultCode,
  Item._SDProcessStatus AS _SDProcessStatus,
  Item._TotalDeliveryStatus AS _TotalDeliveryStatus,
  Item._DeliveryStatus AS _DeliveryStatus,
  Item._DeliveryBlockStatus AS _DeliveryBlockStatus,
  Item._OrderRelatedBillingStatus AS _OrderRelatedBillingStatus,
  Item._BillingBlockStatus AS _BillingBlockStatus,
  Item._ItemGeneralIncompletionStatus AS _ItemGeneralIncompletionStatus,
  Item._ItemBillingIncompletionStatus AS _ItemBillingIncompletionStatus,
  Item._PricingIncompletionStatus AS _PricingIncompletionStatus,
  Item._ItemDelivIncompletionSts AS _ItemDelivIncompletionSts,
  Item._SDDocumentRejectionStatus AS _SDDocumentRejectionStatus,
  Item._TotalSDDocReferenceStatus AS _TotalSDDocReferenceStatus
FROM I_CustomerReturnItem AS Item
LEFT OUTER JOIN I_AdvncdReturnsMgmtProcessStep AS AdvncdRetsMgmtProcessStep ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CustomerReturnEnhanced AS _CustomerReturn ON _CustomerReturn.CustomerReturn = CustomerReturn  -- association [1..1]
;