C_QltyCtrlDvtnMatlVislFltr

Visual Filter for deviations by Material | view: CQLTYCCTRLMATLVF | Extraction: Not supported | Component: Active Quality Control Worklist

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

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

Column Name	Description
QualityControlChart	Control Chart Number

Column Name	Description

Column Name	Description

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

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

Column Name	Description	Domain name
QltyCtrlChtCnt	Violations	VDM_QM_COUNTER
WorkCenter	Work Center	ARBPL
BillOfOperationsGroup	Bill of Operations Group	PLNNR
BillOfOperationsVariant	Bill of Operations Group Counter	ALTNR
InspPlanOperationInternalID	Current Node Number from Order Counter	KNTNR
InspectionCharacteristic	Inspection Characteristic Number	QMERKNRP
InspectionSubsetInternalID	Inspection Sample Number	QPROBENR
AuthorizationGroup	Authorization Group	BRGRU

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