C_InspectionResultHistoryValue

Inspection Result History value | view: CINSPRESHVL | TRAN | Extraction: Not supported | Component: Active Quality Control Worklist
Tables used: QAMV, QALS, AFVC, QAOP, QAMR, QASE, QASV, QASR, CRHD
Column Name Description
InspectionLot FK Inspection Lot Number
InspPlanOperationInternalID Current Node Number from Order Counter
InspectionCharacteristic Inspection Characteristic Number
InspResultValueInternalID Number of Individual Result
Column Name Description
Column Name Description
Column Name Description
CreationDate System Date on Which Data Record Was Created
Column Name Description
InspectionResultAttribute Attribute of the Results Record (Valid, Invalid,...) Show values
InspResultHasMeasuredValue Measured Value Is Not Initial Show values
InspectionValuationResult Inspection Result Valuation Show values
InspSpecDecimalPlaces Number of Places to the Right of a Decimal Point (Accuracy) Show values
InspSpecCharacteristicType Characteristic Type Show values
IsBusinessPurposeCompleted Business Purpose Completed Flag Show values
Column Name Description Domain name
InspectionOperation Operation/Activity Number VORNR
InspectionSpecificationPlant Plant for Master Inspection Characteristic QZAEHLER
InspectionSpecificationVersion Version Number of Master Inspection Characteristic QVERSNR
BillOfOperationsGroup Bill of Operations Group PLNNR
BillOfOperationsVariant Bill of Operations Group Counter ALTNR
BOOOperationInternalID Number of the Task List Node KNTNR
InspResultItemInternalID Counter for Inspection Unit Number QZAEHL
InspectionResultMeasuredValue Measured Value for a Sample Unit QURWERT
InspectionResultText Inspection Description for Single Value QKURZTEXT
InspectionResultItem Single-Unit Number for the Unit to Be Inspected QSERIALNR
InspRsltFreeDefinedTestEquip General Information QEQUNR
CharacteristicAttributeCodeGrp Code Group QCODEGRP
CharacteristicAttributeCode Code QCODE
WorkCenter Work Center ARBPL
InspResultFrmtdMeasuredValue Measured Value for a Sample Unit - formatted QURWERT_F
Master Data Relations Join Conditions
Batch Number
  • Batch Number
  • Client
  • Material Number
  • C_INSPECTIONRESULTHISTORYVALUE.BATCH == MCH1.CHARG
  • C_INSPECTIONRESULTHISTORYVALUE.MANDT == MCH1.MANDT
  • C_INSPECTIONRESULTHISTORYVALUE.INSPLOTSELECTIONMATERIAL == MCH1.MATNR
Bill of Operations Type
  • Client
  • Bill of Operations Type
  • C_INSPECTIONRESULTHISTORYVALUE.MANDT == TCA01.MANDT
  • C_INSPECTIONRESULTHISTORYVALUE.BILLOFOPERATIONSTYPE == TCA01.PLNTY
Catalog
  • Catalog
  • Client
  • C_INSPECTIONRESULTHISTORYVALUE.CHARACTERISTICATTRIBUTECATALOG == TQ15.KATALOGART
  • C_INSPECTIONRESULTHISTORYVALUE.MANDT == TQ15.MANDT
Inspection Lot Origin C_INSPECTIONRESULTHISTORYVALUE.INSPECTIONLOTORIGIN == TQ31.HERKUNFT
Inspection Type
  • Inspection Type
  • Client
  • C_INSPECTIONRESULTHISTORYVALUE.INSPECTIONLOTTYPE == TQ30.ART
  • C_INSPECTIONRESULTHISTORYVALUE.MANDT == TQ30.MANDT
Master Inspection Characteristic
  • Plant for Master Inspection Characteristic
  • Client
  • ?
  • Master Inspection Characteristic
  • C_INSPECTIONRESULTHISTORYVALUE.INSPECTIONSPECIFICATIONPLANT == QPMK.ZAEHLER
  • C_INSPECTIONRESULTHISTORYVALUE.MANDT == QPMK.MANDT
  • C_INSPECTIONRESULTHISTORYVALUE.[column in domain "QVERSNRMK"] == QPMK.VERSION
  • C_INSPECTIONRESULTHISTORYVALUE.INSPECTIONSPECIFICATION == QPMK.MKMNR
Unit of Measurement in Which Quantitative Data Is Stored
  • Client
  • Unit of Measurement in Which Quantitative Data Is Stored
  • C_INSPECTIONRESULTHISTORYVALUE.MANDT == T006.MANDT
  • C_INSPECTIONRESULTHISTORYVALUE.INSPECTIONSPECIFICATIONUNIT == T006.MSEHI
Account number of customer
  • Account number of customer
  • Client
  • C_INSPECTIONRESULTHISTORYVALUE.INSPLOTSELECTIONCUSTOMER == KNA1.KUNNR
  • C_INSPECTIONRESULTHISTORYVALUE.MANDT == KNA1.MANDT
Number of Manufacturer
  • Number of Manufacturer
  • Client
  • C_INSPECTIONRESULTHISTORYVALUE.INSPLOTSELECTIONMANUFACTURER == LFA1.LIFNR
  • C_INSPECTIONRESULTHISTORYVALUE.MANDT == LFA1.MANDT
Material Number
  • Client
  • Material Number
  • C_INSPECTIONRESULTHISTORYVALUE.MANDT == MARA.MANDT
  • C_INSPECTIONRESULTHISTORYVALUE.INSPLOTSELECTIONMATERIAL == MARA.MATNR
Vendor's account number
  • Client
  • Vendor's account number
  • C_INSPECTIONRESULTHISTORYVALUE.MANDT == LFA1.MANDT
  • C_INSPECTIONRESULTHISTORYVALUE.INSPLOTSELECTIONSUPPLIER == LFA1.LIFNR
Material Authorization Group for Activities in QM
  • Client
  • Material Authorization Group for Activities in QM
  • C_INSPECTIONRESULTHISTORYVALUE.MANDT == TQ01B.MANDT
  • C_INSPECTIONRESULTHISTORYVALUE.MATLQUALITYAUTHORIZATIONGROUP == TQ01B.QMATAUTH
Plant
  • Plant
  • Client
  • C_INSPECTIONRESULTHISTORYVALUE.PLANT == T001W.WERKS
  • C_INSPECTIONRESULTHISTORYVALUE.MANDT == T001W.MANDT
Object ID of the resource
  • Object ID of the resource
  • Client
  • ?
  • C_INSPECTIONRESULTHISTORYVALUE.WORKCENTERINTERNALID == CRID.OBJID
  • C_INSPECTIONRESULTHISTORYVALUE.MANDT == CRID.MANDT
  • C_INSPECTIONRESULTHISTORYVALUE.[column in domain "CR_OBJTY"] == CRID.OBJTY