C_CustomerReturn

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
CustomerReturnDate Document Date (Date Received/Sent)
CreationDate Date on which the record was created
LastChangeDate Last Changed On
Column Name Description
RetsMgmtIsActive Advanced Returns Management Active Show values
ReferenceSDDocumentCategory Document Category of Preceding SD Document Show values
RetsMgmtLogProcgStatus Logistical Processing Status of a Return Show values
OverallDeliveryStatus Overall Delivery Status (All Items) Show values
RetsMgmtCompnProcgStatus Status of Returns Refund Determination Show values
OverallOrdReltdBillgStatus Order-Related Billing Status (All Items) Show values
RetsMgmtProcessingStatus Processing Status Show values
OverallSDProcessStatus Overall Processing Status (Header/All Items) Show values
OvrlReldForSubsqntProcgSts Release Status Show values
OverallSDDocumentRejectionSts Rejection Status (All Items) Show values
WorkflowIsExternal Approval Request Reason Uses External Workflow Show values
SalesDocApprovalStatus Document Approval Status Show values
Column Name Description Domain name
SalesDocumentTypeName Sales Document Type Description TEXT20
SoldToPartyName Sold-To Party Name TEXT80
OrganizationBPName1 Name 1 NAME
OrganizationBPName2 Name 2 NAME
SoldToPartyAddressID Address ADRNR
ReferenceSDDocument Document number of the reference document VBELN
ReferenceDocumentCategoryName Reference Document Category TEXT80
ReturnReason null
CustReturnRefundStatus Refund Progress of Customer Return
SDDocumentReasonText Description TEXT40
SalesDocApprovalStatusDesc Short Text for Fixed Values DDTEXT
CustRetApprvlStsCriticality null
LastChangeDateTime UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TZNTSTMPL
CreatedByUser Name of Person Responsible for Creating the Object USNAM
PurchaseOrderByCustomer Customer Reference BSTKD
SalesAreaDesc Sales Area TXT_VTRBER
SalesArea null
ResponsibleEmployee Employee Responsible PERNR
ShipToPartyName Ship-To Party Name TEXT80
AddressID Address ADRNR
Master Data Relations Join Conditions
Customer Classification
  • Customer Classification
  • Client
  • C_CUSTOMERRETURN.CUSTOMERCLASSIFICATION == TKUKL.KUKLA
  • C_CUSTOMERRETURN.MANDT == TKUKL.MANDT
Order type in order header
  • Customer Return Type
  • Client
  • C_CUSTOMERRETURN.CUSTOMERRETURNTYPE == TVAK.AUART
  • C_CUSTOMERRETURN.MANDT == TVAK.MANDT
Distribution channel in order header
  • Sales Organization
  • Distribution Channel
  • Client
  • C_CUSTOMERRETURN.SALESORGANIZATION == TVKOV.VKORG
  • C_CUSTOMERRETURN.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • C_CUSTOMERRETURN.MANDT == TVKOV.MANDT
Division in order header
  • Division
  • Sales Organization
  • Distribution Channel
  • Client
  • C_CUSTOMERRETURN.ORGANIZATIONDIVISION == TVTA.SPART
  • C_CUSTOMERRETURN.SALESORGANIZATION == TVTA.VKORG
  • C_CUSTOMERRETURN.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • C_CUSTOMERRETURN.MANDT == TVTA.MANDT
Returns Order Reason
  • Returns Order Reason
  • Client
  • C_CUSTOMERRETURN.RETURNSORDERREASON == TVAU.AUGRU
  • C_CUSTOMERRETURN.MANDT == TVAU.MANDT
Sales group
  • Sales group
  • Sales office
  • Client
  • C_CUSTOMERRETURN.SALESGROUP == TVBVK.VKGRP
  • C_CUSTOMERRETURN.SALESOFFICE == TVBVK.VKBUR
  • C_CUSTOMERRETURN.MANDT == TVBVK.MANDT
Sales organization in order header
  • Sales Organization
  • Client
  • C_CUSTOMERRETURN.SALESORGANIZATION == TVKO.VKORG
  • C_CUSTOMERRETURN.MANDT == TVKO.MANDT
Customer - Document Customer
  • Sold-to Party
  • Ship-to Party
  • Client
  • C_CUSTOMERRETURN.SOLDTOPARTY == KNA1.KUNNR
  • C_CUSTOMERRETURN.SHIPTOPARTY == KNA1.KUNNR
  • C_CUSTOMERRETURN.MANDT == KNA1.MANDT
Sold-to Party
  • Sold-to Party
  • Ship-to Party
  • Client
  • C_CUSTOMERRETURN.SOLDTOPARTY == KNA1.KUNNR
  • C_CUSTOMERRETURN.SHIPTOPARTY == KNA1.KUNNR
  • C_CUSTOMERRETURN.MANDT == KNA1.MANDT
Currency in order header
  • SD Document Currency
  • Client
  • C_CUSTOMERRETURN.TRANSACTIONCURRENCY == TCURC.WAERS
  • C_CUSTOMERRETURN.MANDT == TCURC.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Division
  • Sales Organization
  • Sales office
  • Distribution Channel
  • Client
  • C_CUSTOMERRETURN.ORGANIZATIONDIVISION == TVKBZ.SPART
  • C_CUSTOMERRETURN.SALESORGANIZATION == TVKBZ.VKORG
  • C_CUSTOMERRETURN.SALESOFFICE == TVKBZ.VKBUR
  • C_CUSTOMERRETURN.DISTRIBUTIONCHANNEL == TVKBZ.VTWEG
  • C_CUSTOMERRETURN.MANDT == TVKBZ.MANDT