C_CustomerReturnWrkflwInbox

Customer Return Workflow Inbox | view: CSDCRWRKFLWIN | TRAN | Extraction: Not supported | Component: Customer Returns
Tables used: MSR_D_HEAD, MSR_D_ITEM, VBKD, VEDA, VBAK, MSR_D_FIN_STATUS, MSR_D_FIN_DETAIL, MSR_D_LOG_STATUS, MSR_D_PLANNED, VBPA, VBPA, ADRP, ADCP, ADRC, CVI_CUST_CT_LINK, BUT0ID, BUT000, ADRP, KNVK, T005, T005T, KNA1, CVI_CUST_LINK, TVTW, TVTWT, TSPA, TSPAT, TVAK, TVAKT, TVKO, TVKOT, SDAPMAPRR_T, TVAU, TVAUT, CVI_VEND_LINK, USR21, SDAPMAPRRCAT
Column Name Description
CustomerReturn Customer Return
Column Name Description
💲 SD Document Currency (TransactionCurrency):
TotalNetAmount Net Value of the Sales Order in Document Currency
Column Name Description
Column Name Description
CreationDate Date on which the record was created
LastChangeDate Last Changed On
Column Name Description
Column Name Description Domain name
DocumentTitle null
CustomerName Name of Customer TEXT80
ShipToPartyName Name of Customer TEXT80
CityName City
CountryName Country/Region Name TEXT50
PurchaseOrderByCustomer Customer Reference BSTKD
SDDocumentReasonText Description TEXT40
SDApprovalReasonName Approval Request Reason SD_APM_APPROVAL_REASON_DESCR
SalesOrganizationName Sales Organization Description TEXT20
DistributionChannelName Distribution Channel Description TEXT20
DivisionName Division Description TEXT20
UserName User Description SUIDTECHDESC
CreatedByUser Name of Person Responsible for Creating the Object USNAM
UserDescription User Description SUIDTECHDESC
LastChangedByUser User Who Last Changed the Business Document USNAM
Master Data Relations Join Conditions
Country key
  • Client
  • Country/Region Key
  • C_CUSTOMERRETURNWRKFLWINBOX.MANDT == T005.MANDT
  • C_CUSTOMERRETURNWRKFLWINBOX.COUNTRY == T005.LAND1
Approval Request Reason ID
  • Approval Request Reason ID
  • Client
  • C_CUSTOMERRETURNWRKFLWINBOX.CUSTOMERRETURNAPPROVALREASON == SDAPMAPRR.APM_APPROVAL_REASON
  • C_CUSTOMERRETURNWRKFLWINBOX.MANDT == SDAPMAPRR.CLIENT
Order type in order header
  • Customer Return Type
  • Client
  • C_CUSTOMERRETURNWRKFLWINBOX.CUSTOMERRETURNTYPE == TVAK.AUART
  • C_CUSTOMERRETURNWRKFLWINBOX.MANDT == TVAK.MANDT
Distribution channel in order header
  • Distribution Channel
  • Client
  • Sales Organization
  • C_CUSTOMERRETURNWRKFLWINBOX.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • C_CUSTOMERRETURNWRKFLWINBOX.MANDT == TVKOV.MANDT
  • C_CUSTOMERRETURNWRKFLWINBOX.SALESORGANIZATION == TVKOV.VKORG
Division in order header
  • Distribution Channel
  • Division
  • Client
  • Sales Organization
  • C_CUSTOMERRETURNWRKFLWINBOX.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • C_CUSTOMERRETURNWRKFLWINBOX.ORGANIZATIONDIVISION == TVTA.SPART
  • C_CUSTOMERRETURNWRKFLWINBOX.MANDT == TVTA.MANDT
  • C_CUSTOMERRETURNWRKFLWINBOX.SALESORGANIZATION == TVTA.VKORG
Sales organization in order header
  • Client
  • Sales Organization
  • C_CUSTOMERRETURNWRKFLWINBOX.MANDT == TVKO.MANDT
  • C_CUSTOMERRETURNWRKFLWINBOX.SALESORGANIZATION == TVKO.VKORG
Order Reason (Reason for the Business Transaction)
  • Order Reason (Reason for the Business Transaction)
  • Client
  • C_CUSTOMERRETURNWRKFLWINBOX.SDDOCUMENTREASON == TVAU.AUGRU
  • C_CUSTOMERRETURNWRKFLWINBOX.MANDT == TVAU.MANDT
Customer - Document Customer
  • Customer Number
  • Sold-to Party
  • Client
  • C_CUSTOMERRETURNWRKFLWINBOX.SHIPTOPARTY == KNA1.KUNNR
  • C_CUSTOMERRETURNWRKFLWINBOX.SOLDTOPARTY == KNA1.KUNNR
  • C_CUSTOMERRETURNWRKFLWINBOX.MANDT == KNA1.MANDT
Sold-to Party
  • Customer Number
  • Sold-to Party
  • Client
  • C_CUSTOMERRETURNWRKFLWINBOX.SHIPTOPARTY == KNA1.KUNNR
  • C_CUSTOMERRETURNWRKFLWINBOX.SOLDTOPARTY == KNA1.KUNNR
  • C_CUSTOMERRETURNWRKFLWINBOX.MANDT == KNA1.MANDT
Currency in order header
  • Client
  • SD Document Currency
  • C_CUSTOMERRETURNWRKFLWINBOX.MANDT == TCURC.MANDT
  • C_CUSTOMERRETURNWRKFLWINBOX.TRANSACTIONCURRENCY == TCURC.WAERS