tables

[Former Member]

hi

how can we join three tables

[Former Member]

Hi,

<b>Inner joins using 3 tables </b>

<b>Try this :-</b>

SELECT stpo_{stlnr stpo}idnrk mast_{matnr mara}mtart stpo~menge

INTO CORRESPONDING FIELDS OF TABLE zmat1 FROM mast

JOIN stpo ON stpo_{stlnr = mast}stlnr

JOIN mara ON mara_{matnr = mast}matnr

WHERE stpo_{stlty = 'M' "AND stpo}idnrk IN s_matnr

AND mast~werks = 1000.

Here s_matnr is a select-options on the selection-screen.

<b>Or this. </b>

Code:

Select single Vbrk_{Bukrs Vbrk}Kunrg Vbrk~Vbeln

Vbrk_{Fkdat Vbrk}Bstnk_Vf Vbrk~Zterm

Tvzbt~Vtext

Vbak_{Vbeln Vbak}Bstdk

Likp_{Vbeln Likp}lfdat Likp~Lfuhr

into w_vbrk

from vbrk

inner join Tvzbt on Tvzbt_{Zterm = Vbrk}Zterm and

Tvzbt~Spras = sy-langu

Inner join Vbfa as SalesLnk

on SalesLnk~vbeln = pu_vbeln and

SalesLnk~vbtyp_v = c_order

inner join Vbak on Vbak_{Vbeln = SalesLnk}Vbelv

Inner join Vbfa as DeliveryLnk

on DeliveryLnk~vbeln = pu_vbeln and

DeliveryLnk~vbtyp_v = c_Delivery

inner join Likp on Likp_{Vbeln = DeliveryLnk}Vbelv

where vbrk~vbeln = pu_Vbeln.

This code locates sales, delivery and payment terms info from a billing document number.

<b>or

Here, this one also works fine :</b>

select zfpcd_{cadivi zfpcd}proforma zfpcd_{factura zfpcd}aniofactura

zfpcd_{montousd zfpcd}montoap zfpcd_{ebeln zfpcd}inco1

zfpcd_{lifnr lfa1}name1 zcdvs_{status zfpcd}conint

into it_lista

from zfpcd inner join zcdvs

on zfpcd_{ebeln = zcdvs}ebeln

and zfpcd_{proforma = zcdvs}proforma

and zfpcd_{lifnr = zcdvs}lifnr

inner join lfa1

on zfpcd_{lifnr = lfa1}lifnr

where zcdvs~status = '04'.

Regards

Sudheer

[Former Member]

You can use INNER JOIN or OUTER JOIN to join any number of tables.

Eg:

SELECT t685_{kschl t682z}kozgf t682i_{kotabnr t682z}kvewe

t682z_{kappl t682z}kolnr zaehk zifna

FROM t685

INNER JOIN t682i

ON t685_{kvewe eq t682i}kvewe and

t685_{kappl eq t682i}kappl and

t685_{kozgf eq t682i}kozgf

INNER JOIN t682z

ON t682i_{kvewe eq t682z}kvewe and

t682i_{kappl eq t682z}kappl and

t682i_{kozgf eq t682z}kozgf and

t682i_{kolnr eq t682z}kolnr

INTO TABLE gt_t682

WHERE t685~kvewe = 'A' AND " 'A' - Pricing

t685~kappl = 'V' AND " 'V' - Sales/Distribution

t685~kschl IN gr_kschl AND

t682z~qustr NE ''.

Regards

Sri