C_CustomerReturnWrkflwInbox

DDL: C_CUSTOMERRETURNWRKFLWINBOX Type: view CONSUMPTION Package: ODATA_SD_RETURN_WRF
40 Fields 1 Data Sources 1 Associations

Customer Return Workflow Inbox

C_CustomerReturnWrkflwInbox is a Consumption CDS View that provides data about "Customer Return Workflow Inbox" in SAP S/4HANA. It reads from 1 data source (I_CustomerReturnEnhanced) and exposes 40 fields with key field CustomerReturn. It has 1 association to related views. Part of development package ODATA_SD_RETURN_WRF.

Data Sources (1)

SourceAliasJoin Type
I_CustomerReturnEnhanced CustomerReturn from

Associations (1)

CardinalityTargetAliasCondition
[0..*] C_CustomerReturnItmWrkflwInbox _CustomerReturnItem $projection.CustomerReturn = _CustomerReturnItem.CustomerReturn

Annotations (13)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Customer Return Workflow Inbox view
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName CSDCRWRKFLWIN view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.compositionRoot true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #CONSUMPTION view
UI.headerInfo.title.type #STANDARD view
UI.headerInfo.title.value DocumentTitle view

Fields (40)

KeyFieldSource TableSource FieldDescription
KEY CustomerReturn I_CustomerReturnEnhanced CustomerReturn Return
CustomerReturnType I_CustomerReturnEnhanced CustomerReturnType
CustomerReturn01asDocumentTitle
SoldToPartyName
SoldToParty I_CustomerReturnEnhanced SoldToParty Sold-to Party
ShipToPartyName
ShipToParty CustRetPartner Customer Ship-To Party
CityName City
CountryName
Country Country or Region
PurchaseOrderByCustomer I_CustomerReturnEnhanced PurchaseOrderByCustomer Purchase Order Number
TransactionCurrency I_CustomerReturnEnhanced TransactionCurrency Transaction Currency
TotalNetAmount I_CustomerReturnEnhanced TotalNetAmount Total Net Amount
SDDocumentReasonText
SDDocumentReason I_CustomerReturnEnhanced SDDocumentReason Order Reason
SDApprovalReasonName
CustomerReturnApprovalReason I_CustomerReturnEnhanced CustomerReturnApprovalReason Approval Request Reason
SalesOrganizationName
SalesOrganization I_CustomerReturnEnhanced SalesOrganization Sales Organization
DistributionChannelName
DistributionChannel I_CustomerReturnEnhanced DistributionChannel RefDistCh-Cust/Mat.
DivisionName
OrganizationDivision I_CustomerReturnEnhanced OrganizationDivision Org. Division
UserName
CreatedByUser I_CustomerReturnEnhanced CreatedByUser User Name
CreationDate I_CustomerReturnEnhanced CreationDate Created On
UserDescription
LastChangedByUser I_CustomerReturnEnhanced LastChangedByUser User Name
LastChangeDate I_CustomerReturnEnhanced LastChangeDate Last Changed On
_CustomerReturnItem _CustomerReturnItem
_SoldToParty _SoldToParty
_TransactionCurrency _TransactionCurrency
_SalesOrganization _SalesOrganization
_DistributionChannel _DistributionChannel
_OrganizationDivision _OrganizationDivision
_CustRetApprovalReason _CustRetApprovalReason
_SDDocumentReason _SDDocumentReason
_CustomerReturnType _CustomerReturnType
_CreatedByUser _CreatedByUser
_LastChangedByUser _LastChangedByUser

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_CustomerReturnWrkflwInbox.
-- 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_CustomerReturnWrkflwInbox AS
SELECT
  CustomerReturn.CustomerReturn AS CustomerReturn,
  CustomerReturn.CustomerReturnType AS CustomerReturnType,
  concat_with_space(concat_with_space(CustomerReturn._CustomerReturnType._Text[1: Language=$session.system_language].SalesDocumentTypeName, '-', 1), ltrim(CustomerReturn.CustomerReturn,'0'), 1) as DocumentTitle AS CustomerReturn01asDocumentTitle,
  cast('' as ad_namtext ) AS SoldToPartyName,
  CustomerReturn.SoldToParty AS SoldToParty,
  cast('' as ad_namtext ) AS ShipToPartyName,
  CustRetPartner.Customer AS ShipToParty,
  CustRetPartner._DfltAddrRprstn.CityName AS CityName,
  CustRetPartner._DfltAddrRprstn._Country._Text[1: Language=$session.system_language ].CountryName AS CountryName,
  CustRetPartner._DfltAddrRprstn.Country AS Country,
  CustomerReturn.PurchaseOrderByCustomer AS PurchaseOrderByCustomer,
  CustomerReturn.TransactionCurrency AS TransactionCurrency,
  CustomerReturn.TotalNetAmount AS TotalNetAmount,
  CustomerReturn._SDDocumentReason._Text[1: Language=$session.system_language ].SDDocumentReasonText AS SDDocumentReasonText,
  CustomerReturn.SDDocumentReason AS SDDocumentReason,
  CustomerReturn._CustRetApprovalReason._SDApprovalReasonT[1: Language=$session.system_language ].SDApprovalReasonName AS SDApprovalReasonName,
  CustomerReturn.CustomerReturnApprovalReason AS CustomerReturnApprovalReason,
  CustomerReturn._SalesOrganization._Text[1: Language=$session.system_language ].SalesOrganizationName AS SalesOrganizationName,
  CustomerReturn.SalesOrganization AS SalesOrganization,
  CustomerReturn._DistributionChannel._Text[1: Language=$session.system_language ].DistributionChannelName AS DistributionChannelName,
  CustomerReturn.DistributionChannel AS DistributionChannel,
  CustomerReturn._OrganizationDivision._Text[1: Language=$session.system_language ].DivisionName AS DivisionName,
  CustomerReturn.OrganizationDivision AS OrganizationDivision,
  CustomerReturn._CreatedByUser.UserDescription AS UserName,
  CustomerReturn.CreatedByUser AS CreatedByUser,
  CustomerReturn.CreationDate AS CreationDate,
  CustomerReturn._LastChangedByUser.UserDescription AS UserDescription,
  CustomerReturn.LastChangedByUser AS LastChangedByUser,
  CustomerReturn.LastChangeDate AS LastChangeDate
FROM I_CustomerReturnEnhanced AS CustomerReturn
LEFT OUTER JOIN C_CustomerReturnItmWrkflwInbox AS _CustomerReturnItem ON CustomerReturn = _CustomerReturnItem.CustomerReturn  -- association [0..*]
;

Learn More