Indentifying Closed Plants

[Former Member]

Is there a way to indentify plants that have not had any activity in the last 12 months?

[Former Member]

Hi Mecca,

Yes, we can identify the closed plants based on the material movements. In other words the Plant neither received any material nor distributed the material to the customer.

In SAP every material movement with the plant will create the material document.

So, you can do like this.

* get the all plants from T001w assigned to the company code

* check the MKPF and MSEG tables and display the output.

* from the output you can check which plants are stopped from the goods and services.

select required fields
          into corresponding fields of table  it_materialdocuments
          from mkpf as mkpf  join mseg as mseg
                   on mkpf~mandt  =  mseg~mandt  and
                      mkpf~mjahr  =  mseg~mjahr

   FOR ALL ENTRIES OF IT_T001E
          where
                  mseg~werks  in  IT_T001W
            and mkpf~budat  ge  datum-low AND

                   mkpf~budat  ge  datum-high.

Thanks,

Kiran

[former_member235395]

Hi Mecca,

Maybe you can try this:

Check on MSEG Table the fields WERKS, GJAHR and CPUDT_MKPF. If don´t have records, meaning hadn't activity. The problem will be the performance!

Regards,

[former_member227140]

I am not sure , but may be you can try this.

Go to MB5B transaction which shows material movements in plant.

in selection date put date from say 01-01-2012 to 31-12-2013

and run (in plant you can put in plant no or no of plants ) and run the report. it will show movements in all plants just do some sorting based on plant for the output displayed compare it with list of plants in system.

please check this , i am not sure if it will solve the purpose.  also consult your MM consultant he will throw some light on it.