How To Fix EHPRC_CPM_IMPORT191 - Listed substance &1 does not exist; import of record &2 skipped

SAP Error Message - Details

• Message type: E = Error

• Message class: EHPRC_CPM_IMPORT - Import Messages

• Message number: 191

• Message text: Listed substance &1 does not exist; import of record &2 skipped

What causes this issue?

A listed substance that can be used for the substance &SYST-MSGV1& does
not exist.

System Response

The system issues an error message and will not allow you to continue with this transaction until the error is resolved.

How to fix this error?

Create a listed substance manually in the latest regulatory list
revision for the regulatory list <LS>GADSL</>.
Import the substance record from the IMDS file again.
Add the CAS number &SYST-MSGV3& to the new listed substance.
To import only the failed substance, you can copy the rows of the
substance with the node ID &SYST-MSGV2& from the IMDS file into a new
file. You can then import this smaller file instead of the whole IMDS
file.

Procedure for System Administrators

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message EHPRC_CPM_IMPORT191 - Listed substance &1 does not exist; import of record &2 skipped ?

  The SAP error message EHPRC_CPM_IMPORT191 indicates that there is an issue with the import of a record related to a listed substance in the context of SAP's Environment, Health, and Safety (EHS) module, specifically in the Chemical Product Management (CPM) area. The error message states that the listed substance referenced by &1 does not exist, and as a result, the import of record &2 has been skipped.
  Cause:
  
  Missing Substance: The primary cause of this error is that the listed substance (identified by &1) is not present in the SAP database. This could happen if the substance was never created, was deleted, or if there is a mismatch in the substance identifier.
  Data Import Issues: If you are importing data from an external source (like a CSV file or another system), there may be inconsistencies or errors in the data being imported, such as typos or incorrect identifiers.
  Configuration Issues: There may be configuration issues in the EHS module that prevent the system from recognizing the listed substance.
  
  Solution:
  
  Verify Substance Existence: Check if the listed substance exists in the SAP system. You can do this by navigating to the relevant transaction (e.g., CPE1 for creating substances or CPE2 for changing substances) and searching for the substance using its identifier.
  Create Missing Substance: If the substance does not exist, you will need to create it in the system. Ensure that all required fields are filled out correctly.
  Check Import Data: Review the data you are trying to import. Ensure that the identifiers for the listed substances are correct and match those in the SAP system.
  Error Log Review: Check the error logs for more details on the import process. This may provide additional context or related errors that can help diagnose the issue.
  Consult Documentation: Refer to SAP documentation or help resources for specific guidelines on managing listed substances and data imports in the EHS module.
  
  Related Information:
  
  Transaction Codes: Familiarize yourself with relevant transaction codes in SAP EHS, such as CPE1, CPE2, and CPE3 for managing chemical substances.
  SAP Notes: Check for any SAP Notes related to this error message or the EHS module that may provide additional insights or patches.
  User Roles and Authorizations: Ensure that the user performing the import has the necessary authorizations to create or modify substances in the system.
  
  By following these steps, you should be able to resolve the error and successfully import the required records.