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.
as we can get from below tables and expecting a logic to get the work center with respective mateial.
Material : MARA, MACR, MAKT,
-Work Center :CRHD
-Tasklist : MAPL, PLKZ, PLKO, PLFL,PLAS,PLPO.