Skip to Content

SAP local Currency up-to 3 Decimal Places

Dear Experts,

We have a customer requirement wherein we have to show local currency amount up to 3 decimal places in SAP.

company code local currency has been set as BHD wherein up to 3 decimal places are permitted.

when we see any standard report local currency amount shows only up to 2 decimal places.

Can some one please advise

Regards,

Manish

.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • Jan 14 at 09:16 AM

    Hi,

    Bahrain company code currency will be 3 decimal in standard. so all the standard report will show 3 decimals.

    Regards

    Shihab

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 14 at 10:59 AM

    Hi Shihab,

    I am working for Industry Specific Unit : FICA wherein in DFKKOP table i.e. item table there are two fields BETRH & BETRW wherein BETRH is local currency amount & BETRW is amount field only.

    we have to use local currency field in all the programs which we intend to develop but however this field is saving data up to 2 decimal places only.

    attached snapshot for reference.

    Regards,

    manish capture.png

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 14 at 12:55 PM

    Hi,

    In SAP there are issues with displaying the decimals defined in the currency. Some reports have to be adjusted with OSS note implementation, others - remain incoherent and there is no standard solution for it; depending on the domain.

    Therefore, when you say' any standard report', can you give an example?

    Regards,

    Eli

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 15 at 01:10 PM

    Hi Eli,

    Thanks for the reply.

    Refer attached snapshots for reference.

    regards,

    Manish

    snapshots-1.jpg

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Eli,

      Amount in FPE3 and all the standard reports used in FICA is shown with 3 decimal places.

      Issue is not specific to FICA when we transfer values from FICA - FICO then again BSEG table is updated with 2 decimal places and standard report like FBL3N is showing 3 decimal places. ( here i am referring to FPG1 transferring total records of FICA to General Ledger)

      refer attached snapshots.

      we will surely raise an OSS note for this.snapshots1-1.jpg

      Regards,

      Manish

      snapshots1-1.jpg (301.1 kB)
  • Jan 24 at 08:02 AM

    Raising OSS note to SAP & will share an update on this forum for all.

    regards,

    Manish

    Add comment
    10|10000 characters needed characters exceeded

    • Just one question: are you sure that at no point the settings for BHD were not changed in OY04? Because, this could've caused these inconsistencies. You can check the log of this via Menu - Utilities - Change logs

  • Jan 24 at 12:37 PM

    Hi Eli,

    we ensured that no changes are done in OY04 at any point of time for BHD.

    regards,

    Manish

    Add comment
    10|10000 characters needed characters exceeded