SAP ABAP Table RIQS5 (PM/SM/QM Notifications: I/O data for creating notification)
Hierarchy
☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MSE (Application Component) Mobile Service
     ⤷ IWOC (Package) Application Development R/3 Work Order Cycle
Basic Data
Table Category INTTAB    Structure 
Structure RIQS5   Table Relationship Diagram
Short Description PM/SM/QM Notifications: I/O data for creating notification    
Delivery and Maintenance
Pool/cluster      
Delivery Class      
Data Browser/Table View Maintenance     Display/Maintenance Allowed with Restrictions 
Components
     
Field Key Data Element Domain Data
Type		 Length Decimal
Places		 Short Description Check
table
1 QMART QMART QMART CHAR 2   0   Message Type *
2 QMNUM QMNUM QMNUM CHAR 12   0   Message Number *
3 EQUNR EQUNR EQUNR CHAR 18   0   Equipment Number *
4 TPLNR TPLNR TPLNR CHAR 30   0   Functional Location *
5 BAUTL BAUTL MATNR CHAR 18   0   Assembly *
6 SERIALNR GERNR GERNR CHAR 18   0   Serial Number  
7 MATNR MATNR MATNR CHAR 18   0   Material Number *
8 MAWERK QMAWERKS WERKS CHAR 4   0   Plant for Material *
9 REVLV REVLV REVLV CHAR 2   0   Revision level  
10 CHARG CHARG_D CHARG CHAR 10   0   Batch Number *
11 LGORTCHARG QLGORTCHAR LGORT CHAR 4   0   Storage Location of Batch *
12 SPART SPART SPART CHAR 2   0   Division *
13 VKORG VKORG VKORG CHAR 4   0   Sales Organization *
14 VTWEG VTWEG VTWEG CHAR 2   0   Distribution Channel *
15 VKBUR VKBUR VKBUR CHAR 4   0   Sales office *
16 VKGRP VKGRP VKGRP CHAR 3   0   Sales group *
17 KUNUM KUNUM KUNNR CHAR 10   0   Customer Number *
18 PARNR PARNR PARNR NUMC 10   0   Number of contact person  
19 EKORG EKORG EKORG CHAR 4   0   Purchasing organization *
20 BKGRP BKGRP EKGRP CHAR 3   0   Purchasing Group *
21 LIFNUM LIFNUM LIFNR CHAR 10   0   Vendor Account Number *
22 HERSTELLER QLIFNR LIFNR CHAR 10   0   Number of Manufacturer *
23 QMTXT QMTXT TEXT40 CHAR 40   0   Short Text  
24 PRIOK PRIOK PRIOK CHAR 1   0   Priority *
25 STRMN STRMN DATUM DATS 8   0   Desired Start Date  
26 STRUR STRUR UZEIT TIMS 6   0   Desired Start Time  
27 LTRMN LTRMN DATUM DATS 8   0   Required Finish Date  
28 LTRUR LTRUR UZEIT TIMS 6   0   Required End Date-Time  
29 DEVICEID DEVICEID DEVICEID CHAR 40   0   Additional Device Data  
30 PRODDAT QPRODDAT DATUM DATS 8   0   Production Date  
31 SCREENTY SCREENTY CHAR4 CHAR 4   0   SCREEN TYPE: for order-order category (see domain)  
32 ARBPLWERK QARBPWERKS WERKS CHAR 4   0   Plant for Work Center *
33 ARBPL LGWID CR_OBJID NUMC 8   0   Object ID of the Work Center *
34 CROBJTY CR_OBJTY CR_OBJTY CHAR 2   0   Object types of the CIM resource  
35 QWRNUM QWRNUM QMNUM CHAR 12   0   Reference Notification Number *
36 REFNUM QMEXTNR CHAR020 CHAR 20   0   External Reference Number  
37 LS_KDAUF KDAUF VBELN CHAR 10   0   Sales Order Number *
38 LS_KDPOS KDPOS NUM06 NUMC 6   0   Item number in Sales Order  
39 BSTNK BSTKD BSTKD CHAR 35   0   Customer purchase order number  
40 BSTDK BSTDK DATUM DATS 8   0   Customer purchase order date  
41 LS_VBELN VBELN_VL VBELN CHAR 10   0   Delivery *
42 LS_POSNR QPOSNR_VL POSNR NUMC 6   0   Delivery Item *
43 KDMAT MATNR_KU IDNEX CHAR 35   0   Customer Material Number  
44 EBELN EBELN EBELN CHAR 10   0   Purchasing Document Number *
45 EBELP QEBELP EBELP NUMC 5   0   Item Number of Purchasing Document *
46 MJAHR MJAHR GJAHR NUMC 4   0   Year of material document  
47 MBLNR MBLNR BELNR CHAR 10   0   Number of Material Document  
48 MBLPO QMBLPO MBLPO NUMC 4   0   Item in Material Document  
49 IDNLF IDNLF IDNEX CHAR 35   0   Material Number Used by Vendor  
50 LICHN LICHN LICHN CHAR 15   0   Vendor Batch Number  
51 EMATNR EMATN MATNR CHAR 18   0   Material number corresponding to manufacturer part number *
52 VERID VERID VERID CHAR 4   0   Production Version *
53 RM_MATNR RM_MATNR MATNR CHAR 18   0   Material number of the production version *
54 RM_WERKS RM_WERKS WERKS CHAR 4   0   Plant of production version *
55 FERTAUFNR FERTAUFNR AUFNR CHAR 12   0   Order Number (Production Order) *
56 FERTAUFPL FERTAUFPL AUFPL NUMC 10   0   Plan Number for Operations in Order (Production Order)  
57 PNLKN QLFNKN KNTNR NUMC 8   0   Current Node Number from Order Counter APLZL  
58 IWERK IWERK WERKS CHAR 4   0   Maintenance Planning Plant *
59 INGRP INGRP INGRP CHAR 3   0   Planner Group for Customer Service and Plant Maintenance *
60 MSAUS MSAUS XFELD CHAR 1   0   Breakdown Indicator  
61 AUSVN AUSVN DATUM DATS 8   0   Start of Malfunction (Date)  
62 AUZTV AUZTV UHRZT TIMS 6   0   Start of Malfunction (Time)  
63 QMNAM QMNAM USNAM CHAR 12   0   Name of declarant  
64 QMDAT QMDAT DATUM DATS 8   0   Date of Notification  
65 MZEIT MZEIT UHRZT TIMS 6   0   Notification Time  
66 QMKAT QMKAT QKATART CHAR 1   0   Catalog type - coding *
67 QMGRP QMGRP QCODEGRP CHAR 8   0   Code group - coding *
68 QMCOD QMCOD QCODE CHAR 4   0   Coding *
69 AUSWIRK QSCENARIO QSCENARIO CHAR 4   0   Key for a Scenario *
70 MGEIG MGEIG MENGE QUAN 13   3   Defective Quantity (Internal)  
71 MGFRD MGFRD MENGE QUAN 13   3   Defective Quantity (External)  
72 BZMNG QBZMNG MENGE QUAN 13   3   General Reference Quantity  
73 RKMNG RKMNG MENGE QUAN 13   3   Complaint Quantity  
74 RGMNG RGMNG MENGE QUAN 13   3   Return Delivery Quantity  
75 RKDAT RKDAT DATUM DATS 8   0   Date of Return Delivery  
76 WARPL WARPL WARPL CHAR 12   0   Maintenance Plan *
77 ABNUM ABNUM ABNUM INT4 10   0   Maintenance Plan Call Number  
78 WAPOS WAPOS POSNU CHAR 16   0   Maintenance item  
79 KDAUF VBELN_VA VBELN CHAR 10   0   Sales Document *
80 KDPOS POSNR_VA POSNR NUMC 6   0   Sales Document Item *
81 AUSBS AUSBS DATUM DATS 8   0   End of Malfunction (Date)  
82 AUZTB AUZTB UHRZT TIMS 6   0   End of Malfunction (Time)  
83 AUSZT AUSZT FLTP FLTP 16   16   Breakdown Duration  
84 MAUEH MAUEH MEINS UNIT 3   0   Unit for Breakdown Duration *
85 REFOBJTYP SWO_OBJTYP OJ_NAME CHAR 10   0   Object Type *
86 REFOBJKEY SWO_TYPEID SWO_TYPEID CHAR 70   0   Object key  
87 RELTYPE BINRELTYP BINRELTYP CHAR 4   0   Relationship type *
88 .INCLUDE       0   0   OSS-Relevant Attributes/Fields  
89 /SAPSMOSS/INSTN /SAPSMOSS/R3INSTN /SAPSMOSS/R3INSTN CHAR 10   0   Installation number /SAPSMOSS/INSTN
90 /SAPSMOSS/MNUMM /SAPSMOSS/MNUMM /SAPSMOSS/MNUMM NUMC 24   0   SAPNet notification number  
91 /SAPSMOSS/OSSYS /SAPSMOSS/OSSYS /SAPSMOSS/OSSYS CHAR 10   0   Operating system and version /SAPSMOSS/OSYS
92 /SAPSMOSS/DBSYS /SAPSMOSS/DBSYS /SAPSMOSS/DBSYS CHAR 10   0   Database system /SAPSMOSS/DBSY
93 /SAPSMOSS/REL /SAPSMOSS/R3REL /SAPSMOSS/R3REL CHAR 10   0   R/3 Release /SAPSMOSS/REL
94 /SAPSMOSS/COMP /SAPSMOSS/R3COMP /SAPSMOSS/R3COMP CHAR 20   0   Area  
95 /SAPSMOSS/FRONT /SAPSMOSS/FRONTEND /SAPSMOSS/FRONTEND CHAR 10   0   Frontend /SAPSMOSS/FRNT
96 /SAPSMOSS/SYSTYP /SAPSMOSS/R3SYSTYPE /SAPSMOSS/R3SYSTYPE CHAR 1   0   R/3 System type /SAPSMOSS/SYST
97 /SAPSMOSS/ADDID /SAPSMOSS/R3ADDID /SAPSMOSS/R3ADDID CHAR 10   0   Add-on ID /SAPSMOSS/ADDID
98 /SAPSMOSS/ADDREL /SAPSMOSS/R3ADDREL /SAPSMOSS/R3ADDREL CHAR 10   0   Add-On Release /SAPSMOSS/ADDRL
99 /SAPSMOSS/TSTMP /SAPSMOSS/NSTSTMP TZNTIMESTP NUMC 14   0   SAPNet time stamp  
100 /SAPSMOSS/STATUS /SAPSMOSS/STATUS /SAPSMOSS/STATUS CHAR 1   0   Status of R/3 notification in SAPNet /SAPSMOSS/STAT
101 /SAPSMOSS/ERDAT /SAPSMOSS/ERDAT DATUM DATS 8   0   Date on which notification was completed at SAP  
102 /SAPSMOSS/ERZEIT /SAPSMOSS/ERZEIT UHRZT TIMS 6   0   Time when notification was completed at SAP  
103 /SAPSMOSS/SYSID SYSYSID SYCHAR08 CHAR 8   0   Name of SAP System  
104 /SAPSMOSS/MANDT SYMANDT MANDT CLNT 3   0   Client ID *
105 .INCLUDE       0   0   Additional Claim Management Data  
106 PSP_NR PS_POSNR PS_POSNR NUMC 8   0   WBS Element *
107 ESTIMATED_COSTS PS_COSTS WERTV7 CURR 13   2   Estimated Costs for a Claim  
108 CLAIMED_COSTS COSTS_CLAIM WERTV7 CURR 13   2   Costs Claimed  
109 RESULT_COSTS COSTS_RESULT WERTV7 CURR 13   2   Costs Accepted  
110 CHANCE PS_CHANCE PS_CHANCE NUMC 2   0   Chance of Completing a Claim  
111 OPPONENT PS_OPPONENT OPPONENT CHAR 2   0   Partner Type  
112 KOKRS KOKRS CACCD CHAR 4   0   Controlling Area TKA01
113 OBJNR_REAL J_OBJNR_REAL J_OBJNR CHAR 22   0   Object number of real CO account assignment ONR00
114 OBJNR_STAT OBJNR_N1 J_OBJNR CHAR 22   0   Auxiliary account assignment 1 ONR00
115 KALVAR CK_KALVAR KLVAR CHAR 4   0   Costing Variant for Postprocessing with Unit Costing TCK03
116 KALNR CK_KALNR CK_KALNR NUMC 12   0   Cost Estimate Number for Cost Est. w/o Qty Structure *
117 WAERS WAERS WAERS CUKY 5   0   Currency Key *
118 PRDHA PRODH_D PRODH CHAR 18   0   Product Hierarchy *
119 ADRNR CADNR CADRNR CHAR 10   0   Addresses: Address Number *
120 BUKRS BUKRS BUKRS CHAR 4   0   Company Code *
121 MATKL MATKL MATKL CHAR 9   0   Material Group *
122 ILOAN ILOAN ILOAN CHAR 12   0   Location and account assignment for technical object *
123 ILOAI ILOAI X CHAR 1   0   ILOA Individual  
124 SWERK SWERK WERKS CHAR 4   0   Maintenance Plant *
125 STORT PMLOC AP_STAND CHAR 10   0   Location of maintenance object *
126 MSGRP RAUMNR CHAR8 CHAR 8   0   Room  
127 BEBER BEBER BEBER CHAR 3   0   Organizational Area *
128 PPSID PPSID CR_OBJID NUMC 8   0   Object ID of PP work center *
129 ABCKZ ABCKZ ABCKZ CHAR 1   0   ABC Indicator for Technical Object *
130 EQFNR EQFNR CHAR30 CHAR 30   0   Sort Field  
131 GSBER GSBER GSBER CHAR 4   0   Business Area *
132 KOSTL KOSTL KOSTL CHAR 10   0   Cost Center *
133 PROID PS_PSP_PNR PS_POSNR NUMC 8   0   Work Breakdown Structure Element (WBS Element) *
134 ANLNR ANLN1 ANLN1 CHAR 12   0   Main Asset Number *
135 ANLUN ANLN2 ANLN2 CHAR 4   0   Asset Subnumber *
136 MGEIN MGEIN MEINS UNIT 3   0   Unit of Measure *
137 .INCLU--AP       0   0   Fields for /ISDFPS/ Enhancements  
138 /ISDFPS/OBJNR J_OBJNR J_OBJNR CHAR 22   0   Object number *
139 LOGSYSTEM LOGSYSTEM LOGSYS CHAR 10   0   Logical System *
140 /ISDFPS/MEQUI /ISDFPS/MEQUI EQUNR CHAR 18   0   Master Equipment *
141 .INCLU--AP       0   0   Logbook fields  
142 BTPLN BTPLN TPLNR CHAR 30   0   Functional Location Affected *
143 BEQUI BEQUI EQUNR CHAR 18   0   Equipment Affected *
144 .INCLU--AP       0   0   Customer fields for table RIQS5  
145 PLNTY PLNTY PLNTY CHAR 1   0   Task List Type *
146 PLNNR PLNNR PLNNR CHAR 8   0   Key for Task List Group  
147 PLNAL PLNAL ALTNR CHAR 2   0   Group Counter  
148 .INCLU--AP       0   0   Technical Object/Work Center + Hierarchy Shift Note  
149 SHN_OBJTY CR_OBJTY CR_OBJTY CHAR 2   0   Object types of the CIM resource  
150 SHN_OBJID CR_OBJID CR_OBJID NUMC 8   0   Object ID of the resource *
151 SHN_FUNCT_LOC TPLNR TPLNR CHAR 30   0   Functional Location *
152 SHN_EQUIPMENT EQUNR EQUNR CHAR 18   0   Equipment Number *
153 SHN_ORIGIN COCF_SRN_ORIGIN COCF_SRN_ORIGIN NUMC 2   0   Origin or Use of Shift Note or Report  
154 .INCLU--AP       0   0   IUID Append  
155 UII UII_CHAR72 UII_CHAR72 CHAR 72   0   Unique Item Identifier  
156 .INCLU--AP       0   0   Enhancements for PAMS  
157 PAMS_DUMMY CHAR01 CHAR1 CHAR 1   0   Character Field Length 1  
158 PAMS_ATSTF PAMS_ATSTF TZNTSTMPS DEC 15   0   Actual Start Time  
159 PAMS_ATSTT PAMS_ATSTT TZNTSTMPS DEC 15   0   Actual End Time  
160 PAMS_PTSTT PAMS_PTSTT TZNTSTMPS DEC 15   0   Planned Time Stamp (to)  
161 PAMS_PTSTF PAMS_PTSTF TZNTSTMPS DEC 15   0   Planned Time Stamp (from)  
162 .INCLU--AP       0   0   Revision  
163 REVNR REVNI REVNI CHAR 8   0   Revision of Plant Maintenance and Customer Service *
164 .INCLU--AP       0   0   RIQS5 Append for RPLM  
165 PRUEFLOS QPLOS QPLOS NUMC 12   0   Inspection Lot Number *
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 RIQS5 /SAPSMOSS/ADDID /SAPSMOSS/ADDID R3ADDID    
2 RIQS5 /SAPSMOSS/ADDREL /SAPSMOSS/ADDRL R3ADDREL    
3 RIQS5 /SAPSMOSS/DBSYS /SAPSMOSS/DBSY DBSYS REF 1 CN
4 RIQS5 /SAPSMOSS/FRONT /SAPSMOSS/FRNT FRONTEND REF    
5 RIQS5 /SAPSMOSS/INSTN /SAPSMOSS/INSTN R3INSTN REF 1 CN
6 RIQS5 /SAPSMOSS/OSSYS /SAPSMOSS/OSYS OSSYS REF 1 CN
7 RIQS5 /SAPSMOSS/REL /SAPSMOSS/REL R3REL REF 1 CN
8 RIQS5 /SAPSMOSS/STATUS /SAPSMOSS/STAT STATUS    
9 RIQS5 /SAPSMOSS/SYSTYP /SAPSMOSS/SYST R3SYSTYPE REF 1 CN
10 RIQS5 KALVAR TCK03 KLVAR REF    
11 RIQS5 KOKRS TKA01 KOKRS REF C CN
12 RIQS5 OBJNR_REAL ONR00 OBJNR REF    
13 RIQS5 OBJNR_STAT ONR00 OBJNR REF    
History
Last changed by/on SAP  20130529 
SAP Release Created in