Decimals in query on General Settings

[Former Member]

Hi experts,

I set the decimal places in General settings as follows;

     Amounts = 0
     Decimals in Query = 2

And currncies settings is as follows;

     EUR : Decimals = 2 Digits

Then for example, Invoice can be input as 10.35 EUR. But if I check the JDT1 by query , the amount shows 10.

It seems that the option for Decilas in query doesn't work. Is that a bug already known??

Also I can't get 10.35 on PLD of Journal entry. The fiels is Debit amount (FC) and Credit amount (FC), they are also shown as 10.I think this is same reason that JDT1 doesn't show 10.35.

I know if I set the decimal places of amounts=2, query shows 10.35. But Local ccy and System ccy have no decimal, so I don't want to set amount =2.   Version is 9.0 PL07.

Please advise.

Thanks and regards,

Kaori

[kothandaraman_nagarajan · Accepted solution]

Hi,

Please check SAP note for clear explanation:

1414744 - Decimal places setting in “Currencies - Setup” window
overrides “General Settings” window

Thanks & Regards,

Nagarajan

[Former Member · Accepted solution]

Hi Nagarajan,

My understanding is same as you and SAP. Decimal places setting in Currencies setup should override General settings.

But even if I defined the decimal field in the Currnecies set up, data (JDT1) has still no decimal...it means that General settings isn't be overriden for data. It works for screen like as Journal Entry or Sales Invoice.   Then I defined "Decimal in Query " in the General settings, but it doesn't work in query.

Do you have any advice?

Thanks,

Kaori

[kothandaraman_nagarajan · Accepted solution]

Hi,

The amount decimal should be 2 in order to get 10.35 in query result.

Thanks & Regards,

Nagarajan

[Former Member · Accepted solution]

Hi Narafajan,

You mean that "Decimal in Query " in the General Settings does not work ?

(I know If  "Amount" in the General Settings is 2, query shows 10.35.)

And SAP Note doesn't fit for query?  Also doesn't fit for PLD? Anyone knows?

Thanks and regards,

Kaori

[kothandaraman_nagarajan · Accepted solution]

Hi,

Tested in 8.82 version:

For example, create sales order with quantity of 1 and unit price 10.35

Condition 1:

Set all decimal places to zero and only set decimal place for query = 2

Run below query:

select t0.quantity , t0.unitprice from RDR1 t0.

Result:

T0.quantity         T0.unitprice

  1                              10

Condition 2 :

Set all decimal places to zero and only set decimal place for query= 2

Run below query to multiply quantity with price

select t0.quantity * t0.unitprice from RDR1 t0.

Result:

T0.quantity         T0.unitprice

  1                              10.35

So decimal place in query will affect when do perform calculation through query.

Condition 3:

Set Price decimal places to 2 and only set decimal place for query= 0

Run below query:

select t0.quantity , t0.unitprice from RDR1 t0.

Result:

T0.quantity         T0.unitprice

  1                              10.35

Final conclusions:

1. When you perform calculation in query (condition 2), the decimal place in query will take effect, regardless of decimal place in all other field

2. When you retrieve data directly from field (condition 3), the decimal place in query will not take effect. But decimal place set for price will take effect.

3. In your case, your query directly retrieve the data from JDT1 table. So that decimal in query (2 place) no effect on query result. Query result shows 10 because, the decimal for price field 0.

4. To get correct result (10.35), you have to set two decimal places for price field.

5. Please ignore the SAP note.

Hope it will be helpful.

Thanks & Regards,

Nagarajan

[Former Member · Accepted solution]

Hi Nagarajan,

I fully understand your conclusions and it helps very much.

I really appreciate for your validation and clarification on my question.

Thanks and regards,

Kaori

[Former Member]

Hello Kaori San,

Would it be possible for you to post a screen shot of General Settings--> Display from the db in which you are facing this issue?

Thanks,

Joseph

[Former Member]

Hi Joseph san,

Please refer the following screen shots;

General settings

Currency (EUR has 2 digits decimals)

Journal Entry (Dr&Cr(FC) show 2 digits decimal, = no problem)

Query view for JDT1 (Dr&Cr amount FC have no decimal. This is problem for us.)

Thanks,

Kaori

[Former Member]

Hi Kaori San,

You may please check as suggested by Nagarajan in a Test db to confirm and in case if you dont see this as a solution, you may open a case with SAP as well..

Thanks,

Joseph