ALV REPORT

Former Member — Mon, 15 Oct 2007 12:15:52 GMT

Hai senior's,

Thanks for KT,but i wish to know about selecting fields from different tables(two r three tables).

Re: ALV REPORT

Former Member — Mon, 15 Oct 2007 12:40:01 GMT

Hi Saravanan,

Use Inner Joins for that or if it is more than 3 tabeles , use for all entries.

Eg 1: Inner Joins

DATA: DATE LIKE SFLIGHT-FLDATE,

CARRID LIKE SFLIGHT-CARRID,

CONNID LIKE SFLIGHT-CONNID.

SELECT F_{CARRID F}CONNID F~FLDATE

INTO (CARRID, CONNID, DATE)

FROM SFLIGHT AS F INNER JOIN SPFLI AS P

ON F_{CARRID = P}CARRID AND

F_{CONNID = P}CONNID

WHERE P~CITYFROM = 'FRANKFURT'

AND P~CITYTO = 'NEW YORK'

AND F~FLDATE BETWEEN '20010910' AND '20010920'

AND F_{SEATSOCC < F}SEATSMAX.

WRITE: / DATE, CARRID, CONNID.

ENDSELECT.

Eg 2: For all entries

Select fld1 fld2 fld3

from itab1

into table itab2 where fld1 = " ".

if sy-subrc eq 0.

select fld1 fld2 fld3 form itab3 into table itab4 for all entries in itab2

where fld1 = itab2-fld3.

Reward if Useful.

Regards,

Chitra

Former Member — Tue, 16 Oct 2007 05:30:28 GMT

1. U can use joins

for help on joins go to F1 help provided