Report

[Former Member]

Hi,

How to select records from two tables?

Regards.

Sudhan

[Former Member]

Hi Manikam,

U can use joins on two tables if they have any fields in common.

e.g. if we want to select the data from tables VBAK and VBAK then we can write as follows :

SELECT VBAK_{VBELN VBAK}AUART VBAP_{POSNR into correspodning fields of table itab from VBAK join VBAP on VBAK}VBELN = VBAP~VBELN WHERE

<conditions>.

Other way is to use SELECT ...... FOR ALL ENTRIES.

Regards,

Himanshu

[Former Member]

manikam,

For this you have to use innerjoins.

SELECT a~mandt

a~vbeln

a~posnr

a~lprio

a~matnr

a~kwmeng

a~vrkme

a~netwr

a~waerk

a~kdmat

a~werks

a~pstyv

a~charg

a~route

u~absta

u~fksta

u~gbsta

u~lfsta

a~posex

a~vgbel

u~besta

v~bsark

v~ihrez

INTO TABLE i_vbap

FROM vbap AS a

INNER JOIN vbup AS u ON u_{vbeln = a}vbeln AND u_{posnr = a}posnr

INNER JOIN vbkd AS v ON v_{vbeln = a}vbeln AND v_{posnr = a}posnr

FOR ALL ENTRIES IN i_vbak

WHERE a~vbeln EQ i_vbak-vbeln.

Don't forget ot reward if useful

[Former Member]

hi,

u have make use of inner join for selecting records from more than onew table but u have to have atleast one common field in both the tables.

regards,

ravi

[Former Member]

Hi,

There are two ways of doing this.

1. Using Joins as mentioned earlier by some.

2. Declare two internal tables for the two database tables and populate any one of them. then use FOR ALL ENTRIES in that filled internal table and populate the other internal table from the other database table. Now declare one final internal table and move the data from the two tables into this. Use the final internal table for displaying the records or for reports.

hope this helps....

reward if helpful....

naba

[Former Member]

hi

good

you can select data from two table using the INNER JOIN or OUTER JOIN statement.

thanks

mrutyun^