SAP table QPMT (Master Inspection Characteristics Texts)
SAP table QPMT has 5 primary key fields being MANDT,ZAEHLER,MKMNR,VERSION,SPRACHE.
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 | |
| ZAEHLER | Plant for the Master Inspection Characteristic | CHAR | 4 | 0 | QZAEHLER | ||
| MKMNR | Master Inspection Characteristic | CHAR | 8 | 0 | QPMK | QMERKNR | |
| VERSION | Version Number of Inspection Method | CHAR | 6 | 0 | QVERSNRPM | ||
| SPRACHE | Language Key | LANG | 1 | 0 | T002 | SPRAS | |
| GUELTIGAB | Valid-From Date | DATS | 8 | 0 | DATUV | ||
| KURZTEXT | Short Text | CHAR | 40 | 0 | QKURZTEXT | ||
| LTEXTKZ | Long Text Exists for the Characteristic | CHAR | 1 | 0 | QLTEXTMK | ||
| LTEXTEKZ | Long Text for Sample Drawing of a Characteristic | CHAR | 1 | 0 | QLTEXTEKZ | ||
| GELOESCHT | Data Record Was Deleted | CHAR | 1 | 0 | QGEL |
QPMT foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 QPMT | MKMNR | QPMK | Inspection characteristic master | MANDT |
| 0 QPMT | MKMNR | QPMK | Inspection characteristic master | ZAEHLER |
| 0 QPMT | MKMNR | QPMK | Inspection characteristic master | VERSION |
| 1 QPMT | SPRACHE | T002 | Language Keys (Component BC-I18) | SPRAS |