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,

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