C_MassChangeSalesContract

Mass Change of Sales Contract | view: CSDMCSLSCONTR | Extraction: Not supported | Component: Mass Change of Sales Documents
Tables used: VBKD, VEDA, VBAK, VBPA, VBPA, CVI_CUST_CT_LINK, BUT000, TCURC, TCURX, TCURT, KNA1, TVZB, TVZBT, CVI_CUST_LINK, TINC, TINCT, T171, T171T, TVKGR, TVGRT, TVBUR, TVKBT, TVAU, TVAUT, TVSB, TVSBT, CVI_VEND_LINK
Column Name Description
SalesContract Sales Contract
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
SalesContractValidityStartDate Valid-From Date (Outline Agreements, Product Proposals)
SalesContractValidityEndDate Valid-To Date (Outline Agreements, Product Proposals)
PricingDate Date for Pricing and Exchange Rate
CustomerPurchaseOrderDate Customer Reference Date
SalesContractDate Document Date (Date Received/Sent)
BillingDocumentDate Billing Date
Column Name Description
OverallSDProcessStatus Overall Processing Status (Header/All Items) Show values
SalesDocApprovalStatus Document Approval Status Show values
OverallSDDocumentRejectionSts Rejection Status (All Items) Show values
TotalBlockStatus Overall Block Status (Header) Show values
HdrGeneralIncompletionStatus Incompletion Status (Header) Show values
HeaderBillgIncompletionStatus Billing Incompletion Status (Header) Show values
OverallPricingIncompletionSts Pricing Incompltn Sts (All Items) Show values
OverallTrdCmplncEmbargoSts Embargo Status (All Items) Show values
OvrlTrdCmplncSnctndListChkSts Watch List Screening Status (All Items) Show values
OvrlTrdCmplncLegalCtrlChkSts Legal Control Status(All Items) Show values
OverallChmlCmplncStatus Product Marketability Status(All Items) Show values
OverallDangerousGoodsStatus Dangerous Goods Status (All Items) Show values
ContractDownPaymentStatus Down Payment Status (Header) Show values
SlsDocMassChgEntityLevel Entity Level Show values
SDProcessStatus Overall Processing Status (Item) Show values
SDDocumentRejectionStatus Rejection 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
SDDocReferenceStatus Reference Status (Item) Show values
TotalSDDocReferenceStatus Overall Reference Status (Item) Show values
TrdCmplncEmbargoSts Embargo Status (Item) Show values
TrdCmplncSnctndListChkSts Screening Status (Item) Show values
ChmlCmplncStatus Product Marketability Status (Item) Show values
DangerousGoodsStatus Dangerous Goods Status (Item) Show values
ContractItemDownPaymentStatus Down Payment Status Show values
SDDocumentCategory SD Document Category Show values
Column Name Description Domain name
CreatedByUser Name of Person Responsible for Creating the Object USNAM
IncotermsTransferLocation Incoterms (Part 2) INCO2
IncotermsLocation1 Incoterms Location 1 INCO_L
IncotermsLocation2 Incoterms Location 2 INCO_L
ResponsibleEmployee Employee Responsible PERNR
SalesEmployee Sales Employee PERNR
CostCenter Cost Center KOSTL
PurchaseOrderByCustomer Customer Reference BSTKD
CustomerPaymentTerms Terms of payment key ZTERM
MasterSalesContract Master Contract Number VBELN
AdditionalPartnerName null
Product Product Number MATNR
PartnerFunction Partner Function CHAR2
Customer Customer Number KUNNR
Supplier Account Number of Supplier LIFNR
Personnel Personnel Number PERNR
ContactPerson Number of Contact Person PARNR
SlsDocMassChangeRequestUUID null
Division Division SPART
SalesContractItemCategory Sales document item category PSTYV
SalesDocumentRjcnReason Reason for Rejection of Sales Documents ABGRU_VA
Plant Plant (Own or External) WERKS
ProfitCenter Profit Center PRCTR
DeliveryPriority Delivery Priority LPRIO
OrganizationBPName1 Name 1 NAME
OrganizationBPName2 Name 2 NAME
SDDocumentReasonText Description TEXT40
SalesGroupName Sales Group Description TEXT20
SalesOfficeName Sales Office Description TEXT20
SalesDistrictName Name of the district TEXT20
ShippingConditionName Shipping Conditions Description TEXT20
CustomerPaymentTermsName Description of terms of payment TEXT30
IncotermsClassificationName Description TEXT30
CurrencyName Description TEXT40
Master Data Relations Join Conditions
Customer Group 1
  • Client
  • Customer Group 1
  • C_MASSCHANGESALESCONTRACT.MANDT == TVV1.MANDT
  • C_MASSCHANGESALESCONTRACT.ADDITIONALCUSTOMERGROUP1 == TVV1.KVGR1
Customer Group 2
  • Customer Group 2
  • Client
  • C_MASSCHANGESALESCONTRACT.ADDITIONALCUSTOMERGROUP2 == TVV2.KVGR2
  • C_MASSCHANGESALESCONTRACT.MANDT == TVV2.MANDT
Customer Group 3
  • Client
  • Customer Group 3
  • C_MASSCHANGESALESCONTRACT.MANDT == TVV3.MANDT
  • C_MASSCHANGESALESCONTRACT.ADDITIONALCUSTOMERGROUP3 == TVV3.KVGR3
Customer Group 4
  • Customer Group 4
  • Client
  • C_MASSCHANGESALESCONTRACT.ADDITIONALCUSTOMERGROUP4 == TVV4.KVGR4
  • C_MASSCHANGESALESCONTRACT.MANDT == TVV4.MANDT
Customer Group 5
  • Customer Group 5
  • Client
  • C_MASSCHANGESALESCONTRACT.ADDITIONALCUSTOMERGROUP5 == TVV5.KVGR5
  • C_MASSCHANGESALESCONTRACT.MANDT == TVV5.MANDT
Company Code to Be Billed
  • Company Code to Be Billed
  • Client
  • C_MASSCHANGESALESCONTRACT.BILLINGCOMPANYCODE == T001.BUKRS
  • C_MASSCHANGESALESCONTRACT.MANDT == T001.MANDT
Customer - Document Customer
  • Bill-to Party
  • Payer
  • Ship-to Party
  • Sold-to Party
  • Client
  • C_MASSCHANGESALESCONTRACT.BILLTOPARTY == KNA1.KUNNR
  • C_MASSCHANGESALESCONTRACT.PAYERPARTY == KNA1.KUNNR
  • C_MASSCHANGESALESCONTRACT.SHIPTOPARTY == KNA1.KUNNR
  • C_MASSCHANGESALESCONTRACT.SOLDTOPARTY == KNA1.KUNNR
  • C_MASSCHANGESALESCONTRACT.MANDT == KNA1.MANDT
Business Area
  • Business Area
  • Client
  • C_MASSCHANGESALESCONTRACT.BUSINESSAREA == TGSB.GSBER
  • C_MASSCHANGESALESCONTRACT.MANDT == TGSB.MANDT
Controlling Area
  • Controlling Area
  • Client
  • C_MASSCHANGESALESCONTRACT.CONTROLLINGAREA == TKA01.KOKRS
  • C_MASSCHANGESALESCONTRACT.MANDT == TKA01.MANDT
Credit control area
  • Credit control area
  • Client
  • C_MASSCHANGESALESCONTRACT.CREDITCONTROLAREA == T014.KKBER
  • C_MASSCHANGESALESCONTRACT.MANDT == T014.MANDT
Customer Group
  • Client
  • Customer Group
  • C_MASSCHANGESALESCONTRACT.MANDT == T151.MANDT
  • C_MASSCHANGESALESCONTRACT.CUSTOMERGROUP == T151.KDGRP
Distribution channel in order header
  • Distribution Channel
  • Client
  • Sales Organization
  • C_MASSCHANGESALESCONTRACT.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • C_MASSCHANGESALESCONTRACT.MANDT == TVKOV.MANDT
  • C_MASSCHANGESALESCONTRACT.SALESORGANIZATION == TVKOV.VKORG
Incoterms (Part 1)
  • Client
  • Incoterms (Part 1)
  • C_MASSCHANGESALESCONTRACT.MANDT == TINC.MANDT
  • C_MASSCHANGESALESCONTRACT.INCOTERMSCLASSIFICATION == TINC.INCO1
Incoterms Version
  • Incoterms Version
  • Client
  • C_MASSCHANGESALESCONTRACT.INCOTERMSVERSION == TINCV.INCOV
  • C_MASSCHANGESALESCONTRACT.MANDT == TINCV.MANDT
Division in order header
  • Distribution Channel
  • Client
  • Organization Division
  • Sales Organization
  • C_MASSCHANGESALESCONTRACT.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • C_MASSCHANGESALESCONTRACT.MANDT == TVTA.MANDT
  • C_MASSCHANGESALESCONTRACT.ORGANIZATIONDIVISION == TVTA.SPART
  • C_MASSCHANGESALESCONTRACT.SALESORGANIZATION == TVTA.VKORG
Customer - Document Customer
  • Bill-to Party
  • Payer
  • Ship-to Party
  • Sold-to Party
  • Client
  • C_MASSCHANGESALESCONTRACT.BILLTOPARTY == KNA1.KUNNR
  • C_MASSCHANGESALESCONTRACT.PAYERPARTY == KNA1.KUNNR
  • C_MASSCHANGESALESCONTRACT.SHIPTOPARTY == KNA1.KUNNR
  • C_MASSCHANGESALESCONTRACT.SOLDTOPARTY == KNA1.KUNNR
  • C_MASSCHANGESALESCONTRACT.MANDT == KNA1.MANDT
Payment Method
  • ?
  • Client
  • Payment Method
  • C_MASSCHANGESALESCONTRACT.[column in domain "LAND1"] == T042Z.LAND1
  • C_MASSCHANGESALESCONTRACT.MANDT == T042Z.MANDT
  • C_MASSCHANGESALESCONTRACT.PAYMENTMETHOD == T042Z.ZLSCH
Approval Request Reason ID
  • Approval Request Reason ID
  • Client
  • C_MASSCHANGESALESCONTRACT.SALESCONTRACTAPPROVALREASON == SDAPMAPRR.APM_APPROVAL_REASON
  • C_MASSCHANGESALESCONTRACT.MANDT == SDAPMAPRR.CLIENT
Order type in order header
  • Sales Document Type
  • Sales Contract Type
  • Client
  • C_MASSCHANGESALESCONTRACT.SALESDOCUMENTTYPE == TVAK.AUART
  • C_MASSCHANGESALESCONTRACT.SALESCONTRACTTYPE == TVAK.AUART
  • C_MASSCHANGESALESCONTRACT.MANDT == TVAK.MANDT
Sales District
  • Client
  • Sales District
  • C_MASSCHANGESALESCONTRACT.MANDT == T171.MANDT
  • C_MASSCHANGESALESCONTRACT.SALESDISTRICT == T171.BZIRK
Order type in order header
  • Sales Document Type
  • Sales Contract Type
  • Client
  • C_MASSCHANGESALESCONTRACT.SALESDOCUMENTTYPE == TVAK.AUART
  • C_MASSCHANGESALESCONTRACT.SALESCONTRACTTYPE == TVAK.AUART
  • C_MASSCHANGESALESCONTRACT.MANDT == TVAK.MANDT
Sales group
  • Sales office
  • Client
  • Sales group
  • C_MASSCHANGESALESCONTRACT.SALESOFFICE == TVBVK.VKBUR
  • C_MASSCHANGESALESCONTRACT.MANDT == TVBVK.MANDT
  • C_MASSCHANGESALESCONTRACT.SALESGROUP == TVBVK.VKGRP
Sales organization in order header
  • Client
  • Sales Organization
  • C_MASSCHANGESALESCONTRACT.MANDT == TVKO.MANDT
  • C_MASSCHANGESALESCONTRACT.SALESORGANIZATION == TVKO.VKORG
Order Reason (Reason for the Business Transaction)
  • Client
  • Order Reason (Reason for the Business Transaction)
  • C_MASSCHANGESALESCONTRACT.MANDT == TVAU.MANDT
  • C_MASSCHANGESALESCONTRACT.SDDOCUMENTREASON == TVAU.AUGRU
Shipping Conditions
  • Client
  • Shipping Conditions
  • C_MASSCHANGESALESCONTRACT.MANDT == TVSB.MANDT
  • C_MASSCHANGESALESCONTRACT.SHIPPINGCONDITION == TVSB.VSBED
Shipping Type
  • Shipping Type
  • Client
  • C_MASSCHANGESALESCONTRACT.SHIPPINGTYPE == T173.VSART
  • C_MASSCHANGESALESCONTRACT.MANDT == T173.MANDT
Customer - Document Customer
  • Bill-to Party
  • Payer
  • Ship-to Party
  • Sold-to Party
  • Client
  • C_MASSCHANGESALESCONTRACT.BILLTOPARTY == KNA1.KUNNR
  • C_MASSCHANGESALESCONTRACT.PAYERPARTY == KNA1.KUNNR
  • C_MASSCHANGESALESCONTRACT.SHIPTOPARTY == KNA1.KUNNR
  • C_MASSCHANGESALESCONTRACT.SOLDTOPARTY == KNA1.KUNNR
  • C_MASSCHANGESALESCONTRACT.MANDT == KNA1.MANDT
Sold-to Party
  • Bill-to Party
  • Payer
  • Ship-to Party
  • Sold-to Party
  • Client
  • C_MASSCHANGESALESCONTRACT.BILLTOPARTY == KNA1.KUNNR
  • C_MASSCHANGESALESCONTRACT.PAYERPARTY == KNA1.KUNNR
  • C_MASSCHANGESALESCONTRACT.SHIPTOPARTY == KNA1.KUNNR
  • C_MASSCHANGESALESCONTRACT.SOLDTOPARTY == KNA1.KUNNR
  • C_MASSCHANGESALESCONTRACT.MANDT == KNA1.MANDT
Currency in order header
  • Client
  • SD Document Currency
  • C_MASSCHANGESALESCONTRACT.MANDT == TCURC.MANDT
  • C_MASSCHANGESALESCONTRACT.TRANSACTIONCURRENCY == TCURC.WAERS
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Sales office
  • Distribution Channel
  • Client
  • Organization Division
  • Sales Organization
  • C_MASSCHANGESALESCONTRACT.SALESOFFICE == TVKBZ.VKBUR
  • C_MASSCHANGESALESCONTRACT.DISTRIBUTIONCHANNEL == TVKBZ.VTWEG
  • C_MASSCHANGESALESCONTRACT.MANDT == TVKBZ.MANDT
  • C_MASSCHANGESALESCONTRACT.ORGANIZATIONDIVISION == TVKBZ.SPART
  • C_MASSCHANGESALESCONTRACT.SALESORGANIZATION == TVKBZ.VKORG