SAP table QMMA (Quality notification - activities)
SAP table QMMA has 3 primary key fields being MANDT,QMNUM,MANUM.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| QMNUM | Notification Number | CHAR | 12 | 0 | QMEL | QMNUM | |
| MANUM | Consecutive Number of Activity | NUMC | 4 | 0 | AKNUM | ||
| FENUM | Item Number in Item Record | NUMC | 4 | 0 | QMFE | FELFD | |
| URNUM | Sequential Number for Cause | NUMC | 4 | 0 | URNUM | ||
| MNKAT | Catalog Type - Activities | CHAR | 1 | 0 | TQ15 | MFKAT | |
| MNGRP | Activity Code Group | CHAR | 8 | 0 | QPGR | MFGRP | |
| MNCOD | Activity Code | CHAR | 4 | 0 | MFCOD | ||
| MNVER | Version Number | CHAR | 6 | 0 | QVERSNR | ||
| MATXT | Activity Text | CHAR | 40 | 0 | MFTEXT | ||
| ERNAM | Name of Person Responsible for Creating the Object | CHAR | 12 | 0 | ERNAM | ||
| ERDAT | Date on which the record was created | DATS | 8 | 0 | ERDAT | ||
| AENAM | Name of Person Who Changed Object | CHAR | 12 | 0 | AENAM | ||
| AEDAT | Last Changed On | DATS | 8 | 0 | AEDAT | ||
| MAKLS | Task Class | CHAR | 18 | 0 | MAKLS | ||
| KLAKZ | Indicator: Classification exists | CHAR | 1 | 0 | KLAKZ | ||
| PSTER | Activity Start Date | DATS | 8 | 0 | PSTERMA | ||
| PETER | Activity End Date | DATS | 8 | 0 | PETERMA | ||
| INDTX | Object Long Text Available | CHAR | 1 | 0 | INDLTX | ||
| KZMLA | Primary language indicator for text segment | CHAR | 1 | 0 | KZMLA | ||
| MNGFA | Quantity Factor for Activities | NUMC | 3 | 0 | MNGFA | ||
| PSTUR | Start Time of Activity | TIMS | 6 | 0 | PSTURMA | ||
| PETUR | End Time of Activity | TIMS | 6 | 0 | PETURMA | ||
| ERZEIT | Time at Which Record Was Added | TIMS | 6 | 0 | ERZEIT | ||
| AEZEIT | Time of Change | TIMS | 6 | 0 | AEZEIT | ||
| KZLOESCH | Delete Data Record | CHAR | 1 | 0 | KZLOESCH | ||
| QMANUM | Sort Number for Activity | NUMC | 4 | 0 | QMANUM | ||
| AUTKZ | Data Record Created with Function 'Create with Copy Model' | CHAR | 1 | 0 | QAUTKZ | ||
| KZACTIONBOX | Created Using Action Box | CHAR | 1 | 0 | QNKZACTIONBOX | ||
| FUNKTION | Keys for Function in Action Box | CHAR | 4 | 0 | QNFUNKTION | ||
| CHANGEDDATETIME | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | DEC | 15 | 0 | TZNTSTMPS | ||
| DUMMY_QMMA_INCL_EEW_PS | Dummy function in length 1 | CHAR | 1 | 0 | DUMMY |
QMMA foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 QMMA | FENUM | QMFE | Quality notification - items / Defect | MANDT |
| 1 QMMA | MNGRP | QPGR | Inspection catalog code groups | MANDT |
| 1 QMMA | MNGRP | QPGR | Inspection catalog code groups | KATALOGART |
| 0 QMMA | MNKAT | TQ15 | Inspection catalog type index | KATALOGART |
| 1 QMMA | QMNUM | QMEL | Quality Notification | MANDT |
| 1 QMMA | QMNUM | QMEL | Quality Notification | QMNUM |