sd table

[Former Member]

hi friends,

I am giving country code in the selection screen.

Based on the country i want to fetch plant and sales organization .

which table i want to use for this.

After getting sales organization i want to fetch the sales order

Thanks in advance

[Former Member]

Hi

you can fetch the sales order from the table VBAK - header table and corresponding lineitems from the table VBAP.In VBAK we can find plant and sales organizzation.

Reward points if it is helpful.

Regards,

Sangeetha.a

[Former Member]

HI,

use table vbak and kna1

VBAK-VKORG-sales organization

VBAK-VBELN-sales docc or sales order.

KNA1-WERKS-plant

KNA1-land1-country code

rgds,

bharat.

Message was edited by:

Bharat Kalagara

[Former Member]

Hi,

You can use T001 to get the company codes for the given country...t001-land1.

Then You can use table T001K, TVKO to get the plants and sales organization for the given company codes..

Thanks,

Naren

[santhosh_patil]

Hi,

Use table <b>T001W</b> for plant and sales organization .

and <b>VBAK</b> for sales order

[Former Member]

Hi,

Check the table T001W

Regards

Shiva

[Former Member]

Hi Sadhu,

Based on Country Code, you can select Plant and Sales Organization from MVKE table ( Material Master : Sales Data - contains matnr for further selection from next table) and MARC table ( contains Plant), also for sales order try tables VBAK and VBAP.

Regards,

Samson Rodrigues.

[Former Member]

little late, but thanks for all the replies.

regards

sadhu kishore