The ESTVP table in SAP ERP or S/4HANA stores Value Assignment Item data. There are total 34 fields in ESTVP table. The Value Assignment Item table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of ESTVP table. It is in Company Environment Information System (CBUI) ABAP package and is part of the Product Safety (EHS-SAF) module.
SAP ESTVP Table Fields
Following is the list of fields that are available in SAP ESTVP table. The primary key fields of the table are MANDT (Client), RECN (Sequential Number of Data Record), ACTN (Sequential Number of the Change State).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT (3) |
| RECN | Sequential Number of Data Record | ESERECN | NUMC (20) | |
| ACTN | Sequential Number of the Change State | ESEACTN | NUMC (20) | |
| VALFR | Valid-From Date | ESEVALFR | DATS (8) | |
| VALTO | Valid-To Date | ESEVALTO | DATS (8) | |
| AENNR | Change Number | ESEAENNR | AENR | CHAR (12) |
| DELFLG | Deletion Indicator | ESEDELFLG | CHAR (1) | |
| PARKFLG | Data Record Is Inactive | ESEPARKFLG | CHAR (1) | |
| CRDAT | Created On | ESECRDAT | DATS (8) | |
| CRNAM | Created By | ESECRNAM | CHAR (12) | |
| UPDDAT | Last Changed On | ESEUPDDAT | DATS (8) | |
| UPDNAM | Last Changed By | ESEUPDNAM | CHAR (12) | |
| SRSID | Source of Data | ESESRSID | TCG56 | CHAR (10) |
| OWNID | Data Provider | ESEVENDRID | * | CHAR (10) |
| RECNROOT | Sequential Number of Data Record | ESERECN | * | NUMC (20) |
| RECNTVA | Reference to RECN for Tables ESTVA, ESTRH and ESTRI | ESERECNTVA | NUMC (20) | |
| COMPCAT | Component Type | ESECOMPCAT | TCG76 | CHAR (10) |
| RECNCMP | Reference to Specification Header of a Component | ESERECNCMP | NUMC (20) | |
| PRECL | Operator for Lower Limit | ESEPRECL | CHAR (5) | |
| COMPLOW | Lower Limit of a Component Proportion | ESECOMPLOW | DEC (10) | |
| PRECU | Operator for Upper Limit | ESEPRECU | CHAR (5) | |
| COMPUPP | Upper limit of a component proportion | ESECOMPUPP | DEC (10) | |
| COMPAVG | Target Value or Actual Value of a Component | ESECOMPAVG | DEC (10) | |
| COMPEXP | Unit for Quantity Specification | ESECOMPEXP | T006 | UNIT (3) |
| ORD | Sort Order | ESEORD | NUMC (4) | |
| COMPLOWDEC | Decimal Places for the Concentration of a Component | ESECOMPNUMDEC | INT4 (10) | |
| COMPUPPDEC | Decimal Places for the Concentration of a Component | ESECOMPNUMDEC | INT4 (10) | |
| COMPAVGDEC | Decimal Places for the Concentration of a Component | ESECOMPNUMDEC | INT4 (10) | |
| COMPEXCVAL | Exception Value of a Component | ESECOMPEXCVAL | TCG78 | CHAR (2) |
| UPD_CMP | Date of Last Change to Component | ESEUPD_CMP | DATS (8) | |
| MATNR | Material Number | MATNR | * | CHAR (40) |
| ALPGR | Alternative item: group | CS_ALPGR | CHAR (2) | |
| PREF_ALT | Preferred Alternative | EHPRC_PREF_ALT | CHAR (1) | |
| NOT_REL_FOR_CHCK | Not Relevant for Check | EHPRC_FLG_NOT_REL_FOR_CHCK | CHAR (1) |
