Permitted characters during BW data load

[#1]

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]

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.