how to get all the plants for a particular company code

[Former Member]

Hi,

Can any one please suggest which table to query to gat all the plants(WERKS)

for a given company code?

Thanks and Regards,

Smriti Singh

[former_member555112]

Hi,

Select from T001W table matcing the BUKRS field with BWKEY (Valuation area).

Regards,

Ankur Parab

[former_member585865]

Hi Smriti,

you can check t001k where bwkey is plant and bukrs is company code.

[Pawan_Kesari]

1) Get Purchasing Orgs (T024E-EKORG) in Company Code

T001-BUKRS = T024E-BUKRS

2) Get all the plant for all Purchasing Orgs you got from step 1

T024E-EKORG = T001W-EKORG

[Former Member]

Hi,

T001W is the table where you can find all the plants.

[Former Member]

Hi,

Try EKPO.

[Former Member]

Hi,

It is T001W table where we can find the all plants for a company code.

Thanks,

Jayasree.

[Former Member]

hi

t001w is the master table for plants, u can see all plants in this table.

regads:

rajesh.k