I_ARunOvwTotDmndCube

Supply Assignment Run Demand Cube View | view: IARUNTOTDMNDCUBE | TRAN | Extraction: Not supported | Component: Order Allocation Run
Tables used: VBAK, VBAP, VBKD, EKKO, EKPO, EKPV, SCAL_TT_DATE, EKKO, EKPO, EKPV, RESB, VBAK, VBAP, VBKD, EKKO, EKPO, EKPV, VBPA, VBPA, LIPS, VBAK, VBAP, VBEP, EKET, EKKO, EKPO, EKPV, ATP_BOP_VARIANT, KNA1, KNA1, ARUN_RULE, ARUN_RULE_TEXT, ARUN_SIM_LOG, ARUN_SIMULATION, ATP_CHECK, ATP_FUP_RUN, ATP_SELD_FU_RQMT, CVI_CUST_CT_LINK, BUT000, CVI_CUST_LINK, MARA, T161T, TVAKT, MARA, MARC, KNA1, KNA1, ARUN_BDBS, ARUN_PREVIEW, KNVV, CVI_VEND_LINK, VBBE, ATP_SELD_RQMT
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
ActlAmt Net Value in Document Currency
Column Name Description
📏 Base Unit of Measure (SupAssgmtAggrgQtyUnit):
DeliveredQuantityInBaseUnit null
RequestedRqmtQtyInBaseUnit null
ConfirmedRqmtQtyInBaseUnit null
OpenDemandQuantity null
ARunTotSupProtQty Total Restriction Quantity
ARunActualSupProtQty Actual Restriction Quantity
AssignedQuantityInBaseUnit null
NormalAssignedQuantityInBsUnt null
FixedQuantityInBaseUnit null
SupAssgmtReservedQtyInBaseUnit null
ReadyForReleaseQtyInBaseUnit null
OnHoldQuantityInBaseUnit null
InboundAssignedQuantityInBsUnt null
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
ABOPVariantUUID BOP Variant UUID
ABOPVariantName Name for BOP Variant
StartedByUser User Name SYCHAR12
ATPCheckStartUTCDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
ATPCheckEndUTCDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
ATPCheckStatus null
ATPRlvtDocItmIsSupAssgmtRlvt null
Material Material Number MATNR
Plant Plant WERKS
RequirementSegment Requirement Segment SGT_SRCA
OrderTypeName Sales Document Type Description TEXT20
SoldToParty Sold-to Party KUNNR
ShipToParty Customer Number KUNNR
DeliveryGroup Delivery Group (Items are delivered together) GRKOR
NetPriceQuantity Condition Pricing Unit KPEIN
CalendarYear Calendar Year
CalendarMonth Calendar Month NUM2
CalendarMonthName Short Text for Fixed Values
CalendarWeek null
CalendarDay Calendar Day
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
Master Data Relations Join Conditions
Company Code to Be Billed
  • Company Code to Be Billed
  • Client
  • I_ARUNOVWTOTDMNDCUBE.COMPANYCODE == T001.BUKRS
  • I_ARUNOVWTOTDMNDCUBE.MANDT == T001.MANDT
Cross-Plant Configurable Material
  • Cross-Plant Configurable Material
  • Client
  • I_ARUNOVWTOTDMNDCUBE.CROSSPLANTCONFIGURABLEPRODUCT == MARA.MATNR
  • I_ARUNOVWTOTDMNDCUBE.MANDT == MARA.MANDT
Customer Group
  • Customer Group
  • Client
  • I_ARUNOVWTOTDMNDCUBE.CUSTOMERGROUP == T151.KDGRP
  • I_ARUNOVWTOTDMNDCUBE.MANDT == T151.MANDT
Delivery Block (Document Header)
  • Delivery Block (Document Header)
  • Client
  • I_ARUNOVWTOTDMNDCUBE.DELIVERYBLOCKREASON == TVLS.LIFSP
  • I_ARUNOVWTOTDMNDCUBE.MANDT == TVLS.MANDT
Distribution channel in order header
  • Sales Organization
  • Client
  • Distribution Channel
  • I_ARUNOVWTOTDMNDCUBE.SALESORGANIZATION == TVKOV.VKORG
  • I_ARUNOVWTOTDMNDCUBE.MANDT == TVKOV.MANDT
  • I_ARUNOVWTOTDMNDCUBE.DISTRIBUTIONCHANNEL == TVKOV.VTWEG
Division
  • Client
  • Division
  • Division
  • I_ARUNOVWTOTDMNDCUBE.MANDT == TSPA.MANDT
  • I_ARUNOVWTOTDMNDCUBE.DIVISION == TSPA.SPART
  • I_ARUNOVWTOTDMNDCUBE.ORGANIZATIONDIVISION == TSPA.SPART
SD Document Currency
  • Client
  • SD Document Currency
  • I_ARUNOVWTOTDMNDCUBE.MANDT == TCURC.MANDT
  • I_ARUNOVWTOTDMNDCUBE.DOCUMENTCURRENCY == TCURC.WAERS
Material Group
  • Material Group
  • Client
  • I_ARUNOVWTOTDMNDCUBE.MATERIALGROUP == T023.MATKL
  • I_ARUNOVWTOTDMNDCUBE.MANDT == T023.MANDT
Order type in order header
  • Sales Document Type
  • Client
  • I_ARUNOVWTOTDMNDCUBE.ORDERTYPE == TVAK.AUART
  • I_ARUNOVWTOTDMNDCUBE.MANDT == TVAK.MANDT
Division in order header
  • Sales Organization
  • Client
  • Division
  • Division
  • Distribution Channel
  • I_ARUNOVWTOTDMNDCUBE.SALESORGANIZATION == TVTA.VKORG
  • I_ARUNOVWTOTDMNDCUBE.MANDT == TVTA.MANDT
  • I_ARUNOVWTOTDMNDCUBE.DIVISION == TVTA.SPART
  • I_ARUNOVWTOTDMNDCUBE.ORGANIZATIONDIVISION == TVTA.SPART
  • I_ARUNOVWTOTDMNDCUBE.DISTRIBUTIONCHANNEL == TVTA.VTWEG
Fashion Collection
  • Fashion Collection
  • Season
  • Season Year
  • Client
Season
  • Season
  • Season Year
  • Client
  • I_ARUNOVWTOTDMNDCUBE.PRODUCTSEASON == FSH_SEASONS.FSH_SEASON
  • I_ARUNOVWTOTDMNDCUBE.PRODUCTSEASONYEAR == FSH_SEASONS.FSH_SEASON_YEAR
  • I_ARUNOVWTOTDMNDCUBE.MANDT == FSH_SEASONS.MANDT
Season Year
  • Season
  • Season Year
  • Client
  • I_ARUNOVWTOTDMNDCUBE.PRODUCTSEASON == FSH_SEASONS.FSH_SEASON
  • I_ARUNOVWTOTDMNDCUBE.PRODUCTSEASONYEAR == FSH_SEASONS.FSH_SEASON_YEAR
  • I_ARUNOVWTOTDMNDCUBE.MANDT == FSH_SEASONS.MANDT
Fashion Theme
  • Fashion Collection
  • Season
  • Season Year
  • Client
  • Fashion Theme
  • I_ARUNOVWTOTDMNDCUBE.PRODUCTCOLLECTION == FSH_THEMES.FSH_COLLECTION
  • I_ARUNOVWTOTDMNDCUBE.PRODUCTSEASON == FSH_THEMES.FSH_SEASON
  • I_ARUNOVWTOTDMNDCUBE.PRODUCTSEASONYEAR == FSH_THEMES.FSH_SEASON_YEAR
  • I_ARUNOVWTOTDMNDCUBE.MANDT == FSH_THEMES.MANDT
  • I_ARUNOVWTOTDMNDCUBE.PRODUCTTHEME == FSH_THEMES.FSH_THEME
Sales District
  • Sales District
  • Client
  • I_ARUNOVWTOTDMNDCUBE.SALESDISTRICT == T171.BZIRK
  • I_ARUNOVWTOTDMNDCUBE.MANDT == T171.MANDT
Sales organization in order header
  • Sales Organization
  • Client
  • I_ARUNOVWTOTDMNDCUBE.SALESORGANIZATION == TVKO.VKORG
  • I_ARUNOVWTOTDMNDCUBE.MANDT == TVKO.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Sales office
  • Sales Organization
  • Client
  • Division
  • Division
  • Distribution Channel
  • I_ARUNOVWTOTDMNDCUBE.SALESOFFICE == TVKBZ.VKBUR
  • I_ARUNOVWTOTDMNDCUBE.SALESORGANIZATION == TVKBZ.VKORG
  • I_ARUNOVWTOTDMNDCUBE.MANDT == TVKBZ.MANDT
  • I_ARUNOVWTOTDMNDCUBE.DIVISION == TVKBZ.SPART
  • I_ARUNOVWTOTDMNDCUBE.ORGANIZATIONDIVISION == TVKBZ.SPART
  • I_ARUNOVWTOTDMNDCUBE.DISTRIBUTIONCHANNEL == TVKBZ.VTWEG