joining tables

[Former Member]

Can i join t178t with kna1 on kondm ?

[Former Member]

How to join VBAP with t178t ?

[Former Member]

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.

[Former Member]

There is no KONDM in KNA1.

Please check it again.

[Former Member]

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