I_MfgOrderItemAmountCube

Manufacturing Order Item Amount - Cube | view: IMFGORDITEMAMTC | TRAN | Extraction: Not supported | Component: Virtual Data Model in PP
Tables used: SCAL_TT_DATE, MATDOC, AFKO, AFPO, CKMLPP, CKMLCR, CKMLPP, FMLT_PRICE, MARA, FINSC_LEDGER, FINSC_LEDGER_T, MARA, MARM, CKMLHD, CKMLHD, T001, T001K, CKMLHD, T001K, FINSC_CURTYPE, FINSC_CURTYPE, FINSC_CURTYPET, FINSC_LEDGER, FINSC_CURTYPET, FINSC_VALSUBTYPT, FINSC_VALUTYPT, FINSC_ACTVE_APPL, FINSC_FISC_DATE, FINSC_PERIOD, FMLC_TOGGLE, FMLT_CURTP_ML
Column Name Description
ManufacturingOrder FK Manufacturing Order ID
ManufacturingOrderItem Manufacturing Order Item ID
Column Name Description
💲 Currency Key (CompanyCodeCurrency):
PlannedScrapAmountInCCCrcy Planned Scrap Amount in Company Code Currency
ConfirmedScrapAmountInCCCrcy Confirmed Scrap Amount in Company Code Currency
ConfirmedYieldAmountInCCCrcy Confirmed Yield Amount in Company Code Currency
ConfirmedReworkAmountInCCCrcy Confirmed Rework Amount in Company Code Currency
InventoryPrice Inventory Price
💲 Display Currency (DisplayCurrency):
PlannedScrapAmountInDspCrcy Planned Scrap Amount in Display Currency
ConfirmedScrapAmountInDspCrcy Confirmed Scrap Amount in Display Currency
ConfirmedYieldAmountInDspCrcy Confirmed Yield Amount in Display Currency
ConfirmedReworkAmountInDspCrcy Confirmed Rework Amount in Display Currency
Column Name Description
📏 Production Unit of Measure (ManufacturingOrderUnit):
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
MfgOrderConfirmedYieldQty Confirmed Yield Quantity From Order Confirmation
MfgOrderConfirmedScrapQty Confirmed Scrap Quantity From Order Confirmation
MfgOrderConfirmedReworkQty Total Confirmed Rework Quantity
MfgOrderConfirmedTotalQty Total Quantity From Confirmation
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
MfgOrderItemActualDeliveryDate Actual Delivery/Finish Date
Column Name Description
ManufacturingOrderCategory Manufacturing Order Category Show values
MfgOrderItemIsFinallyDelivered "Delivery Completed" Indicator Show values
ReportingPeriod Reporting Period Show values
Column Name Description Domain name
MaterialGoodsReceiptDuration Goods Receipt Processing Duration in Days DEC3
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
MfgOrderItemPlannedScrapPct Manufacturing Order Planned Item Scrap in Percent PRZ32
MfgOrderConfirmedScrapInPct Manufacturing Order Confirmed Scrap in Percent PRZ32
MfgOrderConfirmedReworkInPct Manufacturing Order Confirmed Rework in Percent PRZ32
MfgOrderConfirmedYieldInPct Manufacturing Order Confirmed Yield in Percent PRZ32
CostEstimate Cost Estimate Number for Product Costing CK_KALNR
MaterialPriceUnitQty Material Price Unit Quantity PACK3
FiscalPeriod Fiscal Period POPER
FiscalYear Fiscal Year GJAHR
FiscalYear_2 Fiscal Year FIS_GJAHR_NO_CONV
Master Data Relations Join Conditions
Base Unit of Measure
  • Base Unit of Measure
  • Client
  • I_MFGORDERITEMAMOUNTCUBE.BASEUNIT == T006.MSEHI
  • I_MFGORDERITEMAMOUNTCUBE.MANDT == T006.MANDT
Batch Number
  • Batch Number
  • Production Plant
  • Client
  • Material Number for Order
  • I_MFGORDERITEMAMOUNTCUBE.BATCH == MCHA.CHARG
  • I_MFGORDERITEMAMOUNTCUBE.PRODUCTIONPLANT == MCHA.WERKS
  • I_MFGORDERITEMAMOUNTCUBE.MANDT == MCHA.MANDT
  • I_MFGORDERITEMAMOUNTCUBE.PRODUCT == MCHA.MATNR
Business Area
  • Business Area
  • Client
  • I_MFGORDERITEMAMOUNTCUBE.BUSINESSAREA == TGSB.GSBER
  • I_MFGORDERITEMAMOUNTCUBE.MANDT == TGSB.MANDT
Inventory Valuation Type
  • Client
  • Inventory Valuation Type
  • I_MFGORDERITEMAMOUNTCUBE.MANDT == T149D.MANDT
  • I_MFGORDERITEMAMOUNTCUBE.INVENTORYVALUATIONTYPE == T149D.BWTAR
Manufacturing Order ID
  • Manufacturing Order ID
  • Client
  • I_MFGORDERITEMAMOUNTCUBE.MANUFACTURINGORDER == AUFK.AUFNR
  • I_MFGORDERITEMAMOUNTCUBE.MANDT == AUFK.MANDT
Manufacturing Order Type
  • Manufacturing Order Type
  • Client
  • I_MFGORDERITEMAMOUNTCUBE.MANUFACTURINGORDERTYPE == T003O.AUART
  • I_MFGORDERITEMAMOUNTCUBE.MANDT == T003O.CLIENT
Production Unit of Measure
  • Production Unit of Measure
  • Client
  • I_MFGORDERITEMAMOUNTCUBE.MANUFACTURINGORDERUNIT == T006.MSEHI
  • I_MFGORDERITEMAMOUNTCUBE.MANDT == T006.MANDT
MRP Controller Group
  • ?
  • MRP Controller
  • Client
  • I_MFGORDERITEMAMOUNTCUBE.[column in domain "WERKS_D"] == T024D.WERKS
  • I_MFGORDERITEMAMOUNTCUBE.MRPCONTROLLER == T024D.DISPO
  • I_MFGORDERITEMAMOUNTCUBE.MANDT == T024D.MANDT
Planning Plant for an Order
  • Client
  • Planning Plant for an Order
  • I_MFGORDERITEMAMOUNTCUBE.MANDT == T001W.MANDT
  • I_MFGORDERITEMAMOUNTCUBE.MRPPLANT == T001W.WERKS
Material Number for Order
  • Client
  • Material Number for Order
  • I_MFGORDERITEMAMOUNTCUBE.MANDT == MARA.MANDT
  • I_MFGORDERITEMAMOUNTCUBE.PRODUCT == MARA.MATNR
Production Plant
  • Production Plant
  • Client
  • I_MFGORDERITEMAMOUNTCUBE.PRODUCTIONPLANT == T001W.WERKS
  • I_MFGORDERITEMAMOUNTCUBE.MANDT == T001W.MANDT
Production Supervisor
  • ?
  • Production Supervisor
  • Client
  • I_MFGORDERITEMAMOUNTCUBE.[column in domain "WERKS_D"] == T024F.WERKS
  • I_MFGORDERITEMAMOUNTCUBE.PRODUCTIONSUPERVISOR == T024F.FEVOR
  • I_MFGORDERITEMAMOUNTCUBE.MANDT == T024F.MANDT
Storage Location
  • Storage Location
  • Client
  • Planning Plant for an Order
  • I_MFGORDERITEMAMOUNTCUBE.STORAGELOCATION == T001L.LGORT
  • I_MFGORDERITEMAMOUNTCUBE.MANDT == T001L.MANDT
  • I_MFGORDERITEMAMOUNTCUBE.MRPPLANT == T001L.WERKS
Valuation area
  • Valuation area
  • Client
  • I_MFGORDERITEMAMOUNTCUBE.VALUATIONAREA == T001K.BWKEY
  • I_MFGORDERITEMAMOUNTCUBE.MANDT == T001K.MANDT