SAP ABAP Table QCERT_TS_CHARACT (Quality Certificate Data at Characteristics Level)
Hierarchy
BBPCRM (Software Component) BBPCRM
   CRM (Application Component) Customer Relationship Management
     CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       QC (Package) QM quality certificate
Basic Data
Table Category INTTAB    Structure 
Structure QCERT_TS_CHARACT   Table Relationship Diagram
Short Description Quality Certificate Data at Characteristics Level    
Delivery and Maintenance
Pool/cluster      
Delivery Class      
Data Browser/Table View Maintenance     Display/Maintenance Allowed with Restrictions 
Components
     
Field Key Data Element Domain Data
Type
Length Decimal
Places
Short Description Check
table
1 QCVME QCVME   STRU 0   0    
2 .INCLUDE       0   0   Certificate profile characteristic level  
3 MANDANT MANDT MANDT CLNT 3   0   Client  
4 CTYP QZGTYP QZGTYP CHAR 4   0   Certificate Type  
5 VORLNR QVORLNR QVORLNR CHAR 12   0   Certificate Profile Number  
6 VERSION QCVERSION QVERSNR CHAR 6   0   Version Number of Certificate Profile  
7 BLOCKNR QBLOCKNR NUMC4 NUMC 4   0   Number of Characteristic Block  
8 MERKMALNR QMKNR QCMERKNR NUMC 4   0   Consecutive Characteristic Number  
9 SORTNR QSORTNR NUMC4 NUMC 4   0   Sort Number  
10 TEXT_ELEM QCTEXTELEM CHAR4 CHAR 4   0   Assignment of a Characteristic to a Form Text Element  
11 KATEGORIE QCCHARCAT QCMERKKAT CHAR 1   0   Characteristic Category for Certificates  
12 ZAEHLER WERKS_D WERKS CHAR 4   0   Plant  
13 MKMNR QMERKNR QMERKNR CHAR 8   0   Master Inspection Characteristics  
14 VERSIONMK QVERSNRMK QVERSNR CHAR 6   0   Version Number of the Master Inspection Characteristic  
15 CMERKMALID ATINN ATINN NUMC 10   0   Internal characteristic  
16 KZHERKWERT QKZHERKWT QKZHERKWT CHAR 2   0   Origin of the Characteristic Result on the Certificate  
17 KZHERKTEXT QKZHERKTXT QKZHERKTXT CHAR 2   0   Origin of Characteristic Short Text  
18 KZAUSGFMT QKZAUSGFMT QKZAUSGFMT CHAR 2   0   Characteristic Output Format  
19 KZMETHODE QKZMETHODE QKZMETHODE CHAR 2   0   Output Inspection Method  
20 KZESEL QKZESEL QKZESEL CHAR 1   0   Level for Result Selection  
21 KZHERKVG QKZHERKVG QKZHERKVG CHAR 2   0   Origin of Inspection Specifications  
22 KZSTRSKIP QKZSTRSKIP QKZSTRSKIP CHAR 2   0   Output Strategy for Skip Characteristics  
23 MASSEINHSW QMASSEH MEINS UNIT 3   0   Unit of Measurement, in Which Quantitative Data Is Stored  
24 AUSGLEN QLAENGE QLAENGE INT1 3   0   Output Length  
25 STELLEN QSTELLEN QSTELLEN INT1 3   0   Number of Places to the Right of a Decimal Point (Accuracy)  
26 KZEXPDS QKZEXPDS QKZ CHAR 1   0   Indicator: Exponential Notation  
27 KZOFFSPTX QKZOFFSPTX QKZOFFSPTX CHAR 1   0   Additional Text When Result Is Outside Specifications  
28 KZOBL QKZMKOBL QKZ CHAR 1   0   Indicator: Characteristic Required  
29 VMSORTNR QCSORTNR NUMC4 NUMC 4   0   Sort Number in List of Materials for Certificate Profile  
30 COLUMNSORT QCCOLSORT QKZ CHAR 1   0   Display by Columns  
31 COLUMNS QCCOLUMNS NUMC2 NUMC 2   0   Number of Columns  
32 UNITNRSORT QCUNITSORT QKZ CHAR 1   0   Sort by Term for Inspected Unit  
33 CHARACT_ID1 QCHARACT_ID1 QCHARACT_ID CHAR 40   0   Characteristic Description for Quality Data Exchange  
34 .INCLUDE       0   0    
35 TQ61_FBNAM RS38L_FNAM FUNCNAME CHAR 30   0   Name of Function Module  
36 FROM_LOT QKZFROMLOT QKZ CHAR 1   0   Indicator: Read Inspection Lots  
37 TQ62_FBNAM RS38L_FNAM FUNCNAME CHAR 30   0   Name of Function Module  
38 TQ63_FBNAM RS38L_FNAM FUNCNAME CHAR 30   0   Name of Function Module  
39 TQ64_FBNAM RS38L_FNAM FUNCNAME CHAR 30   0   Name of Function Module  
40 INCOMPLETE QKZ QKZ CHAR 1   0   X and Blank (Indicator)  
41 ATNAM ATNAM ATNAM CHAR 30   0   Characteristic Name  
42 VALUESORTNR QSORTNR NUMC4 NUMC 4   0   Sort Number  
43 IPMEDIUM QCIPMEDIUM QKZ CHAR 1   0   Mean Value / Original Values from All Inspection Points  
44 QCSPEC QCSPEC   STRU 0   0    
45 PRUEFLOS QPLOS QPLOS NUMC 12   0   Inspection Lot Number  
46 TEILLOS QTLOS QTLOS NUMC 6   0   Partial lot number  
47 VORGLFNR QLFNKN KNTNR NUMC 8   0   Current Node Number from Order Counter APLZL  
48 MATNR MATNR MATNR CHAR 18   0   Material Number  
49 CHARG CHARG_D CHARG CHAR 10   0   Batch Number  
50 PHYSPROBE QPHYSPROBE QPROBENR NUMC 6   0   Number of the Partial Sample  
51 STATUSV QSTATUS QSTATUS CHAR 1   0   Specification Record Status  
52 STATUSTEXT QKURZTEXT QKURZTEXT CHAR 40   0   Short Text  
53 QUANTITAT QKZQUNMK QKZ CHAR 1   0   Quantitative Characteristic  
54 MESSWERTE QKZQUMK QKZ CHAR 1   0   Measured Values Must Be Recorded  
55 PRUEFKAT QKZPKAT QKZ CHAR 1   0   Reference to Characteristic Attribute Required  
56 TOLEROBEN QKZTOLOB QKZ CHAR 1   0   Upper Specification Limit  
57 TOLERUNTEN QKZTOLUN QKZ CHAR 1   0   Lower Specification Limit  
58 PUMFKZ QPUMFKZ QPUMFKZ CHAR 1   0   Inspection Scope  
59 LZEITKZ QLZEITKZ QKZ CHAR 1   0   Long-Term Inspection  
60 ESTUKZ QESTUKZ QESTUKZ CHAR 1   0   Recording Type  
61 DOKUKZ QDOKUKZ QDOKUKZ CHAR 1   0   Documentation Required for Inspection Results  
62 RZWANG QRZWANG QRZWANG CHAR 1   0   Characteristic Category  
63 SYNCRO QSYNCRO QKZ CHAR 1   0   Synchronization is Active  
64 ZERSTPRF QKZDESTROY QKZ CHAR 1   0   Destructive Inspection  
65 FORMELMK QKZFORMEL QKZFORMEL CHAR 1   0   Calculated Characteristic  
66 STICHPR QSTICHPR QKZ CHAR 1   0   Sampling Procedure is Required  
67 AUSSLOS QAUSSLOS QKZ CHAR 1   0   Characteristic Relevant for Qual. Score and Scrap Share  
68 BEWFHLZHL QBFHLZHL QKZ CHAR 1   0   Recording the Number of Defects  
69 FEHLREC QFEHLREC QKZ CHAR 1   0   Defects Recording Automatically Called Up  
70 AENDBELEG QKZAENBEL QKZ CHAR 1   0   Create Change Documents During Results Recording  
71 QMTB_WERKS WERKS_D WERKS CHAR 4   0   Plant  
72 PMETHODE QPMETHODE QPMETHODE CHAR 8   0   Inspection Method  
73 PMTVERSION QVERSNRPM QVERSNR CHAR 6   0   Version Number of the Inspection Method  
74 PMT_KTEXT QTXTMETHOD QKURZTEXT CHAR 40   0   Short Text for Inspection Method  
75 PMT_LTXTKZ QLTEXTMT QKZ CHAR 1   0   Long Text Exists for the Inspection Method  
76 MERKGEW QMERKGEW QMERKKLAS CHAR 2   0   Weighting of the Characteristic  
77 WERKS QWERKS WERKS CHAR 4   0   Plant  
78 MKMNR QMERKNR QMERKNR CHAR 8   0   Master Inspection Characteristics  
79 VERSION QVERSNRMK QVERSNR CHAR 6   0   Version Number of the Master Inspection Characteristic  
80 KURZTEXT QMKKURZTXT QKURZTEXT CHAR 40   0   Short Text for the Inspection Characteristic  
81 DUMMY10 QTXT10 QTXT10 CHAR 10   0   Text Line for Additional Information  
82 DUMMY20 QTXT20 QTXT20 CHAR 20   0   Text Line for Additional Information  
83 DUMMY40 QTXT40 QTXT40 CHAR 40   0   Text Line for Additional Information  
84 AUSWMENGE1 QCGRAUSW QCGRAUSW CHAR 8   0   Assigned Code Group or Selected Set  
85 AUSWMGWRK1 QWERKAUSW WERKS CHAR 4   0   Plant of the Assigned Selected Set  
86 AUSWMTEXT1 QTXT_GROUP QKURZTEXT CHAR 40   0   Short Text for the Code Group/Selected Set  
87 TEXT_KAT1 QTXTCATALG QKURZTEXT CHAR 40   0   Short Text for the Catalog  
88 STELLEN QSTELLEN QSTELLEN INT1 3   0   Number of Places to the Right of a Decimal Point (Accuracy)  
89 MASSEINHSW MSEHI MEINS UNIT 3   0   Unit of Measurement  
90 SOLLWERT QSOLLWERTC QSOLLWERTC CHAR 16   0   Target Value for a Quantitative Characteristic  
91 TOLERANZOB QTOLOBC QSOLLWERTC CHAR 16   0   Upper Specification Limit  
92 TOLERANZUN QTOLUNC QSOLLWERTC CHAR 16   0   Lower Specification Limit  
93 TOLOBFLOAT QTOLOB QSOLLWERTE FLTP 16   16   Upper Specification Limit  
94 TOLUNFLOAT QTOLUN QSOLLWERTE FLTP 16   16   Lower Tolerance Limit  
95 TOLERWKZ QTOLERWKZ QKZ CHAR 1   0   Tolerance Change Is Active  
96 GRENZEOB1 QGRENZO1C QSOLLWERTC CHAR 16   0   First Upper Specification Limit  
97 GRENZEUN1 QGRENZU1C QSOLLWERTC CHAR 16   0   First Lower Specification Limit  
98 GRENZEOB2 QGRENZO2C QSOLLWERTC CHAR 16   0   Second Upper Specification Limit  
99 GRENZEUN2 QGRENZU2C QSOLLWERTC CHAR 16   0   Second Lower Specification Limit  
100 PLAUSIOBEN QPLAUSIOBC QSOLLWERTC CHAR 16   0   Upper Plausibility Limit  
101 PLAUSIUNTE QPLAUSIUNC QSOLLWERTC CHAR 16   0   Lower Plausibility Limit  
102 STICHPRVER QSTICHVERF QSTPRVER CHAR 8   0   Sampling Procedure in Inspection Characteristic  
103 STPRVTEXT QTXTSMPPRO QKURZTEXT CHAR 40   0   Short Text for the Sampling Procedure  
104 SOLLSTPUMF QGESUMF QANZAHL4 INT4 10   0   Sample Size that Has to Be Inspected for a Characteristic  
105 PRUEFUMF QPRUEFUMF QMENGEPLOS QUAN 13   3   Quantity to Be Inspected  
106 MENGENEINH QPROBEMGEH MEINS UNIT 3   0   Base Unit of Measure for the Sample Unit  
107 HPZ QHPZ QKZ CHAR 1   0   100% Inspection  
108 KZATTRFE QKZATTRFE QKZ CHAR 1   0   Attributive Inspection by Nonconforming Units  
109 KZATTRFZ QKZATTRFZ QKZ CHAR 1   0   Attributive Inspection by Number of Defects  
110 KZVARS QKZVARS QKZ CHAR 1   0   Variable Inspection by S-Method  
111 KZCOD QKZCOD QKZ CHAR 1   0   Valuation by Code  
112 KZMAN QKZMAN QKZ CHAR 1   0   Manual Valuation  
113 KZUMFS QKZUMFS QKZUMFS CHAR 1   0   Multiple Samples  
114 KZNULL QKZKNULL QKZ CHAR 1   0   Inspection Against Specification Limits (k = 0)  
115 ANNAHMEZ QANNAHMEZ QINT2NEG INT2 5   0   Acceptance Number  
116 RUECKWEZ QRUECKWEZ QANZAHL2 INT2 5   0   Rejection Number  
117 KFAKTORNI QNINITIAL QKZ CHAR 1   0   Value Not Initial if Set  
118 KFAKTOR QKFAKTORC QKFAKTORC CHAR 16   0   K-Factor for a Variable Inspection  
119 ATCOD ATCOD ATCOD CHAR 1   0   Code for value dependency  
120 QCRES QCRES   STRU 0   0    
121 LEVEL_RESULT QKZESEL QKZESEL CHAR 1   0   Level for Result Selection  
122 PRUEFLOS QPLOS QPLOS NUMC 12   0   Inspection Lot Number  
123 TEILLOS QTLOS QTLOS NUMC 6   0   Partial lot number  
124 VORGLFNR QLFNKN KNTNR NUMC 8   0   Current Node Number from Order Counter APLZL  
125 MERKNR QMERKNRP QMERKNRP NUMC 4   0   Inspection Characteristic Number  
126 PROBENR QPROBENR QPROBENR NUMC 6   0   Sample Number  
127 DETAILERG QDETAILERG QDETAILERG NUMC 8   0   Number of the Individual Result  
128 MATNR MATNR MATNR CHAR 18   0   Material Number  
129 CHARG CHARG_D CHARG CHAR 10   0   Batch Number  
130 .INCLUDE       0   0   Quality Certificate: Result Output  
131 MVALUE QCOUTMVAL TDSTXLLINE CHAR 132   0   Certificates: Output Field for Mean Value  
132 ATTRIBUTE_QDI QCATTRIBUT QCATTRIBUT CHAR 3   0   Attribute for Results Record (Greater, Smaller,..)  
133 VALUE1_QDI QC_VALUE QSTATWERTC CHAR 16   0   Value or Part of Value Range on Certificate  
134 VALUE2_QDI QC_VALUE QSTATWERTC CHAR 16   0   Value or Part of Value Range on Certificate  
135 KZSPEC QCKZSPEC QCKZSPEC CHAR 2   0   Relationship of Value to Specifications  
136 STAT07 QKZFERTPRF QKZ CHAR 1   0   Inspection with Inspection Points  
137 SLWBEZ QSLWBEZ QSLWBEZ CHAR 3   0   Identification for the Inspection Point Field Combination  
138 STAT13 QPPKTTYP QPPKTTYP CHAR 1   0   Inspection Point Type  
139 PHYSPROBE QPHYSPROBE QPROBENR NUMC 6   0   Number of the Partial Sample  
140 STATUSR QBEASTATUS QSTATUS CHAR 1   0   Results Record Status  
141 STATUSTEXT QKURZTEXT QKURZTEXT CHAR 40   0   Short Text  
142 QUANTITAT QKZQUNMK QKZ CHAR 1   0   Quantitative Characteristic  
143 MESSWERTE QKZQUMK QKZ CHAR 1   0   Measured Values Must Be Recorded  
144 PRUEFKAT QKZPKAT QKZ CHAR 1   0   Reference to Characteristic Attribute Required  
145 TOLEROBEN QKZTOLOB QKZ CHAR 1   0   Upper Specification Limit  
146 TOLERUNTEN QKZTOLUN QKZ CHAR 1   0   Lower Specification Limit  
147 SOLLPRUEF QKZSOLLPR QKZ CHAR 1   0   Check Target Value  
148 PUMFKZ QPUMFKZ QPUMFKZ CHAR 1   0   Inspection Scope  
149 LZEITKZ QLZEITKZ QKZ CHAR 1   0   Long-Term Inspection  
150 ESTUKZ QESTUKZ QESTUKZ CHAR 1   0   Recording Type  
151 DOKUKZ QDOKUKZ QDOKUKZ CHAR 1   0   Documentation Required for Inspection Results  
152 RZWANG QRZWANG QRZWANG CHAR 1   0   Characteristic Category  
153 SYNCRO QSYNCRO QKZ CHAR 1   0   Synchronization is Active  
154 ZERSTPRF QKZDESTROY QKZ CHAR 1   0   Destructive Inspection  
155 FORMELMK QKZFORMEL QKZFORMEL CHAR 1   0   Calculated Characteristic  
156 STICHPR QSTICHPR QKZ CHAR 1   0   Sampling Procedure is Required  
157 AUSSLOS QAUSSLOS QKZ CHAR 1   0   Characteristic Relevant for Qual. Score and Scrap Share  
158 BEWFHLZHL QBFHLZHL QKZ CHAR 1   0   Recording the Number of Defects  
159 FEHLREC QFEHLREC QKZ CHAR 1   0   Defects Recording Automatically Called Up  
160 AENDBELEG QKZAENBEL QKZ CHAR 1   0   Create Change Documents During Results Recording  
161 WERKS QWERKS WERKS CHAR 4   0   Plant  
162 MKMNR QMERKNR QMERKNR CHAR 8   0   Master Inspection Characteristics  
163 VERSION QVERSNRMK QVERSNR CHAR 6   0   Version Number of the Master Inspection Characteristic  
164 KURZTEXT QMKKURZTXT QKURZTEXT CHAR 40   0   Short Text for the Inspection Characteristic  
165 ATNAM ATNAM ATNAM CHAR 30   0   Characteristic Name  
166 ATWTB ATWTB TEXT30 CHAR 30   0   Characteristic value description  
167 ATTRIBUT QATTRIBUT QATTRIBUT CHAR 1   0   Attribute of the Results Record (Valid, Invalid,...)  
168 ATTRTEXT DDTEXT DDTEXT CHAR 60   0   Explanatory short text  
169 QERGDATH QERGDATH QERGDATH CHAR 2   0   Origin of Results Data  
170 ERDATHETXT QKURZTEXT QKURZTEXT CHAR 40   0   Short Text  
171 MBEWERTG QMBEWERTG QEEBEWERTG CHAR 1   0   Inspection Result Valuation  
172 MBEWTEXT DDTEXT DDTEXT CHAR 60   0   Explanatory short text  
173 PRUEFBEMKT QKURZTEXT QKURZTEXT CHAR 40   0   Short Text  
174 PRLTEXTKZ QLTEXTKZ QKZ CHAR 1   0   Inspection Characteristic Long Text Exists  
175 LTEXTSPR SPRAS SPRAS LANG 1   0   Language Key  
176 ANZFEHLEH QANZFEHEH4 QANZAHL4 INT4 10   0   Number of Nonconforming Sample Units  
177 ANTEIL QANTEILC QSOLLWERTC CHAR 16   0   Estimated Fraction of Nonconforming Units  
178 ANZFEHLER QANZFEHL4 QANZAHL4 INT4 10   0   Number of Defects Found  
179 ANZWERTO QANZWERTO4 QANZAHL4 INT4 10   0   Number of Measured Values Above the Tolerance Range  
180 ANZWERTU QANZWERTU4 QANZAHL4 INT4 10   0   Number of Measured Values Below the Tolerance Range  
181 ANZWERTG QANZWERTG4 QANZAHL4 INT4 10   0   Number of Inspected Sample Units  
182 STELLEN QSTELLEN QSTELLEN INT1 3   0   Number of Places to the Right of a Decimal Point (Accuracy)  
183 MASSEINHSW MSEHI MEINS UNIT 3   0   Unit of Measurement  
184 MAXWERT QMAXWERTC QSTATWERTC CHAR 16   0   Maximum Value of the Valid Measured Values  
185 MINWERT QMINWERTC QSTATWERTC CHAR 16   0   Minimum Value of the Valid Measured Values  
186 MITTELWERT QMITTEWRTC QSTATWERTC CHAR 16   0   Arithmetic Mean of Valid Measured Values  
187 VARIANZ QVARIANZC QSTATWERTC CHAR 16   0   Dispersion (Variance) of Valid Measured Values  
188 MOMENT3 QMOMENT3C QSTATWERTC CHAR 16   0   Third Central Moment of Valid Measured Values  
189 MOMENT4 QMOMENT4C QSTATWERTC CHAR 16   0   Fourth Central Moment of Valid Measured Values  
190 ANTEILO QANTEILOC QSTATWERTC CHAR 16   0   Estimated Fraction Above the Tolerance Range  
191 ANTEILU QANTEILUC QSTATWERTC CHAR 16   0   Estimated Fraction Below the Tolerance Range  
192 IVARIANZ QIVARIANZC QSTATWERTC CHAR 16   0   Internal Dispersion of Valid Measured Values  
193 GRUPPE1 QCODEGRP QCODEGRP CHAR 8   0   Code Group  
194 CODE1 QCODE QCODE CHAR 4   0   Code  
195 CODEKTXT1 QTXT_CODE QKURZTEXT CHAR 40   0   Short Text for Code  
196 STDABW QSTDAWC QSTATWERTC CHAR 16   0   Standard Deviation of Valid Measured Values  
197 SPANNWEITE QSPANNWEIC QSTATWERTC CHAR 16   0   Range of Valid Measured Values  
198 FEHLKLAS QFEHLKLAS QFEHLKLAS CHAR 2   0   Defect class  
199 FEHLKLTEXT QKURZTEXT QKURZTEXT CHAR 40   0   Short Text  
200 PPSORTKEY QPPSORTKEY QPPSORT CHAR 70   0   Key Field (Sort Field) for Inspection Point  
201 EQUNR EQUNR EQUNR CHAR 18   0   Equipment Number  
202 TPLNR TPLNR TPLNR CHAR 30   0   Functional Location  
203 PHYNR QPHYSPRNR QPHYSPRNR CHAR 12   0   Physical Sample Number  
204 STUECKNR QSTUECKNR QZAEHL NUMC 4   0   Counter for Inspection Unit Number  
205 SERIALNR QPRUEFLINR QSERIALNR CHAR 18   0   Single-Unit Number for the Unit to Be Inspected  
206 MASCHINE QMASCHINE QEQUNR CHAR 18   0   General Information  
207 INSP_POSITION QPRPOS QPRPOS NUMC 4   0   Test Position  
208 GRPTXT1 QGRPTEXT QKURZTEXT CHAR 40   0   Short Text for Code Group  
209 UNIT_CHARACT QMGEH6 MSEC6 CHAR 6   0   Measurement Unit in Which Quantitative Data Is Maintained  
210 UNIT_CHARACT_10 MSEHT TEXT10 CHAR 10   0   Unit of Measurement Text (Maximum 10 Characters)  
211 UNIT_CHARACT_30 MSEHL TEXT30 CHAR 30   0   Unit of Measurement Text (Maximum 30 Characters)  
212 QCRES_TAB QC_TT_QCRES   TTYP 0   0    
213 QCTEXT QCTEXT   STRU 0   0    
214 SHORT_TEXT QCSHORTTX TDSTXLLINE CHAR 132   0   Certificates: Output Field for Characteristic Short Text  
215 QAPPUSR_TAB QC_TT_QAPPUSR   TTYP 0   0    
216 QAPP_TAB QC_TT_QAPP   TTYP 0   0    
History
Last changed by/on SAP  20130529 
SAP Release Created in 700