SAP Table UMR_RI200
RMS: Assigned BW Queries
UMR_RI200 (RMS: Assigned BW Queries) 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 UMR_RI200 to other SAP tables.
UMR_RI200 table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||||||||
| GUID_25 | BW Generation tool: GUID in compressed form (CHAR25) | RSSGUID25 | CHAR | 25 | 0 | |||||||||||||
| APP | Application Key | UMC_Y_APPLICATION | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| APPKEY | Technical Name of Application(s) | UMC_Y_APPKEY | CHAR | 15 | 0 | |||||||||||||
| OTYPE | Type of Assigned Object | UMR_Y_OTYPE | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| OKEY | Key of Assigned Object | UMR_Y_OKEY | CHAR | 30 | 0 | |||||||||||||
| SELNO | Selection number | UMC_Y_SELNO | NUMC | 2 | 0 | |||||||||||||
| ISWORKBOOK | Indicator for Workbook | UMC_Y_ISWORKBOOK | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| RFCDEST | RFC Destination | UMC_Y_RFCDEST | CHAR | 32 | 0 | |||||||||||||
| IQUERY | BW Report (BW Internal Display) | UMC_Y_IQUERY | CHAR | 30 | 0 | |||||||||||||
| GENUNIID | Compressed Generic Unique ID of a Query | UMC_Y_QUERY_GENUNIID | CHAR | 25 | 0 | |||||||||||||
| COMPUID | Compressed Generic Unique ID of a Query | UMC_Y_QUERY_COMPUID | CHAR | 25 | 0 | |||||||||||||
UMR_RI200 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| UMR_RI200 | MANDT | UMR_RI200 | MANDT | T000 | Clients | MANDT |
