ESTESCD_ARC_ROOT - Inbound Archive Header Information
Inbound Archive Header Information information is stored in SAP table ESTESCD_ARC_ROOT.
It is part of development package CBESCOM in software component EHS-SAF-ESM. This development package consists of objects that can be grouped under "EHS: Integration of Exposure Scenario Communication".
It is part of development package CBESCOM in software component EHS-SAF-ESM. This development package consists of objects that can be grouped under "EHS: Integration of Exposure Scenario Communication".
Fields for table ESTESCD_ARC_ROOT
Field Name | Description | Is Key | Data Element | Data Type | Length | Check Table |
|---|---|---|---|---|---|---|
| MANDT | Client | X | MANDT | CLNT | 6 | |
| RECN | Sequential Number of Data Record | X | ESERECN | NUMC | 40 | |
| .INCLUDE | ADMIN | ESEESCS_ADMIN_DATA | 0 | |||
| CRTIMESTAMP_UTC | Created On | ESEESC_CREATED_ON | DEC | 8 | ||
| CRNAM | Created By | ESECRNAM | CHAR | 24 | ||
| UPDTIMESTAMP_UTC | Changed On | ESEESC_CHANGED_ON | DEC | 8 | ||
| UPDNAM | Last Changed By | ESEUPDNAM | CHAR | 24 | ||
| IMPORT_REQUEST | Import Request for ESComXML File | ESEESC_INB_IMPORT_REQUEST_NO | NUMC | 14 | ||
| EHS_SUBSTANCE_RECN | Record Number of REACH Substance with ESComXML Assignment | ESEESC_XML_ASSGND_SUBST_RECN | NUMC | 40 | ESTRH | |
| EHS_REAL_SUB_E_RECN | Record Number of Supplier Material with ESComXML Assignment | ESEESC_XML_ASSGND_SUP_MAT_RECN | NUMC | 40 | ESTRH | |
| EHS_OWN_REG_SUB_RECN | Record Number of Pure Substance with ESComXML Assignment | ESEESC_XML_ASSGND_PURESUB_RECN | NUMC | 40 | ESTRH | |
| .INCLUDE | DATA | ESEESCS_INB_ROOT_DATA | 0 | |||
| EHS_SUBSTANCE_ID | Substance in Product Safety | ESEESC_XML_ASSGND_SUBST_ID | CHAR | 24 | ||
| EHS_REAL_SUB_E_SUBID | Supplier Material in Product Safety | ESEESC_XML_ASSGND_SUP_MAT_ID | CHAR | 24 | ||
| DMSKEY | Generic Key of a Document | ESEDMSKEY | CHAR | 140 | ||
| RESPONSIBLE | Person Responsible | ESEESC_RESP_USER | CHAR | 24 | ||
| INBOUND_PROCESSING_STATUS | Processing Status of ESComXML Inbound Processing | ESEESC_INB_PROCESSING_STATUS | CHAR | 4 | ||
| XML_FILENAME | ESComXML File | ESEESC_ESCOMXML_FILENAME | CHAR | 510 | ||
| XML_GEN_TIMESTMP | Generation Time Stamp of ESComXML File | ESEESC_XML_GENERATION_TIMESTMP | DEC | 8 | ||
| XML_VERSION_NO | Version of ESComXML Data Model | ESEESC_ESCOMXML_VERSION | CHAR | 12 | ||
| XML_PHRASE_CAT_VERSION | Version of ESCom Phrase Library | ESEESC_CATALOGUE_VERSION_INB | CHAR | 16 | ||
| XML_LANGUAGE_CODE | Generation Language of ESComXML File | ESEESC_XML_LANGU | CHAR | 4 | ||
| SAP_LANGU | Language Key from ESComXML File | ESEESC_LANGU | LANG | 2 | * | |
| XML_SUBST_MIX_IND | Indicator for Substance or Mixture | ESEESC_SUB_MIX_IND | CHAR | 20 | ||
| XML_ESCOM_TYPE | ESCom Type | ESEESC_ESCOM_TYPE | CHAR | 8 | ||
| XML_ESDS_VERSION_NUMBER | Version of Report | ESEESC_REPORT_VERSION | CHAR | 24 | ||
| XML_SUPPLIER_MATERIAL_NAME | Material Name from ESComXML File | ESEESC_XML_MATERIAL_NAME | CHAR | 2000 | ||
| XML_SUPPLIER_MATERIAL_ID | Material from ESComXML File | ESEESC_XML_MATERIAL_ID | CHAR | 510 | ||
| XML_SUPPLIER_NAME | Supplier Name from ESComXML File | ESEESC_XML_SUPPLIER_NAME | CHAR | 510 | ||
| XML_SUPPLIER_EMAIL | E-Mail Address of Supplier from ESComXML File | ESEESC_XML_SUPPLIER_EMAIL | CHAR | 482 | ||
| XML_SUPPLIER_DUNS_CODE | DUNS Number from the ESComXML File | ESEESC_XML_DUNS_CODE | CHAR | 18 | ||
| COUNT_ESCOM_PHRASES | Number of ESCom Phrases in ESComXML File | ESEESC_COUNT_ESCOM_PHRASES | INT4 | 4 | ||
| COUNT_NON_ESCOM_PHRASES | Number of Non-ESCom Phrases in ESComXML File | ESEESC_COUNT_NON_ESCOM_PHRASES | INT4 | 4 | ||
| COUNT_EXPOSURE_SCENS | Number of Exposure Scenarios in ESComXML File | ESEESC_COUNT_EXPOSURE_SCENS | INT4 | 4 | ||
| MATERIAL_ID | Material Number | ESEESC_MATERIAL_ID | CHAR | 80 | * | |
| SUPPLIER_ID | Supplier | ESEESC_SUPPLIER_ID | CHAR | 20 | * | |
| XML_FILE_STATUS | Status of ESComXML File | ESEESC_FILE_STATUS | CHAR | 2 | ||
| XML_OWN_REG_SUBSTANCE_NAME | Substance Name from ESComXML File | ESEESC_XML_SUBSTANCE_NAME | STRG | 8 | ||
| XML_OWN_REG_EC_NUMBER | EC Number of Self-Registered Substance from ESComXML File | ESEESC_XML_EC_NUMBER | CHAR | 18 | ||
| XML_OWN_REG_CAS_NUMBER | CAS Number of Self-Registered Substance from ESComXML File | ESEESC_XML_CAS_NUMBER | CHAR | 24 | ||
| EHS_OWN_REG_SUB_SUBID | Specification of Pure Subst. with ESComXML Assign. (SelfReg) | ESEESC_XML_ASSGND_PURESUB_ID | CHAR | 24 | ||
| ASS_SUP_MAT_CHANGED_IND | Indicator for Change to Assigned Supplier Material | ESEESC_INB_SUP_MAT_CHANGED_IND | CHAR | 2 | ||
| IMPORT_STATUS | Status of ESComXML Data Import | ESEESC_IMPORT_STATUS | CHAR | 2 |