MC.9 : report with plant, storage location and material together for key figures

[former_member496691]

Hi,

In MC,9, we can get the report for value of key figures per material in a drill down report or key figures for plant and storage location for basic list.

Can we get the consolidated report which shows values for key figures for material along with plant and storage location detail on one screen?

ie, the output should be like - plant, storage location and material and then key figures like valuated stock, valuated stock value, last movement, last receipt, last GI.

(Currently it is either plant, storage location and key figures or material and key figures, but not plant, storage location and material together with key figures)

Thanks,

Susmitha

[JL23 · Accepted solution]

Basically it is a online transaction and if you drill down from material to storage location then you see the information about the material on the very top of the screen. Precondition, you have selected in the menu Settings > page header > with drill down log.

An export of the analysis can give you even more information next to each other.

Just try it by selecting the menu Material Analysis > Export > Transfer to XXL ...

[former_member496691 · Accepted solution]

Thanks Jurgen! The exporting thing worked..

[former_member962830]

Hi,

After getting MC.9 report, Go to Material Analysis >>> Export >>> Transfer to XXL

Select the required fields like

Material

Plant

Storage location

Then choose the processing mode <Table> <Microsoft excel>

Now the report will open in excel in the desired format.

Hope this will help in meeting the requirement

Thank you.