C_CustomerReturns_F2200

Customer Returns F2200 | view: CUSTOMERRETURNS | TRAN | Extraction: Not supported | Component: Sales Analytics
Tables used: VBAP, MSR_D_HEAD, MSR_D_ITEM, VBKD, VEDA, VBAK, VBAK, VBAP, VBKD, VEDA, VBAP, MSR_D_FIN_STATUS, MSR_D_FIN_DETAIL, MSR_D_LOG_STATUS, MSR_D_PLANNED, KNA1, T000
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
Column Name Description
OverallDeliveryStatus Delivery Status (All Items) Show values
ReferenceSDDocumentCategory Document Category of Preceding SD Document Show values
OverallSDProcessStatus Overall Processing Status (Header/All Items) Show values
Column Name Description Domain name
CustomerReturnIsReadyForRefund null
OvrlReldForSubsqntProcgSts null
CriticalityCode null
LastChangeDateTime UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TZNTSTMPL
CustomerReturnIsWithinOneWeek null
ReferenceSDDocument Document number of the reference document VBELN
ReferenceDocument null
CustomerName Name of Customer TEXT80
CreatedByUser Name of Person Responsible for Creating the Object USNAM
LastChangedByUser User Who Last Changed the Business Document USNAM
AuthorizationGroup Authorization Group BRGRU
Master Data Relations Join Conditions
Customer Account Group
  • Customer Account Group
  • Client
  • C_CUSTOMERRETURNS_F2200.CUSTOMERACCOUNTGROUP == T077D.KTOKD
  • C_CUSTOMERRETURNS_F2200.MANDT == T077D.MANDT
Customer Classification
  • Customer Classification
  • Client
  • C_CUSTOMERRETURNS_F2200.CUSTOMERCLASSIFICATION == TKUKL.KUKLA
  • C_CUSTOMERRETURNS_F2200.MANDT == TKUKL.MANDT
Order type in order header
  • Customer Return Type
  • Client
  • C_CUSTOMERRETURNS_F2200.CUSTOMERRETURNTYPE == TVAK.AUART
  • C_CUSTOMERRETURNS_F2200.MANDT == TVAK.MANDT
Distribution channel in order header
  • Sales Organization
  • Client
  • Distribution Channel
  • C_CUSTOMERRETURNS_F2200.SALESORGANIZATION == TVKOV.VKORG
  • C_CUSTOMERRETURNS_F2200.MANDT == TVKOV.MANDT
  • C_CUSTOMERRETURNS_F2200.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
Division in order header
  • Division
  • Sales Organization
  • Client
  • Distribution Channel
  • C_CUSTOMERRETURNS_F2200.ORGANIZATIONDIVISION == TVTA.SPART
  • C_CUSTOMERRETURNS_F2200.SALESORGANIZATION == TVTA.VKORG
  • C_CUSTOMERRETURNS_F2200.MANDT == TVTA.MANDT
  • C_CUSTOMERRETURNS_F2200.DISTRIBUTIONCHANNEL == TVTA.VTWEG
Sales group
  • Sales office
  • Client
  • Sales group
  • C_CUSTOMERRETURNS_F2200.SALESOFFICE == TVBVK.VKBUR
  • C_CUSTOMERRETURNS_F2200.MANDT == TVBVK.MANDT
  • C_CUSTOMERRETURNS_F2200.SALESGROUP == TVBVK.VKGRP
Sales organization in order header
  • Sales Organization
  • Client
  • C_CUSTOMERRETURNS_F2200.SALESORGANIZATION == TVKO.VKORG
  • C_CUSTOMERRETURNS_F2200.MANDT == TVKO.MANDT
Sold-to Party
  • Sold-to Party
  • Client
  • C_CUSTOMERRETURNS_F2200.SOLDTOPARTY == KNA1.KUNNR
  • C_CUSTOMERRETURNS_F2200.MANDT == KNA1.MANDT
Currency in order header
  • Client
  • SD Document Currency
  • C_CUSTOMERRETURNS_F2200.MANDT == TCURC.MANDT
  • C_CUSTOMERRETURNS_F2200.TRANSACTIONCURRENCY == TCURC.WAERS
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Division
  • Sales Organization
  • Sales office
  • Client
  • Distribution Channel
  • C_CUSTOMERRETURNS_F2200.ORGANIZATIONDIVISION == TVKBZ.SPART
  • C_CUSTOMERRETURNS_F2200.SALESORGANIZATION == TVKBZ.VKORG
  • C_CUSTOMERRETURNS_F2200.SALESOFFICE == TVKBZ.VKBUR
  • C_CUSTOMERRETURNS_F2200.MANDT == TVKBZ.MANDT
  • C_CUSTOMERRETURNS_F2200.DISTRIBUTIONCHANNEL == TVKBZ.VTWEG