C_SupDmndAllDocTotDmndQry

Query View for Total Demand of All Document Types | view: CSUPDMNDADDMNDQ | Extraction: Not supported | Component: Order Allocation Run
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
Column Name Description
RequestedRqmtQtyInBaseUnit null
ConfirmedRqmtQtyInBaseUnit null
DeliveredQuantityInBaseUnit null
OpenDemandQuantity null
AssignedQuantityInBaseUnit null
NormalAssignedQuantityInBsUnt null
Column Name Description
RequestedDate Material Staging/Availability Date
ProductAvailabilityDate Material Staging/Availability Date
RequestedDeliveryDate null
Column Name Description
Column Name Description Domain name
ARunDocumentItemUniqueID Unique Identification for Supply Assignment Document Item
DocumentItemConcatenatedID Unique Identification for Supply Assignment Document Item CHAR17
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
SalesOrganization Sales Organization VKORG
DistributionChannel Distribution Channel VTWEG
Division Division SPART
SalesDistrict Sales District BZIRK
Customer null
CompanyCode Company Code to Be Billed BUKRS
SupplyProtectionName Name DDTEXT
RequirementSegment Requirement Segment SGT_SRCA
Master Data Relations Join Conditions
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • C_SUPDMNDALLDOCTOTDMNDQRY.BASEUNIT == T006.MSEHI
  • C_SUPDMNDALLDOCTOTDMNDQRY.MANDT == T006.MANDT
Cross-Plant Configurable Material
  • Cross-Plant Configurable Material
  • Client
  • C_SUPDMNDALLDOCTOTDMNDQRY.CROSSPLANTCONFIGURABLEPRODUCT == MARA.MATNR
  • C_SUPDMNDALLDOCTOTDMNDQRY.MANDT == MARA.MANDT
SD Document Currency
  • Client
  • SD Document Currency
  • C_SUPDMNDALLDOCTOTDMNDQRY.MANDT == TCURC.MANDT
  • C_SUPDMNDALLDOCTOTDMNDQRY.DOCUMENTCURRENCY == TCURC.WAERS
Material Number
  • Material Number
  • Client
  • C_SUPDMNDALLDOCTOTDMNDQRY.MATERIAL == MARA.MATNR
  • C_SUPDMNDALLDOCTOTDMNDQRY.MANDT == MARA.MANDT
Material Group
  • Client
  • Material Group
  • C_SUPDMNDALLDOCTOTDMNDQRY.MANDT == T023.MANDT
  • C_SUPDMNDALLDOCTOTDMNDQRY.MATERIALGROUP == T023.MATKL
Material type
  • Material type
  • Client
  • C_SUPDMNDALLDOCTOTDMNDQRY.MATERIALTYPE == T134.MTART
  • C_SUPDMNDALLDOCTOTDMNDQRY.MANDT == T134.MANDT
Plant
  • Client
  • Plant
  • C_SUPDMNDALLDOCTOTDMNDQRY.MANDT == T001W.MANDT
  • C_SUPDMNDALLDOCTOTDMNDQRY.PLANT == T001W.WERKS
Storage location
  • Storage location
  • Client
  • Plant
  • C_SUPDMNDALLDOCTOTDMNDQRY.STORAGELOCATION == T001L.LGORT
  • C_SUPDMNDALLDOCTOTDMNDQRY.MANDT == T001L.MANDT
  • C_SUPDMNDALLDOCTOTDMNDQRY.PLANT == T001L.WERKS