C_DefectsByDefectCode

Defects By Defect Code View | view: CDEFSBYDEFCODE | Extraction: Not supported | Component: Defect Analytics
Tables used: QALS, QMEL, QMFE, AFVC, QPCD, QPCT, TQDEFECTCONFIG, MARA, MAKT, CRHD
Column Name Description
Defect Defect Number
Column Name Description
Column Name Description
Column Name Description
Column Name Description
InspectionLotHasQuantity Checkbox Show values
WorkCenterTypeCode Object types of the CIM resource Show values
Column Name Description Domain name
DefectCode Defect Code
DefectCodeText Text for Defect Code QKURZTEXT
NumberOfDefects Defects
CalculationDate null
InspectionLot Inspection Lot Number QPLOS
MainWorkCenter Work Center ARBPL
Notification Notification Number QMNUM
Master Data Relations Join Conditions
Storage Location for Batch
  • ?
  • Storage Location for Batch
  • Client
  • Defective Material
  • ?
  • C_DEFECTSBYDEFECTCODE.[column in domain "CHARG_D"] == MCHB.CHARG
  • C_DEFECTSBYDEFECTCODE.BATCHSTORAGELOCATION == MCHB.LGORT
  • C_DEFECTSBYDEFECTCODE.MANDT == MCHB.MANDT
  • C_DEFECTSBYDEFECTCODE.MATERIAL == MCHB.MATNR
  • C_DEFECTSBYDEFECTCODE.[column in domain "WERKS_D"] == MCHB.WERKS
Customer (Ship-To Party)
  • Customer (Ship-To Party)
  • Client
  • C_DEFECTSBYDEFECTCODE.CUSTOMER == KNA1.KUNNR
  • C_DEFECTSBYDEFECTCODE.MANDT == KNA1.MANDT
Defect Category
  • Defect Category
  • Client
  • C_DEFECTSBYDEFECTCODE.DEFECTCATEGORY == TQDEFCAT.CATEGORY
  • C_DEFECTSBYDEFECTCODE.MANDT == TQDEFCAT.MANDANT
Defect Code Group
  • Defect Code Group
  • Client
  • ?
  • C_DEFECTSBYDEFECTCODE.DEFECTCODEGROUP == QPGR.CODEGRUPPE
  • C_DEFECTSBYDEFECTCODE.MANDT == QPGR.MANDT
  • C_DEFECTSBYDEFECTCODE.[column in domain "QKATART"] == QPGR.KATALOGART
Inspection Lot Origin C_DEFECTSBYDEFECTCODE.INSPECTIONLOTORIGIN == TQ31.HERKUNFT
Inspection Type
  • Client
  • Inspection Type
  • C_DEFECTSBYDEFECTCODE.MANDT == TQ30.MANDT
  • C_DEFECTSBYDEFECTCODE.INSPECTIONLOTTYPE == TQ30.ART
Object ID of the Work Center
  • Client
  • Object ID of the Work Center
  • Work Center
  • Object types of the CIM resource
  • C_DEFECTSBYDEFECTCODE.MANDT == CRID.MANDT
  • C_DEFECTSBYDEFECTCODE.MAINWORKCENTERINTERNALID == CRID.OBJID
  • C_DEFECTSBYDEFECTCODE.MAINWORKCENTER == CRID.OBJID
  • C_DEFECTSBYDEFECTCODE.WORKCENTERTYPECODE == CRID.OBJTY
Plant for Work Center
  • Client
  • Plant for Work Center
  • C_DEFECTSBYDEFECTCODE.MANDT == T001W.MANDT
  • C_DEFECTSBYDEFECTCODE.MAINWORKCENTERPLANT == T001W.WERKS
Number of Manufacturer
  • Number of Manufacturer
  • Client
  • C_DEFECTSBYDEFECTCODE.MANUFACTURER == LFA1.LIFNR
  • C_DEFECTSBYDEFECTCODE.MANDT == LFA1.MANDT
Manufacturer Material
  • Manufacturer Material
  • Client
  • C_DEFECTSBYDEFECTCODE.MANUFACTURERPARTNMBR == MARA.MATNR
  • C_DEFECTSBYDEFECTCODE.MANDT == MARA.MANDT
Defective Material
  • Client
  • Defective Material
  • C_DEFECTSBYDEFECTCODE.MANDT == MARA.MANDT
  • C_DEFECTSBYDEFECTCODE.MATERIAL == MARA.MATNR
Material Authorization Group for Activities in QM
  • Client
  • Material Authorization Group for Activities in QM
  • C_DEFECTSBYDEFECTCODE.MANDT == TQ01B.MANDT
  • C_DEFECTSBYDEFECTCODE.MATLQUALITYAUTHORIZATIONGROUP == TQ01B.QMATAUTH
Plant
  • Plant
  • Client
  • C_DEFECTSBYDEFECTCODE.PLANT == T001W.WERKS
  • C_DEFECTSBYDEFECTCODE.MANDT == T001W.MANDT
Purchasing Organization
  • Purchasing Organization
  • Client
  • C_DEFECTSBYDEFECTCODE.PURCHASINGORGANIZATION == T024E.EKORG
  • C_DEFECTSBYDEFECTCODE.MANDT == T024E.MANDT
Sales Organization
  • Sales Organization
  • Client
  • C_DEFECTSBYDEFECTCODE.SALESORGANIZATION == TVKO.VKORG
  • C_DEFECTSBYDEFECTCODE.MANDT == TVKO.MANDT
Customer (Sold-To Party)
  • Client
  • Customer (Sold-To Party)
  • C_DEFECTSBYDEFECTCODE.MANDT == KNA1.MANDT
  • C_DEFECTSBYDEFECTCODE.SOLDTOPARTY == KNA1.KUNNR
Vendor's account number
  • Client
  • Vendor's account number
  • C_DEFECTSBYDEFECTCODE.MANDT == LFA1.MANDT
  • C_DEFECTSBYDEFECTCODE.SUPPLIER == LFA1.LIFNR