Billing & Invoicing amount decimal places

[Former Member]

Hi,

do you know any way to extend the decimal places for the AMOUNT fields in Billing & Invoicing transactions?

Actually the amount comes with 2 decimals (12.34) and I'm studying the feasibility of extending it up to 7 (12.3456789).

Thanks,

John

[Former Member · Accepted solution]

Hi John

All amounts in SAP (including the billing invoicing tables) are defined as CURR, 13 characters, 2 decimals. This is something you cannot change.

However, all amount fields have a currency field assigned to. For example amount:

ERDK.TOTAL_AMNT    Data Type CURR

is assigned to currency field

ERDK.TOTAL_WAER   Data Type CUKY

(you can check this in transaction SE11, by double clicking onto the amount field).

The currency key holds the number of decimals required for the currency, for example JPY has 0 decimals, but the decimals of the amount field are used because of the larger numbers required.

You can create your own currency, where you can specify the number of decimals (table TCURX). For example:

NZD - Standard with 2 decimals (Not in TCURX)

NZD5 - Same as standard currency only with 5 decimals (in TCURX).

In the IMG go to:

  SAP NetWeaver

    -  General settings

      -  Currencies

        -  Set Decimal Places for Currencies

Yep

Jürgen

[Former Member]

Hi Juergen,

many thanks for your advice. In fact, I would consider your solution (by defining a new currency) and link it to all the involved organizations, rather than implementing custom logic/enhancements.

I have just one concern:

e.g. in EA22 - Display billing document, the standard amount field (NETTOBTR) has 2 decimals; how will it be displayed if the BillDoc is created with the new currency (7 decimals)?

[Former Member]

Hi John

I don't have the time to check it, but - YES - it should show it in the format defined by the currency linked to the amount field.

Just give it a try, for example with JPY, which shows no decimals.

Yep

Jürgen