Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

SP Transaction Notification for Special Prices


I need to monitor changes on the additions and updates for the business partners special prices. I have a challenge while implementing the

@num_of_cols_in_key because I understand a special price object number 7 has two keys i.e CardCode and ItemCode both from OSPP table.

I have tested with this sql code:

IF ((@object_type = 7) AND (@transaction_type = 'U'))


IF EXISTS (SELECT T0.ItemCode, T0.CardCode, T0.Price, T0.Currency, T0.Discount, T0.ListNum FROM OSPP T0 WHERE

  T0.ItemCode = @list_of_key_cols_tab_del)


What am I doing wrong?


Helpful Answer

Not what you were looking for? View more on this topic or Ask a question