Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

get plant from sales org and distribution channel

Former Member
0 Kudos
1,014

Hi expert,

how to get default delivery plant from sales organization and distribution

channel.

thanks,

neo

1 ACCEPTED SOLUTION

Former Member
0 Kudos
321

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

4 REPLIES 4

Former Member
0 Kudos
322

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
Active Contributor
0 Kudos
321

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
0 Kudos
321

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

0 Kudos
321

select data from both tables

based on vkorg ,then get werks from TVKO Table.

Thanks

Seshu