C_Customerreturnfs

Customer Return Fact Sheet | view: CCUSTRETURNFS | Extraction: Not supported | Component: Customer Returns
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
CustomerPurchaseOrderDate Customer Reference Date
CustomerReturnDate Document Date (Date Received/Sent)
Column Name Description
OverallSDProcessStatus Overall Processing Status (Header/All Items) Show values
OverallSDDocumentRejectionSts Rejection Status (All Items) Show values
OverallTotalDeliveryStatus Overall Delivery Status (All Items) Show values
OverallOrdReltdBillgStatus Order-Related Billing Status (All Items) Show values
SalesDocApprovalStatus Document Approval Status Show values
IsValid Boolean Variable (X = True, - = False, Space = Unknown) Show values
Column Name Description Domain name
SalesDocumentTypeName null
SoldToPartyFullName Full Name of Person TEXT80
CustRetApprvlStsCriticality null
SalesAreaDesc Sales Area TXT_VTRBER
EmployeeName null
ResponsibleEmployeeName Full Name of Person TEXT80
PurchaseOrderByCustomer Customer Reference BSTKD
ShipToPartyFullName Full Name of Person TEXT80
Master Data Relations Join Conditions
Approval Request Reason ID
  • Approval Request Reason ID
  • Client
  • C_CUSTOMERRETURNFS.CUSTOMERRETURNAPPROVALREASON == SDAPMAPRR.APM_APPROVAL_REASON
  • C_CUSTOMERRETURNFS.MANDT == SDAPMAPRR.CLIENT
Order type in order header
  • Client
  • Customer Return Type
  • C_CUSTOMERRETURNFS.MANDT == TVAK.MANDT
  • C_CUSTOMERRETURNFS.CUSTOMERRETURNTYPE == TVAK.AUART
Distribution channel in order header
  • Sales Organization
  • Client
  • Distribution Channel
  • C_CUSTOMERRETURNFS.SALESORGANIZATION == TVKOV.VKORG
  • C_CUSTOMERRETURNFS.MANDT == TVKOV.MANDT
  • C_CUSTOMERRETURNFS.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
Division in order header
  • Sales Organization
  • Client
  • Division
  • Distribution Channel
  • C_CUSTOMERRETURNFS.SALESORGANIZATION == TVTA.VKORG
  • C_CUSTOMERRETURNFS.MANDT == TVTA.MANDT
  • C_CUSTOMERRETURNFS.ORGANIZATIONDIVISION == TVTA.SPART
  • C_CUSTOMERRETURNFS.DISTRIBUTIONCHANNEL == TVTA.VTWEG
Sales organization in order header
  • Sales Organization
  • Client
  • C_CUSTOMERRETURNFS.SALESORGANIZATION == TVKO.VKORG
  • C_CUSTOMERRETURNFS.MANDT == TVKO.MANDT
Customer - Document Customer
  • Client
  • Customer Number
  • Sold-to Party
  • C_CUSTOMERRETURNFS.MANDT == KNA1.MANDT
  • C_CUSTOMERRETURNFS.SHIPTOPARTY == KNA1.KUNNR
  • C_CUSTOMERRETURNFS.SOLDTOPARTY == KNA1.KUNNR
Sold-to Party
  • Client
  • Customer Number
  • Sold-to Party
  • C_CUSTOMERRETURNFS.MANDT == KNA1.MANDT
  • C_CUSTOMERRETURNFS.SHIPTOPARTY == KNA1.KUNNR
  • C_CUSTOMERRETURNFS.SOLDTOPARTY == KNA1.KUNNR
Currency in order header
  • Client
  • SD Document Currency
  • C_CUSTOMERRETURNFS.MANDT == TCURC.MANDT
  • C_CUSTOMERRETURNFS.TRANSACTIONCURRENCY == TCURC.WAERS