C_SupDmndAllDocSupAmtCubeQry

Query View Amount demand in Display Curr | view: CSUPDALLDOCSQRY | Extraction: Not supported | Component: Order Allocation Run
Column Name Description
Material FK Material Number
Plant FK Plant
SupplyNumber null
SupplyItem null
SupplyScheduleLine null
AssignedSupplyType null
ProductAvailabilityDate Purchasing Document Date
Column Name Description
💲 Display Currency (DisplayCurrency):
TotActualAmtInDisplayCurrency Net Value in Display Currency
Column Name Description
TotalQuantity null
OpenSupplyQuantity null
Column Name Description
ProductAvailabilityDate Purchasing Document Date
RequestedDeliveryDate Purchasing Document Date
Column Name Description
Column Name Description Domain name
Batch Batch Number CHARG
StorageLocation Storage location LGORT
SupAssgmtSource null
MaterialType Material type MTART
StockSegment Stock Segment SGT_SRCA
CrossPlantConfigurableProduct Cross-Plant Configurable Material MATNR
SalesOrganization Sales Organization VKORG
DistributionChannel Distribution Channel VTWEG
Division Division SPART
SalesDistrict Sales District BZIRK
SalesOrder Sales and Distribution Document Number VBELN
SalesOrderItem Item number of the SD document POSNR
Master Data Relations Join Conditions
Purchase Order Unit of Measure
  • Client
  • Purchase Order Unit of Measure
  • C_SUPDMNDALLDOCSUPAMTCUBEQRY.MANDT == T006.MANDT
  • C_SUPDMNDALLDOCSUPAMTCUBEQRY.BASEUNIT == T006.MSEHI
Company Code
  • Client
  • Company Code
  • C_SUPDMNDALLDOCSUPAMTCUBEQRY.MANDT == T001.MANDT
  • C_SUPDMNDALLDOCSUPAMTCUBEQRY.COMPANYCODE == T001.BUKRS
Customer
  • Customer
  • Client
  • C_SUPDMNDALLDOCSUPAMTCUBEQRY.CUSTOMER == KNA1.KUNNR
  • C_SUPDMNDALLDOCSUPAMTCUBEQRY.MANDT == KNA1.MANDT
Material Number
  • Client
  • Material Number
  • C_SUPDMNDALLDOCSUPAMTCUBEQRY.MANDT == MARA.MANDT
  • C_SUPDMNDALLDOCSUPAMTCUBEQRY.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • C_SUPDMNDALLDOCSUPAMTCUBEQRY.MANDT == T023.MANDT
  • C_SUPDMNDALLDOCSUPAMTCUBEQRY.MATERIALGROUP == T023.MATKL
Plant
  • Client
  • Plant
  • C_SUPDMNDALLDOCSUPAMTCUBEQRY.MANDT == T001W.MANDT
  • C_SUPDMNDALLDOCSUPAMTCUBEQRY.PLANT == T001W.WERKS
Purchasing Group
  • Client
  • Purchasing Group
  • C_SUPDMNDALLDOCSUPAMTCUBEQRY.MANDT == T024.MANDT
  • C_SUPDMNDALLDOCSUPAMTCUBEQRY.PURCHASINGGROUP == T024.EKGRP
Purchasing organization
  • Purchasing organization
  • Client
  • C_SUPDMNDALLDOCSUPAMTCUBEQRY.PURCHASINGORGANIZATION == T024E.EKORG
  • C_SUPDMNDALLDOCSUPAMTCUBEQRY.MANDT == T024E.MANDT