What is the best fix to permanently fix an invalid characters error in a flat file load.
During a flat file data load I got a message that a value 9887b00.555 of characteristic 0MATERIAL contains invalid characters.
The load failed but when I went into PSA to browse through the package of 600 records, there was no error, they were all green. Even the record with value 9887b00.555 was available as green.
Later, I deleted the Red request and went into the flat file (.csv) and modified it by switching the small b to B in 9887b00.555
I then reloaded the data and it loaded successfully without any problems.
What are the possible permanent solutions to this problem?
Please provide the detail steps and tcodes where applicable.