I_RFM_SlsOrdPrgrsMntrItm

Sales Order item details | view: IRFMSOPMITM | TRAN | Extraction: Not supported | Component: Retail & Fashion Sales and Distribution
Tables used: VBAK, VBAP, VBKD, VBPA, VBEP, MARA, KNA1, MARA, MAKT
Column Name Description
SalesOrder FK Sales Document
SalesOrderItem Sales Document Item
Column Name Description
💲 SD Document Currency (TransactionCurrency):
NetAmount Net Value of the Order Item in Document Currency
Column Name Description
📏 Base Unit of Measure (BaseUnit):
OrderQuantity Cumulative order quantity in sales units
ConfdDelivQtyInOrderQtyUnit Cumulative Confirmed Quantity in Sales Unit
RequestedQuantityInBaseUnit null
ConfirmedRqmtQtyInBaseUnit null
UnconfirmedQuantityInBaseUnit null
DeliveredQuantityInBaseUnit null
Column Name Description
RequestedDeliveryDate Requested Delivery Date
CreationDate Date on which the record was created
FashionCancelDate Cancellation Date
PricingDate Date for Pricing and Exchange Rate
SalesDocumentDate Document Date (Date Received/Sent)
CustomerPurchaseOrderDate Customer Reference Date
BillingDocumentDate Billing Date
Column Name Description
OverallSDProcessStatus Overall Processing Status (Header/All Items) Show values
OverallTotalDeliveryStatus Overall Delivery Status (All Items) Show values
TotalCreditCheckStatus Overall Status of Credit Checks Show values
TotalBlockStatus Overall Block Status (Header) Show values
OverallPricingIncompletionSts Pricing Incompletion Status (All Items) Show values
HdrGeneralIncompletionStatus Incompletion Status (Header) Show values
HeaderDelivIncompletionStatus Delivery Incompletion Status (Header) Show values
HeaderBillgIncompletionStatus Billing Incompletion Status (Header) Show values
OvrlItmGeneralIncompletionSts Incompletion Status (All Items) Show values
OvrlItmDelivIncompletionSts Delivery Incompletion Status (All Items) Show values
OvrlItmBillingIncompletionSts Billing Incompletion Status (All Items) Show values
SeasonCompletenessStatus Season Completeness Indicator 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
DeliveryStatus Delivery Status (Item) Show values
OrderRelatedBillingStatus Order-Related Billing Status (Item) Show values
Column Name Description Domain name
CreatedByUser Name of Person Responsible for Creating the Object USNAM
IncotermsLocation1 Incoterms Location 1 INCO_L
CustomerPaymentTerms Terms of payment key ZTERM
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
InventorySpecialStockType null
ProductName Product Description TEXT40
RequirementSegment Requirement Segment SGT_SRCA
Plant Plant (Own or External) WERKS
ShippingGroupRule PSST Grouping Rule RFM_PSST_RULE
ShippingGroupNumber PSST Group RFM_PSST_GROUP_ID
ProductCharacteristic1 Characteristic Value 1 WRF_CHARSTC
ProductCharacteristic2 Characteristic Value 2 WRF_CHARSTC
ProductCharacteristic3 Characteristic Value 3 WRF_CHARSTC
HigherLevelItem Higher-Level Item in Bill of Material Structures POSNR
OrderToBaseQuantityDnmntr Denominator (divisor) for conversion of sales Qty into SKU UMBSN
OrderToBaseQuantityNmrtr Numerator (factor) for conversion of sales quantity into SKU UMBSZ
FormattedSalesDocumentItem Sales Document Item CHAR17
ItemHasValueAddedService null
Master Data Relations Join Conditions
Material Group 1
  • Client
  • Material Group 1
  • I_RFM_SLSORDPRGRSMNTRITM.MANDT == TVM1.MANDT
  • I_RFM_SLSORDPRGRSMNTRITM.ADDITIONALMATERIALGROUP1 == TVM1.MVGR1
Material Group 2
  • Client
  • Material Group 2
  • I_RFM_SLSORDPRGRSMNTRITM.MANDT == TVM2.MANDT
  • I_RFM_SLSORDPRGRSMNTRITM.ADDITIONALMATERIALGROUP2 == TVM2.MVGR2
Material Group 3
  • Client
  • Material Group 3
  • I_RFM_SLSORDPRGRSMNTRITM.MANDT == TVM3.MANDT
  • I_RFM_SLSORDPRGRSMNTRITM.ADDITIONALMATERIALGROUP3 == TVM3.MVGR3
Material Group 4
  • Client
  • Material Group 4
  • I_RFM_SLSORDPRGRSMNTRITM.MANDT == TVM4.MANDT
  • I_RFM_SLSORDPRGRSMNTRITM.ADDITIONALMATERIALGROUP4 == TVM4.MVGR4
Material Group 5
  • Client
  • Material Group 5
  • I_RFM_SLSORDPRGRSMNTRITM.MANDT == TVM5.MANDT
  • I_RFM_SLSORDPRGRSMNTRITM.ADDITIONALMATERIALGROUP5 == TVM5.MVGR5
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • I_RFM_SLSORDPRGRSMNTRITM.MANDT == T006.MANDT
  • I_RFM_SLSORDPRGRSMNTRITM.BASEUNIT == T006.MSEHI
Batch Number
  • Client
  • Batch Number
  • Plant (Own or External)
  • Material Number
  • I_RFM_SLSORDPRGRSMNTRITM.MANDT == MCHA.MANDT
  • I_RFM_SLSORDPRGRSMNTRITM.BATCH == MCHA.CHARG
  • I_RFM_SLSORDPRGRSMNTRITM.PLANT == MCHA.WERKS
  • I_RFM_SLSORDPRGRSMNTRITM.MATERIAL == MCHA.MATNR
Customer condition group 1
  • Client
  • Customer condition group 1
  • I_RFM_SLSORDPRGRSMNTRITM.MANDT == TVKGG.MANDT
  • I_RFM_SLSORDPRGRSMNTRITM.CUSTOMERCONDITIONGROUP1 == TVKGG.KDKGR
Customer condition group 2
  • Client
  • Customer condition group 2
  • I_RFM_SLSORDPRGRSMNTRITM.MANDT == TVKGG.MANDT
  • I_RFM_SLSORDPRGRSMNTRITM.CUSTOMERCONDITIONGROUP2 == TVKGG.KDKGR
Customer condition group 3
  • Client
  • Customer condition group 3
  • I_RFM_SLSORDPRGRSMNTRITM.MANDT == TVKGG.MANDT
  • I_RFM_SLSORDPRGRSMNTRITM.CUSTOMERCONDITIONGROUP3 == TVKGG.KDKGR
Customer condition group 4
  • Client
  • Customer condition group 4
  • I_RFM_SLSORDPRGRSMNTRITM.MANDT == TVKGG.MANDT
  • I_RFM_SLSORDPRGRSMNTRITM.CUSTOMERCONDITIONGROUP4 == TVKGG.KDKGR
Customer condition group 5
  • Client
  • Customer condition group 5
  • I_RFM_SLSORDPRGRSMNTRITM.MANDT == TVKGG.MANDT
  • I_RFM_SLSORDPRGRSMNTRITM.CUSTOMERCONDITIONGROUP5 == TVKGG.KDKGR
Customer Group
  • Customer Group
  • Client
  • I_RFM_SLSORDPRGRSMNTRITM.CUSTOMERGROUP == T151.KDGRP
  • I_RFM_SLSORDPRGRSMNTRITM.MANDT == T151.MANDT
Customer Price Group
  • Client
  • Customer Price Group
  • I_RFM_SLSORDPRGRSMNTRITM.MANDT == T188.MANDT
  • I_RFM_SLSORDPRGRSMNTRITM.CUSTOMERPRICEGROUP == T188.KONDA
Customer Purchase Order Type
  • Client
  • Customer Purchase Order Type
  • I_RFM_SLSORDPRGRSMNTRITM.MANDT == T176.MANDT
  • I_RFM_SLSORDPRGRSMNTRITM.CUSTOMERPURCHASEORDERTYPE == T176.BSARK
Delivery Block (Document Header)
  • Delivery Block (Document Header)
  • Client
  • I_RFM_SLSORDPRGRSMNTRITM.DELIVERYBLOCKREASON == TVLS.LIFSP
  • I_RFM_SLSORDPRGRSMNTRITM.MANDT == TVLS.MANDT
Delivery Priority
  • Delivery Priority
  • Client
  • I_RFM_SLSORDPRGRSMNTRITM.DELIVERYPRIORITY == TPRIO.LPRIO
  • I_RFM_SLSORDPRGRSMNTRITM.MANDT == TPRIO.MANDT
Department number
  • Client
  • Department number
  • I_RFM_SLSORDPRGRSMNTRITM.MANDT == TSAB.MANDT
  • I_RFM_SLSORDPRGRSMNTRITM.DEPARTMENTCLASSIFICATIONBYCUST == TSAB.ABTNR
Distribution channel in order header
  • Client
  • Distribution Channel
  • Sales Organization
  • I_RFM_SLSORDPRGRSMNTRITM.MANDT == TVKOV.MANDT
  • I_RFM_SLSORDPRGRSMNTRITM.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
  • I_RFM_SLSORDPRGRSMNTRITM.SALESORGANIZATION == TVKOV.VKORG
Billing Block in SD Document
  • Client
  • Billing Block in SD Document
  • I_RFM_SLSORDPRGRSMNTRITM.MANDT == TVFS.MANDT
  • I_RFM_SLSORDPRGRSMNTRITM.HEADERBILLINGBLOCKREASON == TVFS.FAKSP
Incoterms (Part 1)
  • Client
  • Incoterms (Part 1)
  • I_RFM_SLSORDPRGRSMNTRITM.MANDT == TINC.MANDT
  • I_RFM_SLSORDPRGRSMNTRITM.INCOTERMSCLASSIFICATION == TINC.INCO1
Material: order item
  • Client
  • Material Number
  • I_RFM_SLSORDPRGRSMNTRITM.MANDT == MARA.MANDT
  • I_RFM_SLSORDPRGRSMNTRITM.MATERIAL == MARA.MATNR
Sales unit
  • Client
  • Sales unit
  • I_RFM_SLSORDPRGRSMNTRITM.MANDT == T006.MANDT
  • I_RFM_SLSORDPRGRSMNTRITM.ORDERQUANTITYUNIT == T006.MSEHI
Division in order header
  • Client
  • Distribution Channel
  • Division
  • Sales Organization
  • I_RFM_SLSORDPRGRSMNTRITM.MANDT == TVTA.MANDT
  • I_RFM_SLSORDPRGRSMNTRITM.DISTRIBUTIONCHANNEL == TVTA.VTWEG
  • I_RFM_SLSORDPRGRSMNTRITM.ORGANIZATIONDIVISION == TVTA.SPART
  • I_RFM_SLSORDPRGRSMNTRITM.SALESORGANIZATION == TVTA.VKORG
Fashion Collection
  • Fashion Collection
  • Season Year
  • Client
  • Season
Product Group
  • Client
  • Product Group
  • I_RFM_SLSORDPRGRSMNTRITM.MANDT == T023.MANDT
  • I_RFM_SLSORDPRGRSMNTRITM.PRODUCTGROUP == T023.MATKL
Season
  • Season Year
  • Client
  • Season
  • I_RFM_SLSORDPRGRSMNTRITM.PRODUCTSEASONYEAR == FSH_SEASONS.FSH_SEASON_YEAR
  • I_RFM_SLSORDPRGRSMNTRITM.MANDT == FSH_SEASONS.MANDT
  • I_RFM_SLSORDPRGRSMNTRITM.PRODUCTSEASON == FSH_SEASONS.FSH_SEASON
Season Year
  • Season Year
  • Client
  • Season
  • I_RFM_SLSORDPRGRSMNTRITM.PRODUCTSEASONYEAR == FSH_SEASONS.FSH_SEASON_YEAR
  • I_RFM_SLSORDPRGRSMNTRITM.MANDT == FSH_SEASONS.MANDT
  • I_RFM_SLSORDPRGRSMNTRITM.PRODUCTSEASON == FSH_SEASONS.FSH_SEASON
Fashion Theme
  • Fashion Collection
  • Season Year
  • Client
  • Season
  • Fashion Theme
  • I_RFM_SLSORDPRGRSMNTRITM.PRODUCTCOLLECTION == FSH_THEMES.FSH_COLLECTION
  • I_RFM_SLSORDPRGRSMNTRITM.PRODUCTSEASONYEAR == FSH_THEMES.FSH_SEASON_YEAR
  • I_RFM_SLSORDPRGRSMNTRITM.MANDT == FSH_THEMES.MANDT
  • I_RFM_SLSORDPRGRSMNTRITM.PRODUCTSEASON == FSH_THEMES.FSH_SEASON
  • I_RFM_SLSORDPRGRSMNTRITM.PRODUCTTHEME == FSH_THEMES.FSH_THEME
Customer Group 10
  • Customer Group 10
  • Client
  • Sales Organization
  • I_RFM_SLSORDPRGRSMNTRITM.RETAILADDITIONALCUSTOMERGRP10 == FSH_TVV10.KVGR10
  • I_RFM_SLSORDPRGRSMNTRITM.MANDT == FSH_TVV10.MANDT
  • I_RFM_SLSORDPRGRSMNTRITM.SALESORGANIZATION == FSH_TVV10.VKORG
Customer Group 6
  • Client
  • Customer Group 6
  • Sales Organization
  • I_RFM_SLSORDPRGRSMNTRITM.MANDT == FSH_TVV6.MANDT
  • I_RFM_SLSORDPRGRSMNTRITM.RETAILADDITIONALCUSTOMERGRP6 == FSH_TVV6.KVGR6
  • I_RFM_SLSORDPRGRSMNTRITM.SALESORGANIZATION == FSH_TVV6.VKORG
Customer Group 7
  • Client
  • Customer Group 7
  • Sales Organization
  • I_RFM_SLSORDPRGRSMNTRITM.MANDT == FSH_TVV7.MANDT
  • I_RFM_SLSORDPRGRSMNTRITM.RETAILADDITIONALCUSTOMERGRP7 == FSH_TVV7.KVGR7
  • I_RFM_SLSORDPRGRSMNTRITM.SALESORGANIZATION == FSH_TVV7.VKORG
Customer Group 8
  • Client
  • Customer Group 8
  • Sales Organization
  • I_RFM_SLSORDPRGRSMNTRITM.MANDT == FSH_TVV8.MANDT
  • I_RFM_SLSORDPRGRSMNTRITM.RETAILADDITIONALCUSTOMERGRP8 == FSH_TVV8.KVGR8
  • I_RFM_SLSORDPRGRSMNTRITM.SALESORGANIZATION == FSH_TVV8.VKORG
Customer Group 9
  • Client
  • Customer Group 9
  • Sales Organization
  • I_RFM_SLSORDPRGRSMNTRITM.MANDT == FSH_TVV9.MANDT
  • I_RFM_SLSORDPRGRSMNTRITM.RETAILADDITIONALCUSTOMERGRP9 == FSH_TVV9.KVGR9
  • I_RFM_SLSORDPRGRSMNTRITM.SALESORGANIZATION == FSH_TVV9.VKORG
Sales District
  • Client
  • Sales District
  • I_RFM_SLSORDPRGRSMNTRITM.MANDT == T171.MANDT
  • I_RFM_SLSORDPRGRSMNTRITM.SALESDISTRICT == T171.BZIRK
Sales document item category
  • Client
  • Sales document item category
  • I_RFM_SLSORDPRGRSMNTRITM.MANDT == TVPT.MANDT
  • I_RFM_SLSORDPRGRSMNTRITM.SALESDOCUMENTITEMCATEGORY == TVPT.PSTYV
Reason for Rejection of Sales Documents
  • Client
  • Reason for Rejection of Sales Documents
  • I_RFM_SLSORDPRGRSMNTRITM.MANDT == TVAG.MANDT
  • I_RFM_SLSORDPRGRSMNTRITM.SALESDOCUMENTRJCNREASON == TVAG.ABGRU
Order type in order header
  • Client
  • Sales Document Type
  • I_RFM_SLSORDPRGRSMNTRITM.MANDT == TVAK.MANDT
  • I_RFM_SLSORDPRGRSMNTRITM.SALESDOCUMENTTYPE == TVAK.AUART
Sales group
  • Client
  • Sales office
  • Sales group
  • I_RFM_SLSORDPRGRSMNTRITM.MANDT == TVBVK.MANDT
  • I_RFM_SLSORDPRGRSMNTRITM.SALESOFFICE == TVBVK.VKBUR
  • I_RFM_SLSORDPRGRSMNTRITM.SALESGROUP == TVBVK.VKGRP
Sales organization in order header
  • Client
  • Sales Organization
  • I_RFM_SLSORDPRGRSMNTRITM.MANDT == TVKO.MANDT
  • I_RFM_SLSORDPRGRSMNTRITM.SALESORGANIZATION == TVKO.VKORG
Order Reason (Reason for the Business Transaction)
  • Order Reason (Reason for the Business Transaction)
  • Client
  • I_RFM_SLSORDPRGRSMNTRITM.SDDOCUMENTREASON == TVAU.AUGRU
  • I_RFM_SLSORDPRGRSMNTRITM.MANDT == TVAU.MANDT
Shipping Conditions
  • Client
  • Shipping Conditions
  • I_RFM_SLSORDPRGRSMNTRITM.MANDT == TVSB.MANDT
  • I_RFM_SLSORDPRGRSMNTRITM.SHIPPINGCONDITION == TVSB.VSBED
Shipping Point / Receiving Point
  • Client
  • Shipping Point / Receiving Point
  • I_RFM_SLSORDPRGRSMNTRITM.MANDT == TVST.MANDT
  • I_RFM_SLSORDPRGRSMNTRITM.SHIPPINGPOINT == TVST.VSTEL
Shipping Type
  • Client
  • Shipping Type
  • I_RFM_SLSORDPRGRSMNTRITM.MANDT == T173.MANDT
  • I_RFM_SLSORDPRGRSMNTRITM.SHIPPINGTYPE == T173.VSART
Customer - Document Customer
  • Client
  • Customer Number
  • Sold-to Party
  • I_RFM_SLSORDPRGRSMNTRITM.MANDT == KNA1.MANDT
  • I_RFM_SLSORDPRGRSMNTRITM.SHIPTOPARTY == KNA1.KUNNR
  • I_RFM_SLSORDPRGRSMNTRITM.SOLDTOPARTY == KNA1.KUNNR
Sold-to Party
  • Client
  • Customer Number
  • Sold-to Party
  • I_RFM_SLSORDPRGRSMNTRITM.MANDT == KNA1.MANDT
  • I_RFM_SLSORDPRGRSMNTRITM.SHIPTOPARTY == KNA1.KUNNR
  • I_RFM_SLSORDPRGRSMNTRITM.SOLDTOPARTY == KNA1.KUNNR
Storage location
  • Client
  • Plant (Own or External)
  • Storage location
  • I_RFM_SLSORDPRGRSMNTRITM.MANDT == T001L.MANDT
  • I_RFM_SLSORDPRGRSMNTRITM.PLANT == T001L.WERKS
  • I_RFM_SLSORDPRGRSMNTRITM.STORAGELOCATION == T001L.LGORT
SD Document Currency
  • Client
  • SD Document Currency
  • I_RFM_SLSORDPRGRSMNTRITM.MANDT == TCURC.MANDT
  • I_RFM_SLSORDPRGRSMNTRITM.TRANSACTIONCURRENCY == TCURC.WAERS
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Client
  • Sales office
  • Distribution Channel
  • Division
  • Sales Organization
  • I_RFM_SLSORDPRGRSMNTRITM.MANDT == TVKBZ.MANDT
  • I_RFM_SLSORDPRGRSMNTRITM.SALESOFFICE == TVKBZ.VKBUR
  • I_RFM_SLSORDPRGRSMNTRITM.DISTRIBUTIONCHANNEL == TVKBZ.VTWEG
  • I_RFM_SLSORDPRGRSMNTRITM.ORGANIZATIONDIVISION == TVKBZ.SPART
  • I_RFM_SLSORDPRGRSMNTRITM.SALESORGANIZATION == TVKBZ.VKORG