Skip to Content
Author's profile photo Former Member

Removing the Non Printable Charecteristics from data

Data  failure is one of the  common issues that occur in  BW, below are the reasons (often) why data loading gets cancelled/failed.

  • Invalid units
  • Invalid currencies
  • Invalid characters

I’ve tried an attempt to explain how to handle the invalid  characteristics in the below blog.


Removing Invalid Characters using field routine

But we recently faced an issue again with Invalid characteristics even after implementing the above logic! It gave us a tough time to identify the issue with the Non-Printable characteristics.

Take a look here, Data got failed due to below issue, Actually it is not #, it is a TAB!

ISSUE1.JPG

How to identify it

  • Go to PSA and find out
  • Copy the data and paste it in a Run as shown below

By doing this you will be able to see the Check boxes like below instead of #

PSA.JPG

Notepad.JPG

Now to identify what exactly the check box is? Then copy the data to a Notepad/Word , you will be able to see the data like mentioned in the below screen.

word.JPG

The highlighted area is the Tab.

From here I guess it is easy for you to remove it using the routine. Here you go

code.JPG

The code is just replacing the Tab with a space.

Now delete data and run the DTP, data will be loaded successfully.

Dataloadsuccessful.JPG

Hope it helps you.

Assigned Tags

      7 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Kamal Mehta
      Kamal Mehta

      Thanks for sharing.

      Can you elaborate more on CL_ABAP_CHAR_UTILITIES.

      Thanks

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Hi Kamal,

      It is an ABAP Class for processing characters

      characters that have hexadecimal display between HEX00 and HEX1F are not permitted in characteristic values, in the above scenario # falls between this, so with the help of the ABAP Class we could achieve it.

      Author's profile photo Former Member
      Former Member

      Thanks for Sharing a nice Tips

      Author's profile photo Suman Chakravarthy K
      Suman Chakravarthy K

      Hi Jyothi,

      Nice way of handling the scenario 🙂

      Regards,

      Suman

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thank you Suman

      Author's profile photo Martin Grob
      Martin Grob

      quite a common issue 🙂 nice trick

      Martin

      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Thank you