Invalid Character

[#1]

I am laoding Master Data into BW, and i do hae some invalid characterstics and some corrupted data in R/3, and i want to avoid those records. How can i avoid those data records at run time?

[Former Member]

Hi-

Try using error handling in the infopackage. Use the option "valid records update, reporting possible (request green)" and terminate after errors "99,999". This option would ignore the bad records, so you risk losing some data. The other way to cleanse the data (the way I recommend) is by writing a ABAP program to space out the error causing characters (like \). Assign points if this helps.