C_MatlDefect

Defects by Material | view: CMATLDEFECT | TRAN | Extraction: Not supported | Component: Defects Recording

Tables used: SCAL_TT_DATE, QALS, QMEL, QMFE, AFVC, TQDEFECTCONFIG, MARA, MAKT, CRHD

🔑 Keys (1)
💰 Amounts
∑ Quantities
📅 Dates (1)
☰ Categorical (3)
Other (14)
🔗 Relations (20)

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
MaterialName	Material Description	TEXT40
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 Client Defective Material Batch Number	`C_MATLDEFECT.MANDT == MCH1.MANDT` `C_MATLDEFECT.MATERIAL == MCH1.MATNR` `C_MATLDEFECT.BATCH == MCH1.CHARG`
Storage Location for Batch Client Storage Location for Batch Defective Material ? Batch Number	`C_MATLDEFECT.MANDT == MCHB.MANDT` `C_MATLDEFECT.BATCHSTORAGELOCATION == MCHB.LGORT` `C_MATLDEFECT.MATERIAL == MCHB.MATNR` `C_MATLDEFECT.[column in domain "WERKS_D"] == MCHB.WERKS` `C_MATLDEFECT.BATCH == MCHB.CHARG`
Customer (Ship-To Party) Client Customer (Ship-To Party)	`C_MATLDEFECT.MANDT == KNA1.MANDT` `C_MATLDEFECT.CUSTOMER == KNA1.KUNNR`
Defect Category Client Defect Category	`C_MATLDEFECT.MANDT == TQDEFCAT.MANDANT` `C_MATLDEFECT.DEFECTCATEGORY == TQDEFCAT.CATEGORY`
Defect Class Client Defect Class	`C_MATLDEFECT.MANDT == TQ17.MANDT` `C_MATLDEFECT.DEFECTCLASS == TQ17.FEHLKLASSE`
Defect Code Group Client Defect Code Group ?	`C_MATLDEFECT.MANDT == QPGR.MANDT` `C_MATLDEFECT.DEFECTCODEGROUP == QPGR.CODEGRUPPE` `C_MATLDEFECT.[column in domain "QKATART"] == QPGR.KATALOGART`
Inspection Lot Origin	`C_MATLDEFECT.INSPECTIONLOTORIGIN == TQ31.HERKUNFT`
Inspection Type Client Inspection Type	`C_MATLDEFECT.MANDT == TQ30.MANDT` `C_MATLDEFECT.INSPECTIONLOTTYPE == TQ30.ART`
Object ID of the Work Center Work Center Work Center Object ID of the Work Center Object types of the CIM resource Client	`C_MATLDEFECT.WORKCENTER == CRID.OBJID` `C_MATLDEFECT.MAINWORKCENTER == CRID.OBJID` `C_MATLDEFECT.MAINWORKCENTERINTERNALID == CRID.OBJID` `C_MATLDEFECT.WORKCENTERTYPECODE == CRID.OBJTY` `C_MATLDEFECT.MANDT == CRID.MANDT`
Plant for Work Center Client Plant for Work Center	`C_MATLDEFECT.MANDT == T001W.MANDT` `C_MATLDEFECT.MAINWORKCENTERPLANT == T001W.WERKS`
Number of Manufacturer Client Number of Manufacturer	`C_MATLDEFECT.MANDT == LFA1.MANDT` `C_MATLDEFECT.MANUFACTURER == LFA1.LIFNR`
Manufacturer Material Manufacturer Material Client	`C_MATLDEFECT.MANUFACTURERPARTNMBR == MARA.MATNR` `C_MATLDEFECT.MANDT == MARA.MANDT`
Order Number (Production Order) Client Order Number (Production Order)	`C_MATLDEFECT.MANDT == AUFK.MANDT` `C_MATLDEFECT.MANUFACTURINGORDER == AUFK.AUFNR`
Defective Material Client Defective Material	`C_MATLDEFECT.MANDT == MARA.MANDT` `C_MATLDEFECT.MATERIAL == MARA.MATNR`
Plant Client Plant	`C_MATLDEFECT.MANDT == T001W.MANDT` `C_MATLDEFECT.PLANT == T001W.WERKS`
Purchasing Organization Purchasing Organization Client	`C_MATLDEFECT.PURCHASINGORGANIZATION == T024E.EKORG` `C_MATLDEFECT.MANDT == T024E.MANDT`
Sales Organization Client Sales Organization	`C_MATLDEFECT.MANDT == TVKO.MANDT` `C_MATLDEFECT.SALESORGANIZATION == TVKO.VKORG`
Vendor's account number Client Vendor's account number	`C_MATLDEFECT.MANDT == LFA1.MANDT` `C_MATLDEFECT.SUPPLIER == LFA1.LIFNR`