Generated Table for View — the notification view joining the QMEL notification header with equipment, functional-location, order, maintenance-plan, and organizational master data. This is the notification-reporting surface that any reliability, breakdown, or maintenance-KPI analysis reads from, since it flattens the object hierarchy (equipment/functional-location/order) onto the notification record. SAP's real view carries 250+ fields (it re-exposes most of the QMEL header plus joined reference fields from EQUI/IFLOT/AUFK/MPLA/organizational tables); this definition is scoped to the full key, notification classification and priority fields, all scheduling/reported dates, the equipment/functional-location/order/plan linkage fields, and the core organizational fields a crosswalk or failure-cause analysis (QMMA/QMUR) depends on — never silently truncate beyond that scope.
Hover a canonical name to see the legacy SAP field name
| Canonical name | Concept | Description | Data element | Type | Check table |
|---|---|---|---|---|---|
| CLI key | cliens | Client | MANDT | CLNT 3 | T000 |
| NTS_NUM key | nuntius numerus | Notification Number | QMNUM | CHAR 12 | — |
| NTS_GEN | nuntius genus | Notification type | QMART | CHAR 2 | TQ80 |
| NTS_TXT | nuntius textus | Notification short text | QMTXT | CHAR 40 | — |
| NTS_ORG | nuntius origo | Notification origin | ARTPR | CHAR 2 | T356A |
| PRI_GEN | prioritas genus | Priority type | PRIOK | CHAR 2 | T356 |
| PRI | prioritas | Priority | PRIOX | CHAR 1 | — |
| NOM_PSN_CRE | nomen persona creatus | Name of Person who Created the Object | ERNAM | CHAR 12 | — |
| DIE_TBL_CRE | dies tabula creatus | Date on which the record was created | ERDAT | DATS 8 | — |
| NOM_PSN_MUT | nomen persona mutatus | Name of Person Who Changed Object | AENAM | CHAR 12 | — |
| MUT | mutatus | Changed On | AEDAT | DATS 8 | — |
| DIE_NTS_CRE | dies nuntius creatus | Date notification created (in header) | QMDAT | DATS 8 | — |
| TMP_NTS_CRE | tempus nuntius creatus | Time notification created | MZEIT | TIMS 6 | — |
| INI_DIE | initium dies | Required start date | STRMN | DATS 8 | — |
| INI_TMP | initium tempus | Required start time | STRUR | TIMS 6 | — |
| FIN_DIE | finis dies | Required end date | LTRMN | DATS 8 | — |
| FIN_TMP | finis tempus | Required end time | LTRUR | TIMS 6 | — |
| INI_DIE2 | initium dies | Malfunction start date | MDDAT | DATS 8 | — |
| TMP | tempus | Time of malfunction | MDZET | TIMS 6 | — |
| FIN_DIE2 | finis dies | Malfunction end date | MEDAT | DATS 8 | — |
| FIN_TMP2 | finis tempus | Malfunction end time | METIM | TIMS 6 | — |
| MRA | mora | Breakdown duration | MADUR | DEC 12,3 | — |
| TMP_UNI_MRA | tempus unitas mora | Time unit for breakdown duration | MAUEH | UNIT 3 | T006 |
| OBI_STA_TXT | obiectum status textus | Object status short text (system status) | J_STTXT | CHAR 40 | — |
| OBI_NUM_STA | obiectum numerus status | Object number (status management) | J_OBJNR | CHAR 22 | ONR00 |
| INM_NUM | instrumentum numerus | Equipment Number | EQUNR | CHAR 18 | EQUI |
| MAT_NUM_OBI | materia numerus obiectum | Assembly (material number of technical object) | TEXTBAUTL | CHAR 18 | MARA |
| LCF | locus functionalis | Functional Location | TPLNR | CHAR 30 | IFLOT |
| LCF_CLV | locus functionalis clavis | Functional location (internal key) | ILOAN | NUMC 8 | ILOA |
| MND_NUM | mandatum numerus | Order Number | AUFNR | CHAR 12 | AUFK |
| CCU | consilium curationis | Maintenance Plan | WARPL | NUMC 12 | MPLA |
| MAT_NUM | materia numerus | Material Number | MATNR | CHAR 18 | MARA |
| NSR | numerus serialis | Serial number | GERNR | CHAR 18 | — |
| EMP_NUM | emptor numerus | Customer Number | KUNUM | CHAR 10 | KNA1 |
| RBNR | Catalog profile | QRBNR | CHAR 8 | T352B | |
| GEN | genus | Catalog type for coding | QMKAT | CHAR 1 | — |
| NTS_COD_CTS | nuntius codex coetus | Notification: code group | QMGRP | CHAR 8 | QPGR |
| NTS | nuntius | Notification: coding | QMCOD | CHAR 4 | — |
| AMD | area moderationis | Controlling Area | KOKRS | CHAR 4 | TKA01 |
| CSM | centrum sumptus | Cost Center | KOSTL | CHAR 10 | CSKS |
| SOC | codex societatis | Company Code | BUKRS | CHAR 4 | T001 |
| ANG | area negotii | Business Area | GSBER | CHAR 4 | TGSB |
| CUR_CNS_OFC | curatio consilium officina | Maintenance planning plant | IWERK | CHAR 4 | T399I |
| CCS | coetus consiliorum | Planner Group | INGRP | CHAR 3 | T024I |
| OVD | organizatio venditionis | Sales Organization | VKORG | CHAR 4 | TVKO |
| CDS | canalis distributionis | Distribution Channel | VTWEG | CHAR 2 | TVTW |
| DVS | divisio | Division | SPART | CHAR 2 | TSPA |
| NOM_PSN_NTS | nomen persona nuntius | Name of the person who reported the notification | QMNAM | CHAR 12 | — |
| STA | status | Overall status (icon representation) | J_STATUS_ICO | CHAR 4 | — |
Foreign keys
| Field | Check table | Check field |
|---|---|---|
ARTPR | T356A | ARTPR |
AUFNR | AUFK | AUFNR |
BAUTL | MARA | MATNR |
BUKRS | T001 | BUKRS |
EQUNR | EQUI | EQUNR |
GSBER | TGSB | GSBER |
ILOAN | ILOA | ILOAN |
INGRP | T024I | INGRP |
IWERK | T399I | IWERK |
KOKRS | TKA01 | KOKRS |
KOSTL | CSKS | KOSTL |
KUNUM | KNA1 | KUNNR |
MANDT | T000 | MANDT |
MATNR | MARA | MATNR |
MAUEH | T006 | MSEHI |
OBJNR | ONR00 | OBJNR |
PRIOK | T356 | PRIOK |
QMART | TQ80 | QMART |
QMGRP | QPGR | CODEGRUPPE |
RBNR | T352B | RBNR |
SPART | TSPA | SPART |
TPLNR | IFLOT | TPLNR |
VKORG | TVKO | VKORG |
VTWEG | TVTW | VTWEG |
WARPL | MPLA | WARPL |