Select statement on maintenance view.

[Former Member]

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

[Former Member]

HI,

try this way....

select * from view

into table it.

where bukrs = P_BUKRS

vtweg in S_CHNL.

[Former Member]

Hi

for maintanence view we con't write Select Stmt .

[Former Member]

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

[Former Member]

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

[Former Member]

Hi ,

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

Regards

Arun

[SuhaSaha]

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