Syntax error not defined as table or projection view or database view

[Former Member]

All,

I have to select a Maintenance View V_tcurr when I do Select statement I am getting SYNTAX ERROR stating its not defined as table or projection view or database view in Abap dictionary.

Can you give me a hint, how do I select maintenance View in the select statement ?

Any help will be highly appreciated.

Thanks

[Former Member]

Raja,

Maint View V_tcurr connects to DB table tcurr - and there is no join in the maint view.

Just do your SELECT against TCURR.

[Former Member]

data: lt_TCURR TYPE TABLE OF TCURR.

data: lv_TCURR TYPE TCURR.

SELECT * INTO TABLE lt_tcurr

FROM TCURR.

TCURR just has some extra fields that are exlcuded in the Maint View.

[Former Member]

Thanks for your reply.

Got hint that we can't select entries from Maintenance views, which do not store data. We can get data using FM 'VIEW_MAINTENANCE_CALL'.

[wanjiru]

USE HIGHLIGHTED STEPS