ESTVP SAP table for – EHS: Value Assignment Item

Here we would like to draw your attention to ESTVP table in SAP. As we know it is being mainly used with the SAP EHS-SAF (Product Safety in EHS) component which is coming under EHS module (Environment, Health and Safety). ESTVP is a SAP standard transp table used for storing EHS: Value Assignment Item related data in SAP. It comes under the package CBUI.

SAP ESTVP table

Table ESTVP technical data

TableESTVP
Data storingEHS: Value Assignment Item
ModuleEHS
Sub ModuleEHS-SAF
SAP PackageCBUI
Delivery ClassA – Application table (master and transaction data)
ComponentEA-APPL
Table CategoryTRANSP

SAP ESTVP Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in ESTVP table.

  • .INCLUDE : EHS: Structure for key info of master data
    Its a key field.
  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • RECN : Sequential Number of Data Record
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 20
  • ACTN : Sequential Number of the Change State
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 20
  • .INCLUDE : EHS: Structure for General Administration Information
  • VALFR : Valid-From Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • VALTO : Valid-To Date
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • AENNR : Change Number
    Its data type is CHAR (Character String) with field length 12
  • DELFLG : Deletion Indicator
    Its data type is CHAR (Character String) with field length 1
  • PARKFLG : Data Record Is Inactive
    Its data type is CHAR (Character String) with field length 1
  • CRDAT : Created On
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • CRNAM : Created By
    Its data type is CHAR (Character String) with field length 12
  • UPDDAT : Changed On
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • UPDNAM : Last Changed By
    Its data type is CHAR (Character String) with field length 12
  • SRSID : Source of Data
    Its data type is CHAR (Character String) with field length 10
  • OWNID : Data Provider
    Its data type is CHAR (Character String) with field length 10
  • RECNROOT : Sequential Number of Data Record
    Its data type is NUMC (Character String with Digits Only) with field length 20
  • RECNTVA : Reference to RECN for Tables ESTVA, ESTRH and ESTRI
    Its data type is NUMC (Character String with Digits Only) with field length 20
  • COMPCAT : Component Type
    Its data type is CHAR (Character String) with field length 10
  • RECNCMP : Reference to Specification Header of a Component
    Its data type is NUMC (Character String with Digits Only) with field length 20
  • PRECL : Operator for Lower Limit
    Its data type is CHAR (Character String) with field length 5
  • COMPLOW : Lower Limit of a Component Proportion
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • PRECU : Operator for Upper Limit
    Its data type is CHAR (Character String) with field length 5
  • COMPUPP : Upper limit of a component proportion
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • COMPAVG : Target Value or Actual Value of a Component
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • COMPEXP : Unit for Quantity Specification
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • ORD : Sort Sequence
    Its data type is NUMC (Character String with Digits Only) with field length 4
  • COMPLOWDEC : Decimal Places for the Concentration of a Component
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • COMPUPPDEC : Decimal Places for the Concentration of a Component
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • COMPAVGDEC : Decimal Places for the Concentration of a Component
    Its data type is INT4 (Four-byte integer – Dictionry type INT4) with field length 10
  • COMPEXCVAL : Exception Value of a Component
    Its data type is CHAR (Character String) with field length 2
  • UPD_CMP : Date of Last Change to Component
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • .INCLU–AP : CP: Append Struktur ESTVP
  • MATNR : Material Number
    Its data type is CHAR (Character String) with field length 18
  • ALPGR : Alternative Item: Group
    Its data type is CHAR (Character String) with field length 2
  • PREF_ALT : Preferred Alternative
    Its data type is CHAR (Character String) with field length 1
  • REC_PROC_ID_COMP : Recycling Process ID
    Its data type is CHAR (Character String) with field length 20
  • DISASSEMBLY_COMP : Disassembly
    Its data type is CHAR (Character String) with field length 1
  • NOT_REL_FOR_REG : Not Relevant for Registration
    Its data type is CHAR (Character String) with field length 1
  • NOT_REL_FOR_CHCK : Not Relevant for Check
    Its data type is CHAR (Character String) with field length 1