Remove Invalid Characters in SAP BW 3.X?

[Former Member]

Hi,

I have some invalid Arabic characters in my system. I want to remove those invalid characters.

i know how to do it in 7.X data flow using routine but i dont know how to do it in 3.X.

I searched many threads and this but nothing is helpful.

Please help me

Thanks

[Former Member · Accepted solution]

Hi,

In 7.x we use SOURCE_FIELDS and we need to change to TRAN_STRUCTURE in 3.x. Everything will be same apart from this change in 3.X & 7.X.

I did the change and it is working fine now.

Thanks

[Former Member]

Hi Ram,

It is coming daily and source team informed me to remove it in BW side. It is full load and It is master data

Please provide me if you know how to remove using field routine code.

I dont want to allow them by using RSKC i just want remove using field routine in 3.5.

Thanks

[KodandaPani_KV]

Hi,

please try the code at transfer routine.

DATA: l_d_length like sy-index.
DATA: l_d_offset LIKE sy-index.

DATA: CharAllowedUpper(60) TYPE C.
DATA: CharAllowedLower(60) TYPE C.
DATA: CharAllowedNumbr(60) TYPE C.
DATA: CharAllowedSondr(60) TYPE C.
DATA: CharAllowedAll(240) TYPE C.

CharAllowedUpper = 'ABCDEFGHIJKLMNOPQRSTUVWXYZÄÜÖ'.
CharAllowedLower = 'abcdefghijklmnopqrstuvwxyzäüöß'.
CharAllowedNumbr = '0123456789'.

CharAllowedSondr = '!"§$%&/()=?{[]}\u00B4`*+~;:_,.-><|@'''.

CONCATENATE CharAllowedUpper CharAllowedLower CharAllowedNumbr
CharAllowedSondr INTO CharAllowedAll.

RESULT = SOURCE_FIELDS- (give here the source fileld)
l_d_length = strlen( RESULT ).

IF NOT RESULT CO CharAllowedAll.

DO l_d_length TIMES.

l_d_offset = sy-index - 1.

IF NOT RESULT+l_d_offset(1) CO CharAllowedAll.

RESULT+l_d_offset(1) = ''.
CONDENSE RESULT NO-GAPS.

ENDIF.

ENDDO.

endif.

Thanks,

Phani.

[Former Member]

Hi Kodanda Pani,

i used the code you provided and i am getting below error.

E:Field "SOURCE_FIELDS" is unknown. It is neither in one of the specified

Thanks

[former_member183012]

Hi,

Please take help from your ABAP team, to correct abap code.

Regards,

Ganesh Bothe

[KodandaPani_KV]

Hi,

give the source field technical name then try it.

[former_member182997]

Did you try

Using  Tcode RSKC   and  removing  those invalid characters.
Thanks

[RamanKorrapati]

Hi,

if your getting daily then at transfer structure level you need to write transfer routine.

if its came just one time load then you can edit and reload from PSA.

Another way:

Ask source team to rectify it and later reload it.

Is it delta load or full load?

master data or transnational data?

Thanks