TQ80 SAP (Notification Types) Table details
Dictionary Type: Table
Description: Notification Types
Description: Notification Types
Table field list including key, data, relationships and ABAP select examples
TQ80 is a standard SAP Table which is used to store Notification Types data and is available within R/3 SAP systems depending on the version and release level.
The TQ80 table consists of various fields, each holding specific information or linking keys about Notification Types data available in SAP. These include QMART (Notification Type), QMTYP (Notification Category), RBNR (Catalog Profile), HERKZ (Origin of Notification).. 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: Can be enhanced (character-type or numeric)
Text table = TQ80_T
SAP TQ80 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 | |||
QMART | Notification Type | QMART | CHAR | 2 | QMART | QMR | |||
QMTYP | Notification Category | QMTYP | CHAR | 2 | TQ8T | QMTYP | |||
RBNR | Catalog Profile | RBNR | CHAR | 9 | T352B | RBNR | |||
HERKZ | Origin of Notification | HERKZ | CHAR | 2 | HERKZ | ||||
BEZZT | PM Notification Reference Date/Time | BEZZT | CHAR | 1 | BEZZT | ||||
QMNUK | Number Range for Notifications | QMNUK | CHAR | 2 | NUMKR | ||||
AUART | Order Type | AUFART | CHAR | 4 | T003O | AUFART | AAT | ||
HSCRTP | Subscreen Type - Header | HSCRTP | CHAR | 4 | TQBT | SCRTP | |||
OSCRTP | Subscreen Type - Object | OSCRTP | CHAR | 4 | TQBT | SCRTP | |||
PSCRTP | Subscreen Type - Partner | PSCRTP | CHAR | 4 | TQBT | SCRTP | |||
PARGR | Partner Determination Procedure | PARGR | CHAR | 4 | TVPG | PARGR | |||
STSMA | Status Profile | J_STSMA | CHAR | 8 | TJ20 | J_STSMA | |||
SMSTSMA | Status Profile | J_STSMA | CHAR | 8 | TJ20 | J_STSMA | |||
ARTPR | Priority Type | ARTPR | CHAR | 2 | T356A | ARTPR | |||
SDAUART | Sales Document Type | AUART | CHAR | 4 | TVAK | AUART | AUART | AAT | |
COAUART | Order Type | AUFART | CHAR | 4 | T003O | AUFART | AAT | ||
PARVW_KUND | Partner Function for Customer | PARVW_KUND | CHAR | 2 | TPAR | PARVW | PARVW | PAR | |
PARVW_AP | Partner Function for Contact Person | PARVW_AP | CHAR | 2 | TPAR | PARVW | PARVW | PAR | |
PARVW_INT | Partner Function for Implementation (Department) | PARVW_INT | CHAR | 2 | TPAR | PARVW | PARVW | PAR | |
PARVW_LIEF | Partner Function for Vendor | PARVW_LIEF | CHAR | 2 | TPAR | PARVW | PARVW | PAR | |
PARVW_HER | Partner Function for Manufacturer | PARVW_HER | CHAR | 2 | TPAR | PARVW | PARVW | PAR | |
PARVW_VERA | Partner Function: Person/Department Responsible | PARVW_VERA | CHAR | 2 | TPAR | PARVW | PARVW | ||
PARVW_AUTO | Partner Function for Author of Notification | PARVW_AUTO | CHAR | 2 | TPAR | PARVW | PARVW | ||
PARVW_QMSM | Function of Person Responsible for Task | QMSM_PARVW | CHAR | 2 | TPAR | PARVW | PARVW | PAR | |
KLAKT | Indicator Classification Active | KLAKT | CHAR | 1 | X | ||||
INFO_WIND | Parameter ID Object Info | I_INFOWIND | CHAR | 10 | TQ80O | I_INFOWIND | |||
SERWI | Service Profile | I_SERWI | CHAR | 10 | T355R | I_SERWI | |||
ESCAL | Response Profile | I_ESCAL | CHAR | 10 | T355E | I_ESCAL | |||
FEKAT | Catalog Type - Problems/Defects | FEKAT | CHAR | 1 | TQ15 | QKATART | |||
URKAT | Catalog Type - Causes | URKAT | CHAR | 1 | TQ15 | QKATART | |||
MAKAT | Catalog Type - Tasks | MAKAT | CHAR | 1 | TQ15 | QKATART | |||
MFKAT | Catalog Type - Activities | MFKAT | CHAR | 1 | TQ15 | QKATART | |||
OTKAT | Catalog Type - Object Parts | OTKAT | CHAR | 1 | TQ15 | QKATART | |||
SAKAT | Catalog Type - Coding | SAKAT | CHAR | 1 | TQ15 | QKATART | |||
STAFO | Update group for statistics update | STAFO | CHAR | 6 | TMCB | ALPHA | STAFO | MCF | |
QMWAERS | Unit of Estimated Nonconformity Costs | QMWAERS | CUKY | 5 | TCURC | WAERS | |||
QMWERT | Valuation of Average Noncomformity Costs | QMWERT | CURR | 11(2) | WERT11 | ||||
FBS_CREATE | Function Module 'Create Notification' | QFBSQM01 | CHAR | 30 | TFDIR | FUNCNAME | LIB | ||
FBS_DYNNR | Number of Initial Screen | QFBSDYNNR | CHAR | 4 | DYNNR | ||||
TDFORMAT | Format Column for Long Text Lines on Notification Screen | QTDFORMAT | CHAR | 2 | TDELEMSTYL | ||||
KZEILE | Formatting Applies to Each Single Long Text Line | KZEILE | CHAR | 1 | X | ||||
USERSCR1 | Subscreen Number for Customer Screen Area 'Notif. Header' | QMUSRSCR | CHAR | 4 | DYNNR | ||||
USERSCR2 | Subscreen Number for Customer Screen Area Notification Item | QMUSRSCR1 | CHAR | 4 | DYNNR | ||||
USERSCR3 | Subscreen Number for Customer Screen Area 'Cause' | QMUSRSCR2 | CHAR | 4 | DYNNR | ||||
USERSCR4 | Screen Area Number for Customer Screen Area 'Task' | QMUSRSCR3 | CHAR | 4 | DYNNR | ||||
USERSCR5 | Screen Area Number for Customer Screen Area 'Activity' | QMUSRSCR4 | CHAR | 4 | DYNNR | ||||
QMLTXT01 | Log Line for Long Text Change | QMLTXT01 | CHAR | 1 | QKZ | ||||
QMLTXT02 | No Changes to Existing Long Text | QMLTXT02 | CHAR | 1 | QKZ | ||||
AUART2 | Order Type | AUFART | CHAR | 4 | T003O | AUFART | AAT | ||
EARLY_NUM | Early Number Assignment | EARLY_NUM | CHAR | 1 | XFELD | ||||
AUTOM_CONT | Automatic Contract Determination | AUTOM_CONT | CHAR | 1 | XFELD | ||||
MATKZ | Search for Notifications for Material | QNMATKZ | CHAR | 1 | QKZ | ||||
KUKZ | Search for Notifications for Customer | QNKUKZ | CHAR | 1 | QKZ | ||||
MATKUKZ | Search for Notifications for Material/Customer | QNMATKUKZ | CHAR | 1 | QKZ | ||||
LIKZ | Search for Vendor Notifications | QNLIKZ | CHAR | 1 | QKZ | ||||
MATLIKZ | Search for Notifications for Material/Vendor | QNMATLIKZ | CHAR | 1 | QKZ | ||||
MATCHKZ | Search for Notifications for Material and Batch | QNMATCHKZ | CHAR | 1 | QKZ | ||||
MATCHKUKZ | Search for Notifications for Material/Batch and Customer | QNMATCHKUKZ | CHAR | 1 | QKZ | ||||
MATCHLIKZ | Search for Notifications for Material/Batch and Vendor | QNMATCHLIKZ | CHAR | 1 | QKZ | ||||
FEGRPKZ | Search for Notifications for 'Defect Type' Code Group | QNFEGRPKZ | CHAR | 1 | QKZ | ||||
FECODKZ | Search for Notifications for 'Defect Type' Code | QNFECODKZ | CHAR | 1 | QKZ | ||||
FOGRPKZ | Search for Notifications for 'Defect Location' Code Group | QNFOGRPKZ | CHAR | 1 | QKZ | ||||
FOCODKZ | Search for Notifications for 'Defect Location' Code | QNFOCODKZ | CHAR | 1 | QKZ | ||||
MOD | Display Mode for Notifications | QNMOD | CHAR | 1 | QKZMOD | ||||
ICON1 | No Outstanding Notifications | QNICON1 | CHAR | 30 | SCRPICON_N | ||||
ICON2 | Outstanding Notifications | QNICON2 | CHAR | 30 | SCRPICON_N | ||||
VERS | Variants for Determining Existence of Notifications | QNVERS | CHAR | 1 | QKZVERS | ||||
ZEITRAUM | Number of Days | QNZEIT | NUMC | 4 | NUMC4 | ||||
TDOBJECT | Texts: Application Object | TDOBJECT | CHAR | 10 | TTXOB | TDOBJECT | |||
TDNAME | Name | TDOBNAME | CHAR | 70 | STXH | TDOBNAME | |||
TDID | Text ID | TDID | CHAR | 4 | TTXID | TDID | |||
CMCHECK_SM | Credit Limit Check for CS Processing | CMCHECK_SM | CHAR | 1 | CMCHECK_SM | ||||
CMGRA | Credit group sales order | CMGRA | CHAR | 2 | T691D | CRMGR_CM | |||
PARVW_PAGE | Partner Function for Paging | PARVW_PAGE | CHAR | 2 | TPAR | PARVW | PARVW | ||
CUA_FBS | Function Module that Sets CUA Menu | Q_CUA_FBS | CHAR | 30 | TFDIR | FUNCNAME | |||
ROLE_VERA | Standard Role for Partner Determination: Notif. Processor | QSTROLE | CHAR | 12 | CHAR12 | ||||
PERMIT | Notification Type with Approval Procedure | QPERMIT | CHAR | 1 | XFELD | ||||
PARVW_GEH | Partner Function for Approver (Person/Department) | PARVW_GEH | CHAR | 2 | TPAR | PARVW | PARVW | ||
ROLE_GEH | Standard Role for Partner Determination: Approver | QSTROLE2 | CHAR | 12 | CHAR12 | ||||
ROLE_QMSM | Standard Role for Partner Determination: Task Processor | QSTROLE3 | CHAR | 12 | CHAR12 | ||||
PROCESS | QM Process | QMPROCESS | NUMC | 3 | TQ80_PR | NUMC3 |
Key field | Non-key field |
How do I retrieve data from SAP table TQ80 using ABAP code
The following ABAP code Example will allow you to do a basic selection on TQ80 to SELECT all data from the tableDATA: WA_TQ80 TYPE TQ80.
SELECT SINGLE *
FROM TQ80
INTO CORRESPONDING FIELDS OF WA_TQ80
WHERE...
How to access SAP table TQ80
Within an ECC or HANA version of SAP you can also view further information about TQ80 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