SAP Table ALM_ME_NOTIFICATION_ITEM
Work Table for Notification Item
ALM_ME_NOTIFICATION_ITEM (Work Table for Notification Item) 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 ALM_ME_NOTIFICATION_ITEM to other SAP tables.
ALM_ME_NOTIFICATION_ITEM table fields
Field | Data element | Checktable | Datatype | Length | Decimals | |||
---|---|---|---|---|---|---|---|---|
NOTIF_NO | Notification No | QMNUM | QMEL | CHAR | 12 | 0 | ||
ITEM_KEY | Item Number in Item Record | FELFD | QMFE | NUMC | 4 | 0 | ||
CREATED_BY | Name of Person who Created the Object | ERNAM | CHAR | 12 | 0 | |||
CREATED_DATE | Date on Which Record Was Created | ERDAT | DATS | 8 | 0 | |||
CHANGED_BY | Name of Person Who Changed Object | AENAM | CHAR | 12 | 0 | |||
CHANGED_DATE | Changed On | AEDAT | DATS | 8 | 0 | |||
DESCRIPT | Notification Item Short Text | FETXT | CHAR | 40 | 0 | |||
D_CAT_TYP | Catalog Type - Problems/Defects | FEKAT | TQ15 | CHAR | 1 | 0 | ||
D_CODEGRP | Code Group - Problem | FEGRP | QPGR | CHAR | 8 | 0 | ||
D_CODE | Problem or Damage Code | FECOD | QPCD | CHAR | 4 | 0 | ||
DL_CAT_TYP | Catalog Type - Object Parts | OTKAT | TQ15 | CHAR | 1 | 0 | ||
DL_CODEGRP | Code Group - Object Parts | OTGRP | QPGR | CHAR | 8 | 0 | ||
DL_CODE | Part of Object | OTEIL | QPCD | CHAR | 4 | 0 | ||
ASSEMBLY | Assembly | BAUTL | MARA | CHAR | 18 | 0 | ||
LONG_TEXT | Object Long Text Available | INDLTX | CHAR | 1 | 0 | |||
PRILANG | Primary language indicator for text segment | KZMLA | CHAR | 1 | 0 | |||
POS_TIME | Time, at Which Record Was Added | ERZEIT | TIMS | 6 | 0 | |||
CHANGE_TIME | Time of Change | AEZEIT | TIMS | 6 | 0 | |||
DELETE_FLAG | Delete Data Record | KZLOESCH | CHAR | 1 | 0 | |||
ITEM_SORT_NO | Sort Number for Item | QLFDPOS | NUMC | 4 | 0 | |||
STXT_GRPCD | Short Description of the Code Group | QKTEXTGR | CHAR | 40 | 0 | |||
TXT_PROBCD | Problem Code Short Text | TXTCDFE | CHAR | 40 | 0 | |||
TXT_GRPCD | Short Description of the Code Group | QKTEXTGR | CHAR | 40 | 0 | |||
TXT_OBJPTCD | Object Part Code Short Text | TXTCDOT | CHAR | 40 | 0 | |||
CLASSIF | Classification | FRKLS | CHAR | 18 | 0 | |||
CLASSIF_DESC | Class Description | KLSBEZ | CHAR | 40 | 0 | |||
INTCLASSNR | Internal Class Number | CLINT | NUMC | 10 | 0 | |||
TXT_PART | Character field of length 40 | CHAR40 | CHAR | 40 | 0 | |||
CLASS_TYPE | Class Type | KLASSENART | CHAR | 3 | 0 |
ALM_ME_NOTIFICATION_ITEM foreign key relationships
Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
---|---|---|---|---|---|---|
ALM_ME_NOTIFICATION_ITEM | ASSEMBLY | SYST | MANDT | MARA | General Material Data | MANDT |
ALM_ME_NOTIFICATION_ITEM | ASSEMBLY | ALM_ME_NOTIFICATION_ITEM | ASSEMBLY | MARA | General Material Data | MATNR |
ALM_ME_NOTIFICATION_ITEM | DL_CAT_TYP | ALM_ME_NOTIFICATION_ITEM | DL_CAT_TYP | TQ15 | Inspection catalog type index | KATALOGART |
ALM_ME_NOTIFICATION_ITEM | DL_CAT_TYP | SYST | MANDT | TQ15 | Inspection catalog type index | MANDT |
ALM_ME_NOTIFICATION_ITEM | DL_CODE | ALM_ME_NOTIFICATION_ITEM | DL_CAT_TYP | QPCD | Inspection catalog codes | KATALOGART |
ALM_ME_NOTIFICATION_ITEM | DL_CODE | ALM_ME_NOTIFICATION_ITEM | DL_CODEGRP | QPCD | Inspection catalog codes | CODEGRUPPE |
ALM_ME_NOTIFICATION_ITEM | DL_CODE | ALM_ME_NOTIFICATION_ITEM | DL_CODE | QPCD | Inspection catalog codes | CODE |
ALM_ME_NOTIFICATION_ITEM | DL_CODE | * | QPCD | Inspection catalog codes | VERSION | |
ALM_ME_NOTIFICATION_ITEM | DL_CODE | SYST | MANDT | QPCD | Inspection catalog codes | MANDT |
ALM_ME_NOTIFICATION_ITEM | DL_CODEGRP | ALM_ME_NOTIFICATION_ITEM | DL_CODEGRP | QPGR | Inspection catalog code groups | CODEGRUPPE |
ALM_ME_NOTIFICATION_ITEM | DL_CODEGRP | SYST | MANDT | QPGR | Inspection catalog code groups | MANDT |
ALM_ME_NOTIFICATION_ITEM | DL_CODEGRP | ALM_ME_NOTIFICATION_ITEM | DL_CAT_TYP | QPGR | Inspection catalog code groups | KATALOGART |
ALM_ME_NOTIFICATION_ITEM | D_CAT_TYP | SYST | MANDT | TQ15 | Inspection catalog type index | MANDT |
ALM_ME_NOTIFICATION_ITEM | D_CAT_TYP | ALM_ME_NOTIFICATION_ITEM | D_CAT_TYP | TQ15 | Inspection catalog type index | KATALOGART |
ALM_ME_NOTIFICATION_ITEM | D_CODE | ALM_ME_NOTIFICATION_ITEM | D_CODEGRP | QPCD | Inspection catalog codes | CODEGRUPPE |
ALM_ME_NOTIFICATION_ITEM | D_CODE | ALM_ME_NOTIFICATION_ITEM | D_CODE | QPCD | Inspection catalog codes | CODE |
ALM_ME_NOTIFICATION_ITEM | D_CODE | * | QPCD | Inspection catalog codes | VERSION | |
ALM_ME_NOTIFICATION_ITEM | D_CODE | SYST | MANDT | QPCD | Inspection catalog codes | MANDT |
ALM_ME_NOTIFICATION_ITEM | D_CODE | ALM_ME_NOTIFICATION_ITEM | D_CAT_TYP | QPCD | Inspection catalog codes | KATALOGART |
ALM_ME_NOTIFICATION_ITEM | D_CODEGRP | SYST | MANDT | QPGR | Inspection catalog code groups | MANDT |
ALM_ME_NOTIFICATION_ITEM | D_CODEGRP | ALM_ME_NOTIFICATION_ITEM | D_CAT_TYP | QPGR | Inspection catalog code groups | KATALOGART |
ALM_ME_NOTIFICATION_ITEM | D_CODEGRP | ALM_ME_NOTIFICATION_ITEM | D_CODEGRP | QPGR | Inspection catalog code groups | CODEGRUPPE |
ALM_ME_NOTIFICATION_ITEM | ITEM_KEY | SYST | MANDT | QMFE | Quality notification - items | MANDT |
ALM_ME_NOTIFICATION_ITEM | ITEM_KEY | ALM_ME_NOTIFICATION_ITEM | NOTIF_NO | QMFE | Quality notification - items | QMNUM |
ALM_ME_NOTIFICATION_ITEM | ITEM_KEY | ALM_ME_NOTIFICATION_ITEM | ITEM_KEY | QMFE | Quality notification - items | FENUM |
ALM_ME_NOTIFICATION_ITEM | NOTIF_NO | ALM_ME_NOTIFICATION_ITEM | NOTIF_NO | QMEL | Quality Notification | QMNUM |
ALM_ME_NOTIFICATION_ITEM | NOTIF_NO | SYST | MANDT | QMEL | Quality Notification | MANDT |