View and rule - checks new materials coming into the system. With email notification

[former_member1349072]

Hi,

I want email notifications to users when items are back in stock. That means I want email notification whenever a material is created in the system.

I can set up email notification from Scorecard Setup - key data domain - mange email notification - use CMC to create recurring task on this.

I mainly need help to create a sutiable view and rule that can return all new materails created.

I was thinking to create a view over materials that are 30 days (then I will always have materials that are newer then 30 days) old by his:

• table: MARA, fields: MATNR and ERSDA (created on date).
• filter on view: created on=sysdate-30.

Rule and email notification:

• rule: MATNR=null (all materials have a MTNR so by this I will return all materials because I get 0 score)
• email notification: sensitivity: under low threshold (by this I will return all that are below 10 in score whic will be all material based on my rule).

Im not sure if this is the right approach since I have never done this before. If anyone have a input on this or another solution, then I will really appreciate it. This is a bit urgent so looking forward for a quick response 🙂

Br,

Ushna

[former_member706979]

Hi Ushna,

Can you try below filter in view

date_diff(sysdate(),to_date(ersda,'YYYY-MM-DD'), 'MM') = 01

One screenshot is attached ,it may help.

ersda-sysdate-difference.jpg