What is I_CustomerReturnItemImport in SAP S/4HANA?

I_CustomerReturnItemImport is a composite CDS view in SAP S/4HANA. Item Fields for Customer Return Import It contains 108 fields.

Which tables does I_CustomerReturnItemImport read from?

I_CustomerReturnItemImport reads data from: I_CustomerReturnItem.

What VDM layer is I_CustomerReturnItemImport?

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

I_CustomerReturnItemImport

DDL: I_CUSTOMERRETURNITEMIMPORT Type: view_entity COMPOSITE Package: VDM_SD_SLS_IMPORT_CRT

108 Fields 1 Data Sources 4 Associations 1 OData Services

Item Fields for Customer Return Import

I_CustomerReturnItemImport is a Composite CDS View that provides data about "Item Fields for Customer Return Import" in SAP S/4HANA. It reads from 1 data source (I_CustomerReturnItem) and exposes 108 fields with key fields CustomerReturn, CustomerReturnItem. It has 4 associations to related views. It is exposed through 1 OData service (ASQL_F8641). Part of development package VDM_SD_SLS_IMPORT_CRT.

Data Sources (1)

Source	Alias	Join Type
I_CustomerReturnItem	CustomerReturnItem	from

Associations (4)

Cardinality	Target	Alias	Condition
[1..1]	I_CustomerReturnImport	_CustomerReturn	`$projection.CustomerReturn = _CustomerReturn.CustomerReturn`
[0..*]	I_SalesDocItemCompletePartner	_Partner	`$projection.CustomerReturn = _Partner.SalesDocument and $projection.CustomerReturnItem = _Partner.SalesDocumentItem`
[0..*]	I_SalesDocItemPricingElement	_PricingElement	`$projection.CustomerReturn = _PricingElement.SalesDocument and $projection.CustomerReturnItem = _PricingElement.SalesDocumentItem`
[0..1]	E_SalesDocumentItemBasic	_Extension	`CustomerReturnItem.CustomerReturn = _Extension.SalesDocument and CustomerReturnItem.CustomerReturnItem = _Extension.SalesDocumentItem`

Annotations (8)

Name	Value	Level
AccessControl.authorizationCheck	#PRIVILEGED_ONLY	view
EndUserText.label	Item Fields for Customer Return Import	view
Metadata.ignorePropagatedAnnotations	true	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.usageType.dataClass	#MIXED	view
VDM.lifecycle.contract.type	#PUBLIC_LOCAL_API	view
VDM.viewType	#COMPOSITE	view

OData Services (1)

Service	Binding	Version	Contract	Release
ASQL_F8641	ASQL_F8641		C2	NOT_RELEASED

Fields (108)

Key	Field	Source Table	Source Field	Description
KEY	CustomerReturn	I_CustomerReturnItem	CustomerReturn
KEY	CustomerReturnItem	I_CustomerReturnItem	CustomerReturnItem
	SourceSalesDocumentItemText
	HigherLevelItem	I_CustomerReturnItem	HigherLevelItem	Higher-Lev.Item
	CustomerReturnItemCategory	I_CustomerReturnItem	CustomerReturnItemCategory	Item Category
	CustomerReturnItemText	I_CustomerReturnItem	CustomerReturnItemText	Item Descr.
	PurchaseOrderByCustomer	I_CustomerReturnItem	PurchaseOrderByCustomer	Purchase Order Number
	Product	I_CustomerReturnItem	Product	Product Sold
	Material	I_CustomerReturnItem	Material	Vehicle Model
	MaterialByCustomer	I_CustomerReturnItem	MaterialByCustomer	Customer Mat.
	ProductConfiguration	I_CustomerReturnItem	ProductConfiguration
	ProductGroup	I_CustomerReturnItem	ProductGroup	Product Sold Group
	Batch	I_CustomerReturnItem	Batch	Lot No.
	RequestedQuantity	I_CustomerReturnItem	RequestedQuantity	Requested Quantity
	RequestedQuantityUnit	I_CustomerReturnItem	RequestedQuantityUnit	Requested Quantity Unit
	ItemGrossWeight	I_CustomerReturnItem	ItemGrossWeight	Gross Weight
	ItemNetWeight	I_CustomerReturnItem	ItemNetWeight	Net Weight
	ItemWeightUnit	I_CustomerReturnItem	ItemWeightUnit	Unit of Weight
	ItemVolume	I_CustomerReturnItem	ItemVolume	Volume
	ItemVolumeUnit	I_CustomerReturnItem	ItemVolumeUnit	Volume Unit
	NetAmount	I_CustomerReturnItem	NetAmount	Stated Amount
	TransactionCurrency	I_CustomerReturnItem	TransactionCurrency	Transaction Currency
	PricingDate	I_CustomerReturnItem	PricingDate	Pricing Date
	TaxAmount	I_CustomerReturnItem	TaxAmount	Tax Amt in Rptg Crcy
	MatlAccountAssignmentGroup	I_CustomerReturnItem	MatlAccountAssignmentGroup
	ControllingArea	I_CustomerReturnItem	ControllingArea	Controlling Area
	ProductionPlant
	StorageLocation	I_CustomerReturnItem	StorageLocation	StorageLocation
	ShippingPoint
	DeliveryPriority	I_CustomerReturnItem	DeliveryPriority	Delivery Prior.
	ShippingType	I_CustomerReturnItem	ShippingType	Shipping Type
	SalesDocumentRjcnReason	I_CustomerReturnItem	SalesDocumentRjcnReason	RejectionReason
	ItemBillingBlockReason	I_CustomerReturnItem	ItemBillingBlockReason	Billing Block
	IncotermsClassification	I_CustomerReturnItem	IncotermsClassification	Incoterms
	IncotermsTransferLocation	I_CustomerReturnItem	IncotermsTransferLocation	Incoterms 2
	IncotermsLocation1	I_CustomerReturnItem	IncotermsLocation1	Inco. Location1
	IncotermsLocation2	I_CustomerReturnItem	IncotermsLocation2	Inco. Location2
	CustomerPaymentTerms	I_CustomerReturnItem	CustomerPaymentTerms	Pyt Terms
	ProfitCenter	I_CustomerReturnItem	ProfitCenter	Profit Center
	WBSElementInternalID	I_CustomerReturnItem	WBSElementInternalID	WBS Internal ID
	WBSElementExternalID
	RetsMgmtProcess	I_CustomerReturnItem	RetsMgmtProcess
	ReturnReason	I_CustomerReturnItem	ReturnReason	Return Reason
	RetsMgmtProcessingBlock	I_CustomerReturnItem	RetsMgmtProcessingBlock
	CustRetItmFollowUpActivity	AdvncdRetsMgmtProcessStep	CustRetItmFollowUpActivity	Follow-Up Act.
	ReturnsMaterialHasBeenReceived	AdvncdRetsMgmtProcessStep	ReturnsMaterialHasBeenReceived	Product Received
	CustRetItmCustomerText
	CustRetItmInspectionText
	ReturnsRefundType	AdvncdRetsMgmtProcessStep	ReturnsRefundType
	ReturnsRefundProcgMode
	RetsProdValnIsSuspended	AdvncdRetsMgmtProcessItem	RetsProdValnIsSuspended
	RetsInspIsCrtedAutomly	AdvncdRetsMgmtProcessItem	RetsInspIsCrtedAutomly
	RetsProdIsVltdWithRef	AdvncdRetsMgmtProcessItem	RetsProdIsVltdWithRef
	ReturnsRefundExtent	I_CustomerReturnItem	ReturnsRefundExtent
	PrelimRefundIsDetermined	AdvncdRetsMgmtProcessStep	PrelimRefundIsDetermined
	ReturnsRefundRjcnReason	AdvncdRetsMgmtProcessItem	ReturnsRefundRjcnReason
	ReplacementMaterial
	ReplacementMaterialQuantity	AdvncdRetsMgmtProcessStep	ReplacementMaterialQuantity
	ReplacementMaterialQtyUnit	AdvncdRetsMgmtProcessStep	ReplacementMaterialQtyUnit
	ReplacementMaterialIsRequested	AdvncdRetsMgmtProcessStep	ReplacementMaterialIsRequested
	ReplacementMatlSupplyingPlant	AdvncdRetsMgmtProcessStep	ReplacementMatlSupplyingPlant
	NextPlantForFollowUpActivity	AdvncdRetsMgmtProcessStep	NextPlantForFollowUpActivity
	ReturnsTransshipmentPlant	AdvncdRetsMgmtProcessStep	ReturnsTransshipmentPlant
	Supplier	AdvncdRetsMgmtProcessStep	Supplier	Supplier
	SupplierRetMatlAuthzn	AdvncdRetsMgmtProcessStep	SupplierRetMatlAuthzn
	SuplrRetMatlAuthznIsRequired	AdvncdRetsMgmtProcessStep	SuplrRetMatlAuthznIsRequired
	CustomerRetMatlInspResultCode	AdvncdRetsMgmtProcessItem	CustomerRetMatlInspResultCode
	NextFllwUpActivityForMatlInsp	AdvncdRetsMgmtProcessItem	NextFllwUpActivityForMatlInsp
	RetMatlInspResultCode	AdvncdRetsMgmtProcessStep	RetMatlInspResultCode
	ProductIsInspectedAtCustSite	AdvncdRetsMgmtProcessStep	ProductIsInspectedAtCustSite
	CustRetMatlAuthzn	AdvncdRetsMgmtProcessItem	CustRetMatlAuthzn
	CRMLogicalSystem	AdvncdRetsMgmtProcessItem	CRMLogicalSystem
	CRMObjectUUID	AdvncdRetsMgmtProcessItem	CRMObjectUUID
	CRMObjectID	AdvncdRetsMgmtProcessItem	CRMObjectID
	CRMObjectType	AdvncdRetsMgmtProcessItem	CRMObjectType
	RetsMgmtItmLogProcgStatus	AdvncdRetsMgmtProcessItem	RetsMgmtItmLogProcgStatus
	RetsMgmtItmCompnProcgStatus	AdvncdRetsMgmtProcessItem	RetsMgmtItmCompnProcgStatus
	RetsMgmtItmProcgStatus	AdvncdRetsMgmtProcessItem	RetsMgmtItmProcgStatus
	ReturnsDocumentStatus	AdvncdRetsMgmtProcessStep	ReturnsDocumentStatus
	ReturnsDocumentApprovalStatus	AdvncdRetsMgmtProcessStep	ReturnsDocumentApprovalStatus
	ReferenceSDDocument	I_CustomerReturnItem	ReferenceSDDocument	Reference Doc.
	ReferenceSDDocumentItem	I_CustomerReturnItem	ReferenceSDDocumentItem	Reference Item
	ReferenceSDDocumentCategory	I_CustomerReturnItem	ReferenceSDDocumentCategory	Prec.Doc.Categ.
	SDProcessStatus	I_CustomerReturnItem	SDProcessStatus
	SDDocumentRejectionStatus	I_CustomerReturnItem	SDDocumentRejectionStatus
	ProductTaxClassification1	I_CustomerReturnItem	ProductTaxClassification1
	ProductTaxClassification2	I_CustomerReturnItem	ProductTaxClassification2
	ProductTaxClassification3	I_CustomerReturnItem	ProductTaxClassification3
	ProductTaxClassification4	I_CustomerReturnItem	ProductTaxClassification4
	ProductTaxClassification5	I_CustomerReturnItem	ProductTaxClassification5
	ProductTaxClassification6	I_CustomerReturnItem	ProductTaxClassification6
	ProductTaxClassification7	I_CustomerReturnItem	ProductTaxClassification7
	ProductTaxClassification8	I_CustomerReturnItem	ProductTaxClassification8
	ProductTaxClassification9	I_CustomerReturnItem	ProductTaxClassification9
	AdditionalMaterialGroup1	I_CustomerReturnItem	AdditionalMaterialGroup1	MaterialGroup 1
	AdditionalMaterialGroup2	I_CustomerReturnItem	AdditionalMaterialGroup2	MaterialGroup 2
	AdditionalMaterialGroup3	I_CustomerReturnItem	AdditionalMaterialGroup3	MaterialGroup 3
	AdditionalMaterialGroup4	I_CustomerReturnItem	AdditionalMaterialGroup4	MaterialGroup 4
	AdditionalMaterialGroup5	I_CustomerReturnItem	AdditionalMaterialGroup5	MaterialGroup 5
	Subtotal1Amount	I_CustomerReturnItem	Subtotal1Amount	Subtotal 1 Amount
	Subtotal2Amount	I_CustomerReturnItem	Subtotal2Amount	Subtotal 2 Amount
	Subtotal3Amount	I_CustomerReturnItem	Subtotal3Amount	Subtotal 3 Amount
	Subtotal4Amount	I_CustomerReturnItem	Subtotal4Amount	Subtotal 4 Amount
	Subtotal5Amount	I_CustomerReturnItem	Subtotal5Amount	Subtotal 5 Amount
	Subtotal6Amount	I_CustomerReturnItem	Subtotal6Amount	Subtotal 6 Amount
	_CustomerReturn		_CustomerReturn
	_Partner		_Partner
	_PricingElement		_PricingElement

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_CustomerReturnItemImport.
-- 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_CustomerReturnItemImport AS
SELECT
  CustomerReturnItem.CustomerReturn AS CustomerReturn,
  CustomerReturnItem.CustomerReturnItem AS CustomerReturnItem,
  cast( '' as char6 ) AS SourceSalesDocumentItemText,
  CustomerReturnItem.HigherLevelItem AS HigherLevelItem,
  CustomerReturnItem.CustomerReturnItemCategory AS CustomerReturnItemCategory,
  CustomerReturnItem.CustomerReturnItemText AS CustomerReturnItemText,
  CustomerReturnItem.PurchaseOrderByCustomer AS PurchaseOrderByCustomer,
  CustomerReturnItem.Product AS Product,
  CustomerReturnItem.Material AS Material,
  CustomerReturnItem.MaterialByCustomer AS MaterialByCustomer,
  CustomerReturnItem.ProductConfiguration AS ProductConfiguration,
  CustomerReturnItem.ProductGroup AS ProductGroup,
  CustomerReturnItem.Batch AS Batch,
  CustomerReturnItem.RequestedQuantity AS RequestedQuantity,
  CustomerReturnItem.RequestedQuantityUnit AS RequestedQuantityUnit,
  CustomerReturnItem.ItemGrossWeight AS ItemGrossWeight,
  CustomerReturnItem.ItemNetWeight AS ItemNetWeight,
  CustomerReturnItem.ItemWeightUnit AS ItemWeightUnit,
  CustomerReturnItem.ItemVolume AS ItemVolume,
  CustomerReturnItem.ItemVolumeUnit AS ItemVolumeUnit,
  CustomerReturnItem.NetAmount AS NetAmount,
  CustomerReturnItem.TransactionCurrency AS TransactionCurrency,
  CustomerReturnItem.PricingDate AS PricingDate,
  CustomerReturnItem.TaxAmount AS TaxAmount,
  CustomerReturnItem.MatlAccountAssignmentGroup AS MatlAccountAssignmentGroup,
  CustomerReturnItem.ControllingArea AS ControllingArea,
  cast(CustomerReturnItem.Plant as wsubst_rec_plant preserving type) AS ProductionPlant,
  CustomerReturnItem.StorageLocation AS StorageLocation,
  cast(CustomerReturnItem.ShippingPoint as borgr_wanst preserving type) AS ShippingPoint,
  CustomerReturnItem.DeliveryPriority AS DeliveryPriority,
  CustomerReturnItem.ShippingType AS ShippingType,
  CustomerReturnItem.SalesDocumentRjcnReason AS SalesDocumentRjcnReason,
  CustomerReturnItem.ItemBillingBlockReason AS ItemBillingBlockReason,
  CustomerReturnItem.IncotermsClassification AS IncotermsClassification,
  CustomerReturnItem.IncotermsTransferLocation AS IncotermsTransferLocation,
  CustomerReturnItem.IncotermsLocation1 AS IncotermsLocation1,
  CustomerReturnItem.IncotermsLocation2 AS IncotermsLocation2,
  CustomerReturnItem.CustomerPaymentTerms AS CustomerPaymentTerms,
  CustomerReturnItem.ProfitCenter AS ProfitCenter,
  CustomerReturnItem.WBSElementInternalID AS WBSElementInternalID,
  CustomerReturnItem._WBSElementBasicData_2.WBSElementExternalID AS WBSElementExternalID,
  CustomerReturnItem.RetsMgmtProcess AS RetsMgmtProcess,
  CustomerReturnItem.ReturnReason AS ReturnReason,
  CustomerReturnItem.RetsMgmtProcessingBlock AS RetsMgmtProcessingBlock,
  AdvncdRetsMgmtProcessStep.CustRetItmFollowUpActivity AS CustRetItmFollowUpActivity,
  AdvncdRetsMgmtProcessStep.ReturnsMaterialHasBeenReceived AS ReturnsMaterialHasBeenReceived,
  cast ( '' as msr_cust_insp_comment ) AS CustRetItmCustomerText,
  cast ( '' as msr_insp_comment ) AS CustRetItmInspectionText,
  AdvncdRetsMgmtProcessStep.ReturnsRefundType AS ReturnsRefundType,
  cast(AdvncdRetsMgmtProcessStep.ReturnsRefundProcgMode as msr_refund_control preserving type) AS ReturnsRefundProcgMode,
  AdvncdRetsMgmtProcessItem.RetsProdValnIsSuspended AS RetsProdValnIsSuspended,
  AdvncdRetsMgmtProcessItem.RetsInspIsCrtedAutomly AS RetsInspIsCrtedAutomly,
  AdvncdRetsMgmtProcessItem.RetsProdIsVltdWithRef AS RetsProdIsVltdWithRef,
  CustomerReturnItem.ReturnsRefundExtent AS ReturnsRefundExtent,
  AdvncdRetsMgmtProcessStep.PrelimRefundIsDetermined AS PrelimRefundIsDetermined,
  AdvncdRetsMgmtProcessItem.ReturnsRefundRjcnReason AS ReturnsRefundRjcnReason,
  cast(AdvncdRetsMgmtProcessStep.ReplacementMaterial as return_replace_product preserving type) AS ReplacementMaterial,
  AdvncdRetsMgmtProcessStep.ReplacementMaterialQuantity AS ReplacementMaterialQuantity,
  AdvncdRetsMgmtProcessStep.ReplacementMaterialQtyUnit AS ReplacementMaterialQtyUnit,
  AdvncdRetsMgmtProcessStep.ReplacementMaterialIsRequested AS ReplacementMaterialIsRequested,
  AdvncdRetsMgmtProcessStep.ReplacementMatlSupplyingPlant AS ReplacementMatlSupplyingPlant,
  AdvncdRetsMgmtProcessStep.NextPlantForFollowUpActivity AS NextPlantForFollowUpActivity,
  AdvncdRetsMgmtProcessStep.ReturnsTransshipmentPlant AS ReturnsTransshipmentPlant,
  AdvncdRetsMgmtProcessStep.Supplier AS Supplier,
  AdvncdRetsMgmtProcessStep.SupplierRetMatlAuthzn AS SupplierRetMatlAuthzn,
  AdvncdRetsMgmtProcessStep.SuplrRetMatlAuthznIsRequired AS SuplrRetMatlAuthznIsRequired,
  AdvncdRetsMgmtProcessItem.CustomerRetMatlInspResultCode AS CustomerRetMatlInspResultCode,
  AdvncdRetsMgmtProcessItem.NextFllwUpActivityForMatlInsp AS NextFllwUpActivityForMatlInsp,
  AdvncdRetsMgmtProcessStep.RetMatlInspResultCode AS RetMatlInspResultCode,
  AdvncdRetsMgmtProcessStep.ProductIsInspectedAtCustSite AS ProductIsInspectedAtCustSite,
  AdvncdRetsMgmtProcessItem.CustRetMatlAuthzn AS CustRetMatlAuthzn,
  AdvncdRetsMgmtProcessItem.CRMLogicalSystem AS CRMLogicalSystem,
  AdvncdRetsMgmtProcessItem.CRMObjectUUID AS CRMObjectUUID,
  AdvncdRetsMgmtProcessItem.CRMObjectID AS CRMObjectID,
  AdvncdRetsMgmtProcessItem.CRMObjectType AS CRMObjectType,
  AdvncdRetsMgmtProcessItem.RetsMgmtItmLogProcgStatus AS RetsMgmtItmLogProcgStatus,
  AdvncdRetsMgmtProcessItem.RetsMgmtItmCompnProcgStatus AS RetsMgmtItmCompnProcgStatus,
  AdvncdRetsMgmtProcessItem.RetsMgmtItmProcgStatus AS RetsMgmtItmProcgStatus,
  AdvncdRetsMgmtProcessStep.ReturnsDocumentStatus AS ReturnsDocumentStatus,
  AdvncdRetsMgmtProcessStep.ReturnsDocumentApprovalStatus AS ReturnsDocumentApprovalStatus,
  CustomerReturnItem.ReferenceSDDocument AS ReferenceSDDocument,
  CustomerReturnItem.ReferenceSDDocumentItem AS ReferenceSDDocumentItem,
  CustomerReturnItem.ReferenceSDDocumentCategory AS ReferenceSDDocumentCategory,
  CustomerReturnItem.SDProcessStatus AS SDProcessStatus,
  CustomerReturnItem.SDDocumentRejectionStatus AS SDDocumentRejectionStatus,
  CustomerReturnItem.ProductTaxClassification1 AS ProductTaxClassification1,
  CustomerReturnItem.ProductTaxClassification2 AS ProductTaxClassification2,
  CustomerReturnItem.ProductTaxClassification3 AS ProductTaxClassification3,
  CustomerReturnItem.ProductTaxClassification4 AS ProductTaxClassification4,
  CustomerReturnItem.ProductTaxClassification5 AS ProductTaxClassification5,
  CustomerReturnItem.ProductTaxClassification6 AS ProductTaxClassification6,
  CustomerReturnItem.ProductTaxClassification7 AS ProductTaxClassification7,
  CustomerReturnItem.ProductTaxClassification8 AS ProductTaxClassification8,
  CustomerReturnItem.ProductTaxClassification9 AS ProductTaxClassification9,
  CustomerReturnItem.AdditionalMaterialGroup1 AS AdditionalMaterialGroup1,
  CustomerReturnItem.AdditionalMaterialGroup2 AS AdditionalMaterialGroup2,
  CustomerReturnItem.AdditionalMaterialGroup3 AS AdditionalMaterialGroup3,
  CustomerReturnItem.AdditionalMaterialGroup4 AS AdditionalMaterialGroup4,
  CustomerReturnItem.AdditionalMaterialGroup5 AS AdditionalMaterialGroup5,
  CustomerReturnItem.Subtotal1Amount AS Subtotal1Amount,
  CustomerReturnItem.Subtotal2Amount AS Subtotal2Amount,
  CustomerReturnItem.Subtotal3Amount AS Subtotal3Amount,
  CustomerReturnItem.Subtotal4Amount AS Subtotal4Amount,
  CustomerReturnItem.Subtotal5Amount AS Subtotal5Amount,
  CustomerReturnItem.Subtotal6Amount AS Subtotal6Amount
FROM I_CustomerReturnItem AS CustomerReturnItem
LEFT OUTER JOIN I_CustomerReturnImport AS _CustomerReturn ON CustomerReturn = _CustomerReturn.CustomerReturn  -- association [1..1]
LEFT OUTER JOIN I_SalesDocItemCompletePartner AS _Partner ON CustomerReturn = _Partner.SalesDocument AND CustomerReturnItem = _Partner.SalesDocumentItem  -- association [0..*]
LEFT OUTER JOIN I_SalesDocItemPricingElement AS _PricingElement ON CustomerReturn = _PricingElement.SalesDocument AND CustomerReturnItem = _PricingElement.SalesDocumentItem  -- association [0..*]
LEFT OUTER JOIN E_SalesDocumentItemBasic AS _Extension ON CustomerReturnItem.CustomerReturn = _Extension.SalesDocument AND CustomerReturnItem.CustomerReturnItem = _Extension.SalesDocumentItem  -- association [0..1]
;

Depth:

I_CustomerReturnItemImport view_entity

I_CustomerReturnItem view