I_MfgOrderItemWithStatus

Manufacturing Order Item with Status | view: IMFGORDITEMWSTS | ATTR | Extraction: Not supported | Component: Virtual Data Model in PP
Tables used: AFKOAFPOJEST
Column Name Description
ManufacturingOrder FK Manufacturing Order ID
ManufacturingOrderItem Manufacturing Order Item ID
Column Name Description
Column Name Description
📏 Production Unit of Measure (ProductionUnit):
MfgOrderItemPlannedTotalQty Order Item Planned Total Quantity
MfgOrderItemPlannedScrapQty Order Item Planned Scrap Quantity
MfgOrderItemPlannedYieldQty Planned Yield Quantity
MfgOrderItemGoodsReceiptQty Quantity of Goods Received for the Order Item
MfgOrderItemActualDeviationQty Expected Surplus/Deficit For Goods Receipt
MfgOrderItemOpenYieldQty Open Yield Quantity
MfgOrderConfirmedYieldQty Confirmed Yield Quantity From Order Confirmation
MfgOrderConfirmedScrapQty Confirmed Scrap Quantity From Order Confirmation
MfgOrderConfirmedReworkQty Total Confirmed Rework Quantity
MfgOrderConfirmedTotalQty Total Quantity From Confirmation
MfgOrderPlannedTotalQty Total Order Quantity
MfgOrderPlannedScrapQty Total Scrap Quantity in the Order
Column Name Description
MfgOrderPlannedStartDate Manufacturing Order Planned Start Date
MfgOrderPlannedStartTime Manufacturing Order Planned Start Time
MfgOrderScheduledStartDate Manufacturing Order Scheduled Start Date
MfgOrderScheduledStartTime Manufacturing Order Scheduled Start Time
MfgOrderActualStartDate Manufacturing Order Actual Start Date
MfgOrderActualStartTime Manufacturing Order Actual Start Time
MfgOrderPlannedEndDate Manufacturing Order Planned End Date
MfgOrderPlannedEndTime Manufacturing Order Planned End Time
MfgOrderScheduledEndDate Manufacturing Order Scheduled End Date
MfgOrderScheduledEndTime Manufacturing Order Scheduled End Time
MfgOrderConfirmedEndDate Manufacturing Order Confirmed End Date
MfgOrderConfirmedEndTime Manufacturing Order Confirmed End Time
MfgOrderActualEndDate Manufacturing Order Actual End Date
MfgOrderScheduledReleaseDate Manufacturing Order Scheduled Release Date
MfgOrderActualReleaseDate Manufacturing Order Actual Release Date
MfgOrderItemPlannedEndDate Manufacturing Order Item Planned End Date
MfgOrderItemScheduledEndDate Manufacturing Order Item Scheduled End Date
MfgOrderItemPlndDeliveryDate Delivery Date From Planned Order
MfgOrderItemActualDeliveryDate Actual Delivery/Finish Date
MfgOrderItemTotalCmtmtDate Total Commitment Date
Column Name Description
ManufacturingOrderCategory Manufacturing Order Category Show values
IsMarkedForDeletion Deletion Flag Show values
IsCompletelyDelivered "Delivery Completed" Indicator Show values
OrderItemIsCreated Indicator: Order is Created Show values
OrderItemIsReleased Indicator: Order is Released Show values
OrderItemIsClosed Indicator: Order Is Closed Show values
OrderItemIsPartiallyDelivered Indicator: Is Partially Delivered Show values
SettlementRuleIsCreated Indicator: Settlement Rule is Created Show values
MaterialProcurementCategory Material Procurement Category Show values
MaterialProcurementType Material Procurement Type Show values
MfgOrderItemReplnmtElmntType Kanban Indicator Show values
GoodsReceiptIsExpected Goods Receipt is Allowed and Expected Show values
GoodsReceiptIsNonValuated Goods Receipt is Non-Valuated Show values
UnlimitedOverdeliveryIsAllowed Unlimited Overdelivery Allowed Show values
InventoryUsabilityCode Inventory Usability Code Show values
InventorySpecialStockValnType Inventory Special Stock Valuation Type Show values
ConsumptionPosting Consumption posting Show values
Column Name Description Domain name
ProductionVersion Production Version VERID
MRPArea MRP Area BERID
QuotaArrangement Quota Arrangement QUNUM
QuotaArrangementItem Quota Arrangement Item NUM03
SettlementReservation Settlement Reservation RSNUM
SettlementReservationItem Settlement Reservation Item RSPOS
CoProductReservation Co-Prodcut Reservation RSNUM
CoProductReservationItem Co-Prodcut Reservation Item RSPOS
NumberOfSerialNumbers Number of Serial Numbers PPH_COUNT_INT4
ProductConfiguration Product Configuration CUOBJ
EffectivityParameterVariant Parameter Variant/Standard Variant TECHS
MaterialGoodsReceiptDuration Goods Receipt Processing Duration in Days DEC3
UnderdelivTolrtdLmtRatioInPct Underdelivery Tolerance PRZ21
OverdelivTolrtdLmtRatioInPct Overdelivery Tolerance PRZ21
GoodsRecipientName Goods Recipient WEMPF
UnloadingPointName Unloading Point TEXT25
StockSegment Stock Segment SGT_SRCA
OrderIsCreated null
OrderIsReleased null
Master Data Relations Join Conditions
Account Assignment Category
  • Client
  • Account Assignment Category
  • I_MFGORDERITEMWITHSTATUS.MANDT == T163K.MANDT
  • I_MFGORDERITEMWITHSTATUS.ACCOUNTASSIGNMENTCATEGORY == T163K.KNTTP
Batch Number
  • Production Plant
  • Batch Number
  • Client
  • Product Number
  • I_MFGORDERITEMWITHSTATUS.PRODUCTIONPLANT == MCHA.WERKS
  • I_MFGORDERITEMWITHSTATUS.BATCH == MCHA.CHARG
  • I_MFGORDERITEMWITHSTATUS.MANDT == MCHA.MANDT
  • I_MFGORDERITEMWITHSTATUS.PRODUCT == MCHA.MATNR
Business Area
  • Client
  • Business Area
  • I_MFGORDERITEMWITHSTATUS.MANDT == TGSB.MANDT
  • I_MFGORDERITEMWITHSTATUS.BUSINESSAREA == TGSB.GSBER
Inventory Special Stock Type
  • Client
  • Inventory Special Stock Type
  • I_MFGORDERITEMWITHSTATUS.MANDT == T148.MANDT
  • I_MFGORDERITEMWITHSTATUS.INVENTORYSPECIALSTOCKTYPE == T148.SOBKZ
Valuation Category
  • Valuation Category
  • Client
  • I_MFGORDERITEMWITHSTATUS.INVENTORYVALUATIONCATEGORY == T149C.BWTTY
  • I_MFGORDERITEMWITHSTATUS.MANDT == T149C.MANDT
Inventory Valuation Type
  • Inventory Valuation Type
  • Client
  • I_MFGORDERITEMWITHSTATUS.INVENTORYVALUATIONTYPE == T149D.BWTAR
  • I_MFGORDERITEMWITHSTATUS.MANDT == T149D.MANDT
Manufacturing Order ID
  • Manufacturing Order ID
  • Client
  • I_MFGORDERITEMWITHSTATUS.MANUFACTURINGORDER == AUFK.AUFNR
  • I_MFGORDERITEMWITHSTATUS.MANDT == AUFK.MANDT
Manufacturing Order Type
  • Client
  • Manufacturing Order Type
  • I_MFGORDERITEMWITHSTATUS.MANDT == T003O.CLIENT
  • I_MFGORDERITEMWITHSTATUS.MANUFACTURINGORDERTYPE == T003O.AUART
MRP Controller Group
  • Client
  • MRP Controller
  • ?
  • I_MFGORDERITEMWITHSTATUS.MANDT == T024D.MANDT
  • I_MFGORDERITEMWITHSTATUS.MRPCONTROLLER == T024D.DISPO
  • I_MFGORDERITEMWITHSTATUS.[column in domain "WERKS_D"] == T024D.WERKS
Planning Plant for an Order
  • Client
  • Planning Plant for an Order
  • I_MFGORDERITEMWITHSTATUS.MANDT == T001W.MANDT
  • I_MFGORDERITEMWITHSTATUS.PLANNINGPLANT == T001W.WERKS
Product Number
  • Client
  • Product Number
  • I_MFGORDERITEMWITHSTATUS.MANDT == MARA.MANDT
  • I_MFGORDERITEMWITHSTATUS.PRODUCT == MARA.MATNR
Production Plant
  • Production Plant
  • Client
  • I_MFGORDERITEMWITHSTATUS.PRODUCTIONPLANT == T001W.WERKS
  • I_MFGORDERITEMWITHSTATUS.MANDT == T001W.MANDT
Production Supervisor
  • Client
  • Production Supervisor
  • ?
  • I_MFGORDERITEMWITHSTATUS.MANDT == T024F.MANDT
  • I_MFGORDERITEMWITHSTATUS.PRODUCTIONSUPERVISOR == T024F.FEVOR
  • I_MFGORDERITEMWITHSTATUS.[column in domain "WERKS_D"] == T024F.WERKS
Production Unit of Measure
  • Client
  • Production Unit of Measure
  • I_MFGORDERITEMWITHSTATUS.MANDT == T006.MANDT
  • I_MFGORDERITEMWITHSTATUS.PRODUCTIONUNIT == T006.MSEHI
MRP Distribution Key
  • Production Plant
  • MRP Distribution Key
  • Client
  • I_MFGORDERITEMWITHSTATUS.PRODUCTIONPLANT == T437V.WERKS
  • I_MFGORDERITEMWITHSTATUS.QUANTITYDISTRIBUTIONKEY == T437V.VERTL
  • I_MFGORDERITEMWITHSTATUS.MANDT == T437V.MANDT
Serial Number Profile
  • Serial Number Profile
  • Client
  • I_MFGORDERITEMWITHSTATUS.SERIALNUMBERASSGMTPROFILE == T377P.SERAIL
  • I_MFGORDERITEMWITHSTATUS.MANDT == T377P.MANDT
Storage Location
  • Storage Location
  • Client
  • Planning Plant for an Order
  • I_MFGORDERITEMWITHSTATUS.STORAGELOCATION == T001L.LGORT
  • I_MFGORDERITEMWITHSTATUS.MANDT == T001L.MANDT
  • I_MFGORDERITEMWITHSTATUS.PLANNINGPLANT == T001L.WERKS