joining three tables.. urgent(with in 15 minutes)

[Former Member]

hi,

i have to join three tables vbak,vbuk,vbap...

i need the syntax..

when i wrote like..

select .. into table int_itab

from vbak as a join vbuk as b

on a_{vbeln = b}vbeln

join vbap as c

on c_{vbeln = a}vbeln.

where ....

for the above combination , i have only one record...

but iam getting records... i.e., it is displaying the same record twice

please help me urgently .... very fast

regards

sree

[Former Member]

HI, IT IS BCOZ U HAVE WRITTEN :-

<b>on a_{vbeln = b}vbeln </b>

It should be written like dis b_{vbeln = a}vbeln and rest of ur code wil be fine and it will not dsiplay d value twice.

if u find it useful ,plz do rewards tooo.

[Former Member]

here is d code for u:-

select .. into table int_itab

from vbak as a join vbuk as b

<b>on b_{vbeln = a}vbeln

inner join vbap as c</b>

on c_{vbeln = a}vbeln.

where ....

hpoe u understood now.

do rewards if u find it useful.

[Former Member]

hi,

still it is not working.....

i have added the second join..

if i wont add the second join , the output is working nice

plzzzzzzzz.. help urgently

regards

sree

[Former Member]

what have provided in whereclause?

psate ur code

[Former Member]

SELECT DISTINCT A_{VBELN A}ERDAT A_{BSTNK A}BSTDK A_{KUNNR B}SPART B_{MATNR B}POSNR B_{WERKS B}POSNR B_{KWMENG B}KBMENG C_{NTGEW C}BRGEW C_{GEWEI D}WMENG D_{BMENG D}EDATU D~VBELN

FROM VBAK AS A INNER JOIN VBAP AS B ON B_{VBELN = A}VBELN

INNER JOIN MARA AS C ON C_{MATNR = B}MATNR

INTO CORRESPONDING FIELDS OF TABLE ITSO

WHERE A_{VBELN IN SO_ORD AND A}KUNNR IN SO_PARTY AND B_{SPART IN DIV AND A}ERDAT IN SO_DATE.

dis is d best exapmle of inner joins ,but do not enter more dan 3 inner joins as it will lead to

effect d efficiency.

or

u just send ur complete requierments of ur report i will provide d solution for it.

[Former Member]

if u find it useful den do rewards toooo

[Former Member]

HI,

THANKS FOR YOUR SUPPORT..

SINCE THERE ARE MORE THAN ONE LINE ITEM....

I GETTING LIKE THAT ..

I HAVE DONE THE NECESSARY MODIFICAITONS

IT IS SOLVED..

REGARDS

SREE

[Former Member]

I'm assuming as you didn't get your solution within the requested 15 minutes that's why you haven't acknowledged the contribution of the efforts of those listed above by the gift of points.

<a href="https://wiki.sdn.sap.com/wiki/x/FgQ">https://wiki.sdn.sap.com/wiki/x/FgQ</a>