I_CustomerReturnItemCube

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_CustomerReturnItemCube.
-- 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_CustomerReturnItemCube AS
SELECT
  cast(SDIA.SalesDocument as vdm_customer_return preserving type) AS CustomerReturn,
  cast(SDIA.SalesDocumentItem as vdm_customer_return_item preserving type) AS CustomerReturnItem,
  cast(SDIA.SalesDocumentType as vdm_customer_return_type preserving type) AS CustomerReturnType,
  SDIA.SalesDocumentItemType AS CustomerReturnItemType,
  SDIA.SalesDocumentItemCategory AS CustomerReturnItemCategory,
  SDIA._ItemCategory AS _ItemCategory,
  SDIA.CreatedByUser AS CreatedByUser,
  SDIA._CreatedByUser AS _CreatedByUser,
  SDIA.CreationDate AS CreationDate,
  SDIA.CreationTime AS CreationTime,
  SDIA.LastChangeDate AS LastChangeDate,
  cast(CalendarDate.CalendarYear as creation_date_year) AS CreationDateYear,
  cast(CalendarDate.YearQuarter as creation_date_year_quarter) AS CreationDateYearQuarter,
  cast(CalendarDate.YearMonth as creation_date_year_month) AS CreationDateYearMonth,
  SDIA.SalesOrganization AS SalesOrganization,
  SDIA._SalesOrganization AS _SalesOrganization,
  SDIA.DistributionChannel AS DistributionChannel,
  SDIA._DistributionChannel AS _DistributionChannel,
  cast(SDIA.OrganizationDivision as organization_division preserving type) AS OrganizationDivision,
  SDIA._OrganizationDivision AS _OrganizationDivision,
  SDIA.Division AS Division,
  SDIA._Division AS _Division,
  SDIA.SalesGroup AS SalesGroup,
  SDIA._SalesGroup AS _SalesGroup,
  SDIA.SalesOffice AS SalesOffice,
  SDIA._SalesOffice AS _SalesOffice,
  SDIA.SoldToParty AS SoldToParty,
  SDIA._SoldToParty AS _SoldToParty,
  SDIA.ShipToParty AS ShipToParty,
  SDIA._ShipToParty AS _ShipToParty,
  SDIA.PayerParty AS PayerParty,
  SDIA._PayerParty AS _PayerParty,
  SDIA.BillToParty AS BillToParty,
  SDIA._BillToParty AS _BillToParty,
  SDIA.SDDocumentReason AS SDDocumentReason,
  SDIA._SDDocumentReason AS _SDDocumentReason,
  SDIA.SalesDocumentItemText AS CustomerReturnItemText,
  SDIA.CustomerPurchaseOrderType AS CustomerPurchaseOrderType,
  SDIA._CustomerPurchaseOrderType AS _CustomerPurchaseOrderType,
  SDIA.PurchaseOrderByCustomer AS PurchaseOrderByCustomer,
  SDIA.CustomerPurchaseOrderDate AS CustomerPurchaseOrderDate,
  SDIA.CustomerGroup AS CustomerGroup,
  SDIA._CustomerGroup AS _CustomerGroup,
  SDIA.SalesDocumentRjcnReason AS SalesDocumentRjcnReason,
  SDIA._SalesDocumentRjcnReason AS _SalesDocumentRjcnReason,
  SDIA.ReturnReason AS ReturnReason,
  SDIA._ReturnReason AS _ReturnReason,
  SDIA.ReturnsRefundExtent AS ReturnsRefundExtent,
  SDIA._ReturnsRefundExtent AS _ReturnsRefundExtent,
  SDIA.RetsMgmtProcessingBlock AS RetsMgmtProcessingBlock,
  SDIA._Material AS _Material,
  Product,
  SDIA.MaterialGroup AS MaterialGroup,
  SDIA._MaterialGroup AS _MaterialGroup,
  SDIA.ProductGroup AS ProductGroup,
  SDIA._ProductGroup AS _ProductGroup,
  SDIA.Plant AS Plant,
  SDIA._Plant AS _Plant,
  SDIA.ItemWeightUnit AS ItemWeightUnit,
  SDIA._ItemWeightUnit AS _ItemWeightUnit,
  SDIA.ItemGrossWeight AS ItemGrossWeight,
  SDIA.ItemNetWeight AS ItemNetWeight,
  SDIA.ItemVolumeUnit AS ItemVolumeUnit,
  SDIA._ItemVolumeUnit AS _ItemVolumeUnit,
  SDIA.ItemVolume AS ItemVolume,
  SDIA.MainItemPricingRefProduct AS MainItemPricingRefProduct,
  SDIA.HigherLevelItem AS HigherLevelItem,
  SDIA.BillOfMaterial AS BillOfMaterial,
  SDIA.PropagatePrftbltySgmt2BOM AS PropagatePrftbltySgmt2BOM,
  SDIA.CostDeterminationIsRequired AS CostDeterminationIsRequired,
  SDIA.BillingCompanyCode AS BillingCompanyCode,
  SDIA._BillingCompanyCode AS _BillingCompanyCode,
  SDIA.ItemIsBillingRelevant AS ItemIsBillingRelevant,
  SDIA._ItemIsBillingRelevant AS _ItemIsBillingRelevant,
  cast(SDIA.ItemBillingBlockReason as billing_block_reason_item preserving type) AS ItemBillingBlockReason,
  SDIA._ItemBillingBlockReason AS _ItemBillingBlockReason,
  SDIA.ExchangeRateDate AS ExchangeRateDate,
  SDIA.PriceDetnExchangeRate AS PriceDetnExchangeRate,
  SDIA.NetPriceAmount AS NetPriceAmount,
  SDIA.NetPriceQuantity AS NetPriceQuantity,
  SDIA.NetPriceQuantityUnit AS NetPriceQuantityUnit,
  SDIA._NetPriceQuantityUnit AS _NetPriceQuantityUnit,
  SDIA.StatisticalValueControl AS StatisticalValueControl,
  SDIA._StatisticalValueControl AS _StatisticalValueControl,
  SDIA.TaxAmount AS TaxAmount,
  SDIA.CostAmount AS CostAmount,
  SDIA.Subtotal1Amount AS Subtotal1Amount,
  SDIA.Subtotal2Amount AS Subtotal2Amount,
  SDIA.Subtotal3Amount AS Subtotal3Amount,
  SDIA.Subtotal4Amount AS Subtotal4Amount,
  SDIA.Subtotal5Amount AS Subtotal5Amount,
  SDIA.Subtotal6Amount AS Subtotal6Amount,
  SDIA.CustomerPaymentTerms AS CustomerPaymentTerms,
  SDIA._CustomerPaymentTerms AS _CustomerPaymentTerms,
  SDIA.PaymentMethod AS PaymentMethod,
  SDIA.BusinessArea AS BusinessArea,
  SDIA._BusinessArea AS _BusinessArea,
  SDIA.ShippingPoint AS ShippingPoint,
  SDIA._ShippingPoint AS _ShippingPoint,
  SDIA.ReferenceSDDocumentCategory AS ReferenceSDDocumentCategory,
  SDIA._ReferenceSDDocumentCategory AS _ReferenceSDDocumentCategory,
  SDIA.ReferenceSDDocument AS ReferenceSDDocument,
  SDIA._ReferenceSDDocument AS _ReferenceSDDocument,
  SDIA.ReferenceSDDocumentItem AS ReferenceSDDocumentItem,
  SDIA._ReferenceSDDocumentItem AS _ReferenceSDDocumentItem,
  SDIA.BaseUnit AS BaseUnit,
  SDIA._BaseUnit AS _BaseUnit,
  SDIA.TransactionCurrency AS TransactionCurrency,
  SDIA._TransactionCurrency AS _TransactionCurrency,
  SDIA.NumberOfIncomingCustRetItems AS NumberOfIncomingCustRetItems,
  SDIA.IncomingCustReturnsNetAmount AS IncomingCustReturnsNetAmount,
  SDIA.IncomingCustReturnsQuantity AS IncomingCustReturnsQuantity,
  cast(SDIA.SDProcessStatus as sd_doc_process_status preserving type) AS SDProcessStatus,
  SDIA._SDProcessStatus AS _SDProcessStatus,
  SDIA.OrderRelatedBillingStatus AS OrderRelatedBillingStatus,
  SDIA._OrderRelatedBillingStatus AS _OrderRelatedBillingStatus,
  SDIA.BillingBlockStatus AS BillingBlockStatus,
  SDIA._BillingBlockStatus AS _BillingBlockStatus
FROM I_SalesDocumentItemAnalytics AS SDIA
LEFT OUTER JOIN I_CustomerReturn AS _CustomerReturn ON CustomerReturn = _CustomerReturn.CustomerReturn  -- association [1..1]
LEFT OUTER JOIN I_CustomerReturnType AS _CustomerReturnType ON CustomerReturnType = _CustomerReturnType.CustomerReturnType  -- association [0..1]
LEFT OUTER JOIN I_Product AS _Product ON Product = _Product.Product  -- association [0..1]
LEFT OUTER JOIN E_SalesDocumentItemBasic AS _Extension ON SDIA.SalesDocument = _Extension.SalesDocument AND SDIA.SalesDocumentItem = _Extension.SalesDocumentItem  -- association [0..1]
;