I_OpActyPlanInspCharInfo

Order PIC Info | view: IOAPICINFO | TRAN | Extraction: Not supported | Component: Shop Floor Execution
Tables used: QAMVQALSAFVCQAOPQAMRQAPPQASVQPAMQPAMTXTQPCTQMTBQMTTTQ76TQ76TT006T006ACRHDTQSS1
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
📏 Base Unit of Measure for Inspection Lot Quantity (InspectionLotQuantityUnit):
InspectionLotQuantity Inspection Lot Quantity
Column Name Description
Column Name Description
InspectionValuationResult Inspection Result Valuation Show values
InspectionResultHasMeanValue Value Not Initial if Set Show values
HasInspCharcPrtlSmpl Partial Samples Possible Show values
InspCharcIsNotPlanned Unplanned Characteristic Show values
InspLotHasSubsets Inspection with Inspection Points Show values
InspSpecDecimalPlaces Number of Places to the Right of a Decimal Point (Accuracy) Show values
InspSpecHasTargetValue Value Not Initial if Set Show values
InspSpecHasUpperLimit Value Not Initial if Set Show values
InspSpecHasLowerLimit Value Not Initial if Set Show values
InspSpecIsMeasuredValueRqd Measured Values Must Be Recorded Show values
InspSpecIsSelectedSetRequired Reference to Characteristic Attribute Required Show values
InspSpecHasControlChart SPC Characteristic Show values
InspSpecHasSamplingProcedure Sampling Procedure Is Required Show values
InspSpecIsDefectsRecgAutomatic Defects Recording Automatically Called Up Show values
InspectionResultHasLongText Inspection Characteristic Long Text Exists Show values
InspectionResultAttribute Attribute of the Results Record (Valid, Invalid,...) Show values
InspSpecAddlDecimalPlaces Number of Additional Decimal Places for Statistical Values Show values
InspSpecSummarizedDcmlPlaces Number of Places to the Right of a Decimal Point (Accuracy) Show values
InspResultIsDocumentationRqd Documentation Required for Inspection Results Show values
InspectionSubsetType Inspection Point Type Show values
InspSpecInspectedIsEnabled Boolean Variable (X = True, - = False, Space = Unknown) Show values
InspSpecNonConformingIsEnabled Boolean Variable (X = True, - = False, Space = Unknown) Show values
NrOfRsltsAboveIsVisible Boolean Variable (X = True, - = False, Space = Unknown) Show values
NrOfRsltsBelowIsVisible Boolean Variable (X = True, - = False, Space = Unknown) Show values
Column Name Description Domain name
InspectionResultStatusText Inspection Result Status Text QKURZTEXT
InspectionResultStatus Specification Record Status QSTATUS
InspectionSpecificationText Short Text for Inspection Characteristic QKURZTEXT
InspectionResultMeanValue Arithmetic Mean of Valid Measured Values QSTATWERT
CharacteristicAttributeCode Code QCODE
CharacteristicAttributeCodeGrp Code Group QCODEGRP
InspLotTestEquipInternalID Assigned Test Equipment PZLFH
InspectionMethodText Short Text QKURZTEXT
InspectionMethodVersion Version Number of Inspection Method QVERSNR
InspCharacteristicSampleSize Sample Size that Has to Be Inspected for a Characteristic QANZAHL4
InspSpecSampleQuantityFactor Sample Quantity Factor for Sample(Mult. Sample Unit of Msr.) QPROBEFAK
InspSpecControlIndicators Cntrl Indicator String for Insp. Char./Master Insp. Char. QMKCONTROL
InspSpecTargetValue Target Value for a Quantitative Characteristic QSOLLWERTE
InspSpecUpperLimit Upper Specification Limit QSOLLWERTE
InspSpecLowerLimit Lower Specification Limit QSOLLWERTE
UnitOfMeasureTechnicalName External Unit of Measurement in Technical Format (6-Char.) MSEH6
InspectionSpecificationPlant Plant for Master Inspection Characteristic QZAEHLER
InspectionSpecificationVersion Version Number of Master Inspection Characteristic QVERSNR
SelectedCodeSet Assigned Code Group or Selected Set QCGRAUSW
SelectedCodeSetText Short Description of Selected Set QKURZTEXT
InspectionResultText Inspection Description for Summarized Result QKURZTEXT
InspSampleAcceptanceNumber Acceptance Number QINT2NEG
InspSampleRejectionNumber Rejection Number QANZAHL2
InspectionSampleSize Sample Size that Must Be Inspected QANZAHL4
WorkCenter Work Center ARBPL
InspectionOperation Operation or Phase Number VDM_VORNR
LastChangedByUser Name of User Who Last Changed Data Record QAENDERER
CreatedByUser Name of User Who Created the Data Record QAENDERER
InspRsltBelowToleranceValsNmbr Number of Measured Values Below Tolerance Range QANZAHL4
InspRsltAboveToleranceValsNmbr Number of Measured Values Above Tolerance Range QANZAHL4
InspRsltNonconformingValsNmbr Number of Nonconforming Sample Units QANZAHL4
InspRsltAboveToleranceFraction Estimated Fraction Above Tolerance Range QSTATWERT
InspRsltBelowToleranceFraction Estimated Fraction Below Tolerance Range QSTATWERT
InspResultValidValuesNumber Number of Inspected Sample Units QANZAHL4
InspResultVariance Dispersion (Variance) of Valid Measured Values QSTATWERT
Inspector Name of Inspector QPRUEFER
CharacteristicAttributeCodeTxt Text for Code QKURZTEXT
InspectionNonconformingRatio null
InspectionValuationResultText Inspection Result Valuation Text DDTEXT
InspSpecIsQuantitative null
InspSpecIsLongTermInspection null
InspSpecRecordingType null
InspSpecCharcCategory null
InspSpecResultCalculation null
BOOCharcGroup Characteristic Group QCHARGROUP
BOOCharcSourceCharc Source Characteristic of Characteristic Group Division QMERKNRP
BOOCharcGroupDivision Internal Division ID QDIVISIONINT
ProductionOrderOperationActy Identifies an Operation Activity MPE_OAN_ELEMENT_ID
ProductionOrderOpActyVers Number of an Operation Actiivity Version
InspRsltRecgViewTemplate null
Master Data Relations Join Conditions
Batch Number
  • Material Number
  • Batch Number
  • Client
  • I_OPACTYPLANINSPCHARINFO.MATERIAL == MCH1.MATNR
  • I_OPACTYPLANINSPCHARINFO.BATCH == MCH1.CHARG
  • I_OPACTYPLANINSPCHARINFO.MANDT == MCH1.MANDT
Sample Unit of Measure
  • Client
  • Sample Unit of Measure
  • Sample Unit of Measure
  • I_OPACTYPLANINSPCHARINFO.MANDT == T006.MANDT
  • I_OPACTYPLANINSPCHARINFO.INSPCHARACTERISTICSAMPLEUNIT == T006.MSEHI
  • I_OPACTYPLANINSPCHARINFO.QUANTITYUNIT == T006.MSEHI
Base Unit of Measure for Inspection Lot Quantity
  • Client
  • Base Unit of Measure for Inspection Lot Quantity
  • I_OPACTYPLANINSPCHARINFO.MANDT == T006.MANDT
  • I_OPACTYPLANINSPCHARINFO.INSPECTIONLOTQUANTITYUNIT == T006.MSEHI
Inspection Type
  • Inspection Type
  • Client
  • I_OPACTYPLANINSPCHARINFO.INSPECTIONLOTTYPE == TQ30.ART
  • I_OPACTYPLANINSPCHARINFO.MANDT == TQ30.MANDT
Inspection Method
  • Inspection Method
  • Version Number of Inspection Method
  • Client
  • Plant for Inspection Method
  • I_OPACTYPLANINSPCHARINFO.INSPECTIONMETHOD == QMTB.PMTNR
  • I_OPACTYPLANINSPCHARINFO.INSPECTIONMETHODVERSION == QMTB.VERSION
  • I_OPACTYPLANINSPCHARINFO.MANDT == QMTB.MANDT
  • I_OPACTYPLANINSPCHARINFO.INSPECTIONMETHODPLANT == QMTB.WERKS
Plant for Inspection Method
  • Client
  • Plant for Inspection Method
  • I_OPACTYPLANINSPCHARINFO.MANDT == T001W.MANDT
  • I_OPACTYPLANINSPCHARINFO.INSPECTIONMETHODPLANT == T001W.WERKS
Master Inspection Characteristic
  • Plant for Master Inspection Characteristic
  • Version Number of Inspection Method
  • Master Inspection Characteristic
  • Client
  • I_OPACTYPLANINSPCHARINFO.INSPECTIONSPECIFICATIONPLANT == QPMK.ZAEHLER
  • I_OPACTYPLANINSPCHARINFO.INSPECTIONMETHODVERSION == QPMK.VERSION
  • I_OPACTYPLANINSPCHARINFO.INSPECTIONSPECIFICATION == QPMK.MKMNR
  • I_OPACTYPLANINSPCHARINFO.MANDT == QPMK.MANDT
Unit of Measurement in Which Quantitative Data Is Stored
  • Unit of Measurement in Which Quantitative Data Is Stored
  • Client
  • I_OPACTYPLANINSPCHARINFO.INSPECTIONSPECIFICATIONUNIT == T006.MSEHI
  • I_OPACTYPLANINSPCHARINFO.MANDT == T006.MANDT
Valuation Rule
  • Valuation Rule
  • Client
  • I_OPACTYPLANINSPCHARINFO.INSPSAMPLEVALUATIONRULE == QDFM.FBKEY
  • I_OPACTYPLANINSPCHARINFO.MANDT == QDFM.MANDT
Weighting of Characteristic
  • Weighting of Characteristic
  • Client
  • I_OPACTYPLANINSPCHARINFO.INSPSPECIMPORTANCECODE == TQ17A.MERKKLASSE
  • I_OPACTYPLANINSPCHARINFO.MANDT == TQ17A.MANDT
Order Number (Production Order)
  • Order Number (Production Order)
  • Client
  • I_OPACTYPLANINSPCHARINFO.MANUFACTURINGORDER == AUFK.AUFNR
  • I_OPACTYPLANINSPCHARINFO.MANDT == AUFK.MANDT
Material Number
  • Material Number
  • Client
  • I_OPACTYPLANINSPCHARINFO.MATERIAL == MARA.MATNR
  • I_OPACTYPLANINSPCHARINFO.MANDT == MARA.MANDT
Material Authorization Group for Activities in QM
  • Material Authorization Group for Activities in QM
  • Client
  • I_OPACTYPLANINSPCHARINFO.MATLQUALITYAUTHORIZATIONGROUP == TQ01B.QMATAUTH
  • I_OPACTYPLANINSPCHARINFO.MANDT == TQ01B.MANDT
Plant
  • Plant
  • Client
  • I_OPACTYPLANINSPCHARINFO.PLANT == T001W.WERKS
  • I_OPACTYPLANINSPCHARINFO.MANDT == T001W.MANDT
Sample Unit of Measure
  • Client
  • Sample Unit of Measure
  • Sample Unit of Measure
  • I_OPACTYPLANINSPCHARINFO.MANDT == T006.MANDT
  • I_OPACTYPLANINSPCHARINFO.INSPCHARACTERISTICSAMPLEUNIT == T006.MSEHI
  • I_OPACTYPLANINSPCHARINFO.QUANTITYUNIT == T006.MSEHI