topic Re: Select statement on maintenance view. in Application Development and Automation Discussions

Select statement on maintenance view.

Former Member — Wed, 17 Dec 2008 12:30:34 GMT

Hello Friends,

I have a quick question. I have a maintenance view, and I want to do a select statement on this view in an ABAP program, but seems like the view is not filled with data when running the program.

How do I get the view to be populated at runtime in the ABAP program? the work area and the internal table is TYPE of the view..

Here's the code:

select * into wa

from view

where bukrs = P_BUKRS

vtweg in S_CHNL.

append wa to it.

endselect.

best regards B

Re: Select statement on maintenance view.

Former Member — Wed, 17 Dec 2008 12:38:48 GMT

HI,

try this way....

select * from view

into table it.

where bukrs = P_BUKRS

vtweg in S_CHNL.

Re: Select statement on maintenance view.

Former Member — Wed, 17 Dec 2008 12:39:14 GMT

for maintanence view we con't write Select Stmt .

Re: Select statement on maintenance view.

Former Member — Wed, 17 Dec 2008 12:41:50 GMT

Hi ,

To the extent i remember you can only use a database view in select statement .

Regards

Arun

Re: Select statement on maintenance view.

Former Member — Wed, 17 Dec 2008 12:43:06 GMT

Ok, thanx.

Where can I see which tables the view gets it's data from.

In SE11 I only see the data-elements for the fields ...

Re: Select statement on maintenance view.

Former Member — Wed, 17 Dec 2008 13:03:11 GMT

Hi ,

In SE11 when you see the join , there is a tab with the name Table/Join Condition , there you will get the table and the condition based on which the data is displayed.

Regards

Arun

Re: Select statement on maintenance view.

SuhaSaha — Wed, 17 Dec 2008 13:07:49 GMT

Hello B,

Just to inform you: "You can select data only from Database Views".

You can design a work-around for this, by taking look @ the Join tables. May i know form which View you want to get the data?

BR,

Suhas