I_ARunOvwSDItem

Basic View for Sales Document Item | view: IARUNOVWSDITEM | Extraction: Not supported | Component: Order Allocation Run
Tables used: VBAK, VBAP, VBKD, VBPA, VBPA, KNA1, CVI_CUST_CT_LINK, BUT000, CVI_CUST_LINK, TVAKT, MARA, MARC, CVI_VEND_LINK
Column Name Description
RequirementDocumentNumber FK Sales Document
RequirementDocumentItem Sales Document Item
RequirementType null
Column Name Description
💲 SD Document Currency (DocumentCurrency):
NetAmount Net Value of the Order Item in Document Currency
NetPriceAmount Net Price
Column Name Description
Column Name Description
FashionCancelDate Cancellation Date
Column Name Description
IsBusinessPurposeCompleted Business Purpose Completed Flag Show values
Column Name Description Domain name
SoldToParty Sold-to Party KUNNR
ShipToParty Customer Number KUNNR
CustomerReferenceNumber Customer Reference BSTNK
HigherLevelItem Higher-Level Item in Bill of Material Structures POSNR
DeliveryGroup Delivery Group (Items are delivered together) GRKOR
ProfitCenter Profit Center PRCTR
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
PaymentTerms Terms of payment key ZTERM
PurchaseOrderByCustomer Customer Reference BSTKD
RetailArticleColor Characteristic Value for Colors of Variants WRF_ATWRT
RetailArticleMainSize Characteristic Value for Main Sizes of Variants WRF_ATWRT
RetailArticleSecondSize Characteristic Value for Second Size for Variants WRF_ATWRT
OrderTypeName Sales Document Type Description TEXT20
TotalCreditCheckStatus null
DeliveryBlockReason null
SupDmndRangeInDays null
OverallPrcIncompletionStsDesc null
Master Data Relations Join Conditions
Customer Group 1
  • Client
  • Customer Group 1
  • I_ARUNOVWSDITEM.MANDT == TVV1.MANDT
  • I_ARUNOVWSDITEM.ADDITIONALCUSTOMERGROUP1 == TVV1.KVGR1
Customer Group 2
  • Customer Group 2
  • Client
  • I_ARUNOVWSDITEM.ADDITIONALCUSTOMERGROUP2 == TVV2.KVGR2
  • I_ARUNOVWSDITEM.MANDT == TVV2.MANDT
Customer Group 3
  • Customer Group 3
  • Client
  • I_ARUNOVWSDITEM.ADDITIONALCUSTOMERGROUP3 == TVV3.KVGR3
  • I_ARUNOVWSDITEM.MANDT == TVV3.MANDT
Customer Group 4
  • Customer Group 4
  • Client
  • I_ARUNOVWSDITEM.ADDITIONALCUSTOMERGROUP4 == TVV4.KVGR4
  • I_ARUNOVWSDITEM.MANDT == TVV4.MANDT
Customer Group 5
  • Client
  • Customer Group 5
  • I_ARUNOVWSDITEM.MANDT == TVV5.MANDT
  • I_ARUNOVWSDITEM.ADDITIONALCUSTOMERGROUP5 == TVV5.KVGR5
Release Rule
  • Client
  • Release Rule
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • I_ARUNOVWSDITEM.BASEUNIT == T006.MSEHI
  • I_ARUNOVWSDITEM.MANDT == T006.MANDT
Business Area
  • Business Area
  • Client
  • I_ARUNOVWSDITEM.BUSINESSAREA == TGSB.GSBER
  • I_ARUNOVWSDITEM.MANDT == TGSB.MANDT
Company Code to Be Billed
  • Company Code to Be Billed
  • Client
  • I_ARUNOVWSDITEM.COMPANYCODE == T001.BUKRS
  • I_ARUNOVWSDITEM.MANDT == T001.MANDT
Cross-Plant Configurable Material
  • Client
  • Cross-Plant Configurable Material
  • I_ARUNOVWSDITEM.MANDT == MARA.MANDT
  • I_ARUNOVWSDITEM.CROSSPLANTCONFIGURABLEPRODUCT == MARA.MATNR
Customer Group
  • Customer Group
  • Client
  • I_ARUNOVWSDITEM.CUSTOMERGROUP == T151.KDGRP
  • I_ARUNOVWSDITEM.MANDT == T151.MANDT
Delivery Block (Document Header)
  • Delivery Block (Document Header)
  • Client
  • I_ARUNOVWSDITEM.DELIVERYBLOCK == TVLS.LIFSP
  • I_ARUNOVWSDITEM.MANDT == TVLS.MANDT
Delivery Priority
  • Client
  • Delivery Priority
  • I_ARUNOVWSDITEM.MANDT == TPRIO.MANDT
  • I_ARUNOVWSDITEM.DELIVERYPRIORITY == TPRIO.LPRIO
Distribution channel in order header
  • Sales Organization
  • Client
  • Distribution Channel
  • I_ARUNOVWSDITEM.SALESORGANIZATION == TVKOV.VKORG
  • I_ARUNOVWSDITEM.MANDT == TVKOV.MANDT
  • I_ARUNOVWSDITEM.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
Division
  • Division
  • Division
  • Client
  • I_ARUNOVWSDITEM.DIVISION == TSPA.SPART
  • I_ARUNOVWSDITEM.ORGANIZATIONDIVISION == TSPA.SPART
  • I_ARUNOVWSDITEM.MANDT == TSPA.MANDT
SD Document Currency
  • Client
  • SD Document Currency
  • I_ARUNOVWSDITEM.MANDT == TCURC.MANDT
  • I_ARUNOVWSDITEM.DOCUMENTCURRENCY == TCURC.WAERS
Billing Block for Item
  • Client
  • Billing Block for Item
  • I_ARUNOVWSDITEM.MANDT == TVFS.MANDT
  • I_ARUNOVWSDITEM.ITEMBILLINGBLOCKREASON == TVFS.FAKSP
Material: order item
  • Material Number
  • Client
  • I_ARUNOVWSDITEM.MATERIAL == MARA.MATNR
  • I_ARUNOVWSDITEM.MANDT == MARA.MANDT
Material Group
  • Client
  • Material Group
  • I_ARUNOVWSDITEM.MANDT == T023.MANDT
  • I_ARUNOVWSDITEM.MATERIALGROUP == T023.MATKL
Order type in order header
  • Sales Document Type
  • Client
  • I_ARUNOVWSDITEM.ORDERTYPE == TVAK.AUART
  • I_ARUNOVWSDITEM.MANDT == TVAK.MANDT
Division in order header
  • Division
  • Division
  • Sales Organization
  • Client
  • Distribution Channel
  • I_ARUNOVWSDITEM.DIVISION == TVTA.SPART
  • I_ARUNOVWSDITEM.ORGANIZATIONDIVISION == TVTA.SPART
  • I_ARUNOVWSDITEM.SALESORGANIZATION == TVTA.VKORG
  • I_ARUNOVWSDITEM.MANDT == TVTA.MANDT
  • I_ARUNOVWSDITEM.DISTRIBUTIONCHANNEL == TVTA.VTWEG
Partner function - Document partner
  • Client
  • Partner Function
  • I_ARUNOVWSDITEM.MANDT == TPAR.MANDT
  • I_ARUNOVWSDITEM.PARTNERFUNCTION == TPAR.PARVW
Fashion Collection
  • Client
  • Fashion Collection
  • Season Year
  • Season
Season
  • Client
  • Season Year
  • Season
Season Year
  • Client
  • Season Year
  • Season
Fashion Theme
  • Client
  • Fashion Collection
  • Season Year
  • Season
  • Fashion Theme
  • I_ARUNOVWSDITEM.MANDT == FSH_THEMES.MANDT
  • I_ARUNOVWSDITEM.PRODUCTCOLLECTION == FSH_THEMES.FSH_COLLECTION
  • I_ARUNOVWSDITEM.PRODUCTSEASONYEAR == FSH_THEMES.FSH_SEASON_YEAR
  • I_ARUNOVWSDITEM.PRODUCTSEASON == FSH_THEMES.FSH_SEASON
  • I_ARUNOVWSDITEM.PRODUCTTHEME == FSH_THEMES.FSH_THEME
Sales District
  • Sales District
  • Client
  • I_ARUNOVWSDITEM.SALESDISTRICT == T171.BZIRK
  • I_ARUNOVWSDITEM.MANDT == T171.MANDT
Sales document item category
  • Client
  • Sales document item category
  • I_ARUNOVWSDITEM.MANDT == TVPT.MANDT
  • I_ARUNOVWSDITEM.SALESDOCUMENTITEMCATEGORY == TVPT.PSTYV
Reason for Rejection of Sales Documents
  • Client
  • Reason for Rejection of Sales Documents
  • I_ARUNOVWSDITEM.MANDT == TVAG.MANDT
  • I_ARUNOVWSDITEM.SALESDOCUMENTRJCNREASON == TVAG.ABGRU
Sales group
  • Client
  • Sales office
  • Sales group
  • I_ARUNOVWSDITEM.MANDT == TVBVK.MANDT
  • I_ARUNOVWSDITEM.SALESOFFICE == TVBVK.VKBUR
  • I_ARUNOVWSDITEM.SALESGROUP == TVBVK.VKGRP
Sales organization in order header
  • Sales Organization
  • Client
  • I_ARUNOVWSDITEM.SALESORGANIZATION == TVKO.VKORG
  • I_ARUNOVWSDITEM.MANDT == TVKO.MANDT
Shipping Conditions
  • Client
  • Shipping Conditions
  • I_ARUNOVWSDITEM.MANDT == TVSB.MANDT
  • I_ARUNOVWSDITEM.SHIPPINGCONDITION == TVSB.VSBED
Shipping Point / Receiving Point
  • Client
  • Shipping Point / Receiving Point
  • I_ARUNOVWSDITEM.MANDT == TVST.MANDT
  • I_ARUNOVWSDITEM.SHIPPINGPOINT == TVST.VSTEL
Storage location
  • Client
  • Plant (Own or External)
  • Storage location
  • I_ARUNOVWSDITEM.MANDT == T001L.MANDT
  • I_ARUNOVWSDITEM.PLANT == T001L.WERKS
  • I_ARUNOVWSDITEM.STORAGELOCATION == T001L.LGORT
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Division
  • Division
  • Sales Organization
  • Client
  • Sales office
  • Distribution Channel
  • I_ARUNOVWSDITEM.DIVISION == TVKBZ.SPART
  • I_ARUNOVWSDITEM.ORGANIZATIONDIVISION == TVKBZ.SPART
  • I_ARUNOVWSDITEM.SALESORGANIZATION == TVKBZ.VKORG
  • I_ARUNOVWSDITEM.MANDT == TVKBZ.MANDT
  • I_ARUNOVWSDITEM.SALESOFFICE == TVKBZ.VKBUR
  • I_ARUNOVWSDITEM.DISTRIBUTIONCHANNEL == TVKBZ.VTWEG