C_ARunAnlytsSupDmndOvwQry

Overview of Supply and Demand Query | view: CARNANLYTSADOVWQ | 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 (16)
🔗 Relations (13)

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	Storage location

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

Column Name	Description
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
SupAssgmtSource	null
PreviewAssignedQuantityInBsUnt	null
ARunTmpAssignedQuantityInBsUnt	null
CalendarYear	Calendar Year
CalendarMonth	Calendar Month
CalendarMonthName	Short Text for Fixed Values
CalendarWeek	null
CalendarDay	Calendar Day
ProductGroup	Material Group
SalesOrganization	Sales Organization
DistributionChannel	Distribution Channel	VTWEG
Division	Division	SPART
SalesDistrict	Sales District
CompanyCode	Company Code to Be Billed
SoldToParty	null
ShipToParty	null

Master Data Relations	Join Conditions
Country key Client Country/Region Key	`C_ARUNANLYTSSUPDMNDOVWQRY.MANDT == T005.MANDT` `C_ARUNANLYTSSUPDMNDOVWQRY.COUNTRY == T005.LAND1`
Cross-Plant Configurable Material Client Cross-Plant Configurable Material	`C_ARUNANLYTSSUPDMNDOVWQRY.MANDT == MARA.MANDT` `C_ARUNANLYTSSUPDMNDOVWQRY.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)	`C_ARUNANLYTSSUPDMNDOVWQRY.MANDT == T005S.MANDT` `C_ARUNANLYTSSUPDMNDOVWQRY.SOLDTOPARTYCOUNTRY == T005S.LAND1` `C_ARUNANLYTSSUPDMNDOVWQRY.PLANTCOUNTRY == T005S.LAND1` `C_ARUNANLYTSSUPDMNDOVWQRY.SHIPTOCOUNTRY == T005S.LAND1` `C_ARUNANLYTSSUPDMNDOVWQRY.SOLDTOPARTYREGION == T005S.BLAND` `C_ARUNANLYTSSUPDMNDOVWQRY.CUSTOMERREGION == T005S.BLAND`
Plant Client Plant	`C_ARUNANLYTSSUPDMNDOVWQRY.MANDT == T001W.MANDT` `C_ARUNANLYTSSUPDMNDOVWQRY.PLANT == T001W.WERKS`
Country key Client Country/Region Key Country/Region Key Country/Region Key	`C_ARUNANLYTSSUPDMNDOVWQRY.MANDT == T005.MANDT` `C_ARUNANLYTSSUPDMNDOVWQRY.SOLDTOPARTYCOUNTRY == T005.LAND1` `C_ARUNANLYTSSUPDMNDOVWQRY.PLANTCOUNTRY == T005.LAND1` `C_ARUNANLYTSSUPDMNDOVWQRY.SHIPTOCOUNTRY == T005.LAND1`
Material Number Client Material Number	`C_ARUNANLYTSSUPDMNDOVWQRY.MANDT == MARA.MANDT` `C_ARUNANLYTSSUPDMNDOVWQRY.PRODUCT == MARA.MATNR`
Material type Client Material type	`C_ARUNANLYTSSUPDMNDOVWQRY.MANDT == T134.MANDT` `C_ARUNANLYTSSUPDMNDOVWQRY.PRODUCTTYPE == T134.MTART`
Region code Region (State, Province, County) Client Country/Region Key	`C_ARUNANLYTSSUPDMNDOVWQRY.REGION == T005S.BLAND` `C_ARUNANLYTSSUPDMNDOVWQRY.MANDT == T005S.MANDT` `C_ARUNANLYTSSUPDMNDOVWQRY.COUNTRY == T005S.LAND1`
Sales group Client Sales group Sales office	`C_ARUNANLYTSSUPDMNDOVWQRY.MANDT == TVBVK.MANDT` `C_ARUNANLYTSSUPDMNDOVWQRY.SALESGROUP == TVBVK.VKGRP` `C_ARUNANLYTSSUPDMNDOVWQRY.SALESOFFICE == TVBVK.VKBUR`
Country/Region Key Client Country/Region Key Country/Region Key Country/Region Key	`C_ARUNANLYTSSUPDMNDOVWQRY.MANDT == T005.MANDT` `C_ARUNANLYTSSUPDMNDOVWQRY.SOLDTOPARTYCOUNTRY == T005.LAND1` `C_ARUNANLYTSSUPDMNDOVWQRY.PLANTCOUNTRY == T005.LAND1` `C_ARUNANLYTSSUPDMNDOVWQRY.SHIPTOCOUNTRY == T005.LAND1`
Country/Region Key Client Country/Region Key Country/Region Key Country/Region Key	`C_ARUNANLYTSSUPDMNDOVWQRY.MANDT == T005.MANDT` `C_ARUNANLYTSSUPDMNDOVWQRY.SOLDTOPARTYCOUNTRY == T005.LAND1` `C_ARUNANLYTSSUPDMNDOVWQRY.PLANTCOUNTRY == T005.LAND1` `C_ARUNANLYTSSUPDMNDOVWQRY.SHIPTOCOUNTRY == T005.LAND1`
Region (State, Province, County) Client Country/Region Key Country/Region Key Country/Region Key Region (State, Province, County) Region (State, Province, County)	`C_ARUNANLYTSSUPDMNDOVWQRY.MANDT == T005S.MANDT` `C_ARUNANLYTSSUPDMNDOVWQRY.SOLDTOPARTYCOUNTRY == T005S.LAND1` `C_ARUNANLYTSSUPDMNDOVWQRY.PLANTCOUNTRY == T005S.LAND1` `C_ARUNANLYTSSUPDMNDOVWQRY.SHIPTOCOUNTRY == T005S.LAND1` `C_ARUNANLYTSSUPDMNDOVWQRY.SOLDTOPARTYREGION == T005S.BLAND` `C_ARUNANLYTSSUPDMNDOVWQRY.CUSTOMERREGION == T005S.BLAND`

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