I_ARunAnlytsSlsOrdRejection

Sales Order Rejection | view: IARNALYSSOREJ | TRAN | Extraction: Not supported | Component: Order Allocation Run
Tables used: VBAP, VBKD, VEDA, VBAK, VBAK, VBAP, VBKD, VEDA, MARA, MARC
Column Name Description
RequirementDocumentNumber FK Sales Document
RequirementDocumentItem Sales Document Item
Column Name Description
💲 SD Document Currency (DocumentCurrency):
NetPriceAmount Net Price
💲 Display Currency (DisplayCurrency):
TotActualAmtInDisplayCurrency Net Value in Display Currency
Column Name Description
📏 Base Unit of Measure (SupAssgmtAggrgQtyUnit):
RequestedRqmtQtyInBaseUnit null
ConfirmedRqmtQtyInBaseUnit Quantity field, 15 characters
DeliveredQuantityInBaseUnit null
OpenDemandQuantity null
AssignedQuantityInBaseUnit Quantity field, 15 characters
NormalAssignedQuantityInBsUnt Quantity field, 15 characters
Column Name Description
RequestedDate Material Staging/Availability Date
ProductAvailabilityDate Material Staging/Availability Date
RequestedDeliveryDate Requested Delivery Date
FashionCancelDate Cancellation Date
Column Name Description
Column Name Description Domain name
SupProtTimeBucketUUID null
RequirementType null
RequirementTypeName Explanatory Short Text DDTEXT
ARunDocumentItemUniqueID Unique Identification for Supply Assignment Document Item CHAR17
RequirementSegment Requirement Segment SGT_SRCA
ProductCharacteristic1 Characteristic Value 1 WRF_CHARSTC
ProductCharacteristic2 Characteristic Value 2 WRF_CHARSTC
ProductCharacteristic3 Characteristic Value 3 WRF_CHARSTC
PreviewAssignedQuantityInBsUnt null
ARunTmpAssignedQuantityInBsUnt null
CalendarYear Calendar Year NUM4
CalendarMonth Calendar Month NUM2
CalendarMonthName Explanatory Short Text DDTEXT
CalendarWeek null
CalendarDay Calendar Day NUM2
PlantCountry Country/Region Key LAND1
PlantRegion Region (State, Province, County) REGIO
Country Country/Region Key LAND1
Region Region (State, Province, County) REGIO
SoldToParty Sold-to Party KUNNR
ShipToParty null
SoldToPartyCountry Country/Region Key LAND1
SoldToPartyRegion Region (State, Province, County) REGIO
ShipToCountry Country/Region Key LAND1
CustomerRegion Region (State, Province, County) REGIO
SupplyProtectionName Name DDTEXT
NmbrOfItemsInOrder Item Issues in Order ITEM_ISSUES
Master Data Relations Join Conditions
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • I_ARUNANLYTSSLSORDREJECTION.MANDT == T006.MANDT
  • I_ARUNANLYTSSLSORDREJECTION.BASEUNIT == T006.MSEHI
Company Code to Be Billed
  • Company Code to Be Billed
  • Client
  • I_ARUNANLYTSSLSORDREJECTION.COMPANYCODE == T001.BUKRS
  • I_ARUNANLYTSSLSORDREJECTION.MANDT == T001.MANDT
Cross-Plant Configurable Material
  • Client
  • Cross-Plant Configurable Material
  • I_ARUNANLYTSSLSORDREJECTION.MANDT == MARA.MANDT
  • I_ARUNANLYTSSLSORDREJECTION.CROSSPLANTCONFIGURABLEPRODUCT == MARA.MATNR
Distribution channel in order header
  • Client
  • Sales Organization
  • Distribution Channel
  • I_ARUNANLYTSSLSORDREJECTION.MANDT == TVKOV.MANDT
  • I_ARUNANLYTSSLSORDREJECTION.SALESORGANIZATION == TVKOV.VKORG
  • I_ARUNANLYTSSLSORDREJECTION.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
Division
  • Client
  • Division
  • I_ARUNANLYTSSLSORDREJECTION.MANDT == TSPA.MANDT
  • I_ARUNANLYTSSLSORDREJECTION.DIVISION == TSPA.SPART
SD Document Currency
  • Client
  • SD Document Currency
  • I_ARUNANLYTSSLSORDREJECTION.MANDT == TCURC.MANDT
  • I_ARUNANLYTSSLSORDREJECTION.DOCUMENTCURRENCY == TCURC.WAERS
Plant
  • Client
  • Plant
  • I_ARUNANLYTSSLSORDREJECTION.MANDT == T001W.MANDT
  • I_ARUNANLYTSSLSORDREJECTION.PLANT == T001W.WERKS
Material Number
  • Client
  • Material Number
  • I_ARUNANLYTSSLSORDREJECTION.MANDT == MARA.MANDT
  • I_ARUNANLYTSSLSORDREJECTION.PRODUCT == MARA.MATNR
Fashion Collection
  • Client
  • Season
  • Fashion Collection
  • Season Year
Material Group
  • Client
  • Material Group
  • I_ARUNANLYTSSLSORDREJECTION.MANDT == T023.MANDT
  • I_ARUNANLYTSSLSORDREJECTION.PRODUCTGROUP == T023.MATKL
Season
  • Client
  • Season
  • Season Year
  • I_ARUNANLYTSSLSORDREJECTION.MANDT == FSH_SEASONS.MANDT
  • I_ARUNANLYTSSLSORDREJECTION.PRODUCTSEASON == FSH_SEASONS.FSH_SEASON
  • I_ARUNANLYTSSLSORDREJECTION.PRODUCTSEASONYEAR == FSH_SEASONS.FSH_SEASON_YEAR
Season Year
  • Client
  • Season
  • Season Year
  • I_ARUNANLYTSSLSORDREJECTION.MANDT == FSH_SEASONS.MANDT
  • I_ARUNANLYTSSLSORDREJECTION.PRODUCTSEASON == FSH_SEASONS.FSH_SEASON
  • I_ARUNANLYTSSLSORDREJECTION.PRODUCTSEASONYEAR == FSH_SEASONS.FSH_SEASON_YEAR
Fashion Theme
  • Client
  • Season
  • Fashion Collection
  • Season Year
  • Fashion Theme
  • I_ARUNANLYTSSLSORDREJECTION.MANDT == FSH_THEMES.MANDT
  • I_ARUNANLYTSSLSORDREJECTION.PRODUCTSEASON == FSH_THEMES.FSH_SEASON
  • I_ARUNANLYTSSLSORDREJECTION.PRODUCTCOLLECTION == FSH_THEMES.FSH_COLLECTION
  • I_ARUNANLYTSSLSORDREJECTION.PRODUCTSEASONYEAR == FSH_THEMES.FSH_SEASON_YEAR
  • I_ARUNANLYTSSLSORDREJECTION.PRODUCTTHEME == FSH_THEMES.FSH_THEME
Material type
  • Client
  • Material type
  • I_ARUNANLYTSSLSORDREJECTION.MANDT == T134.MANDT
  • I_ARUNANLYTSSLSORDREJECTION.PRODUCTTYPE == T134.MTART
Sales District
  • Client
  • Sales District
  • I_ARUNANLYTSSLSORDREJECTION.MANDT == T171.MANDT
  • I_ARUNANLYTSSLSORDREJECTION.SALESDISTRICT == T171.BZIRK
Reason for Rejection of Sales Documents
  • Client
  • Reason for Rejection of Sales Documents
  • I_ARUNANLYTSSLSORDREJECTION.MANDT == TVAG.MANDT
  • I_ARUNANLYTSSLSORDREJECTION.SALESDOCUMENTRJCNREASON == TVAG.ABGRU
Sales group
  • Client
  • Sales office
  • Sales group
  • I_ARUNANLYTSSLSORDREJECTION.MANDT == TVBVK.MANDT
  • I_ARUNANLYTSSLSORDREJECTION.SALESOFFICE == TVBVK.VKBUR
  • I_ARUNANLYTSSLSORDREJECTION.SALESGROUP == TVBVK.VKGRP
Sales organization in order header
  • Client
  • Sales Organization
  • I_ARUNANLYTSSLSORDREJECTION.MANDT == TVKO.MANDT
  • I_ARUNANLYTSSLSORDREJECTION.SALESORGANIZATION == TVKO.VKORG
Storage location
  • Client
  • Storage location
  • Plant
  • I_ARUNANLYTSSLSORDREJECTION.MANDT == T001L.MANDT
  • I_ARUNANLYTSSLSORDREJECTION.STORAGELOCATION == T001L.LGORT
  • I_ARUNANLYTSSLSORDREJECTION.PLANT == T001L.WERKS
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Client
  • Sales office
  • Sales Organization
  • Distribution Channel
  • Division
  • I_ARUNANLYTSSLSORDREJECTION.MANDT == TVKBZ.MANDT
  • I_ARUNANLYTSSLSORDREJECTION.SALESOFFICE == TVKBZ.VKBUR
  • I_ARUNANLYTSSLSORDREJECTION.SALESORGANIZATION == TVKBZ.VKORG
  • I_ARUNANLYTSSLSORDREJECTION.DISTRIBUTIONCHANNEL == TVKBZ.VTWEG
  • I_ARUNANLYTSSLSORDREJECTION.DIVISION == TVKBZ.SPART