topic Re: selecting data from view in Application Development and Automation Discussions

selecting data from view

Former Member — Sat, 08 Mar 2008 20:18:42 GMT

Hello All:

I am trying to select a data from view using the SQL

SELECT SINGLE * FROM V_T8A30 WHERE

KONTO_VON GE P_GLACCOUNT

AND KONTO_BIS LE P_GLACCOUNT.

but getting an error:

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

Could someone please let me know if there is any other command to select data from view or any information?

Thanks.

Mithun

Re: selecting data from view

Clemenss — Sat, 08 Mar 2008 21:29:32 GMT

Hi Mithun,

I'm not on the system now but I guess that V_T8A30 is defined as a maintenance view. You can select the data from the underlying table(s), probably T8A30. Got to SE12 dictionary, check V_T8A30 (or is it a type o and you should try V_TBA30). Check the tables in the view and pick the one you need.

Regards,

Clemens

Re: selecting data from view

Former Member — Sat, 08 Mar 2008 23:02:12 GMT

Hi,

You cannot select data directly from Maintenance View.

You need to query the underlying tables involved in that view.

Also try with FM: VIEWPROC_V_T052 or even easier with VIEW_GET_DATA .

thanks

Dan

Re: selecting data from view

Former Member — Fri, 25 Apr 2008 12:05:08 GMT

Use fm VIEW_MAINTENANCE_NO_DIALOG.

Pass your selection condition in the format of SELLIST, and pass the name of your view.

The TOTAL/EXTRACT parameter will contain your required data.

Regards,

Rekha