ESTPH

EHS: Phrase Header | #masterdata | Component: Environment, Health and Safety: Master Data
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
Column Name Description Domain name
CRNAM Created By USNAM
UPDNAM Last Changed By USNAM
PHRID Phrase ESDPHRID
REM Note TEXT60
USEXNAM Language-Independent User Exit Key ESDUSEXNAM
WERKS Plant for Inspection Method WERKS
Master Data Relations Join Conditions
Change Number
  • Change Number
  • Client
  • ESTPH.AENNR == AENR.AENNR
  • ESTPH.MANDT == AENR.MANDT
Unique phrase library identification
  • ESTPH.MANDT == TCG61.MANDT
  • ESTPH.CATPIN == TCG61.CATPIN
Client ESTPH.MANDT == T000.MANDT
Phrase Group
  • Phrase Group
  • Client
  • Unique phrase library identification
  • ESTPH.PHRGRP == TCG63.PHRGRP
  • ESTPH.MANDT == TCG63.MANDT
  • ESTPH.CATPIN == TCG63.CATPIN
Foreign Key for Check Method
  • ?
  • Inspection Method
  • Client
  • Plant for Inspection Method
  • ESTPH.[column in domain "QVERSNRPM"] == QMTB.VERSION
  • ESTPH.PMTNR == QMTB.PMTNR
  • ESTPH.MANDT == QMTB.MANDT
  • ESTPH.WERKS == QMTB.WERKS
Language
  • Language
  • Client
  • ESTPH.SRLANGU == TCG65.PHRLANG
  • ESTPH.MANDT == TCG65.MANDT
EHS: Foreign Key for Substance Authorization Group
  • ESTPH.MANDT == TCG56.MANDT
  • ESTPH.SRSID == TCG56.SRSID