Retrieving data from diff tables

[Former Member]

Hi ,

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

Regards

Suresh.D

[Former Member]

Hi

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

[Former Member]

No you cannot do it.

There has to be some link.

regards

[Former Member]

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.

[Former Member]

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.

[S0025444845]

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.