I_MfgOrdPlanInspCharInfo

Order PIC Info | view: IORDPIC | TRAN | Extraction: Not supported | Component: Shop Floor Execution
Tables used: QAMVQALSAFVCQAOPQAMRQAPPQASVQASRQPAMQPAMTXTQPCTTQ30TQ30TQMTBQMTTTQ77TQ73TQ73TTQ76TQ76TTQ77TTQ17ATQ17UMAKTT006T006ACRHDTQSS1
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
📏 Sample Unit of Measure (InspCharacteristicSampleUnit):
InspectionScope Quantity to Be Inspected
Column Name Description
InspectionLotStartTime Inspection Started At
InspectionLotEndDate End Date of Inspection in Local Time Zone
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
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
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 null
InspectionResultStatus null
InspectionSpecificationText Short Text for Inspection Characteristic QKURZTEXT
OperationText Operation Short Text TEXT40
InspectionResultMeanValue Arithmetic Mean of Valid Measured Values QSTATWERT
CharacteristicAttributeCode Code QCODE
CharacteristicAttributeCodeGrp Code Group QCODEGRP
InspectionResultOriginText Short Text QKURZTEXT
InspectionLotTypeText Inspection Type Text QKURZTEXT
InspLotTestEquipInternalID Assigned Test Equipment PZLFH
InspectionMethod Inspection Method QPMETHODE
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
InspSampleValuationRule Valuation Rule QKEY1
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/Activity Number 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
InspectionResultAttributeText Short Text QKURZTEXT
InspResultVariance Dispersion (Variance) of Valid Measured Values QSTATWERT
Inspector Name of Inspector QPRUEFER
CharacteristicAttributeCodeTxt Text for Code QKURZTEXT
InspectionNonconformingRatio null
MaterialName Material Description TEXT40
InspSpecSummarizedDcmlPlaces null
InspectionValuationResultText Inspection Result Valuation Text DDTEXT
InspSpecIsQuantitative null
InspSpecIsLongTermInspection null
InspSpecRecordingType null
InspSpecCharcCategory null
InspSpecResultCalculation null
InspectionSubsetLongCharKey User Field for 18 Characters QUSRCHAR18
LinkedSAPObjectKey null
InspResultValueCount null
InspSpecImportanceCodeText Short Text QKURZTEXT
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
  • Client
  • Batch Number
  • Material Number
  • I_MFGORDPLANINSPCHARINFO.MANDT == MCH1.MANDT
  • I_MFGORDPLANINSPCHARINFO.BATCH == MCH1.CHARG
  • I_MFGORDPLANINSPCHARINFO.MATERIAL == MCH1.MATNR
Sample Unit of Measure
  • Client
  • Sample Unit of Measure
  • Sample Unit of Measure
  • I_MFGORDPLANINSPCHARINFO.MANDT == T006.MANDT
  • I_MFGORDPLANINSPCHARINFO.INSPCHARACTERISTICSAMPLEUNIT == T006.MSEHI
  • I_MFGORDPLANINSPCHARINFO.QUANTITYUNIT == T006.MSEHI
Base Unit of Measure for Inspection Lot Quantity
  • Client
  • Base Unit of Measure for Inspection Lot Quantity
  • I_MFGORDPLANINSPCHARINFO.MANDT == T006.MANDT
  • I_MFGORDPLANINSPCHARINFO.INSPECTIONLOTQUANTITYUNIT == T006.MSEHI
Inspection Type
  • Client
  • Inspection Type
  • I_MFGORDPLANINSPCHARINFO.MANDT == TQ30.MANDT
  • I_MFGORDPLANINSPCHARINFO.INSPECTIONLOTTYPE == TQ30.ART
Plant for Inspection Method
  • Client
  • Plant for Inspection Method
  • I_MFGORDPLANINSPCHARINFO.MANDT == T001W.MANDT
  • I_MFGORDPLANINSPCHARINFO.INSPECTIONMETHODPLANT == T001W.WERKS
Master Inspection Characteristic
  • Client
  • Version Number of Inspection Method
  • Master Inspection Characteristic
  • Plant for Master Inspection Characteristic
  • I_MFGORDPLANINSPCHARINFO.MANDT == QPMK.MANDT
  • I_MFGORDPLANINSPCHARINFO.INSPECTIONMETHODVERSION == QPMK.VERSION
  • I_MFGORDPLANINSPCHARINFO.INSPECTIONSPECIFICATION == QPMK.MKMNR
  • I_MFGORDPLANINSPCHARINFO.INSPECTIONSPECIFICATIONPLANT == QPMK.ZAEHLER
Unit of Measurement in Which Quantitative Data Is Stored
  • Client
  • Unit of Measurement in Which Quantitative Data Is Stored
  • I_MFGORDPLANINSPCHARINFO.MANDT == T006.MANDT
  • I_MFGORDPLANINSPCHARINFO.INSPECTIONSPECIFICATIONUNIT == T006.MSEHI
Weighting of Characteristic
  • Client
  • Weighting of Characteristic
  • I_MFGORDPLANINSPCHARINFO.MANDT == TQ17A.MANDT
  • I_MFGORDPLANINSPCHARINFO.INSPSPECIMPORTANCECODE == TQ17A.MERKKLASSE
Order Number (Production Order)
  • Client
  • Order Number (Production Order)
  • I_MFGORDPLANINSPCHARINFO.MANDT == AUFK.MANDT
  • I_MFGORDPLANINSPCHARINFO.MANUFACTURINGORDER == AUFK.AUFNR
Material Number
  • Client
  • Material Number
  • I_MFGORDPLANINSPCHARINFO.MANDT == MARA.MANDT
  • I_MFGORDPLANINSPCHARINFO.MATERIAL == MARA.MATNR
Material Authorization Group for Activities in QM
  • Client
  • Material Authorization Group for Activities in QM
  • I_MFGORDPLANINSPCHARINFO.MANDT == TQ01B.MANDT
  • I_MFGORDPLANINSPCHARINFO.MATLQUALITYAUTHORIZATIONGROUP == TQ01B.QMATAUTH
Plant
  • Client
  • Plant
  • I_MFGORDPLANINSPCHARINFO.MANDT == T001W.MANDT
  • I_MFGORDPLANINSPCHARINFO.PLANT == T001W.WERKS
Sample Unit of Measure
  • Client
  • Sample Unit of Measure
  • Sample Unit of Measure
  • I_MFGORDPLANINSPCHARINFO.MANDT == T006.MANDT
  • I_MFGORDPLANINSPCHARINFO.INSPCHARACTERISTICSAMPLEUNIT == T006.MSEHI
  • I_MFGORDPLANINSPCHARINFO.QUANTITYUNIT == T006.MSEHI