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

Clarify decimal setting in layout vs KF definition

I have a key figure defined as FLTP (16 decimals). In my layout definition, I've limited the decimals to 3. Does the layout definition only apply to the display of the value or does it also apply to the decimal precision used in actual calculations?

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

6 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Dec 03, 2007 at 06:21 PM

    It will only apply to that Key figure.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 03, 2007 at 06:21 PM

    Did you mean it only applies to how the key figure is displayed?

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 03, 2007 at 06:36 PM

    yes

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 03, 2007 at 06:39 PM

    <b>Decimal places (of a key figure)</b>

    This field describes the number of decimal places that are displayed by default for the field in the Business Explorer. This display can be overwritten in Queries.

    The possible values are stored as fixed values in a domain.

    Source : <b>F1</b>

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 03, 2007 at 06:55 PM

    I should have specified - this is for BPS, not IP.

    What's confusing is that according to SAP help:

    "If you determine decimal places in the properties of the planning layout this overwrites all other settings. The settings in the layout cannot be used to increase the accuracy of those values saved in the database."

    it's the "overwrites all other settings" statement that I'm looking for clarification on. If in the layout properties you choose a decimal value lower than the database precision as defined by the key figure itself , what exactly is the impact?

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi,

      the decimal setting in the Layout Builder are 'screen decimals' not technical decimals. The 'precision' of a key figure is determined by the technical type used in the DB.

      BPS uses the following display decimals

      - technical settings, if nothing is defined in rsd1 or Layout Builder

      - rsd1 settings, if defined and nothing is defined in the Layout Builder

      - Layout Builder settings, if defined

      In BPS the display decimals will be checked, e.g.

      - float key figure, 3 display decimals; input 1.1234, transfer -> error message

      Float key figures internally are used with full precsion of ABAP FLOAT type, but be careful: Decimal number are not exact in ABAP FLOAT (i.e. 'double' in C, C++),

      some DB platforms use different formats. So aggregation in DB and ABAP may lead to slightly different values. This can lead to problems with 'delete' planning functions, cf. other threads in this discussion forum.

      Regards,

      Gregor

  • author's profile photo Former Member
    Former Member
    Posted on Dec 05, 2007 at 01:57 PM

    Thanks - that's very helpful. Yes - it's the delete function in particular that we're having issues with for our FLTP key figures, due to 'residual' values being left behind.

    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.