topic Re: Retrieving data from diff tables in Application Development and Automation Discussions

Retrieving data from diff tables

Former Member — Wed, 30 May 2007 06:37:33 GMT

Hi ,

Is there any possibility to retrive data from different table without relation between those tables.

Regards

Suresh.D

Re: Retrieving data from diff tables

Former Member — Wed, 30 May 2007 06:39:03 GMT

There should be some link with atleast one field with the other tables, then only we will fetch data from different tables linking them

other wise we can't fetch data.

Reward points if useful

Regards

Anji

Message was edited by:

Anji Reddy Vangala

Re: Retrieving data from diff tables

Former Member — Wed, 30 May 2007 06:40:24 GMT

No you cannot do it.

There has to be some link.

regards

Re: Retrieving data from diff tables

Former Member — Wed, 30 May 2007 06:42:08 GMT

hi,

no they should have relation.

if they don't have any relation then we have to search another table using which we can relate these two tables.i.e.if the two tables have relation with another table then using that we can retrieve data.

Re: Retrieving data from diff tables

Former Member — Wed, 30 May 2007 06:44:48 GMT

Hi,

On what basis would you like to retrieve the data from different tables?

There should be some link b/w the tables in order to retrieve the data

Regards,

Sankar.

Re: Retrieving data from diff tables

S0025444845 — Wed, 30 May 2007 06:46:29 GMT

Hi,

We can not retrieve data from two tables without any relation between them,

there should be some link,may be through some different table i.e third table.

for eg

there is no link b/w VBRP table and T001 table

but we have to retrieve WAERs from t001

then You can pass VBELN into VBRK table and GET BUKRS from there and based on VBRK-BUKRS you can retrieve T001-WAERS.

So VBRK table is indirect link bw VBRP and T001

regard ,

Sudha,

Reward points if useful.