topic Can i select data from a view in Application Development and Automation Discussions

Can i select data from a view

Former Member — Mon, 25 Jun 2007 05:52:27 GMT

I need to select weight and weight unit for an equipment .

It is in view ITOB -can i select from that or is it in any other table.

Thanks in advance.

Re: Can i select data from a view

Former Member — Mon, 25 Jun 2007 05:53:58 GMT

Check the table fields that form the view fields (guess its third tab in the display of view in SE11)

Use the underlying tables to get the required data.

Regards

Raj

Re: Can i select data from a view

Former Member — Mon, 25 Jun 2007 05:56:08 GMT

Hi Anjali ,

Yes you can select data from the view ITOB as it is a Database view, the process is similar to selecting data from a database table .

Assign points if helpful

Regards

Arun

Re: Can i select data from a view

Former Member — Mon, 25 Jun 2007 06:02:54 GMT

Hi,

Yes you can select the data from a view the same way you select it from a table.

There are no implication of selecting data from a view , you will get all the records which satisfy the conditions specified in the view i.e all records based on the mapping done between the fields of the tables used in the view.

Just take a view e.g.ITOB and go to the Table/join conditions , there you can see the tables used and the condition ,i.e. the mapping between the records in the tables , so all the records that satisfy that condition will be in the view.

Select * into table zview from ITOB.

Regards,

Priyanka.

Re: Can i select data from a view

gopi_narendra — Mon, 25 Jun 2007 06:04:36 GMT

You can select data from the VIEW in the same way as from a table.

View contains the logical data that is joined from different table. You can view the relation between tables in SE11 and its join conditions also

Regards

Gopi

Re: Can i select data from a view

former_member391118 — Mon, 25 Jun 2007 06:32:19 GMT

Hi,

You can select data from any VIEW as the same way as you select data from any table. But some times it may give redundant records if the join conditions produce multiple records even though the table has single records. So, if you get redundant records you can use DISTINCT to avoid getting redundant records.

Regards,

Jashua

Re: Can i select data from a view

Former Member — Mon, 25 Jun 2007 06:56:23 GMT

Thanks