P_MfgOrderDefect

Notification and Defect | view: PMFGORDDEF | Extraction: Not supported | Component: Shop Floor Execution
Column Name Description
DefectInternalID FK Notification Number
NotificationItem Item Number in Item Record
Column Name Description
Column Name Description
📏 Unit of Measure for Item (DefectiveQuantityUnit):
DefectiveQuantity Defective Quantity for Item (Internal)
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
DefectIsCreatedAutomatically Defect Created Automatically Show values
IsDeleted Is Deleted Show values
NotifProcessingPhase Notification Processing Phase Show values
DefectLifecycleStatus Defect Status Show values
WorkCenterTypeCode Object types of the CIM resource Show values
MfgDefectDecision Defect decision Show values
Column Name Description Domain name
Notification Notification Number QMNUM
Defect Defect Number QDEFECTID
NotificationType Notification Type QMART
CreatedByUser Name of Person Responsible for Creating the Object USNAM
LastChangedByUser Name of Person Who Changed Object USNAM
DefectText Defect Text TEXT40
NotificationText Short Text TEXT40
DefectCode Defect Code QCODE
ProductionOrderOperationActy Identifies an Operation Activity MPE_OAN_ELEMENT_ID
ProductionOrderOpActyVers Number of an Operation Actiivity Version
OpActyNtwkElementExternalID Element Number MPE_OAN_ELEMENT_NUMBER_EXT
OpActyNtwkElement Internal OAN Element Number
ProductionOrder Order Number (Production Order) AUFNR
OrderInternalID Plan Number for Operations in Order (Production Order) AUFPL
InspPlanOperationInternalID Current Node Number from Order Counter KNTNR
InspectionCharacteristic Inspection Characteristic Number QMERKNRP
DefectiveSingleUnit Single-Unit Number for Unit to Be Inspected QSERIALNR
ProducedMaterial Material Number MATNR
ProducedSerialNumber Serial Number GERNR
Batch Batch Number CHARG
SerialNumber Single-Unit Number for Unit to Be Inspected QSERIALNR
ShopFloorItem ID of Serialized Material
Equipment Equipment Number EQUNR
Material Defective Material MATNR
Plant Plant WERKS
InspectionLot Inspection Lot Number QPLOS
ChangedDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
BOMItemInstanceUUID Internal Identification for DMU Objects of Type RAW 16 DMU_GUID16
ReferenceDesignatorValue Reference Designator CHAR128
MainWorkCenter Work Center ARBPL
MfgDefectDecisionName Defect decision Text DDTEXT
Master Data Relations Join Conditions
Defect Category
  • Defect Category
  • Client
  • P_MFGORDERDEFECT.DEFECTCATEGORY == TQDEFCAT.CATEGORY
  • P_MFGORDERDEFECT.MANDT == TQDEFCAT.MANDANT
Catalog Type - Problems/Defects
  • Catalog Type - Problems/Defects
  • Client
  • P_MFGORDERDEFECT.DEFECTCODECATALOG == TQ15.KATALOGART
  • P_MFGORDERDEFECT.MANDT == TQ15.MANDT
Defect Code Group
  • Catalog Type - Problems/Defects
  • Client
  • Defect Code Group
  • P_MFGORDERDEFECT.DEFECTCODECATALOG == QPGR.KATALOGART
  • P_MFGORDERDEFECT.MANDT == QPGR.MANDT
  • P_MFGORDERDEFECT.DEFECTCODEGROUP == QPGR.CODEGRUPPE
Plant for Work Center
  • Client
  • Plant for Work Center
  • P_MFGORDERDEFECT.MANDT == T001W.MANDT
  • P_MFGORDERDEFECT.MAINWORKCENTERPLANT == T001W.WERKS
Object ID of the Work Center
  • Object ID of the Work Center
  • Work Center
  • Client
  • Object types of the CIM resource
  • P_MFGORDERDEFECT.WORKCENTERINTERNALID == CRID.OBJID
  • P_MFGORDERDEFECT.MAINWORKCENTER == CRID.OBJID
  • P_MFGORDERDEFECT.MANDT == CRID.MANDT
  • P_MFGORDERDEFECT.WORKCENTERTYPECODE == CRID.OBJTY