PSA data correction

[Former Member]

Hi,

I am trying to load some data into an ODS. For a field 'Insurance Type', there's some records in the source system that have some incorrect data. In these records, instead of the data 'Full Insurance', there's some hexadecimal characters (exactly how many I am not sure) in the beginning of the string 'Full Insurance'.

I want to delete these records in the PSA. I am searching in the PSA by setting a filter on this field. For the filter value, I tried giving a string starting with one/two/three '?' for single characters followed by Full* for the rest of 'Full Insurance' string, but I am not getting any hits. How can I filter these records in the PSA, to remove the hexadecimal characters from the records?

Thanks.

[former_member496813]

If bad data is already in PSA and want to edit, do the following:

Detele the target request first.

You won't be able to edit data in PSA until you delete the target request.

Now go to PSA table (RSA15) find the PSA request & right click on it and click Edit.

Here you will see all good data as green and bad/erroneous data in red. Double Click on the bad data and edit it.

Save data and come back to request.

Right click on the request and click on the Update data immediately.

All the good data will be in target.

If bad data is not in PSA, try to fix it in Source or you can write a small routine in transfer rules.

Hope it helps...

[Former Member]

Hi,

Thanks for your reply. Somehow I was able to find the bad data in PSA and correct it.

Actually, you said it's not possible to edit PSA data without deleting the request in the data target, but i found that is was possible.

[Former Member]

You can edit the PSA w/o deleting the request in target, however you cannot load the same request w/o deleting it in the target.