SAP Table
TQ80 Notification Types
SAP table TQ80 has 2 primary key fields being MANDT,QMART.
If you are only analysing data from a single SAP instance you may omit field MANDT in your relationships as it will be the same across the entire dataset. On the other hand, if you are combining data from multiple SAP instances you need to take MANDT into account.
/ Fields
TQ80 columns.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| KeyMANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |||||||||||||||||||||||||||
| KeyQMART | 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 | ||||||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||||||
| BEZZT | PM Notification Reference Date/Time | CHAR | 1 | 0 | BEZZT | ||||||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||||||
| 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 | ||||||||||||||||||||||||||||
/ Relationships
TQ80 foreign keys.
| Table | Field | Check Table | Description | Check Field |
|---|---|---|---|---|
| TQ80 | ARTPR | T356A | Priority type table | MANDT |
| TQ80 | ARTPR | T356A | Priority type table | ARTPR |
| TQ80 | AUART | T003O | Order Types | AUART |
| TQ80 | AUART2 | T003O | Order Types | AUART |
| TQ80 | CMGRA | T691D | Credit groups for document types | MANDT |
| TQ80 | COAUART | T003O | Order Types | AUART |
| TQ80 | CUA_FBS | TFDIR | Function Module | FUNCNAME |
| TQ80 | ESCAL | T355E | Response time monitor | MANDT |
| TQ80 | ESCAL | T355E | Response time monitor | ESCAL |
| TQ80 | FBS_CREATE | TFDIR | Function Module | FUNCNAME |
| TQ80 | FEKAT | TQ15 | Inspection catalog type index | KATALOGART |
| TQ80 | INFO_WIND | TQ80O | Object info parameters | MANDT |
| TQ80 | INFO_WIND | TQ80O | Object info parameters | INFO_WIND |
| TQ80 | MAKAT | TQ15 | Inspection catalog type index | KATALOGART |
| TQ80 | MFKAT | TQ15 | Inspection catalog type index | KATALOGART |
| TQ80 | OTKAT | TQ15 | Inspection catalog type index | KATALOGART |
| TQ80 | PARGR | TVPG | Partner Function Groups | PARGR |
| TQ80 | PARVW_AP | TPAR | Business Partner: Functions | PARVW |
| TQ80 | PARVW_AUTO | TPAR | Business Partner: Functions | PARVW |
| TQ80 | PARVW_GEH | TPAR | Business Partner: Functions | PARVW |
| TQ80 | PARVW_HER | TPAR | Business Partner: Functions | PARVW |
| TQ80 | PARVW_INT | TPAR | Business Partner: Functions | PARVW |
| TQ80 | PARVW_KUND | TPAR | Business Partner: Functions | PARVW |
| TQ80 | PARVW_LIEF | TPAR | Business Partner: Functions | PARVW |
| TQ80 | PARVW_PAGE | TPAR | Business Partner: Functions | PARVW |
| TQ80 | PARVW_QMSM | TPAR | Business Partner: Functions | PARVW |
| TQ80 | PARVW_VERA | TPAR | Business Partner: Functions | PARVW |
| TQ80 | PROCESS | TQ80_PR | QM Process | PROCESS |
| TQ80 | QMTYP | TQ8T | Notification category | MANDT |
| TQ80 | QMTYP | TQ8T | Notification category | QMTYP |
| TQ80 | QMWAERS | TCURC | Currency Codes | MANDT |
| TQ80 | QMWAERS | TCURC | Currency Codes | WAERS |
| TQ80 | RBNR | T352B | Technical report | MANDT |
| TQ80 | SAKAT | TQ15 | Inspection catalog type index | KATALOGART |
| TQ80 | SDAUART | TVAK | Sales Document Types | MANDT |
| TQ80 | SDAUART | TVAK | Sales Document Types | AUART |
| TQ80 | SERWI | T355R | Service window | MANDT |
| TQ80 | SERWI | T355R | Service window | SERWI |
| TQ80 | SMSTSMA | TJ20 | Status profiles | MANDT |
| TQ80 | SMSTSMA | TJ20 | Status profiles | STSMA |
| TQ80 | STAFO | TMCB | Update groups | MANDT |
| TQ80 | STAFO | TMCB | Update groups | STAFO |
| TQ80 | STSMA | TJ20 | Status profiles | MANDT |
| TQ80 | STSMA | TJ20 | Status profiles | STSMA |
| TQ80 | TDNAME | STXH | STXD SAPscript text file header | MANDT |
| TQ80 | TDNAME | STXH | STXD SAPscript text file header | TDNAME |
| TQ80 | TDNAME | STXH | STXD SAPscript text file header | TDSPRAS |
| TQ80 | TDOBJECT | TTXOB | Valid text objects | TDOBJECT |
| TQ80 | URKAT | TQ15 | Inspection catalog type index | KATALOGART |