12-17-2008 12:30 PM
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
12-17-2008 12:38 PM
HI,
try this way....
select * from view
into table it.
where bukrs = P_BUKRS
vtweg in S_CHNL.
12-17-2008 12:39 PM
12-17-2008 12:43 PM
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 ...
12-17-2008 1:03 PM
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
12-17-2008 12:41 PM
Hi ,
To the extent i remember you can only use a database view in select statement .
Regards
Arun
12-17-2008 1:07 PM
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