Alert

[Former Member]

Hi Experts,

                 I just need an idea from you.

1. In Sap, If a New Item is added to the system then an alert should be made.

2. Similarly , If an item is deleted in the system, the system should alert.

Is it possible pls help

[kothandaraman_nagarajan]

Hi,

Please try below query for when new item is added,

SELECT T0.[ItemCode], T0.[ItemName] FROM OITM T0 WHERE datediff(day,  T0.[CreateDate] ,Getdate()) =0

Thanks

[narayanis]

Hi,

As Augustin said it correctly, post writing a code in post transaction, frame a query on your user defined table, and check if any DMLs have taken on item master.

Shoot this query as an alert through Alert Management.

Hope this will help you.

Regards

Narayani

[agustin_marcoscividanes]

Hi

you can use the PostTransaction SP in this way:

1. Create a user table in SBO, and add two columns: operation as char(1) with values A(dd) and D(elete); and another to record the date of the operation.

2. Insert in this table, the itemcode in code column, the itemname in the name column, the operation and the date when the PostTransaction is triggered.

Show this information as you need.

Kind regards

Agustín Marcos Cividanes

[former_member240324]

Following - is there a doc somewhere that tells how to use the SP?  In the past with an add-on I was able to use the history table but only because this particular add-on put the date and time into the history tables.  I don't believe standard tables do this.

Thanks,

Scott

[narayanis]

Hi,

You can create a user defined table through Tools ---> Customization Tools ----> User Defined Table Set Up. It will get created with two default columns viz. Code And Name.

Through Tools ----> Customization Tools ----> User Defined Fields Management ------> User Defined Tables, you will find newly created table.

After selecting it, you will get keys, Update And Remove options to play with table definition.

Now coming to SP

In Sql Server, select the database ----> Programability ------> Stored Procedure -------> you will get

SBO_SP_PostTransactionNotice

Click on it and select Modify. You will get a template. In the section "Add Your Code Here" frame your logic.

@list_of_key_cols_tab_del represents column names for an object type. For eg: for BP it is CardCode , Item Master it is Itemcode .

@list_of_val_cols_tab_del represents the value for the that object type's column name. Docentry.

Hope this will help you.

Regards

Narayani