topic Re: Data type miss match in Application Development and Automation Discussions

Data type miss match

Former Member — Wed, 18 Apr 2007 16:34:53 GMT

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

Re: Data type miss match

Former Member — Wed, 18 Apr 2007 16:38:46 GMT

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.

Re: Data type miss match

surya_gupta3 — Wed, 18 Apr 2007 16:39:31 GMT

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

Re: Data type miss match

Former Member — Wed, 18 Apr 2007 16:44:35 GMT

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

Re: Data type miss match

Simha_ — Wed, 18 Apr 2007 16:47:36 GMT

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...

Re: Data type miss match

Former Member — Wed, 18 Apr 2007 16:48:07 GMT

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

Re: Data type miss match

aabhas_wilmar — Wed, 18 Apr 2007 16:48:43 GMT

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...

Re: Data type miss match

Former Member — Wed, 18 Apr 2007 16:51:19 GMT

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

Re: Data type miss match

former_member491305 — Wed, 18 Apr 2007 16:55:18 GMT

Hi,

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

Re: Data type miss match

Former Member — Wed, 18 Apr 2007 17:07:05 GMT

I tried it also but cannot get the proper output.

Regards,

Line

Re: Data type miss match

Former Member — Wed, 18 Apr 2007 17:11:21 GMT

Hi,

Use write statement with edit mask option.

regards,

bhaskar

Re: Data type miss match

Former Member — Wed, 18 Apr 2007 17:18:10 GMT

Hi,

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

Regards,

Line