I_ARunOvwDmndItem

View for Total Demand Item Level | view: IARUNDMNDITEM | Extraction: Not supported | Component: Order Allocation Run
Tables used: VBAK, VBAP, VBKD, EKKO, EKPO, EKPV, VBPA, VBPA, KNA1, KNA1, CVI_CUST_CT_LINK, BUT000, CVI_CUST_LINK, T161T, TVAKT, MARA, MARC, KNVV, 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
SupAssgmtOrdStatus null
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
PurchaseOrderByCustomer Customer Reference BSTKD
Master Data Relations Join Conditions
Customer Group 1
  • Customer Group 1
  • Client
  • I_ARUNOVWDMNDITEM.ADDITIONALCUSTOMERGROUP1 == TVV1.KVGR1
  • I_ARUNOVWDMNDITEM.MANDT == TVV1.MANDT
Customer Group 2
  • Customer Group 2
  • Client
  • I_ARUNOVWDMNDITEM.ADDITIONALCUSTOMERGROUP2 == TVV2.KVGR2
  • I_ARUNOVWDMNDITEM.MANDT == TVV2.MANDT
Customer Group 3
  • Customer Group 3
  • Client
  • I_ARUNOVWDMNDITEM.ADDITIONALCUSTOMERGROUP3 == TVV3.KVGR3
  • I_ARUNOVWDMNDITEM.MANDT == TVV3.MANDT
Customer Group 4
  • Customer Group 4
  • Client
  • I_ARUNOVWDMNDITEM.ADDITIONALCUSTOMERGROUP4 == TVV4.KVGR4
  • I_ARUNOVWDMNDITEM.MANDT == TVV4.MANDT
Customer Group 5
  • Customer Group 5
  • Client
  • I_ARUNOVWDMNDITEM.ADDITIONALCUSTOMERGROUP5 == TVV5.KVGR5
  • I_ARUNOVWDMNDITEM.MANDT == TVV5.MANDT
Release Rule
  • Release Rule
  • Client
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • I_ARUNOVWDMNDITEM.BASEUNIT == T006.MSEHI
  • I_ARUNOVWDMNDITEM.MANDT == T006.MANDT
Business Area
  • Business Area
  • Client
  • I_ARUNOVWDMNDITEM.BUSINESSAREA == TGSB.GSBER
  • I_ARUNOVWDMNDITEM.MANDT == TGSB.MANDT
Company Code to Be Billed
  • Company Code to Be Billed
  • Client
  • I_ARUNOVWDMNDITEM.COMPANYCODE == T001.BUKRS
  • I_ARUNOVWDMNDITEM.MANDT == T001.MANDT
Cross-Plant Configurable Material
  • Cross-Plant Configurable Material
  • Client
  • I_ARUNOVWDMNDITEM.CROSSPLANTCONFIGURABLEPRODUCT == MARA.MATNR
  • I_ARUNOVWDMNDITEM.MANDT == MARA.MANDT
Customer Group
  • Customer Group
  • Client
  • I_ARUNOVWDMNDITEM.CUSTOMERGROUP == T151.KDGRP
  • I_ARUNOVWDMNDITEM.MANDT == T151.MANDT
Delivery Block (Document Header)
  • Delivery Block (Document Header)
  • Client
  • I_ARUNOVWDMNDITEM.DELIVERYBLOCKREASON == TVLS.LIFSP
  • I_ARUNOVWDMNDITEM.MANDT == TVLS.MANDT
Delivery Priority
  • Delivery Priority
  • Client
  • I_ARUNOVWDMNDITEM.DELIVERYPRIORITY == TPRIO.LPRIO
  • I_ARUNOVWDMNDITEM.MANDT == TPRIO.MANDT
Distribution channel in order header
  • Client
  • Sales Organization
  • Distribution Channel
  • I_ARUNOVWDMNDITEM.MANDT == TVKOV.MANDT
  • I_ARUNOVWDMNDITEM.SALESORGANIZATION == TVKOV.VKORG
  • I_ARUNOVWDMNDITEM.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
Division
  • Division
  • Division
  • Client
  • I_ARUNOVWDMNDITEM.DIVISION == TSPA.SPART
  • I_ARUNOVWDMNDITEM.ORGANIZATIONDIVISION == TSPA.SPART
  • I_ARUNOVWDMNDITEM.MANDT == TSPA.MANDT
SD Document Currency
  • SD Document Currency
  • Client
  • I_ARUNOVWDMNDITEM.DOCUMENTCURRENCY == TCURC.WAERS
  • I_ARUNOVWDMNDITEM.MANDT == TCURC.MANDT
Billing Block for Item
  • Billing Block for Item
  • Client
  • I_ARUNOVWDMNDITEM.ITEMBILLINGBLOCKREASON == TVFS.FAKSP
  • I_ARUNOVWDMNDITEM.MANDT == TVFS.MANDT
Material: order item
  • Material Number
  • Client
  • I_ARUNOVWDMNDITEM.MATERIAL == MARA.MATNR
  • I_ARUNOVWDMNDITEM.MANDT == MARA.MANDT
Material Group
  • Material Group
  • Client
  • I_ARUNOVWDMNDITEM.MATERIALGROUP == T023.MATKL
  • I_ARUNOVWDMNDITEM.MANDT == T023.MANDT
Order type in order header
  • Sales Document Type
  • Client
  • I_ARUNOVWDMNDITEM.ORDERTYPE == TVAK.AUART
  • I_ARUNOVWDMNDITEM.MANDT == TVAK.MANDT
Division in order header
  • Division
  • Division
  • Client
  • Sales Organization
  • Distribution Channel
  • I_ARUNOVWDMNDITEM.DIVISION == TVTA.SPART
  • I_ARUNOVWDMNDITEM.ORGANIZATIONDIVISION == TVTA.SPART
  • I_ARUNOVWDMNDITEM.MANDT == TVTA.MANDT
  • I_ARUNOVWDMNDITEM.SALESORGANIZATION == TVTA.VKORG
  • I_ARUNOVWDMNDITEM.DISTRIBUTIONCHANNEL == TVTA.VTWEG
Partner function - Document partner
  • Client
  • Partner Function
  • I_ARUNOVWDMNDITEM.MANDT == TPAR.MANDT
  • I_ARUNOVWDMNDITEM.PARTNERFUNCTION == TPAR.PARVW
Fashion Collection
  • Fashion Collection
  • Season Year
  • Season
  • Client
Season
  • Season Year
  • Season
  • Client
  • I_ARUNOVWDMNDITEM.PRODUCTSEASONYEAR == FSH_SEASONS.FSH_SEASON_YEAR
  • I_ARUNOVWDMNDITEM.PRODUCTSEASON == FSH_SEASONS.FSH_SEASON
  • I_ARUNOVWDMNDITEM.MANDT == FSH_SEASONS.MANDT
Season Year
  • Season Year
  • Season
  • Client
  • I_ARUNOVWDMNDITEM.PRODUCTSEASONYEAR == FSH_SEASONS.FSH_SEASON_YEAR
  • I_ARUNOVWDMNDITEM.PRODUCTSEASON == FSH_SEASONS.FSH_SEASON
  • I_ARUNOVWDMNDITEM.MANDT == FSH_SEASONS.MANDT
Fashion Theme
  • Fashion Collection
  • Season Year
  • Fashion Theme
  • Season
  • Client
  • I_ARUNOVWDMNDITEM.PRODUCTCOLLECTION == FSH_THEMES.FSH_COLLECTION
  • I_ARUNOVWDMNDITEM.PRODUCTSEASONYEAR == FSH_THEMES.FSH_SEASON_YEAR
  • I_ARUNOVWDMNDITEM.PRODUCTTHEME == FSH_THEMES.FSH_THEME
  • I_ARUNOVWDMNDITEM.PRODUCTSEASON == FSH_THEMES.FSH_SEASON
  • I_ARUNOVWDMNDITEM.MANDT == FSH_THEMES.MANDT
Sales District
  • Sales District
  • Client
  • I_ARUNOVWDMNDITEM.SALESDISTRICT == T171.BZIRK
  • I_ARUNOVWDMNDITEM.MANDT == T171.MANDT
Sales document item category
  • Sales document item category
  • Client
  • I_ARUNOVWDMNDITEM.SALESDOCUMENTITEMCATEGORY == TVPT.PSTYV
  • I_ARUNOVWDMNDITEM.MANDT == TVPT.MANDT
Reason for Rejection of Sales Documents
  • Reason for Rejection of Sales Documents
  • Client
  • I_ARUNOVWDMNDITEM.SALESDOCUMENTRJCNREASON == TVAG.ABGRU
  • I_ARUNOVWDMNDITEM.MANDT == TVAG.MANDT
Sales group
  • Sales office
  • Sales group
  • Client
  • I_ARUNOVWDMNDITEM.SALESOFFICE == TVBVK.VKBUR
  • I_ARUNOVWDMNDITEM.SALESGROUP == TVBVK.VKGRP
  • I_ARUNOVWDMNDITEM.MANDT == TVBVK.MANDT
Sales organization in order header
  • Client
  • Sales Organization
  • I_ARUNOVWDMNDITEM.MANDT == TVKO.MANDT
  • I_ARUNOVWDMNDITEM.SALESORGANIZATION == TVKO.VKORG
Shipping Conditions
  • Shipping Conditions
  • Client
  • I_ARUNOVWDMNDITEM.SHIPPINGCONDITION == TVSB.VSBED
  • I_ARUNOVWDMNDITEM.MANDT == TVSB.MANDT
Shipping Point / Receiving Point
  • Shipping Point / Receiving Point
  • Client
  • I_ARUNOVWDMNDITEM.SHIPPINGPOINT == TVST.VSTEL
  • I_ARUNOVWDMNDITEM.MANDT == TVST.MANDT
Storage location
  • Storage location
  • Client
  • Plant (Own or External)
  • I_ARUNOVWDMNDITEM.STORAGELOCATION == T001L.LGORT
  • I_ARUNOVWDMNDITEM.MANDT == T001L.MANDT
  • I_ARUNOVWDMNDITEM.PLANT == T001L.WERKS
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Division
  • Division
  • Sales office
  • Client
  • Sales Organization
  • Distribution Channel
  • I_ARUNOVWDMNDITEM.DIVISION == TVKBZ.SPART
  • I_ARUNOVWDMNDITEM.ORGANIZATIONDIVISION == TVKBZ.SPART
  • I_ARUNOVWDMNDITEM.SALESOFFICE == TVKBZ.VKBUR
  • I_ARUNOVWDMNDITEM.MANDT == TVKBZ.MANDT
  • I_ARUNOVWDMNDITEM.SALESORGANIZATION == TVKBZ.VKORG
  • I_ARUNOVWDMNDITEM.DISTRIBUTIONCHANNEL == TVKBZ.VTWEG