Permitted characters during BW data load

[Former Member]

Hello everyone,

I have problems loading data into my BW system because characters like "!" and "#" are not "allowed".

I went to RSKC txn., and added "!", but data load is still not possible, same error. RSKC now allows "ALL_CAPITAL,!" characters, however.

What else do I need to do?

Regards,

Mario Vallejo.

P.S. I manually edited PSA data to load my previous feed (because of urgency of load) but a 2nd feed that just came to my system had same problem and I had already used RSKC by that time.

I want to eliminate from root cause for future incidents.

[Former Member · Accepted solution]

Mario

Two possibilities to eliminate root cause

1 Correct Data in R/3 it self

2 To deal with special characters, invisible, like TAB, CR BACKSPACE etc. you need to write ABAP routines in transfer rules to eliminate them.

Hope this helps

Thanks

Sat

[Former Member · Accepted solution]

Sat,

Let me check your answer and I'll come back to you later.

Thank you.

Mario

[Former Member]

Hi Mario,

'!' sign is allowed by default. However, values starting from it are not allowed, see OSS Note # #173241 - "Allowed characters in the BW System".

Look here for some additional info:

Best regards,

Eugene

[Former Member]

Thank you all.

I have made testing on my QA system, and confirmed RSKC should just contain "ALL_CAPITAL".

Still single "#" and "!" characters (per se) can't be loaded but that it's not a problem since these kind of characters normally do not come alone.

Regards,

Mario

[Former Member]

Hi,

After adding all the special characters in RSKC and considering all capitals...

If # or ! comes as a first character in the free text system raises error, even they are present in RSKC.

In this case try to replace the first character with some other character like 'X'.

GSM.

[Former Member]

Try with this code:

• Inizio modifiche Caforio Claudio (SIDI 13/06/2005)

DATA: g_allowed_char(200) TYPE c.

• L'utilizzo del seguente function è necessario al fine di

• controllare la validità dei caratteri passati

IF g_allowed_char IS INITIAL.

CALL FUNCTION 'RSKC_ALLOWED_CHAR_GET'

IMPORTING

e_allowed_char = g_allowed_char.

ENDIF.

RESULT = TRAN_STRUCTURE-zdescat01_a.

TRANSLATE RESULT TO UPPER CASE.

CHECK g_allowed_char NE 'ALL_CAPITAL'.

• if allowed_char = ALL_CAPITAL, all capital letters are allowed,

• therefore no further action nescessary

DO.

IF NOT RESULT CO g_allowed_char.

SHIFT RESULT+sy-fdpos LEFT.

ELSE.

EXIT.

ENDIF.

ENDDO.

• Fine modifiche Caforio Claudio (SIDI 11/07/2005)

_____________________________________________________

*****************************************************

-

-

---

ELSE try with this

• Inizio modifiche Caforio Claudio (SIDI 13/06/2005)

CONSTANTS : c1(42) TYPE c

VALUE '!"#$%&()*+,-./0123456789:;<=>?@ABCDEFGHIJK' .

CONSTANTS : c2(48) TYPE c

VALUE 'LMNOPQRSTUVWXYZ[]^_abcdefghijklmnopqrstuvwxyz{}' .

DATA : caratteri_ammessi(90) TYPE c.

DATA : times TYPE i,

i LIKE sy-index .

DATA : input LIKE TRAN_STRUCTURE-ZDESCAT01_A,

output LIKE TRAN_STRUCTURE-ZDESCAT01_A,

s TYPE c .

CLEAR output .

CONCATENATE c1 c2 INTO caratteri_ammessi.

CONDENSE caratteri_ammessi NO-GAPS.

input = TRAN_STRUCTURE-ZDESCAT01_A.

times = STRLEN( input ) .

DO times TIMES.

i = sy-index - 1.

s = input+i(1).

IF s CA caratteri_ammessi .

CONCATENATE output s INTO output .

ELSE.

CONCATENATE output '#' INTO output .

ENDIF.

ENDDO .

TRANSLATE output USING '# '.

RESULT = output .

• Fine modifiche Caforio Claudio (SIDI 11/07/2005)

[Former Member]

Claudio,

Let me check your answer and I'll come back to you later.

Thank you.

Mario

[edwin_harpino]

hi Mario,

"ALL_CAPITAL,!" ?

in rskc, just put ALL_CAPITAL, no other ! char.