C_InspCharcsQty

Characteristic Analytics - Quantities | view: CINSPCHARQTY | 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 Sample Quantity
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
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
InspLotSampleQuantityInPercent Sample Quantity (in %) VDM_QM_FLTP
InspLotSkipQuantityInPercent Skip Quantity (in %) VDM_QM_FLTP
InspLotRjctdQuantityInPercent Rejected Quantity (in %) VDM_QM_FLTP
Master Data Relations Join Conditions
Customer (Ship-To Party)
  • Customer (Ship-To Party)
  • Client
  • C_INSPCHARCSQTY.CUSTOMER == KNA1.KUNNR
  • C_INSPCHARCSQTY.MANDT == KNA1.MANDT
Inspection Lot Origin C_INSPCHARCSQTY.INSPECTIONLOTORIGIN == TQ31.HERKUNFT
Inspection Lot Base Unit
  • Inspection Lot Sample Base Unit
  • Inspection Lot Base Unit
  • Client
  • C_INSPCHARCSQTY.INSPECTIONLOTSAMPLEUNIT == T006.MSEHI
  • C_INSPCHARCSQTY.INSPECTIONLOTQUANTITYUNIT == T006.MSEHI
  • C_INSPCHARCSQTY.MANDT == T006.MANDT
Inspection Lot Sample Base Unit
  • Inspection Lot Sample Base Unit
  • Inspection Lot Base Unit
  • Client
  • C_INSPCHARCSQTY.INSPECTIONLOTSAMPLEUNIT == T006.MSEHI
  • C_INSPCHARCSQTY.INSPECTIONLOTQUANTITYUNIT == T006.MSEHI
  • C_INSPCHARCSQTY.MANDT == T006.MANDT
Inspection Type
  • Inspection Type
  • Client
  • C_INSPCHARCSQTY.INSPECTIONLOTTYPE == TQ30.ART
  • C_INSPCHARCSQTY.MANDT == TQ30.MANDT
Work Center Plant
  • Client
  • Work Center Plant
  • C_INSPCHARCSQTY.MANDT == T001W.MANDT
  • C_INSPCHARCSQTY.INSPECTIONOPERATIONPLANT == T001W.WERKS
Material Number
  • Client
  • Material Number
  • C_INSPCHARCSQTY.MANDT == MARA.MANDT
  • C_INSPCHARCSQTY.MATERIAL == MARA.MATNR
Material Authorization Group for Activities in QM
  • Material Authorization Group for Activities in QM
  • Client
  • C_INSPCHARCSQTY.MATLQUALITYAUTHORIZATIONGROUP == TQ01B.QMATAUTH
  • C_INSPCHARCSQTY.MANDT == TQ01B.MANDT
Plant
  • Plant
  • Client
  • C_INSPCHARCSQTY.PLANT == T001W.WERKS
  • C_INSPCHARCSQTY.MANDT == T001W.MANDT
Vendor's account number
  • Vendor's account number
  • Client
  • C_INSPCHARCSQTY.SUPPLIER == LFA1.LIFNR
  • C_INSPCHARCSQTY.MANDT == LFA1.MANDT