C_ReturnsReferenceDocumentItem

Return Reference Document Item | view: CRETSREFDOCITM | Extraction: Not supported | Component: Customer Returns
Tables used: VBAP, VBRK, VBRP, VBAK, VBAK, VBAP, VBKD, VEDA, VBAP, T001W, TVAP
Column Name Description
ReturnsReferenceDocument FK Sales Document
ReturnsReferenceDocumentItem Sales Document Item
TargetSalesDocumentType Copying Control: Target Sales Document Type
Column Name Description
💲 SD Document Currency (Currency):
NetAmount Net Value of the Order Item in Document Currency
Column Name Description
📏 Sales unit (OrderQuantityUnit):
OrderQuantity Original Quantity
ReturnableQuantity Returnable Quantity
📏 Sales unit (ReturnQuantityUnit):
ReturnQuantity Cumulative order quantity in sales units
📏 Base Unit of Measure (BaseUnit):
RequestedQuantityInBaseUnit Requested Order Quantity in Base Unit
Column Name Description
DeliveryDate Requested Delivery Date
BOMExplosionDate Key date of the bill of material
Column Name Description
SDDocumentCategory SD Document Category Show values
PricingRelevance Carry out pricing Show values
Column Name Description Domain name
SalesDocumentItem Sales Document Item POSNR
HigherLevelItem Higher-Level Item in Bill of Material Structures POSNR
ProductionPlant Plant (Own or External) WERKS
PlantName Plant Name TEXT30
MaterialByCustomer Material Number Used by Customer IDNEX
BillOfMaterial Bill of Material STNUM
Master Data Relations Join Conditions
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • C_RETURNSREFERENCEDOCUMENTITEM.MANDT == T006.MANDT
  • C_RETURNSREFERENCEDOCUMENTITEM.BASEUNIT == T006.MSEHI
Batch Number
  • Batch Number
  • Client
  • Product Number
  • Plant (Own or External)
  • C_RETURNSREFERENCEDOCUMENTITEM.BATCH == MCHA.CHARG
  • C_RETURNSREFERENCEDOCUMENTITEM.MANDT == MCHA.MANDT
  • C_RETURNSREFERENCEDOCUMENTITEM.MATERIAL == MCHA.MATNR
  • C_RETURNSREFERENCEDOCUMENTITEM.PRODUCTIONPLANT == MCHA.WERKS
SD Document Currency
  • Client
  • SD Document Currency
  • C_RETURNSREFERENCEDOCUMENTITEM.MANDT == TCURC.MANDT
  • C_RETURNSREFERENCEDOCUMENTITEM.CURRENCY == TCURC.WAERS
Distribution channel in order header
  • Client
  • Sales Organization
  • Distribution Channel
  • C_RETURNSREFERENCEDOCUMENTITEM.MANDT == TVKOV.MANDT
  • C_RETURNSREFERENCEDOCUMENTITEM.SALESORGANIZATION == TVKOV.VKORG
  • C_RETURNSREFERENCEDOCUMENTITEM.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
Material: order item
  • Client
  • Product Number
  • C_RETURNSREFERENCEDOCUMENTITEM.MANDT == MARA.MANDT
  • C_RETURNSREFERENCEDOCUMENTITEM.MATERIAL == MARA.MATNR
Product Group
  • Client
  • Product Group
  • C_RETURNSREFERENCEDOCUMENTITEM.MANDT == T023.MANDT
  • C_RETURNSREFERENCEDOCUMENTITEM.MATERIALGROUP == T023.MATKL
Sales unit
  • Client
  • Sales unit
  • Sales unit
  • C_RETURNSREFERENCEDOCUMENTITEM.MANDT == T006.MANDT
  • C_RETURNSREFERENCEDOCUMENTITEM.RETURNQUANTITYUNIT == T006.MSEHI
  • C_RETURNSREFERENCEDOCUMENTITEM.ORDERQUANTITYUNIT == T006.MSEHI
Division in order header
  • Client
  • Division
  • Sales Organization
  • Distribution Channel
  • C_RETURNSREFERENCEDOCUMENTITEM.MANDT == TVTA.MANDT
  • C_RETURNSREFERENCEDOCUMENTITEM.ORGANIZATIONDIVISION == TVTA.SPART
  • C_RETURNSREFERENCEDOCUMENTITEM.SALESORGANIZATION == TVTA.VKORG
  • C_RETURNSREFERENCEDOCUMENTITEM.DISTRIBUTIONCHANNEL == TVTA.VTWEG
Sales unit
  • Client
  • Sales unit
  • Sales unit
  • C_RETURNSREFERENCEDOCUMENTITEM.MANDT == T006.MANDT
  • C_RETURNSREFERENCEDOCUMENTITEM.RETURNQUANTITYUNIT == T006.MSEHI
  • C_RETURNSREFERENCEDOCUMENTITEM.ORDERQUANTITYUNIT == T006.MSEHI
Sales organization in order header
  • Client
  • Sales Organization
  • C_RETURNSREFERENCEDOCUMENTITEM.MANDT == TVKO.MANDT
  • C_RETURNSREFERENCEDOCUMENTITEM.SALESORGANIZATION == TVKO.VKORG
Shipping Point / Receiving Point
  • Client
  • Shipping Point / Receiving Point
  • C_RETURNSREFERENCEDOCUMENTITEM.MANDT == TVST.MANDT
  • C_RETURNSREFERENCEDOCUMENTITEM.SHIPPINGPOINT == TVST.VSTEL