Fixing Macro

[mwallace]

Hello

I hope someone can help.

I want to load plant into the planning book and drill down to material.  Then once at the drill down level I want to fix the cells in the total level, so that the lower level can be adjusted and keep the overall total.  I can do this with navigation but can't work out a macro to fix the row automatically.  Is it possible?

Thanks for your help!

Michael

[Former Member · Accepted solution]

Hi Michael

Did you tried with the SAP Note 643517 ?

--> Nota source and target KFig are the same in the example below

KR

Arno

[mwallace · Accepted solution]

Hello Arnaud

Thanks for your reply!

I've got the fixing part to work in the way you've decribed above and there are no problems, it's just that I can't fix just the header at the drill down level.

In the screenshot below, I want to load selling plant, drill down to detail level then apply fixing to only the total row (highlighted in the red box) without changing any of the fixing at the detailed level.

Cheers

Mike

[Former Member · Accepted solution]

Hi Michael

OK I understand your issue. Because If you lock at the total level you will lock all the data on the lowest level.

Maintaining the total row unchanged after modifying data at Plant level only is an interesting challenge.

Unfortunately, I don’t know how to do it in an easy way.

KR

Arno