C_QualityControlChart

Quality Control Chart | view: CQLTYCNTRLCHART | Extraction: Not supported | Component: Active Quality Control Worklist
Tables used: QAMVQALSAFVCQAOPQAMRQASVQASRQASHQASTTCA01TCA02TQ30TQ30TMARAMAKTT001WCRTXQPSTQPSTTQPSPQPSPTQPSHQPSHTLFA1CRHD
Column Name Description
QualityControlChart Control Chart Number
InspectionLot FK Inspection Lot Number
Column Name Description
Column Name Description
Column Name Description
InspectionEndDate Inspection End Date
InspectionEndTime End Time in Local Time Zone of Inspection
QltyCtrlChartCreationDate Date on Which Record Was Created
QltyCtrlChartCreationTime System Time at Which Data Record Was Created
QltyCtrlChartLastChangedDate System Date on Which Data Record Was Changed
QltyCtrlChartLastChangedTime System Time at Which Data Record Was Changed
Column Name Description
QualityControlChartStatus Control Chart Status Show values
QltyCtrlChtDvtnSts Violated Limits Type Show values
NmbrOfRsltsRecordedCat Partial Samples Show values
ControlChartAxisType Reference Axis of a Control Chart Show values
InspSpecHasUpperLimit Value Not Initial If Set Show values
InspSpecHasLowerLimit Value Not Initial If Set Show values
InspectionValuationResult Inspection Result Valuation Show values
InspSubsetResultValuation Inspection Result Valuation Show values
IsBusinessPurposeCompleted Business Purpose Completed Flag Show values
Column Name Description Domain name
InspPlanOperationInternalID Current Node Number from Order Counter KNTNR
InspectionSubsetInternalID Inspection Sample Number QPROBENR
QualityControlChartTypeText Quality Control Chart Type Text QKURZTEXT
InspectionCharacteristic Inspection Characteristic Number QMERKNRP
InspectionSpecificationText Short Text for Inspection Characteristic QKURZTEXT
QualityControlChartStatusText Quality Control Chart Status Text QKURZTEXT
ControlChartWorkCenter Work Center ARBPL
ControlChartWorkCenterText Work Center Text TEXT40
PlantName Plant Name TEXT30
ControlChartMaterialText Material Description TEXT40
MaterialName Material Description TEXT40
WorkCenter Work Center ARBPL
WorkCenterText Work Center Text TEXT40
QltyCtrlChtAggrgnCriterionTxt Short Text QKURZTEXT
QltyCtrlChtDvtnStsTxt Violated Limits Type Text DDTEXT
BillOfOperationsGroup Bill of Operations Group PLNNR
BillOfOperationsVariant Bill of Operations Group Counter ALTNR
InspectionSpecificationPlant Plant for Master Inspection Characteristic QZAEHLER
InspectionLotTypeText Inspection Type Text QKURZTEXT
QualityControlChartText Quality Control Chart Characteristic Text QKURZTEXT
InspSpecUpperLimit Upper Specification Limit QSOLLWERTE
InspSpecLowerLimit Lower Specification Limit QSOLLWERTE
QualityControlChartTracks No. of Tracks VDM_QM_COUNTER
InspectionSampleSize Number of Individual Values QANZAHL4
InspResultVariance Dispersion (Variance) of Valid Measured Values QSTATWERT
ActionLimitDeviations Number of Action Limit Violations VDM_QM_COUNTER
CtrlChartProcessCapability Process Capability Index - Cp QSTATWERTC
CtrlChartMeanProcessCapability Process Capability Index - Cpk QSTATWERTC
InspectionNonconformingRatio Average Fraction of Nonconforming Units QSTATWERTC
InspectionPartialSampleSize Number of Partial Samples for Characteristic QANZAHL2
CtrlChartLowerActionLimit Lower Action Limit for Track 1 QSTATWERT
CtrlChartLowerWarningLimit Lower Warning Limit for Track 1 QSTATWERT
CtrlChartMeanValue Mean Value for Track 1 QSTATWERT
CtrlChartUpperActionLimit Upper Action Limit for Track 1 QSTATWERT
CtrlChartUpperWarningLimit Upper Warning Limit for Track 1 QSTATWERT
BillOfOperationsTypeName Description of the Task List Type TEXT30
CtrlChartBillOfOperationsGroup Bill of Operations Group PLNNR
CtrlChtBillOfOperationsVariant Bill of Operations Group Counter ALTNR
QltyCtrlChartCreatedByUser Name of Person Responsible for Creating the Object USNAM
QltyCtrlChartLastChangedByUser Name of Person Who Changed Object USNAM
LastCtrlChtInspectionLot null
LastCtrlChtInspPlanOplIntID null
LastCtrlChtInspCharacteristic null
LastCtrlChtInspSbstIntID null
AuthorizationGroup Authorization Group BRGRU
Master Data Relations Join Conditions
Bill of Operations Type
  • Bill of Operations Type
  • Bill of Operations Type
  • Client
  • C_QUALITYCONTROLCHART.CTRLCHARTBILLOFOPERATIONSTYPE == TCA01.PLNTY
  • C_QUALITYCONTROLCHART.BILLOFOPERATIONSTYPE == TCA01.PLNTY
  • C_QUALITYCONTROLCHART.MANDT == TCA01.MANDT
Material Number
  • Client
  • Material Number
  • C_QUALITYCONTROLCHART.MANDT == MARA.MANDT
  • C_QUALITYCONTROLCHART.CONTROLCHARTMATERIAL == MARA.MATNR
Bill of Operations Type
  • Client
  • Bill of Operations Type
  • Bill of Operations Type
  • C_QUALITYCONTROLCHART.MANDT == TCA01.MANDT
  • C_QUALITYCONTROLCHART.CTRLCHARTBILLOFOPERATIONSTYPE == TCA01.PLNTY
  • C_QUALITYCONTROLCHART.BILLOFOPERATIONSTYPE == TCA01.PLNTY
Customer (Ship-To Party)
  • Customer (Ship-To Party)
  • Client
  • C_QUALITYCONTROLCHART.CUSTOMER == KNA1.KUNNR
  • C_QUALITYCONTROLCHART.MANDT == KNA1.MANDT
Equipment
  • Client
  • Equipment Number
  • C_QUALITYCONTROLCHART.MANDT == EQUI.MANDT
  • C_QUALITYCONTROLCHART.EQUIPMENT == EQUI.EQUNR
Functional location
  • Client
  • Functional Location
  • C_QUALITYCONTROLCHART.MANDT == IFLOT.MANDT
  • C_QUALITYCONTROLCHART.FUNCTIONALLOCATION == IFLOT.TPLNR
Inspection Lot Origin C_QUALITYCONTROLCHART.INSPECTIONLOTORIGIN == TQ31.HERKUNFT
Inspection Type
  • Inspection Type
  • Client
  • C_QUALITYCONTROLCHART.INSPECTIONLOTTYPE == TQ30.ART
  • C_QUALITYCONTROLCHART.MANDT == TQ30.MANDT
Master Inspection Characteristic
  • Client
  • Plant for Master Inspection Characteristic
  • ?
  • Master Inspection Characteristic
  • C_QUALITYCONTROLCHART.MANDT == QPMK.MANDT
  • C_QUALITYCONTROLCHART.INSPECTIONSPECIFICATIONPLANT == QPMK.ZAEHLER
  • C_QUALITYCONTROLCHART.[column in domain "QVERSNRMK"] == QPMK.VERSION
  • C_QUALITYCONTROLCHART.INSPECTIONSPECIFICATION == QPMK.MKMNR
Vendor's account number
  • Vendor's account number
  • Vendor's account number
  • Client
  • C_QUALITYCONTROLCHART.INSPLOTSELECTIONSUPPLIER == LFA1.LIFNR
  • C_QUALITYCONTROLCHART.SUPPLIER == LFA1.LIFNR
  • C_QUALITYCONTROLCHART.MANDT == LFA1.MANDT
Work Center Plant
  • Client
  • Work Center Plant
  • C_QUALITYCONTROLCHART.MANDT == T001W.MANDT
  • C_QUALITYCONTROLCHART.MAINWORKCENTERPLANT == T001W.WERKS
Number of Manufacturer
  • Number of Manufacturer
  • Client
  • C_QUALITYCONTROLCHART.MANUFACTURER == LFA1.LIFNR
  • C_QUALITYCONTROLCHART.MANDT == LFA1.MANDT
Material Number
  • Client
  • Material Number
  • C_QUALITYCONTROLCHART.MANDT == MARA.MANDT
  • C_QUALITYCONTROLCHART.MATERIAL == MARA.MATNR
Plant
  • Client
  • Plant
  • C_QUALITYCONTROLCHART.MANDT == T001W.MANDT
  • C_QUALITYCONTROLCHART.PLANT == T001W.WERKS
SPC Criterion
  • Client
  • SPC Criterion
  • C_QUALITYCONTROLCHART.MANDT == QPSP.MANDT
  • C_QUALITYCONTROLCHART.QLTYCTRLCHARTAGGRGNCRITERION == QPSP.SPCKRIT
Chart Type
  • Client
  • Chart Type
  • C_QUALITYCONTROLCHART.MANDT == QPSH.MANDT
  • C_QUALITYCONTROLCHART.QUALITYCONTROLCHARTTYPE == QPSH.QRKART
Vendor's account number
  • Vendor's account number
  • Vendor's account number
  • Client
  • C_QUALITYCONTROLCHART.INSPLOTSELECTIONSUPPLIER == LFA1.LIFNR
  • C_QUALITYCONTROLCHART.SUPPLIER == LFA1.LIFNR
  • C_QUALITYCONTROLCHART.MANDT == LFA1.MANDT