I_ARunAnlytsTotDmndCube

Supply Assignment Total Demand - Cube | view: IARNALYSTDMND | TRAN | Extraction: Not supported | Component: Order Allocation Run
Tables used: VBAP, SCAL_TT_DATE, EKKO, EKPO, EKPV, EKET, VBKD, VEDA, VBAK, VBAK, VBAP, VBKD, VEDA, VBEP, PBED, PBIM, RESB, AFPO, RESB, RESB, EBAN, RESB, EKKO, EKPO, EBAN, EBKN, EKET, EKKO, EKPO, EKET, SCAL_TT_WEEK, VBPA, VBPA, LIPS, EKPO, MATDOC, EKET, EKKO, EKPO, ADCP, ADRC, ARUN_BDBS, ARUN_PREVIEW, ARUN_SDO_ALLDOC, SUP_CVC, SUP_OBJECT, CVI_CUST_CT_LINK, BUT000, KNA1, CVI_CUST_LINK, PACTLG_PATH, TVAK, TVKO, ARUN_SDO_ALLDOC, PBID, PLAF, LFA1, TVEP, MARA, MARC, T001K, T001W, KNVV, CVI_VEND_LINK, SUP_TIMEBUCKET, SUP_PCP, VBBE
Column Name Description
RequirementDocumentNumber Sales Document
RequirementDocumentItem Sales Document Item
SupProtTimeBucketUUID null
RequestedDate Material Staging/Availability Date
ProductAvailabilityDate Material Staging/Availability Date
RequirementType null
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 null
DeliveredQuantityInBaseUnit null
OpenDemandQuantity null
AssignedQuantityInBaseUnit null
NormalAssignedQuantityInBsUnt null
ARunPhysSupAssgdQtyInBsUnt null
SupAssgmtReservedQtyInBaseUnit null
FixedQuantityInBaseUnit null
OnHoldQuantityInBaseUnit null
SimulationRdyForRelQtyInBsUnt null
Column Name Description
RequestedDate Material Staging/Availability Date
ProductAvailabilityDate Material Staging/Availability Date
RequestedDeliveryDate null
FashionCancelDate Cancellation Date
Column Name Description
Column Name Description Domain name
RequirementTypeName Short Text for Fixed Values DDTEXT
ARunDocumentItemUniqueID Unique Identification for Supply Assignment Document Item CHAR17
PreviewAssignedQuantityInBsUnt null
ARunTmpAssignedQuantityInBsUnt null
ARunCancDteSupDlyTmeHrznCode null
CalendarYear Calendar Year NUM4
CalendarMonth Calendar Month NUM2
CalendarMonthName Short Text for Fixed Values DDTEXT
CalendarWeek null
CalendarDay Calendar Day NUM2
SalesOrganization Sales Organization VKORG
DistributionChannel Distribution Channel VTWEG
Division Division SPART
SalesDistrict Sales District BZIRK
SoldToParty null
ShipToParty null
CompanyCode Company Code to Be Billed BUKRS
SupplyProtectionName Name DDTEXT
RequirementSegment Requirement Segment SGT_SRCA
ProductCharacteristic1 Characteristic Value 1 WRF_CHARSTC
ProductCharacteristic2 Characteristic Value 2 WRF_CHARSTC
ProductCharacteristic3 Characteristic Value 3 WRF_CHARSTC
Master Data Relations Join Conditions
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • I_ARUNANLYTSTOTDMNDCUBE.MANDT == T006.MANDT
  • I_ARUNANLYTSTOTDMNDCUBE.BASEUNIT == T006.MSEHI
Country key
  • Country/Region Key
  • Client
  • I_ARUNANLYTSTOTDMNDCUBE.COUNTRY == T005.LAND1
  • I_ARUNANLYTSTOTDMNDCUBE.MANDT == T005.MANDT
Cross-Plant Configurable Material
  • Client
  • Cross-Plant Configurable Material
  • I_ARUNANLYTSTOTDMNDCUBE.MANDT == MARA.MANDT
  • I_ARUNANLYTSTOTDMNDCUBE.CROSSPLANTCONFIGURABLEPRODUCT == MARA.MATNR
Region (State, Province, County)
  • Client
  • Country/Region Key
  • Country/Region Key
  • Country/Region Key
  • Region (State, Province, County)
  • Region (State, Province, County)
  • Region (State, Province, County)
  • I_ARUNANLYTSTOTDMNDCUBE.MANDT == T005S.MANDT
  • I_ARUNANLYTSTOTDMNDCUBE.SHIPTOCOUNTRY == T005S.LAND1
  • I_ARUNANLYTSTOTDMNDCUBE.PLANTCOUNTRY == T005S.LAND1
  • I_ARUNANLYTSTOTDMNDCUBE.SOLDTOPARTYCOUNTRY == T005S.LAND1
  • I_ARUNANLYTSTOTDMNDCUBE.CUSTOMERREGION == T005S.BLAND
  • I_ARUNANLYTSTOTDMNDCUBE.SOLDTOPARTYREGION == T005S.BLAND
  • I_ARUNANLYTSTOTDMNDCUBE.PLANTREGION == T005S.BLAND
SD Document Currency
  • Client
  • SD Document Currency
  • I_ARUNANLYTSTOTDMNDCUBE.MANDT == TCURC.MANDT
  • I_ARUNANLYTSTOTDMNDCUBE.DOCUMENTCURRENCY == TCURC.WAERS
Plant
  • Client
  • Plant
  • I_ARUNANLYTSTOTDMNDCUBE.MANDT == T001W.MANDT
  • I_ARUNANLYTSTOTDMNDCUBE.PLANT == T001W.WERKS
Country key
  • Client
  • Country/Region Key
  • Country/Region Key
  • Country/Region Key
  • I_ARUNANLYTSTOTDMNDCUBE.MANDT == T005.MANDT
  • I_ARUNANLYTSTOTDMNDCUBE.SHIPTOCOUNTRY == T005.LAND1
  • I_ARUNANLYTSTOTDMNDCUBE.PLANTCOUNTRY == T005.LAND1
  • I_ARUNANLYTSTOTDMNDCUBE.SOLDTOPARTYCOUNTRY == T005.LAND1
Region
  • Client
  • Country/Region Key
  • Country/Region Key
  • Country/Region Key
  • Region (State, Province, County)
  • Region (State, Province, County)
  • Region (State, Province, County)
  • I_ARUNANLYTSTOTDMNDCUBE.MANDT == T005S.MANDT
  • I_ARUNANLYTSTOTDMNDCUBE.SHIPTOCOUNTRY == T005S.LAND1
  • I_ARUNANLYTSTOTDMNDCUBE.PLANTCOUNTRY == T005S.LAND1
  • I_ARUNANLYTSTOTDMNDCUBE.SOLDTOPARTYCOUNTRY == T005S.LAND1
  • I_ARUNANLYTSTOTDMNDCUBE.CUSTOMERREGION == T005S.BLAND
  • I_ARUNANLYTSTOTDMNDCUBE.SOLDTOPARTYREGION == T005S.BLAND
  • I_ARUNANLYTSTOTDMNDCUBE.PLANTREGION == T005S.BLAND
Material Number
  • Client
  • Material Number
  • I_ARUNANLYTSTOTDMNDCUBE.MANDT == MARA.MANDT
  • I_ARUNANLYTSTOTDMNDCUBE.PRODUCT == MARA.MATNR
Fashion Collection
  • Season Year
  • Client
  • Fashion Collection
  • Season
Material Group
  • Client
  • Material Group
  • I_ARUNANLYTSTOTDMNDCUBE.MANDT == T023.MANDT
  • I_ARUNANLYTSTOTDMNDCUBE.PRODUCTGROUP == T023.MATKL
Season
  • Season Year
  • Client
  • Season
  • I_ARUNANLYTSTOTDMNDCUBE.PRODUCTSEASONYEAR == FSH_SEASONS.FSH_SEASON_YEAR
  • I_ARUNANLYTSTOTDMNDCUBE.MANDT == FSH_SEASONS.MANDT
  • I_ARUNANLYTSTOTDMNDCUBE.PRODUCTSEASON == FSH_SEASONS.FSH_SEASON
Season Year
  • Season Year
  • Client
  • Season
  • I_ARUNANLYTSTOTDMNDCUBE.PRODUCTSEASONYEAR == FSH_SEASONS.FSH_SEASON_YEAR
  • I_ARUNANLYTSTOTDMNDCUBE.MANDT == FSH_SEASONS.MANDT
  • I_ARUNANLYTSTOTDMNDCUBE.PRODUCTSEASON == FSH_SEASONS.FSH_SEASON
Fashion Theme
  • Season Year
  • Client
  • Fashion Theme
  • Fashion Collection
  • Season
  • I_ARUNANLYTSTOTDMNDCUBE.PRODUCTSEASONYEAR == FSH_THEMES.FSH_SEASON_YEAR
  • I_ARUNANLYTSTOTDMNDCUBE.MANDT == FSH_THEMES.MANDT
  • I_ARUNANLYTSTOTDMNDCUBE.PRODUCTTHEME == FSH_THEMES.FSH_THEME
  • I_ARUNANLYTSTOTDMNDCUBE.PRODUCTCOLLECTION == FSH_THEMES.FSH_COLLECTION
  • I_ARUNANLYTSTOTDMNDCUBE.PRODUCTSEASON == FSH_THEMES.FSH_SEASON
Material type
  • Client
  • Material type
  • I_ARUNANLYTSTOTDMNDCUBE.MANDT == T134.MANDT
  • I_ARUNANLYTSTOTDMNDCUBE.PRODUCTTYPE == T134.MTART
Region code
  • Country/Region Key
  • Region (State, Province, County)
  • Client
  • I_ARUNANLYTSTOTDMNDCUBE.COUNTRY == T005S.LAND1
  • I_ARUNANLYTSTOTDMNDCUBE.REGION == T005S.BLAND
  • I_ARUNANLYTSTOTDMNDCUBE.MANDT == T005S.MANDT
Sales group
  • Client
  • Sales office
  • Sales group
  • I_ARUNANLYTSTOTDMNDCUBE.MANDT == TVBVK.MANDT
  • I_ARUNANLYTSTOTDMNDCUBE.SALESOFFICE == TVBVK.VKBUR
  • I_ARUNANLYTSTOTDMNDCUBE.SALESGROUP == TVBVK.VKGRP
Country/Region Key
  • Client
  • Country/Region Key
  • Country/Region Key
  • Country/Region Key
  • I_ARUNANLYTSTOTDMNDCUBE.MANDT == T005.MANDT
  • I_ARUNANLYTSTOTDMNDCUBE.SHIPTOCOUNTRY == T005.LAND1
  • I_ARUNANLYTSTOTDMNDCUBE.PLANTCOUNTRY == T005.LAND1
  • I_ARUNANLYTSTOTDMNDCUBE.SOLDTOPARTYCOUNTRY == T005.LAND1
Country/Region Key
  • Client
  • Country/Region Key
  • Country/Region Key
  • Country/Region Key
  • I_ARUNANLYTSTOTDMNDCUBE.MANDT == T005.MANDT
  • I_ARUNANLYTSTOTDMNDCUBE.SHIPTOCOUNTRY == T005.LAND1
  • I_ARUNANLYTSTOTDMNDCUBE.PLANTCOUNTRY == T005.LAND1
  • I_ARUNANLYTSTOTDMNDCUBE.SOLDTOPARTYCOUNTRY == T005.LAND1
Region (State, Province, County)
  • Client
  • Country/Region Key
  • Country/Region Key
  • Country/Region Key
  • Region (State, Province, County)
  • Region (State, Province, County)
  • Region (State, Province, County)
  • I_ARUNANLYTSTOTDMNDCUBE.MANDT == T005S.MANDT
  • I_ARUNANLYTSTOTDMNDCUBE.SHIPTOCOUNTRY == T005S.LAND1
  • I_ARUNANLYTSTOTDMNDCUBE.PLANTCOUNTRY == T005S.LAND1
  • I_ARUNANLYTSTOTDMNDCUBE.SOLDTOPARTYCOUNTRY == T005S.LAND1
  • I_ARUNANLYTSTOTDMNDCUBE.CUSTOMERREGION == T005S.BLAND
  • I_ARUNANLYTSTOTDMNDCUBE.SOLDTOPARTYREGION == T005S.BLAND
  • I_ARUNANLYTSTOTDMNDCUBE.PLANTREGION == T005S.BLAND
Storage location
  • Client
  • Storage location
  • Plant
  • I_ARUNANLYTSTOTDMNDCUBE.MANDT == T001L.MANDT
  • I_ARUNANLYTSTOTDMNDCUBE.STORAGELOCATION == T001L.LGORT
  • I_ARUNANLYTSTOTDMNDCUBE.PLANT == T001L.WERKS
Other Relations | to Master Data Relations ↑ Join Conditions
Sales office
  • Client
  • Sales office
  • ?
  • ?
  • ?
  • I_ARUNANLYTSTOTDMNDCUBE.MANDT == TVKBZ.MANDT
  • I_ARUNANLYTSTOTDMNDCUBE.SALESOFFICE == TVKBZ.VKBUR
  • I_ARUNANLYTSTOTDMNDCUBE.[column in domain "SPART"] == TVKBZ.SPART
  • I_ARUNANLYTSTOTDMNDCUBE.[column in domain "VKORG"] == TVKBZ.VKORG
  • I_ARUNANLYTSTOTDMNDCUBE.[column in domain "VTWEG"] == TVKBZ.VTWEG