How To Fix CN_EVWB101 - OBJNR missing in the uploaded excel

SAP Error Message - Details

• 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.

Smart SAP Assistant

• What is the cause and solution for SAP error message CN_EVWB101 - OBJNR missing in the uploaded excel ?

  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 interpreted as missing OBJNR values.
  
  Solution:
  
  
  Check the Excel File:
  
  Ensure that the OBJNR column is present and correctly populated in the Excel file.
  Verify that there are no empty cells in the OBJNR column.
  Make sure that the data format in the OBJNR column matches the expected format in SAP.
  
  
  
  Review Mapping:
  
  If you are using a data upload tool or program, check the mapping configuration to ensure that the OBJNR column in Excel is correctly mapped to the corresponding field in SAP.
  
  
  
  Data Validation:
  
  Validate the data in the Excel file to ensure that all required fields are filled out correctly and that there are no formatting issues.
  
  
  
  Test Upload with Sample Data:
  
  Create a small sample Excel file with a few rows of data, including the OBJNR, and test the upload to see if the error persists.
  
  
  
  Consult Documentation:
  
  Refer to the SAP documentation or user guides related to the specific transaction or program you are using for the upload to ensure compliance with the required data structure.
  
  
  
  Error Logs:
  
  Check any error logs or messages generated during the upload process for additional details that may help identify the issue.
  
  
  
  Related Information:
  
  SAP Transaction Codes: Depending on the context, you may be using specific transaction codes for data uploads (e.g., LSMW, BAPIs, or custom programs).
  SAP Notes: Search for relevant SAP Notes in the SAP Support Portal that may address this specific error or provide additional troubleshooting steps.
  User Forums: Consider checking SAP community forums or user groups for similar issues and solutions shared by other users.
  
  By following these steps, you should be able to identify and resolve the issue causing the CN_EVWB101 error message.