C_DefectKeyFigAnalyze

Defect Analytics - Key Figures | view: CDEFECTKEYFIG | 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

🔑 Keys (1)
💰 Amounts
∑ Quantities
📅 Dates (1)
☰ Categorical (3)
Other (29)
🔗 Relations (14)

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

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
InspectionCharacteristic	Inspection Characteristic Number	QMERKNRP
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_DEFECTKEYFIGANALYZE.CUSTOMER == KNA1.KUNNR` `C_DEFECTKEYFIGANALYZE.MANDT == KNA1.MANDT`
Defect Category Client Defect Category	`C_DEFECTKEYFIGANALYZE.MANDT == TQDEFCAT.MANDANT` `C_DEFECTKEYFIGANALYZE.DEFECTCATEGORY == TQDEFCAT.CATEGORY`
Defect Code Group Client Defect Code Group ?	`C_DEFECTKEYFIGANALYZE.MANDT == QPGR.MANDT` `C_DEFECTKEYFIGANALYZE.DEFECTCODEGROUP == QPGR.CODEGRUPPE` `C_DEFECTKEYFIGANALYZE.[column in domain "QKATART"] == QPGR.KATALOGART`
Inspection Lot Origin	`C_DEFECTKEYFIGANALYZE.INSPECTIONLOTORIGIN == TQ31.HERKUNFT`
Inspection Type Inspection Type Client	`C_DEFECTKEYFIGANALYZE.INSPECTIONLOTTYPE == TQ30.ART` `C_DEFECTKEYFIGANALYZE.MANDT == TQ30.MANDT`
Master Inspection Characteristic ? ? Client Master Inspection Characteristic	`C_DEFECTKEYFIGANALYZE.[column in domain "QVERSNRMK"] == QPMK.VERSION` `C_DEFECTKEYFIGANALYZE.[column in domain "QZAEHLER"] == QPMK.ZAEHLER` `C_DEFECTKEYFIGANALYZE.MANDT == QPMK.MANDT` `C_DEFECTKEYFIGANALYZE.INSPECTIONSPECIFICATION == QPMK.MKMNR`
Object ID of the Work Center Client Work Center Work Center Object ID of the Work Center Object types of the CIM resource	`C_DEFECTKEYFIGANALYZE.MANDT == CRID.MANDT` `C_DEFECTKEYFIGANALYZE.MAINWORKCENTER == CRID.OBJID` `C_DEFECTKEYFIGANALYZE.WORKCENTER == CRID.OBJID` `C_DEFECTKEYFIGANALYZE.MAINWORKCENTERINTERNALID == CRID.OBJID` `C_DEFECTKEYFIGANALYZE.WORKCENTERTYPECODE == CRID.OBJTY`
Plant for Work Center Work Center Plant Plant for Work Center Client	`C_DEFECTKEYFIGANALYZE.WORKCENTERPLANT == T001W.WERKS` `C_DEFECTKEYFIGANALYZE.MAINWORKCENTERPLANT == T001W.WERKS` `C_DEFECTKEYFIGANALYZE.MANDT == T001W.MANDT`
Defective Material Client Defective Material	`C_DEFECTKEYFIGANALYZE.MANDT == MARA.MANDT` `C_DEFECTKEYFIGANALYZE.MATERIAL == MARA.MATNR`
Material Authorization Group for Activities in QM Material Authorization Group for Activities in QM Client	`C_DEFECTKEYFIGANALYZE.MATLQUALITYAUTHORIZATIONGROUP == TQ01B.QMATAUTH` `C_DEFECTKEYFIGANALYZE.MANDT == TQ01B.MANDT`
Plant Client Plant	`C_DEFECTKEYFIGANALYZE.MANDT == T001W.MANDT` `C_DEFECTKEYFIGANALYZE.PLANT == T001W.WERKS`
Vendor's account number Vendor's account number Client	`C_DEFECTKEYFIGANALYZE.SUPPLIER == LFA1.LIFNR` `C_DEFECTKEYFIGANALYZE.MANDT == LFA1.MANDT`
Work Center Plant Work Center Plant Plant for Work Center Client	`C_DEFECTKEYFIGANALYZE.WORKCENTERPLANT == T001W.WERKS` `C_DEFECTKEYFIGANALYZE.MAINWORKCENTERPLANT == T001W.WERKS` `C_DEFECTKEYFIGANALYZE.MANDT == T001W.MANDT`