read databaseview in program

[Former Member]

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

[Former Member]

Hi,

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

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

[Former Member]

same as u read a transparent table..

SELECT field1 fields2 from DBVIEW

into table it_view

where field IN s_option.

[GauthamV]

SEARCH in SCN you have so many posts on same

[Former Member]

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.