C_InspQuantitativeCharcs

Characteristics Detailed Analytics - Quantitative Analysis | view: CINSPCHARQUANTCH | TRAN | Extraction: Not supported | Component: Active Quality Control Worklist
Tables used: SCAL_TT_DATEQAMVQALSAFVCQAOPQAMRPLMKKNA1QPMKQPMTMAKTT001WCRTXLFA1CRHD
Column Name Description
InspectionLot FK Inspection Lot Number
InspPlanOperationInternalID Current Node Number from Order Counter
InspectionCharacteristic Inspection Characteristic Number
Column Name Description
Column Name Description
Column Name Description
CreationDate Result Recorded On
Column Name Description
InspResultAggregationLevel Inspection Result Aggregation Level Show values
InspSpecHasLowerLimit Has Lower Specification Limit Show values
InspSpecHasUpperLimit Has Upper Specification Limit Show values
BOOCharcHasInspSpecReference Reference to Master Insp. Characteristic in Task List Show values
InspCharcsHasLowerLimit Inspection Characteristic Has Lower Limit Show values
InspCharcsHasUpperLimit Inspection Characteristic Has Upper Limit Show values
InspectionSubsetType Inspection Point Type Show values
IsBusinessPurposeCompleted Business Purpose Completed Flag Show values
Column Name Description Domain name
InspResultHistoryCharc Inspection Characteristic Key for Results History
MasterInspCharcsKey Master Inspection Characteristic TEXT24
InspectionSpecificationText Short Text QKURZTEXT
InspectionCharacteristicText Short Text for Inspection Characteristic QKURZTEXT
PlantName Plant Name TEXT30
MaterialName Material Description TEXT40
SupplierName Name of Supplier TEXT80
CustomerFullName Customer Full Name TEXT220
WorkCenter Work Center ARBPL
WorkCenterText Work Center Text TEXT40
WorkCenterPlantName Plant Name TEXT30
CalendarYear Calendar Year NUM4
CalendarQuarter Calendar Quarter NUM1
CalendarQuarterName Short Text for Fixed Values DDTEXT
CalendarMonth Calendar Month NUM2
CalendarMonthName Short Text for Fixed Values DDTEXT
CalendarWeek Calendar Week NUM2
NumberOfInspections No. of Inspections VDM_QM_COUNTER
InspectionResultMeanValue Arithmetic Mean of Valid Measured Values (KPI) QSTATWERT
InspResultVariance Dispersion (Variance) of Valid Measured Values (KPI) QSTATWERT
InspRsltFrmtdStandardDeviation Standard Deviation of Valid Measured Values (KPI) QSTATWERT
InspRsltBelowToleranceValsNmbr Units Below Tolerance VDM_QM_COUNTER
InspRsltAboveToleranceValsNmbr Units Above Tolerance VDM_QM_COUNTER
InspSpecLowerLimit Lower Specification Limit QSOLLWERTE
InspSpecUpperLimit Upper Specification Limit QSOLLWERTE
InspCharcsUpperLimit Inspection Characteristic Upper Limit QSOLLWERTE
InspCharcsLowerLimit Inspection Characteristic Lower Limit QSOLLWERTE
CtrlChartProcessCapability Cp Index VDM_QM_FLTP
CtrlChartMeanProcessCapability Cpk Index VDM_QM_FLTP
Master Data Relations Join Conditions
Customer (Ship-To Party)
  • Customer (Ship-To Party)
  • Client
  • C_INSPQUANTITATIVECHARCS.CUSTOMER == KNA1.KUNNR
  • C_INSPQUANTITATIVECHARCS.MANDT == KNA1.MANDT
Inspection Lot Origin C_INSPQUANTITATIVECHARCS.INSPECTIONLOTORIGIN == TQ31.HERKUNFT
Inspection Type
  • Inspection Type
  • Client
  • C_INSPQUANTITATIVECHARCS.INSPECTIONLOTTYPE == TQ30.ART
  • C_INSPQUANTITATIVECHARCS.MANDT == TQ30.MANDT
Work Center Plant
  • Client
  • Work Center Plant
  • C_INSPQUANTITATIVECHARCS.MANDT == T001W.MANDT
  • C_INSPQUANTITATIVECHARCS.INSPECTIONOPERATIONPLANT == T001W.WERKS
Unit of Measurement in Which Quantitative Data Is Stored
  • Client
  • Unit of Measurement in Which Quantitative Data Is Stored
  • C_INSPQUANTITATIVECHARCS.MANDT == T006.MANDT
  • C_INSPQUANTITATIVECHARCS.INSPECTIONSPECIFICATIONUNIT == T006.MSEHI
Material Number
  • Client
  • Material Number
  • C_INSPQUANTITATIVECHARCS.MANDT == MARA.MANDT
  • C_INSPQUANTITATIVECHARCS.MATERIAL == MARA.MATNR
Material Authorization Group for Activities in QM
  • Material Authorization Group for Activities in QM
  • Client
  • C_INSPQUANTITATIVECHARCS.MATLQUALITYAUTHORIZATIONGROUP == TQ01B.QMATAUTH
  • C_INSPQUANTITATIVECHARCS.MANDT == TQ01B.MANDT
Plant
  • Client
  • Plant
  • C_INSPQUANTITATIVECHARCS.MANDT == T001W.MANDT
  • C_INSPQUANTITATIVECHARCS.PLANT == T001W.WERKS
Vendor's account number
  • Vendor's account number
  • Client
  • C_INSPQUANTITATIVECHARCS.SUPPLIER == LFA1.LIFNR
  • C_INSPQUANTITATIVECHARCS.MANDT == LFA1.MANDT