Skip to Content

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Oct 15, 2015 at 09:43 AM

    Hi,

    Can you explain your requirement in detail

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Paul Nganga

      Hi,

      The problem is that parameter (@list_of_cols_val_tab_del ) contain the business partner and the item code . it seems that there is no space between them . is you need only the item code you have to substring the (@list_of_cols_val_tab_del )

      shachar