SAP Table EHQMT_BASIC_DATA
EH&S-QM: Basic Data for Inspection Plans
EHQMT_BASIC_DATA (EH&S-QM: Basic Data for Inspection Plans) 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_BASIC_DATA to other SAP tables.
EHQMT_BASIC_DATA table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||
| ID | Character field of length 12 | CHAR012 | CHAR | 12 | 0 | |||||||
| ORD | 5 Character Numeric NUMC | NUMC5 | NUMC | 5 | 0 | |||||||
| RECN | Sequential Number of Data Record | ESERECN | NUMC | 20 | 0 | |||||||
| SUBID | Specification | ESESUBID | CHAR | 12 | 0 | |||||||
| VALDAT | Key Date | ESEDIAGVD | DATS | 8 | 0 | |||||||
| AENNR | Change Number | AENNR | AENR | CHAR | 12 | 0 | ||||||
| MATNR | Material Number | MATNR | MARA | CHAR | 18 | 0 | ||||||
| VACLID | Rating | ESEVACLID | TCG86 | CHAR | 10 | 0 | ||||||
| WERKS | Plant | WERKS_D | T001W | CHAR | 4 | 0 | ||||||
| KUNNR | Account Number of Customer | EKUNN | KNA1 | CHAR | 10 | 0 | ||||||
| LIFNR | Vendor Account Number | ELIFN | LFA1 | CHAR | 10 | 0 | ||||||
| ALLVACL | EH&S-QM: Group All Ratings | EHQME_ALLVACL | CHAR | 1 | 0 |
Possible values
|
||||||
EHQMT_BASIC_DATA foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| EHQMT_BASIC_DATA | AENNR | SYST | MANDT | AENR | Change Master | MANDT |
| EHQMT_BASIC_DATA | AENNR | EHQMT_BASIC_DATA | AENNR | AENR | Change Master | AENNR |
| EHQMT_BASIC_DATA | KUNNR | SYST | MANDT | KNA1 | General Data in Customer Master | MANDT |
| EHQMT_BASIC_DATA | KUNNR | EHQMT_BASIC_DATA | KUNNR | KNA1 | General Data in Customer Master | KUNNR |
| EHQMT_BASIC_DATA | LIFNR | SYST | MANDT | LFA1 | Vendor Master (General Section) | MANDT |
| EHQMT_BASIC_DATA | LIFNR | EHQMT_BASIC_DATA | LIFNR | LFA1 | Vendor Master (General Section) | LIFNR |
| EHQMT_BASIC_DATA | MANDT | EHQMT_BASIC_DATA | MANDT | T000 | Clients | MANDT |
| EHQMT_BASIC_DATA | MATNR | SYST | MANDT | MARA | General Material Data | MANDT |
| EHQMT_BASIC_DATA | MATNR | EHQMT_BASIC_DATA | MATNR | MARA | General Material Data | MATNR |
| EHQMT_BASIC_DATA | VACLID | SYST | MANDT | TCG86 | EHS: Characteristic rating | MANDT |
| EHQMT_BASIC_DATA | VACLID | EHQMT_BASIC_DATA | VACLID | TCG86 | EHS: Characteristic rating | VACLID |
| EHQMT_BASIC_DATA | WERKS | SYST | MANDT | T001W | Plants/Branches | MANDT |
| EHQMT_BASIC_DATA | WERKS | EHQMT_BASIC_DATA | WERKS | T001W | Plants/Branches | WERKS |
