cancel
Showing results for 
Search instead for 
Did you mean: 

Wrong number of Decimals in FBL3N

racingpro
Explorer
0 Kudos

Hi to all,

I am having a display issue with TCode FBL3N. I am displaying the G/L Account Line Items for various currencies and the number of decimals is 2 for the lines in USD and EUR which is good. The lines with currency CLP (Chiliean Pesos) appears without any decimals. It gives the impression that all amounts were divided by 100.

I've checked the configuration transaction OY04 and the CLP currency code has 0 decimal like most of the other currencies. This is the SAP standard value. I may be wrong but I do not think that this configuration needs to be updated.

I also remarked that in SE16N the G/L Amount field (PSWBT) of table BSEG is shown without any decimals. It might be related to the problem but I am not quite sure.

I had a look at other discussions and some solutions were talking about data conversions and I want to avoid using this kind of tasks.

Does anyone have a clue on what is causing this display issue in FBL3N?

Thank you very much for your help,

Sylvain

Accepted Solutions (1)

Accepted Solutions (1)

former_member132315
Active Participant

Hi, You can check these SAP notes below:

- 137626 - FAQ: Decimal places for currency codes
- 153707 - Currency translation miscalculates by 100, 1000..
- 434349 - Change of decimal places of currencies - 370896
- Line items: special amnt fields not crrncy-specific - 569939
- Line item: Open FI: Absolute amounts

They might help you to resolve your issue.

Best Regards,
Gabriel Mattos.

Answers (3)

Answers (3)

racingpro
Explorer
0 Kudos

Hi guys,

Thank you everyone for your answers. I was assigned to other tasks lately and was not able to reply before.

Since we didn't want to impact any data in the system by modifying the number of decimals in OY04, we decided to create new amount fileds in FBL3N and use conversion routines in the data elements. This option allow us to display the amount fields with the number of decimal positions we want.

Best regards,

Sylvain

soham_252_vanarase1
Discoverer
0 Kudos

Hii Sylvain Ayotte,

Please can you share the solution which you proposed. I am new to ABAP and I am also getting same issue in FBL3N.

former_member229024
Contributor
0 Kudos

Hi Sylvain,

As in OY04, for chielean currency the decimal places allowed is 0, then SAP wont allow to post decimal amounts in chielean currency. So FBL3n displays the zero decimals posted in GL accounts in chielean currency as std.

Cheers,

former_member132315
Active Participant
0 Kudos

Hello Ravish,

Are you using any special field to display this amount?
Can you provide maybe a screenshot of your issue?

Thanks.

Kind Regards,
Gabriel Mattos.

sanilbhandari
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi

I believe that it is SAP Standard

Check the below link

Thanks & Regards


Sanil Bhandari