topic Re: read databaseview in program in Application Development and Automation Discussions

read databaseview in program

Former Member — Tue, 20 Jan 2009 11:51:48 GMT

Hello @ all,

I create i databaseview with some joins in the ddic. I want to read databaseview in my program and write this data in a internal table. How can I do this?

Thanks.

Regards

Chris

Re: read databaseview in program

Former Member — Tue, 20 Jan 2009 11:53:44 GMT

Hi,

It's normal way how you read the data from the database table.

SELECT * FROM <VIEW> INTO Table <iTAB> WHERE <CONDT>.

Re: read databaseview in program

Former Member — Tue, 20 Jan 2009 11:54:22 GMT

same as u read a transparent table..

SELECT field1 fields2 from DBVIEW

into table it_view

where field IN s_option.

Re: read databaseview in program

GauthamV — Tue, 20 Jan 2009 11:55:03 GMT

SEARCH in SCN you have so many posts on same

Re: read databaseview in program

Former Member — Tue, 20 Jan 2009 11:56:51 GMT

Hi,

In database views, the join conditions can be formulated using equality relationships between any base fields. In the other types of view, they must be taken from existing foreign keys. That is, tables can only be collected in a maintenance or help view if they are linked to one another via foreign keys.

Regards,

Phani.