SAP table CHA_CLASS_DATA (Data for the class of inspection charcteristics)

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 * MANDT
PLNTY Task List Type CHAR 1 0 PLNTY
PLNNR Key for Task List Group CHAR 8 0 PLNNR
PLNKN Number of the Task List Node NUMC 8 0 PLNKN
KZEINSTELL Characteristic Type CHAR 1 0 QKZEINSTMK
Inspection Characteristic
MERKNR Inspection Characteristic Number NUMC 4 0 QMERKNRP
ZAEHL Internal counter NUMC 8 0 CIM_COUNT
GUELTIGAB Valid-From Date DATS 8 0 DATUV
SERNV Technical status from CHAR 12 0 TECHV
LOEKZ Deletion Indicator CHAR 1 0 LKENZ
PARKZ Indicator: inactive changes CHAR 1 0 PARKZ
AENDERGNR Change Number CHAR 12 0 * AENNR
ERSTELLER User who created record CHAR 12 0 ANNAM
ERSTELLDAT System Date on Which Data Record Was Created DATS 8 0 QDATUMERST
AENDERER Name of User Who Last Changed Data Record CHAR 12 0 QAENDERER
AENDERDAT System Date on Which Data Record Was Changed DATS 8 0 QDATUMAEND
STEUERKZ Cntrl Indicator String for Insp. Char./Master Insp. Char. CHAR 30 0 QMKCONTROL
QMTB_WERKS Plant for Inspection Method CHAR 4 0 T001W Q_METH_PLANT
PMETHODE Inspection Method CHAR 8 0 QMTB QPMETHODE
PMTVERSION Version Number of Inspection Method CHAR 6 0 QVERSNRPM
QPMK_REF Reference to Master Insp. Characteristic in Task List CHAR 1 0 QKZ_REF
QPMK_ZAEHL Plant for the Master Inspection Characteristic CHAR 4 0 QZAEHLER
VERWMERKM Master Inspection Characteristic CHAR 8 0 QPMK QMERKNR
MKVERSION Version Number of Master Inspection Characteristic CHAR 6 0 QVERSNRMK
MKVERSDAT Key Date for Version Selection DATS 8 0 QVERSDAT
MERKGEW Weighting of Characteristic CHAR 2 0 TQ17A QMERKGEW
PROBENR Partial Sample No. for Inspection Charac. in Task List NUMC 3 0 QPROBEPL
PRUEFQUALI Inspector Qualification CHAR 5 0 TQ11 QPRQUALIF
TOLERANZSL Tolerance Key CHAR 4 0 TQ29 QTOLERANZ
KURZTEXT Short Text for Inspection Characteristic CHAR 40 0 QTXT_CHA
LTEXTKZ Inspection Characteristic Long Text Exists CHAR 1 0 QLTEXTKZ
LTEXTSPR Language Key LANG 1 0 SPRAS
LTEXTEKZ Sample-Drawing Text Exists CHAR 1 0 QKZPRZIEH
LTXTENTSPR Language Key LANG 1 0 SPRAS
STELLEN Number of Places to the Right of a Decimal Point (Accuracy) INT1 3 0 QSTELLEN
0 To a maximum of 10 decimal places
MASSEINHSW Unit of Measurement in Which Quantitative Data Is Stored UNIT 3 0 T006 QMASSEH
SOLLWERT Target Value for a Quantitative Characteristic FLTP 16 16 QSOLLWERTE
SOLLWNI Value Not Initial if Set CHAR 1 0 QNINITIAL
TOLERANZOB Upper Specification Limit FLTP 16 16 QTOLOB
TOLOBNI Value Not Initial if Set CHAR 1 0 QNINITIAL
TOLERANZUN Lower Specification Limit FLTP 16 16 QTOLUN
TOLUNNI Value Not Initial if Set CHAR 1 0 QNINITIAL
KLASANZAHL Number of Value Classes for Inspection Results INT1 3 0 QKLASSZAHL
KLASBREITE Class Width FLTP 16 16 QKLASSBR
KLASBRNI Value Not Initial if Set CHAR 1 0 QNINITIAL
KLASMITTE Class Midpoint FLTP 16 16 QKLASSMIT
KLASMINI Value Not Initial if Set CHAR 1 0 QNINITIAL
GRENZEOB1 First Upper Specification Limit FLTP 16 16 QGRENZOB1
GRENZOB1NI Value Not Initial if Set CHAR 1 0 QNINITIAL
GRENZEUN1 First Lower Specification Limit FLTP 16 16 QGRENZUN1
GRENZUN1NI Value Not Initial if Set CHAR 1 0 QNINITIAL
GRENZEOB2 Second Upper Specification Limit FLTP 16 16 QGRENZOB2
GRENZOB2NI Value Not Initial if Set CHAR 1 0 QNINITIAL
GRENZEUN2 Second Lower Specification Limit FLTP 16 16 QGRENZUN2
GRENZUN2NI Value Not Initial if Set CHAR 1 0 QNINITIAL
PLAUSIOBEN Upper Plausibility Limit FLTP 16 16 QPLAUSIOB
PLAUSIOBNI Value Not Initial if Set CHAR 1 0 QNINITIAL
PLAUSIUNTE Lower Plausibility Limit FLTP 16 16 QPLAUSIUN
PLAUSIUNNI Value Not Initial if Set CHAR 1 0 QNINITIAL
TOLERWEIOB Change to Upper Specification Limit FLTP 16 16 QTOLWOB
TOLWOBNI Value Not Initial if Set CHAR 1 0 QNINITIAL
TOLERWEIUN Change to Lower Specification Limit FLTP 16 16 QTOLWUN
TOLWUNNI Value Not Initial if Set CHAR 1 0 QNINITIAL
TOLERWAB Date from Which the Tolerance Change Is Valid DATS 8 0 QTOLWAB
TOLERWBIS Date Until Which the Tolerance Change Is Valid DATS 8 0 QTOLWBIS
STICHPRVER Sampling Procedure in Inspection Characteristic CHAR 8 0 * QSTICHVERF
FAKPLANME Factor for Converting MatUnitOfMeasure to SampUnitOfMeasure FLTP 16 16 QUMREN
FAKPROBME Factor for Converting SampUnitOfMeasure to MatUnitOfMeasure FLTP 16 16 QUMRENPME
PROBEMGEH Sample Unit of Measure UNIT 3 0 T006 QPROBME
PRUEFEINH Sample Quantity Factor for Sample(Mult. Sample Unit of Msr.) DEC 5 2 QPROBEFAK
DYNKRIT String for Dynamic Modification Criteria (Database Relevant) CHAR 10 0 QDYNSTRING
FORMELSL Check and Calculate Formula in QM CHAR 1 0 QFORMELSL
FORMEL1 Formula Field CHAR 60 0 QFORMEL
FORMEL2 Formula Field CHAR 60 0 QFORMEL
CODEGR9U Defect Code Group for Rejection at Lower Tolerance CHAR 8 0 * QCODEGRPU
CODE9U Defect Code for Rejection at Lower Specification Limit CHAR 4 0 * QCODEU
CODEVR9U Version Number CHAR 6 0 QVERSNR
CODEGR9O Defect Code Group for Rejection at Upper Tolerance CHAR 8 0 * QCODEGRPO
CODE9O Defect Code for Rejection at Upper Specification Limit CHAR 4 0 * QCODEO
CODEVR9O Version Number CHAR 6 0 QVERSNR
KATAB1 Catalog Entry Is a Selected Set CHAR 1 0 QKTTAB
KATALGART1 Catalog Type of Assigned Code Group or Selected Set CHAR 1 0 TQ15 QKATAUSW
AUSWMENGE1 Assigned Code Group or Selected Set CHAR 8 0 QCGRAUSW
AUSWMGWRK1 Plant of the Assigned Selected Set CHAR 4 0 T001W QWERKAUSW
AUSWVERS1 Version Number CHAR 6 0 QVERSNR
AUSWDAT1 Key Date for Version Selection DATS 8 0 QVERSDAT
KATAB2 Catalog Entry Is a Selected Set CHAR 1 0 QKTTAB
KATALGART2 Catalog Type of Assigned Code Group or Selected Set CHAR 1 0 TQ15 QKATAUSW
AUSWMENGE2 Assigned Code Group or Selected Set CHAR 8 0 QCGRAUSW
AUSWMGWRK2 Plant of the Assigned Selected Set CHAR 4 0 T001W QWERKAUSW
AUSWVERS2 Version Number CHAR 6 0 QVERSNR
AUSWDAT2 Key Date for Version Selection DATS 8 0 QVERSDAT
KATAB3 Catalog Entry Is a Selected Set CHAR 1 0 QKTTAB
KATALGART3 Catalog Type of Assigned Code Group or Selected Set CHAR 1 0 TQ15 QKATAUSW
AUSWMENGE3 Assigned Code Group or Selected Set CHAR 8 0 QCGRAUSW
AUSWMGWRK3 Plant of the Assigned Selected Set CHAR 4 0 T001W QWERKAUSW
AUSWVERS3 Version Number CHAR 6 0 QVERSNR
AUSWDAT3 Key Date for Version Selection DATS 8 0 QVERSDAT
KATAB4 Catalog Entry Is a Selected Set CHAR 1 0 QKTTAB
KATALGART4 Catalog Type of Assigned Code Group or Selected Set CHAR 1 0 TQ15 QKATAUSW
AUSWMENGE4 Assigned Code Group or Selected Set CHAR 8 0 QCGRAUSW
AUSWMGWRK4 Plant of the Assigned Selected Set CHAR 4 0 T001W QWERKAUSW
AUSWVERS4 Version Number CHAR 6 0 QVERSNR
AUSWDAT4 Key Date for Version Selection DATS 8 0 QVERSDAT
KATAB5 Catalog Entry Is a Selected Set CHAR 1 0 QKTTAB
KATALGART5 Catalog Type of Assigned Code Group or Selected Set CHAR 1 0 TQ15 QKATAUSW
AUSWMENGE5 Assigned Code Group or Selected Set CHAR 8 0 QCGRAUSW
AUSWMGWRK5 Plant of the Assigned Selected Set CHAR 4 0 T001W QWERKAUSW
AUSWVERS5 Version Number CHAR 6 0 QVERSNR
AUSWDAT5 Key Date for Version Selection DATS 8 0 QVERSDAT
DUMMY10 Text Line for Additional Information CHAR 10 0 QTXT10
DUMMY20 Text Line for Additional Information CHAR 20 0 QTXT20
DUMMY40 Text Line for Additional Information CHAR 40 0 QTXT40
CHARACT_ID1 Characteristic Description for Quality Data Exchange CHAR 40 0 QCHARACT_ID1
QERGDATH Planned Results Data Origin CHAR 2 0 TQ73 QERGDATHPL
EEANTVERF Fraction Calculation CHAR 2 0 TQ72 QEANTVERF
QDYNREGEL Dynamic Modification Rule CHAR 3 0 QDDR QDYNREGEL
DYNMERKREF Characteristic (in Plan) whose Q-Level Will Be Copied NUMC 4 0 QMERKDYN
PZLFH Assigned Test Equipment NUMC 8 0 QPZLFH
CODEGRQUAL Defect Code Group for General Rejection CHAR 8 0 * QCODEGRPQL
CODEQUAL Defect Code for Rejection: General CHAR 4 0 * QCODEQL
SPCKRIT SPC Criterion CHAR 3 0 QPSP QSPCKRIT
INPPROC Parameters for Input Processing in QM Results Recording CHAR 3 0 TQ71 QINPPROC
RES_PLAN Response Plan CHAR 3 0 TQPC_RESPLAN QP_RESPLAN
CTRMETH Control Method CHAR 3 0 TQPC_CTRMETH QP_CTRMETH
CHAORIG Inspection Characteristic Origin CHAR 3 0 TQPC_CHAORIG QP_CHAORIG
CHAORIG_GUID Reference to Characteristic That Was Adopted RAW 16 0 QP_CHAORIG_GUID
NO_INSPECTION Do Not Copy Inspection Characteristic to Inspection Lot CHAR 1 0 QP_NO_INSPECTION
CHAR_RELEVANCE Relevance of Characteristic for Inspection CHAR 1 0 QP_CHAR_RELEVANCE
General
X First Article Inspection
QP_CHAORIG_ID Original Identification for Characteristic CHAR 40 0 QMIP_CHAORIG_ID
CHARGROUP Characteristic Group CHAR 10 0 * QCHARGROUP
CHARGROUP_CREF Source Characteristic of Characteristic Group Division NUMC 4 0 QCHARGROUP_CREF
DIVISIONINT Internal Division ID NUMC 4 0 QDIVISIONINT
VALID_TO_ON_DB Valid-to date DATS 8 0 DATUB
VERSN Routing Version CHAR 4 0 PLNVERSN
VERSN_SOURCE Source Routing Version CHAR 4 0 PLNVERSN_SOURCE_VERSN
VERSN_SOURCE_PLNKN Task List Version: Number of source list node NUMC 8 0 PLNVERSN_SOURCE_PLNKN
VERSN_SOURCE_MERKNR Task List Version: Souce Inspection Characteristic Number NUMC 4 0 PLNVERSN_SOURCE_MERKNR
DUMMY_PLMK_INCL_EEW_PS Dummy function in length 1 CHAR 1 0 DUMMY
PLNAL Group Counter CHAR 2 0 PLNAL
PLNFL Sequence CHAR 6 0 PLNFOLGE
VORNR Operation/Activity Number CHAR 4 0 VORNR
VPLTY Type of the referenced task list CHAR 1 0 * VPLNTY
VPLNR Group of the referenced task list CHAR 8 0 VPLNNR
VPLAL Group counter of the referenced task list CHAR 2 0 VPLNAL
IDENT Operation ID CHAR 8 0 OPRID
IDENT_REF Operation ID of the referenced operation CHAR 8 0 OPR_REFID
HERKUNFT Origin of an operation CHAR 1 0 OPR_HER
0 Operation from current routing
1 Operation from referenced routing
2 Dummy operation
3 Referenced work center operation set
4 Sub-operation from current routing
5 Sub-operation from referenced routing
DATUB Valid-to date DATS 8 0 DATUB
AENNR_AUS To change number CHAR 12 0 * CPCS_ECN_TO
QUANTITAT Quantitative Characteristic CHAR 1 0 QKZQUNMK
MESSWERTE Measured Values Must Be Recorded CHAR 1 0 QKZQUMK
PRUEFKAT Reference to Characteristic Attribute Required CHAR 1 0 QKZPKAT
TOLEROBEN Upper Specification Limit CHAR 1 0 QKZTOLOB
TOLERUNTEN Lower Specification Limit CHAR 1 0 QKZTOLUN
SOLLPRUEF Check Target Value CHAR 1 0 QKZSOLLPR
PUMFKZ Inspection Scope CHAR 1 0 QPUMFKZ
Scope Not Fixed
< Smaller Inspection Scope Allowed
= Fixed Inspection Scope
> Larger Inspection Scope Allowed
LZEITKZ Long-Term Inspection CHAR 1 0 QLZEITKZ
ESTUKZ Recording Type CHAR 1 0 QESTUKZ
Summarized Recording
* Classed Recording
+ Single-Value Recording
- No Results Recording
DOKUKZ Documentation Required for Inspection Results CHAR 1 0 QDOKUKZ
Text Documentation of Test Values Is Not Required
+ All Test Values Must Be Documented with Text
. Test Values with Valuation R (Reject) Must Be Documented
RZWANG Characteristic Category CHAR 1 0 QRZWANG
Optional Characteristic
+ Required When Previous Required Characteristic Is Accepted
- Required When Previous Required Characteristic Is Rejected
X Required Characteristic
SYNCRO Synchronization is Active CHAR 1 0 QSYNCRO
ADDPRO Inspection Sample Quantity Is Added CHAR 1 0 QADDPRO
ZERSTPRF Destructive Inspection CHAR 1 0 QKZDESTROY
FORMELMK Calculated Characteristic CHAR 1 0 QKZFORMEL
No Formula
1 Input Processing
X Calculated Characteristic
STICHPR Sampling Procedure Is Required CHAR 1 0 QSTICHPR
AUSSLOS Characteristic Relevant for Quality Score and Scrap Share CHAR 1 0 QAUSSLOS
FIXIERT Default Control Indicators Cannot Be Changed CHAR 1 0 QNAENDKZ
BEWFHLZHL Recording the Number of Defects CHAR 1 0 QBFHLZHL
LSTKZ Control Characteristics Results - QM Subsystem CHAR 1 0 QLEITSTKZ
VORGAEND Specifications Can Be Changed CHAR 1 0 QVORGAEND
PMMZWANG Assignment of Test Equipment Required CHAR 1 0 QPMZWANG
FEHLREC Defects Recording Automatically Called Up CHAR 1 0 QFEHLREC
AENDBELEG Create Change Documents During Results Recording CHAR 1 0 QKZAENBEL
QSPCMK SPC Characteristic CHAR 1 0 QSPCMK
KEINDRUCK Print CHAR 1 0 QDRUCK1
Print
* Do Not Print at Skip
X Do Not Print
PARA Control Indicator "Parameter Characteristic" Set/Not Set CHAR 1 0 QPARA
PROCESSMK Process Characteristic CHAR 1 0 QKZPROCCHAR
MATKZ Material Considered for Dynamic Modification CHAR 1 0 QMATKZ
LIEFKZ Supplier Considered for Dynamic Modification CHAR 1 0 QLIFKZ
HERSTKZ Manufacturer Considered for Dynamic Modification CHAR 1 0 QHERSTKZ
KUNDKZ Customer Considered for Dynamic Modification CHAR 1 0 QKUNDKZ
MASCHKZ Machine Considered for Dynamic Modification CHAR 1 0 QMASCHKZ
PROKZ Project Considered for Dynamic Modification CHAR 1 0 QPROKZ
VSTEUERKZ Key Containing Preset Characteristic Control Indicators CHAR 4 0 TQ27 QSTEUERKZ
PSNFH Item Number for Production Resource/Tool NUMC 4 0 PSNFH
FHMNR Production resource/tool number CHAR 40 0 FHMNR
KZUMFS Multiple Samples CHAR 1 0 QKZUMFS
No Multiple Samples
1 Dependent Multiple Samples
X Independent Multiple Samples
ATINN Internal characteristic NUMC 10 0 * ATINN
ATNAM Name of the Class Characteristic CHAR 30 0 QATNAM
SLWBEZ Identifier for Inspection Point Field Combination CHAR 3 0 * QSLWBEZ
QDYNHEAD Level at Which Dynamic Modification Parameters Are Defined CHAR 1 0 * QDYNHEAD
TXTZ1 First Line of Text for Production Resources/Tools CHAR 40 0 TXTZ1
STICHPRTXT Short Text for the Sampling Procedure CHAR 40 0 QTXTSMPPRO
MASTERCTXT Short Text for Inspection Characteristic CHAR 40 0 QTXT_CHA
FLG_LOCK Inspection Characteristic Is Locked CHAR 1 0 CHA_LOCK
HANDLE Internal ID of an object INT4 10 0 HANDLE

CHA_CLASS_DATA foreign key relationships

Table Field Check Table Check Field
0 CHA_CLASS_DATA AUSWMGWRK1 T001W Plants/Branches MANDT
0 CHA_CLASS_DATA AUSWMGWRK1 T001W Plants/Branches WERKS
1 CHA_CLASS_DATA AUSWMGWRK2 T001W Plants/Branches MANDT
1 CHA_CLASS_DATA AUSWMGWRK2 T001W Plants/Branches WERKS
0 CHA_CLASS_DATA AUSWMGWRK3 T001W Plants/Branches MANDT
0 CHA_CLASS_DATA AUSWMGWRK3 T001W Plants/Branches WERKS
1 CHA_CLASS_DATA AUSWMGWRK4 T001W Plants/Branches MANDT
1 CHA_CLASS_DATA AUSWMGWRK4 T001W Plants/Branches WERKS
0 CHA_CLASS_DATA AUSWMGWRK5 T001W Plants/Branches MANDT
0 CHA_CLASS_DATA AUSWMGWRK5 T001W Plants/Branches WERKS
1 CHA_CLASS_DATA EEANTVERF TQ72 Type of share calculation ANTVERF
0 CHA_CLASS_DATA INPPROC TQ71 Input Processing in Results Recording QM MANDT
0 CHA_CLASS_DATA INPPROC TQ71 Input Processing in Results Recording QM INPPROC
1 CHA_CLASS_DATA KATALGART1 TQ15 Inspection catalog type index KATALOGART
0 CHA_CLASS_DATA KATALGART2 TQ15 Inspection catalog type index KATALOGART
1 CHA_CLASS_DATA KATALGART3 TQ15 Inspection catalog type index KATALOGART
0 CHA_CLASS_DATA KATALGART4 TQ15 Inspection catalog type index KATALOGART
1 CHA_CLASS_DATA KATALGART5 TQ15 Inspection catalog type index KATALOGART
0 CHA_CLASS_DATA MASSEINHSW T006 Units of Measurement MANDT
1 CHA_CLASS_DATA MERKGEW TQ17A Characteristic weightings MANDT
0 CHA_CLASS_DATA PMETHODE QMTB Inspection method master record MANDT
0 CHA_CLASS_DATA PMETHODE QMTB Inspection method master record WERKS
0 CHA_CLASS_DATA PMETHODE QMTB Inspection method master record VERSION
1 CHA_CLASS_DATA PROBEMGEH T006 Units of Measurement MANDT
0 CHA_CLASS_DATA PRUEFQUALI TQ11 Inspector qualification MANDT
1 CHA_CLASS_DATA QDYNREGEL QDDR Dynamic modification rule (header) MANDT
0 CHA_CLASS_DATA QERGDATH TQ73 Origin of results data MANDT
0 CHA_CLASS_DATA QERGDATH TQ73 Origin of results data QERGDATH
1 CHA_CLASS_DATA QMTB_WERKS T001W Plants/Branches MANDT
1 CHA_CLASS_DATA QMTB_WERKS T001W Plants/Branches WERKS
0 CHA_CLASS_DATA SPCKRIT QPSP SPC criterion MANDT
0 CHA_CLASS_DATA SPCKRIT QPSP SPC criterion SPCKRIT
1 CHA_CLASS_DATA TOLERANZSL TQ29 Defaults for target value and tolerances for characteristics MANDT
1 CHA_CLASS_DATA TOLERANZSL TQ29 Defaults for target value and tolerances for characteristics TOLERANZSL
0 CHA_CLASS_DATA VERWMERKM QPMK Inspection characteristic master MANDT
0 CHA_CLASS_DATA VERWMERKM QPMK Inspection characteristic master ZAEHLER
0 CHA_CLASS_DATA VERWMERKM QPMK Inspection characteristic master VERSION
1 CHA_CLASS_DATA VSTEUERKZ TQ27 Table of default values for charac. control indicators KZEINSTELL