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

CM_EHENV_ADC_IMPORT026 - Overview

• 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