C_MassChgDebitMemoReq

Mass Change of Debit Memo Request | view: CSDMCDEMEREQ | Extraction: Not supported | Component: Mass Change of Sales Documents
Tables used: VBKD, VEDA, VBAK, VBPA, VBPA, CVI_CUST_CT_LINK, BUT000, KNA1, CVI_CUST_LINK, CVI_VEND_LINK
Column Name Description
DebitMemoRequest Debit Memo Request
Column Name Description
💲 SD Document Currency (TransactionCurrency):
TotalNetAmount Net Value of the Sales Order in Document Currency
Column Name Description
Column Name Description
CreationDate Date on which the record was created
CustomerPurchaseOrderDate Customer Reference Date
DebitMemoRequestDate 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
OverallSDDocumentRejectionSts Rejection Status (All Items) Show values
OverallOrdReltdBillgStatus Order-Related Billing Status (All Items) Show values
SalesDocApprovalStatus Document Approval Status Show values
TotalBlockStatus Overall Block Status (Header) Show values
OverallBillingBlockStatus Billing Block Status (All Items) Show values
HdrGeneralIncompletionStatus Incompletion Status (Header) Show values
HeaderBillgIncompletionStatus Billing Incompletion Status (Header) Show values
OverallPricingIncompletionSts Delivery Confirmation Status (Item) Show values
SDProcessStatus Overall Processing Status (Item) Show values
OrderRelatedBillingStatus Order-Related Billing Status (Item) Show values
SDDocumentRejectionStatus Rejection 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
SDDocReferenceStatus Dangerous Goods Status (Item) Show values
TotalSDDocReferenceStatus Overall Reference Status (Item) Show values
SlsDocMassChgEntityLevel Entity Level Show values
SDDocumentCategory SD Document Category Show values
Column Name Description Domain name
PurchaseOrderByCustomer Customer Reference BSTKD
Product Product Number MATNR
CreatedByUser Name of Person Responsible for Creating the Object USNAM
DebitMemoRequestItemCategory Sales document item category PSTYV
Division Division SPART
ProfitCenter Profit Center PRCTR
WBSElementExternalID Work Breakdown Structure Element (WBS Element) Edited PS_POSID_EDIT
CostCenter Cost Center KOSTL
IncotermsTransferLocation Incoterms (Part 2) INCO2
IncotermsLocation1 Incoterms Location 1 INCO_L
IncotermsLocation2 Incoterms Location 2 INCO_L
SalesDocumentRjcnReason Reason for Rejection of Sales Documents ABGRU_VA
OrganizationBPName1 Name 1 NAME
OrganizationBPName2 Name 2 NAME
ResponsibleEmployee Employee Responsible PERNR
SalesEmployee Sales Employee PERNR
PartnerFunction Partner Function CHAR2
Customer Customer Number KUNNR
Supplier Account Number of Supplier LIFNR
Personnel Personnel Number PERNR
ContactPerson Number of Contact Person PARNR
CustomerPaymentTerms Terms of payment key ZTERM
AdditionalPartnerName null
DebitMemoRequestItemText null
SlsDocMassChangeRequestUUID null
Master Data Relations Join Conditions
Customer Group 1
  • Client
  • Customer Group 1
  • C_MASSCHGDEBITMEMOREQ.MANDT == TVV1.MANDT
  • C_MASSCHGDEBITMEMOREQ.ADDITIONALCUSTOMERGROUP1 == TVV1.KVGR1
Customer Group 2
  • Client
  • Customer Group 2
  • C_MASSCHGDEBITMEMOREQ.MANDT == TVV2.MANDT
  • C_MASSCHGDEBITMEMOREQ.ADDITIONALCUSTOMERGROUP2 == TVV2.KVGR2
Customer Group 3
  • Customer Group 3
  • Client
  • C_MASSCHGDEBITMEMOREQ.ADDITIONALCUSTOMERGROUP3 == TVV3.KVGR3
  • C_MASSCHGDEBITMEMOREQ.MANDT == TVV3.MANDT
Customer Group 4
  • Customer Group 4
  • Client
  • C_MASSCHGDEBITMEMOREQ.ADDITIONALCUSTOMERGROUP4 == TVV4.KVGR4
  • C_MASSCHGDEBITMEMOREQ.MANDT == TVV4.MANDT
Customer Group 5
  • Client
  • Customer Group 5
  • C_MASSCHGDEBITMEMOREQ.MANDT == TVV5.MANDT
  • C_MASSCHGDEBITMEMOREQ.ADDITIONALCUSTOMERGROUP5 == TVV5.KVGR5
Company Code to Be Billed
  • Client
  • Company Code to Be Billed
  • C_MASSCHGDEBITMEMOREQ.MANDT == T001.MANDT
  • C_MASSCHGDEBITMEMOREQ.BILLINGCOMPANYCODE == T001.BUKRS
Customer - Document Customer
  • Client
  • Ship-to Party
  • Bill-to Party
  • Payer
  • Sold-to Party
  • C_MASSCHGDEBITMEMOREQ.MANDT == KNA1.MANDT
  • C_MASSCHGDEBITMEMOREQ.SHIPTOPARTY == KNA1.KUNNR
  • C_MASSCHGDEBITMEMOREQ.BILLTOPARTY == KNA1.KUNNR
  • C_MASSCHGDEBITMEMOREQ.PAYERPARTY == KNA1.KUNNR
  • C_MASSCHGDEBITMEMOREQ.SOLDTOPARTY == KNA1.KUNNR
Business Area
  • Business Area
  • Client
  • C_MASSCHGDEBITMEMOREQ.BUSINESSAREA == TGSB.GSBER
  • C_MASSCHGDEBITMEMOREQ.MANDT == TGSB.MANDT
Controlling Area
  • Controlling Area
  • Client
  • C_MASSCHGDEBITMEMOREQ.CONTROLLINGAREA == TKA01.KOKRS
  • C_MASSCHGDEBITMEMOREQ.MANDT == TKA01.MANDT
Credit control area
  • Client
  • Credit control area
  • C_MASSCHGDEBITMEMOREQ.MANDT == T014.MANDT
  • C_MASSCHGDEBITMEMOREQ.CREDITCONTROLAREA == T014.KKBER
Customer Group
  • Customer Group
  • Client
  • C_MASSCHGDEBITMEMOREQ.CUSTOMERGROUP == T151.KDGRP
  • C_MASSCHGDEBITMEMOREQ.MANDT == T151.MANDT
Approval Request Reason ID
  • Client
  • Approval Request Reason ID
  • C_MASSCHGDEBITMEMOREQ.MANDT == SDAPMAPRR.CLIENT
  • C_MASSCHGDEBITMEMOREQ.DEBITMEMOREQAPPROVALREASON == SDAPMAPRR.APM_APPROVAL_REASON
Order type in order header
  • Client
  • Debit Memo Request Type
  • Sales Document Type
  • C_MASSCHGDEBITMEMOREQ.MANDT == TVAK.MANDT
  • C_MASSCHGDEBITMEMOREQ.DEBITMEMOREQUESTTYPE == TVAK.AUART
  • C_MASSCHGDEBITMEMOREQ.SALESDOCUMENTTYPE == TVAK.AUART
Distribution channel in order header
  • Client
  • Sales Organization
  • Distribution Channel
  • C_MASSCHGDEBITMEMOREQ.MANDT == TVKOV.MANDT
  • C_MASSCHGDEBITMEMOREQ.SALESORGANIZATION == TVKOV.VKORG
  • C_MASSCHGDEBITMEMOREQ.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
Header Billing Block Reason
  • Client
  • Header Billing Block Reason
  • C_MASSCHGDEBITMEMOREQ.MANDT == TVFS.MANDT
  • C_MASSCHGDEBITMEMOREQ.HEADERBILLINGBLOCKREASON == TVFS.FAKSP
Division in order header
  • Client
  • Sales Organization
  • Organization Division
  • Distribution Channel
  • C_MASSCHGDEBITMEMOREQ.MANDT == TVTA.MANDT
  • C_MASSCHGDEBITMEMOREQ.SALESORGANIZATION == TVTA.VKORG
  • C_MASSCHGDEBITMEMOREQ.ORGANIZATIONDIVISION == TVTA.SPART
  • C_MASSCHGDEBITMEMOREQ.DISTRIBUTIONCHANNEL == TVTA.VTWEG
Customer - Document Customer
  • Client
  • Ship-to Party
  • Bill-to Party
  • Payer
  • Sold-to Party
  • C_MASSCHGDEBITMEMOREQ.MANDT == KNA1.MANDT
  • C_MASSCHGDEBITMEMOREQ.SHIPTOPARTY == KNA1.KUNNR
  • C_MASSCHGDEBITMEMOREQ.BILLTOPARTY == KNA1.KUNNR
  • C_MASSCHGDEBITMEMOREQ.PAYERPARTY == KNA1.KUNNR
  • C_MASSCHGDEBITMEMOREQ.SOLDTOPARTY == KNA1.KUNNR
Payment Method
  • ?
  • Client
  • Payment Method
  • C_MASSCHGDEBITMEMOREQ.[column in domain "LAND1"] == T042Z.LAND1
  • C_MASSCHGDEBITMEMOREQ.MANDT == T042Z.MANDT
  • C_MASSCHGDEBITMEMOREQ.PAYMENTMETHOD == T042Z.ZLSCH
Sales District
  • Client
  • Sales District
  • C_MASSCHGDEBITMEMOREQ.MANDT == T171.MANDT
  • C_MASSCHGDEBITMEMOREQ.SALESDISTRICT == T171.BZIRK
Order type in order header
  • Client
  • Debit Memo Request Type
  • Sales Document Type
  • C_MASSCHGDEBITMEMOREQ.MANDT == TVAK.MANDT
  • C_MASSCHGDEBITMEMOREQ.DEBITMEMOREQUESTTYPE == TVAK.AUART
  • C_MASSCHGDEBITMEMOREQ.SALESDOCUMENTTYPE == TVAK.AUART
Sales group
  • Client
  • Sales office
  • Sales group
  • C_MASSCHGDEBITMEMOREQ.MANDT == TVBVK.MANDT
  • C_MASSCHGDEBITMEMOREQ.SALESOFFICE == TVBVK.VKBUR
  • C_MASSCHGDEBITMEMOREQ.SALESGROUP == TVBVK.VKGRP
Sales organization in order header
  • Client
  • Sales Organization
  • C_MASSCHGDEBITMEMOREQ.MANDT == TVKO.MANDT
  • C_MASSCHGDEBITMEMOREQ.SALESORGANIZATION == TVKO.VKORG
Order Reason (Reason for the Business Transaction)
  • Order Reason (Reason for the Business Transaction)
  • Client
  • C_MASSCHGDEBITMEMOREQ.SDDOCUMENTREASON == TVAU.AUGRU
  • C_MASSCHGDEBITMEMOREQ.MANDT == TVAU.MANDT
Customer - Document Customer
  • Client
  • Ship-to Party
  • Bill-to Party
  • Payer
  • Sold-to Party
  • C_MASSCHGDEBITMEMOREQ.MANDT == KNA1.MANDT
  • C_MASSCHGDEBITMEMOREQ.SHIPTOPARTY == KNA1.KUNNR
  • C_MASSCHGDEBITMEMOREQ.BILLTOPARTY == KNA1.KUNNR
  • C_MASSCHGDEBITMEMOREQ.PAYERPARTY == KNA1.KUNNR
  • C_MASSCHGDEBITMEMOREQ.SOLDTOPARTY == KNA1.KUNNR
Sold-to Party
  • Client
  • Ship-to Party
  • Bill-to Party
  • Payer
  • Sold-to Party
  • C_MASSCHGDEBITMEMOREQ.MANDT == KNA1.MANDT
  • C_MASSCHGDEBITMEMOREQ.SHIPTOPARTY == KNA1.KUNNR
  • C_MASSCHGDEBITMEMOREQ.BILLTOPARTY == KNA1.KUNNR
  • C_MASSCHGDEBITMEMOREQ.PAYERPARTY == KNA1.KUNNR
  • C_MASSCHGDEBITMEMOREQ.SOLDTOPARTY == KNA1.KUNNR
Currency in order header
  • Client
  • SD Document Currency
  • C_MASSCHGDEBITMEMOREQ.MANDT == TCURC.MANDT
  • C_MASSCHGDEBITMEMOREQ.TRANSACTIONCURRENCY == TCURC.WAERS
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Client
  • Sales Organization
  • Organization Division
  • Sales office
  • Distribution Channel
  • C_MASSCHGDEBITMEMOREQ.MANDT == TVKBZ.MANDT
  • C_MASSCHGDEBITMEMOREQ.SALESORGANIZATION == TVKBZ.VKORG
  • C_MASSCHGDEBITMEMOREQ.ORGANIZATIONDIVISION == TVKBZ.SPART
  • C_MASSCHGDEBITMEMOREQ.SALESOFFICE == TVKBZ.VKBUR
  • C_MASSCHGDEBITMEMOREQ.DISTRIBUTIONCHANNEL == TVKBZ.VTWEG