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

KONP-KBETR value has an extra 0? 500.00 is tored as 5000.00, why is this?

Howdy,

I'm creating a BDC and I read in the rate from table KONP. However in some cases the rate is ten times the value it should be?

In my example KONP-KBETR has a value of '500.000-' in VK13 but when I look at the table it the field is tored as a value of '5000.00-'?

Does anyone know why this happens and how to retrieve the correct value?

Many Thanks!

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

8 Answers

  • Posted on Aug 01, 2005 at 11:55 AM

    SAP stores these values without any decimals and then you have to devide the value by 1000.

    For example,

    500000 / 1000 = 500.000

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 06, 2005 at 07:44 AM

    Hi,

    According to your last example, I think this is only available on percentage number.

    Best Regards

    Heinz

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 06, 2005 at 08:47 AM

    Hi Steve

    The field KBETR is numeric field with 2 decimal, but the value % are often value with 3 decimals.

    So the system can store a value whit 3 decimal in a field with 2 decimal only moltiplying the value for 10.

    Infact if you have 10,324 %, so SAP moltiply it for 10, it'll be 103,24 and this value is stored.

    A routine input/ouput does thi conversion:

    - Input: value * 10;

    - Output: value / 10;

    This routine depends on the currency field that controls KBETR in structure KONP. This field is RV13A-KONWA, if you check the standard program use field KONP-KBETR in screen you can see they fill RV13A-KONWA with 3.

    Max

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Feb 25, 2007 at 07:10 PM

    Steve,

    for BDC you need external representation, This is achieved with WRITE KONP-KBETR TO bdcdata-fval.

    It will we formatted according to the currency field KONWA: Japanese yen no decimals, USD and EUR 2 decimals, Libya pounds (?) 3 decimals.

    Regards,

    Clemens

    P.S. You can use the CURRENCY addition for WRITE. Don't trust 'divide by something' recommendations. They will fail earlier or later.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 01, 2005 at 01:33 PM

    regards,

    Gagan

    Message was edited by: Gagan Bhanot

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 06, 2005 at 07:38 AM

    Hi,

    I think the rate amount in VK13 has 3 decimals. But KONP-KBETR has only 2 decimals. In order to store the data, so 500.000 is tored as 5000.00.

    Solution: you may find a function module to transfer... or divide 10 directly...

    Regards

    Heinz

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 06, 2005 at 08:56 AM

    Hai Steve,

    This happens only in the case of percentage i.e. if KONP-KRECH = 'A'(percentage) then KBETR should be divided by 10 when you use the value. Because 15% is stored in the table as 150.00.

    The same case occurs in your KONV table also.

    You can check that.

    Regards

    Binoo

    NB:Plz award points if the information helped you.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 26, 2007 at 01:28 AM

    Hi Steve,

    Please check this out.

    Table TCURX has the no.of decimal places for the currency that has decimals other than 2. So read the number of decimals from this table then take the whole number of KONP-KBETR ( in your case 500000 as ignoring the decimal in the number ) then dIvide it by the number of decimal you read from the table for the currency key KONP-KONWA i guess.

    Thanks,

    Swetha.

    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.