C_InspOriginDefects

Defects by Insp Origin | view: CINSPORIGNDEFECT | TRAN | Extraction: Not supported | Component: Defects Recording
Tables used: SCAL_TT_DATE, QALS, QMEL, QMFE, AFVC, TQDEFECTCONFIG, TQ31, TQ31T, 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
InspectionLotOriginText Inspection Lot Origin Text QKURZTEXT
NumberOfDefects Number of Defect Occurrences
DefectCode Defect Code QCODE
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_INSPORIGINDEFECTS.BATCH == MCH1.CHARG
  • C_INSPORIGINDEFECTS.MANDT == MCH1.MANDT
  • C_INSPORIGINDEFECTS.MATERIAL == MCH1.MATNR
Storage Location for Batch
  • Batch Number
  • ?
  • Client
  • Storage Location for Batch
  • Defective Material
  • C_INSPORIGINDEFECTS.BATCH == MCHB.CHARG
  • C_INSPORIGINDEFECTS.[column in domain "WERKS_D"] == MCHB.WERKS
  • C_INSPORIGINDEFECTS.MANDT == MCHB.MANDT
  • C_INSPORIGINDEFECTS.BATCHSTORAGELOCATION == MCHB.LGORT
  • C_INSPORIGINDEFECTS.MATERIAL == MCHB.MATNR
Customer (Ship-To Party)
  • Customer (Ship-To Party)
  • Client
  • C_INSPORIGINDEFECTS.CUSTOMER == KNA1.KUNNR
  • C_INSPORIGINDEFECTS.MANDT == KNA1.MANDT
Defect Category
  • Defect Category
  • Client
  • C_INSPORIGINDEFECTS.DEFECTCATEGORY == TQDEFCAT.CATEGORY
  • C_INSPORIGINDEFECTS.MANDT == TQDEFCAT.MANDANT
Defect Class
  • Defect Class
  • Client
  • C_INSPORIGINDEFECTS.DEFECTCLASS == TQ17.FEHLKLASSE
  • C_INSPORIGINDEFECTS.MANDT == TQ17.MANDT
Defect Code Group
  • Defect Code Group
  • ?
  • Client
  • C_INSPORIGINDEFECTS.DEFECTCODEGROUP == QPGR.CODEGRUPPE
  • C_INSPORIGINDEFECTS.[column in domain "QKATART"] == QPGR.KATALOGART
  • C_INSPORIGINDEFECTS.MANDT == QPGR.MANDT
Inspection Lot Origin C_INSPORIGINDEFECTS.INSPECTIONLOTORIGIN == TQ31.HERKUNFT
Inspection Type
  • Inspection Type
  • Client
  • C_INSPORIGINDEFECTS.INSPECTIONLOTTYPE == TQ30.ART
  • C_INSPORIGINDEFECTS.MANDT == TQ30.MANDT
Object ID of the Work Center
  • Object types of the CIM resource
  • Client
  • Object ID of the Work Center
  • Work Center
  • Work Center
  • C_INSPORIGINDEFECTS.WORKCENTERTYPECODE == CRID.OBJTY
  • C_INSPORIGINDEFECTS.MANDT == CRID.MANDT
  • C_INSPORIGINDEFECTS.MAINWORKCENTERINTERNALID == CRID.OBJID
  • C_INSPORIGINDEFECTS.WORKCENTER == CRID.OBJID
  • C_INSPORIGINDEFECTS.MAINWORKCENTER == CRID.OBJID
Plant for Work Center
  • Plant for Work Center
  • Client
  • C_INSPORIGINDEFECTS.MAINWORKCENTERPLANT == T001W.WERKS
  • C_INSPORIGINDEFECTS.MANDT == T001W.MANDT
Number of Manufacturer
  • Client
  • Number of Manufacturer
  • C_INSPORIGINDEFECTS.MANDT == LFA1.MANDT
  • C_INSPORIGINDEFECTS.MANUFACTURER == LFA1.LIFNR
Manufacturer Material
  • Manufacturer Material
  • Client
  • C_INSPORIGINDEFECTS.MANUFACTURERPARTNMBR == MARA.MATNR
  • C_INSPORIGINDEFECTS.MANDT == MARA.MANDT
Order Number (Production Order)
  • Order Number (Production Order)
  • Client
  • C_INSPORIGINDEFECTS.MANUFACTURINGORDER == AUFK.AUFNR
  • C_INSPORIGINDEFECTS.MANDT == AUFK.MANDT
Defective Material
  • Client
  • Defective Material
  • C_INSPORIGINDEFECTS.MANDT == MARA.MANDT
  • C_INSPORIGINDEFECTS.MATERIAL == MARA.MATNR
Plant
  • Plant
  • Client
  • C_INSPORIGINDEFECTS.PLANT == T001W.WERKS
  • C_INSPORIGINDEFECTS.MANDT == T001W.MANDT
Purchasing Organization
  • Purchasing Organization
  • Client
  • C_INSPORIGINDEFECTS.PURCHASINGORGANIZATION == T024E.EKORG
  • C_INSPORIGINDEFECTS.MANDT == T024E.MANDT
Sales Organization
  • Sales Organization
  • Client
  • C_INSPORIGINDEFECTS.SALESORGANIZATION == TVKO.VKORG
  • C_INSPORIGINDEFECTS.MANDT == TVKO.MANDT
Vendor's account number
  • Client
  • Vendor's account number
  • C_INSPORIGINDEFECTS.MANDT == LFA1.MANDT
  • C_INSPORIGINDEFECTS.SUPPLIER == LFA1.LIFNR