to display list of plants not maintained for material type fert and roh

[Former Member]

how to display(logic) the list of plants which are not maintained for material type fert and roh.

[former_member588853]

hi,

select from the table for plants where material type <> fert and material type <> roh.

hope there will be material type field in the plant table..

else take the material from the plant tabl;e and get the material type from MARA..

rewarrd if useful

regards

nazeer

Message was edited by:

nazeer shaik

[Former Member]

Hi

Ftech all the plants from T001W table , then

Use the tables MARA and MARC or join them together with MARA-MTART = ROH and FERT and you will get the MARC-WERKS for those material types

if you remove these plants from the T001W plants you will get the plants to which these material types are not maintained

reward if useful

regards

Anji