topic Re: Need help on data element in Application Development and Automation Discussions

Need help on data element

Former Member — Tue, 26 Feb 2008 08:22:10 GMT

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

Re: Need help on data element

Former Member — Tue, 26 Feb 2008 09:25:26 GMT

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.

Re: Need help on data element

Former Member — Tue, 26 Feb 2008 10:10:13 GMT

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.

Sree

Re: Need help on data element

Former Member — Tue, 26 Feb 2008 10:35:14 GMT

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.

Re: Need help on data element

Former Member — Tue, 26 Feb 2008 11:38:20 GMT

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

Sree