C_DefectMng

Manage Defects | view: CDEFECTMNG | Extraction: Not supported | Component: Defects Recording

Tables used: SCAL_TT_DATE, QALS, AFVC, QAOP, QAVE, QMEL, QMFE, AFVC, MARA, KNA1, TQ17, TQ17T, QPCD, QPGR, QPGT, QPCT, TQDEFECTCONFIG, TQ30, TQ30T, T001W, MARA, CRTX, MAKT, T024E, LFA1, QPCD, QPCT, CRHD

🔑 Keys (1)
💰 Amounts
∑ Quantities (1)
📅 Dates (4)
☰ Categorical (6)
Other (48)
🔗 Relations (23)

Column Name	Description
DefectInternalID FK	Internal Defect ID

Column Name	Description

Column Name	Description
📏 Base Unit of Measure for Inspection Lot Quantity (InspectionLotQuantityUnit):
InspectionLotQuantity	Inspection Lot Quantity

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

Column Name	Description	Domain name
Notification	Notification Number	QMNUM
NotificationItem	Item Number in Item Record	FELFD
Defect	Defect Number
NotificationItemExternalID	Notification Item Sort Number	QFELFD
InspectionLot	Inspection Lot Number	QPLOS
InspPlanOperationInternalID	Current Node Number from Order Counter	KNTNR
InspectionOperation	Operation/Activity Number	VORNR
InspectionCharacteristic	Inspection Characteristic Number
DefectText	Defect Text	TEXT40
DefectCode	Defect Code
DefectCodeText	Text for Defect Code
DefectCodeGroupText	Text for Defect Code Group	QKURZTEXT
DefectCodeGroupAndCode	Defect Code Group and Code	CHAR13
MaterialName	Product Description	TEXT40
PlantName	Plant Name	TEXT30
NumberOfDefectsCriticality	null
NumberOfDefects	Number of Defect Occurrences	QANZAHL4
SupplierName	Name of Supplier	TEXT80
CustomerName	Name of Customer	TEXT80
DefectClassText	Short Text
InspectionLotHasUsageDecision	Checkbox
InspectionLotTypeText	Inspection Type Text	QKURZTEXT
Batch	Batch Number
WorkCenter	Work Center
WorkCenterText	Work Center Text	TEXT40
StorageLocation	Storage location	LGORT
ProductionSupplyArea	Production Supply Area	PRVBE
Warehouse	Warehouse Number/Warehouse Complex	/SCWM/LGNUM
StorageType	Source Storage Type	/SCWM/LGTYP
SourceStorageBin	Source Storage Bin	/SCWM/LGPLA
ManufacturerName	Name of Manufacturer	TEXT80
PurchasingOrganizationName	Purchasing Organization Name	TEXT20
ManufacturingOrder	Order Number (Production Order)	AUFNR
SalesOrder	Sales Order Number	VBELN
SalesOrderItem	Sales Order Item	NUM06
DeliveryDocument	Delivery Document	VBELN
MaterialByCustomer	Customer Material	IDNEX
CalendarWeek	Calendar Week	NUM2
CalendarYear	Calendar Year	NUM4
CreatedByUser	Name of Person Responsible for Creating the Object	USNAM
LastChangedByUser	Name of Person Who Changed Object	USNAM
MaterialDocument	Number of Material Document	BELNR
MaterialDocumentItem	Material Document Item	MBLPO
MaterialDocumentYear	Material Document Year	GJAHR
UsageDecisionCodeText	Text for Code	QKURZTEXT
InspectionLotQualityScore	Quality Score
MainWorkCenter	Work Center	ARBPL
DefectCausedBy	Defect Caused By	QDEFECTCAUSEDBY

Master Data Relations	Join Conditions
Storage Location for Batch Defective Material Batch Number ? Storage Location for Batch Client	`C_DEFECTMNG.MATERIAL == MCHB.MATNR` `C_DEFECTMNG.BATCH == MCHB.CHARG` `C_DEFECTMNG.[column in domain "WERKS_D"] == MCHB.WERKS` `C_DEFECTMNG.BATCHSTORAGELOCATION == MCHB.LGORT` `C_DEFECTMNG.MANDT == MCHB.MANDT`
Customer (Ship-To Party) Customer (Ship-To Party) Client	`C_DEFECTMNG.CUSTOMER == KNA1.KUNNR` `C_DEFECTMNG.MANDT == KNA1.MANDT`
Defect Category Client Defect Category	`C_DEFECTMNG.MANDT == TQDEFCAT.MANDANT` `C_DEFECTMNG.DEFECTCATEGORY == TQDEFCAT.CATEGORY`
Defect Class Client Defect Class	`C_DEFECTMNG.MANDT == TQ17.MANDT` `C_DEFECTMNG.DEFECTCLASS == TQ17.FEHLKLASSE`
Defect Code Group ? Client Defect Code Group	`C_DEFECTMNG.[column in domain "QKATART"] == QPGR.KATALOGART` `C_DEFECTMNG.MANDT == QPGR.MANDT` `C_DEFECTMNG.DEFECTCODEGROUP == QPGR.CODEGRUPPE`
Inspection Lot Origin	`C_DEFECTMNG.INSPECTIONLOTORIGIN == TQ31.HERKUNFT`
Base Unit of Measure for Inspection Lot Quantity Client Base Unit of Measure for Inspection Lot Quantity	`C_DEFECTMNG.MANDT == T006.MANDT` `C_DEFECTMNG.INSPECTIONLOTQUANTITYUNIT == T006.MSEHI`
Inspection Type Inspection Type Client	`C_DEFECTMNG.INSPECTIONLOTTYPE == TQ30.ART` `C_DEFECTMNG.MANDT == TQ30.MANDT`
Usage Decision Code Usage Decision Code ? ? Client ?	`C_DEFECTMNG.INSPECTIONLOTUSAGEDECISIONCODE == QPCD.CODE` `C_DEFECTMNG.[column in domain "QKATART"] == QPCD.KATALOGART` `C_DEFECTMNG.[column in domain "QCODEGRP"] == QPCD.CODEGRUPPE` `C_DEFECTMNG.MANDT == QPCD.MANDT` `C_DEFECTMNG.[column in domain "QVERSNR"] == QPCD.VERSION`
Object ID of the Work Center Work Center Work Center Object ID of the Work Center Object types of the CIM resource Client	`C_DEFECTMNG.MAINWORKCENTER == CRID.OBJID` `C_DEFECTMNG.WORKCENTER == CRID.OBJID` `C_DEFECTMNG.MAINWORKCENTERINTERNALID == CRID.OBJID` `C_DEFECTMNG.WORKCENTERTYPECODE == CRID.OBJTY` `C_DEFECTMNG.MANDT == CRID.MANDT`
Plant for Work Center Client Plant for Work Center	`C_DEFECTMNG.MANDT == T001W.MANDT` `C_DEFECTMNG.MAINWORKCENTERPLANT == T001W.WERKS`
Number of Manufacturer Number of Manufacturer Client	`C_DEFECTMNG.MANUFACTURER == LFA1.LIFNR` `C_DEFECTMNG.MANDT == LFA1.MANDT`
Manufacturer Material Manufacturer Material Client	`C_DEFECTMNG.MANUFACTURERPARTNMBR == MARA.MATNR` `C_DEFECTMNG.MANDT == MARA.MANDT`
Defective Material Defective Material Client	`C_DEFECTMNG.MATERIAL == MARA.MATNR` `C_DEFECTMNG.MANDT == MARA.MANDT`
Plant Client Plant	`C_DEFECTMNG.MANDT == T001W.MANDT` `C_DEFECTMNG.PLANT == T001W.WERKS`
Purchasing Organization Purchasing Organization Client	`C_DEFECTMNG.PURCHASINGORGANIZATION == T024E.EKORG` `C_DEFECTMNG.MANDT == T024E.MANDT`
Sales Organization Sales Organization Client	`C_DEFECTMNG.SALESORGANIZATION == TVKO.VKORG` `C_DEFECTMNG.MANDT == TVKO.MANDT`
Vendor's account number Vendor's account number Client	`C_DEFECTMNG.SUPPLIER == LFA1.LIFNR` `C_DEFECTMNG.MANDT == LFA1.MANDT`