SAP TQ80 Table in S/4 HANA - Notification Types
TQ80 is a standard SAP Table which is used to store Notification Types data and is available within SAP S/4 HANA systems and previous ECC R/3 systems. Below is the technical details and the field list relevant for an SAP S/4 HANA system, see here for details and fields available within the SAP R/3 version of the TQ80 table(ECC)
Delivery Class: C - Customising table, maintenance only by cust
Display/Maintenance via SM30: Display/Maintenance Allowed but with Restrictions
Enhancement category: Can be enhanced (character-type or numeric)
Dictionary Type: Transparent table
Database Table: TQ80
TQ80 table structure field list
Below is the full TQ80 field list that makes up the SAP database table structure, including key fields, description, data type and other technical details of each field
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP | SHLP Field |
| MANDT | Client | MANDT | CLNT | 3(0) | T000 | MANDT | ||||
| QMART | Notification Type | QMART | CHAR | 2(0) | QMART | QMR | ||||
| QMTYP | Notification Category | QMTYP | CHAR | 2(0) | TQ8T | QMTYP | ||||
| RBNR | Catalog Profile | RBNR | CHAR | 9(0) | T352B | RBNR | ||||
| HERKZ | Origin of Notification | HERKZ | CHAR | 2(0) | HERKZ | |||||
| BEZZT | PM Notification Reference Date/Time | BEZZT | CHAR | 1(0) | BEZZT | |||||
| QMNUK | Number Range for Notifications | QMNUK | CHAR | 2(0) | NUMKR | |||||
| AUART | Order Type | AUFART | CHAR | 4(0) | T003O | AUFART | AAT | |||
| HSCRTP | Subscreen Type - Header | HSCRTP | CHAR | 4(0) | TQBT | SCRTP | ||||
| OSCRTP | Subscreen Type - Object | OSCRTP | CHAR | 4(0) | TQBT | SCRTP | ||||
| PSCRTP | Subscreen Type - Partner | PSCRTP | CHAR | 4(0) | TQBT | SCRTP | ||||
| PARGR | Partner Determination Procedure | PARGR | CHAR | 4(0) | TVPG | PARGR | ||||
| STSMA | Status Profile | J_STSMA | CHAR | 8(0) | TJ20 | J_STSMA | ||||
| SMSTSMA | Status Profile | J_STSMA | CHAR | 8(0) | TJ20 | J_STSMA | ||||
| ARTPR | Priority Type | ARTPR | CHAR | 2(0) | T356A | ARTPR | ||||
| SDAUART | Sales Document Type | AUART | CHAR | 4(0) | TVAK | AUART | AUART | AAT | ||
| COAUART | Order Type | AUFART | CHAR | 4(0) | T003O | AUFART | AAT | |||
| PARVW_KUND | Partner Function for Customer | PARVW_KUND | CHAR | 2(0) | TPAR | PARVW | PARVW | PAR | ||
| PARVW_AP | Partner Function for Contact Person | PARVW_AP | CHAR | 2(0) | TPAR | PARVW | PARVW | PAR | ||
| PARVW_INT | Partner Function for Implementation (Department) | PARVW_INT | CHAR | 2(0) | TPAR | PARVW | PARVW | PAR | ||
| PARVW_LIEF | Partner Function for Supplier | PARVW_LIEF | CHAR | 2(0) | TPAR | PARVW | PARVW | PAR | ||
| PARVW_HER | Partner Function for Manufacturer | PARVW_HER | CHAR | 2(0) | TPAR | PARVW | PARVW | PAR | ||
| PARVW_VERA | Partner Function: Person/Department Responsible | PARVW_VERA | CHAR | 2(0) | TPAR | PARVW | PARVW | |||
| PARVW_AUTO | Partner Function for Author of Notification | PARVW_AUTO | CHAR | 2(0) | TPAR | PARVW | PARVW | |||
| PARVW_QMSM | Function of Person Responsible for Task | QMSM_PARVW | CHAR | 2(0) | TPAR | PARVW | PARVW | PAR | ||
| KLAKT | Indicator Classification Active | KLAKT | CHAR | 1(0) | X | |||||
| INFO_WIND | Parameter ID Object Info | I_INFOWIND | CHAR | 10(0) | TQ80O | I_INFOWIND | ||||
| SERWI | Service Profile | I_SERWI | CHAR | 10(0) | T355R | I_SERWI | ||||
| ESCAL | Response Profile | I_ESCAL | CHAR | 10(0) | T355E | I_ESCAL | ||||
| FEKAT | Catalog Type - Problems/Defects | FEKAT | CHAR | 1(0) | TQ15 | QKATART | ||||
| URKAT | Catalog Type - Causes | URKAT | CHAR | 1(0) | TQ15 | QKATART | ||||
| MAKAT | Catalog Type - Tasks | MAKAT | CHAR | 1(0) | TQ15 | QKATART | ||||
| MFKAT | Catalog Type - Activities | MFKAT | CHAR | 1(0) | TQ15 | QKATART | ||||
| OTKAT | Catalog Type - Object Parts | OTKAT | CHAR | 1(0) | TQ15 | QKATART | ||||
| SAKAT | Catalog Type - Coding | SAKAT | CHAR | 1(0) | TQ15 | QKATART | ||||
| STAFO | Update Group for statistics update | STAFO | CHAR | 6(0) | TMCB | ALPHA | STAFO | MCF | ||
| QMWAERS | Unit of Estimated Nonconformity Costs | QMWAERS | CUKY | 5(0) | TCURC | WAERS | ||||
| QMWERT | Valuation of Average Noncomformity Costs | QMWERT | CURR | 11(2) | WERT11 | |||||
| FBS_CREATE | Function Module 'Create Notification' | QFBSQM01 | CHAR | 30(0) | TFDIR | FUNCNAME | LIB | |||
| FBS_DYNNR | Number of Initial Screen | QFBSDYNNR | CHAR | 4(0) | DYNNR | |||||
| TDFORMAT | Format Column for Long Text Lines on Notification Screen | QTDFORMAT | CHAR | 2(0) | TDELEMSTYL | |||||
| KZEILE | Formatting Applies to Each Single Long Text Line | KZEILE | CHAR | 1(0) | X | |||||
| USERSCR1 | Subscreen Number for Customer Screen Area 'Notif. Header' | QMUSRSCR | CHAR | 4(0) | DYNNR | |||||
| USERSCR2 | Subscreen Number for Customer Screen Area Notification Item | QMUSRSCR1 | CHAR | 4(0) | DYNNR | |||||
| USERSCR3 | Subscreen Number for Customer Screen Area 'Cause' | QMUSRSCR2 | CHAR | 4(0) | DYNNR | |||||
| USERSCR4 | Screen Area Number for Customer Screen Area 'Task' | QMUSRSCR3 | CHAR | 4(0) | DYNNR | |||||
| USERSCR5 | Screen Area Number for Customer Screen Area 'Activity' | QMUSRSCR4 | CHAR | 4(0) | DYNNR | |||||
| QMLTXT01 | Log Line for Long Text Change | QMLTXT01 | CHAR | 1(0) | QKZ | |||||
| QMLTXT02 | No Changes to Existing Long Text | QMLTXT02 | CHAR | 1(0) | QKZ | |||||
| AUART2 | Order Type | AUFART | CHAR | 4(0) | T003O | AUFART | AAT | |||
| EARLY_NUM | Early Number Assignment | EARLY_NUM | CHAR | 1(0) | XFELD | |||||
| AUTOM_CONT | Automatic Contract Determination | AUTOM_CONT | CHAR | 1(0) | XFELD | |||||
| MATKZ | Search for Notifications for Material | QNMATKZ | CHAR | 1(0) | QKZ | |||||
| KUKZ | Search for Notifications for Customer | QNKUKZ | CHAR | 1(0) | QKZ | |||||
| MATKUKZ | Search for Notifications for Material/Customer | QNMATKUKZ | CHAR | 1(0) | QKZ | |||||
| LIKZ | Search for Vendor Notifications | QNLIKZ | CHAR | 1(0) | QKZ | |||||
| MATLIKZ | Search for Notifications for Material/Vendor | QNMATLIKZ | CHAR | 1(0) | QKZ | |||||
| MATCHKZ | Search for Notifications for Material and Batch | QNMATCHKZ | CHAR | 1(0) | QKZ | |||||
| MATCHKUKZ | Search for Notifications for Material/Batch and Customer | QNMATCHKUKZ | CHAR | 1(0) | QKZ | |||||
| MATCHLIKZ | Search for Notifications for Material/Batch and Vendor | QNMATCHLIKZ | CHAR | 1(0) | QKZ | |||||
| FEGRPKZ | Search for Notifications for 'Defect Type' Code Group | QNFEGRPKZ | CHAR | 1(0) | QKZ | |||||
| FECODKZ | Search for Notifications for 'Defect Type' Code | QNFECODKZ | CHAR | 1(0) | QKZ | |||||
| FOGRPKZ | Search for Notifications for 'Defect Location' Code Group | QNFOGRPKZ | CHAR | 1(0) | QKZ | |||||
| FOCODKZ | Search for Notifications for 'Defect Location' Code | QNFOCODKZ | CHAR | 1(0) | QKZ | |||||
| MOD | Display Mode for Notifications | QNMOD | CHAR | 1(0) | QKZMOD | |||||
| ICON1 | No Outstanding Notifications | QNICON1 | CHAR | 30(0) | SCRPICON_N | |||||
| ICON2 | Outstanding Notifications | QNICON2 | CHAR | 30(0) | SCRPICON_N | |||||
| VERS | Variants for Determining Existence of Notifications | QNVERS | CHAR | 1(0) | QKZVERS | |||||
| ZEITRAUM | Number of Days | QNZEIT | NUMC | 4(0) | NUMC4 | |||||
| TDOBJECT | Texts: application object | TDOBJECT | CHAR | 10(0) | TTXOB | TDOBJECT | ||||
| TDNAME | Name | TDOBNAME | CHAR | 70(0) | STXH | TDOBNAME | ||||
| TDID | Text ID | TDID | CHAR | 4(0) | TTXID | TDID | ||||
| CMCHECK_SM | Credit Limit Check for CS Processing | CMCHECK_SM | CHAR | 1(0) | CMCHECK_SM | |||||
| CMGRA | Credit group sales order | CMGRA | CHAR | 2(0) | T691D | CRMGR_CM | ||||
| PARVW_PAGE | Partner Function for Paging | PARVW_PAGE | CHAR | 2(0) | TPAR | PARVW | PARVW | |||
| CUA_FBS | Function Module that Sets CUA Menu | Q_CUA_FBS | CHAR | 30(0) | TFDIR | FUNCNAME | ||||
| ROLE_VERA | Standard Role for Partner Determination: Notif. Processor | QSTROLE | CHAR | 12(0) | CHAR12 | |||||
| PERMIT | Notification Type with Approval Procedure | QPERMIT | CHAR | 1(0) | XFELD | |||||
| PARVW_GEH | Partner Function for Approver (Person/Department) | PARVW_GEH | CHAR | 2(0) | TPAR | PARVW | PARVW | |||
| ROLE_GEH | Standard Role for Partner Determination: Approver | QSTROLE2 | CHAR | 12(0) | CHAR12 | |||||
| ROLE_QMSM | Standard Role for Partner Determination: Task Processor | QSTROLE3 | CHAR | 12(0) | CHAR12 | |||||
| PROCESS | QM Process | QMPROCESS | NUMC | 3(0) | TQ80_PR | NUMC3 | ||||
| REQMAINTAPP_USE | Notification Type for Request Maintenance App | EAM_NTF_CREATE_TYPE_ACTIVE | CHAR | 1(0) | XFELD |
Search for further information about these or an SAP related objects