C_MfgOrdOperationScrapQry

Manufacturing Order Operation Scrap - Query | view: CPPMFGOPSCRAPQRY | Extraction: Not supported | Component: Virtual Data Model in PP
Tables used: SCAL_TT_DATEAFKOAFRUAFPOAFVCAFVCAFVUAFVVAUFKMARAMAKTT024DT001WCRTXT024FTRUGTRUGTCRHD
Column Name Description
MfgOrderConfirmation Completion confirmation number for the operation
MfgOrderConfirmationCount Confirmation counter
Column Name Description
Column Name Description
📏 Confirmation Unit of Measure (ConfirmationUnit):
ConfirmationTotalQuantity Total Quantity From Confirmation
ConfirmationYieldQuantity Yield to be Confirmed
ConfirmationReworkQuantity Current Confirmation Rework Quantity
ConfirmationScrapQuantity Scrap to Be Confirmed
📏 Operation Unit of Measure (OperationUnit):
OpPlannedTotalQuantity Operation Total Quantity
OpTotalConfirmedScrapQty Total Scrap Quantity Confirmed
OpPlannedScrapQuantity Operation Planned Scrap Quantity
OpTotalConfirmedYieldQty Total Confirmed Yield
OperationConfirmedReworkQty Total Confirmed Rework Quantity
Column Name Description
PostingDate Posting Date
MfgOrderConfirmationEntryDate Entry Date of Confirmation
MfgOrderConfirmationEntryTime Confirmation Entry Time
Column Name Description
ReportingPeriod Reporting Period Show values
Column Name Description Domain name
OrderInternalBillOfOperations Order Internal Bill of Operations ID AUFPL
WorkCenter Work Center ARBPL
WorkCenterInternalID Work Center Internal ID CR_OBJID
WorkCenterText Work Center Text TEXT40
PlantName Plant Name TEXT30
MaterialName Material Description TEXT40
MRPPlantName Plant Name
MRPController MRP Controller DISPO
MRPControllerName MRP Controller Name TEXT18
ProductionSupervisor Production Supervisor FEVOR
ProductionSupervisorName Production Supervisor Name
ProductionPlant Production Plant WERKS
ProductionPlantName Plant Name
ReportingPeriodName Reporting Period Name DDTEXT
VarianceReasonName Description of the Variance Reason TEXT30
BusinessProcess Business Process CO_PRZNR
MfgOrderOperationText Operation Short Text TEXT40
Personnel Personnel Number PERNR
EmployeeWageType Employee Wage Type LOART
MfgOrderConfirmationEntryHour Confirmation Entry Hour HOUR2
EntryDateYearMonth Year Month NUM6
EntryDateWeekDay Week Day NUM1
EntryDateWeekDayName Short Text for Fixed Values DDTEXT
EntryDateWeek Calendar Week NUM2
EntryDateMonth Calendar Month NUM2
EntryDateMonthName Short Text for Fixed Values DDTEXT
EntryDateYear Calendar Year NUM4
OperationActualScrapPercent null
OperationPlannedScrapPercent null
MfgOrderOpConfdPlndScrapDvtn null
ConfirmationReworkPercent null
ConfirmationYieldPercent null
ConfirmationScrapReworkPercent null
StockSegment Stock Segment
Master Data Relations Join Conditions
Unit of Operation
  • Operation Unit of Measure
  • Confirmation Unit of Measure
  • Client
  • C_MFGORDOPERATIONSCRAPQRY.OPERATIONUNIT == T006.MSEHI
  • C_MFGORDOPERATIONSCRAPQRY.CONFIRMATIONUNIT == T006.MSEHI
  • C_MFGORDOPERATIONSCRAPQRY.MANDT == T006.MANDT
Confirmed Degree of Qualification
  • Employee Suitability
  • Client
  • Plant
  • Production Plant
  • C_MFGORDOPERATIONSCRAPQRY.EMPLOYEESUITABILITY == T423.QUALF
  • C_MFGORDOPERATIONSCRAPQRY.MANDT == T423.MANDT
  • C_MFGORDOPERATIONSCRAPQRY.PLANT == T423.WERKS
  • C_MFGORDOPERATIONSCRAPQRY.PRODUCTIONPLANT == T423.WERKS
Confirmed wage group
  • Employee Wage Group
  • Client
  • Plant
  • Production Plant
  • C_MFGORDOPERATIONSCRAPQRY.EMPLOYEEWAGEGROUP == T421.LOGRP
  • C_MFGORDOPERATIONSCRAPQRY.MANDT == T421.MANDT
  • C_MFGORDOPERATIONSCRAPQRY.PLANT == T421.WERKS
  • C_MFGORDOPERATIONSCRAPQRY.PRODUCTIONPLANT == T421.WERKS
Manufacturing Order ID
  • Manufacturing Order ID
  • Client
  • C_MFGORDOPERATIONSCRAPQRY.MANUFACTURINGORDER == AUFK.AUFNR
  • C_MFGORDOPERATIONSCRAPQRY.MANDT == AUFK.MANDT
Material Number for Order
  • Client
  • Material Number for Order
  • C_MFGORDOPERATIONSCRAPQRY.MANDT == MARA.MANDT
  • C_MFGORDOPERATIONSCRAPQRY.MATERIAL == MARA.MATNR
Planning Plant for an Order
  • Planning Plant for an Order
  • Client
  • C_MFGORDOPERATIONSCRAPQRY.MRPPLANT == T001W.WERKS
  • C_MFGORDOPERATIONSCRAPQRY.MANDT == T001W.MANDT
Priority
  • Priority
  • Client
  • C_MFGORDOPERATIONSCRAPQRY.OPERATIONIMPORTANCE == TCN07.NPRIO
  • C_MFGORDOPERATIONSCRAPQRY.MANDT == TCN07.MANDT
Operation Unit of Measure
  • Operation Unit of Measure
  • Confirmation Unit of Measure
  • Client
  • C_MFGORDOPERATIONSCRAPQRY.OPERATIONUNIT == T006.MSEHI
  • C_MFGORDOPERATIONSCRAPQRY.CONFIRMATIONUNIT == T006.MSEHI
  • C_MFGORDOPERATIONSCRAPQRY.MANDT == T006.MANDT
Plant
  • Client
  • Plant
  • Production Plant
  • C_MFGORDOPERATIONSCRAPQRY.MANDT == T001W.MANDT
  • C_MFGORDOPERATIONSCRAPQRY.PLANT == T001W.WERKS
  • C_MFGORDOPERATIONSCRAPQRY.PRODUCTIONPLANT == T001W.WERKS
Scrap Reason
  • Reason for Variance
  • Client
  • Plant
  • Production Plant
  • C_MFGORDOPERATIONSCRAPQRY.VARIANCEREASONCODE == TRUG.GRUND
  • C_MFGORDOPERATIONSCRAPQRY.MANDT == TRUG.MANDT
  • C_MFGORDOPERATIONSCRAPQRY.PLANT == TRUG.WERKS
  • C_MFGORDOPERATIONSCRAPQRY.PRODUCTIONPLANT == TRUG.WERKS