SAP table reference

TQ80

Notification Types

Explore another table

Enter a table code or keyword to continue exploring.

Explore the structure, fields and relationships of SAP table TQ80.

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

When analysing data from one SAP instance, MANDT is normally identical across the dataset and may be omitted from relationships. When combining multiple instances, include MANDT.

/ Fields

TQ80 fields.

83 fields
FieldDescriptionData typeLengthDecimalsCheck tableData element
Key MANDT ClientCLNT30 T000 MANDT
Key QMART Notification TypeCHAR20 QMART
QMTYP Notification CategoryCHAR20 TQ8T QMTYP
RBNR Catalog ProfileCHAR90 T352B RBNR
HERKZ Origin of NotificationCHAR20 HERKZ
BEZZT PM Notification Reference Date/TimeCHAR10 BEZZT
QMNUK Number Range for NotificationsCHAR20 QMNUK
AUART Order TypeCHAR40 T003O AUFART
HSCRTP Subscreen Type - HeaderCHAR40 TQBT HSCRTP
OSCRTP Subscreen Type - ObjectCHAR40 TQBT OSCRTP
PSCRTP Subscreen Type - PartnerCHAR40 TQBT PSCRTP
PARGR Partner Determination ProcedureCHAR40 TVPG PARGR
STSMA Status ProfileCHAR80 TJ20 J_STSMA
SMSTSMA Status ProfileCHAR80 TJ20 J_STSMA
ARTPR Priority TypeCHAR20 T356A ARTPR
SDAUART Sales Document TypeCHAR40 TVAK AUART
COAUART Order TypeCHAR40 T003O AUFART
PARVW_KUND Partner Function for CustomerCHAR20 TPAR PARVW_KUND
PARVW_AP Partner Function for Contact PersonCHAR20 TPAR PARVW_AP
PARVW_INT Partner Function for Implementation (Department)CHAR20 TPAR PARVW_INT
PARVW_LIEF Partner Function for SupplierCHAR20 TPAR PARVW_LIEF
PARVW_HER Partner Function for ManufacturerCHAR20 TPAR PARVW_HER
PARVW_VERA Partner Function: Person/Department ResponsibleCHAR20 TPAR PARVW_VERA
PARVW_AUTO Partner Function for Author of NotificationCHAR20 TPAR PARVW_AUTO
PARVW_QMSM Function of Person Responsible for TaskCHAR20 TPAR QMSM_PARVW
KLAKT Indicator Classification ActiveCHAR10 KLAKT
INFO_WIND Parameter ID Object InfoCHAR100 TQ80O I_INFOWIND
SERWI Service ProfileCHAR100 T355R I_SERWI
ESCAL Response ProfileCHAR100 T355E I_ESCAL
FEKAT Catalog Type - Problems/DefectsCHAR10 TQ15 FEKAT
URKAT Catalog Type - CausesCHAR10 TQ15 URKAT
MAKAT Catalog Type - TasksCHAR10 TQ15 MAKAT
MFKAT Catalog Type - ActivitiesCHAR10 TQ15 MFKAT
OTKAT Catalog Type - Object PartsCHAR10 TQ15 OTKAT
SAKAT Catalog Type - CodingCHAR10 TQ15 SAKAT
STAFO Update Group for statistics updateCHAR60 TMCB STAFO
QMWAERS Unit of Estimated Nonconformity CostsCUKY50 TCURC QMWAERS
QMWERT Valuation of Average Noncomformity CostsCURR112 QMWERT
FBS_CREATE Function Module "Create Notification"CHAR300 TFDIR QFBSQM01
FBS_DYNNR Number of Initial ScreenCHAR40 QFBSDYNNR
TDFORMAT Format Column for Long Text Lines on Notification ScreenCHAR20 QTDFORMAT
KZEILE Formatting Applies to Each Single Long Text LineCHAR10 KZEILE
USERSCR1 Subscreen Number for Customer Screen Area "Notif. Header"CHAR40 QMUSRSCR
USERSCR2 Subscreen Number for Customer Screen Area Notification ItemCHAR40 QMUSRSCR1
USERSCR3 Subscreen Number for Customer Screen Area 'Cause'CHAR40 QMUSRSCR2
USERSCR4 Screen Area Number for Customer Screen Area 'Task'CHAR40 QMUSRSCR3
USERSCR5 Screen Area Number for Customer Screen Area 'Activity'CHAR40 QMUSRSCR4
QMLTXT01 Log Line for Long Text ChangeCHAR10 QMLTXT01
QMLTXT02 No Changes to Existing Long TextCHAR10 QMLTXT02
AUART2 Order TypeCHAR40 T003O AUFART
EARLY_NUM Early Number AssignmentCHAR10 EARLY_NUM
AUTOM_CONT Automatic Contract DeterminationCHAR10 AUTOM_CONT
MATKZ Search for Notifications for MaterialCHAR10 QNMATKZ
KUKZ Search for Notifications for CustomerCHAR10 QNKUKZ
MATKUKZ Search for Notifications for Material/CustomerCHAR10 QNMATKUKZ
LIKZ Search for Notifications for SupplierCHAR10 QNLIKZ
MATLIKZ Search for Notifications for Material/SupplierCHAR10 QNMATLIKZ
MATCHKZ Search for Notifications for Material and BatchCHAR10 QNMATCHKZ
MATCHKUKZ Search for Notifications for Material/Batch and CustomerCHAR10 QNMATCHKUKZ
MATCHLIKZ Search for Notifications for Material/Batch and SupplierCHAR10 QNMATCHLIKZ
FEGRPKZ Search for Notifications for "Defect Type" Code GroupCHAR10 QNFEGRPKZ
FECODKZ Search for Notifications for "Defect Type" CodeCHAR10 QNFECODKZ
FOGRPKZ Search for Notifications for "Defect Location" Code GroupCHAR10 QNFOGRPKZ
FOCODKZ Search for Notifications for "Defect Location" CodeCHAR10 QNFOCODKZ
MOD Display Mode for NotificationsCHAR10 QNMOD
ICON1 No Outstanding NotificationsCHAR300 QNICON1
ICON2 Outstanding NotificationsCHAR300 QNICON2
VERS Variants for Determining Existence of NotificationsCHAR10 QNVERS
ZEITRAUM Number of DaysNUMC40 QNZEIT
TDOBJECT Texts: application objectCHAR100 TTXOB TDOBJECT
TDNAME NameCHAR700 STXH TDOBNAME
TDID Text IDCHAR40 TTXID TDID
CMCHECK_SM Credit Limit Check for CS ProcessingCHAR10 CMCHECK_SM
CMGRA Credit group sales orderCHAR20 T691D CMGRA
PARVW_PAGE Partner Function for PagingCHAR20 TPAR PARVW_PAGE
CUA_FBS Function Module that Sets CUA MenuCHAR300 TFDIR Q_CUA_FBS
ROLE_VERA Standard Role for Partner Determination: Notif. ProcessorCHAR120 QSTROLE
PERMIT Notification Type with Approval ProcedureCHAR10 QPERMIT
PARVW_GEH Partner Function for Approver (Person/Department)CHAR20 TPAR PARVW_GEH
ROLE_GEH Standard Role for Partner Determination: ApproverCHAR120 QSTROLE2
ROLE_QMSM Standard Role for Partner Determination: Task ProcessorCHAR120 QSTROLE3
PROCESS QM ProcessNUMC30 TQ80_PR QMPROCESS
REQMAINTAPP_USE Notification Type for Request Maintenance AppCHAR10 EAM_NTF_CREATE_TYPE_ACTIVE
/ Relationships

TQ80 relationships.

49 relationships
TableFieldCheck tableDescriptionCheck field
TQ80ARTPRT356APriority type tableMANDT
TQ80ARTPRT356APriority type tableARTPR
TQ80AUARTT003OOrder TypesAUART
TQ80AUART2T003OOrder TypesAUART
TQ80CMGRAT691DCredit groups for document typesMANDT
TQ80COAUARTT003OOrder TypesAUART
TQ80CUA_FBSTFDIRFunction ModuleFUNCNAME
TQ80ESCALT355EResponse time monitorMANDT
TQ80ESCALT355EResponse time monitorESCAL
TQ80FBS_CREATETFDIRFunction ModuleFUNCNAME
TQ80FEKATTQ15Inspection catalog type indexKATALOGART
TQ80INFO_WINDTQ80OObject info parametersMANDT
TQ80INFO_WINDTQ80OObject info parametersINFO_WIND
TQ80MAKATTQ15Inspection catalog type indexKATALOGART
TQ80MFKATTQ15Inspection catalog type indexKATALOGART
TQ80OTKATTQ15Inspection catalog type indexKATALOGART
TQ80PARGRTVPGPartner Function GroupsPARGR
TQ80PARVW_APTPARBusiness Partner: FunctionsPARVW
TQ80PARVW_AUTOTPARBusiness Partner: FunctionsPARVW
TQ80PARVW_GEHTPARBusiness Partner: FunctionsPARVW
TQ80PARVW_HERTPARBusiness Partner: FunctionsPARVW
TQ80PARVW_INTTPARBusiness Partner: FunctionsPARVW
TQ80PARVW_KUNDTPARBusiness Partner: FunctionsPARVW
TQ80PARVW_LIEFTPARBusiness Partner: FunctionsPARVW
TQ80PARVW_PAGETPARBusiness Partner: FunctionsPARVW
TQ80PARVW_QMSMTPARBusiness Partner: FunctionsPARVW
TQ80PARVW_VERATPARBusiness Partner: FunctionsPARVW
TQ80PROCESSTQ80_PRQM ProcessPROCESS
TQ80QMTYPTQ8TNotification categoryMANDT
TQ80QMTYPTQ8TNotification categoryQMTYP
TQ80QMWAERSTCURCCurrency CodesMANDT
TQ80QMWAERSTCURCCurrency CodesWAERS
TQ80RBNRT352BTechnical reportMANDT
TQ80SAKATTQ15Inspection catalog type indexKATALOGART
TQ80SDAUARTTVAKSales Document TypesMANDT
TQ80SDAUARTTVAKSales Document TypesAUART
TQ80SERWIT355RService windowMANDT
TQ80SERWIT355RService windowSERWI
TQ80SMSTSMATJ20Status profilesMANDT
TQ80SMSTSMATJ20Status profilesSTSMA
TQ80STAFOTMCBUpdate groupsMANDT
TQ80STAFOTMCBUpdate groupsSTAFO
TQ80STSMATJ20Status profilesMANDT
TQ80STSMATJ20Status profilesSTSMA
TQ80TDNAMESTXHSTXD SAPscript text file headerMANDT
TQ80TDNAMESTXHSTXD SAPscript text file headerTDNAME
TQ80TDNAMESTXHSTXD SAPscript text file headerTDSPRAS
TQ80TDOBJECTTTXOBValid text objectsTDOBJECT
TQ80URKATTQ15Inspection catalog type indexKATALOGART
Back to SAP tables