ESTESCD_INB_SUBS

Inbound Staging Area - Substance Information | #transactional | Component: Exposure Scenario Management
Column Name Description
MANDT Client
RECN Sequential Number of Data Record
Column Name Description
Column Name Description
Column Name Description
Column Name Description
OBSOLETE_IND Obsolete Show values
Column Name Description Domain name
CRTIMESTAMP_UTC Created On TZNTSTMPS
CRNAM Created By USNAM
UPDTIMESTAMP_UTC Changed On TZNTSTMPS
UPDNAM Last Changed By USNAM
XML_SUBSTANCE_NAME Substance Name from ESComXML File
XML_EC_NUMBER EC Number of Self-Registered Substance from ESComXML File CHAR9
XML_CAS_NUMBER CAS Number of Self-Registered Substance from ESComXML File CHAR12
XML_REACH_REG_NO REACH Registration Number of Substance from ESComXML File ESEESC_REACH_REG_NUMBER
EHS_PURE_SUB_SUBID Specification of Pure Subst. with ESComXML Assign. (SelfReg) ESDSUBID
Master Data Relations Join Conditions
Record Number of Pure Substance with ESComXML Assignment
  • Record Number of Pure Substance with ESComXML Assignment
  • ?
  • ESTESCD_INB_SUBS.EHS_PURE_SUB_RECN == ESTRH.MANDT
  • ESTESCD_INB_SUBS.[column in domain "ESERECN"] == ESTRH.RECN