How To Fix CM_EHENV_ADC_IMPORT026 - Enter mandatory comment on sheet "&1", row &2

SAP Error Message - Details

• Message type: E = Error

• Message class: CM_EHENV_ADC_IMPORT - Message class for Automatic Data Collection

• Message number: 026

• Message text: Enter mandatory comment on sheet "&1", row &2

What causes this issue?

You want to import environmentally related data records in the system
using a spreadsheet file from the file system. However, the data is
marked in the import file as <LS>Value Not Available</>.

System Response

The system cannot import amount records marked as <LS> Value Not
Available</> without a filled out comment field.

How to fix this error?

To import the data, open the import file for editing and enter a comment
why the data is not available.

Procedure for System Administrators

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

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message CM_EHENV_ADC_IMPORT026 - Enter mandatory comment on sheet "&1", row &2 ?

  The SAP error message CM_EHENV_ADC_IMPORT026 indicates that a mandatory comment is required in a specific sheet and row of an import file, typically when working with data uploads in the SAP system. This error is often encountered during the import of data into the Environment, Health, and Safety (EHS) module or similar data management processes.
  Cause:
  The error occurs because:
  
  The import file you are trying to upload is missing a required comment in the specified sheet and row.
  The system has defined certain fields as mandatory, and if these fields are not filled out, the import process will fail.
  
  Solution:
  To resolve this error, follow these steps:
  
  
  Identify the Sheet and Row: Check the error message for the specific sheet name (indicated by "&1") and the row number (indicated by "&2") where the mandatory comment is missing.
  
  
  Open the Import File: Open the import file (usually in Excel or CSV format) that you are trying to upload.
  
  
  Locate the Row: Navigate to the specified sheet and locate the indicated row.
  
  
  Add the Mandatory Comment: Fill in the required comment in the appropriate column. Ensure that the comment meets any specific format or content requirements set by your organization or the SAP system.
  
  
  Save the File: After adding the necessary comments, save the file.
  
  
  Reattempt the Import: Go back to the SAP system and try the import process again.
  
  
  Related Information:
  
  Documentation: Refer to the SAP documentation for the specific module you are working with (e.g., EHS) for details on mandatory fields and import requirements.
  Data Validation: Before importing, it may be helpful to validate the data in your file to ensure all mandatory fields are filled out correctly.
  Error Logs: If the error persists after correcting the comments, check the error logs for additional information that may help identify other issues with the import file.
  SAP Support: If you continue to experience issues, consider reaching out to your SAP support team or consulting the SAP community for further assistance.
  
  By ensuring that all mandatory fields, including comments, are filled out correctly, you should be able to successfully complete the import process without encountering this error.