C_DefectCalcFld

Defects Calculation Fields View | view: CDEFECTCF | 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
CreationDate Date on which the record was created
Column Name Description
InspectionLotHasQuantity Posted to Inspection Stock Show values
IsBusinessPurposeCompleted Business Purpose Completed Flag Show values
WorkCenterTypeCode Object types of the CIM resource Show values
Column Name Description Domain name
CalculationDate null
InspectionLot Inspection Lot Number QPLOS
DefectCode Defect Code QCODE
DefectCodeText Text for Defect Code QKURZTEXT
MaterialName Material Description TEXT40
NumberOfDefects Defects VDM_QM_COUNTER
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_DEFECTCALCFLD.BATCHSTORAGELOCATION == MCHB.LGORT
  • C_DEFECTCALCFLD.MANDT == MCHB.MANDT
  • C_DEFECTCALCFLD.MATERIAL == MCHB.MATNR
  • C_DEFECTCALCFLD.[column in domain "WERKS_D"] == MCHB.WERKS
  • C_DEFECTCALCFLD.[column in domain "CHARG_D"] == MCHB.CHARG
Customer (Ship-To Party)
  • Customer (Ship-To Party)
  • Client
  • C_DEFECTCALCFLD.CUSTOMER == KNA1.KUNNR
  • C_DEFECTCALCFLD.MANDT == KNA1.MANDT
Defect Category
  • Defect Category
  • Client
  • C_DEFECTCALCFLD.DEFECTCATEGORY == TQDEFCAT.CATEGORY
  • C_DEFECTCALCFLD.MANDT == TQDEFCAT.MANDANT
Defect Code Group
  • ?
  • Client
  • Defect Code Group
  • C_DEFECTCALCFLD.[column in domain "QKATART"] == QPGR.KATALOGART
  • C_DEFECTCALCFLD.MANDT == QPGR.MANDT
  • C_DEFECTCALCFLD.DEFECTCODEGROUP == QPGR.CODEGRUPPE
Inspection Lot Origin C_DEFECTCALCFLD.INSPECTIONLOTORIGIN == TQ31.HERKUNFT
Inspection Type
  • Client
  • Inspection Type
  • C_DEFECTCALCFLD.MANDT == TQ30.MANDT
  • C_DEFECTCALCFLD.INSPECTIONLOTTYPE == TQ30.ART
Object ID of the Work Center
  • Work Center
  • Object ID of the Work Center
  • Object types of the CIM resource
  • Client
  • C_DEFECTCALCFLD.MAINWORKCENTER == CRID.OBJID
  • C_DEFECTCALCFLD.MAINWORKCENTERINTERNALID == CRID.OBJID
  • C_DEFECTCALCFLD.WORKCENTERTYPECODE == CRID.OBJTY
  • C_DEFECTCALCFLD.MANDT == CRID.MANDT
Plant for Work Center
  • Plant for Work Center
  • Client
  • C_DEFECTCALCFLD.MAINWORKCENTERPLANT == T001W.WERKS
  • C_DEFECTCALCFLD.MANDT == T001W.MANDT
Number of Manufacturer
  • Number of Manufacturer
  • Client
  • C_DEFECTCALCFLD.MANUFACTURER == LFA1.LIFNR
  • C_DEFECTCALCFLD.MANDT == LFA1.MANDT
Manufacturer Material
  • Manufacturer Material
  • Client
  • C_DEFECTCALCFLD.MANUFACTURERPARTNMBR == MARA.MATNR
  • C_DEFECTCALCFLD.MANDT == MARA.MANDT
Defective Material
  • Client
  • Defective Material
  • C_DEFECTCALCFLD.MANDT == MARA.MANDT
  • C_DEFECTCALCFLD.MATERIAL == MARA.MATNR
Material Authorization Group for Activities in QM
  • Material Authorization Group for Activities in QM
  • Client
  • C_DEFECTCALCFLD.MATLQUALITYAUTHORIZATIONGROUP == TQ01B.QMATAUTH
  • C_DEFECTCALCFLD.MANDT == TQ01B.MANDT
Plant
  • Plant
  • Client
  • C_DEFECTCALCFLD.PLANT == T001W.WERKS
  • C_DEFECTCALCFLD.MANDT == T001W.MANDT
Purchasing Organization
  • Purchasing Organization
  • Client
  • C_DEFECTCALCFLD.PURCHASINGORGANIZATION == T024E.EKORG
  • C_DEFECTCALCFLD.MANDT == T024E.MANDT
Sales Organization
  • Sales Organization
  • Client
  • C_DEFECTCALCFLD.SALESORGANIZATION == TVKO.VKORG
  • C_DEFECTCALCFLD.MANDT == TVKO.MANDT
Customer (Sold-To Party)
  • Customer (Sold-To Party)
  • Client
  • C_DEFECTCALCFLD.SOLDTOPARTY == KNA1.KUNNR
  • C_DEFECTCALCFLD.MANDT == KNA1.MANDT
Vendor's account number
  • Vendor's account number
  • Client
  • C_DEFECTCALCFLD.SUPPLIER == LFA1.LIFNR
  • C_DEFECTCALCFLD.MANDT == LFA1.MANDT