C_ARunOvwTotDmndQuery

Supply Assignment Run Demand Query View | view: CARUNDMNDQUERY | Extraction: Not supported | Component: Order Allocation Run
Column Name Description
ATPCheckUUID Check ID
RequirementDocumentNumber Document Number
RequirementDocumentItem Line Item Number
RequestedDate Schedule line date
ProductAvailabilityDate Material Staging/Availability Date
RequirementType Category of a Document Included in ATP Checks
Column Name Description
💲 SD Document Currency (DocumentCurrency):
NetPriceAmount Net Price
NetAmount Net Value of the Order Item in Document Currency
Column Name Description
📏 Unit (BaseUnit):
DeliveredQuantityInBaseUnit null
RequestedRqmtQtyInBaseUnit null
ConfirmedRqmtQtyInBaseUnit null
OpenDemandQuantity null
ARunReqdRqmtQtyFlfmtPercent Assigned Quantity by ARun
ARunConfdReqdRqmtQtyRatioPct Assigned Quantity by ARun
ARunDlvrdReqdRqmtQtyRatioPct Assigned Quantity by ARun
ARunOpnReqdRqmtQtyRatioPct Assigned Quantity by ARun
AssignedQuantityInBaseUnit null
FixedQuantityInBaseUnit null
SupAssgmtReservedQtyInBaseUnit null
ReadyForReleaseQtyInBaseUnit null
OnHoldQuantityInBaseUnit null
InboundAssignedQuantityInBsUnt null
ARunFixedConfdRqmtQtyRatioPct Assigned Quantity by ARun
ARunOpnForRelConfdQtyRatioPct Assigned Quantity by ARun
ARunOnResvnConfdQtyRatioPct Assigned Quantity by ARun
ARunOnHoldConfdQtyRatioPct Assigned Quantity by ARun
ARunInbAssgdConfdQtyRatioPct Assigned Quantity by ARun
ARunTotSupProtQty Total Restriction Quantity
ARunActualSupProtQty Actual Restriction Quantity
Column Name Description
RequestedDate Schedule line date
ProductAvailabilityDate Material Staging/Availability Date
FashionCancelDate Cancellation Date
Column Name Description
ABOPExecutionMode Indicates if ATP Check was a Simulation Show values
ABOPAssignmentPreviewIsActive Supply Assignment: Preview Show values
Column Name Description Domain name
ARunDocumentItemUniqueID Unique Identification for Supply Assignment Document Item
DocumentItemConcatenatedID Unique Identification for Supply Assignment Document Item CHAR17
CalendarMonth Calendar Month
CalendarWeek null
CalendarYear Calendar Year
CalendarDay Calendar Day
CalendarMonthName Short Text for Fixed Values
ABOPVariantUUID BOP Variant UUID
ABOPVariantName Name for BOP Variant
StartedByUser User Name SYCHAR12
ATPCheckStatus null
ATPRlvtDocItmIsSupAssgmtRlvt null
Material Material Number
Plant Plant WERKS
RequirementSegment Requirement Segment SGT_SRCA
OrderTypeName Sales Document Type Description
SoldToParty Sold-to Party
ShipToParty Customer Number
DeliveryGroup Delivery Group (Items are delivered together) GRKOR
PurchaseOrderByCustomer Customer Reference BSTKD
ProductCharacteristic1 Characteristic Value 1 WRF_CHARSTC
ProductCharacteristic2 Characteristic Value 2 WRF_CHARSTC
ProductCharacteristic3 Characteristic Value 3 WRF_CHARSTC
ProdCharc1InternalNumber Internal Charactieristic Number for Color Characteristics ATINN
ProdCharc2InternalNumber Internal Char. Number for Characteristics for Main Sizes ATINN
ProdCharc3InternalNumber Internal Char. Number for Characteristics for Second Sizes ATINN
NetPriceQuantity Condition Pricing Unit KPEIN
Master Data Relations Join Conditions
Company Code to Be Billed
  • Client
  • Company Code to Be Billed
  • C_ARUNOVWTOTDMNDQUERY.MANDT == T001.MANDT
  • C_ARUNOVWTOTDMNDQUERY.COMPANYCODE == T001.BUKRS
Cross-Plant Configurable Material
  • Client
  • Cross-Plant Configurable Material
  • C_ARUNOVWTOTDMNDQUERY.MANDT == MARA.MANDT
  • C_ARUNOVWTOTDMNDQUERY.CROSSPLANTCONFIGURABLEPRODUCT == MARA.MATNR
Customer Group
  • Client
  • Customer Group
  • C_ARUNOVWTOTDMNDQUERY.MANDT == T151.MANDT
  • C_ARUNOVWTOTDMNDQUERY.CUSTOMERGROUP == T151.KDGRP
Delivery Block (Document Header)
  • Client
  • Delivery Block (Document Header)
  • C_ARUNOVWTOTDMNDQUERY.MANDT == TVLS.MANDT
  • C_ARUNOVWTOTDMNDQUERY.DELIVERYBLOCKREASON == TVLS.LIFSP
Distribution channel in order header
  • Sales Organization
  • Client
  • Distribution Channel
  • C_ARUNOVWTOTDMNDQUERY.SALESORGANIZATION == TVKOV.VKORG
  • C_ARUNOVWTOTDMNDQUERY.MANDT == TVKOV.MANDT
  • C_ARUNOVWTOTDMNDQUERY.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
Division
  • Division
  • Division
  • Client
  • C_ARUNOVWTOTDMNDQUERY.DIVISION == TSPA.SPART
  • C_ARUNOVWTOTDMNDQUERY.ORGANIZATIONDIVISION == TSPA.SPART
  • C_ARUNOVWTOTDMNDQUERY.MANDT == TSPA.MANDT
SD Document Currency
  • Client
  • SD Document Currency
  • C_ARUNOVWTOTDMNDQUERY.MANDT == TCURC.MANDT
  • C_ARUNOVWTOTDMNDQUERY.DOCUMENTCURRENCY == TCURC.WAERS
Material Group
  • Client
  • Material Group
  • C_ARUNOVWTOTDMNDQUERY.MANDT == T023.MANDT
  • C_ARUNOVWTOTDMNDQUERY.MATERIALGROUP == T023.MATKL
Order type in order header
  • Sales Document Type
  • Client
  • C_ARUNOVWTOTDMNDQUERY.ORDERTYPE == TVAK.AUART
  • C_ARUNOVWTOTDMNDQUERY.MANDT == TVAK.MANDT
Division in order header
  • Division
  • Division
  • Sales Organization
  • Client
  • Distribution Channel
  • C_ARUNOVWTOTDMNDQUERY.DIVISION == TVTA.SPART
  • C_ARUNOVWTOTDMNDQUERY.ORGANIZATIONDIVISION == TVTA.SPART
  • C_ARUNOVWTOTDMNDQUERY.SALESORGANIZATION == TVTA.VKORG
  • C_ARUNOVWTOTDMNDQUERY.MANDT == TVTA.MANDT
  • C_ARUNOVWTOTDMNDQUERY.DISTRIBUTIONCHANNEL == TVTA.VTWEG
Fashion Collection
  • Season Year
  • Fashion Collection
  • Client
  • Season
Season
  • Season Year
  • Client
  • Season
  • C_ARUNOVWTOTDMNDQUERY.PRODUCTSEASONYEAR == FSH_SEASONS.FSH_SEASON_YEAR
  • C_ARUNOVWTOTDMNDQUERY.MANDT == FSH_SEASONS.MANDT
  • C_ARUNOVWTOTDMNDQUERY.PRODUCTSEASON == FSH_SEASONS.FSH_SEASON
Season Year
  • Season Year
  • Client
  • Season
  • C_ARUNOVWTOTDMNDQUERY.PRODUCTSEASONYEAR == FSH_SEASONS.FSH_SEASON_YEAR
  • C_ARUNOVWTOTDMNDQUERY.MANDT == FSH_SEASONS.MANDT
  • C_ARUNOVWTOTDMNDQUERY.PRODUCTSEASON == FSH_SEASONS.FSH_SEASON
Fashion Theme
  • Season Year
  • Fashion Collection
  • Client
  • Season
  • Fashion Theme
  • C_ARUNOVWTOTDMNDQUERY.PRODUCTSEASONYEAR == FSH_THEMES.FSH_SEASON_YEAR
  • C_ARUNOVWTOTDMNDQUERY.PRODUCTCOLLECTION == FSH_THEMES.FSH_COLLECTION
  • C_ARUNOVWTOTDMNDQUERY.MANDT == FSH_THEMES.MANDT
  • C_ARUNOVWTOTDMNDQUERY.PRODUCTSEASON == FSH_THEMES.FSH_SEASON
  • C_ARUNOVWTOTDMNDQUERY.PRODUCTTHEME == FSH_THEMES.FSH_THEME
Sales District
  • Sales District
  • Client
  • C_ARUNOVWTOTDMNDQUERY.SALESDISTRICT == T171.BZIRK
  • C_ARUNOVWTOTDMNDQUERY.MANDT == T171.MANDT
Sales organization in order header
  • Sales Organization
  • Client
  • C_ARUNOVWTOTDMNDQUERY.SALESORGANIZATION == TVKO.VKORG
  • C_ARUNOVWTOTDMNDQUERY.MANDT == TVKO.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Division
  • Division
  • Sales office
  • Sales Organization
  • Client
  • Distribution Channel
  • C_ARUNOVWTOTDMNDQUERY.DIVISION == TVKBZ.SPART
  • C_ARUNOVWTOTDMNDQUERY.ORGANIZATIONDIVISION == TVKBZ.SPART
  • C_ARUNOVWTOTDMNDQUERY.SALESOFFICE == TVKBZ.VKBUR
  • C_ARUNOVWTOTDMNDQUERY.SALESORGANIZATION == TVKBZ.VKORG
  • C_ARUNOVWTOTDMNDQUERY.MANDT == TVKBZ.MANDT
  • C_ARUNOVWTOTDMNDQUERY.DISTRIBUTIONCHANNEL == TVKBZ.VTWEG