I_DefectKeyFigCube

Key Figure view for Defect Analytics | view: IDEFECTKEYFIG | TRAN | Extraction: Not supported | Component: Quality Notifications
Tables used: QAMV, QALS, AFVC, QAOP, QMEL, QMFE, AFVC, TQDEFECTCONFIG, CRTX, CRHD
Column Name Description
DefectInternalID FK Internal Defect ID
Column Name Description
Column Name Description
Column Name Description
CreationDate Date on which the record was created
CreationTime System Time of Creation
Column Name Description
WorkCenterTypeCode Object types of the CIM resource Show values
DefectLifecycleStatus Defect Status Show values
IsBusinessPurposeCompleted Business Purpose Completed Flag Show values
Column Name Description Domain name
InspectionLot Inspection Lot Number QPLOS
InspPlanOperationInternalID Current Node Number from Order Counter KNTNR
InspectionCharacteristic Inspection Characteristic Number QMERKNRP
DefectCode Defect Code QCODE
InspectionSpecificationText Short Text for Inspection Characteristic QKURZTEXT
WorkCenter Work Center ARBPL
WorkCenterText Work Center Text TEXT40
InspectionSpecificationPlant Plant for Master Inspection Characteristic QZAEHLER
InspectionSpecificationVersion Version Number of Master Inspection Characteristic QVERSNR
BillOfOperationsGroup Bill of Operations Group PLNNR
BOOOperationInternalID Number of the Task List Node KNTNR
InspResultHistoryCharc null
MasterInspCharcsKey null
NumberOfDefects Defects VDM_QM_COUNTER
NumberOfDefectsWithNotif No. of Defect Records with Notification VDM_QM_COUNTER
NumberOfDefectsWithoutNotif No. of Defect Records Without Notification VDM_QM_COUNTER
Notification Notification Number QMNUM
NotificationItem Item Number in Item Record FELFD
MainWorkCenter Work Center ARBPL
Master Data Relations Join Conditions
Bill of Operations Type
  • Client
  • Bill of Operations Type
  • I_DEFECTKEYFIGCUBE.MANDT == TCA01.MANDT
  • I_DEFECTKEYFIGCUBE.BILLOFOPERATIONSTYPE == TCA01.PLNTY
Customer (Ship-To Party)
  • Client
  • Customer (Ship-To Party)
  • I_DEFECTKEYFIGCUBE.MANDT == KNA1.MANDT
  • I_DEFECTKEYFIGCUBE.CUSTOMER == KNA1.KUNNR
Defect Category
  • Defect Category
  • Client
  • I_DEFECTKEYFIGCUBE.DEFECTCATEGORY == TQDEFCAT.CATEGORY
  • I_DEFECTKEYFIGCUBE.MANDT == TQDEFCAT.MANDANT
Defect Code Group
  • Defect Code Group
  • ?
  • Client
  • I_DEFECTKEYFIGCUBE.DEFECTCODEGROUP == QPGR.CODEGRUPPE
  • I_DEFECTKEYFIGCUBE.[column in domain "QKATART"] == QPGR.KATALOGART
  • I_DEFECTKEYFIGCUBE.MANDT == QPGR.MANDT
Inspection Lot Origin I_DEFECTKEYFIGCUBE.INSPECTIONLOTORIGIN == TQ31.HERKUNFT
Inspection Type
  • Client
  • Inspection Type
  • I_DEFECTKEYFIGCUBE.MANDT == TQ30.MANDT
  • I_DEFECTKEYFIGCUBE.INSPECTIONLOTTYPE == TQ30.ART
Master Inspection Characteristic
  • Client
  • ?
  • Plant for Master Inspection Characteristic
  • Master Inspection Characteristic
  • I_DEFECTKEYFIGCUBE.MANDT == QPMK.MANDT
  • I_DEFECTKEYFIGCUBE.[column in domain "QVERSNRMK"] == QPMK.VERSION
  • I_DEFECTKEYFIGCUBE.INSPECTIONSPECIFICATIONPLANT == QPMK.ZAEHLER
  • I_DEFECTKEYFIGCUBE.INSPECTIONSPECIFICATION == QPMK.MKMNR
Object ID of the Work Center
  • Client
  • Work Center
  • Object ID of the Work Center
  • Work Center
  • Object types of the CIM resource
  • I_DEFECTKEYFIGCUBE.MANDT == CRID.MANDT
  • I_DEFECTKEYFIGCUBE.MAINWORKCENTER == CRID.OBJID
  • I_DEFECTKEYFIGCUBE.MAINWORKCENTERINTERNALID == CRID.OBJID
  • I_DEFECTKEYFIGCUBE.WORKCENTER == CRID.OBJID
  • I_DEFECTKEYFIGCUBE.WORKCENTERTYPECODE == CRID.OBJTY
Plant for Work Center
  • Plant for Work Center
  • Client
  • I_DEFECTKEYFIGCUBE.MAINWORKCENTERPLANT == T001W.WERKS
  • I_DEFECTKEYFIGCUBE.MANDT == T001W.MANDT
Defective Material
  • Defective Material
  • Client
  • I_DEFECTKEYFIGCUBE.MATERIAL == MARA.MATNR
  • I_DEFECTKEYFIGCUBE.MANDT == MARA.MANDT
Material Authorization Group for Activities in QM
  • Client
  • Material Authorization Group for Activities in QM
  • I_DEFECTKEYFIGCUBE.MANDT == TQ01B.MANDT
  • I_DEFECTKEYFIGCUBE.MATLQUALITYAUTHORIZATIONGROUP == TQ01B.QMATAUTH
Plant
  • Plant
  • Client
  • I_DEFECTKEYFIGCUBE.PLANT == T001W.WERKS
  • I_DEFECTKEYFIGCUBE.MANDT == T001W.MANDT
Vendor's account number
  • Vendor's account number
  • Client
  • I_DEFECTKEYFIGCUBE.SUPPLIER == LFA1.LIFNR
  • I_DEFECTKEYFIGCUBE.MANDT == LFA1.MANDT