topic Re: get data from Maint. view in Application Development and Automation Discussions

get data from Maint. view

Former Member — Mon, 04 Oct 2010 15:54:50 GMT

Hello All,

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

SELECT SINGLE * FROM J_1BT001WV WHERE

1BT001WV -WERKS = WERKS and J_1BT001WV-BUKRS = BUKRS .

but getting an error:

"J_1BT001WV" 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.

Abaper

Former Member — Mon, 04 Oct 2010 16:42:07 GMT

Hi,

Select using a inner join of the tables below:

T001W

T001K

T005

Regards,

Felipe

SuhaSaha — Mon, 04 Oct 2010 17:05:16 GMT

Hello,

You can select data only from Database views. Hence your select fails.

Alternatively you can use the FM 'VIEW_GET_DATA' to fetch the data from the Maint. view.

BR,

Suhas

Former Member — Mon, 04 Oct 2010 20:55:38 GMT

The best would be to create a data base view with the same join as that of your maintenance view and use the select command for that.

Else use the VIEW_GET_DATA.

I prefer the option since it is the easiest way!!!