topic Re: Syntax error not defined as table or projection view or database view in Application Development and Automation Discussions

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

Former Member — Wed, 15 Jun 2011 17:47:41 GMT

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

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

Former Member — Wed, 15 Jun 2011 18:10:02 GMT

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.

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

Former Member — Wed, 15 Jun 2011 18:14:18 GMT

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.

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

Former Member — Wed, 15 Jun 2011 18:14:49 GMT

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'.

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

ethornsapbasis — Sun, 09 May 2021 13:13:00 GMT

USE HIGHLIGHTED STEPS