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: 

relationship between plant and distribution channel..

Former Member
0 Kudos

hello,

what is the relationship between plant and distribution channel and region....in which table this info is stored....

thanx,

maya

1 ACCEPTED SOLUTION

former_member181962
Active Contributor
0 Kudos

table T001W. Pass WERKS(Plant ) to get VTWEG .

Regards,

Ravi

6 REPLIES 6

former_member181962
Active Contributor
0 Kudos

table T001W. Pass WERKS(Plant ) to get VTWEG .

Regards,

Ravi

0 Kudos

thank u very much....

is there any relationship b/w plant and PLTYP(price list type)?

thanx,

maya.

0 Kudos

Go to TWEGO table to get the VTWEG for PLTYP. and then use that to get the plant from T001W.

0 Kudos

you can also get from table <b>WKBP</b>

Former Member
0 Kudos

Hi,

Plant(WERKS) is an entity w.r.to Material(MATNR) , so all the Item Tables of different transactions which contains material will have Plant field.(Like VBAP,LIPS,VBRP etc.)

Distribution Channel(VTWEG) is the Org Unit which is a part of Sales area in SD Module along with Sales orgn(VKORG) and Division(SPART) All these fields will be present in Header tables of an Application/Transaction Like VBAK,LIKP, VBRK etc

Region (REGIO) is the one which is linked with ADDRESS field of any entity like Customer, Vendor Address.(KNA1,LFA1 etc tables you will find).

So for which Address you need REGION field is important.

In LIKP table you will get WERKS(plant) and Dist Channel fields.

So in which context you need the link between these 3 fields?

Regards,

Anji

Former Member
0 Kudos

THANK U FOR UR RESPONSE.

REGARDS,

MAYA.