topic Decimal point in Application Development and Automation Discussions

Decimal point

former_member626380 — Fri, 24 Apr 2020 11:46:19 GMT

if output field = 22222.22

How to make ouput like 22,222.22

I declared field type p decimal 2 not true

And used type BSIK-WRBTR

BUT not true too

How to make result 22,222.22

Re: Decimal point

michael_piesche — Fri, 24 Apr 2020 12:41:15 GMT

It seems like your output is the internal representation of a number with fixed length and decimals (only decimal point, no thousands separator for digit grouping). So no Output Conversion has taken place for your 'output'. What coding/technique are you using to output the data?

Please provide coding or screenshots:

Defintion of variable
Setting value of variable
Using variable for output
What/where is the output?
a) Selection-Screen of Report
b) Selection-Screen Output of Report with WRITE commands
c) Dynpro Screen
d) Messages/Logging for Jobs in SM37 or Logs in SLG1
e) Export to file e.g. Excel
f) others?

Be also aware, that depending on the DDIC data element or the ABAP internal type, that the format of the displayed numbers is in general dependent on your default user settings (System->User Profile->Own Data->Defaults->Decimal Notation):

[ ] 1.234.567,89
[X] 1,234,567.89
[Y] 1 234 567,89

For DDIC domains that are assigned to the data elements, there can also be a CONVERSION-EXIT defined, that also changes how the output is presented, and this can be different for different SAP Releases:

in Rel. 753 WRBTR has the Domain AFLE13D2O16N_TO_23D2O30N with the Conversion-Exit AU132
Data Type CURR with 23 characters including 2 decimal places and the output lenght is 30 characters (for digit grouping)
in Rel. 740 WRBTR has the Domain WERT7 with no Conversion-Exit (so only default user settings apply)
Data Type CURR with 13 characters including 2 decimal places and the output lenght is 16 characters (for digit grouping)

Re: Decimal point

foessleitner — Fri, 24 Apr 2020 21:17:53 GMT

Hi,

I would like to add that you also can use String Expressions to change the output of fieldvalues - of course also for decimals fields.

Check: String Embedded Expressions: DECIMALS and NUMBER.

Kind Regards, Johann

Re: Decimal point

michael_piesche — Wed, 13 May 2020 15:41:53 GMT

alaa-azazy, please follow up on your open question.

comment answers or your question if there are still open issues.
otherwise mark an answer as accepted if it helped you solve your problem
or post an answer of yourself and accept it if you found another useful solution yourself
or redirect your question to another question that is related and was useful to solve your problem
in the end, close your question