SAP table RIQS5 (PM/SM/QM Notifications: I/O data for creating notification)

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

RIQS5 foreign key relationships

Table Field Check Table Check Field
0 RIQS5 KALVAR TCK03 Costing Variants MANDT
1 RIQS5 KOKRS TKA01 Controlling Areas MANDT
0 RIQS5 OBJNR_REAL ONR00 General Object Number MANDT
0 RIQS5 OBJNR_REAL ONR00 General Object Number OBJNR
1 RIQS5 OBJNR_STAT ONR00 General Object Number MANDT
1 RIQS5 OBJNR_STAT ONR00 General Object Number OBJNR