C_DefectsByInspLotOrign

Defects By Inspection Lot Origin View | view: CDEFSBYLOTORIGN | Extraction: Not supported | Component: Defect Analytics

Tables used: QALS, QMEL, QMFE, AFVC, QPCD, QPCT, TQDEFECTCONFIG, TQ31, TQ31T, MARA, MAKT, CRHD

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

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	Checkbox	Show values
IsBusinessPurposeCompleted	Business Purpose Completed Flag	Show values
WorkCenterTypeCode	Object types of the CIM resource	Show values

Column Name	Description	Domain name
DefectCodeText	Text for Defect Code	QKURZTEXT
CalculationDate	null
InspectionLot	Inspection Lot Number	QPLOS
InspectionLotOrigin	null
NumberOfDefects	null
DefectCode	Defect Code	QCODE
InspectionLotOriginText	Inspection Lot Origin Text
MainWorkCenter	Work Center	ARBPL
Notification	Notification Number	QMNUM

Master Data Relations	Join Conditions
Storage Location for Batch Defective Material ? ? Storage Location for Batch Client	`C_DEFECTSBYINSPLOTORIGN.MATERIAL == MCHB.MATNR` `C_DEFECTSBYINSPLOTORIGN.[column in domain "WERKS_D"] == MCHB.WERKS` `C_DEFECTSBYINSPLOTORIGN.[column in domain "CHARG_D"] == MCHB.CHARG` `C_DEFECTSBYINSPLOTORIGN.BATCHSTORAGELOCATION == MCHB.LGORT` `C_DEFECTSBYINSPLOTORIGN.MANDT == MCHB.MANDT`
Customer (Ship-To Party) Customer (Ship-To Party) Client	`C_DEFECTSBYINSPLOTORIGN.CUSTOMER == KNA1.KUNNR` `C_DEFECTSBYINSPLOTORIGN.MANDT == KNA1.MANDT`
Defect Category Defect Category Client	`C_DEFECTSBYINSPLOTORIGN.DEFECTCATEGORY == TQDEFCAT.CATEGORY` `C_DEFECTSBYINSPLOTORIGN.MANDT == TQDEFCAT.MANDANT`
Defect Code Group ? Defect Code Group Client	`C_DEFECTSBYINSPLOTORIGN.[column in domain "QKATART"] == QPGR.KATALOGART` `C_DEFECTSBYINSPLOTORIGN.DEFECTCODEGROUP == QPGR.CODEGRUPPE` `C_DEFECTSBYINSPLOTORIGN.MANDT == QPGR.MANDT`
Inspection Type Inspection Type Client	`C_DEFECTSBYINSPLOTORIGN.INSPECTIONLOTTYPE == TQ30.ART` `C_DEFECTSBYINSPLOTORIGN.MANDT == TQ30.MANDT`
Object ID of the Work Center Object ID of the Work Center Work Center Object types of the CIM resource Client	`C_DEFECTSBYINSPLOTORIGN.MAINWORKCENTERINTERNALID == CRID.OBJID` `C_DEFECTSBYINSPLOTORIGN.MAINWORKCENTER == CRID.OBJID` `C_DEFECTSBYINSPLOTORIGN.WORKCENTERTYPECODE == CRID.OBJTY` `C_DEFECTSBYINSPLOTORIGN.MANDT == CRID.MANDT`
Plant for Work Center Plant for Work Center Client	`C_DEFECTSBYINSPLOTORIGN.MAINWORKCENTERPLANT == T001W.WERKS` `C_DEFECTSBYINSPLOTORIGN.MANDT == T001W.MANDT`
Number of Manufacturer Number of Manufacturer Client	`C_DEFECTSBYINSPLOTORIGN.MANUFACTURER == LFA1.LIFNR` `C_DEFECTSBYINSPLOTORIGN.MANDT == LFA1.MANDT`
Manufacturer Material Manufacturer Material Client	`C_DEFECTSBYINSPLOTORIGN.MANUFACTURERPARTNMBR == MARA.MATNR` `C_DEFECTSBYINSPLOTORIGN.MANDT == MARA.MANDT`
Defective Material Defective Material Client	`C_DEFECTSBYINSPLOTORIGN.MATERIAL == MARA.MATNR` `C_DEFECTSBYINSPLOTORIGN.MANDT == MARA.MANDT`
Material Authorization Group for Activities in QM Client Material Authorization Group for Activities in QM	`C_DEFECTSBYINSPLOTORIGN.MANDT == TQ01B.MANDT` `C_DEFECTSBYINSPLOTORIGN.MATLQUALITYAUTHORIZATIONGROUP == TQ01B.QMATAUTH`
Plant Plant Client	`C_DEFECTSBYINSPLOTORIGN.PLANT == T001W.WERKS` `C_DEFECTSBYINSPLOTORIGN.MANDT == T001W.MANDT`
Purchasing Organization Purchasing Organization Client	`C_DEFECTSBYINSPLOTORIGN.PURCHASINGORGANIZATION == T024E.EKORG` `C_DEFECTSBYINSPLOTORIGN.MANDT == T024E.MANDT`
Sales Organization Sales Organization Client	`C_DEFECTSBYINSPLOTORIGN.SALESORGANIZATION == TVKO.VKORG` `C_DEFECTSBYINSPLOTORIGN.MANDT == TVKO.MANDT`
Customer (Sold-To Party) Customer (Sold-To Party) Client	`C_DEFECTSBYINSPLOTORIGN.SOLDTOPARTY == KNA1.KUNNR` `C_DEFECTSBYINSPLOTORIGN.MANDT == KNA1.MANDT`
Vendor's account number Vendor's account number Client	`C_DEFECTSBYINSPLOTORIGN.SUPPLIER == LFA1.LIFNR` `C_DEFECTSBYINSPLOTORIGN.MANDT == LFA1.MANDT`