ESTESCD_INB_ROOT

Inbound Staging Area - Header Information | #header | 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
INBOUND_PROCESSING_STATUS Processing Status of ESComXML Inbound Processing Show values
XML_VERSION_NO Version of ESComXML Data Model Show values
XML_SUBST_MIX_IND Indicator for Substance or Mixture Show values
XML_ESCOM_TYPE ESCom Type Show values
XML_FILE_STATUS Status of ESComXML File Show values
ASS_SUP_MAT_CHANGED_IND Indicator for Change to Assigned Supplier Material Show values
IMPORT_STATUS Status of ESComXML Data Import 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
IMPORT_REQUEST Import Request for ESComXML File ESEESC_INB_IMPORT_REQUEST_NO
EHS_SUBSTANCE_ID Substance in Product Safety ESDSUBID
EHS_REAL_SUB_E_SUBID Supplier Material in Product Safety ESDSUBID
DMSKEY Generic Key of a Document CHAR70
RESPONSIBLE Person Responsible USERNAME
XML_FILENAME ESComXML File TEXT255
XML_GEN_TIMESTMP Generation Time Stamp of ESComXML File TZNTSTMPS
XML_PHRASE_CAT_VERSION Version of ESCom Phrase Library
XML_LANGUAGE_CODE Generation Language of ESComXML File CHAR2
SAP_LANGU Language Key from ESComXML File SPRAS
XML_ESDS_VERSION_NUMBER Version of Report
XML_SUPPLIER_MATERIAL_NAME Material Name from ESComXML File TEXT1000
XML_SUPPLIER_MATERIAL_ID Material from ESComXML File TEXT255
XML_SUPPLIER_NAME Supplier Name from ESComXML File TEXT255
XML_SUPPLIER_EMAIL E-Mail Address of Supplier from ESComXML File AD_SMTPADR
XML_SUPPLIER_DUNS_CODE DUNS Number from the ESComXML File
COUNT_ESCOM_PHRASES Number of ESCom Phrases in ESComXML File
COUNT_NON_ESCOM_PHRASES Number of Non-ESCom Phrases in ESComXML File
COUNT_EXPOSURE_SCENS Number of Exposure Scenarios in ESComXML File
MATERIAL_ID Material Number MATNR
SUPPLIER_ID Supplier LIFNR
XML_OWN_REG_SUBSTANCE_NAME Substance Name from ESComXML File
XML_OWN_REG_EC_NUMBER EC Number of Self-Registered Substance from ESComXML File CHAR9
XML_OWN_REG_CAS_NUMBER CAS Number of Self-Registered Substance from ESComXML File CHAR12
EHS_OWN_REG_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_ROOT.EHS_OWN_REG_SUB_RECN == ESTRH.MANDT
  • ESTESCD_INB_ROOT.[column in domain "ESERECN"] == ESTRH.RECN
Record Number of Supplier Material with ESComXML Assignment
  • Record Number of Supplier Material with ESComXML Assignment
  • ?
  • ESTESCD_INB_ROOT.EHS_REAL_SUB_E_RECN == ESTRH.MANDT
  • ESTESCD_INB_ROOT.[column in domain "ESERECN"] == ESTRH.RECN
Record Number of REACH Substance with ESComXML Assignment
  • Record Number of REACH Substance with ESComXML Assignment
  • ?
  • ESTESCD_INB_ROOT.EHS_SUBSTANCE_RECN == ESTRH.MANDT
  • ESTESCD_INB_ROOT.[column in domain "ESERECN"] == ESTRH.RECN