Creating a macro

[Former Member]

Hi Team,

I am trying to create a Macro which would be basically used to copy data from 1 KF to another KF(which already has some data). However, the copy should not happen if the the Destination Key figure values are fixed at either the Material Level(aggregate level) or at any of the drilled down level(drilled down at Location or Customer). Even if a single cell is fixed at detailed level (Customer/location) the macro should not get executed at all.

I can work on restricting Key fig copy for fixed cells. I am not sure how to control the levels at which this happens.

Let me know if you have some suggestions.

[former_member187488]

Hi, If for one cell, any of it's detailed level is fixed, this cell should be shown as partial fixed (with an open padlock). You can use macro function is_fixed() to decide whether a cell is fixed, and macro function is_partly_fixed() to decide whther a cell is fixed at its detailed level. These macro functions are explained in online help Planning Table Functions and General Functions - Planning Area Administration - SAP Library .