I_DefectCube

Defect Analytics Cube View | view: IDEFECTCUBE | 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_DEFECTCUBE.MANDT == TCA01.MANDT
  • I_DEFECTCUBE.BILLOFOPERATIONSTYPE == TCA01.PLNTY
Customer (Ship-To Party)
  • Customer (Ship-To Party)
  • Client
  • I_DEFECTCUBE.CUSTOMER == KNA1.KUNNR
  • I_DEFECTCUBE.MANDT == KNA1.MANDT
Defect Category
  • Client
  • Defect Category
  • I_DEFECTCUBE.MANDT == TQDEFCAT.MANDANT
  • I_DEFECTCUBE.DEFECTCATEGORY == TQDEFCAT.CATEGORY
Defect Code Group
  • Client
  • Defect Code Group
  • ?
  • I_DEFECTCUBE.MANDT == QPGR.MANDT
  • I_DEFECTCUBE.DEFECTCODEGROUP == QPGR.CODEGRUPPE
  • I_DEFECTCUBE.[column in domain "QKATART"] == QPGR.KATALOGART
Inspection Lot Origin I_DEFECTCUBE.INSPECTIONLOTORIGIN == TQ31.HERKUNFT
Inspection Type
  • Inspection Type
  • Client
  • I_DEFECTCUBE.INSPECTIONLOTTYPE == TQ30.ART
  • I_DEFECTCUBE.MANDT == TQ30.MANDT
Master Inspection Characteristic
  • Client
  • ?
  • Plant for Master Inspection Characteristic
  • Master Inspection Characteristic
  • I_DEFECTCUBE.MANDT == QPMK.MANDT
  • I_DEFECTCUBE.[column in domain "QVERSNRMK"] == QPMK.VERSION
  • I_DEFECTCUBE.INSPECTIONSPECIFICATIONPLANT == QPMK.ZAEHLER
  • I_DEFECTCUBE.INSPECTIONSPECIFICATION == QPMK.MKMNR
Object ID of the Work Center
  • Client
  • Object types of the CIM resource
  • Work Center
  • Object ID of the Work Center
  • Work Center
  • I_DEFECTCUBE.MANDT == CRID.MANDT
  • I_DEFECTCUBE.WORKCENTERTYPECODE == CRID.OBJTY
  • I_DEFECTCUBE.MAINWORKCENTER == CRID.OBJID
  • I_DEFECTCUBE.MAINWORKCENTERINTERNALID == CRID.OBJID
  • I_DEFECTCUBE.WORKCENTER == CRID.OBJID
Plant for Work Center
  • Plant for Work Center
  • Client
  • I_DEFECTCUBE.MAINWORKCENTERPLANT == T001W.WERKS
  • I_DEFECTCUBE.MANDT == T001W.MANDT
Defective Material
  • Client
  • Defective Material
  • I_DEFECTCUBE.MANDT == MARA.MANDT
  • I_DEFECTCUBE.MATERIAL == MARA.MATNR
Material Authorization Group for Activities in QM
  • Material Authorization Group for Activities in QM
  • Client
  • I_DEFECTCUBE.MATLQUALITYAUTHORIZATIONGROUP == TQ01B.QMATAUTH
  • I_DEFECTCUBE.MANDT == TQ01B.MANDT
Plant
  • Client
  • Plant
  • I_DEFECTCUBE.MANDT == T001W.MANDT
  • I_DEFECTCUBE.PLANT == T001W.WERKS
Vendor's account number
  • Vendor's account number
  • Client
  • I_DEFECTCUBE.SUPPLIER == LFA1.LIFNR
  • I_DEFECTCUBE.MANDT == LFA1.MANDT