How To Fix CN_EVWB101 - OBJNR missing in the uploaded excel

CN_EVWB101 - Overview

• Message type: E = Error

• Message class: CN_EVWB - Message class of Eanred Value Workbench

• Message number: 101

• Message text: OBJNR missing in the uploaded excel

What causes this issue?

Column Mismatch: One of the mandatory columns were not found in the
Excel file. This error might also come when the user tries to import an
excel file in a language which is different from the language to which
it was exported.

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?

Procedure for System Administrators

Error message extract from SAP system. Copyright SAP SE.

CN_EVWB101 - Details

• The SAP error message CN_EVWB101: OBJNR missing in the uploaded excel typically occurs when you are trying to upload data into SAP using an Excel file, and the system cannot find the required object number (OBJNR) in the provided data. This error is common in scenarios involving project management, construction, or asset management where object numbers are crucial for identifying specific items or entities.
  
  Cause:
  
  Missing OBJNR: The Excel file you are trying to upload does not contain the required object number (OBJNR) in the expected column.
  Incorrect Mapping: The mapping between the Excel columns and the SAP fields may not be set up correctly, leading to the system not recognizing the OBJNR.
  Data Format Issues: The format of the data in the Excel file may not match the expected format in SAP (e.g., leading/trailing spaces, incorrect data types).
  Empty Rows: There may be empty rows or cells in the Excel file that are being