I_ARunAnlytsSupDmndOvwCube

Overview of Supply and Demand - Cube | view: IARNANLTSADOVWC | TRAN | Extraction: Not supported | Component: Order Allocation Run

Tables used: VBAP, CKMLCR, FMLT_PRICE, SCAL_TT_DATE, MATDOC, EKKO, EKPO, EKPV, EKET, VBKD, VEDA, VBAK, VBAK, VBAP, VBKD, VEDA, VBEP, EKKN, EKKO, EKPO, LIKP, LIPS, PBED, PBIM, RESB, EKKN, EKKO, EKPO, AFPO, AFPO, RESB, EKKO, EKPO, EKAB, RESB, EBAN, EBKN, EBAN, RESB, LIKP, LIPS, VBAK, VBAP, VBEP, VBKD, EKKO, EKPO, EBAN, EBKN, EKET, EKKO, EKPO, EKES, EKET, EKET, SCAL_TT_WEEK, VBPA, VBPA, LIPS, EKPO, MATDOC, VBAK, VBAP, VBEP, EKET, EKKO, EKPO, ACDOCA_M_EXTRACT, MARA, ADCP, ADRC, ARUN_BDBS, ARUN_PREVIEW, ARUN_SDO_ALLDOC, ARUN_BDBS, ARUN_PREVIEW, ARUN_SDO_ALLDOC, SUP_CVC, SUP_OBJECT, CVI_CUST_CT_LINK, BUT000, T001, TKA02, KNA1, CVI_CUST_LINK, PACTLG_PATH, MARA, T001K, TVAK, TVKO, ARUN_SDO_ALLDOC, T16FB, KNA1, VBBE, PBID, PLAF, PLAF, T16FB, AUFK, T16FB, LFA1, LFA1, KNA1, KNA1, TVEP, MARA, MARC, MCHA, T001K, T001W, KNVV, CVI_VEND_LINK, ARUN_BDBS, SUP_TIMEBUCKET, SUP_PCP, EBEW, MBEW, MBEW, MBEW, OBEW, QBEW, VBBE, TVEP, FMLT_CURTP_ML

🔑 Keys (13)
💰 Amounts (1)
∑ Quantities (11)
📅 Dates (2)
☰ Categorical
Other (15)
🔗 Relations (17)

Column Name	Description
RequirementDocumentNumber	Sales Document
RequirementDocumentItem	Sales Document Item
SupProtTimeBucketUUID	null
ProductAvailabilityDate	Material Staging/Availability Date
RequirementType	null
SupplyNumber	null
SupplyItem	null
SupplyScheduleLine	null
AssignedSupplyType	null
Product FK	Material Number
Plant FK	Plant
Batch	Batch Number
StorageLocation FK	Storage location

Column Name	Description
💲 SD Document Currency (DocumentCurrency):
NetPriceAmount	Net Price

Column Name	Description
📏 Base Unit of Measure (SupAssgmtAggrgQtyUnit):
RequestedRqmtQtyInBaseUnit	null
ConfirmedRqmtQtyInBaseUnit	null
DeliveredQuantityInBaseUnit	null
OpenDemandQuantity	null
AssignedQuantityInBaseUnit	null
NormalAssignedQuantityInBsUnt	null
OpenSupplyQuantity	null
AssignedSupplyQtyInBaseUnit	null
NormalSupplyQtyInBaseUnit	null
PreviewSupplyQtyInBaseUnit	null
ARunTmpAssgdSupQtyInBaseUnit	null

Column Name	Description
ProductAvailabilityDate	Material Staging/Availability Date
RequestedDeliveryDate	null

Column Name	Description

Column Name	Description	Domain name
PreviewAssignedQuantityInBsUnt	null
ARunTmpAssignedQuantityInBsUnt	null
CalendarYear	Calendar Year	NUM4
CalendarMonth	Calendar Month	NUM2
CalendarMonthName	Short Text for Fixed Values	DDTEXT
CalendarWeek	null
CalendarDay	Calendar Day	NUM2
SupAssgmtSource	null
SalesOrganization	Sales Organization	VKORG
DistributionChannel	Distribution Channel	VTWEG
Division	Division	SPART
SalesDistrict	Sales District	BZIRK
CompanyCode	Company Code to Be Billed	BUKRS
SoldToParty	null
ShipToParty	null

Master Data Relations	Join Conditions
Base Unit of Measure Base Unit of Measure Client	`I_ARUNANLYTSSUPDMNDOVWCUBE.BASEUNIT == T006.MSEHI` `I_ARUNANLYTSSUPDMNDOVWCUBE.MANDT == T006.MANDT`
Country key Client Country/Region Key	`I_ARUNANLYTSSUPDMNDOVWCUBE.MANDT == T005.MANDT` `I_ARUNANLYTSSUPDMNDOVWCUBE.COUNTRY == T005.LAND1`
Cross-Plant Configurable Material Client Cross-Plant Configurable Material	`I_ARUNANLYTSSUPDMNDOVWCUBE.MANDT == MARA.MANDT` `I_ARUNANLYTSSUPDMNDOVWCUBE.CROSSPLANTCONFIGURABLEPRODUCT == MARA.MATNR`
Region (State, Province, County) Country/Region Key Country/Region Key Country/Region Key Client Region (State, Province, County) Region (State, Province, County)	`I_ARUNANLYTSSUPDMNDOVWCUBE.PLANTCOUNTRY == T005S.LAND1` `I_ARUNANLYTSSUPDMNDOVWCUBE.SHIPTOCOUNTRY == T005S.LAND1` `I_ARUNANLYTSSUPDMNDOVWCUBE.SOLDTOPARTYCOUNTRY == T005S.LAND1` `I_ARUNANLYTSSUPDMNDOVWCUBE.MANDT == T005S.MANDT` `I_ARUNANLYTSSUPDMNDOVWCUBE.CUSTOMERREGION == T005S.BLAND` `I_ARUNANLYTSSUPDMNDOVWCUBE.SOLDTOPARTYREGION == T005S.BLAND`
SD Document Currency SD Document Currency Client	`I_ARUNANLYTSSUPDMNDOVWCUBE.DOCUMENTCURRENCY == TCURC.WAERS` `I_ARUNANLYTSSUPDMNDOVWCUBE.MANDT == TCURC.MANDT`
Plant Client Plant	`I_ARUNANLYTSSUPDMNDOVWCUBE.MANDT == T001W.MANDT` `I_ARUNANLYTSSUPDMNDOVWCUBE.PLANT == T001W.WERKS`
Country key Country/Region Key Country/Region Key Country/Region Key Client	`I_ARUNANLYTSSUPDMNDOVWCUBE.PLANTCOUNTRY == T005.LAND1` `I_ARUNANLYTSSUPDMNDOVWCUBE.SHIPTOCOUNTRY == T005.LAND1` `I_ARUNANLYTSSUPDMNDOVWCUBE.SOLDTOPARTYCOUNTRY == T005.LAND1` `I_ARUNANLYTSSUPDMNDOVWCUBE.MANDT == T005.MANDT`
Material Number Material Number Client	`I_ARUNANLYTSSUPDMNDOVWCUBE.PRODUCT == MARA.MATNR` `I_ARUNANLYTSSUPDMNDOVWCUBE.MANDT == MARA.MANDT`
Material Group Client Material Group	`I_ARUNANLYTSSUPDMNDOVWCUBE.MANDT == T023.MANDT` `I_ARUNANLYTSSUPDMNDOVWCUBE.PRODUCTGROUP == T023.MATKL`
Material type Client Material type	`I_ARUNANLYTSSUPDMNDOVWCUBE.MANDT == T134.MANDT` `I_ARUNANLYTSSUPDMNDOVWCUBE.PRODUCTTYPE == T134.MTART`
Region code Client Country/Region Key Region (State, Province, County)	`I_ARUNANLYTSSUPDMNDOVWCUBE.MANDT == T005S.MANDT` `I_ARUNANLYTSSUPDMNDOVWCUBE.COUNTRY == T005S.LAND1` `I_ARUNANLYTSSUPDMNDOVWCUBE.REGION == T005S.BLAND`
Sales group Sales office Client Sales group	`I_ARUNANLYTSSUPDMNDOVWCUBE.SALESOFFICE == TVBVK.VKBUR` `I_ARUNANLYTSSUPDMNDOVWCUBE.MANDT == TVBVK.MANDT` `I_ARUNANLYTSSUPDMNDOVWCUBE.SALESGROUP == TVBVK.VKGRP`
Country/Region Key Country/Region Key Country/Region Key Country/Region Key Client	`I_ARUNANLYTSSUPDMNDOVWCUBE.PLANTCOUNTRY == T005.LAND1` `I_ARUNANLYTSSUPDMNDOVWCUBE.SHIPTOCOUNTRY == T005.LAND1` `I_ARUNANLYTSSUPDMNDOVWCUBE.SOLDTOPARTYCOUNTRY == T005.LAND1` `I_ARUNANLYTSSUPDMNDOVWCUBE.MANDT == T005.MANDT`
Country/Region Key Country/Region Key Country/Region Key Country/Region Key Client	`I_ARUNANLYTSSUPDMNDOVWCUBE.PLANTCOUNTRY == T005.LAND1` `I_ARUNANLYTSSUPDMNDOVWCUBE.SHIPTOCOUNTRY == T005.LAND1` `I_ARUNANLYTSSUPDMNDOVWCUBE.SOLDTOPARTYCOUNTRY == T005.LAND1` `I_ARUNANLYTSSUPDMNDOVWCUBE.MANDT == T005.MANDT`
Region (State, Province, County) Country/Region Key Country/Region Key Country/Region Key Client Region (State, Province, County) Region (State, Province, County)	`I_ARUNANLYTSSUPDMNDOVWCUBE.PLANTCOUNTRY == T005S.LAND1` `I_ARUNANLYTSSUPDMNDOVWCUBE.SHIPTOCOUNTRY == T005S.LAND1` `I_ARUNANLYTSSUPDMNDOVWCUBE.SOLDTOPARTYCOUNTRY == T005S.LAND1` `I_ARUNANLYTSSUPDMNDOVWCUBE.MANDT == T005S.MANDT` `I_ARUNANLYTSSUPDMNDOVWCUBE.CUSTOMERREGION == T005S.BLAND` `I_ARUNANLYTSSUPDMNDOVWCUBE.SOLDTOPARTYREGION == T005S.BLAND`
Storage location Client Plant Storage location	`I_ARUNANLYTSSUPDMNDOVWCUBE.MANDT == T001L.MANDT` `I_ARUNANLYTSSUPDMNDOVWCUBE.PLANT == T001L.WERKS` `I_ARUNANLYTSSUPDMNDOVWCUBE.STORAGELOCATION == T001L.LGORT`

Other Relations \| to Master Data Relations ↑	Join Conditions
Sales office Sales office ? Client ? ?	`I_ARUNANLYTSSUPDMNDOVWCUBE.SALESOFFICE == TVKBZ.VKBUR` `I_ARUNANLYTSSUPDMNDOVWCUBE.[column in domain "VKORG"] == TVKBZ.VKORG` `I_ARUNANLYTSSUPDMNDOVWCUBE.MANDT == TVKBZ.MANDT` `I_ARUNANLYTSSUPDMNDOVWCUBE.[column in domain "SPART"] == TVKBZ.SPART` `I_ARUNANLYTSSUPDMNDOVWCUBE.[column in domain "VTWEG"] == TVKBZ.VTWEG`