C_CustomerReturnRefDocItem

Return Reference Document Item | view: CSDCUSTRETREFITM | Extraction: Not supported | Component: Customer Returns
Tables used: VBAP, VBRK, VBRP, VBKD, VEDA, VBAK, VBAK, VBAP, VBKD, VEDA, VBAP, MARA, T001W, MARA, TVAP
Column Name Description
CustomerReturn Customer Return
ReturnsReferenceDocument FK Sales Document
ReturnsReferenceDocumentItem Sales Document Item
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
Column Name Description
DeliveryDate Requested Delivery Date
BOMExplosionDate Key date of the bill of material
Column Name Description
IsBatchManagementRequired Batch Management Requirement Indicator Show values
PricingRelevance Carry out pricing Show values
Column Name Description Domain name
TargetSalesDocumentType Copying Control: Target Sales Document Type AUART
HigherLevelItem Higher-Level Item in Bill of Material Structures POSNR
SalesDocumentItem Sales Document Item POSNR
SDDocumentCategory SD Document Category
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
Batch Number
  • Product Number
  • Batch Number
  • Client
  • Plant (Own or External)
  • C_CUSTOMERRETURNREFDOCITEM.MATERIAL == MCHA.MATNR
  • C_CUSTOMERRETURNREFDOCITEM.BATCH == MCHA.CHARG
  • C_CUSTOMERRETURNREFDOCITEM.MANDT == MCHA.MANDT
  • C_CUSTOMERRETURNREFDOCITEM.PRODUCTIONPLANT == MCHA.WERKS
SD Document Currency
  • SD Document Currency
  • Client
  • C_CUSTOMERRETURNREFDOCITEM.CURRENCY == TCURC.WAERS
  • C_CUSTOMERRETURNREFDOCITEM.MANDT == TCURC.MANDT
Distribution channel in order header
  • Distribution Channel
  • Client
  • Sales Organization
  • C_CUSTOMERRETURNREFDOCITEM.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • C_CUSTOMERRETURNREFDOCITEM.MANDT == TVKOV.MANDT
  • C_CUSTOMERRETURNREFDOCITEM.SALESORGANIZATION == TVKOV.VKORG
Material: order item
  • Product Number
  • Client
  • C_CUSTOMERRETURNREFDOCITEM.MATERIAL == MARA.MATNR
  • C_CUSTOMERRETURNREFDOCITEM.MANDT == MARA.MANDT
Product Group
  • Product Group
  • Client
  • C_CUSTOMERRETURNREFDOCITEM.MATERIALGROUP == T023.MATKL
  • C_CUSTOMERRETURNREFDOCITEM.MANDT == T023.MANDT
Sales unit
  • Client
  • Sales unit
  • Sales unit
  • C_CUSTOMERRETURNREFDOCITEM.MANDT == T006.MANDT
  • C_CUSTOMERRETURNREFDOCITEM.ORDERQUANTITYUNIT == T006.MSEHI
  • C_CUSTOMERRETURNREFDOCITEM.RETURNQUANTITYUNIT == T006.MSEHI
Division in order header
  • Distribution Channel
  • Client
  • Division
  • Sales Organization
  • C_CUSTOMERRETURNREFDOCITEM.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • C_CUSTOMERRETURNREFDOCITEM.MANDT == TVTA.MANDT
  • C_CUSTOMERRETURNREFDOCITEM.ORGANIZATIONDIVISION == TVTA.SPART
  • C_CUSTOMERRETURNREFDOCITEM.SALESORGANIZATION == TVTA.VKORG
Sales unit
  • Client
  • Sales unit
  • Sales unit
  • C_CUSTOMERRETURNREFDOCITEM.MANDT == T006.MANDT
  • C_CUSTOMERRETURNREFDOCITEM.ORDERQUANTITYUNIT == T006.MSEHI
  • C_CUSTOMERRETURNREFDOCITEM.RETURNQUANTITYUNIT == T006.MSEHI
Sales organization in order header
  • Client
  • Sales Organization
  • C_CUSTOMERRETURNREFDOCITEM.MANDT == TVKO.MANDT
  • C_CUSTOMERRETURNREFDOCITEM.SALESORGANIZATION == TVKO.VKORG
Shipping Point / Receiving Point
  • Client
  • Shipping Point / Receiving Point
  • C_CUSTOMERRETURNREFDOCITEM.MANDT == TVST.MANDT
  • C_CUSTOMERRETURNREFDOCITEM.SHIPPINGPOINT == TVST.VSTEL