C_QltyCtrlChtWthDvtn

Quality Control Chart with deviation | view: CQLTYCTRLDVTN | Extraction: Not supported | Component: Active Quality Control Worklist

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

🔑 Keys (2)
💰 Amounts
∑ Quantities
📅 Dates (2)
☰ Categorical (5)
Other (3)
🔗 Relations (17)

Column Name	Description
QualityControlChart	Control Chart Number
InspectionLot FK	Inspection Lot 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
QltyCtrlChtDvtnSts	Violated Limits Type	Show values
InspectionLotHasQuantity	Posted to Inspection Stock	Show values
IsBusinessPurposeCompleted	Business Purpose Completed Flag	Show values

Column Name	Description	Domain name
QltyCtrlChtCnt	Violations	VDM_QM_COUNTER
WorkCenter	Work Center	ARBPL
AuthorizationGroup	Authorization Group	BRGRU

Master Data Relations	Join Conditions
Storage Location for Batch Client ? Storage Location for Batch Material Number Plant	`C_QLTYCTRLCHTWTHDVTN.MANDT == MCHB.MANDT` `C_QLTYCTRLCHTWTHDVTN.[column in domain "CHARG_D"] == MCHB.CHARG` `C_QLTYCTRLCHTWTHDVTN.BATCHSTORAGELOCATION == MCHB.LGORT` `C_QLTYCTRLCHTWTHDVTN.MATERIAL == MCHB.MATNR` `C_QLTYCTRLCHTWTHDVTN.PLANT == MCHB.WERKS`
Customer (Ship-To Party) Customer (Ship-To Party) Client	`C_QLTYCTRLCHTWTHDVTN.CUSTOMER == KNA1.KUNNR` `C_QLTYCTRLCHTWTHDVTN.MANDT == KNA1.MANDT`
Inspection Lot Origin	`C_QLTYCTRLCHTWTHDVTN.INSPECTIONLOTORIGIN == TQ31.HERKUNFT`
Storage Location for Inspection Lot Stock Client ? Storage Location for Inspection Lot Stock	`C_QLTYCTRLCHTWTHDVTN.MANDT == T001L.MANDT` `C_QLTYCTRLCHTWTHDVTN.[column in domain "WERKS_D"] == T001L.WERKS` `C_QLTYCTRLCHTWTHDVTN.INSPECTIONLOTSTORAGELOCATION == T001L.LGORT`
Inspection Type Inspection Type Client	`C_QLTYCTRLCHTWTHDVTN.INSPECTIONLOTTYPE == TQ30.ART` `C_QLTYCTRLCHTWTHDVTN.MANDT == TQ30.MANDT`
Vendor's account number Vendor's account number Client	`C_QLTYCTRLCHTWTHDVTN.INSPLOTSELECTIONSUPPLIER == LFA1.LIFNR` `C_QLTYCTRLCHTWTHDVTN.MANDT == LFA1.MANDT`
Number of Manufacturer Number of Manufacturer Client	`C_QLTYCTRLCHTWTHDVTN.MANUFACTURER == LFA1.LIFNR` `C_QLTYCTRLCHTWTHDVTN.MANDT == LFA1.MANDT`
Manufacturer Material Manufacturer Material Client	`C_QLTYCTRLCHTWTHDVTN.MANUFACTURERPARTNMBR == MARA.MATNR` `C_QLTYCTRLCHTWTHDVTN.MANDT == MARA.MANDT`
Material Number Client Material Number	`C_QLTYCTRLCHTWTHDVTN.MANDT == MARA.MANDT` `C_QLTYCTRLCHTWTHDVTN.MATERIAL == MARA.MATNR`
Material Authorization Group for Activities in QM Client Material Authorization Group for Activities in QM	`C_QLTYCTRLCHTWTHDVTN.MANDT == TQ01B.MANDT` `C_QLTYCTRLCHTWTHDVTN.MATLQUALITYAUTHORIZATIONGROUP == TQ01B.QMATAUTH`
Plant Client Plant	`C_QLTYCTRLCHTWTHDVTN.MANDT == T001W.MANDT` `C_QLTYCTRLCHTWTHDVTN.PLANT == T001W.WERKS`
Purchasing Organization Client Purchasing Organization	`C_QLTYCTRLCHTWTHDVTN.MANDT == T024E.MANDT` `C_QLTYCTRLCHTWTHDVTN.PURCHASINGORGANIZATION == T024E.EKORG`
SPC Criterion Client SPC Criterion	`C_QLTYCTRLCHTWTHDVTN.MANDT == QPSP.MANDT` `C_QLTYCTRLCHTWTHDVTN.QLTYCTRLCHARTAGGRGNCRITERION == QPSP.SPCKRIT`
Sales Organization Client Sales Organization	`C_QLTYCTRLCHTWTHDVTN.MANDT == TVKO.MANDT` `C_QLTYCTRLCHTWTHDVTN.SALESORGANIZATION == TVKO.VKORG`
Customer (Sold-To Party) Customer (Sold-To Party) Client	`C_QLTYCTRLCHTWTHDVTN.SOLDTOPARTY == KNA1.KUNNR` `C_QLTYCTRLCHTWTHDVTN.MANDT == KNA1.MANDT`
Account Number of Supplier Account Number of Supplier Client	`C_QLTYCTRLCHTWTHDVTN.SUPPLIER == LFA1.LIFNR` `C_QLTYCTRLCHTWTHDVTN.MANDT == LFA1.MANDT`