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: 

country code & sales organisation

former_member239066
Participant
0 Kudos

hi guys,

i need to retrieve sales orders for a particular country from the table VBAK. for this i need all the sales organisation for that particular country. from which table can i retrieve sales organisation for a particular country?

regards,

vitish.

1 ACCEPTED SOLUTION

Former Member
0 Kudos

Hi Vitesh,

You can get them from A374, A375 & A376.

Regards,

Satish

3 REPLIES 3

former_member188829
Active Contributor
0 Kudos

Hi,

Check KNVV Table...

Former Member
0 Kudos

Hi Vitesh,

You can get them from A374, A375 & A376.

Regards,

Satish

0 Kudos

or how about selecting from view V_VKORG_BW with LAND1 = particular country?

this is the country of the assigned company code.

else try a join on TVKO and ADRC via TVKOADRNR = ADRCADDRNUMBER where COUNTRY = particular country.

Cheers

Thomas