topic Re: Database View in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/database-view/m-p/1834971#M355474 <HTML><HEAD></HEAD><BODY><P>Thanks Guru,</P><P></P><P></P><P>In IMRG table for field CNTRR the datael ement is IMRC_READG</P><P>and in domain the conversion rutin is blank.</P><P></P><P></P><P>the value in field of type FLTP e is 2.2680000000000000E+05 where as it should appear as 63 in view .</P><P></P><P></P><P>pankaj</P></BODY></HTML> Fri, 05 Jan 2007 06:33:23 GMT Former Member 2007-01-05T06:33:23Z Database View https://community.sap.com/t5/application-development-and-automation-discussions/database-view/m-p/1834967#M355470 <HTML><HEAD></HEAD><BODY><P>Hi Friends,</P><P></P><P>Can we created calculated fields in a view.</P><P></P><P>Can we create field in a view using function module.</P><P></P><P>Please suggest ...</P><P></P><P>Pankaj</P></BODY></HTML> Fri, 05 Jan 2007 04:33:04 GMT https://community.sap.com/t5/application-development-and-automation-discussions/database-view/m-p/1834967#M355470 Former Member 2007-01-05T04:33:04Z Re: Database View https://community.sap.com/t5/application-development-and-automation-discussions/database-view/m-p/1834968#M355471 <HTML><HEAD></HEAD><BODY><P>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?</P><P></P><P>- Guru</P><P>Reward points for helpful answers</P></BODY></HTML> Fri, 05 Jan 2007 04:46:56 GMT https://community.sap.com/t5/application-development-and-automation-discussions/database-view/m-p/1834968#M355471 Former Member 2007-01-05T04:46:56Z Re: Database View https://community.sap.com/t5/application-development-and-automation-discussions/database-view/m-p/1834969#M355472 <HTML><HEAD></HEAD><BODY><P>Hi Guru,</P><P>I will give u my exact requirement.</P><P></P><P>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.</P><P></P><P>I have debuged sap program where they have used FM FLTP_CHAR_CONVERSION_FROM_SI to display data in decimal.</P><P></P><P></P><P>My query is can I create field using above FM so that I could a display data in decimal.</P><P></P><P></P><P>Pankaj</P></BODY></HTML> Fri, 05 Jan 2007 04:56:15 GMT https://community.sap.com/t5/application-development-and-automation-discussions/database-view/m-p/1834969#M355472 Former Member 2007-01-05T04:56:15Z Re: Database View https://community.sap.com/t5/application-development-and-automation-discussions/database-view/m-p/1834970#M355473 <HTML><HEAD></HEAD><BODY><P>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.</P><P></P><P>In the data emement of the field, use FLTP_CHAR_CONVERSION_FROM_SI as the conversion routine and your problem will be solved.</P><P></P><P>- Guru</P><P>Reward points for helpful answers</P></BODY></HTML> Fri, 05 Jan 2007 05:42:02 GMT https://community.sap.com/t5/application-development-and-automation-discussions/database-view/m-p/1834970#M355473 Former Member 2007-01-05T05:42:02Z Re: Database View https://community.sap.com/t5/application-development-and-automation-discussions/database-view/m-p/1834971#M355474 <HTML><HEAD></HEAD><BODY><P>Thanks Guru,</P><P></P><P></P><P>In IMRG table for field CNTRR the datael ement is IMRC_READG</P><P>and in domain the conversion rutin is blank.</P><P></P><P></P><P>the value in field of type FLTP e is 2.2680000000000000E+05 where as it should appear as 63 in view .</P><P></P><P></P><P>pankaj</P></BODY></HTML> Fri, 05 Jan 2007 06:33:23 GMT https://community.sap.com/t5/application-development-and-automation-discussions/database-view/m-p/1834971#M355474 Former Member 2007-01-05T06:33:23Z Re: Database View https://community.sap.com/t5/application-development-and-automation-discussions/database-view/m-p/1834972#M355475 <HTML><HEAD></HEAD><BODY><P>Hi Guru,</P><P></P><P>which conversion rutin should i use.</P><P></P><P>Thanks</P><P>Pankaj</P></BODY></HTML> Fri, 05 Jan 2007 07:20:49 GMT https://community.sap.com/t5/application-development-and-automation-discussions/database-view/m-p/1834972#M355475 Former Member 2007-01-05T07:20:49Z Re: Database View https://community.sap.com/t5/application-development-and-automation-discussions/database-view/m-p/1834973#M355476 <HTML><HEAD></HEAD><BODY><P>Not sure which one you have to use as your requirement is very specific.</P><P></P><P>- Guru</P><P>Reward points for helpful answers</P></BODY></HTML> Fri, 05 Jan 2007 18:04:11 GMT https://community.sap.com/t5/application-development-and-automation-discussions/database-view/m-p/1834973#M355476 Former Member 2007-01-05T18:04:11Z