ESTRI

Identifier (Numbers, Names, Chemical Formulas) | #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
LTXTFLG Long Text Show values
FORMATFLG Formatted Show values
FLG_INHSRC Truth Value Show values
FLG_INHOVR Truth Value Show values
FLG_INHEXCL Truth Value Show values
Column Name Description Domain name
CRNAM Created By USNAM
UPDNAM Last Changed By USNAM
IDENT Identifier TEXT132
IDENTNM Normed identification (upper case, no special characters) CHAR132
ORD Sort Order NUMC4
DOKTL Document Part DOKTL
RECN_TPLH Sequential Number of Data Record ESDRECN
RECNTRI_SRC Sequential Number of Data Record ESDRECN
RECNTRI_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
Foreign Key for Change Number
  • Change Number
  • Client
  • ESTRI.AENNR == AENR.AENNR
  • ESTRI.MANDT == AENR.MANDT
Document Type
  • Document Type
  • Client
  • ESTRI.DOKAR == TDWA.DOKAR
  • ESTRI.MANDT == TDWA.MANDT
Identification Type
  • Identification Category
  • Identification Type
  • ESTRI.MANDT == TCG23.MANDT
  • ESTRI.IDTYPE == TCG23.IDTYPE
  • ESTRI.IDCAT == TCG23.IDCAT
Foreign key for identification category ESTRI.IDTYPE == TCG21.IDTYPE
Foreign Key for Language Identifier ESTRI.LANGU == T002.SPRAS
Foreign Key for Client ESTRI.MANDT == T000.MANDT
EHS: Foreign Key for Substance Authorization Group
  • ESTRI.MANDT == TCG56.MANDT
  • ESTRI.SRSID == TCG56.SRSID