Regarding Table Control in screen Painter

[Former Member]

hi,

In my table control, one column is aceepting the UV Rate of the Material. But that particular column did not accept the Decimal Value . when i enter the decimal,

'Please enter the Numeric value' error is coming.

I am declared as Curr Data type for my table zuvrate-dmbtr.

how can i enter decimal value in that column?

[Former Member]

hi,

In my table control, one column is aceepting the UV Rate of the Material. But that particular column did not accept the Decimal Value . when i enter the decimal,

'Please enter the Numeric value' error is coming.

I am declared as Curr Data type for my table zuvrate-dmbtr.

how can i enter decimal value in that column?

[Former Member]

Have you declared the reference field for the currency field in the screen painter? The ref. field parameter can be found in the 'Dictionary' tab under the attributes. Enter the reference field here (eg: T001-WAERS).

Sudha

[Former Member]

this problem will occur with currency and quantity fields...

instead use another variable of type c.

var(len) type c. then assign the values accordingly u ll get correct result.

[Former Member]

Hi sudha,

i have already declared the reference field t001-waers. but it is also showing error?

Is there any other way to enter decimal number in table control?

Regards,

Neptune.M

[Former Member]

Is the screen field referring to the dictionary field? Is the 'From Dict' attribute ticked?

Sudha

[Former Member]

Hi Sudha ,

thanks for your answer.

In screen Painter screen , From Dict is ticked.

But i cant enter the decimal values.

Thanks,

Neptune.M

[Former Member]

Hi Sudha ,

thanks for your answer.

In screen Painter screen , From Dict is ticked.

But i cant enter the decimal values.

Thanks,

Neptune.M

[Former Member]

Neptune,

I think this should solve your problem - in the field attributes, uncheck the 'From dict' and specify the format as DEC (decimal) instead of CURR. I tried with a sample program and this seems to work perfectly.

Sudha

Message was edited by: Sudha Mohan

[Former Member]

Hi Sudha,

If i Uncheck the from dict and i gave as dec then Data type mismatch error is coming ?

For you how it is working?

and one more thing, If i change in table as dec data type, then more than one decimal places will be showing .

For eg If i Give 23456 then

234.56000 value is showing in the table control.

ig i give 233456768 then

23.345.678.9000 value is showing in the table control.

Now what can i do?

Thanks,

Neptune.M

[Former Member]

Neptune,

Lets start from the beginning -

Your custom table has a field called DMBTR (domain WERT7). The reference value for this field is T001-WAERS.

Hope its correct so far.

In the table control, your field DMBTR is called <customtablename>-DMBTR.

In the screen attributes of this field, you have the 'From Dict' ticked, Format is CURR and the reference field is specified. Correct?

If this is the case then the table control should not throw any errors, do let me know if there is any change.

Update: I just figured, probably the reason for your errors is that you have not used the domain in your custom table and have specified the CURR type as a direct type. The problem with this is that 2 decimal places will always be required by the system. Whereas if you use the data element (eg: DMBTR), the output length is 16, which would work fine.

Sudha

Message was edited by: Sudha Mohan

[Former Member]

Hi sudha,

In My table , uvrate column structure is like this,

dmbtr dmbtr curr 13 2 ,

Now From Dict is also ticked,

But i got error once again in table control.

Neptune.M

[Former Member]

Hi all,

In My user table , uvrate column structure is like this,

dmbtr dmbtr curr 13 2 ,

reference field is t001-waers,

in screen painter,

From Dict is also ticked,

But My problem is,

i cant enter decimal values to the table control.

If i enter decimal entry, Please enter numeric error is coming.

actually where is the problem? and what is the Problem?

Plz if anyone knows, reply me.

Thanks,

Neptune