SAP Table EHQMT_MAIN2
EH&S-QM: Characteristics for Inspection Plan Creation
EHQMT_MAIN2 (EH&S-QM: Characteristics for Inspection Plan Creation) 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 EHQMT_MAIN2 to other SAP tables.
EHQMT_MAIN2 table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||
| RECN | Sequential Number of Data Record | ESERECN | NUMC | 20 | 0 | |||||||
| ACTN | Sequential Number of the Change State | ESEACTN | NUMC | 20 | 0 | |||||||
| VALFR | Valid-From Date | ESEVALFR | DATS | 8 | 0 | |||||||
| VALTO | Valid-To Date | ESEVALTO | DATS | 8 | 0 | |||||||
| AENNR | Change Number | ESEAENNR | AENR | CHAR | 12 | 0 | ||||||
| DELFLG | Deletion Indicator | ESEDELFLG | CHAR | 1 | 0 |
Possible values
|
||||||
| PARKFLG | Data Record Is Inactive | ESEPARKFLG | CHAR | 1 | 0 |
Possible values
|
||||||
| CRDAT | Created On | ESECRDAT | DATS | 8 | 0 | |||||||
| CRNAM | Created By | ESECRNAM | CHAR | 12 | 0 | |||||||
| UPDDAT | Changed On | ESEUPDDAT | DATS | 8 | 0 | |||||||
| UPDNAM | Last Changed By | ESEUPDNAM | CHAR | 12 | 0 | |||||||
| SRSID | Source of Data | ESESRSID | TCG56 | CHAR | 10 | 0 | ||||||
| OWNID | Data Provider | ESEVENDRID | CHAR | 10 | 0 | |||||||
| RECNROOT | Sequential Number of Data Record | ESERECN | NUMC | 20 | 0 | |||||||
| ATNAM | Characteristic Name | EHQME_ATNAM2 | CHAR | 30 | 0 | |||||||
| CTYPE | EH&S-QM: Type of Characteristic | EHQME_CTYPE | EHQMT_CHARTYPE | CHAR | 1 | 0 | ||||||
| MKMNR | Master Inspection Characteristics | QMERKNR | QPMK | CHAR | 8 | 0 | ||||||
| ZAEHLER | Plant for the Master Inspection Characteristic | QZAEHLER | CHAR | 4 | 0 | |||||||
EHQMT_MAIN2 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| EHQMT_MAIN2 | AENNR | SY | MANDT | AENR | Change Master | MANDT |
| EHQMT_MAIN2 | AENNR | EHQMT_MAIN2 | AENNR | AENR | Change Master | AENNR |
| EHQMT_MAIN2 | CTYPE | EHQMT_MAIN2 | MANDT | EHQMT_CHARTYPE | EH&S-QM: Types of Characteristics | MANDT |
| EHQMT_MAIN2 | CTYPE | EHQMT_MAIN2 | CTYPE | EHQMT_CHARTYPE | EH&S-QM: Types of Characteristics | CTYPE |
| EHQMT_MAIN2 | MANDT | EHQMT_MAIN2 | MANDT | T000 | Clients | MANDT |
| EHQMT_MAIN2 | MKMNR | EHQMT_MAIN2 | MANDT | QPMK | Inspection characteristic master | MANDT |
| EHQMT_MAIN2 | MKMNR | EHQMT_MAIN2 | ZAEHLER | QPMK | Inspection characteristic master | ZAEHLER |
| EHQMT_MAIN2 | MKMNR | EHQMT_MAIN2 | MKMNR | QPMK | Inspection characteristic master | MKMNR |
| EHQMT_MAIN2 | MKMNR | * | QPMK | Inspection characteristic master | VERSION | |
| EHQMT_MAIN2 | SRSID | EHQMT_MAIN2 | SRSID | TCG56 | EHS: Data Origin | SRSID |
| EHQMT_MAIN2 | SRSID | * | TCG56 | EHS: Data Origin | MANDT | |
