cancel
Showing results for 
Search instead for 
Did you mean: 

Macro in DP planning book: find status of Key Figure Values fixed/unfixed

Former Member
0 Kudos

Hi everybody,

we want to implement a macro in our DP planning book that checks whether a key figure value is fixed or unfixed.

Where or how can we get this status information? Is there a function implemented we can use?

We also want to perform this check over multiple levels and characteristics.

Does anyone know a approach we might take?

Thank you in advance for your help.

Best regards

Mich

Accepted Solutions (1)

Accepted Solutions (1)

satish_waghmare3
Active Contributor
0 Kudos

Hello Mitch

You can use : IS_FIXED (Key Figure)

The IS_FIXED function returns the value 1 if the cell is completely fixed. If the cell is not fixed or is partially fixed, the return value is 0

Also refer below link for Macro functions-usage and syntax

Planning Table Functions and General Functions - Planning Area Administration - SAP Library

Hope this will help.

Thank you

Satish Waghmare

Former Member
0 Kudos

Dear Satish,

thank you very much for your quick response. That was exactly the answer I was looking for.

Best regards

Mitch

Answers (0)