topic Re: Database view in Application Development and Automation Discussions

Database view

Former Member — Fri, 24 Aug 2007 20:53:45 GMT

I have to retrieve data from 7 tables and the conditions may vary .

My question is , can I query a database view with sql statements

Former Member — Fri, 24 Aug 2007 20:56:28 GMT

if view type is database view then you can write the sql query..

select * from v_usr_name into table i_usr.

Thanks

Seshu

Former Member — Fri, 24 Aug 2007 21:05:14 GMT

Check the below code ,here i written join on two tables mara and v_usr_name(Database view)..

REPORT ZJOINS message-id z01. .

data : begin of i_join occurs 0,

matnr like mara-matnr,

ernam like mara-ernam,

NAME_TEXT like v_usr_name-NAME_TEXT,

end of i_join.

start-of-selection.

select a_{matnr a}ernam b~NAME_TEXT into table i_join

from mara as a inner join v_usr_name as b on b_{bname = a}ernam.

loop at i_join.

endloop.

Thanks

Seshu