TQ80 SAP (Notification Types) Table details

Dictionary Type: Table
Description: Notification Types




ABAP Code to SELECT data from TQ80
Related tables to TQ80
Access table TQ80




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 cust
Display/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
MANDTClient MANDTCLNT3T000MANDT
QMARTNotification Type QMARTCHAR2QMARTQMR
QMTYPNotification Category QMTYPCHAR2TQ8TQMTYP
RBNRCatalog Profile RBNRCHAR9T352BRBNR
HERKZOrigin of Notification HERKZCHAR2HERKZ
BEZZTPM Notification Reference Date/Time BEZZTCHAR1BEZZT
QMNUKNumber Range for Notifications QMNUKCHAR2NUMKR
AUARTOrder Type AUFARTCHAR4T003OAUFARTAAT
HSCRTPSubscreen Type - Header HSCRTPCHAR4TQBTSCRTP
OSCRTPSubscreen Type - Object OSCRTPCHAR4TQBTSCRTP
PSCRTPSubscreen Type - Partner PSCRTPCHAR4TQBTSCRTP
PARGRPartner Determination Procedure PARGRCHAR4TVPGPARGR
STSMAStatus Profile J_STSMACHAR8TJ20J_STSMA
SMSTSMAStatus Profile J_STSMACHAR8TJ20J_STSMA
ARTPRPriority Type ARTPRCHAR2T356AARTPR
SDAUARTSales Document Type AUARTCHAR4TVAKAUARTAUARTAAT
COAUARTOrder Type AUFARTCHAR4T003OAUFARTAAT
PARVW_KUNDPartner Function for Customer PARVW_KUNDCHAR2TPARPARVWPARVWPAR
PARVW_APPartner Function for Contact Person PARVW_APCHAR2TPARPARVWPARVWPAR
PARVW_INTPartner Function for Implementation (Department) PARVW_INTCHAR2TPARPARVWPARVWPAR
PARVW_LIEFPartner Function for Vendor PARVW_LIEFCHAR2TPARPARVWPARVWPAR
PARVW_HERPartner Function for Manufacturer PARVW_HERCHAR2TPARPARVWPARVWPAR
PARVW_VERAPartner Function: Person/Department Responsible PARVW_VERACHAR2TPARPARVWPARVW
PARVW_AUTOPartner Function for Author of Notification PARVW_AUTOCHAR2TPARPARVWPARVW
PARVW_QMSMFunction of Person Responsible for Task QMSM_PARVWCHAR2TPARPARVWPARVWPAR
KLAKTIndicator Classification Active KLAKTCHAR1X
INFO_WINDParameter ID Object Info I_INFOWINDCHAR10TQ80OI_INFOWIND
SERWIService Profile I_SERWICHAR10T355RI_SERWI
ESCALResponse Profile I_ESCALCHAR10T355EI_ESCAL
FEKATCatalog Type - Problems/Defects FEKATCHAR1TQ15QKATART
URKATCatalog Type - Causes URKATCHAR1TQ15QKATART
MAKATCatalog Type - Tasks MAKATCHAR1TQ15QKATART
MFKATCatalog Type - Activities MFKATCHAR1TQ15QKATART
OTKATCatalog Type - Object Parts OTKATCHAR1TQ15QKATART
SAKATCatalog Type - Coding SAKATCHAR1TQ15QKATART
STAFOUpdate group for statistics update STAFOCHAR6TMCBALPHASTAFOMCF
QMWAERSUnit of Estimated Nonconformity Costs QMWAERSCUKY5TCURCWAERS
QMWERTValuation of Average Noncomformity Costs QMWERTCURR11(2) WERT11
FBS_CREATEFunction Module 'Create Notification' QFBSQM01CHAR30TFDIRFUNCNAMELIB
FBS_DYNNRNumber of Initial Screen QFBSDYNNRCHAR4DYNNR
TDFORMATFormat Column for Long Text Lines on Notification Screen QTDFORMATCHAR2TDELEMSTYL
KZEILEFormatting Applies to Each Single Long Text Line KZEILECHAR1X
USERSCR1Subscreen Number for Customer Screen Area 'Notif. Header' QMUSRSCRCHAR4DYNNR
USERSCR2Subscreen Number for Customer Screen Area Notification Item QMUSRSCR1CHAR4DYNNR
USERSCR3Subscreen Number for Customer Screen Area 'Cause' QMUSRSCR2CHAR4DYNNR
USERSCR4Screen Area Number for Customer Screen Area 'Task' QMUSRSCR3CHAR4DYNNR
USERSCR5Screen Area Number for Customer Screen Area 'Activity' QMUSRSCR4CHAR4DYNNR
QMLTXT01Log Line for Long Text Change QMLTXT01CHAR1QKZ
QMLTXT02No Changes to Existing Long Text QMLTXT02CHAR1QKZ
AUART2Order Type AUFARTCHAR4T003OAUFARTAAT
EARLY_NUMEarly Number Assignment EARLY_NUMCHAR1XFELD
AUTOM_CONTAutomatic Contract Determination AUTOM_CONTCHAR1XFELD
MATKZSearch for Notifications for Material QNMATKZCHAR1QKZ
KUKZSearch for Notifications for Customer QNKUKZCHAR1QKZ
MATKUKZSearch for Notifications for Material/Customer QNMATKUKZCHAR1QKZ
LIKZSearch for Vendor Notifications QNLIKZCHAR1QKZ
MATLIKZSearch for Notifications for Material/Vendor QNMATLIKZCHAR1QKZ
MATCHKZSearch for Notifications for Material and Batch QNMATCHKZCHAR1QKZ
MATCHKUKZSearch for Notifications for Material/Batch and Customer QNMATCHKUKZCHAR1QKZ
MATCHLIKZSearch for Notifications for Material/Batch and Vendor QNMATCHLIKZCHAR1QKZ
FEGRPKZSearch for Notifications for 'Defect Type' Code Group QNFEGRPKZCHAR1QKZ
FECODKZSearch for Notifications for 'Defect Type' Code QNFECODKZCHAR1QKZ
FOGRPKZSearch for Notifications for 'Defect Location' Code Group QNFOGRPKZCHAR1QKZ
FOCODKZSearch for Notifications for 'Defect Location' Code QNFOCODKZCHAR1QKZ
MODDisplay Mode for Notifications QNMODCHAR1QKZMOD
ICON1No Outstanding Notifications QNICON1CHAR30SCRPICON_N
ICON2Outstanding Notifications QNICON2CHAR30SCRPICON_N
VERSVariants for Determining Existence of Notifications QNVERSCHAR1QKZVERS
ZEITRAUMNumber of Days QNZEITNUMC4NUMC4
TDOBJECTTexts: Application Object TDOBJECTCHAR10TTXOBTDOBJECT
TDNAMEName TDOBNAMECHAR70STXHTDOBNAME
TDIDText ID TDIDCHAR4TTXIDTDID
CMCHECK_SMCredit Limit Check for CS Processing CMCHECK_SMCHAR1CMCHECK_SM
CMGRACredit group sales order CMGRACHAR2T691DCRMGR_CM
PARVW_PAGEPartner Function for Paging PARVW_PAGECHAR2TPARPARVWPARVW
CUA_FBSFunction Module that Sets CUA Menu Q_CUA_FBSCHAR30TFDIRFUNCNAME
ROLE_VERAStandard Role for Partner Determination: Notif. Processor QSTROLECHAR12CHAR12
PERMITNotification Type with Approval Procedure QPERMITCHAR1XFELD
PARVW_GEHPartner Function for Approver (Person/Department) PARVW_GEHCHAR2TPARPARVWPARVW
ROLE_GEHStandard Role for Partner Determination: Approver QSTROLE2CHAR12CHAR12
ROLE_QMSMStandard Role for Partner Determination: Task Processor QSTROLE3CHAR12CHAR12
PROCESSQM Process QMPROCESSNUMC3TQ80_PRNUMC3

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 table
DATA: 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 as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!