C_SupDmndAllDocDmndAmtCubeQry

Query View Amount demand in Display Curr | view: CSUPDALLDOCDQRY | Extraction: Not supported | Component: Order Allocation Run

Tables used: VBAP, EKKO, EKPO, EKPV, EKET, VBKD, VEDA, VBAK, VBAK, VBAP, VBKD, VEDA, VBEP, LIKP, LIPS, EKKO, EKPO, EBAN, EBKN, EKET, EKKO, EKPO, EKET, VBPA, VBPA, EKPO, MATDOC, EKET, EKKO, EKPO, CVI_CUST_CT_LINK, BUT000, KNA1, CVI_CUST_LINK, TVAK, KNA1, VBBE, TVEP, MARA, MARC, KNVV, CVI_VEND_LINK

🔑 Keys (5)
💰 Amounts (1)
∑ Quantities (1)
📅 Dates (3)
☰ Categorical
Other (2)
🔗 Relations (12)

Column Name	Description
RequirementDocumentNumber	Sales Document
RequirementDocumentItem	Sales Document Item
RequestedDate	Material Staging/Availability Date
ProductAvailabilityDate	Material Staging/Availability Date
RequirementType	null

Column Name	Description
💲 Display Currency (DisplayCurrency):
TotActualAmtInDisplayCurrency	Net Value in Display Currency

Column Name	Description
OpenDemandQuantity	null

Column Name	Description
RequestedDate	Material Staging/Availability Date
ProductAvailabilityDate	Material Staging/Availability Date
RequestedDeliveryDate	null

Column Name	Description

Column Name	Description	Domain name
RequirementSegment	Requirement Segment	SGT_SRCA
Customer	null

Master Data Relations	Join Conditions
Base Unit of Measure Client Base Unit of Measure	`C_SUPDMNDALLDOCDMNDAMTCUBEQRY.MANDT == T006.MANDT` `C_SUPDMNDALLDOCDMNDAMTCUBEQRY.BASEUNIT == T006.MSEHI`
Company Code to Be Billed Company Code to Be Billed Client	`C_SUPDMNDALLDOCDMNDAMTCUBEQRY.COMPANYCODE == T001.BUKRS` `C_SUPDMNDALLDOCDMNDAMTCUBEQRY.MANDT == T001.MANDT`
Cross-Plant Configurable Material Client Cross-Plant Configurable Material	`C_SUPDMNDALLDOCDMNDAMTCUBEQRY.MANDT == MARA.MANDT` `C_SUPDMNDALLDOCDMNDAMTCUBEQRY.CROSSPLANTCONFIGURABLEPRODUCT == MARA.MATNR`
Distribution channel in order header Client Sales Organization Distribution Channel	`C_SUPDMNDALLDOCDMNDAMTCUBEQRY.MANDT == TVKOV.MANDT` `C_SUPDMNDALLDOCDMNDAMTCUBEQRY.SALESORGANIZATION == TVKOV.VKORG` `C_SUPDMNDALLDOCDMNDAMTCUBEQRY.DISTRIBUTIONCHANNEL == TVKOV.VTWEG`
Division in order header Client Sales Organization Division Distribution Channel	`C_SUPDMNDALLDOCDMNDAMTCUBEQRY.MANDT == TVTA.MANDT` `C_SUPDMNDALLDOCDMNDAMTCUBEQRY.SALESORGANIZATION == TVTA.VKORG` `C_SUPDMNDALLDOCDMNDAMTCUBEQRY.DIVISION == TVTA.SPART` `C_SUPDMNDALLDOCDMNDAMTCUBEQRY.DISTRIBUTIONCHANNEL == TVTA.VTWEG`
Material Number Client Material Number	`C_SUPDMNDALLDOCDMNDAMTCUBEQRY.MANDT == MARA.MANDT` `C_SUPDMNDALLDOCDMNDAMTCUBEQRY.MATERIAL == MARA.MATNR`
Material Group Client Material Group	`C_SUPDMNDALLDOCDMNDAMTCUBEQRY.MANDT == T023.MANDT` `C_SUPDMNDALLDOCDMNDAMTCUBEQRY.MATERIALGROUP == T023.MATKL`
Material type Client Material type	`C_SUPDMNDALLDOCDMNDAMTCUBEQRY.MANDT == T134.MANDT` `C_SUPDMNDALLDOCDMNDAMTCUBEQRY.MATERIALTYPE == T134.MTART`
Plant Client Plant	`C_SUPDMNDALLDOCDMNDAMTCUBEQRY.MANDT == T001W.MANDT` `C_SUPDMNDALLDOCDMNDAMTCUBEQRY.PLANT == T001W.WERKS`
Sales District Client Sales District	`C_SUPDMNDALLDOCDMNDAMTCUBEQRY.MANDT == T171.MANDT` `C_SUPDMNDALLDOCDMNDAMTCUBEQRY.SALESDISTRICT == T171.BZIRK`
Sales organization in order header Client Sales Organization	`C_SUPDMNDALLDOCDMNDAMTCUBEQRY.MANDT == TVKO.MANDT` `C_SUPDMNDALLDOCDMNDAMTCUBEQRY.SALESORGANIZATION == TVKO.VKORG`
Storage location Client Plant Storage location	`C_SUPDMNDALLDOCDMNDAMTCUBEQRY.MANDT == T001L.MANDT` `C_SUPDMNDALLDOCDMNDAMTCUBEQRY.PLANT == T001L.WERKS` `C_SUPDMNDALLDOCDMNDAMTCUBEQRY.STORAGELOCATION == T001L.LGORT`