How To Fix ALSMEX035 - Invalid symbol in date field

SAP Error Message - Details

• Message type: E = Error

• Message class: ALSMEX - Message Class for Legacy Data Transfer

• Message number: 035

• Message text: Invalid symbol in date field

What causes this issue?

The '&v1&' field in the Excel input file contains an invalid symbol.
The field is assigned to a date field in the asset master record.
Therefore it is only permitted to contain numbers and these symbols:
slash (/), period (.).
The value of the field is '&v2&'.

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?

Change the contents of the field in the input file. Or, if the '&v1&'
field was incorrectly assigned to a date field, create a new field
assignment.

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 ALSMEX035 - Invalid symbol in date field ?

  The SAP error message ALSMEX035: Invalid symbol in date field typically occurs when there is an issue with the date format or the input provided in a date field during data upload or processing, particularly when using the LSMW (Legacy System Migration Workbench) tool.
  Cause:
  
  Incorrect Date Format: The date entered does not match the expected format defined in the SAP system. For example, if the system expects a date in the format YYYY-MM-DD and the input is in DD/MM/YYYY, this error will occur.
  Invalid Characters: The date field may contain invalid characters or symbols that are not recognized as part of a valid date.
  Localization Issues: Different countries have different date formats, and if the system is set to a specific locale, it may not accept dates formatted in another locale.
  Data Source Issues: If the data is being imported from an external source, the data might not be cleaned or formatted correctly before the upload.
  
  Solution:
  
  Check Date Format: Ensure that the date is in the correct format as expected by the SAP system. You can check the expected format in the SAP configuration or documentation.
  Remove Invalid Characters: Review the data for any invalid characters or symbols in the date fields and remove them.
  Use Correct Localization Settings: If applicable, ensure that the date format matches the localization settings of the SAP system.
  Data Validation: Before uploading data, validate the data in the source file to ensure that all date fields are correctly formatted and contain valid dates.
  Test with Sample Data: If you are unsure about the format, try uploading a small sample of data with known valid dates to see if the error persists.
  
  Related Information:
  
  LSMW Documentation: Review the SAP documentation for LSMW to understand the expected formats and data types for each field.
  SAP Notes: Check SAP Notes for any known issues or updates related to this error message.
  Transaction Codes: Familiarize yourself with relevant transaction codes such as LSMW, SE38 (for running programs), and SE11 (for data dictionary) to troubleshoot further.
  User Exits and BAPIs: If you are using custom programs or BAPIs, ensure that they handle date formats correctly.
  
  By addressing the above points, you should be able to resolve the ALSMEX035 error and successfully process your data in SAP.