C_ReturnsReferenceDocVH

Return Reference Document | view: CRETREFDOCVH | Extraction: Not supported | Component: Customer Returns
Column Name Description
ReferenceSDDocument Document number of the reference document
DeliveryDocument FK Delivery
Column Name Description
Column Name Description
Column Name Description
DocumentDate Document Date (Date Received/Sent)
Column Name Description
SDDocumentCategory SD Document Category Show values
Column Name Description Domain name
SDDocumentCategoryName SD Document Category Description DDTEXT
ResponsibleEmployee Employee Responsible PERNR
Master Data Relations Join Conditions
Distribution channel in order header
  • Sales Organization
  • Client
  • Distribution Channel
  • C_RETURNSREFERENCEDOCVH.SALESORGANIZATION == TVKOV.VKORG
  • C_RETURNSREFERENCEDOCVH.MANDT == TVKOV.MANDT
  • C_RETURNSREFERENCEDOCVH.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
Division in order header
  • Sales Organization
  • Client
  • Distribution Channel
  • Division
  • C_RETURNSREFERENCEDOCVH.SALESORGANIZATION == TVTA.VKORG
  • C_RETURNSREFERENCEDOCVH.MANDT == TVTA.MANDT
  • C_RETURNSREFERENCEDOCVH.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • C_RETURNSREFERENCEDOCVH.DIVISION == TVTA.SPART
Sales organization in order header
  • Sales Organization
  • Client
  • C_RETURNSREFERENCEDOCVH.SALESORGANIZATION == TVKO.VKORG
  • C_RETURNSREFERENCEDOCVH.MANDT == TVKO.MANDT
Order type in order header
  • Sales Document Type
  • Client
  • C_RETURNSREFERENCEDOCVH.SDDOCUMENTTYPE == TVAK.AUART
  • C_RETURNSREFERENCEDOCVH.MANDT == TVAK.MANDT
Shipping Point / Receiving Point
  • Client
  • Shipping Point / Receiving Point
  • C_RETURNSREFERENCEDOCVH.MANDT == TVST.MANDT
  • C_RETURNSREFERENCEDOCVH.SHIPPINGPOINT == TVST.VSTEL
Customer - Document Customer
  • Client
  • Sold-to Party
  • Ship-to Party
  • C_RETURNSREFERENCEDOCVH.MANDT == KNA1.MANDT
  • C_RETURNSREFERENCEDOCVH.SOLDTOPARTY == KNA1.KUNNR
  • C_RETURNSREFERENCEDOCVH.SHIPTOPARTY == KNA1.KUNNR
Sold-to Party
  • Client
  • Sold-to Party
  • Ship-to Party
  • C_RETURNSREFERENCEDOCVH.MANDT == KNA1.MANDT
  • C_RETURNSREFERENCEDOCVH.SOLDTOPARTY == KNA1.KUNNR
  • C_RETURNSREFERENCEDOCVH.SHIPTOPARTY == KNA1.KUNNR