Invalid Character

[Former Member]

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,

There are three ways to achieve this. Well what you choose a lot depends on the business reqmnt.

1. In RSKC you can add permitted extra characters provided very few of them appear very frequently and business is fine with it.

2. You can bring your data through PSA, and should yu encounter any invalid chars, delete the request from target (Master data characteristic), edit the PSA by spacing out the invalid chars and update the data back to the target.

3. As suggested one of the solutions above, you can write an ABAP routine for spacing out those characters. But always keep performance in mind and do the logic at start routine level.

Since it is master data and it seems you might be doing a full load every time, its better to get the source data corrected. Well you know better what suits you best.

Thanks,

Sanjeev

[Former Member]

Hi,

Refer the blog <b>Invalid characters in SAP BW 3.x: Myths and Reality. Part 2</b> by <b>Eugene Khusainov</b>.

/people/sap.user72/blog/2006/07/23/invalid-characters-in-sap-bw-3x-myths-and-reality-part-2

Regards

Hari

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