I_InspPlanOpCharcTP

Inspection Plan Characteristic Version | view: IINSPPLOPCHARCTP | Extraction: Not supported | Component: Quality Planning
Tables used: DRATPLKOPLPOPLMKPLFHPLASCRVD_ADRAWEQUICRVE_AEQKTEQUZIFLOTT002CRVM_AMAKTIMPTTCRVS_ACRVP_AIMPTTTCF02TCF03CRFHCRTXT006T006DT006A
Column Name Description
InspectionPlanGroup Key for Task List Group
InspectionPlan Group Counter
InspectionPlanInternalVersion Internal counter
BOOOperationInternalID Number of the Task List Node
BOOOpInternalVersionCounter Internal counter
BOOCharacteristic Inspection Characteristic Number
BOOCharacteristicVersion Internal counter
BillOfOperationsType Task List Type
Column Name Description
Column Name Description
Column Name Description
CreationDate System Date on Which Data Record Was Created
LastChangeDate System Date on Which Data Record Was Changed
ValidityStartDate Valid-From Date
ValidityEndDate Valid-to date
Column Name Description
IsDeleted Deletion Indicator Show values
InspSpecTransferType Copy Model/Reference Characteristic Show values
BOOCharcHasInspSpecReference Reference to Master Insp. Characteristic in Task List Show values
InspSpecIsQuantitative Quantitative Characteristic Show values
InspSpecCharacteristicType Characteristic Type Show values
InspSpecIsMeasuredValueRqd Measured Values Must Be Recorded Show values
InspSpecIsSelectedSetRequired Reference to Characteristic Attribute Required Show values
InspSpecIsUpperLimitRequired Upper Specification Limit Show values
InspSpecIsLowerLimitRequired Lower Specification Limit Show values
InspSpecIsTargetValueInLimit Check Target Value Show values
InspectionScope Inspection Scope Show values
InspSpecIsLongTermInspection Long-Term Inspection Show values
InspSpecRecordingType Recording Type Show values
InspResultIsDocumentationRqd Documentation Required for Inspection Result Show values
InspSpecCharcCategory Characteristic Category Show values
InspSpecIsSampleQtyAdditive Inspection Sample Quantity Is Added Show values
InspSpecIsDestructive Destructive Inspection Show values
InspSpecResultCalculation Characteristic Result Calculation Show values
InspSpecIsSamplingProcedRqd Sampling Procedure Is Required Show values
InspSpecIsScrapRelevant Characteristic Relevant for Quality Score and Scrap Share Show values
InspSpecHasFixedCtrlIndicators Default Control Indicators Cannot Be Changed Show values
InspSpecIsTestEquipmentRqd Assignment of Test Equipment Required Show values
InspSpecIsDefectsRecgAutomatic Defects Recording Automatically Called Up Show values
InspSpecIsChgDocRequired Create Change Documents During Results Recording Show values
InspSpecIsControlChartUsed SPC Characteristic Show values
InspSpecPrintControl Inspection Print Control Show values
InspSpecIsDefectRecordingRqd Recording the Number of Defects Show values
InspSpecDecimalPlaces Number of Places to the Right of a Decimal Point (Accuracy) Show values
InspSpecHasTargetValue Value Not Initial if Set Show values
InspSpecHasLowerLimit Value Not Initial if Set Show values
InspSpecHasUpperLimit Value Not Initial if Set Show values
InspSpecHasClassWidth Value Not Initial if Set Show values
InspSpecHasClassMidpoint Value Not Initial if Set Show values
MatlIsConsideredForDynModif Material Considered for Dynamic Modification Show values
SuplrIsConsideredForDynModif Supplier Considered for Dynamic Modification Show values
MfrIsConsideredForDynModif Manufacturer Considered for Dynamic Modification Show values
CustIsConsideredForDynModif Customer Considered for Dynamic Modification Show values
Column Name Description Domain name
OperationText Operation Short Text TEXT40
Operation Operation/Activity Number VORNR
BillOfOperationsDesc Routing Description TEXT40
BOOOperationPRTInternalID Assigned Test Equipment PZLFH
IsValid null
InspectionMethodVersion Version Number of Inspection Method QVERSNR
InspectionSpecificationVersion Version Number of Master Inspection Characteristic QVERSNR
InspectionSpecificationPlant Plant for the Master Inspection Characteristic QZAEHLER
InspSpecInformationField1 Text Line for Additional Information QTXT10
InspSpecInformationField2 Text Line for Additional Information QTXT20
InspSpecInformationField3 Text Line for Additional Information QTXT40
InspectionSpecificationText Short Text for Inspection Characteristic QKURZTEXT
ProductionResourceTool Production Resource/Tool Number FHMNR
ProductionResourceToolDesc Description of the Production Resource/Tool TEXT40
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
InspSpecHasFormula Check and Calculate Formula in QM QFORMELSL
InspSpecFormula1 Formula Field QFORMEL
InspSpecFormula2 Formula Field QFORMEL
InspSpecNumberOfClasses Number of Value Classes for Inspection Results QKLASSZAHL
InspSpecClassWidthQty Class Width QSOLLWERTE
InspSpecClassMidpointQty Class Midpoint QSOLLWERTE
InspSpecDefectCodeGrpRejection Defect Code Group for General Rejection QCODEGRP
InspSpecDefectCodeRejection Defect Code for Rejection: General QCODE
InspSpecDefectCodeGrpRjcnUpper Defect Code Group for Rejection at Upper Tolerance QCODEGRP
InspSpecDefectCodeRjcnUpper Defect Code for Rejection at Upper Specification Limit QCODE
InspSpecDefectCodeGrpRjcnLower Defect Code Group for Rejection at Lower Tolerance QCODEGRP
InspSpecDefectCodeRjcnLower Defect Code for Rejection at Lower Specification Limit QCODE
SelectedCodeSet Assigned Code Group or Selected Set QCGRAUSW
InspSpecAdditionalSelectedSet2 Assigned Code Group or Selected Set QCGRAUSW
InspSpecAdditionalCodeGroup2 Assigned Code Group or Selected Set QCGRAUSW
InspSpecAdditionalSelectedSet3 Assigned Code Group or Selected Set QCGRAUSW
InspSpecAdditionalCodeGroup3 Assigned Code Group or Selected Set QCGRAUSW
InspSpecAdditionalSelectedSet4 Assigned Code Group or Selected Set QCGRAUSW
InspSpecAdditionalCodeGroup4 Assigned Code Group or Selected Set QCGRAUSW
InspSpecAdditionalSelectedSet5 Assigned Code Group or Selected Set QCGRAUSW
InspSpecAdditionalCodeGroup5 Assigned Code Group or Selected Set QCGRAUSW
SamplingProcedure Sampling Procedure in Inspection Characteristic QSTPRVER
BOOCharcSampleQuantity Sample Quantity Factor for Sample(Mult. Sample Unit of Msr.) QPROBEFAK
InspCharcDynModifRef Characteristic (in Plan) whose Q-Level Will Be Copied QMERKNRP
CreatedByUser User who created record USNAM
LastChangedByUser Name of User Who Last Changed Data Record QAENDERER
ChangeNumber Change Number AENNR
BillOfOperationsVersion Routing Version PLNVERSN
Master Data Relations Join Conditions
Sample Unit of Measure
  • Client
  • Sample Unit of Measure
  • I_INSPPLANOPCHARCTP.MANDT == T006.MANDT
  • I_INSPPLANOPCHARCTP.INSPCHARACTERISTICSAMPLEUNIT == T006.MSEHI
Foreign key inspection method master
  • Inspection Method
  • Version Number of Inspection Method
  • Plant for Inspection Method
  • Client
  • I_INSPPLANOPCHARCTP.INSPECTIONMETHOD == QMTB.PMTNR
  • I_INSPPLANOPCHARCTP.INSPECTIONMETHODVERSION == QMTB.VERSION
  • I_INSPPLANOPCHARCTP.INSPECTIONMETHODPLANT == QMTB.WERKS
  • I_INSPPLANOPCHARCTP.MANDT == QMTB.MANDT
Plant for Inspection Method
  • Plant for Inspection Method
  • Client
  • I_INSPPLANOPCHARCTP.INSPECTIONMETHODPLANT == T001W.WERKS
  • I_INSPPLANOPCHARCTP.MANDT == T001W.MANDT
Master Inspection Characteristic
  • Version Number of Master Inspection Characteristic
  • Plant for the Master Inspection Characteristic
  • Master Inspection Characteristic
  • Client
  • I_INSPPLANOPCHARCTP.INSPECTIONSPECIFICATIONVERSION == QPMK.VERSION
  • I_INSPPLANOPCHARCTP.INSPECTIONSPECIFICATIONPLANT == QPMK.ZAEHLER
  • I_INSPPLANOPCHARCTP.INSPECTIONSPECIFICATION == QPMK.MKMNR
  • I_INSPPLANOPCHARCTP.MANDT == QPMK.MANDT
Unit of Measurement in Which Quantitative Data Is Stored
  • Unit of Measurement in Which Quantitative Data Is Stored
  • Client
  • I_INSPPLANOPCHARCTP.INSPECTIONSPECIFICATIONUNIT == T006.MSEHI
  • I_INSPPLANOPCHARCTP.MANDT == T006.MANDT
Inspector Qualification
  • Client
  • Inspector Qualification
  • I_INSPPLANOPCHARCTP.MANDT == TQ11.MANDT
  • I_INSPPLANOPCHARCTP.INSPECTORQUALIFICATION == TQ11.PRFQL
Dynamic Modification Rule
  • Dynamic Modification Rule
  • Client
  • I_INSPPLANOPCHARCTP.INSPLOTDYNAMICRULE == QDDR.DYNREGEL
  • I_INSPPLANOPCHARCTP.MANDT == QDDR.MANDT
Catalog Type of Assigned Code Group or Selected Set
  • Catalog Type of Assigned Code Group or Selected Set
  • Client
  • I_INSPPLANOPCHARCTP.INSPSPECADDITIONALCATALOG2 == TQ15.KATALOGART
  • I_INSPPLANOPCHARCTP.MANDT == TQ15.MANDT
Catalog Type of Assigned Code Group or Selected Set
  • Catalog Type of Assigned Code Group or Selected Set
  • Client
  • I_INSPPLANOPCHARCTP.INSPSPECADDITIONALCATALOG3 == TQ15.KATALOGART
  • I_INSPPLANOPCHARCTP.MANDT == TQ15.MANDT
Catalog Type of Assigned Code Group or Selected Set
  • Catalog Type of Assigned Code Group or Selected Set
  • Client
  • I_INSPPLANOPCHARCTP.INSPSPECADDITIONALCATALOG4 == TQ15.KATALOGART
  • I_INSPPLANOPCHARCTP.MANDT == TQ15.MANDT
Catalog Type of Assigned Code Group or Selected Set
  • Catalog Type of Assigned Code Group or Selected Set
  • Client
  • I_INSPPLANOPCHARCTP.INSPSPECADDITIONALCATALOG5 == TQ15.KATALOGART
  • I_INSPPLANOPCHARCTP.MANDT == TQ15.MANDT
Plant of the Assigned Selected Set
  • Plant of the Assigned Selected Set
  • Client
  • I_INSPPLANOPCHARCTP.INSPSPECADDLSELDCODESETPLANT2 == T001W.WERKS
  • I_INSPPLANOPCHARCTP.MANDT == T001W.MANDT
Plant of the Assigned Selected Set
  • Plant of the Assigned Selected Set
  • Client
  • I_INSPPLANOPCHARCTP.INSPSPECADDLSELDCODESETPLANT3 == T001W.WERKS
  • I_INSPPLANOPCHARCTP.MANDT == T001W.MANDT
Plant of the Assigned Selected Set
  • Plant of the Assigned Selected Set
  • Client
  • I_INSPPLANOPCHARCTP.INSPSPECADDLSELDCODESETPLANT4 == T001W.WERKS
  • I_INSPPLANOPCHARCTP.MANDT == T001W.MANDT
Plant of the Assigned Selected Set
  • Plant of the Assigned Selected Set
  • Client
  • I_INSPPLANOPCHARCTP.INSPSPECADDLSELDCODESETPLANT5 == T001W.WERKS
  • I_INSPPLANOPCHARCTP.MANDT == T001W.MANDT
Weighting of Characteristic
  • Weighting of Characteristic
  • Client
  • I_INSPPLANOPCHARCTP.INSPSPECIMPORTANCECODE == TQ17A.MERKKLASSE
  • I_INSPPLANOPCHARCTP.MANDT == TQ17A.MANDT
Parameters for Input Processing in QM Results Recording
  • Parameters for Input Processing in QM Results Recording
  • Client
  • I_INSPPLANOPCHARCTP.INSPSPECINPUTPROCEDURE == TQ71.INPPROC
  • I_INSPPLANOPCHARCTP.MANDT == TQ71.MANDT
Tolerance Key
  • Client
  • Tolerance Key
  • I_INSPPLANOPCHARCTP.MANDT == TQ29.MANDT
  • I_INSPPLANOPCHARCTP.INSPTOLERANCESPECIFICATION == TQ29.TOLERANZSL
SPC Criterion
  • SPC Criterion
  • Client
  • I_INSPPLANOPCHARCTP.QLTYCTRLCHARTAGGRGNCRITERION == QPSP.SPCKRIT
  • I_INSPPLANOPCHARCTP.MANDT == QPSP.MANDT
Plant of the Assigned Selected Set
  • Plant of the Assigned Selected Set
  • Client
  • I_INSPPLANOPCHARCTP.SELECTEDCODESETPLANT == T001W.WERKS
  • I_INSPPLANOPCHARCTP.MANDT == T001W.MANDT