C_Customer360CustomerReturn

DDL: C_CUSTOMER360CUSTOMERRETURN Type: view_entity CONSUMPTION Package: ODATA_SD_ADVNCD_CUSTOMER360
44 Fields 2 Data Sources 5 Associations 2 OData Services

Customer 360 Customer Return

C_Customer360CustomerReturn is a Consumption CDS View that provides data about "Customer 360 Customer Return" in SAP S/4HANA. It reads from 2 data sources (I_Customer360BusDocSetting, I_CustomerReturn) and exposes 44 fields with key field CustomerReturn. It has 5 associations to related views. It is exposed through 2 OData services (ASQL_F2187A, SD_ADVNCD_CUSTOMER360). Part of development package ODATA_SD_ADVNCD_CUSTOMER360.

Data Sources (2)

SourceAliasJoin Type
I_Customer360BusDocSetting Customer360BusDocSetting inner
I_CustomerReturn CustomerReturn from

Associations (5)

CardinalityTargetAliasCondition
[0..1] I_RetsMgmtCompnProcgStatus _RetsMgmtCompnProcgStatus $projection.retsmgmtcompnprocgstatus = _RetsMgmtCompnProcgStatus.RetsMgmtCompnProcgStatus
[0..1] I_RetsMgmtProcgStatus _RetsMgmtProcgStatus $projection.retsmgmtlogprocgstatus = _RetsMgmtProcgStatus.RetsMgmtProcessingStatus
[0..1] C_SalesDocumentUserVH _CreatedByUser $projection.CreatedByUser = _CreatedByUser.UserID
[0..1] C_SalesDocumentUserVH _LastChangedByUser $projection.LastChangedByUser = _LastChangedByUser.UserID
[0..1] E_SalesDocumentBasic _Extension $projection.CustomerReturn = _Extension.SalesDocument

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Customer 360 Customer Return view
Metadata.ignorePropagatedAnnotations true view
Search.searchable true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
Metadata.allowExtensions true view
VDM.viewType #CONSUMPTION view

OData Services (2)

ServiceBindingVersionContractRelease
ASQL_F2187A ASQL_F2187A C2 NOT_RELEASED
SD_ADVNCD_CUSTOMER360 SD_ADVNCD_CUSTOMER360 V4 C1 NOT_RELEASED

Fields (44)

KeyFieldSource TableSource FieldDescription
KEY CustomerReturn I_CustomerReturn CustomerReturn
SoldToParty I_CustomerReturn SoldToParty Sold-to Party
RetsMgmtProcess I_CustomerReturn RetsMgmtProcess
CreationDate I_CustomerReturn CreationDate Time Stamp
CustomerReturnDate I_CustomerReturn CustomerReturnDate Document Date
PurchaseOrderByCustomer I_CustomerReturn PurchaseOrderByCustomer Purchase Order Number
RetsMgmtCompnProcgStatus
RetsMgmtCompnProcgStatusDesc
RetsMgmtLogProcgStatus
RetsMgmtProcessingStatusDesc
TotalNetAmount I_CustomerReturn TotalNetAmount Total Net Amount
TransactionCurrency I_CustomerReturn TransactionCurrency Transaction Currency
CurrencyName
CustomerReturnType I_CustomerReturn CustomerReturnType
SalesDocumentTypeName
ReferenceSDDocument I_CustomerReturn ReferenceSDDocument Reference Doc.
SalesOrganization I_CustomerReturn SalesOrganization Sales Organization
SalesOrganizationName
DistributionChannel I_CustomerReturn DistributionChannel RefDistCh-Cust/Mat.
DistributionChannelName
OrganizationDivision I_CustomerReturn OrganizationDivision Org. Division
DivisionName
SalesOffice I_CustomerReturn SalesOffice Sales Office
SalesOfficeName
SalesGroup I_CustomerReturn SalesGroup Sales Group
SalesGroupName
OverallSDProcessStatus I_CustomerReturn OverallSDProcessStatus
OverallSDProcessStatusDesc
CreatedByUser I_CustomerReturn CreatedByUser User Name
CreatedByUserDescription
LastChangedByUser I_CustomerReturn LastChangedByUser User Name
LastChangedByUserDescription
_RetsMgmtCompnProcgStatus _RetsMgmtCompnProcgStatus
_RetsMgmtProcgStatus _RetsMgmtProcgStatus
_CustomerReturnType I_CustomerReturn _CustomerReturnType
_OverallSDProcessStatus I_CustomerReturn _OverallSDProcessStatus
_SalesOrganization I_CustomerReturn _SalesOrganization
_DistributionChannel I_CustomerReturn _DistributionChannel
_OrganizationDivision I_CustomerReturn _OrganizationDivision
_SalesOffice I_CustomerReturn _SalesOffice
_SalesGroup I_CustomerReturn _SalesGroup
_CreatedByUser _CreatedByUser
_LastChangedByUser _LastChangedByUser
_TransactionCurrency I_CustomerReturn _TransactionCurrency

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 C_Customer360CustomerReturn.
-- 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 C_Customer360CustomerReturn AS
SELECT
  CustomerReturn.CustomerReturn AS CustomerReturn,
  CustomerReturn.SoldToParty AS SoldToParty,
  CustomerReturn.RetsMgmtProcess AS RetsMgmtProcess,
  CustomerReturn.CreationDate AS CreationDate,
  CustomerReturn.CustomerReturnDate AS CustomerReturnDate,
  CustomerReturn.PurchaseOrderByCustomer AS PurchaseOrderByCustomer,
  CustomerReturn._RetsMgmtProcess._RetsMgmtProcessingStatus.RetsMgmtCompnProcgStatus AS RetsMgmtCompnProcgStatus,
  CustomerReturn._RetsMgmtProcess._RetsMgmtProcessingStatus._RetsMgmtCompnProcgStatus._Text[1:Language = $session.system_language].RetsMgmtCompnProcgStatusDesc AS RetsMgmtCompnProcgStatusDesc,
  CustomerReturn._RetsMgmtProcess._RetsMgmtProcessingStatus.RetsMgmtLogProcgStatus AS RetsMgmtLogProcgStatus,
  CustomerReturn._RetsMgmtProcess._RetsMgmtProcessingStatus._RetsMgmtLogProcgStatus._Text[1:Language = $session.system_language].RetsMgmtProcessingStatusDesc AS RetsMgmtProcessingStatusDesc,
  CustomerReturn.TotalNetAmount AS TotalNetAmount,
  CustomerReturn.TransactionCurrency AS TransactionCurrency,
  CustomerReturn._TransactionCurrency._Text[1:Language = $session.system_language].CurrencyName AS CurrencyName,
  CustomerReturn.CustomerReturnType AS CustomerReturnType,
  CustomerReturn._CustomerReturnType._Text[1:Language = $session.system_language].SalesDocumentTypeName AS SalesDocumentTypeName,
  CustomerReturn.ReferenceSDDocument AS ReferenceSDDocument,
  CustomerReturn.SalesOrganization AS SalesOrganization,
  CustomerReturn._SalesOrganization._Text[1:Language = $session.system_language].SalesOrganizationName AS SalesOrganizationName,
  CustomerReturn.DistributionChannel AS DistributionChannel,
  CustomerReturn._DistributionChannel._Text[1:Language = $session.system_language].DistributionChannelName AS DistributionChannelName,
  CustomerReturn.OrganizationDivision AS OrganizationDivision,
  CustomerReturn._OrganizationDivision._Text[1:Language = $session.system_language].DivisionName AS DivisionName,
  CustomerReturn.SalesOffice AS SalesOffice,
  CustomerReturn._SalesOffice._Text[1:Language = $session.system_language].SalesOfficeName AS SalesOfficeName,
  CustomerReturn.SalesGroup AS SalesGroup,
  CustomerReturn._SalesGroup._Text[1:Language = $session.system_language].SalesGroupName AS SalesGroupName,
  CustomerReturn.OverallSDProcessStatus AS OverallSDProcessStatus,
  CustomerReturn._OverallSDProcessStatus._Text[1:Language = $session.system_language].OverallSDProcessStatusDesc AS OverallSDProcessStatusDesc,
  CustomerReturn.CreatedByUser AS CreatedByUser,
  CustomerReturn._CreatedByUser.UserDescription AS CreatedByUserDescription,
  CustomerReturn.LastChangedByUser AS LastChangedByUser,
  CustomerReturn._LastChangedByUser.UserDescription AS LastChangedByUserDescription,
  CustomerReturn._CustomerReturnType AS _CustomerReturnType,
  CustomerReturn._OverallSDProcessStatus AS _OverallSDProcessStatus,
  CustomerReturn._SalesOrganization AS _SalesOrganization,
  CustomerReturn._DistributionChannel AS _DistributionChannel,
  CustomerReturn._OrganizationDivision AS _OrganizationDivision,
  CustomerReturn._SalesOffice AS _SalesOffice,
  CustomerReturn._SalesGroup AS _SalesGroup,
  CustomerReturn._TransactionCurrency AS _TransactionCurrency
FROM I_CustomerReturn AS CustomerReturn
INNER JOIN I_Customer360BusDocSetting AS Customer360BusDocSetting ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_RetsMgmtCompnProcgStatus AS _RetsMgmtCompnProcgStatus ON retsmgmtcompnprocgstatus = _RetsMgmtCompnProcgStatus.RetsMgmtCompnProcgStatus  -- association [0..1]
LEFT OUTER JOIN I_RetsMgmtProcgStatus AS _RetsMgmtProcgStatus ON retsmgmtlogprocgstatus = _RetsMgmtProcgStatus.RetsMgmtProcessingStatus  -- association [0..1]
LEFT OUTER JOIN C_SalesDocumentUserVH AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN C_SalesDocumentUserVH AS _LastChangedByUser ON LastChangedByUser = _LastChangedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN E_SalesDocumentBasic AS _Extension ON CustomerReturn = _Extension.SalesDocument  -- association [0..1]
;

Learn More