Invalid Characters

[former_member452200]

Hello-

I am trying to gather a list of invalid characters that will cause failures when loading data in BW and activating the data (when loading to DSO). I am NOT referring to t-code RSKC and I understand that there are characters that you can permit through this program.

What I am referring to are any other exceptions that you don't have control over. For example,

1. Any text string with a preceeding exlamation point ! will fail. This only happens when it is at the beginning of the character string.

2. A hashtag followed by a space. For example, "Apartment #3" is okay, but "Apartment # 3" will fail.

3. Leading and trailing spaces on a text string (intermittent - this does not always cause a failure).

Does anyone know of any other special situations besides these that will cause failures? Once again, as far as we know, RSKC will not resolve the above issues. We have permitted ! and # in that program.

Thanks,

Drew

[Former Member]

Check the Hex value - use SAP Note 173241.

Check if lowercase letters are allowed for the mentioned InfoObject in tcode RSD1

check for the character ~

Please see http://wiki.sdn.sap.com/wiki/display/BI/HowtoremoveInvalidcharacters

[Former Member]

The code below will remove all invalid characters...l_text_in is ur input text...

REPLACE ALL OCCURRENCES OF cl_abap_char_utilities=>cr_lf IN

l_text_in WITH space.

REPLACE ALL OCCURRENCES OF cl_abap_char_utilities=>horizontal_tab IN

l_text_in WITH space.

REPLACE ALL OCCURRENCES OF cl_abap_char_utilities=>vertical_tab IN

l_text_in WITH space.

REPLACE ALL OCCURRENCES OF cl_abap_char_utilities=>newline IN

l_text_in WITH space.

REPLACE ALL OCCURRENCES OF cl_abap_char_utilities=>form_feed IN

l_text_in WITH space.

REPLACE ALL OCCURRENCES OF cl_abap_char_utilities=>backspace IN

l_text_in WITH space.

REPLACE ALL OCCURRENCES OF c_hash IN l_text_in WITH space.

REPLACE ALL OCCURRENCES OF c_aphostope IN l_text_in WITH space.

CONDENSE l_text_in.

SELECT SINGLE allowchar FROM rsallowedchar INTO allowed_char(100).

IF l_text_in CN allowed_char.

TRANSLATE l_text_in TO UPPER CASE.

l_num_len = STRLEN( l_text_in ).

l_pos = 0.

WHILE l_pos < l_num_len.

l_char_len = CHARLEN( l_text_in+l_pos ).

present = l_text_in+l_pos(l_char_len).

IF present IS INITIAL.

l_text_out+l_pos(1) = ' '.

ELSEIF present CO allowed_char.

l_text_outl_pos(1) = l_text_inl_pos(l_char_len).

ELSE.

l_text_out+l_pos(1) = ' '.

ENDIF.

ADD l_char_len TO l_pos.

ENDWHILE.

ELSE.

l_text_out = l_text_in.

ENDIF.

CONDENSE l_text_out.

RESULT = l_text_out(60).

endif.

Edited by: vamsi talluri on Jan 17, 2012 9:53 PM