Avoiding the Special characters in BI

Introduction:

Special characters are maintained in RSKC in BW. Even after maintaining in RSKC , while Loading the data into BW its throwing the data loading error.to allow  the some special characters  like space,@,#,$…etc. and to continue the data load without abend.

step 1: create the Global class to allow the all attributes.

step 2: Enter the short description.

step 3 : create method with following parameters.

step 4: call the FM  ‘RSKC_CHAVL_OF_IOBJ_CHECK’and  pass all the parameters as follows in the above method.

DATA: lo_d_length    TYPE i,

          lo_d_char(1)   TYPE c,

          lo_d_index      TYPE i.

   TRANSLATE g_object TO UPPER CASE.

   lo_d_length = STRLEN( g_object ).

   DO lo_d_length TIMES.

     lo_d_index = sy–index – 1.

     lo_d_char = g_object+lo_d_index(1).

     CALL FUNCTION ‘RSKC_CHAVL_OF_IOBJ_CHECK’

       EXPORTING

          i_chavl           = lo_d_char

          i_iobjnm          = i_object

       EXCEPTIONS

         chavl_not_allowed = 1.

     IF sy–subrc NE 0.

       CLEAR g_object+lo_d_index(1).

     ELSE.

       g_object+lo_d_index(1) = lo_d_char.

     ENDIF.

   ENDDO.

   TRANSLATE g_object TO UPPER CASE.

step 5 : Go to RSA1 and select the info cube and  create the routine.

step 6 : write the logic in the routine.

step 7 : call the class to any fields

step 7 : save the routine and activate the Transformation.