topic Re: joining tables in Application Development and Automation Discussions

joining tables

Former Member — Wed, 12 Dec 2007 10:11:05 GMT

Can i join t178t with kna1 on kondm ?

Re: joining tables

Former Member — Wed, 12 Dec 2007 10:13:28 GMT

How to join VBAP with t178t ?

Re: joining tables

Former Member — Wed, 12 Dec 2007 10:14:10 GMT

There is no KONDM in KNA1.

Please check it again.

Re: joining tables

Former Member — Wed, 12 Dec 2007 10:24:38 GMT

kondm is common to vbap and t178t so you can use join like this,

select a_{field1 a}field2 a_{field3 b}field1 b_{field2 b}field3 into corresponding fields of table itab from (vbap as a inner join t178t as b on a_{kondm = b}kondm).

try like this yar it will work fine.

Re: joining tables

Former Member — Wed, 12 Dec 2007 10:26:57 GMT

Hi,

Could you tell for which field you want to match.

Because in KNA1 we cant match any field to KONDM of T178T table.

if you want you can find mappping thru other tables like VBAP,VBRP using sold-to party or ship-to party.

In VBAK we have KUNNR field (customer number)

In Corresponding to vbeln from VBAK we have to goto VBAP for KONDM.

I think you have to match KONDM to customer.

Sample Code:::::::::::::::::::::::

tables:KNA1.

select-options:s_kunnr for kna1-kunnr.

data:begin of itab occurs 0,

kondm like vbap-kondm,

kunnr like vbak-kunnr,

end of itab.

start-of-selection.

select A_{Kondm B}Kunnr into table itab

from VBAP as A inner join VBAK as B

on VBAP-vbeln = VBAK-vbeln

where B~Kunnr in S_Kunnr.

loop at itab.

write:itab-kondm.

endloop.

Please reward if useful.

Thanks

Sivaparvathi