cancel
Showing results for 
Search instead for 
Did you mean: 

Issue with # in PSA

Former Member
0 Kudos

Hi All,

I am facing an issue with source data, which is leading to failure of DSO activation. The data looks fine in the activation failure message and also in PSA. Only when we try updating the PSA row the data shows up to have a #. I am not able to apply a filter for # also, its not selecting those records. How to identify these erroneous records?

Thanks,

Anupama

Accepted Solutions (0)

Answers (5)

Answers (5)

former_member223526
Participant
0 Kudos

Hi,

How did you resolve this issue.

Thanks.

former_member223526
Participant
0 Kudos

Hi Anupama,

If the customer name you are getting is correct with the space to be included you can do onw thing.

Go to T Code RSKC and in the special characters list add ' '(Spcae) and save.

Then try reloading the data i guess this works.

Thanks,

Madhu.

anish_samuel
Explorer
0 Kudos

Hi Anupama,

Here is the abap code to exclude special character. Please adjust fields accordingly. It will work.

Use this code in Field routine.

data: lv_Postxt type _ty_s_TG_1-POSTXT.

data : in type c.

data: out(2) type c.

data: str1 type string.

data: str2 type xstring.

data: nLength type i, cTemp(200) type c.

clear: out,str2, str1,lv_Postxt.

MOVE SOURCE_FIELDS-XXXX TO lv_Postxt.

nLength = strlen( lv_Postxt ).

  do nLength times.

    subtract 1 from nLength.

    clear in.

    in =  lv_text+nLength(1) .

    call function 'URL_ASCII_CODE_GET'

      EXPORTING

      trans_char = in

      importing

      CHAR_CODE = out.

      concatenate out cTemp into cTemp .

  enddo.

str2 = cTemp.

    call function 'NLS_STRING_CONVERT_TO_SYS'

      EXPORTING

      LANG_USED = 'E'

      SOURCE = str2

      FROM_FE = 'MS'

      importing

      result = str1.

    SHIFT str1 RIGHT DELETING TRAILING space.

    SHIFT str1 LEFT DELETING LEADING space.

    condense str1 .

    RESULT = str1.

Thanks,

Anish Samuel

former_member186445
Active Contributor
0 Kudos

there are a million threads on this topic. search before posting.

you can search with term unpermitted char.

M.

Former Member
0 Kudos

I understand what is unpermitted char. The issue here is that i am not able to see the records with that value. Check the attached screenshot. And , is a permitted character.

former_member186445
Active Contributor
0 Kudos

thought # was giving the issue...anyway... remove the "," and try to load again.

what type is zcustnm?

M.

Former Member
0 Kudos

That does not solve my issue, and its not one record. There are multiple records so every time i active it fails with a new record.

former_member186445
Active Contributor
0 Kudos

now it's clear. please read my first reply. you really need to search on the net for the documentation on how to delete " #" by using abap in your field routine.

there are how-to's with detailed code, you just need to copy/paste the stuff...

M.

RamanKorrapati
Active Contributor
0 Kudos

Hi Anupama,

Based on text(which showed in error message) you can apply filter on specific info object/filed at PSA level.

in edit mode, you can try to remove # character and save the record.

Thanks