C_MfgOrderItemScrapAmtQry

Manufacturing Order Item Scrap Amount - Query | view: CMFGORDITEMAMTQ | 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, T024D, T001W, MARA, T024F, MAKT, MARM, T001L, 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):
InventoryPrice Inventory Price
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
💲 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
MfgOrderConfirmedEndDate Manufacturing Order Confirmed End Date
MfgOrderConfirmedEndTime Manufacturing Order Confirmed End Time
Column Name Description
ManufacturingOrderCategory Manufacturing Order Category Show values
ReportingPeriod Reporting Period Show values
Column Name Description Domain name
ProductName Product Description TEXT40
ProductionPlantName Production Plant Name TEXT30
MRPPlantName Planning Plant Name TEXT30
MRPControllerName MRP Controller Name TEXT18
ProductionSupervisorName Production Supervisor Name TEXT30
StorageLocationName Storage Location Name TEXT16
ReportingPeriodName Reporting Period Name DDTEXT
EndDateHour End Date Hour HOUR2
EndDateWeekDay Week Day NUM1
EndDateWeekDayName End Date Week Day Name DDTEXT
EndDateWeek Calendar Week NUM2
EndDateMonth Calendar Month NUM2
EndDateYear Calendar Year NUM4
EndDateYearMonth Year Month NUM6
CostEstimate Cost Estimate Number for Product Costing CK_KALNR
MaterialPriceUnitQty Material Price Unit Quantity PACK3
FiscalPeriod Fiscal Period POPER
FiscalYear Fiscal Year GJAHR
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
Master Data Relations Join Conditions
Batch Number
  • Client
  • Batch Number
  • Production Plant
  • Material Number for Order
  • C_MFGORDERITEMSCRAPAMTQRY.MANDT == MCHA.MANDT
  • C_MFGORDERITEMSCRAPAMTQRY.BATCH == MCHA.CHARG
  • C_MFGORDERITEMSCRAPAMTQRY.PRODUCTIONPLANT == MCHA.WERKS
  • C_MFGORDERITEMSCRAPAMTQRY.PRODUCT == MCHA.MATNR
Business Area
  • Client
  • Business Area
  • C_MFGORDERITEMSCRAPAMTQRY.MANDT == TGSB.MANDT
  • C_MFGORDERITEMSCRAPAMTQRY.BUSINESSAREA == TGSB.GSBER
Inventory Valuation Type
  • Client
  • Inventory Valuation Type
  • C_MFGORDERITEMSCRAPAMTQRY.MANDT == T149D.MANDT
  • C_MFGORDERITEMSCRAPAMTQRY.INVENTORYVALUATIONTYPE == T149D.BWTAR
Manufacturing Order ID
  • Client
  • Manufacturing Order ID
  • C_MFGORDERITEMSCRAPAMTQRY.MANDT == AUFK.MANDT
  • C_MFGORDERITEMSCRAPAMTQRY.MANUFACTURINGORDER == AUFK.AUFNR
Manufacturing Order Type
  • Client
  • Manufacturing Order Type
  • C_MFGORDERITEMSCRAPAMTQRY.MANDT == T003O.CLIENT
  • C_MFGORDERITEMSCRAPAMTQRY.MANUFACTURINGORDERTYPE == T003O.AUART
Production Unit of Measure
  • Production Unit of Measure
  • Client
  • C_MFGORDERITEMSCRAPAMTQRY.MANUFACTURINGORDERUNIT == T006.MSEHI
  • C_MFGORDERITEMSCRAPAMTQRY.MANDT == T006.MANDT
MRP Controller Group
  • Client
  • ?
  • MRP Controller
  • C_MFGORDERITEMSCRAPAMTQRY.MANDT == T024D.MANDT
  • C_MFGORDERITEMSCRAPAMTQRY.[column in domain "WERKS_D"] == T024D.WERKS
  • C_MFGORDERITEMSCRAPAMTQRY.MRPCONTROLLER == T024D.DISPO
Planning Plant for an Order
  • Client
  • Planning Plant for an Order
  • C_MFGORDERITEMSCRAPAMTQRY.MANDT == T001W.MANDT
  • C_MFGORDERITEMSCRAPAMTQRY.MRPPLANT == T001W.WERKS
Material Number for Order
  • Client
  • Material Number for Order
  • C_MFGORDERITEMSCRAPAMTQRY.MANDT == MARA.MANDT
  • C_MFGORDERITEMSCRAPAMTQRY.PRODUCT == MARA.MATNR
Production Plant
  • Client
  • Production Plant
  • C_MFGORDERITEMSCRAPAMTQRY.MANDT == T001W.MANDT
  • C_MFGORDERITEMSCRAPAMTQRY.PRODUCTIONPLANT == T001W.WERKS
Production Supervisor
  • Client
  • Production Supervisor
  • ?
  • C_MFGORDERITEMSCRAPAMTQRY.MANDT == T024F.MANDT
  • C_MFGORDERITEMSCRAPAMTQRY.PRODUCTIONSUPERVISOR == T024F.FEVOR
  • C_MFGORDERITEMSCRAPAMTQRY.[column in domain "WERKS_D"] == T024F.WERKS
Storage Location
  • Client
  • Storage Location
  • Planning Plant for an Order
  • C_MFGORDERITEMSCRAPAMTQRY.MANDT == T001L.MANDT
  • C_MFGORDERITEMSCRAPAMTQRY.STORAGELOCATION == T001L.LGORT
  • C_MFGORDERITEMSCRAPAMTQRY.MRPPLANT == T001L.WERKS
Valuation area
  • Valuation area
  • Client
  • C_MFGORDERITEMSCRAPAMTQRY.VALUATIONAREA == T001K.BWKEY
  • C_MFGORDERITEMSCRAPAMTQRY.MANDT == T001K.MANDT