C_QltyCtrlChartWrkCtrVislFltr

Visual Filter for deviations by work center | view: CQLTYCTRLWRKCVF | 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
WorkCenter	Work Center	ARBPL
QltyCtrlChtCnt	Violations	VDM_QM_COUNTER
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_QLTYCTRLCHARTWRKCTRVISLFLTR.BILLOFOPERATIONSTYPE == TCA01.PLNTY` `C_QLTYCTRLCHARTWRKCTRVISLFLTR.MANDT == TCA01.MANDT`
Customer (Ship-To Party) Customer (Ship-To Party) Client	`C_QLTYCTRLCHARTWRKCTRVISLFLTR.CUSTOMER == KNA1.KUNNR` `C_QLTYCTRLCHARTWRKCTRVISLFLTR.MANDT == KNA1.MANDT`
Inspection Lot Origin	`C_QLTYCTRLCHARTWRKCTRVISLFLTR.INSPECTIONLOTORIGIN == TQ31.HERKUNFT`
Inspection Type Inspection Type Client	`C_QLTYCTRLCHARTWRKCTRVISLFLTR.INSPECTIONLOTTYPE == TQ30.ART` `C_QLTYCTRLCHARTWRKCTRVISLFLTR.MANDT == TQ30.MANDT`
Master Inspection Characteristic ? ? Client Master Inspection Characteristic	`C_QLTYCTRLCHARTWRKCTRVISLFLTR.[column in domain "QVERSNRMK"] == QPMK.VERSION` `C_QLTYCTRLCHARTWRKCTRVISLFLTR.[column in domain "QZAEHLER"] == QPMK.ZAEHLER` `C_QLTYCTRLCHARTWRKCTRVISLFLTR.MANDT == QPMK.MANDT` `C_QLTYCTRLCHARTWRKCTRVISLFLTR.INSPECTIONSPECIFICATION == QPMK.MKMNR`
Vendor's account number Vendor's account number Client	`C_QLTYCTRLCHARTWRKCTRVISLFLTR.INSPLOTSELECTIONSUPPLIER == LFA1.LIFNR` `C_QLTYCTRLCHARTWRKCTRVISLFLTR.MANDT == LFA1.MANDT`
Number of Manufacturer Number of Manufacturer Client	`C_QLTYCTRLCHARTWRKCTRVISLFLTR.MANUFACTURER == LFA1.LIFNR` `C_QLTYCTRLCHARTWRKCTRVISLFLTR.MANDT == LFA1.MANDT`
Material Number Material Number Client	`C_QLTYCTRLCHARTWRKCTRVISLFLTR.MATERIAL == MARA.MATNR` `C_QLTYCTRLCHARTWRKCTRVISLFLTR.MANDT == MARA.MANDT`
Plant Plant Client	`C_QLTYCTRLCHARTWRKCTRVISLFLTR.PLANT == T001W.WERKS` `C_QLTYCTRLCHARTWRKCTRVISLFLTR.MANDT == T001W.MANDT`
SPC Criterion Client SPC Criterion	`C_QLTYCTRLCHARTWRKCTRVISLFLTR.MANDT == QPSP.MANDT` `C_QLTYCTRLCHARTWRKCTRVISLFLTR.QLTYCTRLCHARTAGGRGNCRITERION == QPSP.SPCKRIT`
Control Chart Type Control Chart Type Client	`C_QLTYCTRLCHARTWRKCTRVISLFLTR.QUALITYCONTROLCHARTTYPE == QPSH.QRKART` `C_QLTYCTRLCHARTWRKCTRVISLFLTR.MANDT == QPSH.MANDT`
Account Number of Supplier Client Account Number of Supplier	`C_QLTYCTRLCHARTWRKCTRVISLFLTR.MANDT == LFA1.MANDT` `C_QLTYCTRLCHARTWRKCTRVISLFLTR.SUPPLIER == LFA1.LIFNR`