get data from Maint. view

[Former Member]

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]

Hi,

Select using a inner join of the tables below:

T001W

T001K

T005

Regards,

Felipe

[SuhaSaha]

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]

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!!!