Data type miss match

[Former Member]

Hi Friends,

I have used the table control from my data, all the data is displayed fine but not in the same data type what i have defined in the final internal table. I am not understanding how to sort this issue, pls kindly help me in this.

ex: dmbtr actual value is 50000.00

but it is displaying like 50.000,00

Can any one tell me how to defined the currency field in the internal table, so that i can defined it individually without refering to the database table fields,

Regards,

Line

[Former Member]

Hi Friends,

I have used the table control from my data, all the data is displayed fine but not in the same data type what i have defined in the final internal table. I am not understanding how to sort this issue, pls kindly help me in this.

ex: dmbtr actual value is 50000.00

but it is displaying like 50.000,00

Can any one tell me how to defined the currency field in the internal table, so that i can defined it individually without refering to the database table fields,

Regards,

Line

[Former Member]

hi Line,

try using packed decimals.

data: lv_dmbtr(20) type p decimals 2.

Also, you can use the Character format and write the values into the character

field as per the required format.

hope this helps,

Sajan Joseph.

[Former Member]

Hi,

Can u tell me how to use the curr data type of length 15 and decimal places 2

Regards,

Line

[surya_gupta3]

I think, this is probably due to settings of your display.

The value getting displayed is 50.000,00

You can notice here that insteed of . you are getting , and insteed of , you are getting .

Please use your display settings.

Else use WRITE <fld> TO <final_itab_fld> CURRENCY w.

Regards,

Surya

[Former Member]

Hi,

Can u pls tell me how to change the display settings ? I think it is not the problem with the display settings, because when i created the table control with wizard actual length of dmbtr is 13 and 2 decimal of data type curr but in the table control I am only getting the length of the field as 7.

I am afraid of this, any one help me! rewarded sure.

Regards,

Line

[Simha_]

Hi,

Go to System--->User profile---->Owndata.

And in that defaults tab

U will find decimal notation.

Change it as u want...

Cheers,

Simha.

Reward all the helpful answers...

[Former Member]

Hi there. To view or change your display settings, at the top of your screen choose "System" then "User Profile" then "Own Data". Go to the "Defaults" tab and then choose the format that you want for "Decimal Notation". Then save your changes. I would suggest logging out afterwards and then logging back in to make sure the changes take effect.

- April King

[former_member491305]

Hi,

In screen painter ,change <b>visible length</b> of the table control fields according to the field length.

[Former Member]

I tried it also but cannot get the proper output.

Regards,

Line

[aabhas_wilmar]

This might be because of the user settings. Try changing them. Also check the country settings.

or else you can also write in ur code the following line to set country specific settings.

SET COUNTRY '<Country Code>'

eg:

SET COUNTRY 'IN' for India

Reward if helpful...

[Former Member]

Hi,

But the data is correct in the internal table, when the data is populating in the table control it is creating problem.

Regards,

Line

[Former Member]

Hi,

Use write statement with edit mask option.

regards,

bhaskar