11-30-2007 10:05 AM
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.
11-30-2007 10:13 AM
Hi Vitesh,
You can get them from A374, A375 & A376.
Regards,
Satish
11-30-2007 10:11 AM
11-30-2007 10:13 AM
Hi Vitesh,
You can get them from A374, A375 & A376.
Regards,
Satish
11-30-2007 11:53 AM
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