C_MassChangeSlsSchedgAgrmt

Mass Change of Sales Scheduling Agreement | view: CSDMCSLSSCHAGMT | TRAN | Extraction: Not supported | Component: Mass Change of Sales Documents
Tables used: VBKD, VEDA, VBAK, VBPA, VBPA, CVI_CUST_CT_LINK, BUT000, CVI_CUST_LINK, CVI_VEND_LINK
Column Name Description
SalesSchedulingAgreement Sales Scheduling Agreement
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
BillingDocumentDate Billing Date
PricingDate Date for Pricing and Exchange Rate
SalesSchedgAgrmtDate Document Date (Date Received/Sent)
Column Name Description
DelivSchedTypeMRPRlvnceCode MRP for delivery schedule type Show values
SalesSchedgAgrmtProcessingType Sales Scheduling Agreement Processing Type Show values
OverallSDProcessStatus Overall Processing Status (Header/All Items) Show values
OverallTotalDeliveryStatus Overall Delivery Status (All Items) Show values
OverallDeliveryStatus Delivery Status (All Items) Show values
SalesDocApprovalStatus Document Approval Status Show values
TotalBlockStatus Overall Block Status (Header) Show values
TotalCreditCheckStatus Credit Status (All Items) 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
OverallDelivConfStatus Delivery Confirmation Status (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
OverallSafetyDataSheetStatus Safety Data Sheet Status (All Items) Show values
TotalDeliveryStatus Overall Delivery 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
DeliveryBlockStatus Delivery Block 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
DeliveryConfirmationStatus Delivery Confirmation 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
SafetyDataSheetStatus Safety Data Sheet Status (Item) Show values
SDDocReferenceStatus Reference Status (Item) Show values
ItemIsDeliveryRelevant Item Is Relevant for Delivery Show values
SlsDocMassChgEntityLevel Entity Level Show values
SDDocumentCategory SD Document Category Show values
Column Name Description Domain name
CreatedByUser Name of Person Responsible for Creating the Object USNAM
PurchaseOrderByCustomer Customer Reference BSTKD
CostCenter Cost Center KOSTL
ResponsibleEmployee Employee Responsible PERNR
SalesEmployee Sales Employee PERNR
CustomerPaymentTerms Terms of payment key ZTERM
IncotermsLocation1 Incoterms Location 1 INCO_L
IncotermsLocation2 Incoterms Location 2 INCO_L
SalesSchedgAgrmtItemCategory null
Product Product Number MATNR
Batch Batch Number CHARG
Division null
ProfitCenter Profit Center PRCTR
SalesDocumentRjcnReason Reason for Rejection of Sales Documents ABGRU_VA
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
DeliveryPriority Delivery Priority LPRIO
Route null
StorageLocation null
ShippingPoint null
AdditionalPartnerName null
SlsDocMassChangeRequestUUID null
Master Data Relations Join Conditions
Customer Group 1
  • Client
  • Customer Group 1
  • C_MASSCHANGESLSSCHEDGAGRMT.MANDT == TVV1.MANDT
  • C_MASSCHANGESLSSCHEDGAGRMT.ADDITIONALCUSTOMERGROUP1 == TVV1.KVGR1
Customer Group 2
  • Client
  • Customer Group 2
  • C_MASSCHANGESLSSCHEDGAGRMT.MANDT == TVV2.MANDT
  • C_MASSCHANGESLSSCHEDGAGRMT.ADDITIONALCUSTOMERGROUP2 == TVV2.KVGR2
Customer Group 3
  • Client
  • Customer Group 3
  • C_MASSCHANGESLSSCHEDGAGRMT.MANDT == TVV3.MANDT
  • C_MASSCHANGESLSSCHEDGAGRMT.ADDITIONALCUSTOMERGROUP3 == TVV3.KVGR3
Customer Group 4
  • Customer Group 4
  • Client
  • C_MASSCHANGESLSSCHEDGAGRMT.ADDITIONALCUSTOMERGROUP4 == TVV4.KVGR4
  • C_MASSCHANGESLSSCHEDGAGRMT.MANDT == TVV4.MANDT
Customer Group 5
  • Client
  • Customer Group 5
  • C_MASSCHANGESLSSCHEDGAGRMT.MANDT == TVV5.MANDT
  • C_MASSCHANGESLSSCHEDGAGRMT.ADDITIONALCUSTOMERGROUP5 == TVV5.KVGR5
Company Code to Be Billed
  • Client
  • Company Code to Be Billed
  • C_MASSCHANGESLSSCHEDGAGRMT.MANDT == T001.MANDT
  • C_MASSCHANGESLSSCHEDGAGRMT.BILLINGCOMPANYCODE == T001.BUKRS
Customer - Document Customer
  • Bill-to Party
  • Ship-to Party
  • Payer
  • Sold-to Party
  • Client
  • C_MASSCHANGESLSSCHEDGAGRMT.BILLTOPARTY == KNA1.KUNNR
  • C_MASSCHANGESLSSCHEDGAGRMT.SHIPTOPARTY == KNA1.KUNNR
  • C_MASSCHANGESLSSCHEDGAGRMT.PAYERPARTY == KNA1.KUNNR
  • C_MASSCHANGESLSSCHEDGAGRMT.SOLDTOPARTY == KNA1.KUNNR
  • C_MASSCHANGESLSSCHEDGAGRMT.MANDT == KNA1.MANDT
Business Area
  • Client
  • Business Area
  • C_MASSCHANGESLSSCHEDGAGRMT.MANDT == TGSB.MANDT
  • C_MASSCHANGESLSSCHEDGAGRMT.BUSINESSAREA == TGSB.GSBER
Controlling Area
  • Client
  • Controlling Area
  • C_MASSCHANGESLSSCHEDGAGRMT.MANDT == TKA01.MANDT
  • C_MASSCHANGESLSSCHEDGAGRMT.CONTROLLINGAREA == TKA01.KOKRS
Credit control area
  • Client
  • Credit control area
  • C_MASSCHANGESLSSCHEDGAGRMT.MANDT == T014.MANDT
  • C_MASSCHANGESLSSCHEDGAGRMT.CREDITCONTROLAREA == T014.KKBER
Customer Group
  • Client
  • Customer Group
  • C_MASSCHANGESLSSCHEDGAGRMT.MANDT == T151.MANDT
  • C_MASSCHANGESLSSCHEDGAGRMT.CUSTOMERGROUP == T151.KDGRP
Delivery Block (Document Header)
  • Delivery Block (Document Header)
  • Client
  • C_MASSCHANGESLSSCHEDGAGRMT.DELIVERYBLOCKREASON == TVLS.LIFSP
  • C_MASSCHANGESLSSCHEDGAGRMT.MANDT == TVLS.MANDT
Distribution channel in order header
  • Client
  • Sales Organization
  • Distribution Channel
  • C_MASSCHANGESLSSCHEDGAGRMT.MANDT == TVKOV.MANDT
  • C_MASSCHANGESLSSCHEDGAGRMT.SALESORGANIZATION == TVKOV.VKORG
  • C_MASSCHANGESLSSCHEDGAGRMT.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
Incoterms (Part 1)
  • Incoterms (Part 1)
  • Client
  • C_MASSCHANGESLSSCHEDGAGRMT.INCOTERMSCLASSIFICATION == TINC.INCO1
  • C_MASSCHANGESLSSCHEDGAGRMT.MANDT == TINC.MANDT
Incoterms Version
  • Incoterms Version
  • Client
  • C_MASSCHANGESLSSCHEDGAGRMT.INCOTERMSVERSION == TINCV.INCOV
  • C_MASSCHANGESLSSCHEDGAGRMT.MANDT == TINCV.MANDT
Order Number
  • Order Number
  • Client
  • C_MASSCHANGESLSSCHEDGAGRMT.ORDERID == AUFK.AUFNR
  • C_MASSCHANGESLSSCHEDGAGRMT.MANDT == AUFK.MANDT
Division in order header
  • Client
  • Sales Organization
  • Organization Division
  • Distribution Channel
  • C_MASSCHANGESLSSCHEDGAGRMT.MANDT == TVTA.MANDT
  • C_MASSCHANGESLSSCHEDGAGRMT.SALESORGANIZATION == TVTA.VKORG
  • C_MASSCHANGESLSSCHEDGAGRMT.ORGANIZATIONDIVISION == TVTA.SPART
  • C_MASSCHANGESLSSCHEDGAGRMT.DISTRIBUTIONCHANNEL == TVTA.VTWEG
Customer - Document Customer
  • Bill-to Party
  • Ship-to Party
  • Payer
  • Sold-to Party
  • Client
  • C_MASSCHANGESLSSCHEDGAGRMT.BILLTOPARTY == KNA1.KUNNR
  • C_MASSCHANGESLSSCHEDGAGRMT.SHIPTOPARTY == KNA1.KUNNR
  • C_MASSCHANGESLSSCHEDGAGRMT.PAYERPARTY == KNA1.KUNNR
  • C_MASSCHANGESLSSCHEDGAGRMT.SOLDTOPARTY == KNA1.KUNNR
  • C_MASSCHANGESLSSCHEDGAGRMT.MANDT == KNA1.MANDT
Payment Method
  • ?
  • Client
  • Payment Method
  • C_MASSCHANGESLSSCHEDGAGRMT.[column in domain "LAND1"] == T042Z.LAND1
  • C_MASSCHANGESLSSCHEDGAGRMT.MANDT == T042Z.MANDT
  • C_MASSCHANGESLSSCHEDGAGRMT.PAYMENTMETHOD == T042Z.ZLSCH
Sales District
  • Client
  • Sales District
  • C_MASSCHANGESLSSCHEDGAGRMT.MANDT == T171.MANDT
  • C_MASSCHANGESLSSCHEDGAGRMT.SALESDISTRICT == T171.BZIRK
Approval Request Reason ID
  • Client
  • Approval Request Reason ID
  • C_MASSCHANGESLSSCHEDGAGRMT.MANDT == SDAPMAPRR.CLIENT
  • C_MASSCHANGESLSSCHEDGAGRMT.SALESDOCAPPROVALREASON == SDAPMAPRR.APM_APPROVAL_REASON
Order type in order header
  • Sales Document Type
  • Sales Scheduling Agreement Type
  • Client
  • C_MASSCHANGESLSSCHEDGAGRMT.SALESDOCUMENTTYPE == TVAK.AUART
  • C_MASSCHANGESLSSCHEDGAGRMT.SALESSCHEDGAGRMTTYPE == TVAK.AUART
  • C_MASSCHANGESLSSCHEDGAGRMT.MANDT == TVAK.MANDT
Sales group
  • Sales group
  • Client
  • Sales office
  • C_MASSCHANGESLSSCHEDGAGRMT.SALESGROUP == TVBVK.VKGRP
  • C_MASSCHANGESLSSCHEDGAGRMT.MANDT == TVBVK.MANDT
  • C_MASSCHANGESLSSCHEDGAGRMT.SALESOFFICE == TVBVK.VKBUR
Sales organization in order header
  • Client
  • Sales Organization
  • C_MASSCHANGESLSSCHEDGAGRMT.MANDT == TVKO.MANDT
  • C_MASSCHANGESLSSCHEDGAGRMT.SALESORGANIZATION == TVKO.VKORG
Order type in order header
  • Sales Document Type
  • Sales Scheduling Agreement Type
  • Client
  • C_MASSCHANGESLSSCHEDGAGRMT.SALESDOCUMENTTYPE == TVAK.AUART
  • C_MASSCHANGESLSSCHEDGAGRMT.SALESSCHEDGAGRMTTYPE == TVAK.AUART
  • C_MASSCHANGESLSSCHEDGAGRMT.MANDT == TVAK.MANDT
Order Reason (Reason for the Business Transaction)
  • Order Reason (Reason for the Business Transaction)
  • Client
  • C_MASSCHANGESLSSCHEDGAGRMT.SDDOCUMENTREASON == TVAU.AUGRU
  • C_MASSCHANGESLSSCHEDGAGRMT.MANDT == TVAU.MANDT
Shipping Conditions
  • Client
  • Shipping Conditions
  • C_MASSCHANGESLSSCHEDGAGRMT.MANDT == TVSB.MANDT
  • C_MASSCHANGESLSSCHEDGAGRMT.SHIPPINGCONDITION == TVSB.VSBED
Shipping Type
  • Client
  • Shipping Type
  • C_MASSCHANGESLSSCHEDGAGRMT.MANDT == T173.MANDT
  • C_MASSCHANGESLSSCHEDGAGRMT.SHIPPINGTYPE == T173.VSART
Customer - Document Customer
  • Bill-to Party
  • Ship-to Party
  • Payer
  • Sold-to Party
  • Client
  • C_MASSCHANGESLSSCHEDGAGRMT.BILLTOPARTY == KNA1.KUNNR
  • C_MASSCHANGESLSSCHEDGAGRMT.SHIPTOPARTY == KNA1.KUNNR
  • C_MASSCHANGESLSSCHEDGAGRMT.PAYERPARTY == KNA1.KUNNR
  • C_MASSCHANGESLSSCHEDGAGRMT.SOLDTOPARTY == KNA1.KUNNR
  • C_MASSCHANGESLSSCHEDGAGRMT.MANDT == KNA1.MANDT
Customer - Document Customer
  • Bill-to Party
  • Ship-to Party
  • Payer
  • Sold-to Party
  • Client
  • C_MASSCHANGESLSSCHEDGAGRMT.BILLTOPARTY == KNA1.KUNNR
  • C_MASSCHANGESLSSCHEDGAGRMT.SHIPTOPARTY == KNA1.KUNNR
  • C_MASSCHANGESLSSCHEDGAGRMT.PAYERPARTY == KNA1.KUNNR
  • C_MASSCHANGESLSSCHEDGAGRMT.SOLDTOPARTY == KNA1.KUNNR
  • C_MASSCHANGESLSSCHEDGAGRMT.MANDT == KNA1.MANDT
Currency in order header
  • SD Document Currency
  • Client
  • C_MASSCHANGESLSSCHEDGAGRMT.TRANSACTIONCURRENCY == TCURC.WAERS
  • C_MASSCHANGESLSSCHEDGAGRMT.MANDT == TCURC.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Client
  • Sales office
  • Sales Organization
  • Organization Division
  • Distribution Channel
  • C_MASSCHANGESLSSCHEDGAGRMT.MANDT == TVKBZ.MANDT
  • C_MASSCHANGESLSSCHEDGAGRMT.SALESOFFICE == TVKBZ.VKBUR
  • C_MASSCHANGESLSSCHEDGAGRMT.SALESORGANIZATION == TVKBZ.VKORG
  • C_MASSCHANGESLSSCHEDGAGRMT.ORGANIZATIONDIVISION == TVKBZ.SPART
  • C_MASSCHANGESLSSCHEDGAGRMT.DISTRIBUTIONCHANNEL == TVKBZ.VTWEG