topic Re: Retreiving plants based on company code in program in Application Development and Automation Discussions

Retreiving plants based on company code in program

Former Member — Wed, 13 Aug 2008 12:38:13 GMT

Hi all ,

My requirement is I have 6 company codes in which there are 16 plants all together but my requirement is I need only 6 plants from them and these plants are in various company codes.

It would be helpful if someone can provide solution.

<removed_by_moderator>

Thanks & Regards

Jerry

Edited by: Julius Bussche on Aug 13, 2008 4:41 PM

Re: Retreiving plants based on company code in program

SuhaSaha — Wed, 13 Aug 2008 12:50:04 GMT

Hello,

Are u selecting the table T001W?

BR,

Suhas

Re: Retreiving plants based on company code in program

Former Member — Wed, 13 Aug 2008 12:52:14 GMT

Check the table TVKO.

Re: Retreiving plants based on company code in program

Former Member — Wed, 13 Aug 2008 13:07:39 GMT

Select bukrs werks from tvko into itab

where bukrs in bukrs_list.

Sort itab by bukrs.

Delete adjacent records comparing bukrs...

Like this you can get single company code and corresponding plant.

Thank you

Re: Retreiving plants based on company code in program

Former Member — Wed, 13 Aug 2008 16:46:27 GMT

Please read [the rules|https://www.sdn.sap.com/irj/sdn/wiki?path=/display/home/rulesofEngagement] before posting further.

If you can confirm that you have read the rules, then I will also give my answer.

Cheers,

Julius