1. Home
  2. Resources
  3. SAP Tables
  4. QGMK - QM: Specifications and results for insp. charac. (GLV)

SAP Table QGMK

QM: Specifications and results for insp. charac. (GLV)

QGMK (QM: Specifications and results for insp. charac. (GLV)) 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 QGMK to other SAP tables.

QGMK table fields

Field Data element Checktable Datatype Length Decimals
PRUEFLOS Inspection Lot Number QPLOS NUMC 12 0
PROBENR Sample Number QPROBENR NUMC 6 0
SATZSTATUSR Results Record Status QBEASTATUS TQ76 CHAR 1 0
MBEWERTG_KEYTEXT Short Text for Fixed Values VAL_TEXT CHAR 60 0
MASSEINHSW Measurement Unit in Which Quantitative Data Is Maintained QMGEH6 T006C CHAR 6 0
SOLLWERT Target Value for a Quantitative Characteristic QSOLLWERTE FLTP 16 16
TOLERANZOB Upper Specification Limit QTOLOB FLTP 16 16
TOLERANZUN Lower Tolerance Limit QTOLUN FLTP 16 16
MITTELWERT Arithmetic Mean of Valid Measured Values QMITTELWRT FLTP 16 16
STDABW Standard Deviation of Valid Measured Values QSTDAW FLTP 16 16
ANZWERTG Number of Inspected Sample Units QANZWERTG4 INT4 10 0
ANZFEHLEH Number of Nonconforming Sample Units QANZFEHEH4 INT4 10 0
ANZFEHLER Number of Defects Found QANZFEHL4 INT4 10 0
ANZWERTO Number of Measured Values Above the Tolerance Range QANZWERTO4 INT4 10 0
ANZWERTU Number of Measured Values Below the Tolerance Range QANZWERTU4 INT4 10 0
ANNAHMEZ Acceptance Number QANNAHMEZ INT2 5 0
FEHLKLAS_KEYTEXT Short Text QKURZTEXT CHAR 40 0
PRUEFDATUV Inspection Start Date QPRUEFDATV DATS 8 0
PRUEFZEITV Starting Time of the Inspection QPRUEFZTV TIMS 6 0
PRUEFBEMKT Short Text QKURZTEXT CHAR 40 0
PRUEFER Name of the Inspector QPRUEFER CHAR 12 0
CODEGRQUAL Defect Code Group for General Rejection QCODEGRPQL CHAR 8 0
CODEQUAL Defect Code for Rejection: General QCODEQL CHAR 4 0
ATTRIBUT_KEYTEXT Short Text for Fixed Values VAL_TEXT CHAR 60 0
VARIANZ Dispersion (Variance) of Valid Measured Values QVARIANZ FLTP 16 16
GRENZEOB1 First Upper Specification Limit QGRENZOB1 FLTP 16 16
GRENZEUN1 First Lower Specification Limit QGRENZUN1 FLTP 16 16
GRENZEOB2 Second Upper Specification Limit QGRENZOB2 FLTP 16 16
GRENZEUN2 Second Lower Specification Limit QGRENZUN2 FLTP 16 16
MAXWERT Maximum Value of the Valid Measured Values QMAXWERT FLTP 16 16
MINWERT Minimum Value of the Valid Measured Values QMINWERT FLTP 16 16
MOMENT3 Third Central Moment of Valid Measured Values QMOMENT3 FLTP 16 16
MOMENT4 Fourth Central Moment of Valid Measured Values QMOMENT4 FLTP 16 16
ANTEILO Estimated Fraction Above the Tolerance Range QANTEILO FLTP 16 16
ANTEILU Estimated Fraction Below the Tolerance Range QANTEILU FLTP 16 16
SPANNWEITE Range of Valid Measured Values QSPANNWEI FLTP 16 16
ISTSTPANZ Number of Partial Samples for the Characteristic QANZSTIPRO INT2 5 0
ISTSTPUMF Number of Recorded Sample Units QISTSTPUMF INT4 10 0
KURZTEXT Short Text for the Inspection Characteristic QMKKURZTXT CHAR 40 0
RUECKWEZ Rejection Number QRUECKWEZ INT2 5 0
PHYSPROBE Number of the Partial Sample QPHYSPROBE NUMC 6 0
PROBMGFAK Sample Quantity Factor for Sample(Mult. Sample Unit of Msr.) QPROBEFAK DEC 5 2
PROBEMGEH Sample Unit of Measure QPROBME T006 UNIT 3 0
SOLLSTPUMF Sample Size that Has to Be Inspected for a Characteristic QGESUMF INT4 10 0
STIPROUMF Sample Size that Must Be Inspected QSTIPROUMF INT4 10 0
PRUEFUMF Quantity to Be Inspected QPRUEFUMF QUAN 13 3
MENGENEINH Base Unit of Measure for the Sample Unit QPROBEMGEH T006 UNIT 3 0
QERGDATH_KEYTEXT Short Text QKURZTEXT CHAR 40 0
MERKGEW_KEYTEXT Short Text QKURZTEXT CHAR 40 0
PRUEFQUALI Inspector Qualification QPRQUALIF TQ11 CHAR 5 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
DBEWERTG Valuation of the Characteristic for Dynamic Modification QDBEWERTG CHAR 1 0
NULL No valuation
A Accepted
R Rejected
F Failed
QDYNREGEL Dynamic Modification Rule QDYNREGEL CHAR 3 0
PRSCHAERFE Inspection Severity QPRSCHAERF NUMC 3 0
PRSTUFE Inspection Stage QPRSTUFE NUMC 4 0
DYNKRIT String for Dynamic Modification Criteria (Database Relevant) QDYNSTRING CHAR 10 0
DYNMERKREF Characteristic (in Plan) whose Q-Level Will Be Copied QMERKDYN NUMC 4 0
KZDYNR Dynamic Modification Rule Available QKZDYNR CHAR 1 0
NULL Indicator is not set
X Indicator is set
ZAEHLERQL Sequential Counter for Different Quality Levels QZAEHLERQL INT4 10 0
ERSTELLERR Name of User Who Created the Data Record QERSTELLER CHAR 12 0
ERSTELLDATR Date on Which the Data Record Was Created QDATUMERST DATS 8 0
ZEITERSTL Time at which data record was created QZEITERSTL TIMS 6 0
AENDERERR Name of User who Most Recently Changed the Data Record QAENDERER CHAR 12 0
AENDERDATR Date on Which Data Record Was Changed QDATUMAEND DATS 8 0
ZEITAEND Time at which data record was last changed QZEITAEND TIMS 6 0
PRUEFDATUB End Date of the Inspection QPRUEFDATB DATS 8 0
PRUEFZEITB End Time of the Inspection QPRUEFZTB TIMS 6 0
SATZSTATUSV Specification Record Status QSTATUS TQ76 CHAR 1 0
STEUERKZ Cntrl Indicator String for Insp. Char./Master Insp. Char. QMKCONTROL CHAR 30 0
NIPLANMKKZ Unplanned Characteristic QNIPLANMK CHAR 1 0
NULL Indicator is not set
X Indicator is set
QMTB_WERKS Plant WERKS_D T001W CHAR 4 0
PMETHODE Inspection Method QPMETHODE CHAR 8 0
PMTVERSION Version Number of the Inspection Method QVERSNRPM CHAR 6 0
ATINN Internal characteristic ATINN NUMC 10 0
QPMK_REF Type of Master Insp. Characteristic Ref. Results Recording QKZ_REF_EE CHAR 1 0
NULL Reference to master inspection characteristic
1 MastInspChar from pln overwritten with matSpec, NoRefToGenCh
2 Values from material specification, without ref. to gen.char
3 Master inspection char. was copied to plan
4 Specifications were changed
5 Specifications were changed by config./batch determination
6 Specifications from config./batch determination
7 MastChar from pln overwritten with mat.spec, with refToGenCh
8 Values are from mat. spec. with ref to gen. charac.
9 Specs changed using flexible inspection specs function
QPMK_WERKS Plant for the Master Inspection Characteristic QZAEHLER CHAR 4 0
VERWMERKM Master Inspection Characteristics QMERKNR CHAR 8 0
MKVERSION Version Number of the Master Inspection Characteristic QVERSNRMK CHAR 6 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
TOLERWKZ Tolerance Change Is Active QTOLERWKZ CHAR 1 0
NULL Indicator is not set
X Indicator is set
PRZIEHVERF Sample-Drawing Procedure QPRZIEHVER CHAR 8 0
VERSION Version No. of the Sample-Drawing Procedure QVERSNPRZV CHAR 6 0
POSNRPRZV Item Number in Sample-Drawing Procedure QZAEHLPRZV NUMC 4 0
LOSGEBEH Lot Container QGEBEH UNIT 3 0
PROBNRPL Highest Partial Sample No. Valid for Instruction QPROBNRBIS NUMC 3 0
STICHPRVER Sampling Procedure in Inspection Characteristic QSTICHVERF CHAR 8 0
FAKPLANME Factor for Converting MatUnitOfMeasure to SampUnitOfMeasure QUMREN FLTP 16 16
FAKPROBME Factor for Converting SampUnitOfMeasure to MatUnitOfMeasure QUMRENPME FLTP 16 16
ANTVERF Fraction Calculation QEANTVERF CHAR 2 0
BEWREGEL Valuation Rule QBEWERT QDFM CHAR 2 0
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
SOLLSTPANZ Number of Planned Partial Samples QSOSTPANZ INT2 5 0
PZLFH Assigned Test Equipment QPZLFH NUMC 8 0
RASTER Inspection Frequency (Only for Inspection with Insp. Points) QRASTER NUMC 3 0
KFAKTOR K-Factor for a Variable Inspection QKFAKTOR FLTP 16 16
QRKNR Control Chart Number QQRKNR NUMC 12 0
ANTEIL Estimated Fraction of Nonconforming Sample Units QANTEIL FLTP 16 16
KATALGART1 Catalog Type of Assigned Code Group or Selected Set QKATAUSW TQ15 CHAR 1 0
GRUPPE1 Code Group QCODEGRP CHAR 8 0
CODE1 Code QCODE CHAR 4 0
KATALGART2 Catalog Type of Assigned Code Group or Selected Set QKATAUSW TQ15 CHAR 1 0
GRUPPE2 Code Group QCODEGRP CHAR 8 0
CODE2 Code QCODE CHAR 4 0
KATALGART3 Catalog Type of Assigned Code Group or Selected Set QKATAUSW TQ15 CHAR 1 0
GRUPPE3 Code Group QCODEGRP CHAR 8 0
CODE3 Code QCODE CHAR 4 0
KATALGART4 Catalog Type of Assigned Code Group or Selected Set QKATAUSW TQ15 CHAR 1 0
GRUPPE4 Code Group QCODEGRP CHAR 8 0
CODE4 Code QCODE CHAR 4 0
KATALGART5 Catalog Type of Assigned Code Group or Selected Set QKATAUSW TQ15 CHAR 1 0
GRUPPE5 Code Group QCODEGRP CHAR 8 0
CODE5 Code QCODE CHAR 4 0
CODE1TEXT Text for Code QRES_TEXT CHAR 80 0
MASCHINE General Information QMASCHINE CHAR 18 0
POSITION Test Position QPRPOS NUMC 4 0
KZVERDICHT Reduced No. of Samples for Characteristic Summarization QVERDICHTG CHAR 1 0
NULL Indicator is not set
X Indicator is set
BEWREGELPR Valuation Rule QBEWERT CHAR 2 0
EQUNR Equipment Number EQUNR CHAR 18 0
TPLNR Functional Location TPLNR CHAR 30 0
PHYNR Physical Sample Number QPHYSPRNR CHAR 12 0
VORGLFNR Current Node Number from Order Counter APLZL QLFNKN NUMC 8 0
MERKNR Inspection Characteristic Number QMERKNRP NUMC 4 0
WERK Plant WERKS_D CHAR 4 0
ART Inspection Type QPART CHAR 8 0
HERKUNFT Inspection Lot Origin QHERK CHAR 2 0
INSMK Quantity Is or Was in Inspection Stock QVINSMK CHAR 1 0
NULL Indicator is not set
X Indicator is set
STAT02 Partial Lots Exist QKZQALT CHAR 1 0
NULL Indicator is not set
X Indicator is set
STAT07 Inspection with Inspection Points QKZFERTPRF CHAR 1 0
NULL Indicator is not set
X Indicator is set
STAT11 GR blocked stock KZWES CHAR 1 0
STAT34 Stock Postings Completed QSTAT34 CHAR 1 0
NULL Indicator is not set
X Indicator is set
STAT35 Usage Decision Has Been Made QSTAT35 CHAR 1 0
NULL Indicator is not set
X Indicator is set
KZSKIPLOT Lot Skipped QKZSKIPLOT CHAR 1 0
NULL Indicator is not set
X Indicator is set
ENSTEHDAT Date of Lot Creation QENTST DATS 8 0
ENTSTEZEIT Time of Lot Creation QENTSTZEIT TIMS 6 0
AUFNR Order Number AUFNR CHAR 12 0
VERID Production Version VERID CHAR 4 0
KUNNR Customer (Ship-To Party) QKUNWE CHAR 10 0
LIFNR Vendor Account Number ELIFN CHAR 10 0
HERSTELLER Number of Manufacturer QLIFNR CHAR 10 0
EMATNR Material Number Corresponding to Manufacturer Part Number EMATN CHAR 18 0
MATNR Material Number MATNR CHAR 18 0
REVLV Revision Level REVLV CHAR 2 0
XCHPF Batch management requirement indicator XCHPF CHAR 1 0
X Yes
NULL No
CHARG Batch Number CHARG_D CHAR 10 0
LAGORTCHRG Storage Location LGORT_D CHAR 4 0
KDAUF Sales Order Number of Valuated Sales Order Stock MAT_KDAUF CHAR 10 0
KDPOS Sales Order Item of Valuated Sales Order Stock MAT_KDPOS NUMC 6 0
EBELN Purchasing Document Number EBELN CHAR 10 0
EBELP Item Number of Purchasing Document EBELP NUMC 5 0
WERKVORG Plant Where Stock for Inspection Lot Is Held QWERKVORG CHAR 4 0
LAGORTVORG Storage Location for Inspection Lot Stock QLGORTVORG CHAR 4 0
KTEXTLOS Short Text QKURZTEXT CHAR 40 0
KTEXTMAT Short Text for Inspection Object QKTEXTOBJ CHAR 40 0
OFFENNLZMK Number of Outstanding Short-Term Chars Which Require Conf. QOFFENLZMK INT2 5 0
OFFEN_LZMK Number of Outstanding Long-Term Chars Which Require Conf. QOFFELZMK INT2 5 0
LOSMENGE Inspection Lot Quantity QLOSMENGE QUAN 13 3
MENGENEINH_QALS Base Unit of Measure for The Inspection Lot Quantity QLOSMENGEH UNIT 3 0
LMENGELZ Sample Quantity for Long-Term Characteristics QLMENGELZ QUAN 13 3
LMENGEPR Quantity Actually Inspected QLMENGEPR QUAN 13 3
LMENGEZER Quantity Destroyed During Inspection QLMENGEZER QUAN 13 3
LMENGEIST Actual Lot Quantity QLMENGEIST QUAN 13 3
LMENGESCH Defective Quantity in Inspected Quantity QLMENGESCH QUAN 13 3
SERNP Serial Number Profile SERAIL CHAR 4 0
SOLLWERT_C Target Value for a Quantitative Characteristic QSOLLWERTC CHAR 16 0
TOLERANZOB_C Upper Specification Limit QTOLOBC CHAR 16 0
TOLERANZUN_C Lower Specification Limit QTOLUNC CHAR 16 0
MITTELWERT_C Arithmetic Mean of Valid Measured Values QMITTEWRTC CHAR 16 0
STDABW_C Standard Deviation of Valid Measured Values QSTDAWC CHAR 16 0
VARIANZ_C Dispersion (Variance) of Valid Measured Values QVARIANZC CHAR 16 0
GRENZEOB1_C First Upper Specification Limit QGRENZO1C CHAR 16 0
GRENZEUN1_C First Lower Specification Limit QGRENZU1C CHAR 16 0
GRENZEOB2_C Second Upper Specification Limit QGRENZO2C CHAR 16 0
GRENZEUN2_C Second Lower Specification Limit QGRENZU2C CHAR 16 0
MAXWERT_C Maximum Value of the Valid Measured Values QMAXWERTC CHAR 16 0
MINWERT_C Minimum Value of the Valid Measured Values QMINWERTC CHAR 16 0
MOMENT3_C Third Central Moment of Valid Measured Values QMOMENT3C CHAR 16 0
MOMENT4_C Fourth Central Moment of Valid Measured Values QMOMENT4C CHAR 16 0
ANTEILO_C Estimated Fraction Above the Tolerance Range QANTEILOC CHAR 16 0
ANTEILU_C Estimated Fraction Below the Tolerance Range QANTEILUC CHAR 16 0
SPANNWEITE_C Range of Valid Measured Values QSPANNWEIC CHAR 16 0
KFAKTOR_C K-Factor for a Variable Inspection QKFAKTORC CHAR 16 0
ANTEIL_C Estimated Fraction of Nonconforming Units QANTEILC CHAR 16 0
ORIGINAL_INPUT Original Value Before Input Processing QORIGINAL_INPUT CHAR 25 0
TECH Following Fields - Technical (Gen. List Viewer) QTECH CHAR 1 0
NULL Indicator is not set
X Indicator is set
MANDANT Client MANDT T000 CLNT 3 0
ERSTELLER Name of User Who Created the Data Record QERSTELLER CHAR 12 0
ERSTELLDAT Date on Which the Data Record Was Created QDATUMERST DATS 8 0
AENDERER Name of User who Most Recently Changed the Data Record QAENDERER CHAR 12 0
AENDERDAT Date on Which Data Record Was Changed QDATUMAEND DATS 8 0
SATZSTATUS Specification Record Status QSTATUS TQ76 CHAR 1 0
PLNFL Sequence PLNFOLGE CHAR 6 0
PLNKN Current Node Number from Order Counter APLZL QLFNKN NUMC 8 0
VORNR Operation/Activity Number VORNR CHAR 4 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
SOLLPRUEF Check Target Value QKZSOLLPR 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
ADDPRO Sample Quantity Is Added QADDPRO 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
FIXIERT Default Control Indicators Cannot Be Changed QNAENDKZ 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
LSTKZ Control Characteristics Results - QM Subsystem QLEITSTKZ CHAR 1 0
NULL Indicator is not set
X Indicator is set
VORGAEND Specifications Can Be Changed QVORGAEND CHAR 1 0
NULL Indicator is not set
X Indicator is set
PMMZWANG Assignment of Test Equipment Required QPMZWANG 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
QSPCMK SPC Characteristic QSPCMK CHAR 1 0
NULL Indicator is not set
X Indicator is set
KEINDRUCK Print QDRUCK1 CHAR 1 0
NULL Print
X Do not print
* Do not print at skip
PARA Control Indicator "Parameter Characteristic" Set/Not Set QPARA CHAR 1 0
NULL Indicator is not set
X Indicator is set
PROCESSMK Process Characteristic QKZPROCCHAR CHAR 1 0
NULL Indicator is not set
X Indicator is set
TSTICHPRKZ Partial Samples Possible QTSTICHPRO CHAR 1 0
NULL No multiple samples
X Independent multiple samples
1 Dependent multiple samples
NOINPUTKZ Results Are Calculated Internally QNOINPUT CHAR 1 0
NULL Indicator is not set
X Indicator is set
SOLLWNI Value Not Initial if Set QNINITIAL CHAR 1 0
NULL Indicator is not set
X Indicator is set
TOLOBNI Value Not Initial if Set QNINITIAL CHAR 1 0
NULL Indicator is not set
X Indicator is set
TOLUNNI Value Not Initial if Set QNINITIAL CHAR 1 0
NULL Indicator is not set
X Indicator is set
GRENZOB1NI Value Not Initial if Set QNINITIAL CHAR 1 0
NULL Indicator is not set
X Indicator is set
GRENZUN1NI Value Not Initial if Set QNINITIAL CHAR 1 0
NULL Indicator is not set
X Indicator is set
GRENZOB2NI Value Not Initial if Set QNINITIAL CHAR 1 0
NULL Indicator is not set
X Indicator is set
GRENZUN2NI Value Not Initial if Set QNINITIAL 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
KZQRK Acceptance Using Control Chart QKZQRK 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
HPZ 100% Inspection QHPZ CHAR 1 0
NULL Indicator is not set
X Indicator is set
ANTEILKZ Take Share Estimate into Account QANTEILKZ CHAR 1 0
NULL Indicator is not set
X Indicator is set
RUECKMELNR Confirmation Number for Inspection Characteristic QRUECKNR NUMC 8 0
KZEINSTELL Characteristic Type QKZEINSTMK CHAR 1 0
ZAEHL Internal counter CIM_COUNT NUMC 8 0
KZRAST Indicator: Sampling Procedure for Inspection Points QKZRAST CHAR 1 0
NULL Without insp. points
X Inspection points for production
1 Inspection points for Plant Maintenance
2 Inspection points for sample management
KFAKTORNI Value Not Initial if Set QNINITIAL CHAR 1 0
NULL Indicator is not set
X Indicator is set
ANTEILNI Not Initialized for Fraction QNIANTEIL CHAR 1 0
NULL Value is initial
X Value was set manually
* Value was calculated internally
MAXWERTNI Value Not Initial if Set QNINITIAL CHAR 1 0
NULL Indicator is not set
X Indicator is set
MINWERTNI Value Not Initial if Set QNINITIAL CHAR 1 0
NULL Indicator is not set
X Indicator is set
MITTELWNI Value Not Initial if Set QNINITIAL CHAR 1 0
NULL Indicator is not set
X Indicator is set
VARIANZNI Value Not Initial if Set QNINITIAL CHAR 1 0
NULL Indicator is not set
X Indicator is set
MOMENT3NI Value Not Initial if Set QNINITIAL CHAR 1 0
NULL Indicator is not set
X Indicator is set
MOMENT4NI Value Not Initial if Set QNINITIAL CHAR 1 0
NULL Indicator is not set
X Indicator is set
ANTEILONI Value Not Initial if Set QNINITIAL CHAR 1 0
NULL Indicator is not set
X Indicator is set
ANTEILUNI Value Not Initial if Set QNINITIAL CHAR 1 0
NULL Indicator is not set
X Indicator is set
GUELSTPANZ Number of Valid Partial Samples QGUELSTPAN INT2 5 0
IVARIANZNI Value Not Initial if Set QNINITIAL CHAR 1 0
NULL Indicator is not set
X Indicator is set
IVARIANZ Internal Dispersion of Valid Measured Values QIVARIANZ FLTP 16 16
IVARIANZ_C Internal Dispersion of Valid Measured Values QIVARIANZC CHAR 16 0
VERSION1 Version Number QVERSNR CHAR 6 0
VERSION2 Version Number QVERSNR CHAR 6 0
VERSION3 Version Number QVERSNR CHAR 6 0
VERSION4 Version Number QVERSNR CHAR 6 0
VERSION5 Version Number QVERSNR CHAR 6 0
STDABWNI Value Not Initial if Set QNINITIAL CHAR 1 0
NULL Indicator is not set
X Indicator is set
SPANNWEINI Value Not Initial if Set QNINITIAL CHAR 1 0
NULL Indicator is not set
X Indicator is set
KZBEWERTG Valuation Copied or Forced QKZBEWERTG CHAR 1 0
NULL Valuation and/or close using plan specifications
* Manual valuation was forced
X Valuation imported from another system (e.g. subsystem)
- Valuation imported internally, e.g. from a differnt char.
+ Manual valuation and forced closure
. Valuation imported externally and forced closure
/ Valuation using specifications, forced closure
STATUSROLD Quality Status of Results Record Before Last Change QBEASTATOD CHAR 1 0
TEILLOST Partial lot number QTLOS NUMC 6 0
TEILLOSP Partial lot number QTLOS NUMC 6 0
CHARGT Batch Number CHARG_D CHAR 10 0
MBEWERTG Inspection Result Valuation QMBEWERTG CHAR 1 0
NULL No valuation
A Accepted
R Rejected
F Failed
FEHLKLAS Defect Class QFEHLKLAS TQ17 CHAR 2 0
ATTRIBUT Attribute of the Results Record (Valid, Invalid,...) QATTRIBUT CHAR 1 0
NULL Result is valid (default)
< The true value is less or equal to; valid result
> The true value is greater or equal to; valid result
? The result was estimated; valid result
* Result considerede an outlier; valid result
/ Invalid result
( Customer attribute '('; valid result
) Customer attribute '('; invalid result
[ Customer attribute '['; valid result
] Customer attribute '['; invalid result
{ Customer attribute '{'; valid result
} Customer attribute '}'; invalid result
~ Result not proven; valid result
# Result not determinable; valid result
U Customer attribute 'U'; valid result
V Customer attribute 'V'; valid result
W Customer attribute 'W'; valid result
X Customer attribute 'X'; invalid result
Y Customer attribute 'Y'; invalid result
Z Customer attribute 'Z'; invalid result
A Formula: Calculation input characteristic is inappropriate
B Formula: Calculation input characteristic does not exist
C Formula: Syntax error
D Formula: Calculation input charac. has an incorrect format
E Formula: Error during values' trans. for calc. input charac.
F Formula: Arithmetic error during formula calculation
G Formula: Not all single results were calculated
H Formula: Error when calculating single units
& Error occurred during results transfer
\ Result is not current; invalid result
QERGDATH Origin of Results Data QERGDATH TQ73 CHAR 2 0
MERKGEW Weighting of the Characteristic QMERKGEW TQ17A CHAR 2 0
DIFF_DEC_PLACES Different Number of Decimal Places QDIFF_DEC_PLACES INT2 5 0

QGMK foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
QGMK BEWREGEL QAMR MANDT QDFM Function modules for valuation mode MANDT
QGMK BEWREGEL QGMK BEWREGEL QDFM Function modules for valuation mode FBKEY
QGMK FEHLKLAS QAMR MANDT TQ17 Defect classes MANDT
QGMK FEHLKLAS QGMK FEHLKLAS TQ17 Defect classes FEHLKLASSE
QGMK KATALGART1 QGMK KATALGART1 TQ15 Inspection catalog type index KATALOGART
QGMK KATALGART1 QAMR MANDT TQ15 Inspection catalog type index MANDT
QGMK KATALGART2 QAMR MANDT TQ15 Inspection catalog type index MANDT
QGMK KATALGART2 QGMK KATALGART2 TQ15 Inspection catalog type index KATALOGART
QGMK KATALGART3 QAMR MANDT TQ15 Inspection catalog type index MANDT
QGMK KATALGART3 QGMK KATALGART3 TQ15 Inspection catalog type index KATALOGART
QGMK KATALGART4 QAMR MANDT TQ15 Inspection catalog type index MANDT
QGMK KATALGART4 QGMK KATALGART4 TQ15 Inspection catalog type index KATALOGART
QGMK KATALGART5 QAMR MANDT TQ15 Inspection catalog type index MANDT
QGMK KATALGART5 QGMK KATALGART5 TQ15 Inspection catalog type index KATALOGART
QGMK MANDANT QGMK MANDANT T000 Clients MANDT
QGMK MASSEINHSW SY LANGU T006C Assignment of external technical to internal unit of measure SPRAS
QGMK MASSEINHSW QGMK MASSEINHSW T006C Assignment of external technical to internal unit of measure MSEH6
QGMK MASSEINHSW SY MANDT T006C Assignment of external technical to internal unit of measure MANDT
QGMK MENGENEINH SY MANDT T006 Units of Measurement MANDT
QGMK MENGENEINH QGMK MENGENEINH T006 Units of Measurement MSEHI
QGMK MERKGEW QAMR MANDT TQ17A Characteristic weightings MANDT
QGMK MERKGEW QGMK MERKGEW TQ17A Characteristic weightings MERKKLASSE
QGMK PROBEMGEH SY MANDT T006 Units of Measurement MANDT
QGMK PROBEMGEH QGMK PROBEMGEH T006 Units of Measurement MSEHI
QGMK PRUEFQUALI QAMR MANDT TQ11 Inspector qualification MANDT
QGMK PRUEFQUALI QGMK PRUEFQUALI TQ11 Inspector qualification PRFQL
QGMK QERGDATH QAMR MANDT TQ73 Origin of results data MANDT
QGMK QERGDATH QGMK QERGDATH TQ73 Origin of results data QERGDATH
QGMK QMTB_WERKS QGMK QMTB_WERKS T001W Plants/Branches WERKS
QGMK QMTB_WERKS QAMR MANDT T001W Plants/Branches MANDT
QGMK SATZSTATUS QGMK SATZSTATUS TQ76 Processing status of inspection characteristics STATUS
QGMK SATZSTATUSR QGMK SATZSTATUSR TQ76 Processing status of inspection characteristics STATUS
QGMK SATZSTATUSV QGMK SATZSTATUSV TQ76 Processing status of inspection characteristics STATUS