Report material & workcenter

[Former Member]

Hi

Can some body help to fetch the best table to get the below report with given selection fields.

Create a report to Display material, material description, work center

and plant.

The selection should have the material type(mtart) the material

pricinggroup(kondm) and plant.

Capture the work center from the routing. These should only be active

materials.

[keiji_mishima]

Hi srinivasch ch

Do you want to get APO data ? Or ERP PP data ?

In case of APO, for materal plant data, you can get from following tables.

/SAPAPO/MATKEY

/SAPAPO/MATTXT

/SAPAPO/LOC

/SAPAPO/MATLOC

On work center, do you want to know resource name that is used in PDS/PPM for specific material.

In case of ERP PP

You can acess material data from

-Material : MARA, MACR, MAKT,

-Work Center :CRHD

-Tasklist : MAPL, PLKZ, PLKO, PLFL,PLAS,PLPO.

Best Regards

Keiji

[Former Member]

Thank you .... In ERP only