topic Re: sd table in Application Development and Automation Discussions

sd table

Former Member — Wed, 30 May 2007 04:34:05 GMT

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

Re: sd table

Former Member — Wed, 30 May 2007 04:36:36 GMT

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

Re: sd table

Former Member — Wed, 30 May 2007 04:36:40 GMT

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

Re: sd table

Former Member — Wed, 30 May 2007 04:38:19 GMT

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

Re: sd table

santhosh_patil — Wed, 30 May 2007 04:40:02 GMT

Hi,

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

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

Re: sd table

Former Member — Wed, 30 May 2007 04:40:38 GMT

Hi,

Check the table T001W

Regards

Shiva

Re: sd table

Former Member — Wed, 30 May 2007 04:43:12 GMT

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.

Re: sd table

Former Member — Sat, 16 Feb 2008 05:34:39 GMT

little late, but thanks for all the replies.

regards

sadhu kishore