how do i join 3 table with the 'join' query ?

[Former Member]

Hello,

i want to join 3 tables -> bsis, bsad and vbrp

the components of the query to be are ,

- select (matnr from vbrp) sum(amount from bsad).

- join bsis and bsad on bsis_{bukrs = bsad}bukrs, bsis_{belnr = bsad}augbl and bsis_{bldat = bsad}augdt.

- where bsis_{blart = 'DZ' and bsis}hkont = '123456'.

- join bsad and vbrp on vbrp_{burks = bsad}bukrs, vbrp_{gjahr = bsad}gjahr and vbrp_{belnr = bsad}belnr.

The double join query is to be constructed out of the above components.

Thanks,

Shehryar Dahar

[andreas_mann3]

Hi,

you cannot join bsid and bsad

they are mutually exclusive:

bsid = open items

bsad = cleared items

so you can only join the tables on the factura (vbeln)

A.

Message was edited by:

Andreas Mann

[Former Member]

Hi Andreas,

Its BSIS, not BSID .

Regards,

Shehryar Dahar

[andreas_mann3]

sorry,

so I'd do the foll.:

1) select bsis into itab

2) loop itab

and select bseg with bukrs belnr gjahr and koart 'D' and augbl <> space

and vbrp with vbeln

A.

[Former Member]

Hello again,

ANybody ?

Regards,

Shehryar Dahar

[Former Member]

Hi

Try this example with your tables...

select aufk~aufnr afko~rsnum afih~revnr 
       from aufk
            inner join afko
               on aufk~aufnr = afko~aufnr
            inner join afih
               on aufk~aufnr = afih~aufnr into
             corresponding fields of table itab.

Pls reward points if it helps....

Kaki Ravindra

[Former Member]

c an example....

DATA: BEGIN OF wa,

carrid TYPE spfli-carrid,

connid TYPE spfli-connid,

fldate TYPE sflight-fldate,

bookid TYPE sbook-bookid,

END OF wa,

itab LIKE SORTED TABLE OF wa

WITH UNIQUE KEY carrid connid fldate bookid.

SELECT p_{carrid p}connid f_{fldate b}bookid

INTO CORRESPONDING FIELDS OF TABLE itab

FROM ( ( spfli AS p

INNER JOIN sflight AS f ON p_{carrid = f}carrid AND

p_{connid = f}connid )

INNER JOIN sbook AS b ON b_{carrid = f}carrid AND

b_{connid = f}connid AND

b_{fldate = f}fldate )

WHERE p~cityfrom = 'FRANKFURT' AND

p~cityto = 'NEW YORK' AND

f_{seatsmax > f}seatsocc.

LOOP AT itab INTO wa.

AT NEW fldate.

WRITE: / wa-carrid, wa-connid, wa-fldate.

ENDAT.

WRITE / wa-bookid.

ENDLOOP.

Ramesh.