C_QltyCtrlExcdLmtVislFltr

Visual Filter for SPC deviation | view: CQLTYCTRLEXDVF | 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 (9)
🔗 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
QltyCtrlChtDvtnSts	Violated Limits Type	Show values
QualityControlChartStatus	Control Chart Status	Show values
NmbrOfRsltsRecordedCat	Partial Samples	Show values
IsBusinessPurposeCompleted	Business Purpose Completed Flag	Show values

Column Name	Description	Domain name
QltyCtrlChtDvtnStsTxt	Violated Limits Type Text	DDTEXT
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 Client Bill of Operations Type	`C_QLTYCTRLEXCDLMTVISLFLTR.MANDT == TCA01.MANDT` `C_QLTYCTRLEXCDLMTVISLFLTR.BILLOFOPERATIONSTYPE == TCA01.PLNTY`
Customer (Ship-To Party) Client Customer (Ship-To Party)	`C_QLTYCTRLEXCDLMTVISLFLTR.MANDT == KNA1.MANDT` `C_QLTYCTRLEXCDLMTVISLFLTR.CUSTOMER == KNA1.KUNNR`
Inspection Lot Origin	`C_QLTYCTRLEXCDLMTVISLFLTR.INSPECTIONLOTORIGIN == TQ31.HERKUNFT`
Inspection Type Client Inspection Type	`C_QLTYCTRLEXCDLMTVISLFLTR.MANDT == TQ30.MANDT` `C_QLTYCTRLEXCDLMTVISLFLTR.INSPECTIONLOTTYPE == TQ30.ART`
Master Inspection Characteristic Client ? Master Inspection Characteristic ?	`C_QLTYCTRLEXCDLMTVISLFLTR.MANDT == QPMK.MANDT` `C_QLTYCTRLEXCDLMTVISLFLTR.[column in domain "QZAEHLER"] == QPMK.ZAEHLER` `C_QLTYCTRLEXCDLMTVISLFLTR.INSPECTIONSPECIFICATION == QPMK.MKMNR` `C_QLTYCTRLEXCDLMTVISLFLTR.[column in domain "QVERSNRMK"] == QPMK.VERSION`
Vendor's account number Client Vendor's account number	`C_QLTYCTRLEXCDLMTVISLFLTR.MANDT == LFA1.MANDT` `C_QLTYCTRLEXCDLMTVISLFLTR.INSPLOTSELECTIONSUPPLIER == LFA1.LIFNR`
Number of Manufacturer Client Number of Manufacturer	`C_QLTYCTRLEXCDLMTVISLFLTR.MANDT == LFA1.MANDT` `C_QLTYCTRLEXCDLMTVISLFLTR.MANUFACTURER == LFA1.LIFNR`
Material Number Client Material Number	`C_QLTYCTRLEXCDLMTVISLFLTR.MANDT == MARA.MANDT` `C_QLTYCTRLEXCDLMTVISLFLTR.MATERIAL == MARA.MATNR`
Plant Client Plant	`C_QLTYCTRLEXCDLMTVISLFLTR.MANDT == T001W.MANDT` `C_QLTYCTRLEXCDLMTVISLFLTR.PLANT == T001W.WERKS`
SPC Criterion Client SPC Criterion	`C_QLTYCTRLEXCDLMTVISLFLTR.MANDT == QPSP.MANDT` `C_QLTYCTRLEXCDLMTVISLFLTR.QLTYCTRLCHARTAGGRGNCRITERION == QPSP.SPCKRIT`
Control Chart Type Client Control Chart Type	`C_QLTYCTRLEXCDLMTVISLFLTR.MANDT == QPSH.MANDT` `C_QLTYCTRLEXCDLMTVISLFLTR.QUALITYCONTROLCHARTTYPE == QPSH.QRKART`
Account Number of Supplier Client Account Number of Supplier	`C_QLTYCTRLEXCDLMTVISLFLTR.MANDT == LFA1.MANDT` `C_QLTYCTRLEXCDLMTVISLFLTR.SUPPLIER == LFA1.LIFNR`