on 05-18-2015 11:51 AM
Hi all,
In Demand Planning I have a macro running successfully saying that unless the material number is at detail level, the specific key figure is locked.
This macro is as below:
IF
DET_LEVEL ( Material_No ) = 0
ROW: XYZ (Attributes) =
Row Input (0)
ELSE
ROW: XYZ (Attributes) =
Row Input (1)
ENDIF
this works fine, and the row XYZ is only open for editing when the DP planning book is drilled down to the material number detail (lowest level)
But I want to enhance this, and its not working.. I am trying to say that TWO characteristics need to be in detail.. not just Material_No
IF
DET_LEVEL ( Material_No ) = 0 AND DET_Level ( Location ) = 0
ROW: XYZ (Attributes) =
Row Input (0)
ELSE
ROW XYZ (Attributes) =
Row Input (1)
But it seems to be totally ignoring the extra part added to check that Location is also at detail.. What am I doing wrong?
Hi,
From the description of your macro, there is no problem.
Maybe you can attach your real macro for us.
If you put "DET_LEVEL ( Material_No ) = 0 AND DET_Level ( Location ) = 0" in one line in your macro, try separating it into 2 lines "DET_LEVEL ( Material_No ) = 0 AND" and "DET_Level ( Location ) = 0"
Best Regards,
Ada
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi S SB,
Instead of AND condition try with DET_LEVEL( '9AMATNR' ; '9ALOCNO' ) = 1. Let me know if it worked.
Regards
Rahul
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi S SB,
Not sure, what we are missing in communication. See the attached macro which is with start/default event.
When I select in selection window only material then specific KF is in display mode, but when I select product and location in selection window it allows me to do so.
Do you want to do the same in drill-down? Let me know what is different in our understanding,
Regards
Rahul
Yes, in Drill Down... So the user has free ability to select what he likes in the selection window, but I want to ensure he has to drill down to the part AND location until he can edit.
It currently works that the key figure is locked unless the part is drilled down.. But when the part is in more that one location, eg: 'TOTAL' in the location header, it still lets him edit.. I do want to allow edit if either location or material are at TOTAL.
hope that clarified my issue better?
User | Count |
---|---|
13 | |
4 | |
3 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.