Skip to Content

How to accept Invalid values in BW?

We have data coming into BW with a lot of invalid char '$ , space, chinese char, spanish' etc. User has told that he wants it to show in report. But we don't want to globally accept such chars (RSKC).

scenario1.

ZTCODES master. datatype char 40.

tcodes coming in with invalid values (red status). How can these values be accepted locally only? These values may then be used for in cubes for reporting and ztcodes is to be used for selection in selection screen.

Scenario2.

DSO holds transaction data but does not activate due to invalid ztcodes vales.

Any ideas?

Regards,

Cleo.

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    Posted on Mar 20, 2015 at 06:40 PM

    Hi Cleo,

    I think we should distinguish between not allowed characters in the context of RSKC and "unwanted" characters, e.g. from Chinese or Spanish character sets.

    Not allowed characters can be handled e.g. via a character string cleansing tool. Please refer to my blog Introducing an Add-on for Cleansing Character Strings for an example. This should be a global approach.

    "Unwanted" characters can have a different approach. You can write a routine (or any other ABAP coding) to handle this (e.g. check characters against an allowed set of characters and replace all the rest with e.g. a space).

    Best regards,
    Sander

    Add a comment
    10|10000 characters needed characters exceeded

    • I made 2 text master infoobjects. I gave a counter as key for both text masters. Took tcode as text in one master and tcode description as text in another master. I use counter no. to relate both tcode and tcode description. I use code to ensure that a certain tcode and and its description will have same counter no. value.

  • Posted on Mar 17, 2015 at 03:16 PM

    Hi,

    For ASCII characters from 32 to 255 (typeable) from keyboard you have options in SPRO - Business Warehouse - > General settings -> maintain permitted extra characters. For the rest you have to write FM to deal with

    Regards

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Mar 18, 2015 at 12:45 AM

    Hi Cleo,

    RSKZ must be enough. If you want load this data, you have two ways.

    1) Try change your DSO standar to write optimized.

    2) Use a routine to change your data.

    Regards.

    data:lv_string type string.

    lv_string = '&^%&^%!@&%hjasdg^%^%@%!aa&'.

    REPLACE all occurrences of REGEX '[^[:alnum:]]*' IN lv_string WITH '' .

    write lv_string.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Cleo James

      Hi,

      Chinese char, Spanish char are not actually invalid characters... check in SMLT T-code whether those languages are installed in your system.

      If respective languages are not installed then ask basis to install the same....

      Regards,

      Pavan.

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.