C_MassChgCustomerReturnItem

Mass Change of Customer Return Item | view: CSDMCCUSTRETITM | Extraction: Not supported | Component: Mass Change of Sales Documents
Tables used: VBAP, MSR_D_EXECUTED, VBKD, VEDA, VBAK, VBAK, VBAP, VBKD, VEDA, MARA, KNA1, MARA, MAKT, MSR_C_RET_REASON, MSR_C_RET_REASOT, TVAG, TVAGT, PRPS
Column Name Description
CustomerReturn FK Customer Return
CustomerReturnItem Sales Document Item
Column Name Description
💲 SD Document Currency (TransactionCurrency):
NetAmount Net Value of the Order Item in Document Currency
Column Name Description
Column Name Description
CreationDate Date on which the record was created
CustomerPurchaseOrderDate Customer Reference Date
CustomerReturnDate Document Date (Date Received/Sent)
BillingDocumentDate Billing Date
PricingDate Date for Pricing and Exchange Rate
Column Name Description
OverallSDProcessStatus Overall Processing Status (Header/All Items) Show values
OverallTotalDeliveryStatus Overall Delivery Status (All Items) Show values
SDDocumentCategory SD Document Category Show values
OverallDeliveryStatus Delivery Status (All Items) Show values
SalesDocApprovalStatus Document Approval Status Show values
TotalBlockStatus Overall Block Status (Header) Show values
OverallSDDocumentRejectionSts Rejection Status (All Items) Show values
OverallDeliveryBlockStatus Overall Delivery Block Status (All Items) Show values
OverallBillingBlockStatus Billing Block Status (All Items) Show values
HdrGeneralIncompletionStatus Incompletion Status (Header) Show values
HeaderBillgIncompletionStatus Billing Incompletion Status (Header) Show values
OverallPricingIncompletionSts Pricing Incompltn Sts (All Items) Show values
HeaderDelivIncompletionStatus Delivery Incompletion Status (Header) Show values
OverallDangerousGoodsStatus Dangerous Goods Status (All Items) Show values
OverallSafetyDataSheetStatus Safety Data Sheet Status (All Items) Show values
OvrlReldForSubsqntProcgSts Release Status Show values
SDProcessStatus Overall Processing Status of the SD Document Item Show values
SDDocumentRejectionStatus Rejection Status (Item) Show values
ItemGeneralIncompletionStatus General Incompletion Status of Item Show values
ItemBillingIncompletionStatus Billing Incompletion Status (Item) Show values
PricingIncompletionStatus Pricing Incompletion Status (Item) Show values
ItemDeliveryIncompletionStatus Delivery Incompletion Status (Item) Show values
SDDocReferenceStatus Reference Status (Item) Show values
TotalSDDocReferenceStatus Overall Reference Status (Item) Show values
DangerousGoodsStatus Dangerous Goods Status (Item) Show values
SafetyDataSheetStatus Safety Data Sheet Status (Item) Show values
DeliveryBlockStatus Delivery Block Status (Item) Show values
BillingBlockStatus Billing Block Status (Item) Show values
ItemIsDeliveryRelevant Item Is Relevant for Delivery Show values
SlsDocMassChgEntityLevel Entity Level Show values
Column Name Description Domain name
SoldToParty Sold-to Party KUNNR
ShipToParty Ship-to Party KUNNR
PurchaseOrderByCustomer Customer Reference BSTKD
SalesOrganization Sales Organization VKORG
DistributionChannel Distribution Channel VTWEG
ProductName Product Description TEXT40
CreatedByUser Name of Person Responsible for Creating the Object USNAM
CustomerReturnType Customer Return Type AUART
ProfitCenter Profit Center PRCTR
ReturnReasonName Return Reason Description TEXT60
WBSElementExternalID Work Breakdown Structure Element (WBS Element) Edited PS_POSID_EDIT
CostCenter Cost Center KOSTL
OrganizationDivision Organization Division SPART
SalesGroup Sales group VKGRP
SalesOffice Sales office VKBUR
PayerParty Payer KUNNR
BillToParty Bill-to Party KUNNR
ResponsibleEmployee Employee Responsible PERNR
SalesEmployee Sales Employee PERNR
AdditionalPartnerName null
PartnerFunction Partner Function CHAR2
Customer Customer Number KUNNR
Supplier Account Number of Supplier LIFNR
Personnel Personnel Number PERNR
ContactPerson Number of Contact Person PARNR
Plant Plant (Own or External) WERKS
SalesDocumentRjcnReasonName Description TEXT40
SlsDocMassChangeRequestUUID null
SalesDocumentItemText Short text for sales order item TEXT40
OrganizationBPName1 Name 1 NAME
OrganizationBPName2 Name 2 NAME
Master Data Relations Join Conditions
Customer Group 1
  • Client
  • Customer Group 1
  • C_MASSCHGCUSTOMERRETURNITEM.MANDT == TVV1.MANDT
  • C_MASSCHGCUSTOMERRETURNITEM.ADDITIONALCUSTOMERGROUP1 == TVV1.KVGR1
Customer Group 2
  • Client
  • Customer Group 2
  • C_MASSCHGCUSTOMERRETURNITEM.MANDT == TVV2.MANDT
  • C_MASSCHGCUSTOMERRETURNITEM.ADDITIONALCUSTOMERGROUP2 == TVV2.KVGR2
Customer Group 3
  • Customer Group 3
  • Client
  • C_MASSCHGCUSTOMERRETURNITEM.ADDITIONALCUSTOMERGROUP3 == TVV3.KVGR3
  • C_MASSCHGCUSTOMERRETURNITEM.MANDT == TVV3.MANDT
Customer Group 4
  • Client
  • Customer Group 4
  • C_MASSCHGCUSTOMERRETURNITEM.MANDT == TVV4.MANDT
  • C_MASSCHGCUSTOMERRETURNITEM.ADDITIONALCUSTOMERGROUP4 == TVV4.KVGR4
Customer Group 5
  • Client
  • Customer Group 5
  • C_MASSCHGCUSTOMERRETURNITEM.MANDT == TVV5.MANDT
  • C_MASSCHGCUSTOMERRETURNITEM.ADDITIONALCUSTOMERGROUP5 == TVV5.KVGR5
Batch Number
  • Client
  • Plant (Own or External)
  • Batch Number
  • Material Number
  • Product Number
  • C_MASSCHGCUSTOMERRETURNITEM.MANDT == MCHA.MANDT
  • C_MASSCHGCUSTOMERRETURNITEM.PLANT == MCHA.WERKS
  • C_MASSCHGCUSTOMERRETURNITEM.BATCH == MCHA.CHARG
  • C_MASSCHGCUSTOMERRETURNITEM.MATERIAL == MCHA.MATNR
  • C_MASSCHGCUSTOMERRETURNITEM.PRODUCT == MCHA.MATNR
Company Code to Be Billed
  • Client
  • Company Code to Be Billed
  • C_MASSCHGCUSTOMERRETURNITEM.MANDT == T001.MANDT
  • C_MASSCHGCUSTOMERRETURNITEM.BILLINGCOMPANYCODE == T001.BUKRS
Business Area
  • Client
  • Business Area
  • C_MASSCHGCUSTOMERRETURNITEM.MANDT == TGSB.MANDT
  • C_MASSCHGCUSTOMERRETURNITEM.BUSINESSAREA == TGSB.GSBER
Controlling Area
  • Client
  • Controlling Area
  • C_MASSCHGCUSTOMERRETURNITEM.MANDT == TKA01.MANDT
  • C_MASSCHGCUSTOMERRETURNITEM.CONTROLLINGAREA == TKA01.KOKRS
Credit control area
  • Credit control area
  • Client
  • C_MASSCHGCUSTOMERRETURNITEM.CREDITCONTROLAREA == T014.KKBER
  • C_MASSCHGCUSTOMERRETURNITEM.MANDT == T014.MANDT
Customer Group
  • Client
  • Customer Group
  • C_MASSCHGCUSTOMERRETURNITEM.MANDT == T151.MANDT
  • C_MASSCHGCUSTOMERRETURNITEM.CUSTOMERGROUP == T151.KDGRP
Approval Request Reason ID
  • Client
  • Approval Request Reason ID
  • C_MASSCHGCUSTOMERRETURNITEM.MANDT == SDAPMAPRR.CLIENT
  • C_MASSCHGCUSTOMERRETURNITEM.CUSTOMERRETURNAPPROVALREASON == SDAPMAPRR.APM_APPROVAL_REASON
Sales document item category
  • Client
  • Sales document item category
  • C_MASSCHGCUSTOMERRETURNITEM.MANDT == TVPT.MANDT
  • C_MASSCHGCUSTOMERRETURNITEM.CUSTOMERRETURNITEMCATEGORY == TVPT.PSTYV
Delivery Block (Document Header)
  • Client
  • Delivery Block (Document Header)
  • C_MASSCHGCUSTOMERRETURNITEM.MANDT == TVLS.MANDT
  • C_MASSCHGCUSTOMERRETURNITEM.DELIVERYBLOCKREASON == TVLS.LIFSP
Division
  • Client
  • Division
  • C_MASSCHGCUSTOMERRETURNITEM.MANDT == TSPA.MANDT
  • C_MASSCHGCUSTOMERRETURNITEM.DIVISION == TSPA.SPART
Header Billing Block Reason
  • Client
  • Header Billing Block Reason
  • C_MASSCHGCUSTOMERRETURNITEM.MANDT == TVFS.MANDT
  • C_MASSCHGCUSTOMERRETURNITEM.HEADERBILLINGBLOCKREASON == TVFS.FAKSP
Material: order item
  • Client
  • Material Number
  • Product Number
  • C_MASSCHGCUSTOMERRETURNITEM.MANDT == MARA.MANDT
  • C_MASSCHGCUSTOMERRETURNITEM.MATERIAL == MARA.MATNR
  • C_MASSCHGCUSTOMERRETURNITEM.PRODUCT == MARA.MATNR
Order Number
  • Order Number
  • Client
  • C_MASSCHGCUSTOMERRETURNITEM.ORDERID == AUFK.AUFNR
  • C_MASSCHGCUSTOMERRETURNITEM.MANDT == AUFK.MANDT
Material: order item
  • Client
  • Material Number
  • Product Number
  • C_MASSCHGCUSTOMERRETURNITEM.MANDT == MARA.MANDT
  • C_MASSCHGCUSTOMERRETURNITEM.MATERIAL == MARA.MATNR
  • C_MASSCHGCUSTOMERRETURNITEM.PRODUCT == MARA.MATNR
Return Reason
  • Client
  • Return Reason
Action at end of contract
  • Client
  • Action at end of contract
  • C_MASSCHGCUSTOMERRETURNITEM.MANDT == TVAS.MANDT
  • C_MASSCHGCUSTOMERRETURNITEM.SALESCONTRACTFOLLOWUPACTION == TVAS.AKTVT
Sales District
  • Client
  • Sales District
  • C_MASSCHGCUSTOMERRETURNITEM.MANDT == T171.MANDT
  • C_MASSCHGCUSTOMERRETURNITEM.SALESDISTRICT == T171.BZIRK
Reason for Rejection of Sales Documents
  • Client
  • Reason for Rejection of Sales Documents
  • C_MASSCHGCUSTOMERRETURNITEM.MANDT == TVAG.MANDT
  • C_MASSCHGCUSTOMERRETURNITEM.SALESDOCUMENTRJCNREASON == TVAG.ABGRU
Order type in order header
  • Sales Document Type
  • Client
  • C_MASSCHGCUSTOMERRETURNITEM.SALESDOCUMENTTYPE == TVAK.AUART
  • C_MASSCHGCUSTOMERRETURNITEM.MANDT == TVAK.MANDT
Order Reason (Reason for the Business Transaction)
  • Client
  • Order Reason (Reason for the Business Transaction)
  • C_MASSCHGCUSTOMERRETURNITEM.MANDT == TVAU.MANDT
  • C_MASSCHGCUSTOMERRETURNITEM.SDDOCUMENTREASON == TVAU.AUGRU
Shipping Conditions
  • Client
  • Shipping Conditions
  • C_MASSCHGCUSTOMERRETURNITEM.MANDT == TVSB.MANDT
  • C_MASSCHGCUSTOMERRETURNITEM.SHIPPINGCONDITION == TVSB.VSBED
Shipping Point / Receiving Point
  • Client
  • Shipping Point / Receiving Point
  • C_MASSCHGCUSTOMERRETURNITEM.MANDT == TVST.MANDT
  • C_MASSCHGCUSTOMERRETURNITEM.SHIPPINGPOINT == TVST.VSTEL
Shipping Type
  • Client
  • Shipping Type
  • C_MASSCHGCUSTOMERRETURNITEM.MANDT == T173.MANDT
  • C_MASSCHGCUSTOMERRETURNITEM.SHIPPINGTYPE == T173.VSART
Storage location
  • Client
  • Plant (Own or External)
  • Storage location
  • C_MASSCHGCUSTOMERRETURNITEM.MANDT == T001L.MANDT
  • C_MASSCHGCUSTOMERRETURNITEM.PLANT == T001L.WERKS
  • C_MASSCHGCUSTOMERRETURNITEM.STORAGELOCATION == T001L.LGORT
SD Document Currency
  • Client
  • SD Document Currency
  • C_MASSCHGCUSTOMERRETURNITEM.MANDT == TCURC.MANDT
  • C_MASSCHGCUSTOMERRETURNITEM.TRANSACTIONCURRENCY == TCURC.WAERS