ESTRH

Specification Header | #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
UPDDATS Date of Last Change to Specification As a Whole
Column Name Description
DELFLG Deletion Indicator Show values
PARKFLG Data Record Is Inactive Show values
Column Name Description Domain name
CRNAM Created By USNAM
UPDNAM Last Changed By USNAM
UPDNAMS Name of Person Who Last Changed Specification USNAM
SUBID Specification ESDSUBID
REM Note TEXT60
Master Data Relations Join Conditions
Foreign Key for Change Number
  • Change Number
  • Client
  • ESTRH.AENNR == AENR.AENNR
  • ESTRH.MANDT == AENR.MANDT
Authorization Group
  • ESTRH.MANDT == TCG36.MANDT
  • ESTRH.AUTHGRP == TCG36.AUTHGRP
Foreign Key for Client ESTRH.MANDT == T000.MANDT
EHS: Foreign Key for Substance Authorization Group
  • ESTRH.MANDT == TCG56.MANDT
  • ESTRH.SRSID == TCG56.SRSID
Foreign key for substance type
  • ESTRH.MANDT == TCG31.MANDT
  • ESTRH.SUBCAT == TCG31.SUBCAT
Foreign Key for Substance Nature
  • Identification of Substance Nature
  • Client
  • ESTRH.SUBCHAR == TCG34.SUBCHAR
  • ESTRH.MANDT == TCG34.MANDT