How to handle Invalid characters(Square Box) in BI

[Former Member]

Hi All,

Daily I am getting Invalid character(Square Box) issue with 0Material description and material manufacture part number when the it is being loaded to targets.

This data is being loaded to many data targets and daily they are being failed .

I have checked the text in MARA Table and found that there also the square box is appearing in the description.But when i copy the text and past it in word document in the place of box it is appearing as space/Tab.

Can you please help me how to handle this type of issue in BI .

Thanks in advance

[Former Member · Accepted solution]

Hi Binbi1,

This eror is due to carriage returns which turns into a square box when transferring data, this can not be corrected through the RSKC, this is solved through an ABAP routine in the transformation rules, use this code:

DATA i_text type c length 60.

i_text = SOURCE_FIELDS-/BIC/ZMBS_FT1. "this is your material description field

REPLACE ALL OCCURRENCES OF '#'

IN i_text WITH ' '.

REPLACE ALL OCCURRENCES OF '□'

IN i_text WITH ' '.

RESULT = i_text.

I hope this help you....

[Former Member]

Written a routine at field level to exlude all the occurences of getting the # from source table

[former_member184494]

The Square box is a control character which can be generated in Notepad using the CTRL+BACKSPACE keys ....

Please search the forums for answers to the same :

/people/sap.user72/blog/2006/07/23/invalid-characters-in-sap-bw-3x-myths-and-reality-part-2

[Pravender]

I do not think that it is possible to handle square box in RSKC. You have to write a code (in transformation) to handle it.

[Former Member]

I tried copying the square box but it is displaying as space ,so i am unable to write a routine to restrict the square box

[yogesh8984]

Would you be able to find out the hexadecimal code of this character (square box)? You can find out that in the error message of load failure. By doing this you can find out which is actual character (it should not just be a square box).

Then try adding the identified character in RSKC or writing a code for it in transformation.

Regards,

Yogesh

[Pravender]

Define a string which includes all the valid characters. Then compare the field value with this string and remove everything else from the field's value.

[former_member186445]

you could try with : CONDENSE text [NO-GAPS].

[former_member623450]

Hi,

You can do this in routine...

Keep all the allowable caracteristics and delete the unknown and unwanted characteristics

Eg:

Data : text1(10) type char value '0123456789'.

datd: text2(10) type char.

data: temp(1) type char.

data : count type i.

data : length type i.

data: n type i value 0.

text2 = Field . " ( for which the routine is written)

length = strlen( text2 ).

n= length.

do length time.

temp = field+n(1).

find temp temp in text1.

if sy-subrc <> 0.

delete text2+n(1).

condense text2......

n= n+1.

endif.

enddo.

result = text2.

Regards,

SKDDON

Edited by: SKDDON on May 20, 2010 1:50 PM

[Former Member]

In the error message also Square box is there in the text ,but when i check the details of the record in PSA i can see it as # and when i copy and paste the whole decription ,in the place of square box space is displaying .

in RSKC ALL_CAPITAL is mainitained .

I think the square box would be Tab which entered in description.is there any code to restrcit the tab/space .

Thanks

[former_member186445]

try this

REPLACE ALL OCCURRENCES OF '#' IN <field_name> WITH ''.

[yogesh8984]

Hi,

Have you tried adding those characters in RSKC? You can maintain such characters in RSKC T code to avoid such errors.

The other way is to manually change them in PSA and load them into targets.

Regards,

Yogesh

[former_member186445]

this has been discussed on the forum like only a million times...search the forum on 'unpermitted characters'...the answer is out there

M.