Problem while retrving data from a view

[Former Member]

Hi Friends

i have a problem while retriving data from a view <b>v_t685a</b>.

the error message is :""" "V_T685A" is not defined in the ABAP Dictionary as a table, projection view or database view."""

i wrote : select single VTEXT1 from V_T685A into w_cst_jin1 where

KSCHL = 'JIN1' and

KAPPL = 'V'.

how to retrive the data.

waiting for quick response

Regards

Mukesh

[Former Member]

Hi

This is a Maintenance View, not a Database View

SO can't fetch data using select statement.

You can use the Table <b>T685</b> directly to fetch the condition Types data straight away instead of the view. write the same select for this table and use.

Regards

Anji

Message was edited by:

Anji Reddy Vangala

[Former Member]

Hi Mukesh,

You can't retrieve data from this view as it is a maintainance view.

regards,

Atish

[former_member404244]

Hi,

u can use table t685a and t685 ...kindly retirieve it by using these tables.

Rewrad if helpful.

Reagrds,

nagaraj

[Former Member]

Thanks,, My Query is solved