SAP table TQ80 (Notification Types)

SAP table TQ80 has 2 primary key fields being MANDT,QMART.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

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

TQ80 foreign key relationships

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