ESTVP

Value Assignment Item | #masterdata | Component: Product Safety
Column Name Description
MANDT FK Client
RECN Sequential Number of Data Record
ACTN Sequential Number of the Change State
Column Name Description
Column Name Description
Column Name Description
VALFR Valid-From Date
VALTO Valid-To Date
CRDAT Created On
UPDDAT Last Changed On
UPD_CMP Date of Last Change to Component
Column Name Description
DELFLG Deletion Indicator Show values
PARKFLG Data Record Is Inactive Show values
PRECL Operator for Lower Limit Show values
PRECU Operator for Upper Limit Show values
PREF_ALT Preferred Alternative Show values
NOT_REL_FOR_CHCK Not Relevant for Check Show values
Column Name Description Domain name
CRNAM Created By USNAM
UPDNAM Last Changed By USNAM
RECNTVA Reference to RECN for Tables ESTVA, ESTRH and ESTRI ESDRECN
RECNCMP Reference to Specification Header of a Component ESDRECN
COMPLOW Lower Limit of a Component Proportion ESDDEC6_4
COMPUPP Upper limit of a component proportion ESDDEC6_4
COMPAVG Target Value or Actual Value of a Component ESDDEC6_4
ORD Sort Order NUMC4
COMPLOWDEC Decimal Places for the Concentration of a Component INT4
COMPUPPDEC Decimal Places for the Concentration of a Component INT4
COMPAVGDEC Decimal Places for the Concentration of a Component INT4
MATNR Material Number MATNR
ALPGR Alternative item: group CHAR2
NOT_REL_FOR_REG Not Relevant for Registration (Obsolete)
Master Data Relations Join Conditions
Change Number
  • Change Number
  • Client
  • ESTVP.AENNR == AENR.AENNR
  • ESTVP.MANDT == AENR.MANDT
Component Type
  • ESTVP.MANDT == TCG76.MANDT
  • ESTVP.COMPCAT == TCG76.COMPCAT
Exception Value of a Component
  • Exception Value of a Component
  • Client
  • ESTVP.COMPEXCVAL == TCG78.COMPEXCVAL
  • ESTVP.MANDT == TCG78.MANDT
EHS: Foreign key for units of measurement
  • ESTVP.MANDT == T006.MANDT
  • ESTVP.COMPEXP == T006.MSEHI
Client ESTVP.MANDT == T000.MANDT
EHS: Foreign Key for Substance Authorization Group
  • ESTVP.MANDT == TCG56.MANDT
  • ESTVP.SRSID == TCG56.SRSID