topic Re: Problem while retrving data from a view in Application Development and Automation Discussions

Problem while retrving data from a view

Former Member — Mon, 12 Nov 2007 05:51:26 GMT

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

Re: Problem while retrving data from a view

Former Member — Mon, 12 Nov 2007 05:54:30 GMT

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

Re: Problem while retrving data from a view

Former Member — Mon, 12 Nov 2007 05:55:47 GMT

Hi Mukesh,

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

regards,

Atish

Re: Problem while retrving data from a view

former_member404244 — Mon, 12 Nov 2007 06:01:35 GMT

Hi,

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

Rewrad if helpful.

Reagrds,

nagaraj

Re: Problem while retrving data from a view

Former Member — Tue, 27 Nov 2007 11:20:52 GMT

Thanks,, My Query is solved