topic Re: Select query on two Database views in Application Development and Automation Discussions

Select query on two Database views

Former Member — Fri, 18 Dec 2009 06:29:45 GMT

Hi all,

Can i fetch the data by writing a select query on two DATABASE VIEWS

Because i am able to fetch data by writing a selct query on ONE DATABASE VIEW and ON TRANSPARANT TABLE

but i am not able to fetch data by writing a query on TWO DATABASE VIEWS

Query which i am able to fetch data is

select * from CSKS where OBJNR = COVJ-OBJNR

Query which i am NOT able to fetch data is

Select * from COAS where OBJNR = COVJ-OBJNR

Here

COVJ is a DATABASE VIEW

CSKS is a Transparant Table

COAS is a DATABASE VIEW

Thanks in advance

Regards

Ajay

Former Member — Fri, 18 Dec 2009 06:43:50 GMT

Hello

Post your code here (part with selects).

Former Member — Fri, 18 Dec 2009 06:44:20 GMT

I tried with code and I am able to fetch data from view COAS

DATA:it_coas TYPE STANDARD TABLE OF coas.

SELECT * FROM coas INTO TABLE it_coas.

IF sy-subrc IS INITIAL.

WRITE:/ 'Sucess'.

ENDIF.

I think in your case COAS view does not have a value for COVJ-OBJNR.

Regards

Srilaxmi