I_MfgOrderItemCube

Manufacturing Order Item - Cube | view: IPPMFGORDITEMC | TRAN | Extraction: Not supported | Component: Virtual Data Model in PP

Tables used: SCAL_TT_DATE, AFKO, AFPO

🔑 Keys (2)
💰 Amounts
∑ Quantities (12)
📅 Dates (21)
☰ Categorical (12)
Other (46)
🔗 Relations (21)

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
MfgOrderConfirmedEndDate	Manufacturing Order Confirmed End Date
MfgOrderConfirmedEndTime	Manufacturing Order Confirmed End 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
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
MfgOrderItemAvailabilityDate	Total Commitment Date

Column Name	Description
ManufacturingOrderCategory	Manufacturing Order Category	Show values
MaterialProcurementCategory	Material Procurement Category	Show values
MaterialProcurementType	Material Procurement Type	Show values
MfgOrderItemReplnmtElmntType	Kanban Indicator	Show values
IsCompletelyDelivered	"Delivery Completed" 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
ReportingPeriod	Reporting Period	Show values

Column Name	Description	Domain name
OrderIsCreated	null
OrderIsReleased	null
OrderIsPartiallyReleased	null
OrderIsPrinted	null
OrderIsConfirmed	null
OrderIsPartiallyConfirmed	null
OrderIsDelivered	null
OrderIsPartiallyDelivered	null
OrderIsLocked	null
OrderIsClosed	null
OrderIsTechnicallyCompleted	null
OrderIsMarkedForDeletion	null
OrderIsDeleted	null
PlannedOrder	Planned Order	PLNUM
Reservation	Number of reservation/dependent requirements	RSNUM
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
EndDateHour	End Date Hour	HOUR2
EndDateWeekDay	Week Day	NUM1
EndDateWeek	Calendar Week	NUM2
EndDateMonth	Calendar Month	NUM2
EndDateYear	Calendar Year	NUM4
EndDateYearMonth	Year Month	NUM6
MfgOrdPlndStrtDateYearMonth	null
MfgOrdPlndStrtDateYearWeek	null
MfgOrdPlndStrtDateWeekDay	null
MfgOrdItemGdsRcptPlndDuration	null
MfgOrdItemGdsRcptSchdldDurn	null
MfgOrdItemGdsRcptActDuration	null
ProcgDurnPlndActualDvtnDays	null
ProcgDurnSchedldActualDvtnDays	null

Master Data Relations	Join Conditions
Account Assignment Category Account Assignment Category Client	`I_MFGORDERITEMCUBE.ACCOUNTASSIGNMENTCATEGORY == T163K.KNTTP` `I_MFGORDERITEMCUBE.MANDT == T163K.MANDT`
Batch Number Material Number for Order Batch Number Client Production Plant	`I_MFGORDERITEMCUBE.MATERIAL == MCHA.MATNR` `I_MFGORDERITEMCUBE.BATCH == MCHA.CHARG` `I_MFGORDERITEMCUBE.MANDT == MCHA.MANDT` `I_MFGORDERITEMCUBE.PRODUCTIONPLANT == MCHA.WERKS`
Business Area Business Area Client	`I_MFGORDERITEMCUBE.BUSINESSAREA == TGSB.GSBER` `I_MFGORDERITEMCUBE.MANDT == TGSB.MANDT`
Inventory Special Stock Type Client Inventory Special Stock Type	`I_MFGORDERITEMCUBE.MANDT == T148.MANDT` `I_MFGORDERITEMCUBE.INVENTORYSPECIALSTOCKTYPE == T148.SOBKZ`
Valuation Category Client Valuation Category	`I_MFGORDERITEMCUBE.MANDT == T149C.MANDT` `I_MFGORDERITEMCUBE.INVENTORYVALUATIONCATEGORY == T149C.BWTTY`
Inventory Valuation Type Inventory Valuation Type Client	`I_MFGORDERITEMCUBE.INVENTORYVALUATIONTYPE == T149D.BWTAR` `I_MFGORDERITEMCUBE.MANDT == T149D.MANDT`
Manufacturing Order ID Client Manufacturing Order ID	`I_MFGORDERITEMCUBE.MANDT == AUFK.MANDT` `I_MFGORDERITEMCUBE.MANUFACTURINGORDER == AUFK.AUFNR`
Manufacturing Order Type Manufacturing Order Type Client	`I_MFGORDERITEMCUBE.MANUFACTURINGORDERTYPE == T003O.AUART` `I_MFGORDERITEMCUBE.MANDT == T003O.CLIENT`
Material Number for Order Material Number for Order Client	`I_MFGORDERITEMCUBE.MATERIAL == MARA.MATNR` `I_MFGORDERITEMCUBE.MANDT == MARA.MANDT`
MRP Controller Group MRP Controller Client ?	`I_MFGORDERITEMCUBE.MRPCONTROLLER == T024D.DISPO` `I_MFGORDERITEMCUBE.MANDT == T024D.MANDT` `I_MFGORDERITEMCUBE.[column in domain "WERKS_D"] == T024D.WERKS`
Planning Plant for an Order Planning Plant for an Order Client	`I_MFGORDERITEMCUBE.MRPPLANT == T001W.WERKS` `I_MFGORDERITEMCUBE.MANDT == T001W.MANDT`
Production Plant Client Production Plant	`I_MFGORDERITEMCUBE.MANDT == T001W.MANDT` `I_MFGORDERITEMCUBE.PRODUCTIONPLANT == T001W.WERKS`
Production Supervisor Production Supervisor Client ?	`I_MFGORDERITEMCUBE.PRODUCTIONSUPERVISOR == T024F.FEVOR` `I_MFGORDERITEMCUBE.MANDT == T024F.MANDT` `I_MFGORDERITEMCUBE.[column in domain "WERKS_D"] == T024F.WERKS`
Production Unit of Measure Client Production Unit of Measure	`I_MFGORDERITEMCUBE.MANDT == T006.MANDT` `I_MFGORDERITEMCUBE.PRODUCTIONUNIT == T006.MSEHI`
MRP Distribution Key Client MRP Distribution Key Production Plant	`I_MFGORDERITEMCUBE.MANDT == T437V.MANDT` `I_MFGORDERITEMCUBE.QUANTITYDISTRIBUTIONKEY == T437V.VERTL` `I_MFGORDERITEMCUBE.PRODUCTIONPLANT == T437V.WERKS`
Serial Number Profile Client Serial Number Profile	`I_MFGORDERITEMCUBE.MANDT == T377P.MANDT` `I_MFGORDERITEMCUBE.SERIALNUMBERASSGMTPROFILE == T377P.SERAIL`
Storage Location Storage Location Planning Plant for an Order Client	`I_MFGORDERITEMCUBE.STORAGELOCATION == T001L.LGORT` `I_MFGORDERITEMCUBE.MRPPLANT == T001L.WERKS` `I_MFGORDERITEMCUBE.MANDT == T001L.MANDT`