...about joining few tables

[Former Member]

i took five tables: vbap, vbak, likp, lips, vbuk.

and the fields are:

vbap-vbeln,posnr,matnr ;

vbak-vkorg,vtweg ;

likp-ernam,erzet ;

lips-pstyv,vrkme ;

vbuk-rfstk,lfstk .

i used inner join to select all fields but it doesnt work.how will i solve it?

plz reply me as soon as possible.

Edited by: ankita Ghosh on Mar 21, 2008 7:56 PM

[Former Member]

i took five tables: vbap, vbak, likp, lips, vbuk.

and the fields are:

vbap-vbeln,posnr,matnr ;

vbak-vkorg,vtweg ;

likp-ernam,erzet ;

lips-pstyv,vrkme ;

vbuk-rfstk,lfstk .

i used inner join to select all fields but it doesnt work.how will i solve it?

plz reply me as soon as possible.

Edited by: ankita Ghosh on Mar 21, 2008 7:56 PM

[Former Member]

hi ankita ,

check this program for jions ....may it helps for u..

report test .

tables: pa0002,pa0008,pa0021.

data: begin of it_final occurs 0,

pernr like pa0002-pernr,

begda like pa0002-begda,

endda like pa0002-endda,

vorna like pa0002-vorna,

nachn like pa0002-nachn,

ansal like pa0008-ansal,

lga01 like pa0008-lga01,

bet01 like pa0008-bet01,

famsa like pa0021-famsa,

fanam like pa0021-fanam,

favor like pa0021-favor,

end of it_final .

select-options:s_pernr for pa0002-pernr.

select a~pernr

a~begda

a~endda

a~vorna

a~nachn

b~ansal

b~lga01

b~bet01

c~famsa

c~fanam

c~favor

from ( ( pa0002 as a inner join pa0008 as b on a_{pernr = b}pernr )

inner join pa0021 as c on a_{pernr = c}pernr and b_{pernr = c}pernr )

into table it_final

where a~pernr in s_pernr.

sort it_final by pernr begda descending.

loop at it_final.

write:/ it_final-pernr,

it_final-begda,

it_final-endda,

it_final-vorna,

it_final-nachn,

it_final-ansal,

it_final-lga01,

it_final-bet01,

it_final-famsa,

it_final-fanam,

it_final-favor.

endloop.

regards,

venkat.

Edited by: venkat appikonda on Mar 21, 2008 8:03 PM

[Former Member]

hi you do like this ...i tested it and it is working fine ....if you not getting the data it means there is no records matchin this situation.

report .

tables: vbap, vbak, likp, lips, vbuk.

data: begin of itab occurs 0,

vbeln like vbap-vbeln,

posnr like vbap-posnr,

matnr like vbap-matnr,

end of itab,

begin of itab1 occurs 0,

vbeln like vbap-vbeln,

vkorg like vbak-vkorg,

vtweg like vbak-vtweg,

end of itab1,

begin of itab2 occurs 0,

vbeln like vbap-vbeln,

ernam like likp-ernam,

erzet like likp-erzet,

end of itab2,

begin of itab3 occurs 0,

vbeln like vbap-vbeln,

pstyv like lips-pstyv,

vrkme like lips-vrkme,

end of itab3,

begin of itab4 occurs 0,

vbeln like vbap-vbeln,

rfstk like vbuk-rfstk,

lfstk like vbuk-lfstk,

end of itab4,

begin of it_final occurs 0,

vbeln like vbap-vbeln,

posnr like vbap-posnr,

matnr like vbap-matnr,

vkorg like vbak-vkorg,

vtweg like vbak-vtweg,

ernam like likp-ernam,

erzet like likp-erzet,

pstyv like lips-pstyv,

vrkme like lips-vrkme,

rfstk like vbuk-rfstk,

lfstk like vbuk-lfstk,

end of it_final.

select-options: s_vbeln for vbap-vbeln.

select vbeln posnr matnr from vbap into table itab where vbeln in s_vbeln.

select vbeln vkorg vtweg from vbak into table itab1 for all entries in itab where vbeln = itab-vbeln.

*

select vbeln ernam erzet from likp into table itab2 for all entries in itab where vbeln = itab-vbeln.

select vbeln pstyv vrkme from lips into table itab3 for all entries in itab where vbeln = itab-vbeln.

select vbeln rfstk lfstk from vbuk into table itab4 for all entries in itab where vbeln = itab-vbeln.

loop at itab.

it_final-vbeln = itab-vbeln.

it_final-posnr = itab-posnr.

it_final-matnr = itab-matnr.

read table itab1 with key vbeln = itab-vbeln.

it_final-vkorg = itab1-vkorg.

it_final-vtweg = itab1-vtweg.

read table itab2 with key vbeln = itab-vbeln.

it_final-ernam = itab2-ernam.

it_final-erzet = itab2-erzet.

read table itab3 with key vbeln = itab-vbeln.

it_final-pstyv = itab3-pstyv .

it_final-vrkme = itab3-vrkme.

read table itab4 with key vbeln = itab-vbeln.

it_final-rfstk = itab4-rfstk.

it_final-lfstk = itab4-lfstk.

endloop.

loop at it_final.

write:/

it_final-vbeln ,

it_final-posnr,

it_final-matnr,

it_final-vkorg,

it_final-vtweg,

it_final-ernam,

it_final-erzet,

it_final-rfstk,

it_final-lfstk.

endloop.

regards,

venkat.

[Former Member]

hello, there is no syntax error in ur code but it doesb get executed.

plz help.

[Former Member]

Why not post your Select Statement and we could look at it and help you.

[Former Member]

plz reply me soon.