1. Home
  2. Resources
  3. SAP Tables
  4. RIQS5 - PM/SM/QM Notifications: I/O data for creating notification

SAP Table RIQS5

PM/SM/QM Notifications: I/O data for creating notification

RIQS5 (PM/SM/QM Notifications: I/O data for creating notification) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link RIQS5 to other SAP tables.

RIQS5 table fields

Field Data element Checktable Datatype Length Decimals
QMART Notification Type QMART CHAR 2 0
QMNUM Notification No QMNUM CHAR 12 0
EQUNR Equipment Number EQUNR CHAR 18 0
TPLNR Functional Location TPLNR CHAR 30 0
BAUTL Assembly BAUTL CHAR 18 0
SERIALNR Serial Number GERNR CHAR 18 0
MATNR Material Number MATNR CHAR 18 0
MAWERK Plant for Material QMAWERKS CHAR 4 0
REVLV Revision Level REVLV CHAR 2 0
CHARG Batch Number CHARG_D CHAR 10 0
LGORTCHARG Storage Location of Batch QLGORTCHAR CHAR 4 0
SPART Division SPART CHAR 2 0
VKORG Sales Organization VKORG CHAR 4 0
VTWEG Distribution Channel VTWEG CHAR 2 0
VKBUR Sales Office VKBUR CHAR 4 0
VKGRP Sales Group VKGRP CHAR 3 0
KUNUM Customer Number KUNUM CHAR 10 0
PARNR Number of contact person PARNR NUMC 10 0
EKORG Purchasing Organization EKORG CHAR 4 0
BKGRP Purchasing Group BKGRP CHAR 3 0
LIFNUM Vendor Account Number LIFNUM CHAR 10 0
HERSTELLER Number of Manufacturer QLIFNR CHAR 10 0
QMTXT Short Text QMTXT CHAR 40 0
PRIOK Priority PRIOK CHAR 1 0
STRMN Required start date STRMN DATS 8 0
STRUR Required Start Time STRUR TIMS 6 0
LTRMN Required End Date LTRMN DATS 8 0
LTRUR Requested End Time LTRUR TIMS 6 0
DEVICEID Additional Device Data DEVICEID CHAR 40 0
PRODDAT Production Date QPRODDAT DATS 8 0
SCREENTY SCREEN TYPE: for order-order category (see domain) SCREENTY CHAR 4 0
ARBPLWERK Plant for Work Center QARBPWERKS CHAR 4 0
ARBPL Object ID of the Work Center LGWID NUMC 8 0
CROBJTY Object types of the CIM resource CR_OBJTY CHAR 2 0
A Work center
AA Work center alias
FH Production resources/tools
H Hierarchy
QWRNUM Reference Notification Number QWRNUM CHAR 12 0
REFNUM External Reference Number QMEXTNR CHAR 20 0
LS_KDAUF Sales Order Number KDAUF CHAR 10 0
LS_KDPOS Item Number in Sales Order KDPOS NUMC 6 0
BSTNK Customer purchase order number BSTKD CHAR 35 0
BSTDK Customer purchase order date BSTDK DATS 8 0
LS_VBELN Delivery VBELN_VL CHAR 10 0
LS_POSNR Delivery Item QPOSNR_VL NUMC 6 0
KDMAT Material Number Used by Customer MATNR_KU CHAR 35 0
EBELN Purchasing Document Number EBELN CHAR 10 0
EBELP Item Number of Purchasing Document QEBELP NUMC 5 0
MJAHR Material Document Year MJAHR NUMC 4 0
MBLNR Number of Material Document MBLNR CHAR 10 0
MBLPO Item in Material Document QMBLPO NUMC 4 0
IDNLF Material Number Used by Vendor IDNLF CHAR 35 0
LICHN Vendor Batch Number LICHN CHAR 15 0
EMATNR Material Number Corresponding to Manufacturer Part Number EMATN CHAR 18 0
VERID Production Version VERID CHAR 4 0
RM_MATNR Material number of the production version RM_MATNR CHAR 18 0
RM_WERKS Plant of production version RM_WERKS CHAR 4 0
FERTAUFNR Order Number (Production Order) FERTAUFNR CHAR 12 0
FERTAUFPL Plan Number for Operations in Order (Production Order) FERTAUFPL NUMC 10 0
PNLKN Current Node Number from Order Counter APLZL QLFNKN NUMC 8 0
IWERK Maintenance Planning Plant IWERK CHAR 4 0
INGRP Planner Group for Customer Service and Plant Maintenance INGRP CHAR 3 0
MSAUS Breakdown Indicator MSAUS CHAR 1 0
X Yes
NULL No
AUSVN Start of Malfunction (Date) AUSVN DATS 8 0
AUZTV Start of Malfunction (Time) AUZTV TIMS 6 0
QMNAM Name of Person Reporting Notification QMNAM CHAR 12 0
QMDAT Date of Notification QMDAT DATS 8 0
MZEIT Time of Notification MZEIT TIMS 6 0
QMKAT Catalog Type - Coding QMKAT CHAR 1 0
QMGRP Code Group - Coding QMGRP CHAR 8 0
QMCOD Coding QMCOD CHAR 4 0
AUSWIRK Key for a Scenario QSCENARIO CHAR 4 0
MGEIG Defective Quantity (Internal) MGEIG QUAN 13 3
MGFRD Defective Quantity (External) MGFRD QUAN 13 3
BZMNG General Reference Quantity QBZMNG QUAN 13 3
RKMNG Complaint Quantity RKMNG QUAN 13 3
RGMNG Return Delivery Quantity RGMNG QUAN 13 3
RKDAT Date of Return Delivery RKDAT DATS 8 0
WARPL Maintenance Plan WARPL CHAR 12 0
ABNUM Maintenance Plan Call Number ABNUM INT4 10 0
WAPOS Maintenance item WAPOS CHAR 16 0
KDAUF Sales Document VBELN_VA CHAR 10 0
KDPOS Sales Document Item POSNR_VA NUMC 6 0
AUSBS End of Malfunction (Date) AUSBS DATS 8 0
AUZTB End of Malfunction (Time) AUZTB TIMS 6 0
AUSZT Breakdown Duration AUSZT FLTP 16 16
MAUEH Unit for Breakdown Duration MAUEH UNIT 3 0
REFOBJTYP Object Type SWO_OBJTYP CHAR 10 0
REFOBJKEY Object key SWO_TYPEID CHAR 70 0
RELTYPE Relationship type BINRELTYP CHAR 4 0
/SAPSMOSS/INSTN Installation number /SAPSMOSS/R3INSTN /SAPSMOSS/INSTN CHAR 10 0
/SAPSMOSS/MNUMM SAPNet notification number /SAPSMOSS/MNUMM NUMC 24 0
/SAPSMOSS/OSSYS Operating system and version /SAPSMOSS/OSSYS /SAPSMOSS/OSYS CHAR 10 0
/SAPSMOSS/DBSYS Database system /SAPSMOSS/DBSYS /SAPSMOSS/DBSY CHAR 10 0
/SAPSMOSS/REL R/3 Release /SAPSMOSS/R3REL /SAPSMOSS/REL CHAR 10 0
/SAPSMOSS/COMP Area /SAPSMOSS/R3COMP CHAR 20 0
/SAPSMOSS/FRONT Frontend /SAPSMOSS/FRONTEND /SAPSMOSS/FRNT CHAR 10 0
/SAPSMOSS/SYSTYP R/3 System type /SAPSMOSS/R3SYSTYPE /SAPSMOSS/SYST CHAR 1 0
/SAPSMOSS/ADDID Add-on ID /SAPSMOSS/R3ADDID /SAPSMOSS/ADDID CHAR 10 0
/SAPSMOSS/ADDREL Add-On Release /SAPSMOSS/R3ADDREL /SAPSMOSS/ADDRL CHAR 10 0
/SAPSMOSS/TSTMP SAPNet time stamp /SAPSMOSS/NSTSTMP NUMC 14 0
/SAPSMOSS/STATUS Status of R/3 notification in SAPNet /SAPSMOSS/STATUS /SAPSMOSS/STAT CHAR 1 0
/SAPSMOSS/ERDAT Date on which notification was completed at SAP /SAPSMOSS/ERDAT DATS 8 0
/SAPSMOSS/ERZEIT Time when notification was completed at SAP /SAPSMOSS/ERZEIT TIMS 6 0
/SAPSMOSS/SYSID Name of SAP System SYSYSID CHAR 8 0
/SAPSMOSS/MANDT Client ID SYMANDT CLNT 3 0
PSP_NR WBS Element PS_POSNR NUMC 8 0
ESTIMATED_COSTS Estimated Costs for a Claim PS_COSTS CURR 13 2
CLAIMED_COSTS Costs Claimed COSTS_CLAIM CURR 13 2
RESULT_COSTS Costs Accepted COSTS_RESULT CURR 13 2
CHANCE Chance of Completing a Claim PS_CHANCE NUMC 2 0
01 Very Low
02 Short
03 Medium
04 High
05 Very high
OPPONENT Partner Type PS_OPPONENT CHAR 2 0
01 Customer
02 Vendor
03 Internal Field
KOKRS Controlling Area KOKRS TKA01 CHAR 4 0
OBJNR_REAL Object number of real CO account assignment J_OBJNR_REAL ONR00 CHAR 22 0
OBJNR_STAT Auxiliary account assignment 1 OBJNR_N1 ONR00 CHAR 22 0
KALVAR Costing Variant for Postprocessing with Unit Costing CK_KALVAR TCK03 CHAR 4 0
KALNR Cost Estimate Number for Cost Est. w/o Qty Structure CK_KALNR NUMC 12 0
WAERS Currency Key WAERS CUKY 5 0
PRDHA Product hierarchy PRODH_D CHAR 18 0
ADRNR Addresses: Address Number CADNR CHAR 10 0
BUKRS Company Code BUKRS CHAR 4 0
MATKL Material Group MATKL CHAR 9 0
ILOAN Location and account assignment for technical object ILOAN CHAR 12 0
ILOAI ILOA Individual ILOAI CHAR 1 0
X Yes
NULL No
SWERK Maintenance plant SWERK CHAR 4 0
STORT Location of maintenance object PMLOC CHAR 10 0
MSGRP Room RAUMNR CHAR 8 0
BEBER Plant section BEBER CHAR 3 0
PPSID Object ID of PP work center PPSID NUMC 8 0
ABCKZ ABC indicator for technical object ABCKZ CHAR 1 0
EQFNR Sort field EQFNR CHAR 30 0
GSBER Business Area GSBER CHAR 4 0
KOSTL Cost Center KOSTL CHAR 10 0
PROID Work Breakdown Structure Element (WBS Element) PS_PSP_PNR NUMC 8 0
ANLNR Main Asset Number ANLN1 CHAR 12 0
ANLUN Asset Subnumber ANLN2 CHAR 4 0
MGEIN Unit of Measure MGEIN UNIT 3 0
/ISDFPS/OBJNR Object number J_OBJNR CHAR 22 0
LOGSYSTEM Logical System LOGSYSTEM CHAR 10 0
/ISDFPS/MEQUI Master Equipment /ISDFPS/MEQUI CHAR 18 0
BTPLN Functional Location Affected BTPLN CHAR 30 0
BEQUI Equipment Affected BEQUI CHAR 18 0
PLNTY Task List Type PLNTY CHAR 1 0
PLNNR Key for Task List Group PLNNR CHAR 8 0
PLNAL Group Counter PLNAL CHAR 2 0
SHN_OBJTY Object types of the CIM resource CR_OBJTY CHAR 2 0
A Work center
AA Work center alias
FH Production resources/tools
H Hierarchy
SHN_OBJID Object ID of the resource CR_OBJID NUMC 8 0
SHN_FUNCT_LOC Functional Location TPLNR CHAR 30 0
SHN_EQUIPMENT Equipment Number EQUNR CHAR 18 0
SHN_ORIGIN Origin or Use of Shift Note or Report COCF_SRN_ORIGIN NUMC 2 0
01 Work Center/Hierarchy
02 Functional Location/Equipment
UII Unique Item Identifier UII_CHAR72 CHAR 72 0
PAMS_DUMMY Character Field Length 1 CHAR01 CHAR 1 0
PAMS_ATSTF Actual Start Time PAMS_ATSTF DEC 15 0
PAMS_ATSTT Actual End Time PAMS_ATSTT DEC 15 0
PAMS_PTSTT Planned Time Stamp (to) PAMS_PTSTT DEC 15 0
PAMS_PTSTF Planned Time Stamp (from) PAMS_PTSTF DEC 15 0
REVNR Revision for Plant Maintenance and Customer Service REVNI CHAR 8 0
PRUEFLOS Inspection Lot Number QPLOS NUMC 12 0

RIQS5 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
RIQS5 /SAPSMOSS/ADDID * /SAPSMOSS/ADDID Add-On ID MANDT
RIQS5 /SAPSMOSS/ADDID RIQS5 /SAPSMOSS/ADDID /SAPSMOSS/ADDID Add-On ID R3ADDID
RIQS5 /SAPSMOSS/ADDREL * /SAPSMOSS/ADDRL Add-On Release MANDT
RIQS5 /SAPSMOSS/ADDREL RIQS5 /SAPSMOSS/ADDREL /SAPSMOSS/ADDRL Add-On Release R3ADDREL
RIQS5 /SAPSMOSS/DBSYS SYST MANDT /SAPSMOSS/DBSY Databases MANDT
RIQS5 /SAPSMOSS/DBSYS RIQS5 /SAPSMOSS/DBSYS /SAPSMOSS/DBSY Databases DBSYS
RIQS5 /SAPSMOSS/FRONT RIQS5 /SAPSMOSS/FRONT /SAPSMOSS/FRNT Frontend FRONTEND
RIQS5 /SAPSMOSS/FRONT SYST MANDT /SAPSMOSS/FRNT Frontend MANDT
RIQS5 /SAPSMOSS/INSTN SYST MANDT /SAPSMOSS/INSTN Table of Installation Numbers MANDT
RIQS5 /SAPSMOSS/INSTN RIQS5 /SAPSMOSS/INSTN /SAPSMOSS/INSTN Table of Installation Numbers R3INSTN
RIQS5 /SAPSMOSS/OSSYS SYST MANDT /SAPSMOSS/OSYS Operating systems MANDT
RIQS5 /SAPSMOSS/OSSYS RIQS5 /SAPSMOSS/OSSYS /SAPSMOSS/OSYS Operating systems OSSYS
RIQS5 /SAPSMOSS/REL SYST MANDT /SAPSMOSS/REL SAP release MANDT
RIQS5 /SAPSMOSS/REL RIQS5 /SAPSMOSS/REL /SAPSMOSS/REL SAP release R3REL
RIQS5 /SAPSMOSS/STATUS RIQS5 /SAPSMOSS/STATUS /SAPSMOSS/STAT Status STATUS
RIQS5 /SAPSMOSS/SYSTYP SYST MANDT /SAPSMOSS/SYST System types MANDT
RIQS5 /SAPSMOSS/SYSTYP RIQS5 /SAPSMOSS/SYSTYP /SAPSMOSS/SYST System types R3SYSTYPE
RIQS5 KALVAR SYST MANDT TCK03 Costing Variants MANDT
RIQS5 KALVAR RIQS5 KALVAR TCK03 Costing Variants KLVAR
RIQS5 KOKRS SYST MANDT TKA01 Controlling Areas MANDT
RIQS5 KOKRS RIQS5 KOKRS TKA01 Controlling Areas KOKRS
RIQS5 OBJNR_REAL RIQS5 OBJNR_REAL ONR00 General Object Number OBJNR
RIQS5 OBJNR_REAL SYST MANDT ONR00 General Object Number MANDT
RIQS5 OBJNR_STAT SYST MANDT ONR00 General Object Number MANDT
RIQS5 OBJNR_STAT RIQS5 OBJNR_STAT ONR00 General Object Number OBJNR