C_SupDmndAllDocProdnOrdCompQ

Query View for Production Order Components | view: CSUPDMNDADCMP3Q | Extraction: Not supported | Component: Order Allocation Run
Column Name Description
RequirementDocumentNumber Number of reservation/dependent requirements
RequirementDocumentItem null
RequestedDate Requirements date for the component
ProductAvailabilityDate Requirements date for the component
RequirementType Requirement type
Column Name Description
Column Name Description
RequestedRqmtQtyInBaseUnit Requirement Quantity
ConfirmedRqmtQtyInBaseUnit Requirement Quantity
OpenDemandQuantity null
AssignedQuantityInBaseUnit null
NormalAssignedQuantityInBsUnt null
Column Name Description
RequestedDate Requirements date for the component
ProductAvailabilityDate Requirements date for the component
RequestedDeliveryDate Requirements date for the component
Column Name Description
Column Name Description Domain name
ARunDocumentItemUniqueID Unique Identification for Supply Assignment Document Item CHAR17
DocumentItemConcatenatedID Unique Identification for Supply Assignment Document Item CHAR17
DeliveredQuantityInBaseUnit null
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
Master Data Relations Join Conditions
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • C_SUPDMNDALLDOCPRODNORDCOMPQ.MANDT == T006.MANDT
  • C_SUPDMNDALLDOCPRODNORDCOMPQ.BASEUNIT == T006.MSEHI
Company code
  • Company Code
  • Client
  • C_SUPDMNDALLDOCPRODNORDCOMPQ.COMPANYCODE == T001.BUKRS
  • C_SUPDMNDALLDOCPRODNORDCOMPQ.MANDT == T001.MANDT
Cross-Plant Configurable Material
  • Client
  • Cross-Plant Configurable Material
  • C_SUPDMNDALLDOCPRODNORDCOMPQ.MANDT == MARA.MANDT
  • C_SUPDMNDALLDOCPRODNORDCOMPQ.CROSSPLANTCONFIGURABLEPRODUCT == MARA.MATNR
Customer Number of Plant
  • Customer Number of Plant
  • Client
  • C_SUPDMNDALLDOCPRODNORDCOMPQ.CUSTOMER == KNA1.KUNNR
  • C_SUPDMNDALLDOCPRODNORDCOMPQ.MANDT == KNA1.MANDT
Distribution channel for intercompany billing
  • Distribution channel for intercompany billing
  • Client
  • C_SUPDMNDALLDOCPRODNORDCOMPQ.DISTRIBUTIONCHANNEL == TVTW.VTWEG
  • C_SUPDMNDALLDOCPRODNORDCOMPQ.MANDT == TVTW.MANDT
Division for intercompany billing
  • Division for intercompany billing
  • Client
  • C_SUPDMNDALLDOCPRODNORDCOMPQ.DIVISION == TSPA.SPART
  • C_SUPDMNDALLDOCPRODNORDCOMPQ.MANDT == TSPA.MANDT
Material Number
  • Material Number
  • Client
  • C_SUPDMNDALLDOCPRODNORDCOMPQ.MATERIAL == MARA.MATNR
  • C_SUPDMNDALLDOCPRODNORDCOMPQ.MANDT == MARA.MANDT
Material Group
  • Material Group
  • Client
  • C_SUPDMNDALLDOCPRODNORDCOMPQ.MATERIALGROUP == T023.MATKL
  • C_SUPDMNDALLDOCPRODNORDCOMPQ.MANDT == T023.MANDT
Material type
  • Material type
  • Client
  • C_SUPDMNDALLDOCPRODNORDCOMPQ.MATERIALTYPE == T134.MTART
  • C_SUPDMNDALLDOCPRODNORDCOMPQ.MANDT == T134.MANDT
Plant
  • Plant
  • Client
  • C_SUPDMNDALLDOCPRODNORDCOMPQ.PLANT == T001W.WERKS
  • C_SUPDMNDALLDOCPRODNORDCOMPQ.MANDT == T001W.MANDT
Sales District
  • Sales District
  • Client
  • C_SUPDMNDALLDOCPRODNORDCOMPQ.SALESDISTRICT == T171.BZIRK
  • C_SUPDMNDALLDOCPRODNORDCOMPQ.MANDT == T171.MANDT
Sales Organization for Intercompany Billing
  • Client
  • Sales Organization for Intercompany Billing
  • C_SUPDMNDALLDOCPRODNORDCOMPQ.MANDT == TVKO.MANDT
  • C_SUPDMNDALLDOCPRODNORDCOMPQ.SALESORGANIZATION == TVKO.VKORG
Storage location
  • Plant
  • Storage location
  • Client
  • C_SUPDMNDALLDOCPRODNORDCOMPQ.PLANT == T001L.WERKS
  • C_SUPDMNDALLDOCPRODNORDCOMPQ.STORAGELOCATION == T001L.LGORT
  • C_SUPDMNDALLDOCPRODNORDCOMPQ.MANDT == T001L.MANDT