C_CustomerReturnItemOPg

Customer Return Item Object Page | view: CCUSTRETITMOPG | 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_HEAD, VBRK, VBRP, /SPE/INSPECRESH, MSR_D_EXECUTED, MSR_D_ITEM, VBKD, VEDA, VBAK, VBAK, VBAP, VBKD, VEDA, VBAP, MSR_D_FIN_STATUS, MSR_D_FIN_DETAIL, MSR_D_LOG_STATUS, MSR_D_PLANNED, MARA, MSR_I_CHAIN, MSR_I_CHAIN, T001W, MARA, MSR_C_REF_CTRL, MSR_C_REF_CTRL_T, TVAP, T006, T006A
Column Name Description
CustomerReturn FK Customer Return
CustomerReturnItem Customer Return 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 Quantity
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
RetsMgmtItmLogProcgStatus Logistical Processing Status of a Return Show values
RetsMgmtItmCompnProcgStatus Status of Returns Refund Determination Show values
RetsMgmtItmProcgStatus Processing Status Show values
BillingRelevanceCode Relevant for Billing Show values
ReferenceSDDocumentCategory Document Category of Preceding SD Document Show values
ReturnsRefundType Refund Type Show values
ReturnsRefundProcgMode Refund Processing Mode for a Return Show values
SDDocumentRejectionStatus Rejection Status (Item) Show values
RetsMgmtProcessingBlock Approval Block Show values
ProductIsInspectedAtCustSite Inspection at Customer Site Show values
Column Name Description Domain name
HigherLevelItem Higher-Level Item in Bill of Material Structures POSNR
RetsMgmtItmLogProcgStatusDesc Description of the Logistical Processing Status of a Return DDTEXT
RetsMgmtCompnProcgStatusDesc Short Text for Fixed Values DDTEXT
RetsMgmtProcessingStatusDesc Short Text for Fixed Values DDTEXT
ProductionPlant Receiving Plant WERKS
RootBatchPlant Plant (Own or External) WERKS
PlantName Plant Name TEXT30
MaterialByCustomer Material Number Used by Customer IDNEX
BillOfMaterial Bill of Material STNUM
ReferenceSDDocument Document number of the reference document VBELN
ReferenceSDDocumentItem Item number of the reference item POSNR
ReturnsRefundProcgModeDesc Description of a Refund Processing Mode for a Return DDTEXT
RetMatlInspResultCode Inspection Code QCODE
LastChangeDateTime UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TZNTSTMPL
ReturnsMaterialHasBeenReceived null
CustRetMatlAuthzn Customer RMA Number MSR_RMA_NR
LinkedSAPObjectKey Document Management Object Key OBJKY
CustomerReturnItemUUID null
BillOfMaterialItemUUID null
InspectionCode Inspection Code QCODE
Supplier Account Number of Supplier LIFNR
SupplierAddress null
SupplierAddressID Address Number AD_ADDRNUM
ItemDeliveryAddressID Address Number AD_ADDRNUM
ProductIsAwaitingInspection null
IsReleasedForSubsqntProcessing null
CustRetItmInspectionText Inspection Comment Line TEXT132
CustRetItmCustomerText Customer Inspection Comment TEXT132
FollowUpActivityIsSupplied null
RetsMgmtProcess Process Identification Number MSR_PROCESS_ID
RetsMgmtProcessItem Item Number MSR_PROCESS_ITEM
Master Data Relations Join Conditions
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • C_CUSTOMERRETURNITEMOPG.MANDT == T006.MANDT
  • C_CUSTOMERRETURNITEMOPG.BASEUNIT == T006.MSEHI
Batch Number
  • Client
  • Product Number
  • Material Number
  • Receiving Plant
  • Plant (Own or External)
  • Batch Number
  • Batch Number
  • C_CUSTOMERRETURNITEMOPG.MANDT == MCHA.MANDT
  • C_CUSTOMERRETURNITEMOPG.MATERIAL == MCHA.MATNR
  • C_CUSTOMERRETURNITEMOPG.ROOTBATCHPRODUCT == MCHA.MATNR
  • C_CUSTOMERRETURNITEMOPG.PRODUCTIONPLANT == MCHA.WERKS
  • C_CUSTOMERRETURNITEMOPG.ROOTBATCHPLANT == MCHA.WERKS
  • C_CUSTOMERRETURNITEMOPG.BATCH == MCHA.CHARG
  • C_CUSTOMERRETURNITEMOPG.BATCHBYSUPPLIER == MCHA.CHARG
Batch Number
  • Client
  • Product Number
  • Material Number
  • Receiving Plant
  • Plant (Own or External)
  • Batch Number
  • Batch Number
  • C_CUSTOMERRETURNITEMOPG.MANDT == MCHA.MANDT
  • C_CUSTOMERRETURNITEMOPG.MATERIAL == MCHA.MATNR
  • C_CUSTOMERRETURNITEMOPG.ROOTBATCHPRODUCT == MCHA.MATNR
  • C_CUSTOMERRETURNITEMOPG.PRODUCTIONPLANT == MCHA.WERKS
  • C_CUSTOMERRETURNITEMOPG.ROOTBATCHPLANT == MCHA.WERKS
  • C_CUSTOMERRETURNITEMOPG.BATCH == MCHA.CHARG
  • C_CUSTOMERRETURNITEMOPG.BATCHBYSUPPLIER == MCHA.CHARG
SD Document Currency
  • Client
  • SD Document Currency
  • C_CUSTOMERRETURNITEMOPG.MANDT == TCURC.MANDT
  • C_CUSTOMERRETURNITEMOPG.CURRENCY == TCURC.WAERS
Order type in order header
  • Client
  • Customer Return Type
  • C_CUSTOMERRETURNITEMOPG.MANDT == TVAK.MANDT
  • C_CUSTOMERRETURNITEMOPG.CUSTOMERRETURNTYPE == TVAK.AUART
Follow-Up Activity Code C_CUSTOMERRETURNITEMOPG.CUSTRETITMFOLLOWUPACTIVITY == MSR_I_CODE.FU_CODE
Distribution channel in order header
  • Client
  • Distribution Channel
  • Sales Organization
  • C_CUSTOMERRETURNITEMOPG.MANDT == TVKOV.MANDT
  • C_CUSTOMERRETURNITEMOPG.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • C_CUSTOMERRETURNITEMOPG.SALESORGANIZATION == TVKOV.VKORG
Material: order item
  • Client
  • Product Number
  • Material Number
  • C_CUSTOMERRETURNITEMOPG.MANDT == MARA.MANDT
  • C_CUSTOMERRETURNITEMOPG.MATERIAL == MARA.MATNR
  • C_CUSTOMERRETURNITEMOPG.ROOTBATCHPRODUCT == MARA.MATNR
Product Group
  • Client
  • Product Group
  • C_CUSTOMERRETURNITEMOPG.MANDT == T023.MANDT
  • C_CUSTOMERRETURNITEMOPG.MATERIALGROUP == T023.MATKL
Sales unit
  • Client
  • Sales unit
  • C_CUSTOMERRETURNITEMOPG.MANDT == T006.MANDT
  • C_CUSTOMERRETURNITEMOPG.ORDERQUANTITYUNIT == T006.MSEHI
Division in order header
  • Client
  • Distribution Channel
  • Division
  • Sales Organization
  • C_CUSTOMERRETURNITEMOPG.MANDT == TVTA.MANDT
  • C_CUSTOMERRETURNITEMOPG.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • C_CUSTOMERRETURNITEMOPG.ORGANIZATIONDIVISION == TVTA.SPART
  • C_CUSTOMERRETURNITEMOPG.SALESORGANIZATION == TVTA.VKORG
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
  • C_CUSTOMERRETURNITEMOPG.MANDT == TVAG.MANDT
  • C_CUSTOMERRETURNITEMOPG.RETURNSREFUNDRJCNREASON == TVAG.ABGRU
Material: order item
  • Client
  • Product Number
  • Material Number
  • C_CUSTOMERRETURNITEMOPG.MANDT == MARA.MANDT
  • C_CUSTOMERRETURNITEMOPG.MATERIAL == MARA.MATNR
  • C_CUSTOMERRETURNITEMOPG.ROOTBATCHPRODUCT == MARA.MATNR
Reason for Rejection of Sales Documents
  • Client
  • Reason for Rejection of Sales Documents
  • C_CUSTOMERRETURNITEMOPG.MANDT == TVAG.MANDT
  • C_CUSTOMERRETURNITEMOPG.SALESDOCUMENTRJCNREASON == TVAG.ABGRU
Sales organization in order header
  • Client
  • Sales Organization
  • C_CUSTOMERRETURNITEMOPG.MANDT == TVKO.MANDT
  • C_CUSTOMERRETURNITEMOPG.SALESORGANIZATION == TVKO.VKORG
Receiving Point
  • Client
  • Receiving Point
  • C_CUSTOMERRETURNITEMOPG.MANDT == TVST.MANDT
  • C_CUSTOMERRETURNITEMOPG.SHIPPINGPOINT == TVST.VSTEL
x
  • Client
  • Dimension key
  • C_CUSTOMERRETURNITEMOPG.MANDT == T006D.MANDT
  • C_CUSTOMERRETURNITEMOPG.UNITOFMEASUREDIMENSION == T006D.DIMID