C_SlsOrdFlfmtMfgOrderQ

SOFM Manufacturing Order Query | view: CSOFMFGORDQ | Extraction: Not supported | Component: Sales Analytics
Tables used: VBAPAFKOAFKOAFPOVBAKVBAPVBKDVEDAAUFKMARAMAKTT003OT003PT001WT024F
Column Name Description
ManufacturingOrder Manufacturing Order ID
Column Name Description
💲 SD Document Currency (SalesOrderTransactionCurrency):
SalesOrderItemNetAmount Net Value of the Order Item in Document Currency
Column Name Description
📏 Production Unit of Measure (ProductionUnit):
MfgOrderPlannedTotalQty Manufacturing Order Planned Total Quantity
📏 Sales unit (OrderQuantityUnit):
SalesOrderItemQuantity Cumulative order quantity in sales units
Column Name Description
MfgOrderScheduledStartDate Manufacturing Order Scheduled Start Date
MfgOrderScheduledEndDate Manufacturing Order Scheduled End Date
MfgOrderScheduledReleaseDate Manufacturing Order Scheduled Release Date
MfgOrderActualStartDate Manufacturing Order Actual Start Date
MfgOrderActualEndDate Manufacturing Order Actual End Date
MfgOrderActualReleaseDate Manufacturing Order Actual Release Date
MfgOrderConfirmedEndDate Manufacturing Order Confirmed End Date
Column Name Description
ManufacturingOrderCategory Manufacturing Order Category Show values
Column Name Description Domain name
ManufacturingOrderTypeName Manufacturing Order Type Name TEXT40
MaterialName Material Description TEXT40
ProductionPlantName Plant Name TEXT30
ProductionSupervisorName Production Supervisor Name TEXT30
Master Data Relations Join Conditions
Manufacturing Order Type
  • Client
  • Manufacturing Order Type
  • C_SLSORDFLFMTMFGORDERQ.MANDT == T003O.CLIENT
  • C_SLSORDFLFMTMFGORDERQ.MANUFACTURINGORDERTYPE == T003O.AUART
Material Number for Order
  • Client
  • Material Number for Order
  • C_SLSORDFLFMTMFGORDERQ.MANDT == MARA.MANDT
  • C_SLSORDFLFMTMFGORDERQ.MATERIAL == MARA.MATNR
Sales unit
  • Client
  • Sales unit
  • C_SLSORDFLFMTMFGORDERQ.MANDT == T006.MANDT
  • C_SLSORDFLFMTMFGORDERQ.ORDERQUANTITYUNIT == T006.MSEHI
Production Plant
  • Client
  • Production Plant
  • C_SLSORDFLFMTMFGORDERQ.MANDT == T001W.MANDT
  • C_SLSORDFLFMTMFGORDERQ.PRODUCTIONPLANT == T001W.WERKS
Production Supervisor
  • Production Supervisor
  • Client
  • Production Plant
  • C_SLSORDFLFMTMFGORDERQ.PRODUCTIONSUPERVISOR == T024F.FEVOR
  • C_SLSORDFLFMTMFGORDERQ.MANDT == T024F.MANDT
  • C_SLSORDFLFMTMFGORDERQ.PRODUCTIONPLANT == T024F.WERKS
Production Unit of Measure
  • Client
  • Production Unit of Measure
  • C_SLSORDFLFMTMFGORDERQ.MANDT == T006.MANDT
  • C_SLSORDFLFMTMFGORDERQ.PRODUCTIONUNIT == T006.MSEHI
SD Document Currency
  • Client
  • SD Document Currency
  • C_SLSORDFLFMTMFGORDERQ.MANDT == TCURC.MANDT
  • C_SLSORDFLFMTMFGORDERQ.SALESORDERTRANSACTIONCURRENCY == TCURC.WAERS