Skip to Content

Displaying Invoice value in BHD currency(3 Decimals) using SAP Script...

Hello,

The issue is in displaying Invoice value in BHD currency(3 Decimals) using SAP Script.

Now what i observed is as below -

If the data type of the varibale used for displaying Invoice value(In BHD) is  konv-kwert  then value is getting displayed correctly with 3 decimal.

Eg:250 value would be displayed as 250.000

In driver program the variable value at runtime is 2500.00 but the time SAP script element is called the variable value becomes as 250.000 and is then displayed correctly on output.

But,

If the data type of the varibale used for displaying Invoice value(In BHD) is    fplt-fakwr  then value is getting displayed wrongly with 2 decimal.

Eg:250 value would be displayed as 2500.00(wrong value in output)

In driver program the variable value  at runtime is 2500.00 but the time SAP script element is called the variable value remains as 2500.00 and is shown incorrectly on output.

So my question is how are the above two variable data types affecting/changing the value of variables in SAP script.

Note - Variable with data type  konv-kwert and fplt-fakwr are declared in driver program.

Also i don't see SET COUNTRY syntax affecting anything since only the data type declaration change is solving the issue.

Thanks in Advance!!!

Regards,

Vikas

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Dec 30, 2014 at 06:25 AM

    Hello Experts,

    Any suggestions or any clue that can help me dig it in more details?

    Thoughts are highly appreciated.

    Regards,

    Vikas

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 30, 2014 at 07:59 PM

    hi vikas,

    you have to check this table t005x and decimal format of this field fplt-fakwr only.


    Also you can refer below help from sap.

    Country-Dependent Formatting: SET COUNTRY

    Add comment
    10|10000 characters needed characters exceeded

    • Hello Abdul,

      Thanks for your reply.

      I already have checked for SET COUNTRY and T005X table entry but  didn't found any issue related to it.

      The decimal format is not a problem...Numbers of Decimals values coming after the Decimal('.') for BHD currency by using two different data type fplt-fakwr and  konv-kwert for a varibale is a problem.

      I think the issue is somewhere in the data type fplt-fakwr and  konv-kwert.Seems like data type konv-kwert has the capability to get converted into Country Specific decimal notation?...

      Just as a additiona information -

      fplt-fakwr and VBRK-NETWR data types are behaving in the same way since there domain is same.

      Does the Domain WERTV7(for field konv-kwert ) description gives you any hint?

      Thanks & Regards,

      Vikas

      1.png (16.5 kB)
      2.png (16.6 kB)
  • Dec 31, 2014 at 02:40 AM

    Hi Vikas,

    &konv-kwert (.2)& will give two decimal places


    Hope it helpful.



    Regards,

    Venkat.


    Add comment
    10|10000 characters needed characters exceeded

    • Hello Venkat,

      Thanks for the reply.

      Varibale with data type konv-kwert will give me 3 decimals and not 2 decimals for BHD currecny.

      If the same variable is declared with data type  fplt-fakwr then i get 2 decimals for BHD currency.

      So the issue exist on what impact are those two data types doing for the same currcency output?

      Regards,

      Vikas