C_QualityControlDeviations

Quality Control Deviations for SPC | view: CQLTYCTRLDVTNS | Extraction: Not supported | Component: Active Quality Control Worklist

Tables used: QAMV, QALS, AFVC, QAOP, QAMR, QASV, QASR, QASH, CRTX, LFA1, CRHD

🔑 Keys (4)
💰 Amounts
∑ Quantities
📅 Dates (2)
☰ Categorical (5)
Other (8)
🔗 Relations (13)

Column Name	Description
InspectionLot FK	Inspection Lot Number
InspPlanOperationInternalID	Current Node Number from Order Counter
InspectionCharacteristic	Inspection Characteristic Number
InspectionSubsetInternalID	Inspection Sample Number

Column Name	Description

Column Name	Description

Column Name	Description
QltyCtrlChartCreationDate	Date on Which Record Was Created
InspectionEndDate	Inspection End Date

Column Name	Description
QualityControlChartStatus	Control Chart Status	Show values
InspectionValuationResult	Inspection Result Valuation	Show values
NmbrOfRsltsRecordedCat	Partial Samples	Show values
QltyCtrlChtDvtnSts	Violated Limits Type	Show values
IsBusinessPurposeCompleted	Business Purpose Completed Flag	Show values

Column Name	Description	Domain name
QualityControlChart	Control Chart Number	QQRKNR
BillOfOperationsGroup	Bill of Operations Group	PLNNR
BillOfOperationsVariant	Bill of Operations Group Counter	ALTNR
WorkCenter	Work Center	ARBPL
WorkCenterText	Work Center Text	TEXT40
InspectionSpecificationText	Short Text for Inspection Characteristic	QKURZTEXT
ActionLimitDeviations	Number of Action Limit Violations	VDM_QM_COUNTER
AuthorizationGroup	Authorization Group	BRGRU

Master Data Relations	Join Conditions
Bill of Operations Type Bill of Operations Type Client	`C_QUALITYCONTROLDEVIATIONS.BILLOFOPERATIONSTYPE == TCA01.PLNTY` `C_QUALITYCONTROLDEVIATIONS.MANDT == TCA01.MANDT`
Customer (Ship-To Party) Customer (Ship-To Party) Client	`C_QUALITYCONTROLDEVIATIONS.CUSTOMER == KNA1.KUNNR` `C_QUALITYCONTROLDEVIATIONS.MANDT == KNA1.MANDT`
Inspection Lot Origin	`C_QUALITYCONTROLDEVIATIONS.INSPECTIONLOTORIGIN == TQ31.HERKUNFT`
Inspection Type Inspection Type Client	`C_QUALITYCONTROLDEVIATIONS.INSPECTIONLOTTYPE == TQ30.ART` `C_QUALITYCONTROLDEVIATIONS.MANDT == TQ30.MANDT`
Master Inspection Characteristic ? Master Inspection Characteristic Client ?	`C_QUALITYCONTROLDEVIATIONS.[column in domain "QVERSNRMK"] == QPMK.VERSION` `C_QUALITYCONTROLDEVIATIONS.INSPECTIONSPECIFICATION == QPMK.MKMNR` `C_QUALITYCONTROLDEVIATIONS.MANDT == QPMK.MANDT` `C_QUALITYCONTROLDEVIATIONS.[column in domain "QZAEHLER"] == QPMK.ZAEHLER`
Vendor's account number Client Vendor's account number	`C_QUALITYCONTROLDEVIATIONS.MANDT == LFA1.MANDT` `C_QUALITYCONTROLDEVIATIONS.INSPLOTSELECTIONSUPPLIER == LFA1.LIFNR`
Number of Manufacturer Number of Manufacturer Client	`C_QUALITYCONTROLDEVIATIONS.MANUFACTURER == LFA1.LIFNR` `C_QUALITYCONTROLDEVIATIONS.MANDT == LFA1.MANDT`
Material Number Material Number Client	`C_QUALITYCONTROLDEVIATIONS.MATERIAL == MARA.MATNR` `C_QUALITYCONTROLDEVIATIONS.MANDT == MARA.MANDT`
Plant Client Plant	`C_QUALITYCONTROLDEVIATIONS.MANDT == T001W.MANDT` `C_QUALITYCONTROLDEVIATIONS.PLANT == T001W.WERKS`
SPC Criterion SPC Criterion Client	`C_QUALITYCONTROLDEVIATIONS.QLTYCTRLCHARTAGGRGNCRITERION == QPSP.SPCKRIT` `C_QUALITYCONTROLDEVIATIONS.MANDT == QPSP.MANDT`
Control Chart Type Control Chart Type Client	`C_QUALITYCONTROLDEVIATIONS.QUALITYCONTROLCHARTTYPE == QPSH.QRKART` `C_QUALITYCONTROLDEVIATIONS.MANDT == QPSH.MANDT`
Account Number of Supplier Account Number of Supplier Client	`C_QUALITYCONTROLDEVIATIONS.SUPPLIER == LFA1.LIFNR` `C_QUALITYCONTROLDEVIATIONS.MANDT == LFA1.MANDT`