C_MfgOrderDefectRecord

Consumption view for defect | view: CMFGORDDEFREC | Extraction: Not supported | Component: Shop Floor Execution
Column Name Description
DefectInternalID FK Internal Defect ID
Column Name Description
Column Name Description
📏 Unit of Measure for Item (DefectiveQuantityUnit):
DefectiveQuantity Defective Quantity for Item (Internal)
Column Name Description
CreationDate Date on which the record was created
LastChangeDate Last Changed On
CreationTime System Time of Creation
LastChangeTime System Time of Change
Column Name Description
DefectIsCreatedAutomatically Defect Created Automatically Show values
WorkCenterTypeCode Object types of the CIM resource Show values
IsDeleted Is Deleted Show values
DefectOrigin Origin of Item Record Show values
DefectLifecycleStatus Defect Status Show values
ProblemAnalysisStatus Problem Analysis Show values
Column Name Description Domain name
SerialNumber Serial Number GERNR
Defect Defect Number QDEFECTID
CreatedByUser Name of Person Responsible for Creating the Object USNAM
LastChangedByUser Name of Person Who Changed Object USNAM
DefectText Defect Text TEXT40
DefectCode Defect Code QCODE
DefectCodeVersion Version Number QVERSNR
DefectObjectCode Defect Location Code QCODE
DefectObjectCodeVersion Version Number QVERSNR
DefectCauseCodeCatalog Initial Defect Cause Code Catalog QKATART
DefectCauseCodeGroup Initial Defect Cause Code Group QCODEGRP
DefectCauseCode Initial Defect Cause Code QCODE
DefectCauseCodeVersion Version Number QVERSNR
ProductionOrderOperationActy Identifies an Operation Activity MPE_OAN_ELEMENT_ID
OpActyNtwkElementExternalID Element Number MPE_OAN_ELEMENT_NUMBER_EXT
OpActyNtwkElement Internal OAN Element Number
ManufacturingOrderOperation Manufacturing Order Operation VORNR
MfgOrderOperationText Operation Short Text TEXT40
ManufacturingOrder Order Number AUFNR
ManufacturingOrderText Manufacturing Order Text TEXT40
ProductionOrderOpActyVers Number of an Operation Actiivity Version
Batch Batch Number CHARG
DefectiveSingleUnit Single-Unit Number for Unit to Be Inspected QSERIALNR
ProductionOrder Order Number (Production Order) AUFNR
OrderInternalID Plan Number for Operations in Order (Production Order) AUFPL
NumberOfDefects Number of Defect Occurrences QANZAHL4
InspPlanOperationInternalID Current Node Number from Order Counter KNTNR
InspectionCharacteristic Inspection Characteristic Number QMERKNRP
MainWorkCenter Work Center ARBPL
Equipment Equipment Number EQUNR
FunctionalLocation Functional Location TPLNR
InspectionLot Inspection Lot Number QPLOS
CatalogProfile Catalog Profile RBNR
ChangedDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
DefectLifecycleStatusText Defect Status Text VDM_QM_TEXT60
QualityIssueReference External Reference Number QEXTREFNUM
MasterLanguage Primary language indicator for text segment CHAR1
NotificationText Short Text TEXT40
NotificationItem Item Number in Item Record
MfgDefectDecision Defect decision
MfgDefectDecisionName Defect decision Text DDTEXT
SitnNumberOfInstances Number of Situations INT4
BOMItemInstanceUUID Internal Identification for DMU Objects of Type RAW 16 DMU_GUID16
ProducedMaterial Material Number MATNR
ProducedSerialNumber Serial Number GERNR
Master Data Relations Join Conditions
Defect Category
  • Client
  • Defect Category
  • C_MFGORDERDEFECTRECORD.MANDT == TQDEFCAT.MANDANT
  • C_MFGORDERDEFECTRECORD.DEFECTCATEGORY == TQDEFCAT.CATEGORY
Defect Class
  • Defect Class
  • Client
  • C_MFGORDERDEFECTRECORD.DEFECTCLASS == TQ17.FEHLKLASSE
  • C_MFGORDERDEFECTRECORD.MANDT == TQ17.MANDT
Catalog Type - Problems/Defects
  • Catalog Type - Problems/Defects
  • Client
  • C_MFGORDERDEFECTRECORD.DEFECTCODECATALOG == TQ15.KATALOGART
  • C_MFGORDERDEFECTRECORD.MANDT == TQ15.MANDT
Defect Code Group
  • Catalog Type - Problems/Defects
  • Defect Code Group
  • Client
  • C_MFGORDERDEFECTRECORD.DEFECTCODECATALOG == QPGR.KATALOGART
  • C_MFGORDERDEFECTRECORD.DEFECTCODEGROUP == QPGR.CODEGRUPPE
  • C_MFGORDERDEFECTRECORD.MANDT == QPGR.MANDT
Unit of Measure for Item
  • Unit of Measure for Item
  • Client
  • C_MFGORDERDEFECTRECORD.DEFECTIVEQUANTITYUNIT == T006.MSEHI
  • C_MFGORDERDEFECTRECORD.MANDT == T006.MANDT
Defect Location Catalog
  • Client
  • Defect Location Catalog
  • C_MFGORDERDEFECTRECORD.MANDT == TQ15.MANDT
  • C_MFGORDERDEFECTRECORD.DEFECTOBJECTCODECATALOG == TQ15.KATALOGART
Defect Location Code Group
  • Client
  • Defect Location Code Group
  • Defect Location Catalog
  • C_MFGORDERDEFECTRECORD.MANDT == QPGR.MANDT
  • C_MFGORDERDEFECTRECORD.DEFECTOBJECTCODEGROUP == QPGR.CODEGRUPPE
  • C_MFGORDERDEFECTRECORD.DEFECTOBJECTCODECATALOG == QPGR.KATALOGART
Object ID of the Work Center
  • Object ID of the Work Center
  • Work Center
  • Client
  • Object types of the CIM resource
  • C_MFGORDERDEFECTRECORD.MAINWORKCENTERINTERNALID == CRID.OBJID
  • C_MFGORDERDEFECTRECORD.MAINWORKCENTER == CRID.OBJID
  • C_MFGORDERDEFECTRECORD.MANDT == CRID.MANDT
  • C_MFGORDERDEFECTRECORD.WORKCENTERTYPECODE == CRID.OBJTY
Plant for Work Center
  • Client
  • Plant for Work Center
  • C_MFGORDERDEFECTRECORD.MANDT == T001W.MANDT
  • C_MFGORDERDEFECTRECORD.MAINWORKCENTERPLANT == T001W.WERKS
Defective Material
  • Client
  • Defective Material
  • C_MFGORDERDEFECTRECORD.MANDT == MARA.MANDT
  • C_MFGORDERDEFECTRECORD.MATERIAL == MARA.MATNR
Plant
  • Client
  • Plant
  • C_MFGORDERDEFECTRECORD.MANDT == T001W.MANDT
  • C_MFGORDERDEFECTRECORD.PLANT == T001W.WERKS