topic Reading data from View in Application Development and Automation Discussions

Reading data from View

Former Member — Tue, 31 May 2011 08:47:17 GMT

HI all,

Can anyone help me please. I want to read data from view with below simple program

Report zread_view.

DATA: it_t053 TYPE TABLE OF V_T053,

wa_t053 like line of it_t053.

*SELECT * INTO TABLE it_t053 from v_t053.*

LOOP AT it_t053 INTO wa_t053.

WRITE: / wa_t053-KURZT.

ENDLOOP.

But when activating this message is show:

'V_T053" is not defined in the ABAP Dictionary as a table, projection view, or database view.

Need for anyone help...?

Thanks,

Ramses

Re: Reading data from View

Former Member — Tue, 31 May 2011 08:58:58 GMT

hi,

which view you are accessing in the program? you can able to access only database view and projection view from prgram.

the view which you are using in the program is niether database view nor projection view. that is why you are getting that error message ''V_T053" is not defined in the ABAP Dictionary as a table, projection view, or database view".

hope this will help you.

Regards,

Kiran

Re: Reading data from View

Former Member — Tue, 31 May 2011 09:01:53 GMT

hai friend ,

instead of using v_t053 you can use the table t053 .

thanks,

anji.

Re: Reading data from View

Former Member — Tue, 31 May 2011 09:16:15 GMT

Hi folks,

After do checking, V_T053 is categorized as Maintenence View, but it is not possible to do select query from maintenance view..?

If I query directly from table T053, need to specify SPRAS = sy-langu.

But thanks for your all responds.

Rgds,

Ramses

Re: Reading data from View

Former Member — Tue, 31 May 2011 09:22:48 GMT

Hi,

Maintenance views do not store data. You cannot get data from v_157D since it is a Maintenance view.

Or else once you try using FM 'VIEW_MAINTENANCE_CALL'.