topic Re: Report in Application Development and Automation Discussions

Report

Former Member — Thu, 05 Apr 2007 08:24:41 GMT

Hi,

How to select records from two tables?

Regards.

Sudhan

Re: Report

Former Member — Thu, 05 Apr 2007 08:27:59 GMT

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

Re: Report

Former Member — Thu, 05 Apr 2007 08:28:40 GMT

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

Re: Report

Former Member — Thu, 05 Apr 2007 08:30:19 GMT

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

Re: Report

Former Member — Thu, 05 Apr 2007 08:34:41 GMT

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

Re: Report

Former Member — Thu, 05 Apr 2007 10:09:32 GMT

good

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

thanks

mrutyun^