topic Re: Read data from View in Application Development and Automation Discussions

Read data from View

Former Member — Fri, 21 Apr 2006 06:29:23 GMT

Hello All

How can we read/select data from a view. I have written a select query for that but I m getting syntax error like "

"V_TVST" is not defined in the ABAP Dictionary as a table,

projection view or database view.

How can I go about this ?

Thanks

Tharani

Former Member — Fri, 21 Apr 2006 06:31:34 GMT

Hi,

V_TVST is a <b>Maintenance View</b>.

You can only read data from projection view or database view.

Regards,

Wenceslaus.

Former Member — Fri, 21 Apr 2006 06:33:13 GMT

then what is the way that I can get data from a maintenance view?

Thanks

Tharani

Former Member — Fri, 21 Apr 2006 06:33:33 GMT

Hi !

The "Data-Tables" or often similar named as the "views".

In your example the data are possibly in table TVST.

You cannot select to V_TVST becase it is a logical View for the SM30 and not a view that is created as a databse view in SE11.

Regards

Rainer

Some forum points would be fine if that helped you a bit...

Former Member — Fri, 21 Apr 2006 06:36:05 GMT

Hi,

You can get data from the underlying SAP databases ( TVST

TVSTT) but not from v_tvst which is a maintenance view.

<b>Make a join between TVST and TVSTT on the VSTEL field.</b>

Ps: Reward helpful posts.

Regards,

Wenceslaus.

Former Member — Fri, 21 Apr 2006 06:37:39 GMT

the values entered in v_tvst r stored in database table tvst...

u can use that for ur selection.

regards,

Bikash