SAP QLTYCERTSPEC Table in S/4 HANA - Quality Certificate Specifications
QLTYCERTSPEC is a standard SAP Table which is used to store Quality Certificate Specifications data and is available within S/4 HANA SAP systems depending on the version and release level. Below is the technical details and the list of fields specifically relevant for an SAP S/4 HANA system
Even using an S/4 Hana system you can still view further information about the SAP QLTYCERTSPEC table and the data within it using standard SAP GUI transactions such as SE11, SE80 or SE16. Or you can use the ADT (ABAP development tools within eclipse).
Delivery Class:
Display/Maintenance via SM30: Display/Maintenance Allowed but with Restrictions
Enhancement category: Can Be Enhanced (Deep)
Dictionary Type: Structure
Database Table: QLTYCERTSPEC
QLTYCERTSPEC table structure field list
Below is the full QLTYCERTSPEC field list that makes up the SAP database table structure, including key fields, description, data type and other technical details of each field
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP | SHLP Field |
| INSPECTIONLOT | Inspection Lot Number | QPLOS | NUMC | 12(0) | QPLOS | QLS | QALS | PRUEFLOS | ||
| INSPECTIONPARTIALLOT | Partial lot number | QTLOS | NUMC | 6(0) | QTLOS | QTL | ||||
| INSPECTIONPLANOPERATIONINTERNA | Current Node Number from Order Counter | QLFNKN | NUMC | 8(0) | KNTNR | QOPER | ||||
| MATERIAL | Material Number | MATNR | CHAR | 40(0) | MATN1 | MATNR | MAT | S_MAT1 | MATNR | |
| BATCH | Batch Number | CHARG_D | CHAR | 10(0) | CHARG | CHA | ||||
| INSPCHARCPRTLSMPL | Number of the Partial Sample | QPHYSPROBE | NUMC | 6(0) | QPROBENR | |||||
| INSPECTIONCHARACTERISTICSTATUS | Specification Record Status | QSTATUS | CHAR | 1(0) | QSTATUS | |||||
| INSPCHARACTERISTICSTATUSTEXT | Short Text | QKURZTEXT | CHAR | 40(0) | QKURZTEXT | |||||
| INSPSPECISQUANTITATIVE | Quantitative Characteristic | QKZQUNMK | CHAR | 1(0) | QKZ | |||||
| INSPSPECISMEASUREDVALUERQD | Measured Values Must Be Recorded | QKZQUMK | CHAR | 1(0) | QKZ | |||||
| INSPSPECISSELECTEDSETREQUIRED | Reference to Characteristic Attribute Required | QKZPKAT | CHAR | 1(0) | QKZ | |||||
| INSPSPECUPPERLIMIT | Upper Specification Limit | QKZTOLOB | CHAR | 1(0) | QKZ | |||||
| INSPSPECLOWERLIMIT | Lower Specification Limit | QKZTOLUN | CHAR | 1(0) | QKZ | |||||
| INSPCHARCSCOPELIMITATION | Inspection Scope | QPUMFKZ | CHAR | 1(0) | QPUMFKZ | |||||
| INSPSPECISLONGTERMINSPECTION | Long-Term Inspection | QLZEITKZ | CHAR | 1(0) | QKZ | |||||
| INSPSPECRECORDINGTYPE | Recording Type | QESTUKZ | CHAR | 1(0) | QESTUKZ | |||||
| INSPRESULTISDOCUMENTATIONRQD | Documentation Required for Inspection Results | QDOKUKZ | CHAR | 1(0) | QDOKUKZ | |||||
| INSPSPECCHARCCATEGORY | Characteristic Category | QRZWANG | CHAR | 1(0) | QRZWANG | |||||
| INSPSPECISDESTRUCTIVE | Destructive Inspection | QKZDESTROY | CHAR | 1(0) | QKZ | |||||
| INSPSPECRESULTCALCULATION | Calculated Characteristic | QKZFORMEL | CHAR | 1(0) | QKZFORMEL | |||||
| INSPSPECISSAMPLINGPROCEDRQD | Sampling Procedure is Required | QSTICHPR | CHAR | 1(0) | QKZ | |||||
| INSPSPECISSCRAPRELEVANT | Characteristic Relevant for Quality Score and Scrap Share | QAUSSLOS | CHAR | 1(0) | QKZ | |||||
| INSPSPECISDEFECTRECORDINGRQD | Recording the Number of Defects | QBFHLZHL | CHAR | 1(0) | QKZ | |||||
| INSPSPECISDEFECTSRECGAUTOMATIC | Defects Recording Automatically Called Up | QFEHLREC | CHAR | 1(0) | QKZ | |||||
| INSPSPECISCHGDOCREQUIRED | Create Change Documents During Results Recording | QKZAENBEL | CHAR | 1(0) | QKZ | |||||
| INSPECTIONMETHODPLANT | Plant | WERKS_D | CHAR | 4(0) | WERKS | WRK | H_T001W_C | WERKS | ||
| INSPECTIONMETHOD | Inspection Method | QPMETHODE | CHAR | 8(0) | ALPHA | QPMETHODE | PMT | |||
| INSPECTIONMETHODVERSION | Version Number of the Inspection Method | QVERSNRPM | CHAR | 6(0) | ALPHA | QVERSNR | ||||
| INSPECTIONMETHODTEXT | Short Text for Inspection Method | QTXTMETHOD | CHAR | 40(0) | QKURZTEXT | |||||
| INSPMETHODHASLONGTEXT | Long Text Exists for the Inspection Method | QLTEXTMT | CHAR | 1(0) | QKZ | |||||
| INSPSPECIMPORTANCECODE | Weighting of Characteristic | QMERKGEW | CHAR | 2(0) | QMERKKLAS | |||||
| INSPECTIONSPECIFICATIONPLANT | Plant | QWERKS | CHAR | 4(0) | WERKS | |||||
| INSPECTIONSPECIFICATION | Master Inspection Characteristic | QMERKNR | CHAR | 8(0) | ALPHA | QMERKNR | PMK | |||
| INSPECTIONSPECIFICATIONVERSION | Version Number of the Master Inspection Characteristic | QVERSNRMK | CHAR | 6(0) | ALPHA | QVERSNR | ||||
| INSPECTIONSPECIFICATIONTEXT | Short Text for the Inspection Characteristic | QMKKURZTXT | CHAR | 40(0) | QKURZTEXT | |||||
| INSPSPECINFORMATIONFIELD1 | Text Line for Additional Information | QTXT10 | CHAR | 10(0) | QTXT10 | |||||
| INSPSPECINFORMATIONFIELD2 | Text Line for Additional Information | QTXT20 | CHAR | 20(0) | QTXT20 | |||||
| INSPSPECINFORMATIONFIELD3 | Text Line for Additional Information | QTXT40 | CHAR | 40(0) | QTXT40 | |||||
| SELECTEDCODESET | Assigned Code Group or Selected Set | QCGRAUSW | CHAR | 8(0) | QCGRAUSW | |||||
| SELECTEDCODESETPLANT | Plant of the Assigned Selected Set | QWERKAUSW | CHAR | 4(0) | WERKS | WRK | ||||
| SELECTEDCODESETTEXT | Short Text for the Code Group/Selected Set | QTXT_GROUP | CHAR | 40(0) | QKURZTEXT | |||||
| INSPSPECADDITIONALCATALOGTEXT | Short Text for the Catalog | QTXTCATALG | CHAR | 40(0) | QKURZTEXT | |||||
| INSPSPECDECIMALPLACES | Number of Places to the Right of a Decimal Point (Accuracy) | QSTELLEN | INT1 | 3(0) | QSTELLEN | |||||
| INSPECTIONSPECIFICATIONUNIT | Unit of Measurement | MSEHI | UNIT | 3(0) | CUNIT | MEINS | ||||
| INSPSPECFRMTDTARGETVALUE | Target Value for a Quantitative Characteristic | QSOLLWERTC | CHAR | 16(0) | QSOLLWERTC | |||||
| INSPSPECFRMTDUPPERLIMIT | Upper Specification Limit | QTOLOBC | CHAR | 16(0) | QSOLLWERTC | |||||
| INSPSPECFRMTDLOWERLIMIT | Lower Specification Limit | QTOLUNC | CHAR | 16(0) | QSOLLWERTC | |||||
| INSPSPECUPPERLIMITFLT | Upper Specification Limit | QTOLOB | FLTP | 16(16) | QSOLLWERTE | |||||
| INSPSPECLOWERLIMITFLT | Lower Specification Limit | QTOLUN | FLTP | 16(16) | QSOLLWERTE | |||||
| INSPSPECHASACTIVECHANGE | Tolerance Change Is Active | QTOLERWKZ | CHAR | 1(0) | QKZ | |||||
| INSPSPECFRMTD1STUPPERSPECLIMIT | First Upper Specification Limit | QGRENZO1C | CHAR | 16(0) | QSOLLWERTC | |||||
| INSPSPECFRMTD1STLOWERSPECLIMIT | First Lower Specification Limit | QGRENZU1C | CHAR | 16(0) | QSOLLWERTC | |||||
| INSPSPECFRMTD2NDUPPERSPECLIMIT | Second Upper Specification Limit | QGRENZO2C | CHAR | 16(0) | QSOLLWERTC | |||||
| INSPSPECFRMTD2NDLOWERSPECLIMIT | Second Lower Specification Limit | QGRENZU2C | CHAR | 16(0) | QSOLLWERTC | |||||
| INSPSPECFRMTDUPRPLSBLTYLMT | Upper Plausibility Limit | QPLAUSIOBC | CHAR | 16(0) | QSOLLWERTC | |||||
| INSPSPECFRMTDLOWERPLSBLTYLMT | Lower Plausibility Limit | QPLAUSIUNC | CHAR | 16(0) | QSOLLWERTC | |||||
| SAMPLINGPROCEDURE | Sampling Procedure in Inspection Characteristic | QSTICHVERF | CHAR | 8(0) | QSTPRVER | |||||
| SAMPLINGPROCEDURETEXT | Short Text for the Sampling Procedure | QTXTSMPPRO | CHAR | 40(0) | QKURZTEXT | |||||
| INSPCHARACTERISTICSAMPLESIZE | Sample Size that Has to Be Inspected for a Characteristic | QGESUMF | INT4 | 10(0) | QANZAHL4 | |||||
| INSPCHARCQUANTITY | Quantity to Be Inspected | QPRUEFUMF | QUAN | 13(3) | QMENGEPLOS | |||||
| INSPECTIONLOTSAMPLEUNIT | Base Unit of Measure for Sample Unit | QPROBEMGEH | UNIT | 3(0) | CUNIT | MEINS | ||||
| INSPECTIONLOTISFULLINSPECTION | 100% Inspection | QHPZ | CHAR | 1(0) | QKZ | |||||
| INSPVALNISBYNONCONFORMINGUNITS | Attributive Inspection by Nonconforming Units | QKZATTRFE | CHAR | 1(0) | QKZ | |||||
| INSPVALNISBYNUMBEROFDEFECTS | Attributive Inspection by Number of Defects | QKZATTRFZ | CHAR | 1(0) | QKZ | |||||
| INSPVALNISBYISOMETHOD | Variable Inspection by S-Method | QKZVARS | CHAR | 1(0) | QKZ | |||||
| INSPVALNISBYCODE | Valuation by Code | QKZCOD | CHAR | 1(0) | QKZ | |||||
| INSPVALNISMANUALLY | Manual Valuation | QKZMAN | CHAR | 1(0) | QKZ | |||||
| SAMPLINGPROCEDUREMLTPLSAMPLES | Multiple Samples | QKZUMFS | CHAR | 1(0) | QKZUMFS | |||||
| INSPVALNISBYSPECLIMITS | Inspection Against Specification Limits (k = 0) | QKZKNULL | CHAR | 1(0) | QKZ | |||||
| SAMPLINGPROCEDACCEPTANCECOUNT | Acceptance Number | QANNAHMEZ | INT2 | 5(0) | QINT2NEG | |||||
| INSPSAMPLEREJECTIONNUMBER | Rejection Number | QRUECKWEZ | INT2 | 5(0) | QANZAHL2 | |||||
| INSPVALFRMTDISOMETHODFACTOR | K-Factor for a Variable Inspection | QKFAKTORC | CHAR | 16(0) | QKFAKTORC | |||||
| CHARCVALUEDEPENDENCY | Code for value dependency | ATCOD | CHAR | 1(0) | ATCOD | |||||
| INSPMETHODLONGTEXT | Text for Inspection Method | INSPECTIONMETHODTEXT | STRG | 0(0) |
Search for further information about these or an SAP related objects