Database View

[Former Member]

Hi Friends,

Can we created calculated fields in a view.

Can we create field in a view using function module.

Please suggest ...

Pankaj

[Former Member]

If you mean to say that you want to update a field at runtime based on the values of the other fields value in the same row, then that is not possible. Also you cannot create a view using function module. Anyways, why would anyone want to do it?

- Guru

Reward points for helpful answers

[Former Member]

Hi Guru,

I will give u my exact requirement.

I have created database view from table imrg and selected the field counter reading ( CNTRR ) . This field is of FLTP type. I want to show the value in this field in decimal.

I have debuged sap program where they have used FM FLTP_CHAR_CONVERSION_FROM_SI to display data in decimal.

My query is can I create field using above FM so that I could a display data in decimal.

Pankaj

[Former Member]

This is nothing but conversion routine for that field. If you look at the properties of the data element/domain of the field you will find the conversino routine it uses. If you use the same conversion routine in the data element of the table you will not have this problem.

In the data emement of the field, use FLTP_CHAR_CONVERSION_FROM_SI as the conversion routine and your problem will be solved.

- Guru

Reward points for helpful answers

[Former Member]

Thanks Guru,

In IMRG table for field CNTRR the datael ement is IMRC_READG

and in domain the conversion rutin is blank.

the value in field of type FLTP e is 2.2680000000000000E+05 where as it should appear as 63 in view .

pankaj

[Former Member]

Hi Guru,

which conversion rutin should i use.

Thanks

Pankaj

[Former Member]

Not sure which one you have to use as your requirement is very specific.

- Guru

Reward points for helpful answers