C_DefectsByMatl

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