P_Inspcharresultdet_Wo_Smpl

Inspection characteristic result details for no-sample lots | view: PRSLTDETWOSMPL | Extraction: Not supported | Component: Quality Management
Tables used: QAMVQALSAFVCQAOPQAMRQASETQ77TQ77TTQSS1
Column Name Description
InspectionLot Inspection Lot Number
InspPlanOperationInternalID Current Node Number from Order Counter
InspectionCharacteristic Inspection Characteristic Number
InspectionSubsetInternalID Number of Partial Sample
InspResultItemInternalID Counter for Inspection Unit Number
Column Name Description
Column Name Description
Column Name Description
Column Name Description
InspSpecDecimalPlaces Number of Places to the Right of a Decimal Point (Accuracy) Show values
InspSpecAddlDecimalPlaces Number of Additional Decimal Places for Statistical Values Show values
InspSpecSummarizedDcmlPlaces Number of Additional Decimal Places for Statistical Values Show values
InspectionResultAttribute Attribute of the Results Record (Valid, Invalid,...) Show values
InspResultAttributeIsValid Attribute of Results Record Is Valid Show values
InspectionValuationResult Inspection Result Valuation Show values
Column Name Description Domain name
InspectionOperation Operation/Activity Number VORNR
InspSpecLowerLimit Lower Specification Limit QSOLLWERTE
InspSpecUpperLimit Upper Specification Limit QSOLLWERTE
InspSpecTargetValue Target Value for a Quantitative Characteristic QSOLLWERTE
InspectionMethodVersion Version Number of Inspection Method QVERSNR
InspCharacteristicSampleSize Sample Size that Has to Be Inspected for a Characteristic QANZAHL4
InspSpecControlIndicators Cntrl Indicator String for Insp. Char./Master Insp. Char. QMKCONTROL
Inspector Name of Inspector QPRUEFER
InspectionResultMeanValue Arithmetic Mean of Valid Measured Values QSTATWERT
InspResultValidValuesNumber Number of Inspected Sample Units QANZAHL4
InspResultValueInternalID Number of Individual Result QDETAILERG
InspectionResultOriginalValue Original Value Before Input Processing CHAR25
InspectionResultMeasuredValue Measured Value for a Sample Unit QURWERT
InspectionResultItem Single-Unit Number for the Unit to Be Inspected QSERIALNR
LastChangedByUser Name of User Who Last Changed Data Record QAENDERER
CreatedByUser Name of User Who Created the Data Record QAENDERER
InspSpecRecordingType null
InspectionResultAttributeText Short Text QKURZTEXT
InspRsltFreeDefinedTestEquip General Information QEQUNR
InspectionResultText Inspection Description for Summarized Result QKURZTEXT
InspSpecIsQuantitative null
CharacteristicAttributeCatalog Catalog Type of Assigned Code Group or Selected Set QKATART
CharacteristicAttributeCode Code QCODE
CharacteristicAttributeCodeGrp Code Group QCODEGRP
Master Data Relations Join Conditions
Sample Unit of Measure
  • Sample Unit of Measure
  • Client
  • P_INSPCHARRESULTDET_WO_SMPL.INSPCHARACTERISTICSAMPLEUNIT == T006.MSEHI
  • P_INSPCHARRESULTDET_WO_SMPL.MANDT == T006.MANDT
Inspection Type
  • Inspection Type
  • Client
  • P_INSPCHARRESULTDET_WO_SMPL.INSPECTIONLOTTYPE == TQ30.ART
  • P_INSPCHARRESULTDET_WO_SMPL.MANDT == TQ30.MANDT
Inspection Method
  • Inspection Method
  • Client
  • Version Number of Inspection Method
  • ?
  • P_INSPCHARRESULTDET_WO_SMPL.INSPECTIONMETHOD == QMTB.PMTNR
  • P_INSPCHARRESULTDET_WO_SMPL.MANDT == QMTB.MANDT
  • P_INSPCHARRESULTDET_WO_SMPL.INSPECTIONMETHODVERSION == QMTB.VERSION
  • P_INSPCHARRESULTDET_WO_SMPL.[column in domain "Q_METH_PLANT"] == QMTB.WERKS
Master Inspection Characteristic
  • Master Inspection Characteristic
  • Client
  • Version Number of Inspection Method
  • ?
  • P_INSPCHARRESULTDET_WO_SMPL.INSPECTIONSPECIFICATION == QPMK.MKMNR
  • P_INSPCHARRESULTDET_WO_SMPL.MANDT == QPMK.MANDT
  • P_INSPCHARRESULTDET_WO_SMPL.INSPECTIONMETHODVERSION == QPMK.VERSION
  • P_INSPCHARRESULTDET_WO_SMPL.[column in domain "QZAEHLER"] == QPMK.ZAEHLER
Unit of Measurement in Which Quantitative Data Is Stored
  • Client
  • Unit of Measurement in Which Quantitative Data Is Stored
  • P_INSPCHARRESULTDET_WO_SMPL.MANDT == T006.MANDT
  • P_INSPCHARRESULTDET_WO_SMPL.INSPECTIONSPECIFICATIONUNIT == T006.MSEHI
Material Authorization Group for Activities in QM
  • Material Authorization Group for Activities in QM
  • Client
  • P_INSPCHARRESULTDET_WO_SMPL.MATLQUALITYAUTHORIZATIONGROUP == TQ01B.QMATAUTH
  • P_INSPCHARRESULTDET_WO_SMPL.MANDT == TQ01B.MANDT
Plant
  • Client
  • Plant
  • P_INSPCHARRESULTDET_WO_SMPL.MANDT == T001W.MANDT
  • P_INSPCHARRESULTDET_WO_SMPL.PLANT == T001W.WERKS