selecting data from view

[Former Member]

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

[Clemenss]

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

[Former Member]

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

[Former Member]

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