I_ManufacturingOrder

Manufacturing Order | view: IMFGORDER | ATTR | Extraction: Full or Incremental | Component: Virtual Data Model in PP
Tables used: AFKO, AFPO, 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
IsMarkedForDeletion Deletion Flag Show values
IsCompletelyDelivered "Delivery Completed" Indicator Show values
MfgOrderHasMultipleItems Order Has Multiple Items Show values
MfgOrderIsPartOfCollvOrder Order is Part of Collective Order Show values
OrderIsNotCostedAutomatically Indicator: Do not cost automatically Show values
OrdIsNotSchedldAutomatically Indicator: Do not schedule automatically 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
MfgOrderSplitStatus Status of an Order in a Split Hierarchy Show values
BillOfMaterialCategory Bill of Material Category Code Show values
ControllingObjectClass Controlling Object Class Show values
Column Name Description Domain name
ManufacturingOrderItem Order Item CO_POSNR
ManufacturingOrderText Manufacturing Order Text TEXT40
LongTextLanguageCode Long Text Language SPRAS
ManufacturingOrderImportance Order Importance Code CHAR1
MfgOrderHierarchyLevel Level (in multi-level BOM explosions) DEC2
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
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
PlannedOrder Planned Order PLNUM
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
  • Client
  • Basic Scheduling Type
  • I_MANUFACTURINGORDER.MANDT == T482.MANDT
  • I_MANUFACTURINGORDER.BASICSCHEDULINGTYPE == T482.TERMKZ
Batch Number
  • ?
  • Client
  • Material Number for Order
  • Product Number
  • Batch Number
  • I_MANUFACTURINGORDER.[column in domain "WERKS_D"] == MCHA.WERKS
  • I_MANUFACTURINGORDER.MANDT == MCHA.MANDT
  • I_MANUFACTURINGORDER.MATERIAL == MCHA.MATNR
  • I_MANUFACTURINGORDER.PRODUCT == MCHA.MATNR
  • I_MANUFACTURINGORDER.BATCH == MCHA.CHARG
BOM Usage
  • Client
  • BOM Usage
  • I_MANUFACTURINGORDER.MANDT == T416.MANDT
  • I_MANUFACTURINGORDER.BILLOFMATERIALVARIANTUSAGE == T416.STLAN
Bill of Operations Material
  • Bill of Operations Material
  • Client
  • I_MANUFACTURINGORDER.BILLOFOPERATIONSMATERIAL == MARA.MATNR
  • I_MANUFACTURINGORDER.MANDT == MARA.MANDT
Task List Usage
  • Client
  • Bill of Operations Usage
  • I_MANUFACTURINGORDER.MANDT == T411.MANDT
  • I_MANUFACTURINGORDER.BILLOFOPERATIONSUSAGE == T411.VERWE
Business Area
  • Client
  • Business Area
  • I_MANUFACTURINGORDER.MANDT == TGSB.MANDT
  • I_MANUFACTURINGORDER.BUSINESSAREA == TGSB.GSBER
Change Number
  • Client
  • Change Number
  • I_MANUFACTURINGORDER.MANDT == AENR.MANDT
  • I_MANUFACTURINGORDER.CHANGENUMBER == AENR.AENNR
Company Code
  • Company Code
  • Client
  • I_MANUFACTURINGORDER.COMPANYCODE == T001.BUKRS
  • I_MANUFACTURINGORDER.MANDT == T001.MANDT
Application I_MANUFACTURINGORDER.CONDITIONAPPLICATION == T681A.KAPPL
Controlling Area
  • Controlling Area
  • Client
  • I_MANUFACTURINGORDER.CONTROLLINGAREA == TKA01.KOKRS
  • I_MANUFACTURINGORDER.MANDT == TKA01.MANDT
Cost Center for Basic Settlement
  • Controlling Area
  • ?
  • Client
  • Cost Center for Basic Settlement
  • I_MANUFACTURINGORDER.CONTROLLINGAREA == CSKS.KOKRS
  • I_MANUFACTURINGORDER.[column in domain "DATBI"] == CSKS.DATBI
  • I_MANUFACTURINGORDER.MANDT == CSKS.MANDT
  • I_MANUFACTURINGORDER.COSTCENTER == CSKS.KOSTL
Settlement Cost Element
  • Controlling Area
  • ?
  • Settlement Cost Element
  • Client
  • I_MANUFACTURINGORDER.CONTROLLINGAREA == CSKB.KOKRS
  • I_MANUFACTURINGORDER.[column in domain "DATBI"] == CSKB.DATBI
  • I_MANUFACTURINGORDER.COSTELEMENT == CSKB.KSTAR
  • I_MANUFACTURINGORDER.MANDT == CSKB.MANDT
Costing Sheet
  • Costing Sheet
  • Application
  • Client
  • ?
  • I_MANUFACTURINGORDER.COSTINGSHEET == T683.KALSM
  • I_MANUFACTURINGORDER.CONDITIONAPPLICATION == T683.KAPPL
  • I_MANUFACTURINGORDER.MANDT == T683.MANDT
  • I_MANUFACTURINGORDER.[column in domain "KVEWE"] == T683.KVEWE
Order Currency
  • Client
  • Order Currency
  • I_MANUFACTURINGORDER.MANDT == TCURC.MANDT
  • I_MANUFACTURINGORDER.CURRENCY == TCURC.WAERS
Functional Area
  • Client
  • Functional Area
  • I_MANUFACTURINGORDER.MANDT == TFKB.MANDT
  • I_MANUFACTURINGORDER.FUNCTIONALAREA == TFKB.FKBER
G/L Account for Basic Settlement
  • Company Code
  • Client
  • G/L Account for Basic Settlement
  • I_MANUFACTURINGORDER.COMPANYCODE == SKB1.BUKRS
  • I_MANUFACTURINGORDER.MANDT == SKB1.MANDT
  • I_MANUFACTURINGORDER.GLACCOUNT == SKB1.SAKNR
Leading Order in Current Processing
  • Client
  • Leading Order in Current Processing
  • I_MANUFACTURINGORDER.MANDT == AUFK.MANDT
  • I_MANUFACTURINGORDER.LEADINGORDER == AUFK.AUFNR
Order Type
  • Order Type
  • Client
  • I_MANUFACTURINGORDER.MANUFACTURINGORDERTYPE == T003O.AUART
  • I_MANUFACTURINGORDER.MANDT == T003O.CLIENT
Material Number for Order
  • Client
  • Material Number for Order
  • Product Number
  • I_MANUFACTURINGORDER.MANDT == MARA.MANDT
  • I_MANUFACTURINGORDER.MATERIAL == MARA.MATNR
  • I_MANUFACTURINGORDER.PRODUCT == MARA.MATNR
MRP Controller Group
  • Production Plant
  • Client
  • MRP Controller
  • I_MANUFACTURINGORDER.PRODUCTIONPLANT == T024D.WERKS
  • I_MANUFACTURINGORDER.MANDT == T024D.MANDT
  • I_MANUFACTURINGORDER.MRPCONTROLLER == T024D.DISPO
Planning Plant for an Order
  • Planning Plant for an Order
  • Client
  • I_MANUFACTURINGORDER.PLANNINGPLANT == T001W.WERKS
  • I_MANUFACTURINGORDER.MANDT == T001W.MANDT
Product Number
  • Client
  • Material Number for Order
  • Product Number
  • I_MANUFACTURINGORDER.MANDT == MARA.MANDT
  • I_MANUFACTURINGORDER.MATERIAL == MARA.MATNR
  • I_MANUFACTURINGORDER.PRODUCT == MARA.MATNR
Fashion Collection
  • Season Year
  • Fashion Collection
  • Client
  • Season
Production Plant
  • Production Plant
  • Client
  • I_MANUFACTURINGORDER.PRODUCTIONPLANT == T001W.WERKS
  • I_MANUFACTURINGORDER.MANDT == T001W.MANDT
Production Scheduling Profile
  • Production Plant
  • Client
  • Production Scheduling Profile
  • I_MANUFACTURINGORDER.PRODUCTIONPLANT == TCO43.WERKS
  • I_MANUFACTURINGORDER.MANDT == TCO43.MANDT
  • I_MANUFACTURINGORDER.PRODUCTIONSCHEDULINGPROFILE == TCO43.CO_PRODPRF
Production Supervisor
  • Production Supervisor
  • Production Plant
  • Client
  • I_MANUFACTURINGORDER.PRODUCTIONSUPERVISOR == T024F.FEVOR
  • I_MANUFACTURINGORDER.PRODUCTIONPLANT == T024F.WERKS
  • I_MANUFACTURINGORDER.MANDT == T024F.MANDT
Production Unit of Measure
  • Production Unit of Measure
  • Client
  • I_MANUFACTURINGORDER.PRODUCTIONUNIT == T006.MSEHI
  • I_MANUFACTURINGORDER.MANDT == T006.MANDT
Season
  • Season Year
  • Client
  • Season
  • I_MANUFACTURINGORDER.PRODUCTSEASONYEAR == FSH_SEASONS.FSH_SEASON_YEAR
  • I_MANUFACTURINGORDER.MANDT == FSH_SEASONS.MANDT
  • I_MANUFACTURINGORDER.PRODUCTSEASON == FSH_SEASONS.FSH_SEASON
Season Year
  • Season Year
  • Client
  • Season
  • I_MANUFACTURINGORDER.PRODUCTSEASONYEAR == FSH_SEASONS.FSH_SEASON_YEAR
  • I_MANUFACTURINGORDER.MANDT == FSH_SEASONS.MANDT
  • I_MANUFACTURINGORDER.PRODUCTSEASON == FSH_SEASONS.FSH_SEASON
Fashion Theme
  • Season Year
  • Fashion Collection
  • Client
  • Fashion Theme
  • Season
  • I_MANUFACTURINGORDER.PRODUCTSEASONYEAR == FSH_THEMES.FSH_SEASON_YEAR
  • I_MANUFACTURINGORDER.PRODUCTCOLLECTION == FSH_THEMES.FSH_COLLECTION
  • I_MANUFACTURINGORDER.MANDT == FSH_THEMES.MANDT
  • I_MANUFACTURINGORDER.PRODUCTTHEME == FSH_THEMES.FSH_THEME
  • I_MANUFACTURINGORDER.PRODUCTSEASON == FSH_THEMES.FSH_SEASON
Profit Center
  • Controlling Area
  • ?
  • Client
  • Profit Center
  • I_MANUFACTURINGORDER.CONTROLLINGAREA == CEPC.KOKRS
  • I_MANUFACTURINGORDER.[column in domain "DATBI"] == CEPC.DATBI
  • I_MANUFACTURINGORDER.MANDT == CEPC.MANDT
  • I_MANUFACTURINGORDER.PROFITCENTER == CEPC.PRCTR
MRP Distribution Key
  • ?
  • Client
  • MRP Distribution Key
  • I_MANUFACTURINGORDER.[column in domain "WERKS_D"] == T437V.WERKS
  • I_MANUFACTURINGORDER.MANDT == T437V.MANDT
  • I_MANUFACTURINGORDER.QUANTITYDISTRIBUTIONKEY == T437V.VERTL
Reference Order Number
  • Client
  • Reference Order Number
  • I_MANUFACTURINGORDER.MANDT == AUFK.MANDT
  • I_MANUFACTURINGORDER.REFERENCEORDER == AUFK.AUFNR
Responsible Cost Center
  • Controlling Area
  • ?
  • Responsible Cost Center
  • Client
  • I_MANUFACTURINGORDER.CONTROLLINGAREA == CSKS.KOKRS
  • I_MANUFACTURINGORDER.[column in domain "DATBI"] == CSKS.DATBI
  • I_MANUFACTURINGORDER.RESPONSIBLECOSTCENTER == CSKS.KOSTL
  • I_MANUFACTURINGORDER.MANDT == CSKS.MANDT
Storage Location
  • Planning Plant for an Order
  • Storage Location
  • Client
  • I_MANUFACTURINGORDER.PLANNINGPLANT == T001L.WERKS
  • I_MANUFACTURINGORDER.STORAGELOCATION == T001L.LGORT
  • I_MANUFACTURINGORDER.MANDT == T001L.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Responsible Planner Group or Department
  • Responsible Planner Group or Department
  • Production Plant
  • Client
  • I_MANUFACTURINGORDER.RESPONSIBLEPLANNERGROUP == T024A.FEVOR
  • I_MANUFACTURINGORDER.PRODUCTIONPLANT == T024A.WERKS
  • I_MANUFACTURINGORDER.MANDT == T024A.MANDT