get plant from sales org and distribution channel

[Former Member]

Hi expert,

how to get default delivery plant from sales organization and distribution

channel.

thanks,

neo

[Former Member]

First get the data from MVKE Table by using material number,then do compare with MARC Table

MVKE - Matnr,VKORG,VTWEG

MARC - MATNR,WERKS

Thanks

Seshu

[ferry_lianto]

Hi,

You can link tables TVKOV and TVKO to get plant (TVKO-WERKS) based on sales org. (VKORG) and distribution channel (VTWEG).

Regards,

Ferry Lianto

[Former Member]

thanks for your quick reply,

i saw table tvkov which has field vkorg,vtweg

but in tvko i found vkorg only .

i don't get vtweg in tvko table,

can u tell me which two condition i need to use ofr join,

one is vkorg and the other one (?) i don't get it.

thanks,

neo

[Former Member]

select data from both tables

based on vkorg ,then get werks from TVKO Table.

Thanks

Seshu