Skip to Content

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

SP Transaction Notification for Special Prices

Hi,

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'))

BEGIN

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)

BEGIN

What am I doing wrong?

Tags:

Helpful Answer

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