1. Home
  2. Resources
  3. SAP Tables
  4. TQ80 - Notification Types

SAP Table TQ80

Notification Types

TQ80 (Notification Types) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link TQ80 to other SAP tables.

TQ80 table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
QMART Notification Type QMART CHAR 2 0
QMTYP Notification Category QMTYP TQ8T CHAR 2 0
RBNR Catalog Profile RBNR T352B CHAR 9 0
HERKZ Origin of Notification HERKZ CHAR 2 0
01 General maintenance notification
02 Malfunction report
03 Activity report
04 Problem notification
05 Activity report (service)
06 General notification (service)
Q1 Customer complaint
Q2 Complaint against vendor
Q3 Internal problem message
R3 SAP notification to SAP support line
C1 Internal claim
C2 External claim
G1 General notification
BEZZT PM Notification Reference Date/Time BEZZT CHAR 1 0
A Malfunction start
B Notification receipt
C Malfunction end
D Notification completion
QMNUK Number Range for Notifications QMNUK CHAR 2 0
AUART Order Type AUFART T003O CHAR 4 0
HSCRTP Subscreen Type - Header HSCRTP TQBT CHAR 4 0
OSCRTP Subscreen Type - Object OSCRTP TQBT CHAR 4 0
PSCRTP Subscreen Type - Partner PSCRTP TQBT CHAR 4 0
PARGR Partner Determination Procedure PARGR TVPG CHAR 4 0
STSMA Status Profile J_STSMA TJ20 CHAR 8 0
SMSTSMA Status Profile J_STSMA TJ20 CHAR 8 0
ARTPR Priority Type ARTPR T356A CHAR 2 0
SDAUART Sales Document Type AUART TVAK CHAR 4 0
COAUART Order Type AUFART T003O CHAR 4 0
PARVW_KUND Partner Function for Customer PARVW_KUND TPAR CHAR 2 0
PARVW_AP Partner Function for Contact Person PARVW_AP TPAR CHAR 2 0
PARVW_INT Partner Function for Implementation (Department) PARVW_INT TPAR CHAR 2 0
PARVW_LIEF Partner Function for Vendor PARVW_LIEF TPAR CHAR 2 0
PARVW_HER Partner Function for Manufacturer PARVW_HER TPAR CHAR 2 0
PARVW_VERA Partner Function: Person/Department Responsible PARVW_VERA TPAR CHAR 2 0
PARVW_AUTO Partner Function for Author of Notification PARVW_AUTO TPAR CHAR 2 0
PARVW_QMSM Function of Person Responsible for Task QMSM_PARVW TPAR CHAR 2 0
KLAKT Indicator Classification Active KLAKT CHAR 1 0
X Yes
NULL No
INFO_WIND Parameter ID Object Info I_INFOWIND TQ80O CHAR 10 0
SERWI Service Profile I_SERWI T355R CHAR 10 0
ESCAL Response Profile I_ESCAL T355E CHAR 10 0
FEKAT Catalog Type - Problems/Defects FEKAT TQ15 CHAR 1 0
URKAT Catalog Type - Causes URKAT TQ15 CHAR 1 0
MAKAT Catalog Type - Tasks MAKAT TQ15 CHAR 1 0
MFKAT Catalog Type - Activities MFKAT TQ15 CHAR 1 0
OTKAT Catalog Type - Object Parts OTKAT TQ15 CHAR 1 0
SAKAT Catalog Type - Coding SAKAT TQ15 CHAR 1 0
STAFO Update group for statistics update STAFO TMCB CHAR 6 0
QMWAERS Unit of Estimated Nonconformity Costs QMWAERS TCURC CUKY 5 0
QMWERT Valuation of Average Noncomformity Costs QMWERT CURR 11 2
FBS_CREATE Function Module "Create Notification" QFBSQM01 TFDIR CHAR 30 0
FBS_DYNNR Number of Initial Screen QFBSDYNNR CHAR 4 0
TDFORMAT Format Column for Long Text Lines on Notification Screen QTDFORMAT CHAR 2 0
KZEILE Formatting Applies to Each Single Long Text Line KZEILE CHAR 1 0
X Yes
NULL No
USERSCR1 Subscreen Number for Customer Screen Area "Notif. Header" QMUSRSCR CHAR 4 0
USERSCR2 Subscreen Number for Customer Screen Area Notification Item QMUSRSCR1 CHAR 4 0
USERSCR3 Subscreen Number for Customer Screen Area 'Cause' QMUSRSCR2 CHAR 4 0
USERSCR4 Screen Area Number for Customer Screen Area "Task" QMUSRSCR3 CHAR 4 0
USERSCR5 Screen Area Number for Customer Screen Area "Activity" QMUSRSCR4 CHAR 4 0
QMLTXT01 Log Line for Long Text Change QMLTXT01 CHAR 1 0
NULL Indicator is not set
X Indicator is set
QMLTXT02 No Changes to Existing Long Text QMLTXT02 CHAR 1 0
NULL Indicator is not set
X Indicator is set
AUART2 Order Type AUFART T003O CHAR 4 0
EARLY_NUM Early Number Assignment EARLY_NUM CHAR 1 0
X Yes
NULL No
AUTOM_CONT Automatic Contract Determination AUTOM_CONT CHAR 1 0
X Yes
NULL No
MATKZ Search for Notifications for Material QNMATKZ CHAR 1 0
NULL Indicator is not set
X Indicator is set
KUKZ Search for Notifications for Customer QNKUKZ CHAR 1 0
NULL Indicator is not set
X Indicator is set
MATKUKZ Search for Notifications for Material/Customer QNMATKUKZ CHAR 1 0
NULL Indicator is not set
X Indicator is set
LIKZ Search for Vendor Notifications QNLIKZ CHAR 1 0
NULL Indicator is not set
X Indicator is set
MATLIKZ Search for Notifications for Material/Vendor QNMATLIKZ CHAR 1 0
NULL Indicator is not set
X Indicator is set
MATCHKZ Search for Notifications for Material and Batch QNMATCHKZ CHAR 1 0
NULL Indicator is not set
X Indicator is set
MATCHKUKZ Search for Notifications for Material/Batch and Customer QNMATCHKUKZ CHAR 1 0
NULL Indicator is not set
X Indicator is set
MATCHLIKZ Search for Notifications for Material/Batch and Vendor QNMATCHLIKZ CHAR 1 0
NULL Indicator is not set
X Indicator is set
FEGRPKZ Search for Notifications for "Defect Type" Code Group QNFEGRPKZ CHAR 1 0
NULL Indicator is not set
X Indicator is set
FECODKZ Search for Notifications for "Defect Type" Code QNFECODKZ CHAR 1 0
NULL Indicator is not set
X Indicator is set
FOGRPKZ Search for Notifications for "Defect Location" Code Group QNFOGRPKZ CHAR 1 0
NULL Indicator is not set
X Indicator is set
FOCODKZ Search for Notifications for "Defect Location" Code QNFOCODKZ CHAR 1 0
NULL Indicator is not set
X Indicator is set
MOD Display Mode for Notifications QNMOD CHAR 1 0
1 Quick info 1: [Icon 1/Icon 2] notifications exist
2 Quick info 2: [Icon 2] outstanding ntoifications exist
3 Detail screen: Print the scores determined
ICON1 No Outstanding Notifications QNICON1 CHAR 30 0
ICON2 Outstanding Notifications QNICON2 CHAR 30 0
VERS Variants for Determining Existence of Notifications QNVERS CHAR 1 0
1 Version 1: Access using original documents
2 Version 2: Access using statistical database
ZEITRAUM Number of Days QNZEIT NUMC 4 0
TDOBJECT Texts: Application Object TDOBJECT TTXOB CHAR 10 0
TDNAME Name TDOBNAME STXH CHAR 70 0
TDID Text ID TDID TTXID CHAR 4 0
CMCHECK_SM Credit Limit Check for CS Processing CMCHECK_SM CHAR 1 0
NULL No check
1 Manual check using function key
2 Automatic check for release of document
3 Automatic check for input of sold-to-party
CMGRA Credit group sales order CMGRA T691D CHAR 2 0
PARVW_PAGE Partner Function for Paging PARVW_PAGE TPAR CHAR 2 0
CUA_FBS Function Module that Sets CUA Menu Q_CUA_FBS TFDIR CHAR 30 0
ROLE_VERA Standard Role for Partner Determination: Notif. Processor QSTROLE CHAR 12 0
PERMIT Notification Type with Approval Procedure QPERMIT CHAR 1 0
X Yes
NULL No
PARVW_GEH Partner Function for Approver (Person/Department) PARVW_GEH TPAR CHAR 2 0
ROLE_GEH Standard Role for Partner Determination: Approver QSTROLE2 CHAR 12 0
ROLE_QMSM Standard Role for Partner Determination: Task Processor QSTROLE3 CHAR 12 0
PROCESS QM Process QMPROCESS TQ80_PR NUMC 3 0

TQ80 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
TQ80 ARTPR TQ80 ARTPR T356A Priority type table ARTPR
TQ80 ARTPR TQ80 MANDT T356A Priority type table MANDT
TQ80 AUART TQ80 MANDT T003O Order Types CLIENT
TQ80 AUART TQ80 AUART T003O Order Types AUART
TQ80 AUART2 TQ80 MANDT T003O Order Types CLIENT
TQ80 AUART2 TQ80 AUART2 T003O Order Types AUART
TQ80 CMGRA TQ80 MANDT T691D Credit groups for document types MANDT
TQ80 CMGRA TQ80 CMGRA T691D Credit groups for document types CRMGR_CM
TQ80 COAUART TQ80 MANDT T003O Order Types CLIENT
TQ80 COAUART TQ80 COAUART T003O Order Types AUART
TQ80 CUA_FBS TQ80 CUA_FBS TFDIR Function Module FUNCNAME
TQ80 ESCAL TQ80 MANDT T355E Response time monitor MANDT
TQ80 ESCAL TQ80 ESCAL T355E Response time monitor ESCAL
TQ80 FBS_CREATE TQ80 FBS_CREATE TFDIR Function Module FUNCNAME
TQ80 FEKAT TQ80 MANDT TQ15 Inspection catalog type index MANDT
TQ80 FEKAT TQ80 FEKAT TQ15 Inspection catalog type index KATALOGART
TQ80 HSCRTP TQ80 HSCRTP TQBT Screen type table for subscreen SCREENTY
TQ80 INFO_WIND TQ80 MANDT TQ80O Object info parameters MANDT
TQ80 INFO_WIND TQ80 INFO_WIND TQ80O Object info parameters INFO_WIND
TQ80 MAKAT TQ80 MANDT TQ15 Inspection catalog type index MANDT
TQ80 MAKAT TQ80 MAKAT TQ15 Inspection catalog type index KATALOGART
TQ80 MANDT TQ80 MANDT T000 Clients MANDT
TQ80 MFKAT TQ80 MANDT TQ15 Inspection catalog type index MANDT
TQ80 MFKAT TQ80 MFKAT TQ15 Inspection catalog type index KATALOGART
TQ80 OSCRTP TQ80 OSCRTP TQBT Screen type table for subscreen SCREENTY
TQ80 OTKAT TQ80 MANDT TQ15 Inspection catalog type index MANDT
TQ80 OTKAT TQ80 OTKAT TQ15 Inspection catalog type index KATALOGART
TQ80 PARGR TQ80 PARGR TVPG Partner Function Groups PARGR
TQ80 PARGR TQ80 MANDT TVPG Partner Function Groups MANDT
TQ80 PARVW_AP TQ80 MANDT TPAR Business Partner: Functions MANDT
TQ80 PARVW_AP TQ80 PARVW_AP TPAR Business Partner: Functions PARVW
TQ80 PARVW_AUTO TQ80 PARVW_AUTO TPAR Business Partner: Functions PARVW
TQ80 PARVW_AUTO TQ80 MANDT TPAR Business Partner: Functions MANDT
TQ80 PARVW_GEH TQ80 MANDT TPAR Business Partner: Functions MANDT
TQ80 PARVW_GEH TQ80 PARVW_GEH TPAR Business Partner: Functions PARVW
TQ80 PARVW_HER TQ80 MANDT TPAR Business Partner: Functions MANDT
TQ80 PARVW_HER TQ80 PARVW_HER TPAR Business Partner: Functions PARVW
TQ80 PARVW_INT TQ80 MANDT TPAR Business Partner: Functions MANDT
TQ80 PARVW_INT TQ80 PARVW_INT TPAR Business Partner: Functions PARVW
TQ80 PARVW_KUND TQ80 MANDT TPAR Business Partner: Functions MANDT
TQ80 PARVW_KUND TQ80 PARVW_KUND TPAR Business Partner: Functions PARVW
TQ80 PARVW_LIEF TQ80 MANDT TPAR Business Partner: Functions MANDT
TQ80 PARVW_LIEF TQ80 PARVW_LIEF TPAR Business Partner: Functions PARVW
TQ80 PARVW_PAGE TQ80 MANDT TPAR Business Partner: Functions MANDT
TQ80 PARVW_PAGE TQ80 PARVW_PAGE TPAR Business Partner: Functions PARVW
TQ80 PARVW_QMSM TQ80 MANDT TPAR Business Partner: Functions MANDT
TQ80 PARVW_QMSM TQ80 PARVW_QMSM TPAR Business Partner: Functions PARVW
TQ80 PARVW_VERA TQ80 PARVW_VERA TPAR Business Partner: Functions PARVW
TQ80 PARVW_VERA TQ80 MANDT TPAR Business Partner: Functions MANDT
TQ80 PROCESS TQ80 PROCESS TQ80_PR QM Process PROCESS
TQ80 PSCRTP TQ80 PSCRTP TQBT Screen type table for subscreen SCREENTY
TQ80 QMTYP TQ80 MANDT TQ8T Notification category MANDT
TQ80 QMTYP TQ80 QMTYP TQ8T Notification category QMTYP
TQ80 QMWAERS TQ80 MANDT TCURC Currency Codes MANDT
TQ80 QMWAERS TQ80 QMWAERS TCURC Currency Codes WAERS
TQ80 RBNR TQ80 MANDT T352B Technical report MANDT
TQ80 RBNR TQ80 RBNR T352B Technical report RBNR
TQ80 SAKAT TQ80 MANDT TQ15 Inspection catalog type index MANDT
TQ80 SAKAT TQ80 SAKAT TQ15 Inspection catalog type index KATALOGART
TQ80 SDAUART TQ80 MANDT TVAK Sales Document Types MANDT
TQ80 SDAUART TQ80 SDAUART TVAK Sales Document Types AUART
TQ80 SERWI TQ80 MANDT T355R Service window MANDT
TQ80 SERWI TQ80 SERWI T355R Service window SERWI
TQ80 SMSTSMA TQ80 MANDT TJ20 Status profiles MANDT
TQ80 SMSTSMA TQ80 SMSTSMA TJ20 Status profiles STSMA
TQ80 STAFO TQ80 MANDT TMCB Update groups MANDT
TQ80 STAFO TQ80 STAFO TMCB Update groups STAFO
TQ80 STSMA TQ80 MANDT TJ20 Status profiles MANDT
TQ80 STSMA TQ80 STSMA TJ20 Status profiles STSMA
TQ80 TDID TQ80 TDOBJECT TTXID Valid text IDs TDOBJECT
TQ80 TDID TQ80 TDID TTXID Valid text IDs TDID
TQ80 TDNAME TQ80 TDID STXH STXD SAPscript text file header TDID
TQ80 TDNAME * STXH STXD SAPscript text file header TDSPRAS
TQ80 TDNAME TQ80 MANDT STXH STXD SAPscript text file header MANDT
TQ80 TDNAME TQ80 TDOBJECT STXH STXD SAPscript text file header TDOBJECT
TQ80 TDNAME TQ80 TDNAME STXH STXD SAPscript text file header TDNAME
TQ80 TDOBJECT TQ80 TDOBJECT TTXOB Valid text objects TDOBJECT
TQ80 URKAT TQ80 MANDT TQ15 Inspection catalog type index MANDT
TQ80 URKAT TQ80 URKAT TQ15 Inspection catalog type index KATALOGART