C_DefectRecord

Record Defect | view: CDEFREC | TRAN | Extraction: Not supported | Component: Defects Recording

Tables used: AFKO, QMEL, QMFE, AFPO, AFVC, QPROBSOLVPROC, QPRBSLVPRCDREF, TQDEFECTCONFIG, AUFK, CRHD

🔑 Keys (1)
💰 Amounts
∑ Quantities (1)
📅 Dates (4)
☰ Categorical (5)
Other (26)
🔗 Relations (14)

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
CreationTime	System Time of Creation
LastChangeDate	Last Changed On
LastChangeTime	System Time of Change

Column Name	Description
DefectLifecycleStatus	Defect Status	Show values
IsDeleted	Is Deleted	Show values
ProblemAnalysisStatus	Problem Analysis	Show values
ManufacturingOrderCategory	Order Category	Show values
WorkCenterTypeCode	Object types of the CIM resource	Show values

Column Name	Description	Domain name
Defect	Defect Number	QDEFECTID
DefectCode	Defect Code	QCODE
QualityIssueReference	External Reference Number	QEXTREFNUM
DefectText	Defect Text	TEXT40
NotificationItemExternalID	Quality Notification External Item Number	QFELFD
MasterLanguage	Primary language indicator for text segment	CHAR1
Batch	Batch Number	CHARG
StorageLocation	Storage location	LGORT
NumberOfDefects	Number of Defect Occurrences	QANZAHL4
CreatedByUser	Name of Person Responsible for Creating the Object	USNAM
LastChangedByUser	Name of Person Who Changed Object	USNAM
InspectionLot	Inspection Lot Number	QPLOS
InspPlanOperationInternalID	Current Node Number from Order Counter	KNTNR
InspectionCharacteristic	Inspection Characteristic Number	QMERKNRP
ProductionOrder	Order Number (Production Order)	AUFNR
ProductionOrderSequence	Sequence	PLNFOLGE
MfgOrderSequenceText	Manufacturing Order Sequence Text	TEXT40
ProductionOrderOperation	Operation/Activity Number	VORNR
MainWorkCenter	Work Center	ARBPL
DefectConfigurationValue	Defect Configuration
ProductionSupplyArea	Production Supply Area	PRVBE
Warehouse	Warehouse Number/Warehouse Complex	/SCWM/LGNUM
StorageType	Source Storage Type	/SCWM/LGTYP
SourceStorageBin	Source Storage Bin	/SCWM/LGPLA
DefectCausedBy	Defect Caused By	QDEFECTCAUSEDBY
ProbSolvingProc	Problem-Solving Process	QPROBSOLVINGPROCESS

Master Data Relations	Join Conditions
Cost Center Cost Center Client ? ?	`C_DEFECTRECORD.COSTCENTER == CSKS.KOSTL` `C_DEFECTRECORD.MANDT == CSKS.MANDT` `C_DEFECTRECORD.[column in domain "DATBI"] == CSKS.DATBI` `C_DEFECTRECORD.[column in domain "KOKRS"] == CSKS.KOKRS`
Defect Category Client Defect Category	`C_DEFECTRECORD.MANDT == TQDEFCAT.MANDANT` `C_DEFECTRECORD.DEFECTCATEGORY == TQDEFCAT.CATEGORY`
Defect Class Defect Class Client	`C_DEFECTRECORD.DEFECTCLASS == TQ17.FEHLKLASSE` `C_DEFECTRECORD.MANDT == TQ17.MANDT`
Catalog Type - Problems/Defects Client Catalog Type - Problems/Defects	`C_DEFECTRECORD.MANDT == TQ15.MANDT` `C_DEFECTRECORD.DEFECTCODECATALOG == TQ15.KATALOGART`
Defect Code Group Defect Code Group Client Catalog Type - Problems/Defects	`C_DEFECTRECORD.DEFECTCODEGROUP == QPGR.CODEGRUPPE` `C_DEFECTRECORD.MANDT == QPGR.MANDT` `C_DEFECTRECORD.DEFECTCODECATALOG == QPGR.KATALOGART`
Unit of Measure for Item Client Unit of Measure for Item	`C_DEFECTRECORD.MANDT == T006.MANDT` `C_DEFECTRECORD.DEFECTIVEQUANTITYUNIT == T006.MSEHI`
Object ID of the Work Center Object types of the CIM resource Client Work Center Object ID of the Work Center	`C_DEFECTRECORD.WORKCENTERTYPECODE == CRID.OBJTY` `C_DEFECTRECORD.MANDT == CRID.MANDT` `C_DEFECTRECORD.MAINWORKCENTER == CRID.OBJID` `C_DEFECTRECORD.MAINWORKCENTERINTERNALID == CRID.OBJID`
Plant for Work Center Client Plant for Work Center	`C_DEFECTRECORD.MANDT == T001W.MANDT` `C_DEFECTRECORD.MAINWORKCENTERPLANT == T001W.WERKS`
Defective Material Client Defective Material	`C_DEFECTRECORD.MANDT == MARA.MANDT` `C_DEFECTRECORD.MATERIAL == MARA.MATNR`
Plant Client Plant	`C_DEFECTRECORD.MANDT == T001W.MANDT` `C_DEFECTRECORD.PLANT == T001W.WERKS`