Skip to Content
author's profile photo Former Member
Former Member

Eliminating zeoes from a CHAR (10) including decimal based IO

Hi guys,

i am getting a filed CHAR (10) from a legacy system via flat file into BW. I created and mapped that incoming field to an InfoObject CHAR (10). Now from the source system field value arrives as '000087.39 ' and user would like to see it as 87.39 in the BW query report. I tried to L_Trim, Shift <field> LEFT DELETING LEADING '0' and CONVERSION_EXIT_ALPHA_OUTPUT but nothing seemed to work in transfer or update rules and Formula.....Remember value is 10 CHAR including decimal (3 max).

Any idea or thoughts?

Thanks.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

6 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jun 13, 2008 at 04:02 AM

    hi there...

    do as folllows...

    itab-field1(C)

    this way, all the leading zeros in the itab-field wil get suppressed.

    regards'

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 15, 2008 at 08:54 AM

    try to use supress leading zeroes

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thanks guys.

      Well i found a workaround, basically i changed the IO from characteristic to KF as Numeric(with DEC) and manipulated the query to show that as an attribute of zmaterial..So now its giving what i asked for...I guess i did not have patience to keep trying ..instead just use the available SAP functionality ...

      Thanks for youe time and responses ..i am assigning points to people who were close to the original problem's resolution.

  • author's profile photo Former Member
    Former Member
    Posted on Jun 13, 2008 at 03:40 AM

    Hi,

    Try to use ' Condense' .

    Thanks.

    Swati.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 13, 2008 at 05:02 AM

    Hi,

    Can't you change the Target field from CHAR(10) to something like a Packed Decimal say

    pack TYPE P DECIMALS 3. I guess that it should sove the problem.

    Regards

    Saket Sharma

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Well i cannot change the IO to a KeyFigure , it has to stay as either CHAR or NUMC so that i could use it as navigational attribute. If i changed it to KF then it would only be used as display and in that case i have add that to the cube drop and reload data, dont want to do that.

      Also i forgot to mention that i tried CONDENSE as well with SHIFT <Field> DELETING LEADING '0' and it did not work. I will try itab and see if it makes a difference..

      Any other ideas..

      Thanks..

  • author's profile photo Former Member
    Former Member
    Posted on Jun 14, 2008 at 09:18 AM

    hi send the value of char into a packed decimal..

    like this..

    data: char(10) type c value '0000087.98',

    test type p decimals 2 .

    test = char .

    write:/ char,test .

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 16, 2008 at 07:39 PM

    I basically changed the strategy..looked into my last comments

    Add a comment
    10|10000 characters needed characters exceeded

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.