P_MfgDefectHistory

Defect History | view: PMFGDEFECTHIST | Extraction: Not supported | Component: Shop Floor Execution
Tables used: QMELQMFECRHD
Column Name Description
Notification FK Notification Number
NotificationItem Item Number in Item Record
Defect Defect Number
Column Name Description
Column Name Description
Column Name Description
CreationDate Date on which the record was created
LastChangeDate Last Changed On
CreationTime System Time of Creation
LastChangeTime System Time of Change
Column Name Description
IsDeleted Is Deleted Show values
Column Name Description Domain name
NotificationFieldLengthValue null
CreatedByUser Name of Person Responsible for Creating the Object USNAM
LastChangedByUser Name of Person Who Changed Object USNAM
ProductionOrderOperationActy Identifies an Operation Activity MPE_OAN_ELEMENT_ID
ProductionOrderOpActyVers Number of an Operation Actiivity Version
ProductionOrder Order Number (Production Order) AUFNR
OrderInternalID Plan Number for Operations in Order (Production Order) AUFPL
InspPlanOperationInternalID Current Node Number from Order Counter KNTNR
Equipment Equipment Number EQUNR
Material Material Number MATNR
Plant Plant WERKS
InspectionLot Inspection Lot Number QPLOS
ChangedDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
NotificationItemText Notification Item Short Text TEXT40
MainWorkCenter Work Center ARBPL
SerialNumber Serial Number GERNR
InspectionCharacteristic Inspection Characteristic Number QMERKNRP
Master Data Relations Join Conditions
Defect Category
  • Client
  • Defect Category
  • P_MFGDEFECTHISTORY.MANDT == TQDEFCAT.MANDANT
  • P_MFGDEFECTHISTORY.DEFECTCATEGORY == TQDEFCAT.CATEGORY
Plant for Work Center
  • Plant for Work Center
  • Client
  • P_MFGDEFECTHISTORY.MAINWORKCENTERPLANT == T001W.WERKS
  • P_MFGDEFECTHISTORY.MANDT == T001W.MANDT