Need help on data element

[Former Member]

Hi All,

I have created a Z table along with table maintainence. In this table i have created a field called Rate using the data element WERTV9. When i try to maintain the entries in the table say for ex rate = 0.07$, its taking correctly but when i try to display the table entries using SE16, i see the rate is being displayed as 7000$ instea of 0.07$. Could any one please help me on this?

Mahesh

[Former Member]

Hi,

first of all u dont take data element as 'WERTV9' because this is Value field PL9 with +/- sign,

then while creating u dont enter something like 0.07$, u can enter 0.07 that's all then in the currency type u can define either '$' or INR or something else.

seshu.

[Former Member]

Hi,

What is the reference table and reference filed name you have entered while creating the table.

There is something called as currency formatting. You can see the documentation for the same for "write" statement.

So while viewing the data through se16n, before displaying the data, formmattign will occur. where as formmating will not occur when you view se11 display content.

You will get the asnwer if you look at the reference table and filed. aslo do not enter value as 0.07$. just enter 0.07.

BR

Sree

[Former Member]

Thanks for the quick responses.

I have created a Z data elemnt using the domain WERTV9.

also there is a seperate field for curency.

I enter 0.07 only in the rate field and not 0.07$.

While creating the table field the reference table and field which i ahve used is same Z table which i have created and the field is the currency field of the table.

[Former Member]

Mahesh,

as per my opinion nothing can be done from technical point of view. Why it is displaying is because of the currency formatting.

Check table TCURX for USD what is the Number of decimal places filed value.

Hope this will answer ur question

BR

Sree