C_SupDmndAllDocProdnOrdQ

Query View for Production Order Details | view: CSUPDMNDADPRODQ | Extraction: Not supported | Component: Order Allocation Run
Tables used: SCAL_TT_DATE, AFPO, SCAL_TT_WEEK, ARUN_BDBS, ARUN_PREVIEW, ARUN_SDO_ALLDOC, AUFK, MARA, MARC, T001K, T001W
Column Name Description
Material FK Material Number for Order
Plant FK Planning Plant for an Order
Batch Batch Number
StorageLocation Storage location
SupplyNumber FK Order Number
SupplyItem null
SupplyScheduleLine null
ProductAvailabilityDate Basic finish date
AssignedSupplyType null
Column Name Description
Column Name Description
TotalQuantity Order Item Planned Total Quantity
OpenSupplyQuantity null
AssignedQuantityInBaseUnit null
NormalAssignedQuantityInBsUnt null
Column Name Description
ProductAvailabilityDate Basic finish date
RequestedDeliveryDate Basic finish date
Column Name Description
Column Name Description Domain name
SupAssgmtSource 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
PurchasingGroup Purchasing Group EKGRP
Master Data Relations Join Conditions
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • C_SUPDMNDALLDOCPRODNORDQ.BASEUNIT == T006.MSEHI
  • C_SUPDMNDALLDOCPRODNORDQ.MANDT == T006.MANDT
Company code
  • Company Code
  • Client
  • C_SUPDMNDALLDOCPRODNORDQ.COMPANYCODE == T001.BUKRS
  • C_SUPDMNDALLDOCPRODNORDQ.MANDT == T001.MANDT
Cross-Plant Configurable Material
  • Cross-Plant Configurable Material
  • Client
  • C_SUPDMNDALLDOCPRODNORDQ.CROSSPLANTCONFIGURABLEPRODUCT == MARA.MATNR
  • C_SUPDMNDALLDOCPRODNORDQ.MANDT == MARA.MANDT
Customer Number of Plant
  • Customer Number of Plant
  • Client
  • C_SUPDMNDALLDOCPRODNORDQ.CUSTOMER == KNA1.KUNNR
  • C_SUPDMNDALLDOCPRODNORDQ.MANDT == KNA1.MANDT
Distribution channel for intercompany billing
  • Distribution channel for intercompany billing
  • Client
  • C_SUPDMNDALLDOCPRODNORDQ.DISTRIBUTIONCHANNEL == TVTW.VTWEG
  • C_SUPDMNDALLDOCPRODNORDQ.MANDT == TVTW.MANDT
Division for intercompany billing
  • Division for intercompany billing
  • Client
  • C_SUPDMNDALLDOCPRODNORDQ.DIVISION == TSPA.SPART
  • C_SUPDMNDALLDOCPRODNORDQ.MANDT == TSPA.MANDT
Material Number for Order
  • Material Number for Order
  • Client
  • C_SUPDMNDALLDOCPRODNORDQ.MATERIAL == MARA.MATNR
  • C_SUPDMNDALLDOCPRODNORDQ.MANDT == MARA.MANDT
Material Group
  • Material Group
  • Client
  • C_SUPDMNDALLDOCPRODNORDQ.MATERIALGROUP == T023.MATKL
  • C_SUPDMNDALLDOCPRODNORDQ.MANDT == T023.MANDT
Material type
  • Client
  • Material type
  • C_SUPDMNDALLDOCPRODNORDQ.MANDT == T134.MANDT
  • C_SUPDMNDALLDOCPRODNORDQ.MATERIALTYPE == T134.MTART
Planning Plant for an Order
  • Planning Plant for an Order
  • Client
  • C_SUPDMNDALLDOCPRODNORDQ.PLANT == T001W.WERKS
  • C_SUPDMNDALLDOCPRODNORDQ.MANDT == T001W.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • C_SUPDMNDALLDOCPRODNORDQ.PURCHASINGORGANIZATION == T024E.EKORG
  • C_SUPDMNDALLDOCPRODNORDQ.MANDT == T024E.MANDT
Sales District
  • Sales District
  • Client
  • C_SUPDMNDALLDOCPRODNORDQ.SALESDISTRICT == T171.BZIRK
  • C_SUPDMNDALLDOCPRODNORDQ.MANDT == T171.MANDT
Sales Organization for Intercompany Billing
  • Sales Organization for Intercompany Billing
  • Client
  • C_SUPDMNDALLDOCPRODNORDQ.SALESORGANIZATION == TVKO.VKORG
  • C_SUPDMNDALLDOCPRODNORDQ.MANDT == TVKO.MANDT
Order Number
  • Order Number
  • Client
  • C_SUPDMNDALLDOCPRODNORDQ.SUPPLYNUMBER == AUFK.AUFNR
  • C_SUPDMNDALLDOCPRODNORDQ.MANDT == AUFK.MANDT