ESTVA

Value Assignment | #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
Column Name Description
DELFLG Deletion Indicator Show values
PARKFLG Data Record Is Inactive Show values
FLG_INHSRC Truth Value Show values
FLG_INHOVR Indicator for Temporary Inheritance Overwriting Show values
FLG_INHEXCL Indicator for Permanent Inheritance Overwriting Show values
Column Name Description Domain name
CRNAM Created By USNAM
UPDNAM Last Changed By USNAM
ORD Sort Order NUMC4
RECN_TPLH Sequential Number of Data Record ESDRECN
RECNTVA_SRC Sequential Number of Data Record ESDRECN
RECNTVA_ORIG Sequential Number of Data Record ESDRECN
RECNROOT_ORIG Sequential Number of Data Record ESDRECN
TPL_ORD Sort Order NUMC4
Master Data Relations Join Conditions
Change Number
  • Change Number
  • Client
  • ESTVA.AENNR == AENR.AENNR
  • ESTVA.MANDT == AENR.MANDT
Reference Value for Component Specification
  • ?
  • Reference Value for Component Specification
  • Client
  • ESTVA.[column in domain "ESECOMPDIMID"] == TCG74.COMPDIMID
  • ESTVA.COMPREL == TCG74.COMPREL
  • ESTVA.MANDT == TCG74.MANDT
Client ESTVA.MANDT == T000.MANDT
EHS: Relationship for Value Assignment Type
  • ?
  • Reference to Value Assignment Header
  • ESTVA.[column in domain "ESERECN"] == ESTVH.RECN
  • ESTVA.RECNTVH == ESTVH.MANDT
EHS: Foreign Key for Substance Authorization Group
  • ESTVA.MANDT == TCG56.MANDT
  • ESTVA.SRSID == TCG56.SRSID