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

Formatting numbers in a TableViewIterator

Hello,

I have a table structure with some fields of type NUMC with a length of 9. One of these fields is called TURNOVER. When I use a tableView and a tableViewIterator to display my table structure turnover looks like 001234567. What I would like turnover to look like is 1.234.567. Is there a simple way to do this?

Thanks

ALEX

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Dec 21, 2004 at 08:06 AM

    You can use TYPE p

    for example

    data: lt_turnover type P decimals 2.
    
    move TURNOVER TO lt_turnover.
    

    Or something like since it's standard ABAP a search in the ABAP forum might help as well.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 21, 2004 at 08:08 AM

    One way to convert from 000123456 is to use FM <b>CONVERSION_EXIT_ALPHA_INPUT</b> FM and update this value in the internal table. This will change the value from <b>000123456</b> to <b>123456</b>. One more way could be by changing the data type of the column from <b>NUMC</b> to <b>Integer</b>. I am sure there is a parameter for this in tableview where you can change the <b>datatype</b>(not sure which).

    Regards,

    Subramanian V.

    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.