1. Home
  2. Resources
  3. SAP Tables
  4. QCSPEC - Certificates: Characteristic specifications

SAP Table QCSPEC

Certificates: Characteristic specifications

QCSPEC (Certificates: Characteristic specifications) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link QCSPEC to other SAP tables.

QCSPEC table fields

Field Data element Checktable Datatype Length Decimals
PRUEFLOS Inspection Lot Number QPLOS NUMC 12 0
TEILLOS Partial lot number QTLOS NUMC 6 0
VORGLFNR Current Node Number from Order Counter APLZL QLFNKN NUMC 8 0
MATNR Material Number MATNR CHAR 18 0
CHARG Batch Number CHARG_D CHAR 10 0
PHYSPROBE Number of the Partial Sample QPHYSPROBE NUMC 6 0
STATUSV Specification Record Status QSTATUS CHAR 1 0
STATUSTEXT Short Text QKURZTEXT CHAR 40 0
QUANTITAT Quantitative Characteristic QKZQUNMK CHAR 1 0
NULL Indicator is not set
X Indicator is set
MESSWERTE Measured Values Must Be Recorded QKZQUMK CHAR 1 0
NULL Indicator is not set
X Indicator is set
PRUEFKAT Reference to Characteristic Attribute Required QKZPKAT CHAR 1 0
NULL Indicator is not set
X Indicator is set
TOLEROBEN Upper Specification Limit QKZTOLOB CHAR 1 0
NULL Indicator is not set
X Indicator is set
TOLERUNTEN Lower Specification Limit QKZTOLUN CHAR 1 0
NULL Indicator is not set
X Indicator is set
PUMFKZ Inspection Scope QPUMFKZ CHAR 1 0
= Fixed inspection scope
NULL Scope not fixed
< Smaller inspection scope allowed
> Larger inspection scope allowed
LZEITKZ Long-Term Inspection QLZEITKZ CHAR 1 0
NULL Indicator is not set
X Indicator is set
ESTUKZ Recording Type QESTUKZ CHAR 1 0
NULL Summarized recording
+ Single-value recording
* Classed recording
- No results recording
DOKUKZ Documentation Required for Inspection Results QDOKUKZ CHAR 1 0
NULL Text documentation of test values is not required
. The test values with valuation R (reject) must be documented
+ All test values must be documented with text
RZWANG Characteristic Category QRZWANG CHAR 1 0
X Required characteristic
NULL Optional characteristic
+ Required when previous required characteristic is accepted
- Required when previous required characteristic is rejected
SYNCRO Synchronization is Active QSYNCRO CHAR 1 0
NULL Indicator is not set
X Indicator is set
ZERSTPRF Destructive Inspection QKZDESTROY CHAR 1 0
NULL Indicator is not set
X Indicator is set
FORMELMK Calculated Characteristic QKZFORMEL CHAR 1 0
NULL No Formula
1 Input Processing
X Calculated Characteristic
STICHPR Sampling Procedure is Required QSTICHPR CHAR 1 0
NULL Indicator is not set
X Indicator is set
AUSSLOS Characteristic Relevant for Qual. Score and Scrap Share QAUSSLOS CHAR 1 0
NULL Indicator is not set
X Indicator is set
BEWFHLZHL Recording the Number of Defects QBFHLZHL CHAR 1 0
NULL Indicator is not set
X Indicator is set
FEHLREC Defects Recording Automatically Called Up QFEHLREC CHAR 1 0
NULL Indicator is not set
X Indicator is set
AENDBELEG Create Change Documents During Results Recording QKZAENBEL CHAR 1 0
NULL Indicator is not set
X Indicator is set
QMTB_WERKS Plant WERKS_D CHAR 4 0
PMETHODE Inspection Method QPMETHODE CHAR 8 0
PMTVERSION Version Number of the Inspection Method QVERSNRPM CHAR 6 0
PMT_KTEXT Short Text for Inspection Method QTXTMETHOD CHAR 40 0
PMT_LTXTKZ Long Text Exists for the Inspection Method QLTEXTMT CHAR 1 0
NULL Indicator is not set
X Indicator is set
MERKGEW Weighting of the Characteristic QMERKGEW CHAR 2 0
WERKS Plant QWERKS CHAR 4 0
MKMNR Master Inspection Characteristics QMERKNR CHAR 8 0
VERSION Version Number of the Master Inspection Characteristic QVERSNRMK CHAR 6 0
KURZTEXT Short Text for the Inspection Characteristic QMKKURZTXT CHAR 40 0
DUMMY10 Text Line for Additional Information QTXT10 CHAR 10 0
DUMMY20 Text Line for Additional Information QTXT20 CHAR 20 0
DUMMY40 Text Line for Additional Information QTXT40 CHAR 40 0
AUSWMENGE1 Assigned Code Group or Selected Set QCGRAUSW CHAR 8 0
AUSWMGWRK1 Plant of the Assigned Selected Set QWERKAUSW CHAR 4 0
AUSWMTEXT1 Short Text for the Code Group/Selected Set QTXT_GROUP CHAR 40 0
TEXT_KAT1 Short Text for the Catalog QTXTCATALG CHAR 40 0
STELLEN Number of Places to the Right of a Decimal Point (Accuracy) QSTELLEN INT1 3 0
0 To a maximum of 10 decimal places
MASSEINHSW Unit of Measurement MSEHI UNIT 3 0
SOLLWERT Target Value for a Quantitative Characteristic QSOLLWERTC CHAR 16 0
TOLERANZOB Upper Specification Limit QTOLOBC CHAR 16 0
TOLERANZUN Lower Specification Limit QTOLUNC CHAR 16 0
TOLOBFLOAT Upper Specification Limit QTOLOB FLTP 16 16
TOLUNFLOAT Lower Tolerance Limit QTOLUN FLTP 16 16
TOLERWKZ Tolerance Change Is Active QTOLERWKZ CHAR 1 0
NULL Indicator is not set
X Indicator is set
GRENZEOB1 First Upper Specification Limit QGRENZO1C CHAR 16 0
GRENZEUN1 First Lower Specification Limit QGRENZU1C CHAR 16 0
GRENZEOB2 Second Upper Specification Limit QGRENZO2C CHAR 16 0
GRENZEUN2 Second Lower Specification Limit QGRENZU2C CHAR 16 0
PLAUSIOBEN Upper Plausibility Limit QPLAUSIOBC CHAR 16 0
PLAUSIUNTE Lower Plausibility Limit QPLAUSIUNC CHAR 16 0
STICHPRVER Sampling Procedure in Inspection Characteristic QSTICHVERF CHAR 8 0
STPRVTEXT Short Text for the Sampling Procedure QTXTSMPPRO CHAR 40 0
SOLLSTPUMF Sample Size that Has to Be Inspected for a Characteristic QGESUMF INT4 10 0
PRUEFUMF Quantity to Be Inspected QPRUEFUMF QUAN 13 3
MENGENEINH Base Unit of Measure for the Sample Unit QPROBEMGEH UNIT 3 0
HPZ 100% Inspection QHPZ CHAR 1 0
NULL Indicator is not set
X Indicator is set
KZATTRFE Attributive Inspection by Nonconforming Units QKZATTRFE CHAR 1 0
NULL Indicator is not set
X Indicator is set
KZATTRFZ Attributive Inspection by Number of Defects QKZATTRFZ CHAR 1 0
NULL Indicator is not set
X Indicator is set
KZVARS Variable Inspection by S-Method QKZVARS CHAR 1 0
NULL Indicator is not set
X Indicator is set
KZCOD Valuation by Code QKZCOD CHAR 1 0
NULL Indicator is not set
X Indicator is set
KZMAN Manual Valuation QKZMAN CHAR 1 0
NULL Indicator is not set
X Indicator is set
KZUMFS Multiple Samples QKZUMFS CHAR 1 0
NULL No multiple samples
X Independent multiple samples
1 Dependent multiple samples
KZNULL Inspection Against Specification Limits (k = 0) QKZKNULL CHAR 1 0
NULL Indicator is not set
X Indicator is set
ANNAHMEZ Acceptance Number QANNAHMEZ INT2 5 0
RUECKWEZ Rejection Number QRUECKWEZ INT2 5 0
KFAKTORNI Value Not Initial if Set QNINITIAL CHAR 1 0
NULL Indicator is not set
X Indicator is set
KFAKTOR K-Factor for a Variable Inspection QKFAKTORC CHAR 16 0
ATCOD Code for value dependency ATCOD CHAR 1 0