Fact table monitor — the request-monitor status table for InfoCube data loads: one row per request (RNR, the technical request ID also seen as 0REQUID in query/InfoCube data) and data packet (DP_NR) posted into an InfoCube's fact table, carrying the record counts at each stage of the update pipeline (selected, sent, converted, updated, inserted, errored, not-updated, and routed-to-ODS) plus the number of cubes the packet was posted to (ANZ_CUBES), the target InfoCube's internal ID (IC_ID), the packet-source type (IDOC_ODS_TYP) and IDoc number for IDoc-based loads, and a message/caller reference for the monitor's status log entry. This is the table BW's load-monitor (transaction RSMO) reads to show green/yellow/red request status; it is the audit trail proving how many records a given load actually moved into a fact table, independent of the fact table's own content.
Hover a canonical name to see the legacy SAP field name
| Canonical name | Concept | Description | Data element | Type | Check table |
|---|---|---|---|---|---|
| NUM key | numerus | Request number for the data transfer | RSREQUNR | CHAR 30 | — |
| NUM2 key | numerus | Data packet number | RSDATAPID | NUMC 6 | — |
| TMP_FRM | tempus forma | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | RSTIMESTMP | DEC 15 | — |
| NUM3 | numerus | Number of Selected Data Records (Absolute) | RSNUMRECORD | INT4 10 | — |
| NUM4 | numerus | Number of Sent Data Records (Absolute) | RSNUMRECORD | INT4 10 | — |
| NUM5 | numerus | Number of Converted Data Records (Absolute) | RSNUMRECORD | INT4 10 | — |
| NUM6 | numerus | Number of Data Records Passed On (Absolute) | RSNUMRECORD | INT4 10 | — |
| NUM7 | numerus | Number of Updated Data Records (Absolute) | RSNUMRECORD | INT4 10 | — |
| NUM8 | numerus | Number of Inserted Data Records (Absolute) | RSNUMRECORD | INT4 10 | — |
| NUM9 | numerus | Number of Erroneous Data Records (Absolute) | RSNUMRECORD | INT4 10 | — |
| NUM10 | numerus | Number of Data Records Not Updated (Absolute) | RSNUMRECORD | INT4 10 | — |
| NUM11 | numerus | Number of Data Records Routed to the ODS (Absolute) | RSNUMRECORD | INT4 10 | — |
| NUM12 | numerus | Number of InfoCubes the data packet was posted to | NUM10 | NUMC 10 | — |
| IC_ID | InfoCube ID | RSINFOC_ID | NUMC 10 | — | |
| GEN | genus | Data packet type (IDoc, ODS, old method ...) | RSDP_TYP | CHAR 1 | — |
| NUM13 | numerus | IDoc number | EDI_DOCNUM | NUMC 16 | — |
| MESS_ID | Message ID | RSMESS_ID | NUMC 10 | — | |
| RSCALLER | Caller | RSCALLER | CHAR 2 | — | |
| IDX | index | Single-Character Indicator | CHAR1 | CHAR 1 | — |