I_MfgOrderWithStatus

Manufacturing Order Header with Status | view: IMFGORDERWSTTS | Extraction: Not supported | Component: Virtual Data Model in PP
Tables used: AFKO, AFPO, JEST, AUFK
Column Name Description
ManufacturingOrder Manufacturing Order ID
Column Name Description
Column Name Description
📏 Production Unit of Measure (ProductionUnit):
MfgOrderPlannedTotalQty Manufacturing Order Planned Total Quantity
MfgOrderPlannedScrapQty Manufacturing Order Planned Scrap Quantity
MfgOrderConfirmedYieldQty Confirmed Yield Quantity From Order Confirmation
MfgOrderConfirmedScrapQty Confirmed Scrap Quantity From Order Confirmation
MfgOrderConfirmedReworkQty Total Confirmed Rework Quantity
ExpectedDeviationQuantity Expected Yield Deviation
ActualDeliveredQuantity Quantity of Goods Received for the Order Item
Column Name Description
CreationDate Order Creation Date
CreationTime Order Creation Time
LastChangeDate Change Date for Order Master
LastChangeTime Changed At
BOOExplosionDate Date for Routing Explosion
BOOValidityStartDate Valid-From Date
BOMExplosionDate Date of BOM Explosion/Routing Transfer
BOMValidityStartDate Valid-From Date
MfgOrderPlannedStartDate Manufacturing Order Planned Start Date
MfgOrderPlannedStartTime Manufacturing Order Planned Start Time
MfgOrderPlannedEndDate Manufacturing Order Planned End Date
MfgOrderPlannedEndTime Manufacturing Order Planned End Time
MfgOrderPlannedReleaseDate Manufacturing Order Planned Release Date
MfgOrderScheduledStartDate Manufacturing Order Scheduled Start Date
MfgOrderScheduledStartTime Manufacturing Order Scheduled Start Time
MfgOrderScheduledEndDate Manufacturing Order Scheduled End Date
MfgOrderScheduledEndTime Manufacturing Order Scheduled End Time
MfgOrderScheduledReleaseDate Manufacturing Order Scheduled Release Date
MfgOrderActualStartDate Manufacturing Order Actual Start Date
MfgOrderActualStartTime Manufacturing Order Actual Start Time
MfgOrderActualEndDate Manufacturing Order Actual End Date
MfgOrderActualReleaseDate Manufacturing Order Actual Release Date
MfgOrderConfirmedEndDate Manufacturing Order Confirmed End Date
MfgOrderConfirmedEndTime Manufacturing Order Confirmed End Time
MfgOrderTotalCommitmentDate Total Commitment Date
MfgOrderActualCompletionDate Technical Completion Date
MfgOrderItemActualDeliveryDate Actual Delivery/Finish Date
Column Name Description
ManufacturingOrderCategory Order Category Show values
ManufacturingOrderHasLongText Long Text Exists Show values
MfgOrderHasMultipleItems Order Has Multiple Items Show values
MfgOrderIsPartOfCollvOrder Order is Part of Collective Order Show values
ProdnProcgIsFlexible Flexible Processing Show values
OrderIsEventBasedPosting Event-Based Posting Show values
InventoryUsabilityCode Inventory Usability Code Show values
CapacityRqmtHasNotToBeCreated Indicator: Do not Create Capacity Requirements Show values
BillOfMaterialCategory Bill of Material Category Code Show values
ControllingObjectClass Controlling Object Class Show values
Column Name Description Domain name
ManufacturingOrderText Manufacturing Order Text TEXT40
LongTextLanguageCode Long Text Language SPRAS
ManufacturingOrderImportance Order Importance Code CHAR1
MfgOrderHierarchyLevel Level (in multi-level BOM explosions) DEC2
OrderIsCreated null
OrderIsReleased null
OrderIsPrinted null
OrderIsConfirmed null
OrderIsPartiallyConfirmed null
OrderIsDelivered null
OrderIsDeleted null
OrderIsPreCosted null
SettlementRuleIsCreated null
OrderIsPartiallyReleased null
OrderIsLocked null
OrderIsTechnicallyCompleted null
OrderIsClosed null
OrderIsPartiallyDelivered null
OrderIsMarkedForDeletion null
SettlementRuleIsCrtedManually null
OrderIsScheduled null
OrderHasGeneratedOperations null
OrderIsToBeHandledInBatches null
MaterialAvailyIsNotChecked null
OrderIsShopFloorOrder null
CreatedByUser Entered By USNAM
LastChangedByUser Last Changed By USNAM
GoodsRecipientName Goods Recipient WEMPF
UnloadingPointName Unloading Point TEXT25
MaterialGoodsReceiptDuration Goods Receipt Processing Duration in Days DEC3
StockSegment Stock Segment SGT_SRCA
MfgOrderInternalID Order Internal ID AUFPL
SuperiorOrder Number of Superior Order AUFNR
MRPArea MRP Area BERID
ProductionVersion Production Version VERID
PlannedOrder Planned Order PLNUM
Reservation Number of reservation/dependent requirements RSNUM
SettlementReservation Settlement Reservation RSNUM
MfgOrderConfirmation Completion confirmation number for the operation CO_RUECK
NumberOfMfgOrderConfirmations Number Of Confirmations CIM_COUNT
CapacityRequirement ID of the Capacity Requirements Record BEDID
InspectionLot Inspection Lot Number QPLOS
MaterialRevisionLevel Revision Level REVLV
MaterialRevisionLevel_2 Revision Level VDM_QM_REVLV
ForecastSchedulingType Forecast Scheduling Type TERART
ProductConfiguration Product Configuration CUOBJ
EffectivityParameterVariant Parameter Variant/Standard Variant TECHS
CapacityActiveVersion Version of Available Capacity KAPVERSION
OrderSequenceNumber Sequence Number Order CY_SEQNR
BillOfOperationsType Bill of Operations Type PLNTY
BillOfOperations Bill of Operations ID PLNNR
BillOfOperationsGroup Bill of Operations Group PLNNR
BillOfOperationsVariant Bill of Operations Variant ALTNR
BOOInternalVersionCounter Internal counter CIM_COUNT
BillOfOperationsVersion Routing Version PLNVERSN
BillOfMaterial Bill of Material STNUM
BillOfMaterialInternalID Bill Of Material PPH_STNUM
BillOfMaterialVariant Alternative BOM ALTNR
BillOfMaterialVersion BOM Version CS_VERSN
ProductCostCollector Cost Collector for Production Process AUFNR
ActualCostsCostingVariant Costing Variant For Actual Costs KLVAR
PlannedCostsCostingVariant Costing Variant for Planned Costs KLVAR
Master Data Relations Join Conditions
Basic Scheduling Type
  • Basic Scheduling Type
  • Client
  • I_MFGORDERWITHSTATUS.BASICSCHEDULINGTYPE == T482.TERMKZ
  • I_MFGORDERWITHSTATUS.MANDT == T482.MANDT
Batch Number
  • ?
  • Client
  • Material Number for Order
  • Product Number
  • Batch Number
  • I_MFGORDERWITHSTATUS.[column in domain "WERKS_D"] == MCHA.WERKS
  • I_MFGORDERWITHSTATUS.MANDT == MCHA.MANDT
  • I_MFGORDERWITHSTATUS.MATERIAL == MCHA.MATNR
  • I_MFGORDERWITHSTATUS.PRODUCT == MCHA.MATNR
  • I_MFGORDERWITHSTATUS.BATCH == MCHA.CHARG
BOM Usage
  • BOM Usage
  • Client
  • I_MFGORDERWITHSTATUS.BILLOFMATERIALVARIANTUSAGE == T416.STLAN
  • I_MFGORDERWITHSTATUS.MANDT == T416.MANDT
Bill of Operations Material
  • Bill of Operations Material
  • Client
  • I_MFGORDERWITHSTATUS.BILLOFOPERATIONSMATERIAL == MARA.MATNR
  • I_MFGORDERWITHSTATUS.MANDT == MARA.MANDT
Task List Usage
  • Client
  • Bill of Operations Usage
  • I_MFGORDERWITHSTATUS.MANDT == T411.MANDT
  • I_MFGORDERWITHSTATUS.BILLOFOPERATIONSUSAGE == T411.VERWE
Business Area
  • Client
  • Business Area
  • I_MFGORDERWITHSTATUS.MANDT == TGSB.MANDT
  • I_MFGORDERWITHSTATUS.BUSINESSAREA == TGSB.GSBER
Change Number
  • Client
  • Change Number
  • I_MFGORDERWITHSTATUS.MANDT == AENR.MANDT
  • I_MFGORDERWITHSTATUS.CHANGENUMBER == AENR.AENNR
Company Code
  • Company Code
  • Client
  • I_MFGORDERWITHSTATUS.COMPANYCODE == T001.BUKRS
  • I_MFGORDERWITHSTATUS.MANDT == T001.MANDT
Application I_MFGORDERWITHSTATUS.CONDITIONAPPLICATION == T681A.KAPPL
Controlling Area
  • Controlling Area
  • Client
  • I_MFGORDERWITHSTATUS.CONTROLLINGAREA == TKA01.KOKRS
  • I_MFGORDERWITHSTATUS.MANDT == TKA01.MANDT
Cost Center for Basic Settlement
  • Controlling Area
  • Cost Center for Basic Settlement
  • Client
  • ?
  • I_MFGORDERWITHSTATUS.CONTROLLINGAREA == CSKS.KOKRS
  • I_MFGORDERWITHSTATUS.COSTCENTER == CSKS.KOSTL
  • I_MFGORDERWITHSTATUS.MANDT == CSKS.MANDT
  • I_MFGORDERWITHSTATUS.[column in domain "DATBI"] == CSKS.DATBI
Settlement Cost Element
  • Controlling Area
  • Settlement Cost Element
  • Client
  • ?
  • I_MFGORDERWITHSTATUS.CONTROLLINGAREA == CSKB.KOKRS
  • I_MFGORDERWITHSTATUS.COSTELEMENT == CSKB.KSTAR
  • I_MFGORDERWITHSTATUS.MANDT == CSKB.MANDT
  • I_MFGORDERWITHSTATUS.[column in domain "DATBI"] == CSKB.DATBI
Costing Sheet
  • ?
  • Client
  • Costing Sheet
  • Application
  • I_MFGORDERWITHSTATUS.[column in domain "KVEWE"] == T683.KVEWE
  • I_MFGORDERWITHSTATUS.MANDT == T683.MANDT
  • I_MFGORDERWITHSTATUS.COSTINGSHEET == T683.KALSM
  • I_MFGORDERWITHSTATUS.CONDITIONAPPLICATION == T683.KAPPL
Order Currency
  • Client
  • Order Currency
  • I_MFGORDERWITHSTATUS.MANDT == TCURC.MANDT
  • I_MFGORDERWITHSTATUS.CURRENCY == TCURC.WAERS
Functional Area
  • Functional Area
  • Client
  • I_MFGORDERWITHSTATUS.FUNCTIONALAREA == TFKB.FKBER
  • I_MFGORDERWITHSTATUS.MANDT == TFKB.MANDT
G/L Account for Basic Settlement
  • G/L Account for Basic Settlement
  • Company Code
  • Client
  • I_MFGORDERWITHSTATUS.GLACCOUNT == SKB1.SAKNR
  • I_MFGORDERWITHSTATUS.COMPANYCODE == SKB1.BUKRS
  • I_MFGORDERWITHSTATUS.MANDT == SKB1.MANDT
Leading Order in Current Processing
  • Leading Order in Current Processing
  • Client
  • I_MFGORDERWITHSTATUS.LEADINGORDER == AUFK.AUFNR
  • I_MFGORDERWITHSTATUS.MANDT == AUFK.MANDT
Order Type
  • Client
  • Order Type
  • I_MFGORDERWITHSTATUS.MANDT == T003O.CLIENT
  • I_MFGORDERWITHSTATUS.MANUFACTURINGORDERTYPE == T003O.AUART
Material Number for Order
  • Client
  • Material Number for Order
  • Product Number
  • I_MFGORDERWITHSTATUS.MANDT == MARA.MANDT
  • I_MFGORDERWITHSTATUS.MATERIAL == MARA.MATNR
  • I_MFGORDERWITHSTATUS.PRODUCT == MARA.MATNR
MRP Controller Group
  • Client
  • Production Plant
  • MRP Controller
  • I_MFGORDERWITHSTATUS.MANDT == T024D.MANDT
  • I_MFGORDERWITHSTATUS.PRODUCTIONPLANT == T024D.WERKS
  • I_MFGORDERWITHSTATUS.MRPCONTROLLER == T024D.DISPO
Planning Plant for an Order
  • Client
  • Planning Plant for an Order
  • I_MFGORDERWITHSTATUS.MANDT == T001W.MANDT
  • I_MFGORDERWITHSTATUS.PLANNINGPLANT == T001W.WERKS
Product Number
  • Client
  • Material Number for Order
  • Product Number
  • I_MFGORDERWITHSTATUS.MANDT == MARA.MANDT
  • I_MFGORDERWITHSTATUS.MATERIAL == MARA.MATNR
  • I_MFGORDERWITHSTATUS.PRODUCT == MARA.MATNR
Production Plant
  • Client
  • Production Plant
  • I_MFGORDERWITHSTATUS.MANDT == T001W.MANDT
  • I_MFGORDERWITHSTATUS.PRODUCTIONPLANT == T001W.WERKS
Production Scheduling Profile
  • Client
  • Production Plant
  • Production Scheduling Profile
  • I_MFGORDERWITHSTATUS.MANDT == TCO43.MANDT
  • I_MFGORDERWITHSTATUS.PRODUCTIONPLANT == TCO43.WERKS
  • I_MFGORDERWITHSTATUS.PRODUCTIONSCHEDULINGPROFILE == TCO43.CO_PRODPRF
Production Supervisor
  • Production Supervisor
  • Client
  • Production Plant
  • I_MFGORDERWITHSTATUS.PRODUCTIONSUPERVISOR == T024F.FEVOR
  • I_MFGORDERWITHSTATUS.MANDT == T024F.MANDT
  • I_MFGORDERWITHSTATUS.PRODUCTIONPLANT == T024F.WERKS
Production Unit of Measure
  • Production Unit of Measure
  • Client
  • I_MFGORDERWITHSTATUS.PRODUCTIONUNIT == T006.MSEHI
  • I_MFGORDERWITHSTATUS.MANDT == T006.MANDT
Profit Center
  • Controlling Area
  • Client
  • ?
  • Profit Center
  • I_MFGORDERWITHSTATUS.CONTROLLINGAREA == CEPC.KOKRS
  • I_MFGORDERWITHSTATUS.MANDT == CEPC.MANDT
  • I_MFGORDERWITHSTATUS.[column in domain "DATBI"] == CEPC.DATBI
  • I_MFGORDERWITHSTATUS.PROFITCENTER == CEPC.PRCTR
MRP Distribution Key
  • ?
  • Client
  • MRP Distribution Key
  • I_MFGORDERWITHSTATUS.[column in domain "WERKS_D"] == T437V.WERKS
  • I_MFGORDERWITHSTATUS.MANDT == T437V.MANDT
  • I_MFGORDERWITHSTATUS.QUANTITYDISTRIBUTIONKEY == T437V.VERTL
Reference Order Number
  • Reference Order Number
  • Client
  • I_MFGORDERWITHSTATUS.REFERENCEORDER == AUFK.AUFNR
  • I_MFGORDERWITHSTATUS.MANDT == AUFK.MANDT
Responsible Cost Center
  • Controlling Area
  • Responsible Cost Center
  • Client
  • ?
  • I_MFGORDERWITHSTATUS.CONTROLLINGAREA == CSKS.KOKRS
  • I_MFGORDERWITHSTATUS.RESPONSIBLECOSTCENTER == CSKS.KOSTL
  • I_MFGORDERWITHSTATUS.MANDT == CSKS.MANDT
  • I_MFGORDERWITHSTATUS.[column in domain "DATBI"] == CSKS.DATBI
Storage Location
  • Client
  • Storage Location
  • Planning Plant for an Order
  • I_MFGORDERWITHSTATUS.MANDT == T001L.MANDT
  • I_MFGORDERWITHSTATUS.STORAGELOCATION == T001L.LGORT
  • I_MFGORDERWITHSTATUS.PLANNINGPLANT == T001L.WERKS
Other Relations | to Master Data Relations ↑ Join Conditions
Responsible Planner Group or Department
  • Responsible Planner Group or Department
  • Client
  • Production Plant
  • I_MFGORDERWITHSTATUS.RESPONSIBLEPLANNERGROUP == T024A.FEVOR
  • I_MFGORDERWITHSTATUS.MANDT == T024A.MANDT
  • I_MFGORDERWITHSTATUS.PRODUCTIONPLANT == T024A.WERKS