can we give join condition in quick viewer

[laxman_sankhla3]

hi

can we give join condition in quick viewer for three table .

if yes than how can we give .

thanks.

[Clemenss · Accepted solution]

Hi Laxman,

although i'm not at the system too, I can tell you: In the Data source field you can choose between table, infotype(?) and join. If you select join and go back, it takes you to the definition screen. There is an icon for 'insert table' (looks like crippled tree or what). Use this subsequently to insert tables. The system automatically connects fields for join condition. With right-muse-click on the link line, you can change to outrer join or delete the join. dragging field from one table to other table other field will create a join.

Good luck!

Regards,

Clemens

[Former Member]

Hi,

Inner joins using 3 tables

Try this :-

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.

Or this.

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.

Regards,

Bhaskar

[laxman_sankhla3]

hi thanks

<b> i m using SQ01 tcode to join table .</b>can we give where condition on join in SQ01

thanks

[Clemenss]

Hi Bhaskar,

never used a quickview? Still programming? Try menu system-servives-quickviewer.

<a href="http://help.sap.com/saphelp_erp2005vp/helpdata/en/d1/44f2a3c7f411d296080000e82de14a/content.htm">Functions for Managing QuickViews</a>

Even I do!

Regards,

Clemens

[Former Member]

Hi Laxman,

Yes we can. I am not in fornt of the system so can't tell the exact steps but if you just look at it you will get the solution.

you can check this thread also. MAy help you.

Reward points if useful.

Regards,

Atish