C_DefectsByCode

Defects by Defect Code | view: CDEFECTSBYCODE | TRAN | Extraction: Not supported | Component: Defects Recording
Tables used: SCAL_TT_DATE, QALS, QMEL, QMFE, AFVC, QPCD, QPGR, QPGT, QPCT, TQDEFECTCONFIG, 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
Column Name Description
InspectionLotHasUsageDecision Checkbox Show values
IsBusinessPurposeCompleted Business Purpose Completed Flag Show values
WorkCenterTypeCode Object types of the CIM resource Show values
Column Name Description Domain name
Notification Notification Number QMNUM
NotificationItem Item Number in Item Record FELFD
Defect Defect Number QDEFECTID
DefectCodeText Text for Defect Code QKURZTEXT
DefectCode Defect Code
DefectCodeGroupText Text for Defect Code Group QKURZTEXT
DefectCodeGroupAndCode Defect Code Group and Code CHAR13
NumberOfDefects Number of Defect Occurrences
WorkCenter Work Center ARBPL
CalendarWeek Calendar Week NUM2
CalendarYear Calendar Year NUM4
SalesOrder Sales Order Number VBELN
DeliveryDocument Delivery Document VBELN
MaterialByCustomer Customer Material IDNEX
InspectionLot Inspection Lot Number QPLOS
MainWorkCenter Work Center ARBPL
Master Data Relations Join Conditions
Batch Number
  • Batch Number
  • Client
  • Defective Material
  • C_DEFECTSBYCODE.BATCH == MCH1.CHARG
  • C_DEFECTSBYCODE.MANDT == MCH1.MANDT
  • C_DEFECTSBYCODE.MATERIAL == MCH1.MATNR
Storage Location for Batch
  • Storage Location for Batch
  • ?
  • Batch Number
  • Client
  • Defective Material
  • C_DEFECTSBYCODE.BATCHSTORAGELOCATION == MCHB.LGORT
  • C_DEFECTSBYCODE.[column in domain "WERKS_D"] == MCHB.WERKS
  • C_DEFECTSBYCODE.BATCH == MCHB.CHARG
  • C_DEFECTSBYCODE.MANDT == MCHB.MANDT
  • C_DEFECTSBYCODE.MATERIAL == MCHB.MATNR
Customer (Ship-To Party)
  • Customer (Ship-To Party)
  • Client
  • C_DEFECTSBYCODE.CUSTOMER == KNA1.KUNNR
  • C_DEFECTSBYCODE.MANDT == KNA1.MANDT
Defect Category
  • Client
  • Defect Category
  • C_DEFECTSBYCODE.MANDT == TQDEFCAT.MANDANT
  • C_DEFECTSBYCODE.DEFECTCATEGORY == TQDEFCAT.CATEGORY
Defect Class
  • Client
  • Defect Class
  • C_DEFECTSBYCODE.MANDT == TQ17.MANDT
  • C_DEFECTSBYCODE.DEFECTCLASS == TQ17.FEHLKLASSE
Defect Code Group
  • Client
  • Defect Code Group
  • ?
  • C_DEFECTSBYCODE.MANDT == QPGR.MANDT
  • C_DEFECTSBYCODE.DEFECTCODEGROUP == QPGR.CODEGRUPPE
  • C_DEFECTSBYCODE.[column in domain "QKATART"] == QPGR.KATALOGART
Inspection Lot Origin C_DEFECTSBYCODE.INSPECTIONLOTORIGIN == TQ31.HERKUNFT
Inspection Type
  • Client
  • Inspection Type
  • C_DEFECTSBYCODE.MANDT == TQ30.MANDT
  • C_DEFECTSBYCODE.INSPECTIONLOTTYPE == TQ30.ART
Object ID of the Work Center
  • Client
  • Object ID of the Work Center
  • Work Center
  • Work Center
  • Object types of the CIM resource
  • C_DEFECTSBYCODE.MANDT == CRID.MANDT
  • C_DEFECTSBYCODE.MAINWORKCENTERINTERNALID == CRID.OBJID
  • C_DEFECTSBYCODE.MAINWORKCENTER == CRID.OBJID
  • C_DEFECTSBYCODE.WORKCENTER == CRID.OBJID
  • C_DEFECTSBYCODE.WORKCENTERTYPECODE == CRID.OBJTY
Plant for Work Center
  • Client
  • Plant for Work Center
  • C_DEFECTSBYCODE.MANDT == T001W.MANDT
  • C_DEFECTSBYCODE.MAINWORKCENTERPLANT == T001W.WERKS
Number of Manufacturer
  • Client
  • Number of Manufacturer
  • C_DEFECTSBYCODE.MANDT == LFA1.MANDT
  • C_DEFECTSBYCODE.MANUFACTURER == LFA1.LIFNR
Manufacturer Material
  • Manufacturer Material
  • Client
  • C_DEFECTSBYCODE.MANUFACTURERPARTNMBR == MARA.MATNR
  • C_DEFECTSBYCODE.MANDT == MARA.MANDT
Order Number (Production Order)
  • Client
  • Order Number (Production Order)
  • C_DEFECTSBYCODE.MANDT == AUFK.MANDT
  • C_DEFECTSBYCODE.MANUFACTURINGORDER == AUFK.AUFNR
Defective Material
  • Client
  • Defective Material
  • C_DEFECTSBYCODE.MANDT == MARA.MANDT
  • C_DEFECTSBYCODE.MATERIAL == MARA.MATNR
Plant
  • Client
  • Plant
  • C_DEFECTSBYCODE.MANDT == T001W.MANDT
  • C_DEFECTSBYCODE.PLANT == T001W.WERKS
Purchasing Organization
  • Purchasing Organization
  • Client
  • C_DEFECTSBYCODE.PURCHASINGORGANIZATION == T024E.EKORG
  • C_DEFECTSBYCODE.MANDT == T024E.MANDT
Sales Organization
  • Sales Organization
  • Client
  • C_DEFECTSBYCODE.SALESORGANIZATION == TVKO.VKORG
  • C_DEFECTSBYCODE.MANDT == TVKO.MANDT
Vendor's account number
  • Vendor's account number
  • Client
  • C_DEFECTSBYCODE.SUPPLIER == LFA1.LIFNR
  • C_DEFECTSBYCODE.MANDT == LFA1.MANDT