What is I_CustomerReturn in SAP S/4HANA?

I_CustomerReturn is a basic CDS view in SAP S/4HANA. Returns Order It contains 181 fields.

Which tables does I_CustomerReturn read from?

I_CustomerReturn reads data from: I_SalesDocument.

What VDM layer is I_CustomerReturn?

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

I_CustomerReturn

DDL: I_CUSTOMERRETURN Type: view BASIC Package: VDM_SD_SLS_CR

181 Fields 1 Data Sources 4 Associations

Returns Order

I_CustomerReturn (Basic)

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

Customer Return · Sales

I_CustomerReturn is a Basic CDS View (Dimension) that provides data about "Returns Order" in SAP S/4HANA. It reads from 1 data source (I_SalesDocument) and exposes 181 fields with key field CustomerReturn. It has 4 associations to related views. Part of development package VDM_SD_SLS_CR.

SAP API Hub

Category	Basic
State	C1
Line of Business	Sales
Application Component	SD-SLS-RE-2CL
Capabilities	Data Source for Data Extraction,Analytical Dimension,Association Target for Defining CDS Entities,Data Source for Defining CDS Entities,Data Source in SQL Select
Extensible (Key User)	Yes
Extensible (Developer)	No
Release State (Key User)	Released
Release State (Developer)	Released
Package	Sales for SAP S/4HANA Cloud Public Edition
Description	<p>This CDS view provides the prerequisites for answering questions about all relevant aspects of customer returns.</p>

Documentation

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

Data Sources (1)

Source	Alias	Join Type
I_SalesDocument	SalesDocument	from

Associations (4)

Cardinality	Target	Alias	Condition
[0..*]	I_CustomerReturnItem	_Item	`$projection.CustomerReturn = _Item.CustomerReturn`
[0..1]	I_RetsMgmtProcess	_RetsMgmtProcess	`$projection.RetsMgmtProcess = _RetsMgmtProcess.RetsMgmtProcess`
[0..1]	I_CustomerReturnApprovalReason	_CustRetApprovalReason	`$projection.CustomerReturnApprovalReason = _CustRetApprovalReason.CustomerReturnApprovalReason`
[0..1]	E_SalesDocumentBasic	_Extension	`SalesDocument.SalesDocument = _Extension.SalesDocument`

Annotations (19)

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

Fields (181)

Key	Field	Source Field	Description
KEY	CustomerReturn		Customer Return
	CustomerReturnType		Customer Return Type
	CreatedByUser	CreatedByUser	Name of Person Responsible for Creating the Object
	LastChangedByUser	LastChangedByUser	User Who Last Changed the Business Document
	CreationDate	CreationDate	Record Creation Date
	CreationTime	CreationTime	Time at Which Record Was Created
	LastChangeDate	LastChangeDate	Last Changed On
	LastChangeDateTime	LastChangeDateTime	UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)
	SenderBusinessSystemName	SenderBusinessSystemName	External Business System ID
	SalesOrganization	SalesOrganization	Sales Organization
	DistributionChannel	DistributionChannel	Distribution Channel
	OrganizationDivision	OrganizationDivision	Org. Division
	SalesGroup	SalesGroup	Sales Group
	SalesOffice	SalesOffice	Sales Office
	SoldToParty	SoldToParty	Sold-to Party
	CustomerGroup	CustomerGroup	Customer Group
	AdditionalCustomerGroup1	AdditionalCustomerGroup1	Customer Group 1
	AdditionalCustomerGroup2	AdditionalCustomerGroup2	Customer Group 2
	AdditionalCustomerGroup3	AdditionalCustomerGroup3	Customer Group 3
	AdditionalCustomerGroup4	AdditionalCustomerGroup4	Customer Group 4
	AdditionalCustomerGroup5	AdditionalCustomerGroup5	Customer Group 5
	CreditControlArea	CreditControlArea	Credit Control Area
	CustomerReturnDate	SalesDocumentDate	Document Date (Date Received/Sent)
	ServicesRenderedDate	ServicesRenderedDate	Date on which services are rendered
	SDDocumentReason	SDDocumentReason	Order Reason (Reason for the Business Transaction)
	PurchaseOrderByCustomer	PurchaseOrderByCustomer	Purchase Order Number
	CustomerPurchaseOrderType	CustomerPurchaseOrderType	Customer Purchase Order Type
	CustPurOrdTypeByShipToParty	CustPurOrdTypeByShipToParty	Ship-to Party Purchase Order Type
	CustomerPurchaseOrderDate	CustomerPurchaseOrderDate	Customer Reference Date
	CustomerPurchaseOrderSuplmnt	CustomerPurchaseOrderSuplmnt	Purchase order number supplement
	PurchaseOrderByShipToParty	PurchaseOrderByShipToParty	Ship-to Party's Customer Reference
	CorrespncExternalReference	CorrespncExternalReference	Your Reference
	CorrespncExtRefByShipToParty	CorrespncExtRefByShipToParty	Your Reference (Ship-to Party)
	BusinessSolutionOrder	BusinessSolutionOrder	Solution Order
	SalesDistrict	SalesDistrict	Sales District
	RetsMgmtProcess	RetsMgmtProcess	Process Identification Number
	TotalNetAmount	TotalNetAmount	Net Value of the Sales Document in Document Currency
	TransactionCurrency	TransactionCurrency	Transaction Currency
	PricingDate	PricingDate	Date for Pricing and Exchange Rate
	PriceDetnExchangeRate	PriceDetnExchangeRate	Exchange Rate for Price Determination
	SDPricingProcedure	SDPricingProcedure	Pricing Procedure in Pricing
	CustomerReturnCondition	SalesDocumentCondition	Number of the Document Condition
	CustomerPriceGroup	CustomerPriceGroup	Customer Price Group
	PriceListType	PriceListType	Price List Type
	TaxDepartureCountry	TaxDepartureCountry	Tax Departure Country/Region
	VATRegistrationCountry	VATRegistrationCountry	Destination Country/Region for Tax Determination
	RequestedDeliveryDate	RequestedDeliveryDate	Requested Delivery Date
	IncotermsClassification	IncotermsClassification	Incoterms (Part 1)
	IncotermsTransferLocation	IncotermsTransferLocation	Incoterms (Part 2)
	IncotermsLocation1	IncotermsLocation1	Incoterms Location 1
	IncotermsLocation2	IncotermsLocation2	Incoterms Location 2
	IncotermsVersion	IncotermsVersion	Incoterms Version
	DeliveryBlockReason	DeliveryBlockReason	Delivery Block (Document Header)
	ShippingType	ShippingType	Shipping Type
	ShippingCondition	ShippingCondition	Shipping Conditions
	CustomerReturnApprovalReason	SalesDocApprovalReason	Approval Request Reason ID
	BillingDocumentDate	BillingDocumentDate	Billing Date
	BillingCompanyCode	BillingCompanyCode	Company Code to Be Billed
	HeaderBillingBlockReason	HeaderBillingBlockReason	Billing Block in SD Document
	CustomerPaymentTerms	CustomerPaymentTerms	Key for Terms of Payment
	PaymentMethod	PaymentMethod	Payment Method
	FixedValueDate	FixedValueDate	Fixed Value Date
	CustomerTaxClassification1	CustomerTaxClassification1	Alternative Tax Classification
	CustomerTaxClassification2	CustomerTaxClassification2	Tax Classification 2 for Customer
	CustomerTaxClassification3	CustomerTaxClassification3	Tax Classification 3 for Customer
	CustomerTaxClassification4	CustomerTaxClassification4	Tax Classification 4 for Customer
	CustomerTaxClassification5	CustomerTaxClassification5	Tax Classification 5 for Customer
	CustomerTaxClassification6	CustomerTaxClassification6	Tax Classification 6 for Customer
	CustomerTaxClassification7	CustomerTaxClassification7	Tax Classification 7 for Customer
	CustomerTaxClassification8	CustomerTaxClassification8	Tax Classification 8 for Customer
	CustomerTaxClassification9	CustomerTaxClassification9	Tax Classification 9 for Customer
	FiscalYear	FiscalYear	G/L Fiscal Year
	FiscalPeriod	FiscalPeriod	Posting Period
	ExchangeRateDate	ExchangeRateDate	Translation Date
	ExchangeRateType	ExchangeRateType	Exchange Rate Type
	BusinessArea	BusinessArea	Business Area
	CustomerAccountAssignmentGroup	CustomerAccountAssignmentGroup	Customer Account Assignment Group
	CostCenterBusinessArea	CostCenterBusinessArea	Business Area from Cost Center
	CostCenter	CostCenter	Cost Center
	ControllingArea	ControllingArea	Controlling Area
	OrderID	OrderID	Order Number
	ControllingObject	ControllingObject	Object Number at Header Level
	ReferenceSDDocument	ReferenceSDDocument	Document Number of Reference Document
	ReferenceSDDocumentCategory	ReferenceSDDocumentCategory	Category of Reference Document
	AccountingDocExternalReference	AccountingDocExternalReference	Reference Document Number
	AssignmentReference	AssignmentReference	Assignment Reference
	OverallSDProcessStatus	OverallSDProcessStatus	Overall Processing Status (Header/All Items)
	OverallSDDocumentRejectionSts	OverallSDDocumentRejectionSts	Rejection Status (All Items)
	TotalBlockStatus	TotalBlockStatus	Overall Block Status (Header)
	OverallTotalDeliveryStatus	OverallTotalDeliveryStatus	Overall Delivery Status (All Items)
	OverallDeliveryStatus	OverallDeliveryStatus	Delivery Status (All Items)
	OverallDeliveryBlockStatus	OverallDeliveryBlockStatus	Delivery Block Status (Item)
	OverallOrdReltdBillgStatus	OverallOrdReltdBillgStatus	Order-Related Billing Status (All Items)
	OverallBillingBlockStatus	OverallBillingBlockStatus	Billing Block Status (All Items)
	OverallTotalSDDocRefStatus	OverallTotalSDDocRefStatus	Overall Reference Status (All Items)
	OverallSDDocReferenceStatus	OverallSDDocReferenceStatus	Reference Status (All Items)
	TotalCreditCheckStatus	TotalCreditCheckStatus	Overall Status of Credit Checks
	MaxDocValueCreditCheckStatus	MaxDocValueCreditCheckStatus	Status of Credit Check Against Maximum Document Value
	PaymentTermCreditCheckStatus	PaymentTermCreditCheckStatus	Status of Credit Check Against Terms of Payment
	FinDocCreditCheckStatus	FinDocCreditCheckStatus	Status of Credit Check Against Financial Document
	ExprtInsurCreditCheckStatus	ExprtInsurCreditCheckStatus	Status of Credit Check Against Export Credit Insurance
	PaytAuthsnCreditCheckSts	PaytAuthsnCreditCheckSts	Status of Credit Check Against Payment Card Authorization
	CentralCreditCheckStatus	CentralCreditCheckStatus	Status of Credit Check SAP Credit Management
	CentralCreditChkTechErrSts	CentralCreditChkTechErrSts	Status of Technical Error SAP Credit Management
	HdrGeneralIncompletionStatus	HdrGeneralIncompletionStatus	Incompletion Status (Header)
	OverallPricingIncompletionSts	OverallPricingIncompletionSts	Pricing Incompletion Status (All Items)
	HeaderDelivIncompletionStatus	HeaderDelivIncompletionStatus	Delivery Incompletion Status (Header)
	HeaderBillgIncompletionStatus	HeaderBillgIncompletionStatus	Billing Incompletion Status (Header)
	OvrlItmGeneralIncompletionSts	OvrlItmGeneralIncompletionSts	Incompletion Status (All Items)
	OvrlItmBillingIncompletionSts	OvrlItmBillingIncompletionSts	Billing Incompletion Status (All Items)
	OvrlItmDelivIncompletionSts	OvrlItmDelivIncompletionSts	Delivery Incompletion Status (All Items)
	SalesDocApprovalStatus	SalesDocApprovalStatus	Document Approval Status
	_Item	_Item
	_Partner	_Partner
	_StandardPartner	_StandardPartner
	_CustomerReturnType	_SalesDocumentType
	_CreatedByUser	_CreatedByUser
	_LastChangedByUser	_LastChangedByUser
	_SalesOrganization	_SalesOrganization
	_DistributionChannel	_DistributionChannel
	_OrganizationDivision	_OrganizationDivision
	_SalesGroup	_SalesGroup
	_SalesOffice	_SalesOffice
	_SoldToParty	_SoldToParty
	_CustomerGroup	_CustomerGroup
	_AdditionalCustomerGroup1	_AdditionalCustomerGroup1
	_AdditionalCustomerGroup2	_AdditionalCustomerGroup2
	_AdditionalCustomerGroup3	_AdditionalCustomerGroup3
	_AdditionalCustomerGroup4	_AdditionalCustomerGroup4
	_AdditionalCustomerGroup5	_AdditionalCustomerGroup5
	_CreditControlArea	_CreditControlArea
	_SDDocumentReason	_SDDocumentReason
	_SDPricingProcedure	_SDPricingProcedure
	_ShippingType	_ShippingType
	_ShippingCondition	_ShippingCondition
	_SalesDistrict	_SalesDistrict
	_RetsMgmtProcess	_RetsMgmtProcess
	_TransactionCurrency	_TransactionCurrency
	_IncotermsClassification	_IncotermsClassification
	_IncotermsVersion	_IncotermsVersion
	_DeliveryBlockReason	_DeliveryBlockReason
	_CustRetApprovalReason	_CustRetApprovalReason
	_BillingCompanyCode	_BillingCompanyCode
	_HeaderBillingBlockReason	_HeaderBillingBlockReason
	_CustomerPaymentTerms	_CustomerPaymentTerms
	_CustomerPurchaseOrderType	_CustomerPurchaseOrderType
	_CustPurOrdTypeByShipToParty	_CustPurOrdTypeByShipToParty
	_ExchangeRateType	_ExchangeRateType
	_BusinessArea	_BusinessArea
	_CustomerAccountAssgmtGroup	_CustomerAccountAssgmtGroup
	_CostCenterBusinessArea	_CostCenterBusinessArea
	_CostCenter	_CostCenter
	_ControllingArea	_ControllingArea
	_ControllingObject	_ControllingObject
	_ReferenceSDDocumentCategory	_ReferenceSDDocumentCategory
	_OverallSDProcessStatus	_OverallSDProcessStatus
	_OverallSDDocumentRejectionSts	_OverallSDDocumentRejectionSts
	_TotalBlockStatus	_TotalBlockStatus
	_OverallTotalDeliveryStatus	_OverallTotalDeliveryStatus
	_OverallDeliveryStatus	_OverallDeliveryStatus
	_OverallDeliveryBlockStatus	_OverallDeliveryBlockStatus
	_OverallOrdReltdBillgStatus	_OverallOrdReltdBillgStatus
	_OverallBillingBlockStatus	_OverallBillingBlockStatus
	_OverallTotalSDDocRefStatus	_OverallTotalSDDocRefStatus
	_OverallSDDocReferenceStatus	_OverallSDDocReferenceStatus
	_TotalCreditCheckStatus	_TotalCreditCheckStatus
	_MaxDocValueCreditCheckStatus	_MaxDocValueCreditCheckStatus
	_PaymentTermCreditCheckStatus	_PaymentTermCreditCheckStatus
	_FinDocCreditCheckStatus	_FinDocCreditCheckStatus
	_ExprtInsurCreditCheckStatus	_ExprtInsurCreditCheckStatus
	_PaytAuthsnCreditCheckSts	_PaytAuthsnCreditCheckSts
	_CentralCreditCheckStatus	_CentralCreditCheckStatus
	_CentralCreditChkTechErrSts	_CentralCreditChkTechErrSts
	_HdrGeneralIncompletionStatus	_HdrGeneralIncompletionStatus
	_OverallPricingIncompletionSts	_OverallPricingIncompletionSts
	_HeaderDelivIncompletionStatus	_HeaderDelivIncompletionStatus
	_HeaderBillgIncompletionStatus	_HeaderBillgIncompletionStatus
	_OvrlItmGeneralIncompletionSts	_OvrlItmGeneralIncompletionSts
	_OvrlItmBillingIncompletionSts	_OvrlItmBillingIncompletionSts
	_OvrlItmDelivIncompletionSts	_OvrlItmDelivIncompletionSts
	_SalesDocApprovalStatus	_SalesDocApprovalStatus

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_CustomerReturn.
-- 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_CustomerReturn AS
SELECT
  cast(SalesDocument as vdm_customer_return preserving type) AS CustomerReturn,
  cast(SalesDocumentType as vdm_customer_return_type preserving type) AS CustomerReturnType,
  CreatedByUser,
  LastChangedByUser,
  CreationDate,
  CreationTime,
  LastChangeDate,
  LastChangeDateTime,
  SenderBusinessSystemName,
  SalesOrganization,
  DistributionChannel,
  OrganizationDivision,
  SalesGroup,
  SalesOffice,
  SoldToParty,
  CustomerGroup,
  AdditionalCustomerGroup1,
  AdditionalCustomerGroup2,
  AdditionalCustomerGroup3,
  AdditionalCustomerGroup4,
  AdditionalCustomerGroup5,
  CreditControlArea,
  SalesDocumentDate AS CustomerReturnDate,
  ServicesRenderedDate,
  SDDocumentReason,
  PurchaseOrderByCustomer,
  CustomerPurchaseOrderType,
  CustPurOrdTypeByShipToParty,
  CustomerPurchaseOrderDate,
  CustomerPurchaseOrderSuplmnt,
  PurchaseOrderByShipToParty,
  CorrespncExternalReference,
  CorrespncExtRefByShipToParty,
  BusinessSolutionOrder,
  SalesDistrict,
  RetsMgmtProcess,
  TotalNetAmount,
  TransactionCurrency,
  PricingDate,
  PriceDetnExchangeRate,
  SDPricingProcedure,
  SalesDocumentCondition AS CustomerReturnCondition,
  CustomerPriceGroup,
  PriceListType,
  TaxDepartureCountry,
  VATRegistrationCountry,
  RequestedDeliveryDate,
  IncotermsClassification,
  IncotermsTransferLocation,
  IncotermsLocation1,
  IncotermsLocation2,
  IncotermsVersion,
  DeliveryBlockReason,
  ShippingType,
  ShippingCondition,
  SalesDocApprovalReason AS CustomerReturnApprovalReason,
  BillingDocumentDate,
  BillingCompanyCode,
  HeaderBillingBlockReason,
  CustomerPaymentTerms,
  PaymentMethod,
  FixedValueDate,
  CustomerTaxClassification1,
  CustomerTaxClassification2,
  CustomerTaxClassification3,
  CustomerTaxClassification4,
  CustomerTaxClassification5,
  CustomerTaxClassification6,
  CustomerTaxClassification7,
  CustomerTaxClassification8,
  CustomerTaxClassification9,
  FiscalYear,
  FiscalPeriod,
  ExchangeRateDate,
  ExchangeRateType,
  BusinessArea,
  CustomerAccountAssignmentGroup,
  CostCenterBusinessArea,
  CostCenter,
  ControllingArea,
  OrderID,
  ControllingObject,
  ReferenceSDDocument,
  ReferenceSDDocumentCategory,
  AccountingDocExternalReference,
  AssignmentReference,
  OverallSDProcessStatus,
  OverallSDDocumentRejectionSts,
  TotalBlockStatus,
  OverallTotalDeliveryStatus,
  OverallDeliveryStatus,
  OverallDeliveryBlockStatus,
  OverallOrdReltdBillgStatus,
  OverallBillingBlockStatus,
  OverallTotalSDDocRefStatus,
  OverallSDDocReferenceStatus,
  TotalCreditCheckStatus,
  MaxDocValueCreditCheckStatus,
  PaymentTermCreditCheckStatus,
  FinDocCreditCheckStatus,
  ExprtInsurCreditCheckStatus,
  PaytAuthsnCreditCheckSts,
  CentralCreditCheckStatus,
  CentralCreditChkTechErrSts,
  HdrGeneralIncompletionStatus,
  OverallPricingIncompletionSts,
  HeaderDelivIncompletionStatus,
  HeaderBillgIncompletionStatus,
  OvrlItmGeneralIncompletionSts,
  OvrlItmBillingIncompletionSts,
  OvrlItmDelivIncompletionSts,
  SalesDocApprovalStatus
FROM I_SalesDocument AS SalesDocument
LEFT OUTER JOIN I_CustomerReturnItem AS _Item ON CustomerReturn = _Item.CustomerReturn  -- association [0..*]
LEFT OUTER JOIN I_RetsMgmtProcess AS _RetsMgmtProcess ON RetsMgmtProcess = _RetsMgmtProcess.RetsMgmtProcess  -- association [0..1]
LEFT OUTER JOIN I_CustomerReturnApprovalReason AS _CustRetApprovalReason ON CustomerReturnApprovalReason = _CustRetApprovalReason.CustomerReturnApprovalReason  -- association [0..1]
LEFT OUTER JOIN E_SalesDocumentBasic AS _Extension ON SalesDocument.SalesDocument = _Extension.SalesDocument  -- association [0..1]
;

Depth:

I_CustomerReturn view

I_SalesDocument view