C_DefectAnalyze

Nonconformance Detailed Analytics | view: CDEFECTANALYZE | TRAN | Extraction: Not supported | Component: Defect Analytics
Tables used: SCAL_TT_DATE, QAMV, QALS, AFVC, QAOP, QMEL, QMFE, AFVC, KNA1, TQDEFCAT, TQDEFCCAT, TQDEFCATT, TQDEFCCATT, QPCD, QPGR, QPGT, QPCT, TQDEFECTCONFIG, QPMT, MAKT, T001W, CRTX, LFA1, CRHD, TQDEFCCATSTTGS
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
NotificationRequiredStartDate Required start date
Column Name Description
DefectLifecycleStatus Defect Status Show values
IsBusinessPurposeCompleted Business Purpose Completed Flag Show values
WorkCenterTypeCode Object types of the CIM resource Show values
Column Name Description Domain name
InspectionLot Inspection Lot Number QPLOS
DefectCategoryText Defect Category Text QKURZTEXT
CalendarYear Calendar Year NUM4
CalendarQuarter Calendar Quarter NUM1
CalendarQuarterName Short Text for Fixed Values DDTEXT
CalendarMonth Calendar Month NUM2
CalendarMonthName Short Text for Fixed Values DDTEXT
CalendarWeek Calendar Week NUM2
DefectCodeText Text for Defect Code QKURZTEXT
DefectCode Defect Code QCODE
DefectCodeGroupText Text for Defect Code Group QKURZTEXT
WorkCenterText Work Center Text TEXT40
WorkCenter Work Center ARBPL
PlantName Plant Name TEXT30
SupplierName Name of Supplier TEXT80
MaterialName Material Description TEXT40
CustomerFullName Customer Full Name TEXT220
InspResultHistoryCharc Inspection Characteristic Key for Results History
InspectionCharacteristicText Short Text for Inspection Characteristic QKURZTEXT
MasterInspCharcsKey Master Inspection Characteristic TEXT24
InspectionSpecificationText Short Text QKURZTEXT
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
NotificationType Notification Type QMART
NotifRqdStrtYr Quality Notification Required Start Year NUM4
NotifRqdStrtQtr Quality Notification Required Start Quarter NUM1
NotifRqdStrtMnth Quality Notification Required Start Month NUM2
NotifRqdStrtWk Quality Notification Required Start Week NUM2
QualityNotificationCount No. of Quality Notifications VDM_QM_COUNTER
Notification Notification Number QMNUM
NotificationItem Item Number in Item Record FELFD
WorkCenterPlantName Plant Name TEXT30
MainWorkCenter Work Center ARBPL
Master Data Relations Join Conditions
Customer (Ship-To Party)
  • Customer (Ship-To Party)
  • Client
  • C_DEFECTANALYZE.CUSTOMER == KNA1.KUNNR
  • C_DEFECTANALYZE.MANDT == KNA1.MANDT
Defect Category
  • Defect Category
  • Client
  • C_DEFECTANALYZE.DEFECTCATEGORY == TQDEFCAT.CATEGORY
  • C_DEFECTANALYZE.MANDT == TQDEFCAT.MANDANT
Defect Code Group
  • Defect Code Group
  • Client
  • ?
  • C_DEFECTANALYZE.DEFECTCODEGROUP == QPGR.CODEGRUPPE
  • C_DEFECTANALYZE.MANDT == QPGR.MANDT
  • C_DEFECTANALYZE.[column in domain "QKATART"] == QPGR.KATALOGART
Inspection Lot Origin C_DEFECTANALYZE.INSPECTIONLOTORIGIN == TQ31.HERKUNFT
Inspection Type
  • Inspection Type
  • Client
  • C_DEFECTANALYZE.INSPECTIONLOTTYPE == TQ30.ART
  • C_DEFECTANALYZE.MANDT == TQ30.MANDT
Object ID of the Work Center
  • Object types of the CIM resource
  • Client
  • Work Center
  • Object ID of the Work Center
  • Work Center
  • C_DEFECTANALYZE.WORKCENTERTYPECODE == CRID.OBJTY
  • C_DEFECTANALYZE.MANDT == CRID.MANDT
  • C_DEFECTANALYZE.MAINWORKCENTER == CRID.OBJID
  • C_DEFECTANALYZE.MAINWORKCENTERINTERNALID == CRID.OBJID
  • C_DEFECTANALYZE.WORKCENTER == CRID.OBJID
Plant for Work Center
  • Plant for Work Center
  • Work Center Plant
  • Client
  • C_DEFECTANALYZE.MAINWORKCENTERPLANT == T001W.WERKS
  • C_DEFECTANALYZE.WORKCENTERPLANT == T001W.WERKS
  • C_DEFECTANALYZE.MANDT == T001W.MANDT
Defective Material
  • Defective Material
  • Client
  • C_DEFECTANALYZE.MATERIAL == MARA.MATNR
  • C_DEFECTANALYZE.MANDT == MARA.MANDT
Material Authorization Group for Activities in QM
  • Client
  • Material Authorization Group for Activities in QM
  • C_DEFECTANALYZE.MANDT == TQ01B.MANDT
  • C_DEFECTANALYZE.MATLQUALITYAUTHORIZATIONGROUP == TQ01B.QMATAUTH
Plant
  • Plant
  • Client
  • C_DEFECTANALYZE.PLANT == T001W.WERKS
  • C_DEFECTANALYZE.MANDT == T001W.MANDT
Vendor's account number
  • Vendor's account number
  • Client
  • C_DEFECTANALYZE.SUPPLIER == LFA1.LIFNR
  • C_DEFECTANALYZE.MANDT == LFA1.MANDT
Work Center Plant
  • Plant for Work Center
  • Work Center Plant
  • Client
  • C_DEFECTANALYZE.MAINWORKCENTERPLANT == T001W.WERKS
  • C_DEFECTANALYZE.WORKCENTERPLANT == T001W.WERKS
  • C_DEFECTANALYZE.MANDT == T001W.MANDT