C_CustRetWrkflwEmailTemplate

Email Template for Cust Ret Wrkflw | view: CSDCRWFEMLTMPL | TRAN | Extraction: Not supported | Component: Customer Returns
Column Name Description
WorkflowTaskInternalID Work item ID
Column Name Description
💲 SD Document Currency (TransactionCurrency):
TotalNetAmount Net Value of the Sales Order in Document Currency
Column Name Description
Column Name Description
CustomerReturnDate Document Date (Date Received/Sent)
Column Name Description
WorkflowTaskPriority Priority of a Work Item Show values
WorkflowTaskStatus Processing Status of a Work Item Show values
Column Name Description Domain name
CustomerReturn Customer Return VBELN
SalesOrganizationName Sales Organization Description TEXT20
DistributionChannelName Distribution Channel Description TEXT20
DivisionName Division Description TEXT20
CustomerReturnTypeName Customer Return Type Name TEXT20
SDDocumentReasonText Description TEXT40
CustomerName Name of Customer TEXT80
WorkflowTaskURL Workflow: Workflow Task URL SWF_WORKFLOW_TASK_URL
Master Data Relations Join Conditions
Order type in order header
  • Client
  • Customer Return Type
  • C_CUSTRETWRKFLWEMAILTEMPLATE.MANDT == TVAK.MANDT
  • C_CUSTRETWRKFLWEMAILTEMPLATE.CUSTOMERRETURNTYPE == TVAK.AUART
Distribution channel in order header
  • Client
  • Distribution Channel
  • Sales Organization
  • C_CUSTRETWRKFLWEMAILTEMPLATE.MANDT == TVKOV.MANDT
  • C_CUSTRETWRKFLWEMAILTEMPLATE.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • C_CUSTRETWRKFLWEMAILTEMPLATE.SALESORGANIZATION == TVKOV.VKORG
Division in order header
  • Client
  • Distribution Channel
  • Division
  • Sales Organization
  • C_CUSTRETWRKFLWEMAILTEMPLATE.MANDT == TVTA.MANDT
  • C_CUSTRETWRKFLWEMAILTEMPLATE.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • C_CUSTRETWRKFLWEMAILTEMPLATE.ORGANIZATIONDIVISION == TVTA.SPART
  • C_CUSTRETWRKFLWEMAILTEMPLATE.SALESORGANIZATION == TVTA.VKORG
Sales organization in order header
  • Client
  • Sales Organization
  • C_CUSTRETWRKFLWEMAILTEMPLATE.MANDT == TVKO.MANDT
  • C_CUSTRETWRKFLWEMAILTEMPLATE.SALESORGANIZATION == TVKO.VKORG
Order Reason (Reason for the Business Transaction)
  • Client
  • Order Reason (Reason for the Business Transaction)
  • C_CUSTRETWRKFLWEMAILTEMPLATE.MANDT == TVAU.MANDT
  • C_CUSTRETWRKFLWEMAILTEMPLATE.SDDOCUMENTREASON == TVAU.AUGRU
Sold-to Party
  • Client
  • Sold-to Party
  • C_CUSTRETWRKFLWEMAILTEMPLATE.MANDT == KNA1.MANDT
  • C_CUSTRETWRKFLWEMAILTEMPLATE.SOLDTOPARTY == KNA1.KUNNR
Currency in order header
  • Client
  • SD Document Currency
  • C_CUSTRETWRKFLWEMAILTEMPLATE.MANDT == TCURC.MANDT
  • C_CUSTRETWRKFLWEMAILTEMPLATE.TRANSACTIONCURRENCY == TCURC.WAERS