SAP Table ESTVH
EHS: Specification - Value Assignment Type Assignment
ESTVH (EHS: Specification - Value Assignment Type Assignment) 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 ESTVH to other SAP tables.
ESTVH table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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 | ||||||||
|
||||||||||||
|
PARKFLG
Data Record Is Inactive
|
ESEPARKFLG |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
|
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 | ||||||||
|
ESTCAT
Value Assignment Type
|
ESEESTCAT | TCG11 |
CHAR
|
30 | 0 | |||||||
|
COUNTER
General Auxiliary Counter
|
ESECOUNTER |
NUMC
|
10 | 0 | ||||||||
ESTVH foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| ESTVH | AENNR | SY | MANDT |
AENR
Change Master
|
MANDT |
| ESTVH | AENNR | ESTVH | AENNR |
AENR
Change Master
|
AENNR |
| ESTVH | ESTCAT | ESTVH | MANDT |
TCG11
EHS: Value Assignment Type
|
MANDT |
| ESTVH | ESTCAT | ESTVH | ESTCAT |
TCG11
EHS: Value Assignment Type
|
ESTCAT |
| ESTVH | MANDT | ESTVH | MANDT |
T000
Clients
|
MANDT |
| ESTVH | SRSID | ESTVH | SRSID |
TCG56
EHS: Data Origin
|
SRSID |
| ESTVH | SRSID | * |
TCG56
EHS: Data Origin
|
MANDT |