cancel
Showing results for 
Search instead for 
Did you mean: 

Flexi planning time fence in planning book

Former Member
0 Kudos

Hello there, need helps from expert here.

Currently, we fix first 2 columns as planning time fence in planning book. In future, users want it to be flexible by referring to material master, Extended SNP Prod Hor. field.

We have removed the fixed first 2 columns in macro. Please advise how to do the flexible planning time fence by reading the value from material master in macro.

Thanks.

Regards,

MS

Accepted Solutions (0)

Answers (1)

Answers (1)

RahulHanda
Active Contributor
0 Kudos

Hi

Check below link i.e. how to read value from product master.

Macro - Value From Product Master in Planning Book | SCN

Thereafter use this value in planning book to do fixing.

If resolved follow else let us know the issue.

Regards

Rahul

Former Member
0 Kudos

Hello Rahul,

Thanks for your link.

I tried the standard MATLOC function before but it is not working here.

I created own Z function to read the product horizon value from product master.

However, the value can't be passed to key figure automatically. So, I have to use own calculation like below but it still not working. Do you know why and how?

Regards,

MS