What is I_CustomerReturnRateAnalytics in SAP S/4HANA?

I_CustomerReturnRateAnalytics is a composite CDS view in SAP S/4HANA. Customer Return Rate Analytics It contains 113 fields.

Which tables does I_CustomerReturnRateAnalytics read from?

I_CustomerReturnRateAnalytics reads data from: I_SalesDocumentItem.

What VDM layer is I_CustomerReturnRateAnalytics?

I_CustomerReturnRateAnalytics is classified as a Composite view that combines data from multiple basic views.

I_CustomerReturnRateAnalytics

DDL: I_CUSTOMERRETURNRATEANALYTICS SQL: ISDCUSTRETRATEA Type: view COMPOSITE

113 Fields 1 Data Sources 4 Associations

Customer Return Rate Analytics

I_CustomerReturnRateAnalytics is a Composite CDS View that provides data about "Customer Return Rate Analytics" in SAP S/4HANA. It reads from 1 data source (I_SalesDocumentItem) and exposes 113 fields with key fields SalesDocument, SalesDocumentItem. It has 4 associations to related views.

Data Sources (1)

Source	Alias	Join Type
I_SalesDocumentItem	SDI	from

Associations (4)

Cardinality	Target	Alias	Condition
[0..1]	I_Product	_Product	`$projection.Product = _Product.Product`
[0..1]	I_ProductGroup_2	_ProductGroup	`$projection.ProductGroup = _ProductGroup.ProductGroup`
[0..1]	I_CostCenter	_CostCenter	`$projection.costcenter = _CostCenter.CostCenter and $projection.ControllingArea = _CostCenter.ControllingArea and _CostCenter.ValidityEndDate >= $projection.salesdocumentdate and _CostCenter.ValidityStartDate <= $projection.salesdocumentdate`
[0..1]	I_SalesDocumentItem	RSDI	`$projection.SDDocumentCategory = 'H' and $projection.ReferenceSDDocumentCategory = 'C' and $projection.ReferenceSDDocument = RSDI.SalesDocument and $projection.ReferenceSDDocumentItem = RSDI.SalesDocumentItem`

Annotations (12)

Name	Value	Level
ClientHandling.algorithm	#SESSION_VARIABLE	view
AbapCatalog.sqlViewName	ISDCUSTRETRATEA	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
AccessControl.authorizationCheck	#CHECK	view
EndUserText.label	Customer Return Rate Analytics	view
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.usageType.serviceQuality	#D	view
ObjectModel.usageType.sizeCategory	#XL	view
VDM.viewType	#COMPOSITE	view
VDM.lifecycle.contract.type	#SAP_INTERNAL_API	view
Metadata.ignorePropagatedAnnotations	true	view

Fields (113)

Key	Field	Source Table	Source Field	Description
KEY	SalesDocument	I_SalesDocumentItem	SalesDocument	SD Document
KEY	SalesDocumentItem	I_SalesDocumentItem	SalesDocumentItem	Sales Document Item
	_SalesDocument	I_SalesDocumentItem	_SalesDocument
	SDDocumentCategory	I_SalesDocumentItem	SDDocumentCategory	Document Cat.
	_SDDocumentCategory	I_SalesDocumentItem	_SDDocumentCategory
	SalesDocumentType	I_SalesDocumentItem	SalesDocumentType	Sales Doc. Type
	_SalesDocumentType	I_SalesDocumentItem	_SalesDocumentType
	SalesDocumentItemCategory	I_SalesDocumentItem	SalesDocumentItemCategory	Item Category
	_ItemCategory	I_SalesDocumentItem	_ItemCategory
	SalesDocumentItemType	I_SalesDocumentItem	SalesDocumentItemType	Item Type
	IsReturnsItem	I_SalesDocumentItem	IsReturnsItem	Returns Item
	ItemIsBillingRelevant	I_SalesDocumentItem	ItemIsBillingRelevant	Relev.for Bill.
	TotalDeliveryStatus	I_SalesDocumentItem	TotalDeliveryStatus	Ovrl Deliv. Sts
	CreatedByUser	I_SalesDocumentItem	CreatedByUser	User Name
	_CreatedByUser	I_SalesDocumentItem	_CreatedByUser
	CreationDate	I_SalesDocumentItem	CreationDate	Time Stamp
	CreationTime	I_SalesDocumentItem	CreationTime	Time of Change
	LastChangeDate	I_SalesDocumentItem	LastChangeDate	Time Stamp
	SalesDocumentDate
	ReferenceSDDocument	I_SalesDocumentItem	ReferenceSDDocument	Reference Doc.
	_ReferenceSDDocument	I_SalesDocumentItem	_ReferenceSDDocument
	ReferenceSDDocumentItem	I_SalesDocumentItem	ReferenceSDDocumentItem	Reference Item
	_ReferenceSDDocumentItem	I_SalesDocumentItem	_ReferenceSDDocumentItem
	ReferenceSDDocumentCategory	I_SalesDocumentItem	ReferenceSDDocumentCategory	Prec.Doc.Categ.
	_ReferenceSDDocumentCategory	I_SalesDocumentItem	_ReferenceSDDocumentCategory
	ReferenceSlsDocItmTransCrcy
	ReferenceSlsDocItmNetAmount
	ReferenceSlsDocItmBaseUnit
	ReferenceSlsDocItmQuantity
	ReferenceSDDocumentDate
	SalesOrganization	I_SalesDocumentItem	SalesOrganization	Sales Organization
	_SalesOrganization	I_SalesDocumentItem	_SalesOrganization
	DistributionChannel	I_SalesDocumentItem	DistributionChannel	RefDistCh-Cust/Mat.
	_DistributionChannel	I_SalesDocumentItem	_DistributionChannel
	OrganizationDivision	I_SalesDocumentItem	OrganizationDivision	Org. Division
	_OrganizationDivision	I_SalesDocumentItem	_OrganizationDivision
	SalesOffice	I_SalesDocumentItem	SalesOffice	Sales Office
	_SalesOffice	I_SalesDocumentItem	_SalesOffice
	SalesGroup	I_SalesDocumentItem	SalesGroup	Sales Group
	_SalesGroup	I_SalesDocumentItem	_SalesGroup
	SoldToParty	I_SalesDocumentItem	SoldToParty	Sold-to Party
	_SoldToParty	I_SalesDocumentItem	_SoldToParty
	ShipToParty	I_SalesDocumentItem	ShipToParty	Ship-To Party (obsolete)
	_ShipToParty	I_SalesDocumentItem	_ShipToParty
	PayerParty	I_SalesDocumentItem	PayerParty	Payer
	_PayerParty	I_SalesDocumentItem	_PayerParty
	BillToParty	I_SalesDocumentItem	BillToParty	Inv. Recipient
	_BillToParty	I_SalesDocumentItem	_BillToParty
	CustomerGroup	I_SalesDocumentItem	CustomerGroup	Customer Group
	_CustomerGroup	I_SalesDocumentItem	_CustomerGroup
	AdditionalCustomerGroup1	I_SalesDocumentItem	AdditionalCustomerGroup1	Customer Grp 1
	_AdditionalCustomerGroup1	I_SalesDocumentItem	_AdditionalCustomerGroup1
	AdditionalCustomerGroup2	I_SalesDocumentItem	AdditionalCustomerGroup2	Customer Grp 2
	_AdditionalCustomerGroup2	I_SalesDocumentItem	_AdditionalCustomerGroup2
	AdditionalCustomerGroup3	I_SalesDocumentItem	AdditionalCustomerGroup3	Customer Grp 3
	_AdditionalCustomerGroup3	I_SalesDocumentItem	_AdditionalCustomerGroup3
	AdditionalCustomerGroup4	I_SalesDocumentItem	AdditionalCustomerGroup4	Customer Grp 4
	_AdditionalCustomerGroup4	I_SalesDocumentItem	_AdditionalCustomerGroup4
	AdditionalCustomerGroup5	I_SalesDocumentItem	AdditionalCustomerGroup5	Customer Grp 5
	_AdditionalCustomerGroup5	I_SalesDocumentItem	_AdditionalCustomerGroup5
	Product
	_Product		_Product
	ProductGroup
	_ProductGroup		_ProductGroup
	MaterialByCustomer	I_SalesDocumentItem	MaterialByCustomer	Customer Mat.
	Division	I_SalesDocumentItem	Division	Internal Division ID
	_Division	I_SalesDocumentItem	_Division
	AdditionalMaterialGroup1	I_SalesDocumentItem	AdditionalMaterialGroup1	MaterialGroup 1
	_AdditionalMaterialGroup1	I_SalesDocumentItem	_AdditionalMaterialGroup1
	AdditionalMaterialGroup2	I_SalesDocumentItem	AdditionalMaterialGroup2	MaterialGroup 2
	_AdditionalMaterialGroup2	I_SalesDocumentItem	_AdditionalMaterialGroup2
	AdditionalMaterialGroup3	I_SalesDocumentItem	AdditionalMaterialGroup3	MaterialGroup 3
	_AdditionalMaterialGroup3	I_SalesDocumentItem	_AdditionalMaterialGroup3
	AdditionalMaterialGroup4	I_SalesDocumentItem	AdditionalMaterialGroup4	MaterialGroup 4
	_AdditionalMaterialGroup4	I_SalesDocumentItem	_AdditionalMaterialGroup4
	AdditionalMaterialGroup5	I_SalesDocumentItem	AdditionalMaterialGroup5	MaterialGroup 5
	_AdditionalMaterialGroup5	I_SalesDocumentItem	_AdditionalMaterialGroup5
	ProductHierarchyNode	I_SalesDocumentItem	ProductHierarchyNode	Prod. Hierarchy
	_ProductHierarchyNode	I_SalesDocumentItem	_ProductHierarchyNode
	Plant	I_SalesDocumentItem	Plant	Valuation Area
	_Plant	I_SalesDocumentItem	_Plant
	OriginallyRequestedMaterial	I_SalesDocumentItem	OriginallyRequestedMaterial	MaterialEntered
	_OriginallyRequestedMaterial	I_SalesDocumentItem	_OriginallyRequestedMaterial
	InternationalArticleNumber	I_SalesDocumentItem	InternationalArticleNumber	EAN/UPC
	Batch	I_SalesDocumentItem	Batch	Lot No.
	ProductCatalog	I_SalesDocumentItem	ProductCatalog	Catalog
	MaterialSubstitutionReason	I_SalesDocumentItem	MaterialSubstitutionReason	Reason
	_MaterialSubstitutionReason	I_SalesDocumentItem	_MaterialSubstitutionReason
	SalesDocumentRjcnReason	I_SalesDocumentItem	SalesDocumentRjcnReason	RejectionReason
	_SalesDocumentRjcnReason	I_SalesDocumentItem	_SalesDocumentRjcnReason
	ReturnReason	I_SalesDocumentItem	ReturnReason	Return Reason
	_ReturnReason	I_SalesDocumentItem	_ReturnReason
	RetsMgmtProcessingBlock	I_SalesDocumentItem	RetsMgmtProcessingBlock	Approval
	BillingCompanyCode
	_BillingCompanyCode
	SalesDistrict	I_SalesDocumentItem	SalesDistrict	Sales District
	_SalesDistrict	I_SalesDocumentItem	_SalesDistrict
	ProfitCenter	I_SalesDocumentItem	ProfitCenter	Profit Center
	_ProfitCenter	I_SalesDocumentItem	_ProfitCenter
	CostCenter
	_CostCenter		_CostCenter
	ControllingArea	I_SalesDocumentItem	ControllingArea	Controlling Area
	_ControllingArea	I_SalesDocumentItem	_ControllingArea
	BusinessArea	I_SalesDocumentItem	BusinessArea	Business Area
	_BusinessArea	I_SalesDocumentItem	_BusinessArea
	StorageLocation	I_SalesDocumentItem	StorageLocation	StorageLocation
	_StorageLocation	I_SalesDocumentItem	_StorageLocation
	TransactionCurrency	I_SalesDocumentItem	TransactionCurrency	Transaction Currency
	_TransactionCurrency	I_SalesDocumentItem	_TransactionCurrency
	NetAmount
	BaseUnit	I_SalesDocumentItem	BaseUnit	Unit of Measure
	_BaseUnit	I_SalesDocumentItem	_BaseUnit
	RequestedQuantityInBaseUnit	I_SalesDocumentItem	RequestedQuantityInBaseUnit	Requested Qty

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_CustomerReturnRateAnalytics.
-- 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.
-- SQL view name: ISDCUSTRETRATEA

CREATE VIEW I_CustomerReturnRateAnalytics AS
SELECT
  SDI.SalesDocument AS SalesDocument,
  SDI.SalesDocumentItem AS SalesDocumentItem,
  SDI._SalesDocument AS _SalesDocument,
  SDI.SDDocumentCategory AS SDDocumentCategory,
  SDI._SDDocumentCategory AS _SDDocumentCategory,
  SDI.SalesDocumentType AS SalesDocumentType,
  SDI._SalesDocumentType AS _SalesDocumentType,
  SDI.SalesDocumentItemCategory AS SalesDocumentItemCategory,
  SDI._ItemCategory AS _ItemCategory,
  SDI.SalesDocumentItemType AS SalesDocumentItemType,
  SDI.IsReturnsItem AS IsReturnsItem,
  SDI.ItemIsBillingRelevant AS ItemIsBillingRelevant,
  SDI.TotalDeliveryStatus AS TotalDeliveryStatus,
  SDI.CreatedByUser AS CreatedByUser,
  SDI._CreatedByUser AS _CreatedByUser,
  SDI.CreationDate AS CreationDate,
  SDI.CreationTime AS CreationTime,
  SDI.LastChangeDate AS LastChangeDate,
  SDI._SalesDocument.SalesDocumentDate AS SalesDocumentDate,
  SDI.ReferenceSDDocument AS ReferenceSDDocument,
  SDI._ReferenceSDDocument AS _ReferenceSDDocument,
  SDI.ReferenceSDDocumentItem AS ReferenceSDDocumentItem,
  SDI._ReferenceSDDocumentItem AS _ReferenceSDDocumentItem,
  SDI.ReferenceSDDocumentCategory AS ReferenceSDDocumentCategory,
  SDI._ReferenceSDDocumentCategory AS _ReferenceSDDocumentCategory,
  cast( RSDI.TransactionCurrency as ref_sls_doc_itm_curr ) AS ReferenceSlsDocItmTransCrcy,
  cast( RSDI.NetAmount as ref_sls_doc_itm_net_amt ) AS ReferenceSlsDocItmNetAmount,
  cast( RSDI.BaseUnit as ref_sls_doc_itm_unit ) AS ReferenceSlsDocItmBaseUnit,
  cast( RSDI.RequestedQuantityInBaseUnit as ref_sls_doc_itm_qty ) AS ReferenceSlsDocItmQuantity,
  cast( RSDI.CreationDate as vgdat ) AS ReferenceSDDocumentDate,
  SDI.SalesOrganization AS SalesOrganization,
  SDI._SalesOrganization AS _SalesOrganization,
  SDI.DistributionChannel AS DistributionChannel,
  SDI._DistributionChannel AS _DistributionChannel,
  SDI.OrganizationDivision AS OrganizationDivision,
  SDI._OrganizationDivision AS _OrganizationDivision,
  SDI.SalesOffice AS SalesOffice,
  SDI._SalesOffice AS _SalesOffice,
  SDI.SalesGroup AS SalesGroup,
  SDI._SalesGroup AS _SalesGroup,
  SDI.SoldToParty AS SoldToParty,
  SDI._SoldToParty AS _SoldToParty,
  SDI.ShipToParty AS ShipToParty,
  SDI._ShipToParty AS _ShipToParty,
  SDI.PayerParty AS PayerParty,
  SDI._PayerParty AS _PayerParty,
  SDI.BillToParty AS BillToParty,
  SDI._BillToParty AS _BillToParty,
  SDI.CustomerGroup AS CustomerGroup,
  SDI._CustomerGroup AS _CustomerGroup,
  SDI.AdditionalCustomerGroup1 AS AdditionalCustomerGroup1,
  SDI._AdditionalCustomerGroup1 AS _AdditionalCustomerGroup1,
  SDI.AdditionalCustomerGroup2 AS AdditionalCustomerGroup2,
  SDI._AdditionalCustomerGroup2 AS _AdditionalCustomerGroup2,
  SDI.AdditionalCustomerGroup3 AS AdditionalCustomerGroup3,
  SDI._AdditionalCustomerGroup3 AS _AdditionalCustomerGroup3,
  SDI.AdditionalCustomerGroup4 AS AdditionalCustomerGroup4,
  SDI._AdditionalCustomerGroup4 AS _AdditionalCustomerGroup4,
  SDI.AdditionalCustomerGroup5 AS AdditionalCustomerGroup5,
  SDI._AdditionalCustomerGroup5 AS _AdditionalCustomerGroup5,
  cast( SDI.Material as productnumber preserving type ) AS Product,
  cast (SDI.MaterialGroup as productgroup preserving type) AS ProductGroup,
  SDI.MaterialByCustomer AS MaterialByCustomer,
  SDI.Division AS Division,
  SDI._Division AS _Division,
  SDI.AdditionalMaterialGroup1 AS AdditionalMaterialGroup1,
  SDI._AdditionalMaterialGroup1 AS _AdditionalMaterialGroup1,
  SDI.AdditionalMaterialGroup2 AS AdditionalMaterialGroup2,
  SDI._AdditionalMaterialGroup2 AS _AdditionalMaterialGroup2,
  SDI.AdditionalMaterialGroup3 AS AdditionalMaterialGroup3,
  SDI._AdditionalMaterialGroup3 AS _AdditionalMaterialGroup3,
  SDI.AdditionalMaterialGroup4 AS AdditionalMaterialGroup4,
  SDI._AdditionalMaterialGroup4 AS _AdditionalMaterialGroup4,
  SDI.AdditionalMaterialGroup5 AS AdditionalMaterialGroup5,
  SDI._AdditionalMaterialGroup5 AS _AdditionalMaterialGroup5,
  SDI.ProductHierarchyNode AS ProductHierarchyNode,
  SDI._ProductHierarchyNode AS _ProductHierarchyNode,
  SDI.Plant AS Plant,
  SDI._Plant AS _Plant,
  SDI.OriginallyRequestedMaterial AS OriginallyRequestedMaterial,
  SDI._OriginallyRequestedMaterial AS _OriginallyRequestedMaterial,
  SDI.InternationalArticleNumber AS InternationalArticleNumber,
  SDI.Batch AS Batch,
  SDI.ProductCatalog AS ProductCatalog,
  SDI.MaterialSubstitutionReason AS MaterialSubstitutionReason,
  SDI._MaterialSubstitutionReason AS _MaterialSubstitutionReason,
  SDI.SalesDocumentRjcnReason AS SalesDocumentRjcnReason,
  SDI._SalesDocumentRjcnReason AS _SalesDocumentRjcnReason,
  SDI.ReturnReason AS ReturnReason,
  SDI._ReturnReason AS _ReturnReason,
  SDI.RetsMgmtProcessingBlock AS RetsMgmtProcessingBlock,
  SDI._SalesDocument.BillingCompanyCode AS BillingCompanyCode,
  SDI._SalesDocument._BillingCompanyCode AS _BillingCompanyCode,
  SDI.SalesDistrict AS SalesDistrict,
  SDI._SalesDistrict AS _SalesDistrict,
  SDI.ProfitCenter AS ProfitCenter,
  SDI._ProfitCenter AS _ProfitCenter,
  SDI._SalesDocument.CostCenter AS CostCenter,
  SDI.ControllingArea AS ControllingArea,
  SDI._ControllingArea AS _ControllingArea,
  SDI.BusinessArea AS BusinessArea,
  SDI._BusinessArea AS _BusinessArea,
  SDI.StorageLocation AS StorageLocation,
  SDI._StorageLocation AS _StorageLocation,
  SDI.TransactionCurrency AS TransactionCurrency,
  SDI._TransactionCurrency AS _TransactionCurrency,
  cast( SDI.NetAmount as slsorditm_netamount ) AS NetAmount,
  SDI.BaseUnit AS BaseUnit,
  SDI._BaseUnit AS _BaseUnit,
  SDI.RequestedQuantityInBaseUnit AS RequestedQuantityInBaseUnit
FROM I_SalesDocumentItem AS SDI
LEFT OUTER JOIN I_Product AS _Product ON Product = _Product.Product  -- association [0..1]
LEFT OUTER JOIN I_ProductGroup_2 AS _ProductGroup ON ProductGroup = _ProductGroup.ProductGroup  -- association [0..1]
LEFT OUTER JOIN I_CostCenter AS _CostCenter ON costcenter = _CostCenter.CostCenter AND ControllingArea = _CostCenter.ControllingArea AND _CostCenter.ValidityEndDate >= salesdocumentdate AND _CostCenter.ValidityStartDate <= salesdocumentdate  -- association [0..1]
LEFT OUTER JOIN I_SalesDocumentItem AS RSDI ON SDDocumentCategory = 'H' AND ReferenceSDDocumentCategory = 'C' AND ReferenceSDDocument = RSDI.SalesDocument AND ReferenceSDDocumentItem = RSDI.SalesDocumentItem  -- association [0..1]
;

Depth:

I_CustomerReturnRateAnalytics view

I_SalesDocumentItem view

I_CustomerReturnRateCube view