Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How to avoid the special char in sap bi 7.3

Hi all,

Now loading data form ECC system to DSO,but i wrote some formulas in transformation level but getting same errors.

avoid the errors please suggest me any code at transformation level?

ex- ÇÉÀÇÊÈÏÌÅÉÒÙÁÍÓÚÑÑÈÍÌÓÒÚÙÉÈÍÌÓÒÚÙ·.'#

      "COMPANY X FOR # SALES".

instead of editing the PSA data provide the simple ABAP logic asap.

Tags:
replied

Hi Shabnam & kalpana,

please find the below code it will work, below code change the source field name which field you required. ex- RESULT = SOURCE_FIELDS-STUDENTEMAILID.

i applied same code, it is working......



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-STUDENTEMAILID.
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.

CONDENSE RESULT NO-GAPS.
TRANSLATE RESULT TO UPPER CASE.

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question