Hi community 😊
I am currently facing a problem when trying to generate DB alerts for DP.
The situation is as follows:
A macro defined alert should be created if the difference between key figure 1 and 2 is >20% or smaller than -20%
_____________________________________________________________________________________
Key figure 1= Anual Plan initial
Key figure 2= Forecast Standard Portfolio
The key figure 2 is calculated per default as follows:
system generated statistical forecast
- manual adjustments absolut
- manual adjustments in %
= key figure 2
______________________________________________________________________________________
The macro for the alert is defined as follows:
1.step: delete all old alerts
2.step: calculate key figures 2
3.step: calculate difference between key figure 1 and 2 using a help table row
4.step: post the alert if the difference is out of the limits set -> >20% or <-20%
______________________________________________________________________________________
Alert profil, activities and jobs are set up using the same selection profile. Aggregation and selection level is only the "material". The alerts should be created via a process chain. The chain runs well with the following messages: 1. macros have been successfully executed and 2. no data has to be adjusted.
When opening the alert monitor the information message "no alerts could be selected" appears. I checked table /SAPAPO/AM_ALERT and was able to find entries related to my planning book, I use for mass processing (e.g. alert generation). .... What might be of further interest is that I did the following trials:
- run the alerts only for one material -> no success
- delete all alerts from the table via a deletion macro -> surprisingly not all alerts have been deleted ... for what reason ever 😔 ... afterwards I recalculated the alerts -> no success
- checked the macros in the interactive planning book via the MSDP_DBO and DBLIST Debugger funcionality ... they work well in the planning book
Any ideas about what I could check/ do additionally!? Could it probably be a problem which is related to a lack of table space !?
Many thanks in advance for any feedback and support!!!
Regards
Frank