TQREO SAP (QM: Archiving Parameter) Table details
Dictionary Type: Table
Description: QM: Archiving Parameter
Description: QM: Archiving Parameter
Table field list including key, data, relationships and ABAP select examples
TQREO is a standard SAP Table which is used to store QM: Archiving Parameter data and is available within R/3 SAP systems depending on the version and release level.
The TQREO table consists of various fields, each holding specific information or linking keys about QM: Archiving Parameter data available in SAP. These include WERK (Plant), LOS (Retention Period for QM Transaction Data on Level 1), VORGMK (Retention Period for QM Transaction Data in Level 2), PROBEN (Retention Period for QM Transaction Data on Level 3).. 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: C - Customising table, maintenance only by custDisplay/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified
SAP TQREO table 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 |
| MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
| WERK | Plant | WERKS_D | CHAR | 4 | T001W | WERKS | WRK | H_T001W_C | |
| LOS | Retention Period for QM Transaction Data on Level 1 | QRESQALS | NUMC | 4 | QRESIDENZ | ||||
| VORGMK | Retention Period for QM Transaction Data in Level 2 | QRESVOMK | NUMC | 4 | QRESIDENZ | ||||
| PROBEN | Retention Period for QM Transaction Data on Level 3 | QRESPROBEN | NUMC | 4 | QRESIDENZ | ||||
| DETERG | Retention Period for QM Transaction Data on Level 4 | QRESDETEE | NUMC | 4 | QRESIDENZ | ||||
| STPRFMK | Retention Period for Archiving Master Insp. Characs | QRESQPMK | NUMC | 4 | QRESIDENZ | ||||
| PMETHODEN | Retention Period for Archiving Inspection Methods | QRESQMTB | NUMC | 4 | QRESIDENZ | ||||
| ARCHIV | Retention Period for Transaction Data in Quality Inspection | QRESARCH | NUMC | 4 | QRESIDENZ | ||||
| QLAGE | Expiry Period of Q-Level in Days | QRESQDQL | NUMC | 4 | QRESIDENZ | ||||
| QLAGECHARGE | Expiry Date of Quality Level (with Batch) in Days | QRESQDQLCH | NUMC | 4 | QRESIDENZ |
| Key field | Non-key field |
How do I retrieve data from SAP table TQREO using ABAP code
The following ABAP code Example will allow you to do a basic selection on TQREO to SELECT all data from the tableDATA: WA_TQREO TYPE TQREO.
SELECT SINGLE *
FROM TQREO
INTO CORRESPONDING FIELDS OF WA_TQREO
WHERE...
How to access SAP table TQREO
Within an ECC or HANA version of SAP you can also view further information about TQREO 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