C_QltyMgmtInfoSystCharcs

Characteristics Detailed Analytics | view: CQMISCHARANLYS | TRAN | Extraction: Not supported | Component: Active Quality Control Worklist
Tables used: SCAL_TT_DATEQAMVQALSAFVCQAOPQAMRQASVQASRKNA1QPMKQPMTMAKTT001WCRTXLFA1CRHD
Column Name Description
InspectionLot FK Inspection Lot Number
InspPlanOperationInternalID Current Node Number from Order Counter
InspectionCharacteristic Inspection Characteristic Number
InspectionSubsetInternalID Inspection Sample Number
Column Name Description
Column Name Description
📏 Inspection Lot Base Unit (InspectionLotQuantityUnit):
InspectionLotQuantity Inspection Lot Quantity
📏 Inspection Lot Sample Base Unit (InspectionLotSampleUnit):
InspectionLotSampleQuantity Inspection Sample Size
InspectionLotSkipQuantity Inspection Lot Skip Quantity
InspectionLotRejectedQuantity Inspection Lot Rejected Quantity
Column Name Description
CreationDate Result Recorded On
Column Name Description
InspResultAggregationLevel Inspection Result Aggregation Level Show values
InspSpecHasLowerLimit Value Not Initial if Set Show values
InspSpecHasUpperLimit Value Not Initial if Set 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
NmbrOfVltdInspections Number of Inspections with Valuation VDM_QM_COUNTER
NumberOfAcceptedInspCharcs No. of Accepted Inspections VDM_QM_COUNTER
NumberOfRejectedInspCharcs No. of Rejected Inspections VDM_QM_COUNTER
NumberOfSkipInspCharcs No. of Skipped Inspections VDM_QM_COUNTER
NumberOfNotSkipInspCharcs No. of Not Skipped Inspections VDM_QM_COUNTER
InspSkipRatePercent Skip Rate VDM_QM_FLTP
InspRsltRjcnRatePercent Rejection Rate VDM_QM_FLTP
InspRsltNonconformingValsNmbr No. of Nonconforming Units VDM_QM_COUNTER
InspResultValidValuesNumber No. of Inspected Units VDM_QM_COUNTER
InspLotSampleQuantityInPercent Sample Quantity (in %) VDM_QM_FLTP
InspLotSkipQuantityInPercent Skip Quantity (in %) VDM_QM_FLTP
InspLotRjctdQuantityInPercent Rejected Quantity (in %) VDM_QM_FLTP
InspectionResultMeanValue Arithmetic Mean of Valid Measured Values QSTATWERT
InspResultVariance Dispersion (Variance) of Valid Measured Values QSTATWERT
InspRsltFrmtdStandardDeviation Standard Deviation of Valid Measured Values (KPI) QSTATWERT
InspRsltBelowToleranceValsNmbr Number of Measured Values Below Tolerance Range QANZAHL4
InspRsltAboveToleranceValsNmbr Number of Measured Values Above Tolerance Range QANZAHL4
InspSpecLowerLimit Lower Specification Limit QSOLLWERTE
InspSpecUpperLimit Upper Specification Limit QSOLLWERTE
CtrlChartProcessCapability null
CtrlChartMeanProcessCapability null
Master Data Relations Join Conditions
Customer (Ship-To Party)
  • Customer (Ship-To Party)
  • Client
  • C_QLTYMGMTINFOSYSTCHARCS.CUSTOMER == KNA1.KUNNR
  • C_QLTYMGMTINFOSYSTCHARCS.MANDT == KNA1.MANDT
Inspection Lot Origin C_QLTYMGMTINFOSYSTCHARCS.INSPECTIONLOTORIGIN == TQ31.HERKUNFT
Inspection Lot Base Unit
  • Client
  • Inspection Lot Base Unit
  • Inspection Lot Sample Base Unit
  • C_QLTYMGMTINFOSYSTCHARCS.MANDT == T006.MANDT
  • C_QLTYMGMTINFOSYSTCHARCS.INSPECTIONLOTQUANTITYUNIT == T006.MSEHI
  • C_QLTYMGMTINFOSYSTCHARCS.INSPECTIONLOTSAMPLEUNIT == T006.MSEHI
Inspection Lot Sample Base Unit
  • Client
  • Inspection Lot Base Unit
  • Inspection Lot Sample Base Unit
  • C_QLTYMGMTINFOSYSTCHARCS.MANDT == T006.MANDT
  • C_QLTYMGMTINFOSYSTCHARCS.INSPECTIONLOTQUANTITYUNIT == T006.MSEHI
  • C_QLTYMGMTINFOSYSTCHARCS.INSPECTIONLOTSAMPLEUNIT == T006.MSEHI
Inspection Type
  • Inspection Type
  • Client
  • C_QLTYMGMTINFOSYSTCHARCS.INSPECTIONLOTTYPE == TQ30.ART
  • C_QLTYMGMTINFOSYSTCHARCS.MANDT == TQ30.MANDT
Work Center Plant
  • Work Center Plant
  • Client
  • C_QLTYMGMTINFOSYSTCHARCS.INSPECTIONOPERATIONPLANT == T001W.WERKS
  • C_QLTYMGMTINFOSYSTCHARCS.MANDT == T001W.MANDT
Unit of Measurement in Which Quantitative Data Is Stored
  • Client
  • Unit of Measurement in Which Quantitative Data Is Stored
  • C_QLTYMGMTINFOSYSTCHARCS.MANDT == T006.MANDT
  • C_QLTYMGMTINFOSYSTCHARCS.INSPECTIONSPECIFICATIONUNIT == T006.MSEHI
Material Number
  • Material Number
  • Client
  • C_QLTYMGMTINFOSYSTCHARCS.MATERIAL == MARA.MATNR
  • C_QLTYMGMTINFOSYSTCHARCS.MANDT == MARA.MANDT
Material Authorization Group for Activities in QM
  • Material Authorization Group for Activities in QM
  • Client
  • C_QLTYMGMTINFOSYSTCHARCS.MATLQUALITYAUTHORIZATIONGROUP == TQ01B.QMATAUTH
  • C_QLTYMGMTINFOSYSTCHARCS.MANDT == TQ01B.MANDT
Plant
  • Client
  • Plant
  • C_QLTYMGMTINFOSYSTCHARCS.MANDT == T001W.MANDT
  • C_QLTYMGMTINFOSYSTCHARCS.PLANT == T001W.WERKS
Vendor's account number
  • Client
  • Vendor's account number
  • C_QLTYMGMTINFOSYSTCHARCS.MANDT == LFA1.MANDT
  • C_QLTYMGMTINFOSYSTCHARCS.SUPPLIER == LFA1.LIFNR