C_InspLotDefect

Inspection Lot Defect View | view: CINSPLOTDEFECT | Extraction: Not supported | Component: Inspection Lot Worklist
Tables used: QAMVQALSAFVCQAOPQAMRQASVQASRQMELQMFEQPAMQPAMTXTQPCDQPCTQPGRQPGTQPCTQMTBQMTTTQ76TQ76TTQ17ATQ17UT006T006ACRHD
Column Name Description
DefectInternalID FK Notification Number
NotificationItem Item Number in Item Record
Defect Defect Number
InspectionCharacteristic Inspection Characteristic Number
Column Name Description
Column Name Description
Column Name Description
Column Name Description
WorkCenterTypeCode Object types of the CIM resource Show values
Column Name Description Domain name
InspectionLot Inspection Lot Number QPLOS
InspSpecAddlCodeGroupText Text for Code Group
InspectionCodeText Text for Code
OperationText Operation Short Text TEXT40
InspectionOperation Operation/Activity Number
InspectionSpecificationText Short Text for Inspection Characteristic QKURZTEXT
NumberOfDefects Number of Defect Occurrences QANZAHL4
DefectCode Defect Code
InspectionLotSum null
InspPlanOperationInternalID Current Node Number from Order Counter KNTNR
MainWorkCenter Work Center ARBPL
Master Data Relations Join Conditions
Defect Category
  • Defect Category
  • Client
  • C_INSPLOTDEFECT.DEFECTCATEGORY == TQDEFCAT.CATEGORY
  • C_INSPLOTDEFECT.MANDT == TQDEFCAT.MANDANT
Defect Code Group
  • Client
  • Defect Code Group
  • ?
  • C_INSPLOTDEFECT.MANDT == QPGR.MANDT
  • C_INSPLOTDEFECT.DEFECTCODEGROUP == QPGR.CODEGRUPPE
  • C_INSPLOTDEFECT.[column in domain "QKATART"] == QPGR.KATALOGART
Object ID of the Work Center
  • Client
  • Work Center
  • Object ID of the Work Center
  • Object types of the CIM resource
  • C_INSPLOTDEFECT.MANDT == CRID.MANDT
  • C_INSPLOTDEFECT.MAINWORKCENTER == CRID.OBJID
  • C_INSPLOTDEFECT.MAINWORKCENTERINTERNALID == CRID.OBJID
  • C_INSPLOTDEFECT.WORKCENTERTYPECODE == CRID.OBJTY
Plant for Work Center
  • Client
  • Plant for Work Center
  • C_INSPLOTDEFECT.MANDT == T001W.MANDT
  • C_INSPLOTDEFECT.MAINWORKCENTERPLANT == T001W.WERKS
Plant
  • Client
  • Plant
  • C_INSPLOTDEFECT.MANDT == T001W.MANDT
  • C_INSPLOTDEFECT.PLANT == T001W.WERKS