C_RFM_MaSaDoEditSlsOrdItm

Item Details on Mass Update | view: CRFMMASADOEDTSDI | TRAN | Extraction: Not supported | Component: Retail & Fashion Sales and Distribution
Tables used: VBAK, VBAP, VBKD, VBPA, MARA, KNA1, MARC, TVAK
Column Name Description
SalesOrder FK Sales Document
SalesOrderItem Sales Document Item
Column Name Description
Column Name Description
Column Name Description
RequestedDeliveryDate Requested Delivery Date
FirstDeliveryDate Item delivery date
FashionCancelDate Cancellation Date
SlsOrdFashionCancelDate Cancellation Date
PricingDate Date for Pricing and Exchange Rate
SlsOrdPricingDate Date for Pricing and Exchange Rate
BillingDocumentDate Billing Date
SalesDocumentDate Document Date (Date Received/Sent)
CreationDate Date on which the record was created
CustomerPurchaseOrderDate Customer Reference Date
AgrmtValdtyStartDate Valid-From Date (Outline Agreements, Product Proposals)
AgrmtValdtyEndDate Valid-To Date (Outline Agreements, Product Proposals)
Column Name Description
SDDocumentCategory SD Document Category Show values
HdrGeneralIncompletionStatus Incompletion Status (Header) Show values
OvrlItmGeneralIncompletionSts Incompletion Status (All Items) Show values
TotalCreditCheckStatus Overall Status of Credit Checks Show values
HeaderBillgIncompletionStatus Billing Incompletion Status (Header) Show values
OvrlItmBillingIncompletionSts Billing Incompletion Status (All Items) Show values
OverallPricingIncompletionSts Pricing Incompletion Status (All Items) Show values
HeaderDelivIncompletionStatus Delivery Incompletion Status (Header) Show values
OvrlItmDelivIncompletionSts Delivery Incompletion Status (All Items) Show values
RqmtIsSupAssgmtRelevant Indicates if Supply Assignment is Relevant for Item Show values
SalesDocumentHasRejection Checkbox Show values
RFM_SD_ApplJobAction Action Show values
Column Name Description Domain name
FormattedSalesDocumentItem Sales Document Item CHAR17
RequirementSegment Requirement Segment SGT_SRCA
Plant Plant (Own or External) WERKS
CustomerPaymentTerms Terms of payment key ZTERM
SlsOrdCustomerPaymentTerms Terms of payment key ZTERM
IncotermsLocation1 Incoterms Location 1 INCO_L
SlsOrdIncotermsLocation1 Incoterms Location 1 INCO_L
HigherLevelItem Higher-Level Item in Bill of Material Structures POSNR
MaterialByCustomer Material Number Used by Customer IDNEX
CreatedByUser Name of Person Responsible for Creating the Object USNAM
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
PurchaseOrderByCustomer Customer Reference BSTKD
PricingType null
ReleaseDateTime null
InternalComment null
SalesDocsInclusionListValue null
SalesDocsExclusionListValue null
SalesOrdItemsAreSelected null
SalesOrdItemIsSelected null
SalesOrdHeadersAreSelected null
SalesOrdGnrcArticleIsSelected null
MngSlsOrdsMassUpdateExecMode null
Master Data Relations Join Conditions
Material Group 1
  • Client
  • Material Group 1
  • C_RFM_MASADOEDITSLSORDITM.MANDT == TVM1.MANDT
  • C_RFM_MASADOEDITSLSORDITM.ADDITIONALMATERIALGROUP1 == TVM1.MVGR1
Material Group 2
  • Client
  • Material Group 2
  • C_RFM_MASADOEDITSLSORDITM.MANDT == TVM2.MANDT
  • C_RFM_MASADOEDITSLSORDITM.ADDITIONALMATERIALGROUP2 == TVM2.MVGR2
Material Group 3
  • Client
  • Material Group 3
  • C_RFM_MASADOEDITSLSORDITM.MANDT == TVM3.MANDT
  • C_RFM_MASADOEDITSLSORDITM.ADDITIONALMATERIALGROUP3 == TVM3.MVGR3
Material Group 4
  • Client
  • Material Group 4
  • C_RFM_MASADOEDITSLSORDITM.MANDT == TVM4.MANDT
  • C_RFM_MASADOEDITSLSORDITM.ADDITIONALMATERIALGROUP4 == TVM4.MVGR4
Material Group 5
  • Client
  • Material Group 5
  • C_RFM_MASADOEDITSLSORDITM.MANDT == TVM5.MANDT
  • C_RFM_MASADOEDITSLSORDITM.ADDITIONALMATERIALGROUP5 == TVM5.MVGR5
Batch Number
  • Client
  • Batch Number
  • Material Number
  • Plant (Own or External)
  • C_RFM_MASADOEDITSLSORDITM.MANDT == MCHA.MANDT
  • C_RFM_MASADOEDITSLSORDITM.BATCH == MCHA.CHARG
  • C_RFM_MASADOEDITSLSORDITM.MATERIAL == MCHA.MATNR
  • C_RFM_MASADOEDITSLSORDITM.PLANT == MCHA.WERKS
Customer condition group 1
  • Client
  • Customer condition group 1
  • Customer condition group 1
  • C_RFM_MASADOEDITSLSORDITM.MANDT == TVKGG.MANDT
  • C_RFM_MASADOEDITSLSORDITM.SLSORDCUSTOMERCONDITIONGROUP1 == TVKGG.KDKGR
  • C_RFM_MASADOEDITSLSORDITM.CUSTOMERCONDITIONGROUP1 == TVKGG.KDKGR
Customer condition group 2
  • Customer condition group 2
  • Customer condition group 2
  • Client
  • C_RFM_MASADOEDITSLSORDITM.SLSORDCUSTOMERCONDITIONGROUP2 == TVKGG.KDKGR
  • C_RFM_MASADOEDITSLSORDITM.CUSTOMERCONDITIONGROUP2 == TVKGG.KDKGR
  • C_RFM_MASADOEDITSLSORDITM.MANDT == TVKGG.MANDT
Customer condition group 3
  • Client
  • Customer condition group 3
  • Customer condition group 3
  • C_RFM_MASADOEDITSLSORDITM.MANDT == TVKGG.MANDT
  • C_RFM_MASADOEDITSLSORDITM.CUSTOMERCONDITIONGROUP3 == TVKGG.KDKGR
  • C_RFM_MASADOEDITSLSORDITM.SLSORDCUSTOMERCONDITIONGROUP3 == TVKGG.KDKGR
Customer condition group 4
  • Client
  • Customer condition group 4
  • Customer condition group 4
  • C_RFM_MASADOEDITSLSORDITM.MANDT == TVKGG.MANDT
  • C_RFM_MASADOEDITSLSORDITM.CUSTOMERCONDITIONGROUP4 == TVKGG.KDKGR
  • C_RFM_MASADOEDITSLSORDITM.SLSORDCUSTOMERCONDITIONGROUP4 == TVKGG.KDKGR
Customer condition group 5
  • Client
  • Customer condition group 5
  • Customer condition group 5
  • C_RFM_MASADOEDITSLSORDITM.MANDT == TVKGG.MANDT
  • C_RFM_MASADOEDITSLSORDITM.CUSTOMERCONDITIONGROUP5 == TVKGG.KDKGR
  • C_RFM_MASADOEDITSLSORDITM.SLSORDCUSTOMERCONDITIONGROUP5 == TVKGG.KDKGR
Customer Group
  • Client
  • Customer Group
  • C_RFM_MASADOEDITSLSORDITM.MANDT == T151.MANDT
  • C_RFM_MASADOEDITSLSORDITM.CUSTOMERGROUP == T151.KDGRP
Customer Price Group
  • Client
  • Customer Price Group
  • Customer Price Group
  • C_RFM_MASADOEDITSLSORDITM.MANDT == T188.MANDT
  • C_RFM_MASADOEDITSLSORDITM.CUSTOMERPRICEGROUP == T188.KONDA
  • C_RFM_MASADOEDITSLSORDITM.SALESORDERCUSTOMERPRICEGROUP == T188.KONDA
Customer Purchase Order Type
  • Client
  • Customer Purchase Order Type
  • Customer Purchase Order Type
  • C_RFM_MASADOEDITSLSORDITM.MANDT == T176.MANDT
  • C_RFM_MASADOEDITSLSORDITM.SLSORDCUSTOMERPURCHASEORDTYPE == T176.BSARK
  • C_RFM_MASADOEDITSLSORDITM.CUSTOMERPURCHASEORDERTYPE == T176.BSARK
Delivery Block (Document Header)
  • Client
  • Delivery Block (Document Header)
  • C_RFM_MASADOEDITSLSORDITM.MANDT == TVLS.MANDT
  • C_RFM_MASADOEDITSLSORDITM.DELIVERYBLOCKREASON == TVLS.LIFSP
Delivery Priority
  • Client
  • Delivery Priority
  • C_RFM_MASADOEDITSLSORDITM.MANDT == TPRIO.MANDT
  • C_RFM_MASADOEDITSLSORDITM.DELIVERYPRIORITY == TPRIO.LPRIO
Department number
  • Department number
  • Client
  • C_RFM_MASADOEDITSLSORDITM.DEPARTMENTCLASSIFICATIONBYCUST == TSAB.ABTNR
  • C_RFM_MASADOEDITSLSORDITM.MANDT == TSAB.MANDT
Distribution channel in order header
  • Client
  • Distribution Channel
  • Sales Organization
  • C_RFM_MASADOEDITSLSORDITM.MANDT == TVKOV.MANDT
  • C_RFM_MASADOEDITSLSORDITM.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • C_RFM_MASADOEDITSLSORDITM.SALESORGANIZATION == TVKOV.VKORG
Billing Block in SD Document
  • Client
  • Billing Block in SD Document
  • C_RFM_MASADOEDITSLSORDITM.MANDT == TVFS.MANDT
  • C_RFM_MASADOEDITSLSORDITM.HEADERBILLINGBLOCKREASON == TVFS.FAKSP
Incoterms (Part 1)
  • Client
  • Incoterms (Part 1)
  • Incoterms (Part 1)
  • C_RFM_MASADOEDITSLSORDITM.MANDT == TINC.MANDT
  • C_RFM_MASADOEDITSLSORDITM.INCOTERMSCLASSIFICATION == TINC.INCO1
  • C_RFM_MASADOEDITSLSORDITM.SLSORDINCOTERMSCLASSIFICATION == TINC.INCO1
Material: order item
  • Client
  • Material Number
  • C_RFM_MASADOEDITSLSORDITM.MANDT == MARA.MANDT
  • C_RFM_MASADOEDITSLSORDITM.MATERIAL == MARA.MATNR
Material Price Group
  • Client
  • Material Price Group
  • C_RFM_MASADOEDITSLSORDITM.MANDT == T178.MANDT
  • C_RFM_MASADOEDITSLSORDITM.MATERIALPRICINGGROUP == T178.KONDM
Division in order header
  • Client
  • Division
  • Distribution Channel
  • Sales Organization
  • C_RFM_MASADOEDITSLSORDITM.MANDT == TVTA.MANDT
  • C_RFM_MASADOEDITSLSORDITM.ORGANIZATIONDIVISION == TVTA.SPART
  • C_RFM_MASADOEDITSLSORDITM.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • C_RFM_MASADOEDITSLSORDITM.SALESORGANIZATION == TVTA.VKORG
Fashion Collection
  • Client
  • Fashion Collection
  • Season
  • Season Year
Product Group
  • Client
  • Product Group
  • C_RFM_MASADOEDITSLSORDITM.MANDT == T023.MANDT
  • C_RFM_MASADOEDITSLSORDITM.PRODUCTGROUP == T023.MATKL
Season
  • Client
  • Season
  • Season Year
  • C_RFM_MASADOEDITSLSORDITM.MANDT == FSH_SEASONS.MANDT
  • C_RFM_MASADOEDITSLSORDITM.PRODUCTSEASON == FSH_SEASONS.FSH_SEASON
  • C_RFM_MASADOEDITSLSORDITM.PRODUCTSEASONYEAR == FSH_SEASONS.FSH_SEASON_YEAR
Season Year
  • Client
  • Season
  • Season Year
  • C_RFM_MASADOEDITSLSORDITM.MANDT == FSH_SEASONS.MANDT
  • C_RFM_MASADOEDITSLSORDITM.PRODUCTSEASON == FSH_SEASONS.FSH_SEASON
  • C_RFM_MASADOEDITSLSORDITM.PRODUCTSEASONYEAR == FSH_SEASONS.FSH_SEASON_YEAR
Fashion Theme
  • Fashion Theme
  • Client
  • Fashion Collection
  • Season
  • Season Year
  • C_RFM_MASADOEDITSLSORDITM.PRODUCTTHEME == FSH_THEMES.FSH_THEME
  • C_RFM_MASADOEDITSLSORDITM.MANDT == FSH_THEMES.MANDT
  • C_RFM_MASADOEDITSLSORDITM.PRODUCTCOLLECTION == FSH_THEMES.FSH_COLLECTION
  • C_RFM_MASADOEDITSLSORDITM.PRODUCTSEASON == FSH_THEMES.FSH_SEASON
  • C_RFM_MASADOEDITSLSORDITM.PRODUCTSEASONYEAR == FSH_THEMES.FSH_SEASON_YEAR
Customer Group 10
  • Customer Group 10
  • Client
  • Sales Organization
  • C_RFM_MASADOEDITSLSORDITM.RETAILADDITIONALCUSTOMERGRP10 == FSH_TVV10.KVGR10
  • C_RFM_MASADOEDITSLSORDITM.MANDT == FSH_TVV10.MANDT
  • C_RFM_MASADOEDITSLSORDITM.SALESORGANIZATION == FSH_TVV10.VKORG
Customer Group 6
  • Customer Group 6
  • Client
  • Sales Organization
  • C_RFM_MASADOEDITSLSORDITM.RETAILADDITIONALCUSTOMERGRP6 == FSH_TVV6.KVGR6
  • C_RFM_MASADOEDITSLSORDITM.MANDT == FSH_TVV6.MANDT
  • C_RFM_MASADOEDITSLSORDITM.SALESORGANIZATION == FSH_TVV6.VKORG
Customer Group 7
  • Client
  • Customer Group 7
  • Sales Organization
  • C_RFM_MASADOEDITSLSORDITM.MANDT == FSH_TVV7.MANDT
  • C_RFM_MASADOEDITSLSORDITM.RETAILADDITIONALCUSTOMERGRP7 == FSH_TVV7.KVGR7
  • C_RFM_MASADOEDITSLSORDITM.SALESORGANIZATION == FSH_TVV7.VKORG
Customer Group 8
  • Client
  • Customer Group 8
  • Sales Organization
  • C_RFM_MASADOEDITSLSORDITM.MANDT == FSH_TVV8.MANDT
  • C_RFM_MASADOEDITSLSORDITM.RETAILADDITIONALCUSTOMERGRP8 == FSH_TVV8.KVGR8
  • C_RFM_MASADOEDITSLSORDITM.SALESORGANIZATION == FSH_TVV8.VKORG
Customer Group 9
  • Customer Group 9
  • Client
  • Sales Organization
  • C_RFM_MASADOEDITSLSORDITM.RETAILADDITIONALCUSTOMERGRP9 == FSH_TVV9.KVGR9
  • C_RFM_MASADOEDITSLSORDITM.MANDT == FSH_TVV9.MANDT
  • C_RFM_MASADOEDITSLSORDITM.SALESORGANIZATION == FSH_TVV9.VKORG
Route
  • Client
  • Route
  • C_RFM_MASADOEDITSLSORDITM.MANDT == TVRO.MANDT
  • C_RFM_MASADOEDITSLSORDITM.ROUTE == TVRO.ROUTE
Sales District
  • Client
  • Sales District
  • C_RFM_MASADOEDITSLSORDITM.MANDT == T171.MANDT
  • C_RFM_MASADOEDITSLSORDITM.SALESDISTRICT == T171.BZIRK
Sales document item category
  • Client
  • Sales document item category
  • C_RFM_MASADOEDITSLSORDITM.MANDT == TVPT.MANDT
  • C_RFM_MASADOEDITSLSORDITM.SALESDOCUMENTITEMCATEGORY == TVPT.PSTYV
Reason for Rejection of Sales Documents
  • Client
  • Reason for Rejection of Sales Documents
  • C_RFM_MASADOEDITSLSORDITM.MANDT == TVAG.MANDT
  • C_RFM_MASADOEDITSLSORDITM.SALESDOCUMENTRJCNREASON == TVAG.ABGRU
Order type in order header
  • Client
  • Sales Document Type
  • C_RFM_MASADOEDITSLSORDITM.MANDT == TVAK.MANDT
  • C_RFM_MASADOEDITSLSORDITM.SALESDOCUMENTTYPE == TVAK.AUART
Sales group
  • Client
  • Sales office
  • Sales group
  • C_RFM_MASADOEDITSLSORDITM.MANDT == TVBVK.MANDT
  • C_RFM_MASADOEDITSLSORDITM.SALESOFFICE == TVBVK.VKBUR
  • C_RFM_MASADOEDITSLSORDITM.SALESGROUP == TVBVK.VKGRP
Customer Price Group
  • Client
  • Customer Price Group
  • Customer Price Group
  • C_RFM_MASADOEDITSLSORDITM.MANDT == T188.MANDT
  • C_RFM_MASADOEDITSLSORDITM.CUSTOMERPRICEGROUP == T188.KONDA
  • C_RFM_MASADOEDITSLSORDITM.SALESORDERCUSTOMERPRICEGROUP == T188.KONDA
Sales organization in order header
  • Client
  • Sales Organization
  • C_RFM_MASADOEDITSLSORDITM.MANDT == TVKO.MANDT
  • C_RFM_MASADOEDITSLSORDITM.SALESORGANIZATION == TVKO.VKORG
Order Reason (Reason for the Business Transaction)
  • Order Reason (Reason for the Business Transaction)
  • Client
  • C_RFM_MASADOEDITSLSORDITM.SDDOCUMENTREASON == TVAU.AUGRU
  • C_RFM_MASADOEDITSLSORDITM.MANDT == TVAU.MANDT
Shipping Conditions
  • Client
  • Shipping Conditions
  • C_RFM_MASADOEDITSLSORDITM.MANDT == TVSB.MANDT
  • C_RFM_MASADOEDITSLSORDITM.SHIPPINGCONDITION == TVSB.VSBED
Shipping Point / Receiving Point
  • Client
  • Shipping Point / Receiving Point
  • C_RFM_MASADOEDITSLSORDITM.MANDT == TVST.MANDT
  • C_RFM_MASADOEDITSLSORDITM.SHIPPINGPOINT == TVST.VSTEL
Shipping Type
  • Client
  • Shipping Type
  • Shipping Type
  • C_RFM_MASADOEDITSLSORDITM.MANDT == T173.MANDT
  • C_RFM_MASADOEDITSLSORDITM.SHIPPINGTYPE == T173.VSART
  • C_RFM_MASADOEDITSLSORDITM.SLSORDSHIPPINGTYPE == T173.VSART
Customer condition group 1
  • Client
  • Customer condition group 1
  • Customer condition group 1
  • C_RFM_MASADOEDITSLSORDITM.MANDT == TVKGG.MANDT
  • C_RFM_MASADOEDITSLSORDITM.SLSORDCUSTOMERCONDITIONGROUP1 == TVKGG.KDKGR
  • C_RFM_MASADOEDITSLSORDITM.CUSTOMERCONDITIONGROUP1 == TVKGG.KDKGR
Customer condition group 2
  • Customer condition group 2
  • Customer condition group 2
  • Client
  • C_RFM_MASADOEDITSLSORDITM.SLSORDCUSTOMERCONDITIONGROUP2 == TVKGG.KDKGR
  • C_RFM_MASADOEDITSLSORDITM.CUSTOMERCONDITIONGROUP2 == TVKGG.KDKGR
  • C_RFM_MASADOEDITSLSORDITM.MANDT == TVKGG.MANDT
Customer condition group 3
  • Client
  • Customer condition group 3
  • Customer condition group 3
  • C_RFM_MASADOEDITSLSORDITM.MANDT == TVKGG.MANDT
  • C_RFM_MASADOEDITSLSORDITM.CUSTOMERCONDITIONGROUP3 == TVKGG.KDKGR
  • C_RFM_MASADOEDITSLSORDITM.SLSORDCUSTOMERCONDITIONGROUP3 == TVKGG.KDKGR
Customer condition group 4
  • Client
  • Customer condition group 4
  • Customer condition group 4
  • C_RFM_MASADOEDITSLSORDITM.MANDT == TVKGG.MANDT
  • C_RFM_MASADOEDITSLSORDITM.CUSTOMERCONDITIONGROUP4 == TVKGG.KDKGR
  • C_RFM_MASADOEDITSLSORDITM.SLSORDCUSTOMERCONDITIONGROUP4 == TVKGG.KDKGR
Customer condition group 5
  • Client
  • Customer condition group 5
  • Customer condition group 5
  • C_RFM_MASADOEDITSLSORDITM.MANDT == TVKGG.MANDT
  • C_RFM_MASADOEDITSLSORDITM.CUSTOMERCONDITIONGROUP5 == TVKGG.KDKGR
  • C_RFM_MASADOEDITSLSORDITM.SLSORDCUSTOMERCONDITIONGROUP5 == TVKGG.KDKGR
Customer Purchase Order Type
  • Client
  • Customer Purchase Order Type
  • Customer Purchase Order Type
  • C_RFM_MASADOEDITSLSORDITM.MANDT == T176.MANDT
  • C_RFM_MASADOEDITSLSORDITM.SLSORDCUSTOMERPURCHASEORDTYPE == T176.BSARK
  • C_RFM_MASADOEDITSLSORDITM.CUSTOMERPURCHASEORDERTYPE == T176.BSARK
Incoterms (Part 1)
  • Client
  • Incoterms (Part 1)
  • Incoterms (Part 1)
  • C_RFM_MASADOEDITSLSORDITM.MANDT == TINC.MANDT
  • C_RFM_MASADOEDITSLSORDITM.INCOTERMSCLASSIFICATION == TINC.INCO1
  • C_RFM_MASADOEDITSLSORDITM.SLSORDINCOTERMSCLASSIFICATION == TINC.INCO1
Shipping Type
  • Client
  • Shipping Type
  • Shipping Type
  • C_RFM_MASADOEDITSLSORDITM.MANDT == T173.MANDT
  • C_RFM_MASADOEDITSLSORDITM.SHIPPINGTYPE == T173.VSART
  • C_RFM_MASADOEDITSLSORDITM.SLSORDSHIPPINGTYPE == T173.VSART
Sold-to Party
  • Sold-to Party
  • Client
  • C_RFM_MASADOEDITSLSORDITM.SOLDTOPARTY == KNA1.KUNNR
  • C_RFM_MASADOEDITSLSORDITM.MANDT == KNA1.MANDT
Storage location
  • Storage location
  • Client
  • Plant (Own or External)
  • C_RFM_MASADOEDITSLSORDITM.STORAGELOCATION == T001L.LGORT
  • C_RFM_MASADOEDITSLSORDITM.MANDT == T001L.MANDT
  • C_RFM_MASADOEDITSLSORDITM.PLANT == T001L.WERKS
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Client
  • Division
  • Sales office
  • Distribution Channel
  • Sales Organization
  • C_RFM_MASADOEDITSLSORDITM.MANDT == TVKBZ.MANDT
  • C_RFM_MASADOEDITSLSORDITM.ORGANIZATIONDIVISION == TVKBZ.SPART
  • C_RFM_MASADOEDITSLSORDITM.SALESOFFICE == TVKBZ.VKBUR
  • C_RFM_MASADOEDITSLSORDITM.DISTRIBUTIONCHANNEL == TVKBZ.VTWEG
  • C_RFM_MASADOEDITSLSORDITM.SALESORGANIZATION == TVKBZ.VKORG