C_MassChgSlsOrdWthoutChrgItem

Mass Change of Sls Ord Without Charge Item | view: CSDMCSLSORDWOITM | TRAN | Extraction: Not supported | Component: Mass Change of Sales Documents
Tables used: VBAP, VBKD, VEDA, VBAK, VBAK, VBAP, VBKD, VEDA, MARA, KNA1, TPRIO, TPRIT, MARA, MAKT, TVAP, TVAPT, TVAG, TVAGT, TVKO, TVKOT, PRPS
Column Name Description
SalesOrderWithoutCharge FK Sales Order Without Charge
SalesOrderWithoutChargeItem Sales Document Item
Column Name Description
💲 SD Document Currency (TransactionCurrency):
TotalNetAmount Net Value of the Sales Order in Document Currency
NetAmount Net Value of the Order Item in Document Currency
Column Name Description
📏 Unit of the Requested Quantity (RequestedQuantityUnit):
RequestedQuantity REQUESTED_QUANTITY
Column Name Description
CreationDate Date on which the record was created
RequestedDeliveryDate Requested Delivery Date
BillingDocumentDate Billing Date
CustomerPurchaseOrderDate Customer Reference Date
SalesOrderWithoutChargeDate Document Date (Date Received/Sent)
PricingDate Date for Pricing and Exchange Rate
Column Name Description
SDDocumentCategory SD Document Category Show values
OverallSDProcessStatus Overall Processing Status (Header/All Items) Show values
OverallTotalDeliveryStatus Overall Delivery Status (All Items) Show values
OverallSDDocumentRejectionSts Rejection Status (All Items) Show values
OverallDeliveryStatus Delivery Status (All Items) Show values
OverallOrdReltdBillgStatus Order-Related Billing Status (All Items) Show values
TotalBlockStatus Overall Block Status (Header) Show values
TotalCreditCheckStatus Credit 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
ContractDownPaymentStatus Down Payment Status (Header) Show values
DeliveryStatus Overall Delivery Status of the Item Show values
SDProcessStatus Overall Processing Status (Item) Show values
TotalDeliveryStatus Overall Delivery Status (All Items) 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 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
DeliveryConfirmationStatus Delivery Confirmation 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
SafetyDataSheetStatus Safety Data Sheet Status (Item) Show values
ContractItemDownPaymentStatus Down Payment Status Show values
ItemIsDeliveryRelevant Item Is Relevant for Delivery Show values
SlsDocMassChgEntityLevel Entity Level Show values
Column Name Description Domain name
CreatedByUser Name of Person Responsible for Creating the Object USNAM
SalesOrganizationName Sales Organization Description TEXT20
SalesOrganization Sales Organization VKORG
DistributionChannel Distribution Channel VTWEG
OrganizationDivision Organization Division SPART
SalesGroup Sales group VKGRP
SalesOffice Sales office VKBUR
ShippingCondition Shipping Conditions VSBED
IncotermsTransferLocation Incoterms (Part 2) INCO2
IncotermsLocation1 Incoterms Location 1 INCO_L
IncotermsLocation2 Incoterms Location 2 INCO_L
ProfitCenter Profit Center PRCTR
WBSElementExternalID Work Breakdown Structure Element (WBS Element) Edited PS_POSID_EDIT
CostCenter Cost Center KOSTL
PurchaseOrderByCustomer Customer Reference BSTKD
AdditionalCustomerGroup1 Customer Group 1 KVGR1
AdditionalCustomerGroup2 Customer Group 2 KVGR2
AdditionalCustomerGroup3 Customer Group 3 KVGR3
AdditionalCustomerGroup4 Customer Group 4 KVGR4
AdditionalCustomerGroup5 Customer Group 5 KVGR5
CustomerPaymentTerms Terms of payment key ZTERM
BusinessSolutionOrder Solution Order CRM_OBJECT_ID
MasterSalesContract Master Contract Number VBELN
SalesDocumentItemCategoryName Description TEXT20
ProductName Product Description TEXT40
Plant Plant (Own or External) WERKS
DeliveryPriorityDesc Description TEXT20
SalesDocumentRjcnReasonName Description TEXT40
SoldToParty Sold-to Party KUNNR
OrganizationBPName1 Name 1 NAME
OrganizationBPName2 Name 2 NAME
ShipToParty Ship-to Party KUNNR
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
SlsDocMassChangeRequestUUID null
SalesDocumentItemText Short text for sales order item TEXT40
SalesOrderWithoutChargeType Sales Order Without Charge Type AUART
SalesDocumentType Sales Document Type AUART
Master Data Relations Join Conditions
Batch Number
  • Client
  • Product Number
  • Material Number
  • Batch Number
  • Plant (Own or External)
  • C_MASSCHGSLSORDWTHOUTCHRGITEM.MANDT == MCHA.MANDT
  • C_MASSCHGSLSORDWTHOUTCHRGITEM.PRODUCT == MCHA.MATNR
  • C_MASSCHGSLSORDWTHOUTCHRGITEM.MATERIAL == MCHA.MATNR
  • C_MASSCHGSLSORDWTHOUTCHRGITEM.BATCH == MCHA.CHARG
  • C_MASSCHGSLSORDWTHOUTCHRGITEM.PLANT == MCHA.WERKS
Company Code to Be Billed
  • Company Code to Be Billed
  • Client
  • C_MASSCHGSLSORDWTHOUTCHRGITEM.BILLINGCOMPANYCODE == T001.BUKRS
  • C_MASSCHGSLSORDWTHOUTCHRGITEM.MANDT == T001.MANDT
Business Area
  • Business Area
  • Client
  • C_MASSCHGSLSORDWTHOUTCHRGITEM.BUSINESSAREA == TGSB.GSBER
  • C_MASSCHGSLSORDWTHOUTCHRGITEM.MANDT == TGSB.MANDT
Controlling Area
  • Controlling Area
  • Client
  • C_MASSCHGSLSORDWTHOUTCHRGITEM.CONTROLLINGAREA == TKA01.KOKRS
  • C_MASSCHGSLSORDWTHOUTCHRGITEM.MANDT == TKA01.MANDT
Credit control area
  • Client
  • Credit control area
  • C_MASSCHGSLSORDWTHOUTCHRGITEM.MANDT == T014.MANDT
  • C_MASSCHGSLSORDWTHOUTCHRGITEM.CREDITCONTROLAREA == T014.KKBER
Customer Group
  • Client
  • Customer Group
  • C_MASSCHGSLSORDWTHOUTCHRGITEM.MANDT == T151.MANDT
  • C_MASSCHGSLSORDWTHOUTCHRGITEM.CUSTOMERGROUP == T151.KDGRP
Delivery Block (Document Header)
  • Delivery Block (Document Header)
  • Client
  • C_MASSCHGSLSORDWTHOUTCHRGITEM.DELIVERYBLOCKREASON == TVLS.LIFSP
  • C_MASSCHGSLSORDWTHOUTCHRGITEM.MANDT == TVLS.MANDT
Delivery Priority
  • Delivery Priority
  • Client
  • C_MASSCHGSLSORDWTHOUTCHRGITEM.DELIVERYPRIORITY == TPRIO.LPRIO
  • C_MASSCHGSLSORDWTHOUTCHRGITEM.MANDT == TPRIO.MANDT
Division
  • Client
  • Division
  • C_MASSCHGSLSORDWTHOUTCHRGITEM.MANDT == TSPA.MANDT
  • C_MASSCHGSLSORDWTHOUTCHRGITEM.DIVISION == TSPA.SPART
Header Billing Block Reason
  • Header Billing Block Reason
  • Client
  • C_MASSCHGSLSORDWTHOUTCHRGITEM.HEADERBILLINGBLOCKREASON == TVFS.FAKSP
  • C_MASSCHGSLSORDWTHOUTCHRGITEM.MANDT == TVFS.MANDT
Incoterms (Part 1)
  • Incoterms (Part 1)
  • Client
  • C_MASSCHGSLSORDWTHOUTCHRGITEM.INCOTERMSCLASSIFICATION == TINC.INCO1
  • C_MASSCHGSLSORDWTHOUTCHRGITEM.MANDT == TINC.MANDT
Incoterms Version
  • Incoterms Version
  • Client
  • C_MASSCHGSLSORDWTHOUTCHRGITEM.INCOTERMSVERSION == TINCV.INCOV
  • C_MASSCHGSLSORDWTHOUTCHRGITEM.MANDT == TINCV.MANDT
Billing Block for Item
  • Client
  • Billing Block for Item
  • C_MASSCHGSLSORDWTHOUTCHRGITEM.MANDT == TVFS.MANDT
  • C_MASSCHGSLSORDWTHOUTCHRGITEM.ITEMBILLINGBLOCKREASON == TVFS.FAKSP
Material: order item
  • Client
  • Product Number
  • Material Number
  • C_MASSCHGSLSORDWTHOUTCHRGITEM.MANDT == MARA.MANDT
  • C_MASSCHGSLSORDWTHOUTCHRGITEM.PRODUCT == MARA.MATNR
  • C_MASSCHGSLSORDWTHOUTCHRGITEM.MATERIAL == MARA.MATNR
Order Number
  • Client
  • Order Number
  • C_MASSCHGSLSORDWTHOUTCHRGITEM.MANDT == AUFK.MANDT
  • C_MASSCHGSLSORDWTHOUTCHRGITEM.ORDERID == AUFK.AUFNR
Payment Method
  • ?
  • Client
  • Payment Method
  • C_MASSCHGSLSORDWTHOUTCHRGITEM.[column in domain "LAND1"] == T042Z.LAND1
  • C_MASSCHGSLSORDWTHOUTCHRGITEM.MANDT == T042Z.MANDT
  • C_MASSCHGSLSORDWTHOUTCHRGITEM.PAYMENTMETHOD == T042Z.ZLSCH
Material: order item
  • Client
  • Product Number
  • Material Number
  • C_MASSCHGSLSORDWTHOUTCHRGITEM.MANDT == MARA.MANDT
  • C_MASSCHGSLSORDWTHOUTCHRGITEM.PRODUCT == MARA.MATNR
  • C_MASSCHGSLSORDWTHOUTCHRGITEM.MATERIAL == MARA.MATNR
Route
  • Client
  • Route
  • C_MASSCHGSLSORDWTHOUTCHRGITEM.MANDT == TVRO.MANDT
  • C_MASSCHGSLSORDWTHOUTCHRGITEM.ROUTE == TVRO.ROUTE
Sales District
  • Sales District
  • Client
  • C_MASSCHGSLSORDWTHOUTCHRGITEM.SALESDISTRICT == T171.BZIRK
  • C_MASSCHGSLSORDWTHOUTCHRGITEM.MANDT == T171.MANDT
Reason for Rejection of Sales Documents
  • Client
  • Reason for Rejection of Sales Documents
  • C_MASSCHGSLSORDWTHOUTCHRGITEM.MANDT == TVAG.MANDT
  • C_MASSCHGSLSORDWTHOUTCHRGITEM.SALESDOCUMENTRJCNREASON == TVAG.ABGRU
Order Reason (Reason for the Business Transaction)
  • Client
  • Order Reason (Reason for the Business Transaction)
  • C_MASSCHGSLSORDWTHOUTCHRGITEM.MANDT == TVAU.MANDT
  • C_MASSCHGSLSORDWTHOUTCHRGITEM.SDDOCUMENTREASON == TVAU.AUGRU
Shipping Point / Receiving Point
  • Client
  • Shipping Point / Receiving Point
  • C_MASSCHGSLSORDWTHOUTCHRGITEM.MANDT == TVST.MANDT
  • C_MASSCHGSLSORDWTHOUTCHRGITEM.SHIPPINGPOINT == TVST.VSTEL
Shipping Type
  • Client
  • Shipping Type
  • C_MASSCHGSLSORDWTHOUTCHRGITEM.MANDT == T173.MANDT
  • C_MASSCHGSLSORDWTHOUTCHRGITEM.SHIPPINGTYPE == T173.VSART
Approval Request Reason ID
  • Approval Request Reason ID
  • Client
  • C_MASSCHGSLSORDWTHOUTCHRGITEM.SLSORDWTHOUTCHRGAPPRVLREASON == SDAPMAPRR.APM_APPROVAL_REASON
  • C_MASSCHGSLSORDWTHOUTCHRGITEM.MANDT == SDAPMAPRR.CLIENT
Sales document item category
  • Client
  • Sales document item category
  • C_MASSCHGSLSORDWTHOUTCHRGITEM.MANDT == TVPT.MANDT
  • C_MASSCHGSLSORDWTHOUTCHRGITEM.SLSORDWTHOUTCHRGITEMCATEGORY == TVPT.PSTYV
Storage location
  • Client
  • Plant (Own or External)
  • Storage location
  • C_MASSCHGSLSORDWTHOUTCHRGITEM.MANDT == T001L.MANDT
  • C_MASSCHGSLSORDWTHOUTCHRGITEM.PLANT == T001L.WERKS
  • C_MASSCHGSLSORDWTHOUTCHRGITEM.STORAGELOCATION == T001L.LGORT
SD Document Currency
  • Client
  • SD Document Currency
  • C_MASSCHGSLSORDWTHOUTCHRGITEM.MANDT == TCURC.MANDT
  • C_MASSCHGSLSORDWTHOUTCHRGITEM.TRANSACTIONCURRENCY == TCURC.WAERS