What is I_CustomerReturnItem in SAP S/4HANA?

I_CustomerReturnItem is a basic CDS view in SAP S/4HANA. Returns Order Item It contains 196 fields.

Which tables does I_CustomerReturnItem read from?

I_CustomerReturnItem reads data from: I_SalesDocumentItem.

What VDM layer is I_CustomerReturnItem?

I_CustomerReturnItem is classified as a Basic (interface) view providing a 1:1 representation of a database table.

I_CustomerReturnItem

DDL: I_CUSTOMERRETURNITEM Type: view BASIC

196 Fields 1 Data Sources 4 Associations

Returns Order Item

I_CustomerReturnItem (Basic)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

CustomerReturnItem · Sales

I_CustomerReturnItem is a Basic CDS View (Dimension) that provides data about "Returns Order Item" in SAP S/4HANA. It reads from 1 data source (I_SalesDocumentItem) and exposes 196 fields with key fields CustomerReturn, CustomerReturnItem. It has 4 associations to related views.

SAP API Hub

State	C1
Line of Business	Sales
Application Component	SD-SLS-RE
Capabilities	Analytical Dimension, Association Target for Defining CDS Entities, Data Source for Defining CDS Entities, Data Source in SQL Select, Data Source for Data Extraction
Package	Sales for SAP S/4HANA Cloud Private Edition
Description	<p>This CDS view provides the prerequisites for answering questions about all relevant aspects of returns order items.</p>

Documentation

Analytics with CDS Views — Build Analytics for S/4HANA Cloud Private Edition ABAP CDS views replicated to SAP Cloud Platform
CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA Cloud Private Edition Private Edition CDS Views on SAP Business Accelerator Hub
Create CDS View as API — Create CDS views in SAP S/4HANA Cloud Private Edition and consume them as APIs
Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
SAP Extensibility Explorer for SAP S/4HANA Cloud Private Edition — Explore SAP S/4HANA Cloud Private Edition Extensibility options by leveraging the sample scenarios from SAP
SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
VDM View Types — The Virtual Data Model in SAP S/4HANA Cloud Private Edition
View Browser — Search, browse and tag CDS Views

Data Sources (1)

Source	Alias	Join Type
I_SalesDocumentItem	SalesDocumentItem	from

Associations (4)

Cardinality	Target	Alias	Condition
[1..1]	I_CustomerReturn	_CustomerReturn	`$projection.CustomerReturn = _CustomerReturn.CustomerReturn`
[0..1]	I_RetsMgmtProcessItem	_RetsMgmtProcessItem	`$projection.RetsMgmtProcess = _RetsMgmtProcessItem.RetsMgmtProcess and $projection.CustomerReturnItem = _RetsMgmtProcessItem.RetsMgmtProcessItem`
[0..*]	I_CustomerReturnScheduleLine	_ScheduleLine	`$projection.CustomerReturn = _ScheduleLine.CustomerReturn and $projection.CustomerReturnItem = _ScheduleLine.CustomerReturnItem`
[0..1]	E_SalesDocumentItemBasic	_Extension	`SalesDocumentItem.SalesDocument = _Extension.SalesDocument and SalesDocumentItem.SalesDocumentItem = _Extension.SalesDocumentItem`

Annotations (18)

Name	Value	Level
ClientHandling.algorithm	#SESSION_VARIABLE	view
EndUserText.label	Returns Order Item	view
VDM.viewType	#BASIC	view
VDM.lifecycle.contract.type	#PUBLIC_LOCAL_API	view
AccessControl.authorizationCheck	#CHECK	view
AbapCatalog.sqlViewName	ISDCUSTRETURNITM	view
AbapCatalog.preserveKey	true	view
AbapCatalog.compiler.compareFilter	true	view
ObjectModel.representativeKey	CustomerReturnItem	view
ObjectModel.modelingPattern	#ANALYTICAL_DIMENSION	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#XL	view
Analytics.dataCategory	#DIMENSION	view
Metadata.ignorePropagatedAnnotations	true	view
Metadata.allowExtensions	true	view
ObjectModel.sapObjectNodeType.name	CustomerReturnItem	view
Analytics.dataExtraction.enabled	true	view

Fields (196)

Key	Field	Source Table	Source Field	Description
KEY	CustomerReturn			Customer Return
KEY	CustomerReturnItem			Customer Return Item
	CustomerReturnItemUUID	I_SalesDocumentItem	SalesDocumentItemUUID	GUID in 'CHAR' Format in Uppercase
	CustomerReturnItemCategory	I_SalesDocumentItem	SalesDocumentItemCategory	Sales Document Item Category
	CustomerReturnItemType	I_SalesDocumentItem	SalesDocumentItemType	Item Type
	IsReturnsItem	I_SalesDocumentItem	IsReturnsItem	Returns Item
	CreatedByUser	I_SalesDocumentItem	CreatedByUser	Name of Person Responsible for Creating the Object
	CreationDate	I_SalesDocumentItem	CreationDate	Record Created On
	CreationTime	I_SalesDocumentItem	CreationTime	Time at Which Record Was Created
	LastChangeDate	I_SalesDocumentItem	LastChangeDate	Last Changed On
	Division	I_SalesDocumentItem	Division	Internal Division ID
	Material	I_SalesDocumentItem	Material	Material Number
	_Material	I_SalesDocumentItem	_Material
	Product	I_SalesDocumentItem	Product	Product Number
	_Product	I_SalesDocumentItem	_Product
	MaterialGroup	I_SalesDocumentItem	MaterialGroup	Material Group
	_MaterialGroup	I_SalesDocumentItem	_MaterialGroup
	ProductGroup	I_SalesDocumentItem	ProductGroup	Product Sold Group
	_ProductGroup	I_SalesDocumentItem	_ProductGroup
	OriginallyRequestedMaterial	I_SalesDocumentItem	OriginallyRequestedMaterial	Material Entered
	MaterialByCustomer	I_SalesDocumentItem	MaterialByCustomer	Material Number Used by Customer
	InternationalArticleNumber	I_SalesDocumentItem	InternationalArticleNumber	International Article Number (EAN/UPC)
	Batch	I_SalesDocumentItem	Batch	Batch Number
	ProductHierarchyNode	I_SalesDocumentItem	ProductHierarchyNode	Product Hierarchy
	ProductCatalog	I_SalesDocumentItem	ProductCatalog	Product Catalog Number
	AdditionalMaterialGroup1	I_SalesDocumentItem	AdditionalMaterialGroup1	Material Group 1
	AdditionalMaterialGroup2	I_SalesDocumentItem	AdditionalMaterialGroup2	Material Group 2
	AdditionalMaterialGroup3	I_SalesDocumentItem	AdditionalMaterialGroup3	Material Group 3
	AdditionalMaterialGroup4	I_SalesDocumentItem	AdditionalMaterialGroup4	Material Group 4
	AdditionalMaterialGroup5	I_SalesDocumentItem	AdditionalMaterialGroup5	Material Group 5
	Plant	I_SalesDocumentItem	Plant	Plant (Own or External)
	StorageLocation	I_SalesDocumentItem	StorageLocation	Storage Location
	ProductConfiguration	I_SalesDocumentItem	ProductConfiguration	Object Number
	BillOfMaterial	I_SalesDocumentItem	BillOfMaterial	Bill of Material
	BOMExplosionDate	I_SalesDocumentItem	BOMExplosionDate	Key Date of the Bill of Material
	CustomerReturnItemText	I_SalesDocumentItem	SalesDocumentItemText	Short text for sales order item
	PurchaseOrderByCustomer	I_SalesDocumentItem	PurchaseOrderByCustomer	Purchase Order Number
	OrderQuantity	I_SalesDocumentItem	OrderQuantity	Cumulative order quantity in sales units
	ConfdDelivQtyInOrderQtyUnit	I_SalesDocumentItem	ConfdDelivQtyInOrderQtyUnit	Cumulative Confirmed Quantity in Sales Unit
	TargetDelivQtyInOrderQtyUnit	I_SalesDocumentItem	TargetDelivQtyInOrderQtyUnit	Cumulative Required Delivery Qty (All Dlv-Relev.Sched.Lines)
	OrderQuantityUnit	I_SalesDocumentItem	OrderQuantityUnit	Sales Unit
	ConfdDeliveryQtyInBaseUnit	I_SalesDocumentItem	ConfdDeliveryQtyInBaseUnit	Cumulative Confirmed Quantity in Base Unit
	BaseUnit	I_SalesDocumentItem	BaseUnit	Base Unit of Measure
	OrderToBaseQuantityDnmntr	I_SalesDocumentItem	OrderToBaseQuantityDnmntr	Denominator (divisor) for conversion of sales Qty into SKU
	OrderToBaseQuantityNmrtr	I_SalesDocumentItem	OrderToBaseQuantityNmrtr	Numerator (factor) for conversion of sales quantity into SKU
	RequestedQuantity	I_SalesDocumentItem	RequestedQuantity	Requested Quantity
	RequestedQuantityUnit	I_SalesDocumentItem	RequestedQuantityUnit	Unit of the Requested Quantity
	RequestedQuantityInBaseUnit	I_SalesDocumentItem	RequestedQuantityInBaseUnit	Requested Order Quantity in Base Unit
	ItemGrossWeight	I_SalesDocumentItem	ItemGrossWeight	Gross Weight of the Item
	ItemNetWeight	I_SalesDocumentItem	ItemNetWeight	Net Weight of the Item
	ItemWeightUnit	I_SalesDocumentItem	ItemWeightUnit	Unit of Weight
	ItemVolume	I_SalesDocumentItem	ItemVolume	Volume of the item
	ItemVolumeUnit	I_SalesDocumentItem	ItemVolumeUnit	Volume Unit
	ServicesRenderedDate	I_SalesDocumentItem	ServicesRenderedDate	Date on which services are rendered
	SalesDistrict	I_SalesDocumentItem	SalesDistrict	Sales District
	SalesDeal	I_SalesDocumentItem	SalesDeal	Sales Deal
	CustomerGroup	I_SalesDocumentItem	CustomerGroup	Customer Group
	SalesDocumentRjcnReason	I_SalesDocumentItem	SalesDocumentRjcnReason	Reason for Rejection of Sales Documents
	ReturnReason	I_SalesDocumentItem	ReturnReason	Return Reason
	ReturnsRefundExtent	I_SalesDocumentItem	ReturnsRefundExtent	Returns Refund Code
	RetsMgmtProcessingBlock	I_SalesDocumentItem	RetsMgmtProcessingBlock	Approval Block
	NetAmount	I_SalesDocumentItem	NetAmount	Net Value of the Document Item in Document Currency
	PricingDate	I_SalesDocumentItem	PricingDate	Date for Pricing and Exchange Rate
	TransactionCurrency	I_SalesDocumentItem	TransactionCurrency	Transaction Currency
	ExchangeRateDate	I_SalesDocumentItem	ExchangeRateDate	Translation Date
	PriceDetnExchangeRate	I_SalesDocumentItem	PriceDetnExchangeRate	Exchange Rate for Price Determination
	NetPriceAmount	I_SalesDocumentItem	NetPriceAmount	Net Price
	NetPriceQuantity	I_SalesDocumentItem	NetPriceQuantity	Condition Pricing Unit
	NetPriceQuantityUnit	I_SalesDocumentItem	NetPriceQuantityUnit	SettlmtPrcUnit
	StatisticalValueControl	I_SalesDocumentItem	StatisticalValueControl	Statistical Values
	_StatisticalValueControl	I_SalesDocumentItem	_StatisticalValueControl
	TaxAmount	I_SalesDocumentItem	TaxAmount	Tax Amount in Document Currency
	CostAmount	I_SalesDocumentItem	CostAmount	Cost in Document Currency
	Subtotal1Amount	I_SalesDocumentItem	Subtotal1Amount	Subtotal 1 from Pricing Procedure for Price Element
	Subtotal2Amount	I_SalesDocumentItem	Subtotal2Amount	Subtotal 2 from Pricing Procedure for Price Element
	Subtotal3Amount	I_SalesDocumentItem	Subtotal3Amount	Subtotal 3 from Pricing Procedure for Price Element
	Subtotal4Amount	I_SalesDocumentItem	Subtotal4Amount	Subtotal 4 from Pricing Procedure for Price Element
	Subtotal5Amount	I_SalesDocumentItem	Subtotal5Amount	Subtotal 5 from Pricing Procedure for Price Element
	Subtotal6Amount	I_SalesDocumentItem	Subtotal6Amount	Subtotal 6 from Pricing Procedure for Price Element
	ShippingPoint	I_SalesDocumentItem	ShippingPoint	Shipping Point / Receiving Point
	ShippingType	I_SalesDocumentItem	ShippingType	Shipping Type
	InventorySpecialStockType	I_SalesDocumentItem	InventorySpecialStockType	Special Stock Indicator
	DeliveryPriority	I_SalesDocumentItem	DeliveryPriority	Delivery Priority
	Route	I_SalesDocumentItem	Route	Vehicle route
	DeliveryDateQuantityIsFixed	I_SalesDocumentItem	DeliveryDateQuantityIsFixed	Delivery Date and Quantity Fixed
	PartialDeliveryIsAllowed	I_SalesDocumentItem	PartialDeliveryIsAllowed	Partial Delivery at Item Level
	MaxNmbrOfPartialDelivery	I_SalesDocumentItem	MaxNmbrOfPartialDelivery	Number of Allowed Partial Deliveries
	UnlimitedOverdeliveryIsAllowed	I_SalesDocumentItem	UnlimitedOverdeliveryIsAllowed	Unlimited Overdelivery Allowed
	OverdelivTolrtdLmtRatioInPct	I_SalesDocumentItem	OverdelivTolrtdLmtRatioInPct	Overdelivery Tolerance
	UnderdelivTolrtdLmtRatioInPct	I_SalesDocumentItem	UnderdelivTolrtdLmtRatioInPct	Underdelivery Tolerance
	MinDeliveryQtyInBaseUnit	I_SalesDocumentItem	MinDeliveryQtyInBaseUnit	Minimum Delivery Quantity in Delivery Note Processing
	IncotermsClassification	I_SalesDocumentItem	IncotermsClassification	Incoterms (Part 1)
	IncotermsTransferLocation	I_SalesDocumentItem	IncotermsTransferLocation	Incoterms (Part 2)
	IncotermsLocation1	I_SalesDocumentItem	IncotermsLocation1	Incoterms Location 1
	IncotermsLocation2	I_SalesDocumentItem	IncotermsLocation2	Incoterms Location 2
	IncotermsVersion	I_SalesDocumentItem	IncotermsVersion	Incoterms Version
	ItemIsDeliveryRelevant	I_SalesDocumentItem	ItemIsDeliveryRelevant	Item Is Relevant for Delivery
	BillingDocumentDate	I_SalesDocumentItem	BillingDocumentDate	Billing Date
	ItemIsBillingRelevant	I_SalesDocumentItem	ItemIsBillingRelevant	Relevant for Billing
	ItemBillingBlockReason	I_SalesDocumentItem	ItemBillingBlockReason	Billing Block for Item
	MatlAccountAssignmentGroup		MatlAccountAssignmentGroup	Account Assignment Group for Material
	CustomerPaymentTerms	I_SalesDocumentItem	CustomerPaymentTerms	Terms of Payment Key
	PaymentMethod	I_SalesDocumentItem	PaymentMethod	Payment Method
	ProductTaxClassification1	I_SalesDocumentItem	ProductTaxClassification1	Tax Classification for Material
	ProductTaxClassification2	I_SalesDocumentItem	ProductTaxClassification2	Tax Classification for Material
	ProductTaxClassification3	I_SalesDocumentItem	ProductTaxClassification3	Tax Classification for Material
	ProductTaxClassification4	I_SalesDocumentItem	ProductTaxClassification4	Tax Classification for Material
	ProductTaxClassification5	I_SalesDocumentItem	ProductTaxClassification5	Tax Classification for Material
	ProductTaxClassification6	I_SalesDocumentItem	ProductTaxClassification6	Tax Classification for Material
	ProductTaxClassification7	I_SalesDocumentItem	ProductTaxClassification7	Tax Classification for Material
	ProductTaxClassification8	I_SalesDocumentItem	ProductTaxClassification8	Tax Classification for Material
	ProductTaxClassification9	I_SalesDocumentItem	ProductTaxClassification9	Tax Classification for Material
	FiscalYear	I_SalesDocumentItem	FiscalYear	G/L Fiscal Year
	FiscalPeriod	I_SalesDocumentItem	FiscalPeriod	Posting Period
	CustomerAccountAssignmentGroup	I_SalesDocumentItem	CustomerAccountAssignmentGroup	Account Assignment Group for Customer
	BusinessArea	I_SalesDocumentItem	BusinessArea	Business Area
	ProfitCenter	I_SalesDocumentItem	ProfitCenter	Profit Center
	WBSElementInternalID	I_SalesDocumentItem	WBSElementInternalID	WBS Internal ID
	OrderID	I_SalesDocumentItem	OrderID	Order Number
	ControllingObject	I_SalesDocumentItem	ControllingObject	Object Number at Item Level
	ProfitabilitySegment	I_SalesDocumentItem	ProfitabilitySegment	Deprecated: Profitability Segment
	ProfitabilitySegment_2	I_SalesDocumentItem	ProfitabilitySegment_2	Profitability Segment
	OriginSDDocument	I_SalesDocumentItem	OriginSDDocument	Originating Document
	OriginSDDocumentItem	I_SalesDocumentItem	OriginSDDocumentItem	Originating Item
	ReferenceSDDocument	I_SalesDocumentItem	ReferenceSDDocument	Document Number of Reference Document
	ReferenceSDDocumentItem	I_SalesDocumentItem	ReferenceSDDocumentItem	Item number of the reference item
	ReferenceSDDocumentCategory	I_SalesDocumentItem	ReferenceSDDocumentCategory	Reference Document Category
	HigherLevelItem	I_SalesDocumentItem	HigherLevelItem	Higher-Level Item in Bill of Material Structures
	RetsMgmtProcess	SalesDocumentBasic	RetsMgmtProcess	Process Identification Number
	SDProcessStatus	I_SalesDocumentItem	SDProcessStatus	Overall Processing Status (Item)
	TotalDeliveryStatus	I_SalesDocumentItem	TotalDeliveryStatus	Overall Delivery Status (Item)
	DeliveryStatus	I_SalesDocumentItem	DeliveryStatus	Delivery Status (Item)
	DeliveryBlockStatus	I_SalesDocumentItem	DeliveryBlockStatus	Delivery Block Status (Item)
	OrderRelatedBillingStatus	I_SalesDocumentItem	OrderRelatedBillingStatus	Order-Related Billing Status (Item)
	BillingBlockStatus	I_SalesDocumentItem	BillingBlockStatus	Billing Block Status (Item)
	ItemGeneralIncompletionStatus	I_SalesDocumentItem	ItemGeneralIncompletionStatus	Incompletion Status (Item)
	ItemBillingIncompletionStatus	I_SalesDocumentItem	ItemBillingIncompletionStatus	Billing Incompletion Status (Item)
	PricingIncompletionStatus	I_SalesDocumentItem	PricingIncompletionStatus	Pricing Incompletion Status (Item)
	ItemDeliveryIncompletionStatus	I_SalesDocumentItem	ItemDeliveryIncompletionStatus	Delivery Incompletion Status (Item)
	SDDocumentRejectionStatus	I_SalesDocumentItem	SDDocumentRejectionStatus	Rejection Status (Item)
	TotalSDDocReferenceStatus	I_SalesDocumentItem	TotalSDDocReferenceStatus	Overall Reference Status (Item)
	_CustomerReturn		_CustomerReturn
	_ScheduleLine		_ScheduleLine
	_Partner	I_SalesDocumentItem	_Partner
	_ItemCategory	I_SalesDocumentItem	_ItemCategory
	_CreatedByUser	I_SalesDocumentItem	_CreatedByUser
	_Division	I_SalesDocumentItem	_Division
	_OriginallyRequestedMaterial	I_SalesDocumentItem	_OriginallyRequestedMaterial
	_ProductHierarchyNode	I_SalesDocumentItem	_ProductHierarchyNode
	_AdditionalMaterialGroup1	I_SalesDocumentItem	_AdditionalMaterialGroup1
	_AdditionalMaterialGroup2	I_SalesDocumentItem	_AdditionalMaterialGroup2
	_AdditionalMaterialGroup3	I_SalesDocumentItem	_AdditionalMaterialGroup3
	_AdditionalMaterialGroup4	I_SalesDocumentItem	_AdditionalMaterialGroup4
	_AdditionalMaterialGroup5	I_SalesDocumentItem	_AdditionalMaterialGroup5
	_Plant	I_SalesDocumentItem	_Plant
	_StorageLocation	I_SalesDocumentItem	_StorageLocation
	_OrderQuantityUnit	I_SalesDocumentItem	_OrderQuantityUnit
	_BaseUnit	I_SalesDocumentItem	_BaseUnit
	_RequestedQuantityUnit	I_SalesDocumentItem	_RequestedQuantityUnit
	_ItemWeightUnit	I_SalesDocumentItem	_ItemWeightUnit
	_ItemVolumeUnit	I_SalesDocumentItem	_ItemVolumeUnit
	_SalesDistrict	I_SalesDocumentItem	_SalesDistrict
	_SalesDeal	I_SalesDocumentItem	_SalesDeal
	_CustomerGroup	I_SalesDocumentItem	_CustomerGroup
	_SalesDocumentRjcnReason	I_SalesDocumentItem	_SalesDocumentRjcnReason
	_ReturnReason	I_SalesDocumentItem	_ReturnReason
	_ReturnsRefundExtent	I_SalesDocumentItem	_ReturnsRefundExtent
	_NetPriceQuantityUnit	I_SalesDocumentItem	_NetPriceQuantityUnit
	_TransactionCurrency	I_SalesDocumentItem	_TransactionCurrency
	_ShippingPoint	I_SalesDocumentItem	_ShippingPoint
	_ShippingType	I_SalesDocumentItem	_ShippingType
	_DeliveryPriority	I_SalesDocumentItem	_DeliveryPriority
	_IncotermsClassification	I_SalesDocumentItem	_IncotermsClassification
	_IncotermsVersion	I_SalesDocumentItem	_IncotermsVersion
	_ItemBillingBlockReason	I_SalesDocumentItem	_ItemBillingBlockReason
	_ItemIsBillingRelevant	I_SalesDocumentItem	_ItemIsBillingRelevant
	_CustomerPaymentTerms	I_SalesDocumentItem	_CustomerPaymentTerms
	_CustomerAccountAssgmtGroup	I_SalesDocumentItem	_CustomerAccountAssgmtGroup
	_BusinessArea	I_SalesDocumentItem	_BusinessArea
	_WBSElementBasicData_2	I_SalesDocumentItem	_WBSElementBasicData_2
	_ReferenceSDDocument	I_SalesDocumentItem	_ReferenceSDDocument
	_ReferenceSDDocumentItem	I_SalesDocumentItem	_ReferenceSDDocumentItem
	_ReferenceSDDocumentCategory	I_SalesDocumentItem	_ReferenceSDDocumentCategory
	_RetsMgmtProcessItem		_RetsMgmtProcessItem
	_SDProcessStatus	I_SalesDocumentItem	_SDProcessStatus
	_TotalDeliveryStatus	I_SalesDocumentItem	_TotalDeliveryStatus
	_DeliveryStatus	I_SalesDocumentItem	_DeliveryStatus
	_DeliveryBlockStatus	I_SalesDocumentItem	_DeliveryBlockStatus
	_OrderRelatedBillingStatus	I_SalesDocumentItem	_OrderRelatedBillingStatus
	_BillingBlockStatus	I_SalesDocumentItem	_BillingBlockStatus
	_ItemGeneralIncompletionStatus	I_SalesDocumentItem	_ItemGeneralIncompletionStatus
	_ItemBillingIncompletionStatus	I_SalesDocumentItem	_ItemBillingIncompletionStatus
	_PricingIncompletionStatus	I_SalesDocumentItem	_PricingIncompletionStatus
	_ItemDelivIncompletionSts	I_SalesDocumentItem	_ItemDelivIncompletionSts
	_SDDocumentRejectionStatus	I_SalesDocumentItem	_SDDocumentRejectionStatus
	_TotalSDDocReferenceStatus	I_SalesDocumentItem	_TotalSDDocReferenceStatus

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_CustomerReturnItem.
-- 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_CustomerReturnItem AS
SELECT
  cast(SalesDocumentItem.SalesDocument as vdm_customer_return preserving type) AS CustomerReturn,
  cast(SalesDocumentItem.SalesDocumentItem as vdm_customer_return_item preserving type) AS CustomerReturnItem,
  SalesDocumentItem.SalesDocumentItemUUID AS CustomerReturnItemUUID,
  SalesDocumentItem.SalesDocumentItemCategory AS CustomerReturnItemCategory,
  SalesDocumentItem.SalesDocumentItemType AS CustomerReturnItemType,
  SalesDocumentItem.IsReturnsItem AS IsReturnsItem,
  SalesDocumentItem.CreatedByUser AS CreatedByUser,
  SalesDocumentItem.CreationDate AS CreationDate,
  SalesDocumentItem.CreationTime AS CreationTime,
  SalesDocumentItem.LastChangeDate AS LastChangeDate,
  SalesDocumentItem.Division AS Division,
  SalesDocumentItem.Material AS Material,
  SalesDocumentItem._Material AS _Material,
  SalesDocumentItem.Product AS Product,
  SalesDocumentItem._Product AS _Product,
  SalesDocumentItem.MaterialGroup AS MaterialGroup,
  SalesDocumentItem._MaterialGroup AS _MaterialGroup,
  SalesDocumentItem.ProductGroup AS ProductGroup,
  SalesDocumentItem._ProductGroup AS _ProductGroup,
  SalesDocumentItem.OriginallyRequestedMaterial AS OriginallyRequestedMaterial,
  SalesDocumentItem.MaterialByCustomer AS MaterialByCustomer,
  SalesDocumentItem.InternationalArticleNumber AS InternationalArticleNumber,
  SalesDocumentItem.Batch AS Batch,
  SalesDocumentItem.ProductHierarchyNode AS ProductHierarchyNode,
  SalesDocumentItem.ProductCatalog AS ProductCatalog,
  SalesDocumentItem.AdditionalMaterialGroup1 AS AdditionalMaterialGroup1,
  SalesDocumentItem.AdditionalMaterialGroup2 AS AdditionalMaterialGroup2,
  SalesDocumentItem.AdditionalMaterialGroup3 AS AdditionalMaterialGroup3,
  SalesDocumentItem.AdditionalMaterialGroup4 AS AdditionalMaterialGroup4,
  SalesDocumentItem.AdditionalMaterialGroup5 AS AdditionalMaterialGroup5,
  SalesDocumentItem.Plant AS Plant,
  SalesDocumentItem.StorageLocation AS StorageLocation,
  SalesDocumentItem.ProductConfiguration AS ProductConfiguration,
  SalesDocumentItem.BillOfMaterial AS BillOfMaterial,
  SalesDocumentItem.BOMExplosionDate AS BOMExplosionDate,
  SalesDocumentItem.SalesDocumentItemText AS CustomerReturnItemText,
  SalesDocumentItem.PurchaseOrderByCustomer AS PurchaseOrderByCustomer,
  SalesDocumentItem.OrderQuantity AS OrderQuantity,
  SalesDocumentItem.ConfdDelivQtyInOrderQtyUnit AS ConfdDelivQtyInOrderQtyUnit,
  SalesDocumentItem.TargetDelivQtyInOrderQtyUnit AS TargetDelivQtyInOrderQtyUnit,
  SalesDocumentItem.OrderQuantityUnit AS OrderQuantityUnit,
  SalesDocumentItem.ConfdDeliveryQtyInBaseUnit AS ConfdDeliveryQtyInBaseUnit,
  SalesDocumentItem.BaseUnit AS BaseUnit,
  SalesDocumentItem.OrderToBaseQuantityDnmntr AS OrderToBaseQuantityDnmntr,
  SalesDocumentItem.OrderToBaseQuantityNmrtr AS OrderToBaseQuantityNmrtr,
  SalesDocumentItem.RequestedQuantity AS RequestedQuantity,
  SalesDocumentItem.RequestedQuantityUnit AS RequestedQuantityUnit,
  SalesDocumentItem.RequestedQuantityInBaseUnit AS RequestedQuantityInBaseUnit,
  SalesDocumentItem.ItemGrossWeight AS ItemGrossWeight,
  SalesDocumentItem.ItemNetWeight AS ItemNetWeight,
  SalesDocumentItem.ItemWeightUnit AS ItemWeightUnit,
  SalesDocumentItem.ItemVolume AS ItemVolume,
  SalesDocumentItem.ItemVolumeUnit AS ItemVolumeUnit,
  SalesDocumentItem.ServicesRenderedDate AS ServicesRenderedDate,
  SalesDocumentItem.SalesDistrict AS SalesDistrict,
  SalesDocumentItem.SalesDeal AS SalesDeal,
  SalesDocumentItem.CustomerGroup AS CustomerGroup,
  SalesDocumentItem.SalesDocumentRjcnReason AS SalesDocumentRjcnReason,
  SalesDocumentItem.ReturnReason AS ReturnReason,
  SalesDocumentItem.ReturnsRefundExtent AS ReturnsRefundExtent,
  SalesDocumentItem.RetsMgmtProcessingBlock AS RetsMgmtProcessingBlock,
  SalesDocumentItem.NetAmount AS NetAmount,
  SalesDocumentItem.PricingDate AS PricingDate,
  SalesDocumentItem.TransactionCurrency AS TransactionCurrency,
  SalesDocumentItem.ExchangeRateDate AS ExchangeRateDate,
  SalesDocumentItem.PriceDetnExchangeRate AS PriceDetnExchangeRate,
  SalesDocumentItem.NetPriceAmount AS NetPriceAmount,
  SalesDocumentItem.NetPriceQuantity AS NetPriceQuantity,
  SalesDocumentItem.NetPriceQuantityUnit AS NetPriceQuantityUnit,
  SalesDocumentItem.StatisticalValueControl AS StatisticalValueControl,
  SalesDocumentItem._StatisticalValueControl AS _StatisticalValueControl,
  SalesDocumentItem.TaxAmount AS TaxAmount,
  SalesDocumentItem.CostAmount AS CostAmount,
  SalesDocumentItem.Subtotal1Amount AS Subtotal1Amount,
  SalesDocumentItem.Subtotal2Amount AS Subtotal2Amount,
  SalesDocumentItem.Subtotal3Amount AS Subtotal3Amount,
  SalesDocumentItem.Subtotal4Amount AS Subtotal4Amount,
  SalesDocumentItem.Subtotal5Amount AS Subtotal5Amount,
  SalesDocumentItem.Subtotal6Amount AS Subtotal6Amount,
  SalesDocumentItem.ShippingPoint AS ShippingPoint,
  SalesDocumentItem.ShippingType AS ShippingType,
  SalesDocumentItem.InventorySpecialStockType AS InventorySpecialStockType,
  SalesDocumentItem.DeliveryPriority AS DeliveryPriority,
  SalesDocumentItem.Route AS Route,
  SalesDocumentItem.DeliveryDateQuantityIsFixed AS DeliveryDateQuantityIsFixed,
  SalesDocumentItem.PartialDeliveryIsAllowed AS PartialDeliveryIsAllowed,
  SalesDocumentItem.MaxNmbrOfPartialDelivery AS MaxNmbrOfPartialDelivery,
  SalesDocumentItem.UnlimitedOverdeliveryIsAllowed AS UnlimitedOverdeliveryIsAllowed,
  SalesDocumentItem.OverdelivTolrtdLmtRatioInPct AS OverdelivTolrtdLmtRatioInPct,
  SalesDocumentItem.UnderdelivTolrtdLmtRatioInPct AS UnderdelivTolrtdLmtRatioInPct,
  SalesDocumentItem.MinDeliveryQtyInBaseUnit AS MinDeliveryQtyInBaseUnit,
  SalesDocumentItem.IncotermsClassification AS IncotermsClassification,
  SalesDocumentItem.IncotermsTransferLocation AS IncotermsTransferLocation,
  SalesDocumentItem.IncotermsLocation1 AS IncotermsLocation1,
  SalesDocumentItem.IncotermsLocation2 AS IncotermsLocation2,
  SalesDocumentItem.IncotermsVersion AS IncotermsVersion,
  SalesDocumentItem.ItemIsDeliveryRelevant AS ItemIsDeliveryRelevant,
  SalesDocumentItem.BillingDocumentDate AS BillingDocumentDate,
  SalesDocumentItem.ItemIsBillingRelevant AS ItemIsBillingRelevant,
  SalesDocumentItem.ItemBillingBlockReason AS ItemBillingBlockReason,
  MatlAccountAssignmentGroup,
  SalesDocumentItem.CustomerPaymentTerms AS CustomerPaymentTerms,
  SalesDocumentItem.PaymentMethod AS PaymentMethod,
  SalesDocumentItem.ProductTaxClassification1 AS ProductTaxClassification1,
  SalesDocumentItem.ProductTaxClassification2 AS ProductTaxClassification2,
  SalesDocumentItem.ProductTaxClassification3 AS ProductTaxClassification3,
  SalesDocumentItem.ProductTaxClassification4 AS ProductTaxClassification4,
  SalesDocumentItem.ProductTaxClassification5 AS ProductTaxClassification5,
  SalesDocumentItem.ProductTaxClassification6 AS ProductTaxClassification6,
  SalesDocumentItem.ProductTaxClassification7 AS ProductTaxClassification7,
  SalesDocumentItem.ProductTaxClassification8 AS ProductTaxClassification8,
  SalesDocumentItem.ProductTaxClassification9 AS ProductTaxClassification9,
  SalesDocumentItem.FiscalYear AS FiscalYear,
  SalesDocumentItem.FiscalPeriod AS FiscalPeriod,
  SalesDocumentItem.CustomerAccountAssignmentGroup AS CustomerAccountAssignmentGroup,
  SalesDocumentItem.BusinessArea AS BusinessArea,
  SalesDocumentItem.ProfitCenter AS ProfitCenter,
  SalesDocumentItem.WBSElementInternalID AS WBSElementInternalID,
  SalesDocumentItem.OrderID AS OrderID,
  SalesDocumentItem.ControllingObject AS ControllingObject,
  SalesDocumentItem.ProfitabilitySegment AS ProfitabilitySegment,
  SalesDocumentItem.ProfitabilitySegment_2 AS ProfitabilitySegment_2,
  SalesDocumentItem.OriginSDDocument AS OriginSDDocument,
  SalesDocumentItem.OriginSDDocumentItem AS OriginSDDocumentItem,
  SalesDocumentItem.ReferenceSDDocument AS ReferenceSDDocument,
  SalesDocumentItem.ReferenceSDDocumentItem AS ReferenceSDDocumentItem,
  SalesDocumentItem.ReferenceSDDocumentCategory AS ReferenceSDDocumentCategory,
  SalesDocumentItem.HigherLevelItem AS HigherLevelItem,
  SalesDocumentBasic.RetsMgmtProcess AS RetsMgmtProcess,
  SalesDocumentItem.SDProcessStatus AS SDProcessStatus,
  SalesDocumentItem.TotalDeliveryStatus AS TotalDeliveryStatus,
  SalesDocumentItem.DeliveryStatus AS DeliveryStatus,
  SalesDocumentItem.DeliveryBlockStatus AS DeliveryBlockStatus,
  SalesDocumentItem.OrderRelatedBillingStatus AS OrderRelatedBillingStatus,
  SalesDocumentItem.BillingBlockStatus AS BillingBlockStatus,
  SalesDocumentItem.ItemGeneralIncompletionStatus AS ItemGeneralIncompletionStatus,
  SalesDocumentItem.ItemBillingIncompletionStatus AS ItemBillingIncompletionStatus,
  SalesDocumentItem.PricingIncompletionStatus AS PricingIncompletionStatus,
  SalesDocumentItem.ItemDeliveryIncompletionStatus AS ItemDeliveryIncompletionStatus,
  SalesDocumentItem.SDDocumentRejectionStatus AS SDDocumentRejectionStatus,
  SalesDocumentItem.TotalSDDocReferenceStatus AS TotalSDDocReferenceStatus,
  SalesDocumentItem._Partner AS _Partner,
  SalesDocumentItem._ItemCategory AS _ItemCategory,
  SalesDocumentItem._CreatedByUser AS _CreatedByUser,
  SalesDocumentItem._Division AS _Division,
  SalesDocumentItem._OriginallyRequestedMaterial AS _OriginallyRequestedMaterial,
  SalesDocumentItem._ProductHierarchyNode AS _ProductHierarchyNode,
  SalesDocumentItem._AdditionalMaterialGroup1 AS _AdditionalMaterialGroup1,
  SalesDocumentItem._AdditionalMaterialGroup2 AS _AdditionalMaterialGroup2,
  SalesDocumentItem._AdditionalMaterialGroup3 AS _AdditionalMaterialGroup3,
  SalesDocumentItem._AdditionalMaterialGroup4 AS _AdditionalMaterialGroup4,
  SalesDocumentItem._AdditionalMaterialGroup5 AS _AdditionalMaterialGroup5,
  SalesDocumentItem._Plant AS _Plant,
  SalesDocumentItem._StorageLocation AS _StorageLocation,
  SalesDocumentItem._OrderQuantityUnit AS _OrderQuantityUnit,
  SalesDocumentItem._BaseUnit AS _BaseUnit,
  SalesDocumentItem._RequestedQuantityUnit AS _RequestedQuantityUnit,
  SalesDocumentItem._ItemWeightUnit AS _ItemWeightUnit,
  SalesDocumentItem._ItemVolumeUnit AS _ItemVolumeUnit,
  SalesDocumentItem._SalesDistrict AS _SalesDistrict,
  SalesDocumentItem._SalesDeal AS _SalesDeal,
  SalesDocumentItem._CustomerGroup AS _CustomerGroup,
  SalesDocumentItem._SalesDocumentRjcnReason AS _SalesDocumentRjcnReason,
  SalesDocumentItem._ReturnReason AS _ReturnReason,
  SalesDocumentItem._ReturnsRefundExtent AS _ReturnsRefundExtent,
  SalesDocumentItem._NetPriceQuantityUnit AS _NetPriceQuantityUnit,
  SalesDocumentItem._TransactionCurrency AS _TransactionCurrency,
  SalesDocumentItem._ShippingPoint AS _ShippingPoint,
  SalesDocumentItem._ShippingType AS _ShippingType,
  SalesDocumentItem._DeliveryPriority AS _DeliveryPriority,
  SalesDocumentItem._IncotermsClassification AS _IncotermsClassification,
  SalesDocumentItem._IncotermsVersion AS _IncotermsVersion,
  SalesDocumentItem._ItemBillingBlockReason AS _ItemBillingBlockReason,
  SalesDocumentItem._ItemIsBillingRelevant AS _ItemIsBillingRelevant,
  SalesDocumentItem._CustomerPaymentTerms AS _CustomerPaymentTerms,
  SalesDocumentItem._CustomerAccountAssgmtGroup AS _CustomerAccountAssgmtGroup,
  SalesDocumentItem._BusinessArea AS _BusinessArea,
  SalesDocumentItem._WBSElementBasicData_2 AS _WBSElementBasicData_2,
  SalesDocumentItem._ReferenceSDDocument AS _ReferenceSDDocument,
  SalesDocumentItem._ReferenceSDDocumentItem AS _ReferenceSDDocumentItem,
  SalesDocumentItem._ReferenceSDDocumentCategory AS _ReferenceSDDocumentCategory,
  SalesDocumentItem._SDProcessStatus AS _SDProcessStatus,
  SalesDocumentItem._TotalDeliveryStatus AS _TotalDeliveryStatus,
  SalesDocumentItem._DeliveryStatus AS _DeliveryStatus,
  SalesDocumentItem._DeliveryBlockStatus AS _DeliveryBlockStatus,
  SalesDocumentItem._OrderRelatedBillingStatus AS _OrderRelatedBillingStatus,
  SalesDocumentItem._BillingBlockStatus AS _BillingBlockStatus,
  SalesDocumentItem._ItemGeneralIncompletionStatus AS _ItemGeneralIncompletionStatus,
  SalesDocumentItem._ItemBillingIncompletionStatus AS _ItemBillingIncompletionStatus,
  SalesDocumentItem._PricingIncompletionStatus AS _PricingIncompletionStatus,
  SalesDocumentItem._ItemDelivIncompletionSts AS _ItemDelivIncompletionSts,
  SalesDocumentItem._SDDocumentRejectionStatus AS _SDDocumentRejectionStatus,
  SalesDocumentItem._TotalSDDocReferenceStatus AS _TotalSDDocReferenceStatus
FROM I_SalesDocumentItem AS SalesDocumentItem
LEFT OUTER JOIN I_CustomerReturn AS _CustomerReturn ON CustomerReturn = _CustomerReturn.CustomerReturn  -- association [1..1]
LEFT OUTER JOIN I_RetsMgmtProcessItem AS _RetsMgmtProcessItem ON RetsMgmtProcess = _RetsMgmtProcessItem.RetsMgmtProcess AND CustomerReturnItem = _RetsMgmtProcessItem.RetsMgmtProcessItem  -- association [0..1]
LEFT OUTER JOIN I_CustomerReturnScheduleLine AS _ScheduleLine ON CustomerReturn = _ScheduleLine.CustomerReturn AND CustomerReturnItem = _ScheduleLine.CustomerReturnItem  -- association [0..*]
LEFT OUTER JOIN E_SalesDocumentItemBasic AS _Extension ON SalesDocumentItem.SalesDocument = _Extension.SalesDocument AND SalesDocumentItem.SalesDocumentItem = _Extension.SalesDocumentItem  -- association [0..1]
;

Depth:

I_CustomerReturnItem view

I_SalesDocumentItem view