QINSSPEC_D - I_INSPSPECIFICATIONVERSIONTP I_INSPSPECIFICATIONVERSIONTP

I_INSPSPECIFICATIONVERSIONTP I_INSPSPECIFICATIONVERSIONTP information is stored in SAP table QINSSPEC_D.
It is part of development package VDM_QM_PLANNING in software component QM-PT. This development package consists of objects that can be grouped under "CDS views for Inspection Planning".

Fields for table QINSSPEC_D

Field Name	Description	Is Key	Data Element	Data Type	Length
MANDT	Client	X	MANDT	CLNT	6
DRAFTUUID	UUID serving as key (parent key, root key)	X	/BOBF/UUID	RAW	16
INSPECTIONSPECIFICATIONPLANT	Plant for the Master Inspection Characteristic		QZAEHLER	CHAR	8
INSPECTIONSPECIFICATION	Master Inspection Characteristic		VDM_QMERKNR	CHAR	16
INSPECTIONSPECIFICATIONVERSION	Version Number of Master Inspection Characteristic		QVERSNRMK	CHAR	12
PLANT	Plant		WERKS_D	CHAR	8
VALIDITYSTARTDATE	Valid-From Date		DATUV	DATS	16
INSPECTIONSPECIFICATIONSRCHTXT	Search Field		QSORTFELD	CHAR	80
INSPSPECGLOBALNAME	Characteristic Description for Quality Data Exchange		QCHARACT_ID1	CHAR	80
INSPECTIONSPECIFICATIONSTATUS	Status of Master Record		QLOESCHKZ	CHAR	2
INSPSPECTRANSFERTYPE	Copy Model/Reference Characteristic		VDM_QVOLLST	CHAR	2
INSPSPECCREATEDBYUSER	Name of User Who Created the Data Record		QERSTELLER	CHAR	24
INSPSPECCREATIONDATE	System Date on Which Data Record Was Created		QDATUMERST	DATS	16
INSPSPECCHANGEDBYUSER	Name of User Who Last Changed Data Record		QAENDERER	CHAR	24
INSPSPECCHANGEDATE	System Date on Which Data Record Was Changed		QDATUMAEND	DATS	16
CHANGEDDATETIME	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)		TZNTSTMPS	DEC	8
INSPSPECCONTROLINDICATORS	Cntrl Indicator String for Insp. Char./Master Insp. Char.		QMKCONTROL	CHAR	60
INSPSPECISQUANTITATIVE	Is Quantitative Characteristic		VDM_QKZQUNMK	CHAR	2
INSPSPECCHARACTERISTICTYPE	Characteristic Type		VDM_QCHAR_TYPE_BASIC	CHAR	2
INSPSPECISMEASUREDVALUERQD	Measured Values Must Be Recorded		QKZQUMK	CHAR	2
INSPSPECISSELECTEDSETREQUIRED	Reference to Characteristic Attribute Required		QKZPKAT	CHAR	2
INSPSPECISUPPERLIMITREQUIRED	Upper Specification Limit		QKZTOLOB	CHAR	2
INSPSPECISLOWERLIMITREQUIRED	Lower Specification Limit		QKZTOLUN	CHAR	2
INSPSPECISTARGETVALUEINLIMIT	Check Target Value		QKZSOLLPR	CHAR	2
INSPECTIONSCOPE	Inspection Scope		QPUMFKZ	CHAR	2
INSPSPECISLONGTERMINSPECTION	Long-Term Inspection		QLZEITKZ	CHAR	2
INSPSPECRECORDINGTYPE	Recording Type		QESTUKZ	CHAR	2
INSPRESULTISDOCUMENTATIONRQD	Documentation Required for Inspection Results		QDOKUKZ	CHAR	2
INSPSPECCHARCCATEGORY	Characteristic Category		QRZWANG	CHAR	2
INSPSPECISSAMPLEQTYADDITIVE	Inspection Sample Quantity Is Added		QADDPRO	CHAR	2
INSPSPECISDESTRUCTIVE	Destructive Inspection		QKZDESTROY	CHAR	2
INSPSPECRESULTCALCULATION	Calculated Characteristic		QKZFORMEL	CHAR	2
INSPSPECISSAMPLINGPROCEDRQD	Sampling Procedure Is Required		QSTICHPR	CHAR	2
INSPSPECISSCRAPRELEVANT	Characteristic Relevant for Quality Score and Scrap Share		QAUSSLOS	CHAR	2
INSPSPECHASFIXEDCTRLINDICATORS	Default Control Indicators Cannot Be Changed		QNAENDKZ	CHAR	2
INSPSPECISTESTEQUIPMENTRQD	Assignment of Test Equipment Required		QPMZWANG	CHAR	2
INSPSPECISDEFECTSRECGAUTOMATIC	Defects Recording Automatically Called Up		QFEHLREC	CHAR	2
INSPSPECISCHGDOCREQUIRED	Create Change Documents During Results Recording		QKZAENBEL	CHAR	2
INSPSPECISCONTROLCHARTUSED	SPC Characteristic		QSPCMK	CHAR	2
INSPSPECPRINTCONTROL	Print		QDRUCK1	CHAR	2
INSPSPECIMPORTANCECODE	Weighting of Characteristic		QMERKGEW	CHAR	4
INSPECTORQUALIFICATION	Inspector Qualification		QPRQUALIF	CHAR	10
INSPSPECINFORMATIONFIELD1	Text Line for Additional Information		QTXT10	CHAR	20
INSPSPECINFORMATIONFIELD2	Text Line for Additional Information		QTXT20	CHAR	40
INSPSPECINFORMATIONFIELD3	Text Line for Additional Information		QTXT40	CHAR	80
QLTYMSTRDATAAUTHORIZATIONGROUP	Authorization Group QM Master Data		QMASTAUTH	CHAR	16
INSPTOLERANCESPECIFICATION	Tolerance Key		QTOLERANZ	CHAR	8
INSPSPECDECIMALPLACES	Number of Places to the Right of a Decimal Point (Accuracy)		QSTELLEN	INT1	1
INSPECTIONSPECIFICATIONUNIT	Unit of Measurement in Which Quantitative Data Is Stored		QMASSEH	UNIT	6
INSPSPECTARGETVALUE	Target Value for a Quantitative Characteristic		QSOLLWERTE	FLTP	8
INSPSPECHASTARGETVALUE	Value Not Initial if Set		QNINITIAL	CHAR	2
INSPSPECUPPERLIMIT	Upper Specification Limit		QTOLOB	FLTP	8
INSPSPECHASUPPERLIMIT	Value Not Initial if Set		QNINITIAL	CHAR	2
INSPSPECLOWERLIMIT	Lower Specification Limit		QTOLUN	FLTP	8
INSPSPECHASLOWERLIMIT	Value Not Initial if Set		QNINITIAL	CHAR	2
INSPSPECFIRSTUPPERSPECLIMIT	First Upper Specification Limit		QGRENZOB1	FLTP	8
INSPSPECHASFIRSTUPPERSPECLIMIT	Value Not Initial if Set		QNINITIAL	CHAR	2
INSPSPECFIRSTLOWERSPECLIMIT	First Lower Specification Limit		QGRENZUN1	FLTP	8
INSPSPECHASFIRSTLOWERSPECLIMIT	Value Not Initial if Set		QNINITIAL	CHAR	2
INSPSPECSECONDUPPERSPECLIMIT	Second Upper Specification Limit		QGRENZOB2	FLTP	8
INSPSPECHASSECONDUPRSPECLIMIT	Value Not Initial if Set		QNINITIAL	CHAR	2
INSPSPECSECONDLOWERSPECLIMIT	Second Lower Specification Limit		QGRENZUN2	FLTP	8
INSPSPECHASSECONDLOWRSPECLIMIT	Value Not Initial if Set		QNINITIAL	CHAR	2
INSPSPECUPPERPLAUSIBILITYLIMIT	Upper Plausibility Limit		QPLAUSIOB	FLTP	8
INSPSPECHASUPRPLAUSIBILITYLMT	Value Not Initial if Set		QNINITIAL	CHAR	2
INSPSPECLOWERPLAUSIBILITYLIMIT	Lower Plausibility Limit		QPLAUSIUN	FLTP	8
INSPSPECHASLOWRPLAUSIBILITYLMT	Value Not Initial if Set		QNINITIAL	CHAR	2
INSPSPECUPPERSPECLIMITCHANGE	Change to Upper Specification Limit		QTOLWOB	FLTP	8
INSPSPECHASUPRSPECLIMITCHANGE	Value Not Initial if Set		QNINITIAL	CHAR	2
INSPSPECLOWERSPECLIMITCHANGE	Change to Lower Specification Limit		QTOLWUN	FLTP	8
INSPSPECHASLOWRSPECLIMITCHANGE	Value Not Initial if Set		QNINITIAL	CHAR	2
INSPSPECTOLERANCECHGVALIDFROM	Date from Which the Tolerance Change Is Valid		QTOLWAB	DATS	16
INSPSPECTOLERANCECHGVALIDTO	Date Until Which the Tolerance Change Is Valid		QTOLWBIS	DATS	16
INSPSPECDEFECTCODEGRPRJCNLOWER	Defect Code Group for Rejection at Lower Tolerance		QCODEGRPU	CHAR	16
INSPSPECDEFECTCODERJCNLOWER	Defect Code for Rejection at Lower Specification Limit		QCODEU	CHAR	8
INSPSPECDEFECTCODEGRPRJCNUPPER	Defect Code Group for Rejection at Upper Tolerance		QCODEGRPO	CHAR	16
INSPSPECDEFECTCODERJCNUPPER	Defect Code for Rejection at Upper Specification Limit		QCODEO	CHAR	8
CHARCINTERNALID	Characteristic Internal ID		ATINN_NO_CONV	NUMC	20
CHARACTERISTICINTERNALID	Characteristic Internal ID		ATINN_NO_CONV	NUMC	20
CHARACTERISTIC	Characteristic Name		ATNAM	CHAR	60
CHARCDESCRIPTION	Characteristic description		ATBEZ	CHAR	60
CHARACTERISTICDESCRIPTION	Characteristic description		ATBEZ	CHAR	60
DEFECTFRACTIONESTIMATIONPROCED	Fraction Calculation		VDM_QEANTVERF	CHAR	4
INSPSPECDEFECTCODEGRPREJECTION	Defect Code Group for General Rejection		QCODEGRPQL	CHAR	16
INSPSPECDEFECTCODEREJECTION	Defect Code for Rejection: General		QCODEQL	CHAR	8
INSPSPECDETERMINATIONRULE	Specification Determination Rule		QASDR_SPEC_DET_RULE	CHAR	6
INSPSPECISDETNRULEACTIVE	Active Indicator for Specification Determination Rule		QASDR_SDR_ACTIVE	CHAR	2
HASACTIVEENTITY	Draft - Indicator - Has active document		SDRAFT_HAS_ACTIVE	CHAR	2
.INCLUDE				SDRAFT_WRITE_DRAFT_ADMIN	0
DRAFTENTITYCREATIONDATETIME	Draft Created On		SDRAFT_CREATED_AT	DEC	11
DRAFTENTITYLASTCHANGEDATETIME	Draft Last Changed On		SDRAFT_LAST_CHANGED_AT	DEC	11
DRAFTADMINISTRATIVEDATAUUID	Technical ID for the Administrative Data of a Draft Document		SDRAFT_ADMIN_UUID	RAW	16
DRAFTENTITYCONSISTENCYSTATUS	Draft - Consistency Status		SDRAFT_CONSISTENCY_STATUS	CHAR	2
DRAFTENTITYOPERATIONCODE	Draft - Operation Code		SDRAFT_OPERATION_CODE	CHAR	2
.INCLUDE				QPMK_INCL_EEW_PS	0
DUMMY_QPMK_INCL_EEW_PS	Dummy function in length 1		DUMMY	CHAR	2