I_SupDmndOvwSDItem

Basic View for Sales Document Item | view: ISUPDMNDOVWSDITM | TRAN | Extraction: Not supported | Component: Order Allocation Run
Tables used: VBAK, VBAP, VBKD, VBAK, VBAP, VBEP, MARA, MARC, KNA1
Column Name Description
Column Name Description
💲 SD Document Currency (TransactionCurrency):
NetAmount Net Value of the Order Item in Document Currency
NetPriceAmount Net Price
Column Name Description
OrderQuantity Cumulative order quantity in sales units
RequestedRqmtQtyInBaseUnit null
ConfirmedRqmtQtyInBaseUnit null
DeliveredQuantityInBaseUnit null
📏 Base Unit of Measure (RequestedQuantityUnit):
ConfdDeliveryQtyInBaseUnit Cumulative Confirmed Quantity in Base Unit
Column Name Description
RequestedDeliveryDate Requested Delivery Date
FashionCancelDate Cancellation Date
CurrentDate null
RequestedDate Schedule line date
ProductAvailabilityDate Material Staging/Availability Date
EarliestRequestedDeliveryDate null
Column Name Description
SDDocumentCategory SD Document Category Show values
TotalCreditCheckStatus Overall Status of Credit Checks Show values
RequirementType Requirement Type Show values
IsBusinessPurposeCompleted Business Purpose Completed Flag Show values
SupAssgmtSource Assignment Source Show values
Column Name Description Domain name
SalesDocumentItem Sales Document Item POSNR
DeliveryGroup Delivery Group (Items are delivered together) GRKOR
Plant Plant (Own or External) WERKS
NetPriceQuantity Condition Pricing Unit KPEIN
RequirementSegment Requirement Segment SGT_SRCA
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
PurchaseOrderByCustomer Customer Reference BSTKD
OverallPrcIncompletionStsDesc null
ARunPriorityValue ARun Demand Priority VBELN
ARunDemandGroupPriority ARun Demand Group Priority VBELN
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
ReferenceSDDocument Document number of the reference document VBELN
InternationalArticleNumber International Article Number (EAN/UPC) EAN11
Master Data Relations Join Conditions
Release Rule
  • Client
  • Release Rule
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • Base Unit of Measure
  • I_SUPDMNDOVWSDITEM.MANDT == T006.MANDT
  • I_SUPDMNDOVWSDITEM.BASEUNIT == T006.MSEHI
  • I_SUPDMNDOVWSDITEM.REQUESTEDQUANTITYUNIT == T006.MSEHI
Company Code to Be Billed
  • Company Code to Be Billed
  • Client
  • I_SUPDMNDOVWSDITEM.BILLINGCOMPANYCODE == T001.BUKRS
  • I_SUPDMNDOVWSDITEM.MANDT == T001.MANDT
Cross-Plant Configurable Material
  • Client
  • Cross-Plant Configurable Material
  • I_SUPDMNDOVWSDITEM.MANDT == MARA.MANDT
  • I_SUPDMNDOVWSDITEM.CROSSPLANTCONFIGURABLEPRODUCT == MARA.MATNR
Customer Group
  • Customer Group
  • Client
  • I_SUPDMNDOVWSDITEM.CUSTOMERGROUP == T151.KDGRP
  • I_SUPDMNDOVWSDITEM.MANDT == T151.MANDT
Delivery Block (Document Header)
  • Client
  • Delivery Block (Document Header)
  • I_SUPDMNDOVWSDITEM.MANDT == TVLS.MANDT
  • I_SUPDMNDOVWSDITEM.DELIVERYBLOCKREASON == TVLS.LIFSP
Delivery Priority
  • Delivery Priority
  • Client
  • I_SUPDMNDOVWSDITEM.DELIVERYPRIORITY == TPRIO.LPRIO
  • I_SUPDMNDOVWSDITEM.MANDT == TPRIO.MANDT
Distribution channel in order header
  • Client
  • Sales Organization
  • Distribution Channel
  • I_SUPDMNDOVWSDITEM.MANDT == TVKOV.MANDT
  • I_SUPDMNDOVWSDITEM.SALESORGANIZATION == TVKOV.VKORG
  • I_SUPDMNDOVWSDITEM.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
Division
  • Client
  • Division
  • Division
  • I_SUPDMNDOVWSDITEM.MANDT == TSPA.MANDT
  • I_SUPDMNDOVWSDITEM.DIVISION == TSPA.SPART
  • I_SUPDMNDOVWSDITEM.ORGANIZATIONDIVISION == TSPA.SPART
Billing Block in SD Document
  • Billing Block in SD Document
  • Client
  • I_SUPDMNDOVWSDITEM.HEADERBILLINGBLOCKREASON == TVFS.FAKSP
  • I_SUPDMNDOVWSDITEM.MANDT == TVFS.MANDT
Billing Block for Item
  • Billing Block for Item
  • Client
  • I_SUPDMNDOVWSDITEM.ITEMBILLINGBLOCKREASON == TVFS.FAKSP
  • I_SUPDMNDOVWSDITEM.MANDT == TVFS.MANDT
Material: order item
  • Material Number
  • Client
  • I_SUPDMNDOVWSDITEM.MATERIAL == MARA.MATNR
  • I_SUPDMNDOVWSDITEM.MANDT == MARA.MANDT
Material Group
  • Client
  • Material Group
  • I_SUPDMNDOVWSDITEM.MANDT == T023.MANDT
  • I_SUPDMNDOVWSDITEM.MATERIALGROUP == T023.MATKL
Division in order header
  • Client
  • Division
  • Division
  • Sales Organization
  • Distribution Channel
  • I_SUPDMNDOVWSDITEM.MANDT == TVTA.MANDT
  • I_SUPDMNDOVWSDITEM.DIVISION == TVTA.SPART
  • I_SUPDMNDOVWSDITEM.ORGANIZATIONDIVISION == TVTA.SPART
  • I_SUPDMNDOVWSDITEM.SALESORGANIZATION == TVTA.VKORG
  • I_SUPDMNDOVWSDITEM.DISTRIBUTIONCHANNEL == TVTA.VTWEG
Fashion Collection
  • Season Year
  • Client
  • Fashion Collection
  • Season
Season
  • Season Year
  • Client
  • Season
  • I_SUPDMNDOVWSDITEM.PRODUCTSEASONYEAR == FSH_SEASONS.FSH_SEASON_YEAR
  • I_SUPDMNDOVWSDITEM.MANDT == FSH_SEASONS.MANDT
  • I_SUPDMNDOVWSDITEM.PRODUCTSEASON == FSH_SEASONS.FSH_SEASON
Season Year
  • Season Year
  • Client
  • Season
  • I_SUPDMNDOVWSDITEM.PRODUCTSEASONYEAR == FSH_SEASONS.FSH_SEASON_YEAR
  • I_SUPDMNDOVWSDITEM.MANDT == FSH_SEASONS.MANDT
  • I_SUPDMNDOVWSDITEM.PRODUCTSEASON == FSH_SEASONS.FSH_SEASON
Fashion Theme
  • Season Year
  • Client
  • Fashion Theme
  • Fashion Collection
  • Season
  • I_SUPDMNDOVWSDITEM.PRODUCTSEASONYEAR == FSH_THEMES.FSH_SEASON_YEAR
  • I_SUPDMNDOVWSDITEM.MANDT == FSH_THEMES.MANDT
  • I_SUPDMNDOVWSDITEM.PRODUCTTHEME == FSH_THEMES.FSH_THEME
  • I_SUPDMNDOVWSDITEM.PRODUCTCOLLECTION == FSH_THEMES.FSH_COLLECTION
  • I_SUPDMNDOVWSDITEM.PRODUCTSEASON == FSH_THEMES.FSH_SEASON
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • Base Unit of Measure
  • I_SUPDMNDOVWSDITEM.MANDT == T006.MANDT
  • I_SUPDMNDOVWSDITEM.BASEUNIT == T006.MSEHI
  • I_SUPDMNDOVWSDITEM.REQUESTEDQUANTITYUNIT == T006.MSEHI
Sales District
  • Client
  • Sales District
  • I_SUPDMNDOVWSDITEM.MANDT == T171.MANDT
  • I_SUPDMNDOVWSDITEM.SALESDISTRICT == T171.BZIRK
Sales document item category
  • Client
  • Sales document item category
  • I_SUPDMNDOVWSDITEM.MANDT == TVPT.MANDT
  • I_SUPDMNDOVWSDITEM.SALESDOCUMENTITEMCATEGORY == TVPT.PSTYV
Order type in order header
  • Sales Document Type
  • Client
  • I_SUPDMNDOVWSDITEM.SALESDOCUMENTTYPE == TVAK.AUART
  • I_SUPDMNDOVWSDITEM.MANDT == TVAK.MANDT
Sales group
  • Client
  • Sales office
  • Sales group
  • I_SUPDMNDOVWSDITEM.MANDT == TVBVK.MANDT
  • I_SUPDMNDOVWSDITEM.SALESOFFICE == TVBVK.VKBUR
  • I_SUPDMNDOVWSDITEM.SALESGROUP == TVBVK.VKGRP
Sales organization in order header
  • Client
  • Sales Organization
  • I_SUPDMNDOVWSDITEM.MANDT == TVKO.MANDT
  • I_SUPDMNDOVWSDITEM.SALESORGANIZATION == TVKO.VKORG
Order Reason (Reason for the Business Transaction)
  • Client
  • Order Reason (Reason for the Business Transaction)
  • I_SUPDMNDOVWSDITEM.MANDT == TVAU.MANDT
  • I_SUPDMNDOVWSDITEM.SDDOCUMENTREASON == TVAU.AUGRU
Shipping Conditions
  • Client
  • Shipping Conditions
  • I_SUPDMNDOVWSDITEM.MANDT == TVSB.MANDT
  • I_SUPDMNDOVWSDITEM.SHIPPINGCONDITION == TVSB.VSBED
Shipping Point / Receiving Point
  • Client
  • Shipping Point / Receiving Point
  • I_SUPDMNDOVWSDITEM.MANDT == TVST.MANDT
  • I_SUPDMNDOVWSDITEM.SHIPPINGPOINT == TVST.VSTEL
Sold-to Party
  • Client
  • Sold-to Party
  • I_SUPDMNDOVWSDITEM.MANDT == KNA1.MANDT
  • I_SUPDMNDOVWSDITEM.SOLDTOPARTY == KNA1.KUNNR
Storage location
  • Client
  • Plant (Own or External)
  • Storage location
  • I_SUPDMNDOVWSDITEM.MANDT == T001L.MANDT
  • I_SUPDMNDOVWSDITEM.PLANT == T001L.WERKS
  • I_SUPDMNDOVWSDITEM.STORAGELOCATION == T001L.LGORT
SD Document Currency
  • Client
  • SD Document Currency
  • I_SUPDMNDOVWSDITEM.MANDT == TCURC.MANDT
  • I_SUPDMNDOVWSDITEM.TRANSACTIONCURRENCY == TCURC.WAERS
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Client
  • Sales office
  • Division
  • Division
  • Sales Organization
  • Distribution Channel
  • I_SUPDMNDOVWSDITEM.MANDT == TVKBZ.MANDT
  • I_SUPDMNDOVWSDITEM.SALESOFFICE == TVKBZ.VKBUR
  • I_SUPDMNDOVWSDITEM.DIVISION == TVKBZ.SPART
  • I_SUPDMNDOVWSDITEM.ORGANIZATIONDIVISION == TVKBZ.SPART
  • I_SUPDMNDOVWSDITEM.SALESORGANIZATION == TVKBZ.VKORG
  • I_SUPDMNDOVWSDITEM.DISTRIBUTIONCHANNEL == TVKBZ.VTWEG