QEC_RESULT SAP (Characteristic Structure for Copy Insp. Results Function) Structure details
Dictionary Type: Structure
Description: Characteristic Structure for Copy Insp. Results Function
Description: Characteristic Structure for Copy Insp. Results Function
Structure field list including key, data, relationships and ABAP select examples
QEC_RESULT is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Characteristic Structure for Copy Insp. Results Function" Information within sap ABAP programs.
This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.
i.e. DATA: wa_QEC_RESULT TYPE QEC_RESULT.
The QEC_RESULT table consists of various fields, each holding specific information or linking keys about Characteristic Structure for Copy Insp. Results Function data available in SAP. These include INSPOPER (Inspection Lot Operation Number), INSPCHAR (Insp. Lot Charac. No.), INSPSAMPLE (Insp. Lot Sample), EQUNR (Equipment Number).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can Be Enhanced (Deep)
SAP QEC_RESULT structure fields - Full list of fields found in SAP data dictionary
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
| INSPLOT | Inspection Lot Number | QIBPLOSNR | NUMC | 12 | Assigned to domain | QPLOS | QLS | ||
| INSPOPER | Inspection Lot Operation Number | QIBPVORNR | CHAR | 4 | NUMCV | VORNR | |||
| INSPCHAR | Insp. Lot Charac. No. | QIBPMERKNR | NUMC | 4 | NUMC4 | ||||
| INSPSAMPLE | Insp. Lot Sample | QIBPPROBE | NUMC | 6 | Assigned to domain | QPROBENR | |||
| EQUNR | Equipment Number | EQUNR | CHAR | 18 | Assigned to domain | ALPHA | EQUNR | EQN | EQUI |
| PHYNR | Physical Sample Number | QPHYSPRNR | CHAR | 12 | Assigned to domain | ALPHA | QPHYSPRNR | QPN | |
| TPLNR | Functional Location | TPLNR | CHAR | 30 | Assigned to domain | TPLNR | TPLNR | IFL | IFLM |
| USERC1 | User Field for 18 Characters | QUSRCHAR18 | CHAR | 18 | ALPHA | QUSRCHAR18 | |||
| USERC2 | User Field for 10 Characters | QUSRCHAR10 | CHAR | 10 | ALPHA | QUSRCHAR10 | |||
| USERN1 | User Field for 10 Digits | QUSRNUMC10 | NUMC | 10 | QUSRNUMC10 | ||||
| USERN2 | User Field for 3 Digits | QUSRNUMC3 | NUMC | 3 | QUSRNUMC3 | ||||
| USERD1 | User Field for Date | QEIFUSRDAT | DATS | 8 | DATUM | ||||
| USERT1 | User Field for Time | QEIFUSRTIM | TIMS | 6 | QZEIT | ||||
| SLWBEZ | Identification for the Inspection Point Field Combination | QSLWBEZ | CHAR | 3 | Assigned to domain | QSLWBEZ | QBK | ||
| MSTR_CHAR | Master Characteristic | QMSTR_CHAR | CHAR | 8 | CHAR8 | ||||
| PMSTR_CHAR | Plant for Master Inspection Characteristic | QEIFPMKWRK | CHAR | 4 | QZAEHLER | ||||
| METHOD | Inspection Method | QPMETHODE | CHAR | 8 | Assigned to domain | ALPHA | QPMETHODE | PMT | |
| PMETHOD | Plant for Inspection Method | QEIFMTBWRK | CHAR | 4 | Assigned to domain | WERKS | |||
| CHARACTERISTIC_NAME | Characteristic Description for Quality Data Exchange | QCHARACT_ID1 | CHAR | 40 | ALPHA | QCHARACT_ID | |||
| ATINN | Internal characteristic | ATINN | NUMC | 10 | Assigned to domain | ATINN | ATINN | ||
| MEAS_UNIT | Measurement Unit in Which Quantitative Data Is Maintained | QMGEH6 | CHAR | 6 | Assigned to domain | LUNIT | MSEC6 | ||
| STATUS | Results Record Status | QBEASTATUS | CHAR | 1 | Assigned to domain | QSTATUS | |||
| QERGDATH | Origin of Results Data | QERGDATH | CHAR | 2 | Assigned to domain | QERGDATH | |||
| SOLLSTPUMF | Sample Size that Has to Be Inspected for a Characteristic | QGESUMF | INT4 | 10 | QANZAHL4 | ||||
| ESTUKZ | Recording Type | QESTUKZ | CHAR | 1 | QESTUKZ | ||||
| FORMELMK | Calculated Characteristic | QKZFORMEL | CHAR | 1 | QKZFORMEL | ||||
| QUANTITAT | Quantitative Characteristic | QKZQUNMK | CHAR | 1 | QKZ | ||||
| PRUEFKAT | Reference to Characteristic Attribute Required | QKZPKAT | CHAR | 1 | QKZ | ||||
| BEWFHLZHL | Recording the Number of Defects | QBFHLZHL | CHAR | 1 | QKZ | ||||
| CHAR_RESULT | 0 | ||||||||
| ATTRIBUT | Attribute of the Results Record (Valid, Invalid,...) | QATTRIBUT | CHAR | 1 | QATTRIBUT | ||||
| QERGDATH | Origin of Results Data | QERGDATH | CHAR | 2 | QERGDATH | ||||
| PRUEFER | Name of the Inspector | QPRUEFER | CHAR | 12 | QPRUEFER | QPR | |||
| PRUEFDATUV | Inspection Start Date | QPRUEFDATV | DATS | 8 | DATUM | QDV | |||
| PRUEFDATUB | End Date of the Inspection | QPRUEFDATB | DATS | 8 | DATUM | ||||
| PRUEFZEITV | Starting Time of the Inspection | QPRUEFZTV | TIMS | 6 | QZEIT | QZV | |||
| PRUEFZEITB | End Time of the Inspection | QPRUEFZTB | TIMS | 6 | QZEIT | ||||
| PRUEFBEMKT | Short Text | QKURZTEXT | CHAR | 40 | QKURZTEXT | ||||
| ANZFEHLEH | Number of Nonconforming Sample Units | QANZFEHEH4 | INT4 | 10 | QANZAHL4 | ||||
| ANZFEHLER | Number of Defects Found | QANZFEHL4 | INT4 | 10 | QANZAHL4 | ||||
| ANZWERTO | Number of Measured Values Above the Tolerance Range | QANZWERTO4 | INT4 | 10 | QANZAHL4 | ||||
| ANZWERTU | Number of Measured Values Below the Tolerance Range | QANZWERTU4 | INT4 | 10 | QANZAHL4 | ||||
| ANZWERTG | Number of Inspected Sample Units | QANZWERTG4 | INT4 | 10 | QANZAHL4 | ||||
| MITTELWERT | Mean Value | QMEAN_VAL | CHAR | 22 | QIFLTP | ||||
| VARIANZ | Variance | QVARIANCE | CHAR | 22 | QIFLTP | ||||
| STDABW | Standard Deviation of Valid Measured Values | QSTDAWC | CHAR | 16 | QSTATWERTC | ||||
| KATALGART1 | Catalog Type of Assigned Code Group or Selected Set | QKATAUSW | CHAR | 1 | QKATART | QKT | |||
| GRUPPE1 | Code Group | QCODEGRP | CHAR | 8 | QCODEGRP | CGP | |||
| CODE1 | Code | QCODE | CHAR | 4 | QCODE | QCODE | |||
| VERSION1 | Version Number | QVERSNR | CHAR | 6 | ALPHA | QVERSNR | |||
| KATALGART2 | Catalog Type of Assigned Code Group or Selected Set | QKATAUSW | CHAR | 1 | QKATART | QKT | |||
| GRUPPE2 | Code Group | QCODEGRP | CHAR | 8 | QCODEGRP | CGP | |||
| CODE2 | Code | QCODE | CHAR | 4 | QCODE | QCODE | |||
| VERSION2 | Version Number | QVERSNR | CHAR | 6 | ALPHA | QVERSNR | |||
| KATALGART3 | Catalog Type of Assigned Code Group or Selected Set | QKATAUSW | CHAR | 1 | QKATART | QKT | |||
| GRUPPE3 | Code Group | QCODEGRP | CHAR | 8 | QCODEGRP | CGP | |||
| CODE3 | Code | QCODE | CHAR | 4 | QCODE | QCODE | |||
| VERSION3 | Version Number | QVERSNR | CHAR | 6 | ALPHA | QVERSNR | |||
| KATALGART4 | Catalog Type of Assigned Code Group or Selected Set | QKATAUSW | CHAR | 1 | QKATART | QKT | |||
| GRUPPE4 | Code Group | QCODEGRP | CHAR | 8 | QCODEGRP | CGP | |||
| CODE4 | Code | QCODE | CHAR | 4 | QCODE | QCODE | |||
| VERSION4 | Version Number | QVERSNR | CHAR | 6 | ALPHA | QVERSNR | |||
| KATALGART5 | Catalog Type of Assigned Code Group or Selected Set | QKATAUSW | CHAR | 1 | QKATART | QKT | |||
| GRUPPE5 | Code Group | QCODEGRP | CHAR | 8 | QCODEGRP | CGP | |||
| CODE5 | Code | QCODE | CHAR | 4 | QCODE | QCODE | |||
| VERSION5 | Version Number | QVERSNR | CHAR | 6 | ALPHA | QVERSNR | |||
| SINGLE_RESULTS | 0 |
| Key field | Non-key field |
How do I retrieve data from SAP structure QEC_RESULT using ABAP code?
As QEC_RESULT is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on QEC_RESULT as there is no data to select.How to access SAP table QEC_RESULT
Within an ECC or HANA version of SAP you can also view further information about QEC_RESULT and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects