I_CustomerReturnItemEnhanced

Customer Return Item Enhanced | view: ISDCRITMENHANCED | ATTR | 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
NetPriceAmount Net Price
TaxAmount Tax Amount in Document Currency
CostAmount Cost in Document Currency
Subtotal1Amount Subtotal 1 from Pricing Procedure for Price Element
Subtotal2Amount Subtotal 2 from Pricing Procedure for Price Element
Subtotal3Amount Subtotal 3 from Pricing Procedure for Price Element
Subtotal4Amount Subtotal 4 from Pricing Procedure for Price Element
Subtotal5Amount Subtotal 5 from Pricing Procedure for Price Element
Subtotal6Amount Subtotal 6 from Pricing Procedure for Price Element
Column Name Description
📏 Sales unit (OrderQuantityUnit):
OrderQuantity Cumulative order quantity in sales units
ConfdDelivQtyInOrderQtyUnit Cumulative Confirmed Quantity in Sales Unit
TargetDelivQtyInOrderQtyUnit Cumulative Required Delivery Qty (All Dlv-Relev.Sched.Lines)
📏 Base Unit of Measure (BaseUnit):
ConfdDeliveryQtyInBaseUnit Cumulative Confirmed Quantity in Base Unit
RequestedQuantityInBaseUnit Requested Order Quantity in Base Unit
MinDeliveryQtyInBaseUnit Minimum Delivery Quantity in Delivery Note Processing
📏 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
CreationDate Date on which the record was created
CreationTime Time at Which Record Was Created
LastChangeDate Last Changed On
BOMExplosionDate Key date of the bill of material
ServicesRenderedDate Date on which services are rendered
ExchangeRateDate Translation date
BillingDocumentDate Billing Date
Column Name Description
CustomerReturnItemType Item Type Show values
IsReturnsItem Returns Item Show values
StatisticalValueControl Statistical Values Show values
DeliveryDateQuantityIsFixed Delivery Date and Quantity Fixed Show values
PartialDeliveryIsAllowed Partial Delivery at Item Level Show values
UnlimitedOverdeliveryIsAllowed Unlimited Overdelivery Allowed Show values
ItemIsDeliveryRelevant Item Is Relevant for Delivery Show values
ItemIsBillingRelevant Relevant for Billing Show values
ReferenceSDDocumentCategory Document Category of Preceding SD Document Show values
RetsMgmtProcessingBlock Approval Block Show values
RetsMgmtItmLogProcgStatus Logistical Processing Status of a Return Show values
RetsMgmtItmCompnProcgStatus Status of Returns Refund Determination Show values
RetsMgmtItmProcgStatus Processing Status Show values
ReturnsDocumentType Document Type Show values
ReturnsReferenceDocumentType Document Type Show values
ReturnsDocumentStatus Status of Document Item Show values
ReturnsDocumentApprovalStatus Approval Status of Returns Process Show values
ReturnsTransshipmentPlant Transshipment Plant Show values
ReturnsRefundType Refund Type Show values
ReturnsRefundProcgMode Refund Processing Mode for a Return Show values
SDProcessStatus Overall Processing Status (Item) Show values
TotalDeliveryStatus Overall Delivery Status (Item) Show values
DeliveryStatus Delivery Status (Item) Show values
DeliveryBlockStatus Delivery Block Status (Item) Show values
OrderRelatedBillingStatus Order-Related Billing Status (Item) Show values
BillingBlockStatus Billing Block Status (Item) Show values
ItemGeneralIncompletionStatus Incompletion Status (Item) Show values
ItemBillingIncompletionStatus Billing Incompletion Status (Item) Show values
PricingIncompletionStatus Pricing Incompletion Status (Item) Show values
ItemDeliveryIncompletionStatus Delivery Incompletion Status (Item) Show values
SDDocumentRejectionStatus Rejection Status (Item) Show values
TotalSDDocReferenceStatus Overall Reference Status (Item) Show values
Column Name Description Domain name
CustomerReturnItemUUID GUID in 'CHAR' Format in Uppercase SYSUUID_C
CreatedByUser Name of Person Responsible for Creating the Object USNAM
MaterialByCustomer Material Number Used by Customer IDNEX
InternationalArticleNumber International Article Number (EAN/UPC) EAN11
Plant Plant (Own or External) WERKS
ProductConfiguration Configuration CUOBJ
BillOfMaterial Bill of Material STNUM
CustomerReturnItemText Short text for sales order item TEXT40
PurchaseOrderByCustomer Customer Reference BSTKD
OrderToBaseQuantityDnmntr Denominator (divisor) for conversion of sales Qty into SKU UMBSN
OrderToBaseQuantityNmrtr Numerator (factor) for conversion of sales quantity into SKU UMBSZ
PriceDetnExchangeRate Exchange Rate for Price Determination KURRF_NOT_CONVERTED
NetPriceQuantity Condition Pricing Unit KPEIN
MaxNmbrOfPartialDelivery Number of Allowed Partial Deliveries ANTLF
OverdelivTolrtdLmtRatioInPct Overdelivery Tolerance PRZ21
UnderdelivTolrtdLmtRatioInPct Underdelivery Tolerance PRZ21
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
FiscalYear Fiscal Year GJAHR
FiscalPeriod Posting period POPER
ProfitCenter Profit Center PRCTR
ProfitabilitySegment Deprecated: Profitability Segment RKEOBJNR_NUMC
ProfitabilitySegment_2 Profitability Segment RKEOBJNR_CHAR
OriginSDDocument Originating Document VBELN
OriginSDDocumentItem Originating Item POSNR
ReferenceSDDocument Document number of the reference document VBELN
ReferenceSDDocumentItem Item number of the reference item POSNR
HigherLevelItem Higher-Level Item in Bill of Material Structures POSNR
RetsMgmtProcess Process Identification Number MSR_PROCESS_ID
RetsMgmtProcessItem Item Number MSR_PROCESS_ITEM
CustRetMatlAuthzn Customer RMA Number MSR_RMA_NR
CustomerRetMatlInspResultCode Customer Inspection Code QCODE
NextFllwUpActivityForMatlInsp Default for Next Follow-Up Activity in Material Inspection MSR_FU_CODE
CRMLogicalSystem CRM Logical System LOGSYS
CRMObjectUUID CRM Object GUID SYCHAR32
CRMObjectID CRM Object ID VBELN
CRMObjectType CRM Object Type CHAR10
RetsMgmtProcItmQtySplit Split Identification Number MSR_SPLIT_ID
ReturnsDocument Document Number MSR_DOC_NR
ReturnsDocumentItem Document Item MSR_DOC_ITEM
ReturnsReferenceDocument Document Number MSR_DOC_NR
ReturnsReferenceDocumentItem Document Item MSR_DOC_ITEM
ReturnsMaterialHasBeenReceived null
NextPlantForFollowUpActivity Plant WERKS
PrelimRefundIsDetermined null
ReplacementMaterialIsRequested null
ReplacementMatlSupplyingPlant Supplying Plant for Replacement Material WERKS
Supplier Account Number of Supplier LIFNR
AddressID Address Number AD_ADDRNUM
SupplierRetMatlAuthzn Supplier RMA Number MSR_RMA_NR
SuplrRetMatlAuthznIsRequired null
RetMatlInspResultCode Inspection Code QCODE
ProductIsInspectedAtCustSite null
RequirementSegment Requirement Segment SGT_SRCA
Master Data Relations Join Conditions
Material Group 1
  • Client
  • Material Group 1
  • I_CUSTOMERRETURNITEMENHANCED.MANDT == TVM1.MANDT
  • I_CUSTOMERRETURNITEMENHANCED.ADDITIONALMATERIALGROUP1 == TVM1.MVGR1
Material Group 2
  • Client
  • Material Group 2
  • I_CUSTOMERRETURNITEMENHANCED.MANDT == TVM2.MANDT
  • I_CUSTOMERRETURNITEMENHANCED.ADDITIONALMATERIALGROUP2 == TVM2.MVGR2
Material Group 3
  • Client
  • Material Group 3
  • I_CUSTOMERRETURNITEMENHANCED.MANDT == TVM3.MANDT
  • I_CUSTOMERRETURNITEMENHANCED.ADDITIONALMATERIALGROUP3 == TVM3.MVGR3
Material Group 4
  • Client
  • Material Group 4
  • I_CUSTOMERRETURNITEMENHANCED.MANDT == TVM4.MANDT
  • I_CUSTOMERRETURNITEMENHANCED.ADDITIONALMATERIALGROUP4 == TVM4.MVGR4
Material Group 5
  • Client
  • Material Group 5
  • I_CUSTOMERRETURNITEMENHANCED.MANDT == TVM5.MANDT
  • I_CUSTOMERRETURNITEMENHANCED.ADDITIONALMATERIALGROUP5 == TVM5.MVGR5
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • I_CUSTOMERRETURNITEMENHANCED.MANDT == T006.MANDT
  • I_CUSTOMERRETURNITEMENHANCED.BASEUNIT == T006.MSEHI
Batch Number
  • Client
  • Batch Number
  • Product Number
  • Material Number
  • Plant (Own or External)
  • I_CUSTOMERRETURNITEMENHANCED.MANDT == MCHA.MANDT
  • I_CUSTOMERRETURNITEMENHANCED.BATCH == MCHA.CHARG
  • I_CUSTOMERRETURNITEMENHANCED.PRODUCT == MCHA.MATNR
  • I_CUSTOMERRETURNITEMENHANCED.MATERIAL == MCHA.MATNR
  • I_CUSTOMERRETURNITEMENHANCED.PLANT == MCHA.WERKS
Business Area
  • Business Area
  • Client
  • I_CUSTOMERRETURNITEMENHANCED.BUSINESSAREA == TGSB.GSBER
  • I_CUSTOMERRETURNITEMENHANCED.MANDT == TGSB.MANDT
Account Assignment Group for this Customer
  • Account Assignment Group for this Customer
  • Client
  • I_CUSTOMERRETURNITEMENHANCED.CUSTOMERACCOUNTASSIGNMENTGROUP == TVKT.KTGRD
  • I_CUSTOMERRETURNITEMENHANCED.MANDT == TVKT.MANDT
Customer Group
  • Client
  • Customer Group
  • I_CUSTOMERRETURNITEMENHANCED.MANDT == T151.MANDT
  • I_CUSTOMERRETURNITEMENHANCED.CUSTOMERGROUP == T151.KDGRP
Sales document item category
  • Client
  • Sales document item category
  • I_CUSTOMERRETURNITEMENHANCED.MANDT == TVPT.MANDT
  • I_CUSTOMERRETURNITEMENHANCED.CUSTOMERRETURNITEMCATEGORY == TVPT.PSTYV
Chain Identification Number I_CUSTOMERRETURNITEMENHANCED.CUSTRETITMCHAINID == MSR_I_CHAIN.CHAIN_ID
Follow-Up Activity Code I_CUSTOMERRETURNITEMENHANCED.CUSTRETITMFOLLOWUPACTIVITY == MSR_I_CODE.FU_CODE
Delivery Priority
  • Client
  • Delivery Priority
  • I_CUSTOMERRETURNITEMENHANCED.MANDT == TPRIO.MANDT
  • I_CUSTOMERRETURNITEMENHANCED.DELIVERYPRIORITY == TPRIO.LPRIO
Division
  • Client
  • Division
  • I_CUSTOMERRETURNITEMENHANCED.MANDT == TSPA.MANDT
  • I_CUSTOMERRETURNITEMENHANCED.DIVISION == TSPA.SPART
Incoterms (Part 1)
  • Client
  • Incoterms (Part 1)
  • I_CUSTOMERRETURNITEMENHANCED.MANDT == TINC.MANDT
  • I_CUSTOMERRETURNITEMENHANCED.INCOTERMSCLASSIFICATION == TINC.INCO1
Incoterms Version
  • Incoterms Version
  • Client
  • I_CUSTOMERRETURNITEMENHANCED.INCOTERMSVERSION == TINCV.INCOV
  • I_CUSTOMERRETURNITEMENHANCED.MANDT == TINCV.MANDT
Special Stock Indicator
  • Client
  • Special Stock Indicator
  • I_CUSTOMERRETURNITEMENHANCED.MANDT == T148.MANDT
  • I_CUSTOMERRETURNITEMENHANCED.INVENTORYSPECIALSTOCKTYPE == T148.SOBKZ
Billing Block for Item
  • Client
  • Billing Block for Item
  • I_CUSTOMERRETURNITEMENHANCED.MANDT == TVFS.MANDT
  • I_CUSTOMERRETURNITEMENHANCED.ITEMBILLINGBLOCKREASON == TVFS.FAKSP
Volume unit
  • Client
  • Volume unit
  • I_CUSTOMERRETURNITEMENHANCED.MANDT == T006.MANDT
  • I_CUSTOMERRETURNITEMENHANCED.ITEMVOLUMEUNIT == T006.MSEHI
Weight Unit
  • Weight Unit
  • Client
  • I_CUSTOMERRETURNITEMENHANCED.ITEMWEIGHTUNIT == T006.MSEHI
  • I_CUSTOMERRETURNITEMENHANCED.MANDT == T006.MANDT
Material: order item
  • Client
  • Product Number
  • Material Number
  • I_CUSTOMERRETURNITEMENHANCED.MANDT == MARA.MANDT
  • I_CUSTOMERRETURNITEMENHANCED.PRODUCT == MARA.MATNR
  • I_CUSTOMERRETURNITEMENHANCED.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Product Group
  • Material Group
  • I_CUSTOMERRETURNITEMENHANCED.MANDT == T023.MANDT
  • I_CUSTOMERRETURNITEMENHANCED.PRODUCTGROUP == T023.MATKL
  • I_CUSTOMERRETURNITEMENHANCED.MATERIALGROUP == T023.MATKL
Condition Unit
  • Condition Unit
  • Client
  • I_CUSTOMERRETURNITEMENHANCED.NETPRICEQUANTITYUNIT == T006.MSEHI
  • I_CUSTOMERRETURNITEMENHANCED.MANDT == T006.MANDT
Order Number
  • Client
  • Order Number
  • I_CUSTOMERRETURNITEMENHANCED.MANDT == AUFK.MANDT
  • I_CUSTOMERRETURNITEMENHANCED.ORDERID == AUFK.AUFNR
Sales unit
  • Client
  • Sales unit
  • I_CUSTOMERRETURNITEMENHANCED.MANDT == T006.MANDT
  • I_CUSTOMERRETURNITEMENHANCED.ORDERQUANTITYUNIT == T006.MSEHI
Material Entered
  • Client
  • Material Entered
  • I_CUSTOMERRETURNITEMENHANCED.MANDT == MARA.MANDT
  • I_CUSTOMERRETURNITEMENHANCED.ORIGINALLYREQUESTEDMATERIAL == MARA.MATNR
Payment Method
  • ?
  • Client
  • Payment Method
  • I_CUSTOMERRETURNITEMENHANCED.[column in domain "LAND1"] == T042Z.LAND1
  • I_CUSTOMERRETURNITEMENHANCED.MANDT == T042Z.MANDT
  • I_CUSTOMERRETURNITEMENHANCED.PAYMENTMETHOD == T042Z.ZLSCH
Material: order item
  • Client
  • Product Number
  • Material Number
  • I_CUSTOMERRETURNITEMENHANCED.MANDT == MARA.MANDT
  • I_CUSTOMERRETURNITEMENHANCED.PRODUCT == MARA.MATNR
  • I_CUSTOMERRETURNITEMENHANCED.MATERIAL == MARA.MATNR
Product Catalog
  • Client
  • Product catalog number
  • I_CUSTOMERRETURNITEMENHANCED.MANDT == WWMI.MANDT
  • I_CUSTOMERRETURNITEMENHANCED.PRODUCTCATALOG == WWMI.WMINR
Product Group
  • Client
  • Product Group
  • Material Group
  • I_CUSTOMERRETURNITEMENHANCED.MANDT == T023.MANDT
  • I_CUSTOMERRETURNITEMENHANCED.PRODUCTGROUP == T023.MATKL
  • I_CUSTOMERRETURNITEMENHANCED.MATERIALGROUP == T023.MATKL
Product hierarchy: order item
  • Client
  • Product hierarchy
  • I_CUSTOMERRETURNITEMENHANCED.MANDT == T179.MANDT
  • I_CUSTOMERRETURNITEMENHANCED.PRODUCTHIERARCHYNODE == T179.PRODH
Replacement Material
  • Client
  • Replacement Material
  • I_CUSTOMERRETURNITEMENHANCED.MANDT == MARA.MANDT
  • I_CUSTOMERRETURNITEMENHANCED.REPLACEMENTMATERIAL == MARA.MATNR
Replacement Material Unit of Measure
  • Client
  • Replacement Material Unit of Measure
  • I_CUSTOMERRETURNITEMENHANCED.MANDT == T006.MANDT
  • I_CUSTOMERRETURNITEMENHANCED.REPLACEMENTMATERIALQTYUNIT == T006.MSEHI
Step ID I_CUSTOMERRETURNITEMENHANCED.RETSMGMTPROCESSSTEP == MSR_I_STEP.STEP_ID
Sequence Identification Number I_CUSTOMERRETURNITEMENHANCED.RETSMGMTPROCITMEXECTDSEQUENCE == MSR_I_SEQ.SEQ_ID
Return Reason
  • Client
  • Return Reason
Returns Refund Code
  • Client
  • Returns Refund Code
Rejection Reason for Credit Memo Request
  • Client
  • Rejection Reason for Credit Memo Request
  • I_CUSTOMERRETURNITEMENHANCED.MANDT == TVAG.MANDT
  • I_CUSTOMERRETURNITEMENHANCED.RETURNSREFUNDRJCNREASON == TVAG.ABGRU
Route
  • Client
  • Route
  • I_CUSTOMERRETURNITEMENHANCED.MANDT == TVRO.MANDT
  • I_CUSTOMERRETURNITEMENHANCED.ROUTE == TVRO.ROUTE
Sales Deal
  • Sales Deal
  • Client
  • I_CUSTOMERRETURNITEMENHANCED.SALESDEAL == KONA.KNUMA
  • I_CUSTOMERRETURNITEMENHANCED.MANDT == KONA.MANDT
Sales District
  • Client
  • Sales District
  • I_CUSTOMERRETURNITEMENHANCED.MANDT == T171.MANDT
  • I_CUSTOMERRETURNITEMENHANCED.SALESDISTRICT == T171.BZIRK
Reason for Rejection of Sales Documents
  • Reason for Rejection of Sales Documents
  • Client
  • I_CUSTOMERRETURNITEMENHANCED.SALESDOCUMENTRJCNREASON == TVAG.ABGRU
  • I_CUSTOMERRETURNITEMENHANCED.MANDT == TVAG.MANDT
Shipping Point / Receiving Point
  • Client
  • Shipping Point / Receiving Point
  • I_CUSTOMERRETURNITEMENHANCED.MANDT == TVST.MANDT
  • I_CUSTOMERRETURNITEMENHANCED.SHIPPINGPOINT == TVST.VSTEL
Shipping Type
  • Client
  • Shipping Type
  • I_CUSTOMERRETURNITEMENHANCED.MANDT == T173.MANDT
  • I_CUSTOMERRETURNITEMENHANCED.SHIPPINGTYPE == T173.VSART
Storage location
  • Client
  • Plant (Own or External)
  • Storage location
  • I_CUSTOMERRETURNITEMENHANCED.MANDT == T001L.MANDT
  • I_CUSTOMERRETURNITEMENHANCED.PLANT == T001L.WERKS
  • I_CUSTOMERRETURNITEMENHANCED.STORAGELOCATION == T001L.LGORT
SD Document Currency
  • Client
  • SD Document Currency
  • I_CUSTOMERRETURNITEMENHANCED.MANDT == TCURC.MANDT
  • I_CUSTOMERRETURNITEMENHANCED.TRANSACTIONCURRENCY == TCURC.WAERS