C_ReturnsReferenceDocument

Return Reference Document | view: CRETSREFDOC | Extraction: Not supported | Component: Customer Returns
Tables used: VBRK, VBKD, VEDA, VBAK, VBPA, ADRP, ADCP, ADRC, TVFK, TVFKT, CVI_CUST_CT_LINK, BUT0ID, BUT000, KNVK, KNA1, CVI_CUST_LINK, TVAKZ, TVTA, TVAK, TVAKT, CVI_VEND_LINK, TVBST
Column Name Description
ReturnsReferenceDocument Document number of the reference document
Column Name Description
💲 SD Document Currency (TransactionCurrency):
TotalNetAmount Net Value of the Sales Order in Document Currency
Column Name Description
Column Name Description
DocumentDate Document Date (Date Received/Sent)
PricingDate Date for Pricing and Exchange Rate
Column Name Description
SDDocumentCategory SD Document Category Show values
OverallSDProcessStatus Overall Processing Status (Header/All Items) Show values
Column Name Description Domain name
DocumentTypeName Sales Document Type Description TEXT20
PurchaseOrderByCustomer Customer Reference BSTKD
SoldToPartyName Customer Full Name TEXT220
ShipToPartyName Customer Full Name TEXT220
CreatedByUser Name of Person Responsible for Creating the Object USNAM
ResponsibleEmployee Employee Responsible PERNR
OverallSDProcessStatusDesc Status Description TEXT20
CreateActionIsEnabled null
Master Data Relations Join Conditions
Distribution channel in order header
  • Client
  • Sales Organization
  • Distribution Channel
  • C_RETURNSREFERENCEDOCUMENT.MANDT == TVKOV.MANDT
  • C_RETURNSREFERENCEDOCUMENT.SALESORGANIZATION == TVKOV.VKORG
  • C_RETURNSREFERENCEDOCUMENT.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
Order type in order header
  • Sales Document Type
  • Client
  • C_RETURNSREFERENCEDOCUMENT.DOCUMENTTYPE == TVAK.AUART
  • C_RETURNSREFERENCEDOCUMENT.MANDT == TVAK.MANDT
Division in order header
  • Client
  • Division
  • Sales Organization
  • Distribution Channel
  • C_RETURNSREFERENCEDOCUMENT.MANDT == TVTA.MANDT
  • C_RETURNSREFERENCEDOCUMENT.ORGANIZATIONDIVISION == TVTA.SPART
  • C_RETURNSREFERENCEDOCUMENT.SALESORGANIZATION == TVTA.VKORG
  • C_RETURNSREFERENCEDOCUMENT.DISTRIBUTIONCHANNEL == TVTA.VTWEG
Sales group
  • Sales office
  • Client
  • Sales group
  • C_RETURNSREFERENCEDOCUMENT.SALESOFFICE == TVBVK.VKBUR
  • C_RETURNSREFERENCEDOCUMENT.MANDT == TVBVK.MANDT
  • C_RETURNSREFERENCEDOCUMENT.SALESGROUP == TVBVK.VKGRP
Sales organization in order header
  • Client
  • Sales Organization
  • C_RETURNSREFERENCEDOCUMENT.MANDT == TVKO.MANDT
  • C_RETURNSREFERENCEDOCUMENT.SALESORGANIZATION == TVKO.VKORG
Customer - Document Customer
  • Client
  • Sold-to Party
  • Ship-to Party
  • C_RETURNSREFERENCEDOCUMENT.MANDT == KNA1.MANDT
  • C_RETURNSREFERENCEDOCUMENT.SOLDTOPARTY == KNA1.KUNNR
  • C_RETURNSREFERENCEDOCUMENT.SHIPTOPARTY == KNA1.KUNNR
Sold-to Party
  • Client
  • Sold-to Party
  • Ship-to Party
  • C_RETURNSREFERENCEDOCUMENT.MANDT == KNA1.MANDT
  • C_RETURNSREFERENCEDOCUMENT.SOLDTOPARTY == KNA1.KUNNR
  • C_RETURNSREFERENCEDOCUMENT.SHIPTOPARTY == KNA1.KUNNR
Currency in order header
  • Client
  • SD Document Currency
  • C_RETURNSREFERENCEDOCUMENT.MANDT == TCURC.MANDT
  • C_RETURNSREFERENCEDOCUMENT.TRANSACTIONCURRENCY == TCURC.WAERS
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Sales office
  • Client
  • Division
  • Sales Organization
  • Distribution Channel
  • C_RETURNSREFERENCEDOCUMENT.SALESOFFICE == TVKBZ.VKBUR
  • C_RETURNSREFERENCEDOCUMENT.MANDT == TVKBZ.MANDT
  • C_RETURNSREFERENCEDOCUMENT.ORGANIZATIONDIVISION == TVKBZ.SPART
  • C_RETURNSREFERENCEDOCUMENT.SALESORGANIZATION == TVKBZ.VKORG
  • C_RETURNSREFERENCEDOCUMENT.DISTRIBUTIONCHANNEL == TVKBZ.VTWEG