Read data from View

[Former Member]

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]

Hi,

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

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

Regards,

Wenceslaus.

[Former Member]

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

Thanks

Tharani

[Former Member]

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]

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]

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

u can use that for ur selection.

regards,

Bikash