A_CustomerReturnItem

Customer Return Item | view: ACRITEM | TRAN | Extraction: Not supported | Component: Customer Returns
Tables used: VBAP, MSR_D_FIN_DETAIL, MSR_D_FIN_STATUS, MSR_D_LOG_STATUS, MSR_D_EXECUTED, MSR_D_ITEM, MSR_D_NEXTPLANTS, MSR_D_ITEM, VBAK, VBAK, VBAP, VBKD, VEDA, MSR_D_FIN_STATUS, MSR_D_FIN_DETAIL, MSR_D_LOG_STATUS, MSR_D_PLANNED, MSR_I_CHAIN
Column Name Description
CustomerReturn FK Customer Return
CustomerReturnItem Customer Return Item
Column Name Description
💲 SD Document Currency (TransactionCurrency):
NetAmount Net Value of the Order Item in Document Currency
Column Name Description
📏 Unit of the Requested Quantity (RequestedQuantityUnit):
RequestedQuantity Requested Quantity
📏 Weight Unit (ItemWeightUnit):
ItemGrossWeight Gross Weight of the Item
ItemNetWeight Net Weight of the Item
📏 Volume unit (ItemVolumeUnit):
ItemVolume Volume of the item
📏 Replacement Material Unit of Measure (ReplacementMaterialQtyUnit):
ReplacementMaterialQuantity Replacement Material Quantity
Column Name Description
Column Name Description
RetsMgmtProcessingBlock Approval Block Show values
ReturnsRefundType Refund Type Show values
ReturnsRefundProcgMode Refund Processing Mode for a Return Show values
ReturnsTransshipmentPlant Transshipment Plant Show values
RetsMgmtItmLogProcgStatus Logistical Processing Status of a Return Show values
RetsMgmtItmCompnProcgStatus Status of Returns Refund Determination Show values
RetsMgmtItmProcgStatus Processing Status Show values
ReturnsDocumentStatus Status of Document Item Show values
ReturnsDocumentApprovalStatus Approval Status of Returns Process Show values
SDProcessStatus Overall Processing Status (Item) Show values
ReferenceSDDocumentCategory Document Category of Preceding SD Document Show values
SDDocumentRejectionStatus Rejection Status (Item) Show values
Column Name Description Domain name
HigherLevelItem Higher-Level Item in Bill of Material Structures POSNR
CustomerReturnItemText Short text for sales order item TEXT40
PurchaseOrderByCustomer Customer Reference BSTKD
MaterialByCustomer Material Number Used by Customer IDNEX
ProductionPlant Plant (Own or External) WERKS
IncotermsTransferLocation Incoterms (Part 2) INCO2
IncotermsLocation1 Incoterms Location 1 INCO_L
IncotermsLocation2 Incoterms Location 2 INCO_L
CustomerPaymentTerms Terms of payment key ZTERM
ProductTaxClassification1 Tax Classification for Material TAXKD
ProductTaxClassification2 Tax Classification for Material TAXKD
ProductTaxClassification3 Tax Classification for Material TAXKD
ProductTaxClassification4 Tax Classification for Material TAXKD
ProductTaxClassification5 Tax Classification for Material TAXKD
ProductTaxClassification6 Tax Classification for Material TAXKD
ProductTaxClassification7 Tax Classification for Material TAXKD
ProductTaxClassification8 Tax Classification for Material TAXKD
ProductTaxClassification9 Tax Classification for Material TAXKD
ProfitCenter Profit Center PRCTR
RetsMgmtProcess Process Identification Number MSR_PROCESS_ID
RetsMgmtProcessItem Item Number MSR_PROCESS_ITEM
ReturnsMaterialHasBeenReceived null
PrelimRefundIsDetermined null
ReplacementMaterialIsRequested null
ReplacementMatlSupplyingPlant Supplying Plant for Replacement Material WERKS
NextPlantForFollowUpActivity Plant WERKS
Supplier Account Number of Supplier LIFNR
SupplierRetMatlAuthzn Supplier RMA Number MSR_RMA_NR
SuplrRetMatlAuthznIsRequired null
CustomerRetMatlInspResultCode Customer Inspection Code QCODE
NextFllwUpActivityForMatlInsp Default for Next Follow-Up Activity in Material Inspection MSR_FU_CODE
RetMatlInspResultCode Inspection Code QCODE
ProductIsInspectedAtCustSite null
CustRetMatlAuthzn Customer RMA Number MSR_RMA_NR
CRMLogicalSystem CRM Logical System LOGSYS
CRMObjectUUID CRM Object GUID SYCHAR32
CRMObjectID CRM Object ID VBELN
CRMObjectType CRM Object Type CHAR10
ReferenceSDDocument Document number of the reference document VBELN
ReferenceSDDocumentItem Item number of the reference item POSNR
RequirementSegment Requirement Segment SGT_SRCA
Master Data Relations Join Conditions
Batch Number
  • Batch Number
  • Client
  • Material Number
  • Plant (Own or External)
  • A_CUSTOMERRETURNITEM.BATCH == MCHA.CHARG
  • A_CUSTOMERRETURNITEM.MANDT == MCHA.MANDT
  • A_CUSTOMERRETURNITEM.MATERIAL == MCHA.MATNR
  • A_CUSTOMERRETURNITEM.PRODUCTIONPLANT == MCHA.WERKS
Sales document item category
  • Sales document item category
  • Client
  • A_CUSTOMERRETURNITEM.CUSTOMERRETURNITEMCATEGORY == TVPT.PSTYV
  • A_CUSTOMERRETURNITEM.MANDT == TVPT.MANDT
Order type in order header
  • Sales Document Type
  • Client
  • A_CUSTOMERRETURNITEM.CUSTOMERRETURNTYPE == TVAK.AUART
  • A_CUSTOMERRETURNITEM.MANDT == TVAK.MANDT
Follow-Up Activity Code A_CUSTOMERRETURNITEM.CUSTRETITMFOLLOWUPACTIVITY == MSR_I_CODE.FU_CODE
Delivery Priority
  • Delivery Priority
  • Client
  • A_CUSTOMERRETURNITEM.DELIVERYPRIORITY == TPRIO.LPRIO
  • A_CUSTOMERRETURNITEM.MANDT == TPRIO.MANDT
Distribution channel in order header
  • Distribution Channel
  • Sales Organization
  • Client
  • A_CUSTOMERRETURNITEM.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • A_CUSTOMERRETURNITEM.SALESORGANIZATION == TVKOV.VKORG
  • A_CUSTOMERRETURNITEM.MANDT == TVKOV.MANDT
Incoterms (Part 1)
  • Incoterms (Part 1)
  • Client
  • A_CUSTOMERRETURNITEM.INCOTERMSCLASSIFICATION == TINC.INCO1
  • A_CUSTOMERRETURNITEM.MANDT == TINC.MANDT
Billing Block for Item
  • Billing Block for Item
  • Client
  • A_CUSTOMERRETURNITEM.ITEMBILLINGBLOCKREASON == TVFS.FAKSP
  • A_CUSTOMERRETURNITEM.MANDT == TVFS.MANDT
Volume unit
  • Volume unit
  • Client
  • A_CUSTOMERRETURNITEM.ITEMVOLUMEUNIT == T006.MSEHI
  • A_CUSTOMERRETURNITEM.MANDT == T006.MANDT
Weight Unit
  • Weight Unit
  • Client
  • A_CUSTOMERRETURNITEM.ITEMWEIGHTUNIT == T006.MSEHI
  • A_CUSTOMERRETURNITEM.MANDT == T006.MANDT
Material: order item
  • Client
  • Material Number
  • A_CUSTOMERRETURNITEM.MANDT == MARA.MANDT
  • A_CUSTOMERRETURNITEM.MATERIAL == MARA.MATNR
Material Group
  • Material Group
  • Client
  • A_CUSTOMERRETURNITEM.MATERIALGROUP == T023.MATKL
  • A_CUSTOMERRETURNITEM.MANDT == T023.MANDT
Division in order header
  • Distribution Channel
  • Division
  • Sales Organization
  • Client
  • A_CUSTOMERRETURNITEM.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • A_CUSTOMERRETURNITEM.ORGANIZATIONDIVISION == TVTA.SPART
  • A_CUSTOMERRETURNITEM.SALESORGANIZATION == TVTA.VKORG
  • A_CUSTOMERRETURNITEM.MANDT == TVTA.MANDT
Replacement Material
  • Replacement Material
  • Client
  • A_CUSTOMERRETURNITEM.REPLACEMENTMATERIAL == MARA.MATNR
  • A_CUSTOMERRETURNITEM.MANDT == MARA.MANDT
Replacement Material Unit of Measure
  • Replacement Material Unit of Measure
  • Client
  • A_CUSTOMERRETURNITEM.REPLACEMENTMATERIALQTYUNIT == T006.MSEHI
  • A_CUSTOMERRETURNITEM.MANDT == T006.MANDT
Return Reason
  • Return Reason
  • Client
Returns Refund Code
  • Client
  • Returns Refund Code
Rejection Reason for Credit Memo Request
  • Rejection Reason for Credit Memo Request
  • Client
  • A_CUSTOMERRETURNITEM.RETURNSREFUNDRJCNREASON == TVAG.ABGRU
  • A_CUSTOMERRETURNITEM.MANDT == TVAG.MANDT
Reason for Rejection of Sales Documents
  • Reason for Rejection of Sales Documents
  • Client
  • A_CUSTOMERRETURNITEM.SALESDOCUMENTRJCNREASON == TVAG.ABGRU
  • A_CUSTOMERRETURNITEM.MANDT == TVAG.MANDT
Sales organization in order header
  • Sales Organization
  • Client
  • A_CUSTOMERRETURNITEM.SALESORGANIZATION == TVKO.VKORG
  • A_CUSTOMERRETURNITEM.MANDT == TVKO.MANDT
Shipping Point / Receiving Point
  • Shipping Point / Receiving Point
  • Client
  • A_CUSTOMERRETURNITEM.SHIPPINGPOINT == TVST.VSTEL
  • A_CUSTOMERRETURNITEM.MANDT == TVST.MANDT
Shipping Type
  • Client
  • Shipping Type
  • A_CUSTOMERRETURNITEM.MANDT == T173.MANDT
  • A_CUSTOMERRETURNITEM.SHIPPINGTYPE == T173.VSART
Storage location
  • Storage location
  • Client
  • Plant (Own or External)
  • A_CUSTOMERRETURNITEM.STORAGELOCATION == T001L.LGORT
  • A_CUSTOMERRETURNITEM.MANDT == T001L.MANDT
  • A_CUSTOMERRETURNITEM.PRODUCTIONPLANT == T001L.WERKS
SD Document Currency
  • SD Document Currency
  • Client
  • A_CUSTOMERRETURNITEM.TRANSACTIONCURRENCY == TCURC.WAERS
  • A_CUSTOMERRETURNITEM.MANDT == TCURC.MANDT