Approval when Bank Account Changes (TXN)

[Former Member]

Hi,

My client is looking for a way to have an "approval" system for when a supplier's bank details change.  We have created 4 UDFs for this (3 for approvers and 1 for an overall approval).

We set the overall approval to Yes when a BP is updated with more than two approvers (Y).

We now want to create a post transaction notification to set all to N for when a change is made to a Supplier's bank details in table OCRB and object 187.

It seems like object 187 and object 2 (BP) fire together, the reason I say this is that when you update the bank nothing happens but when you update OCRD the TXN actually fires for object 187.

We just cannot get it to fire 100%.  Started using the AbsKey but as OCRB has four keys SBO concatenates the four fields to be used in the TXN.

The fields are OCRB.COUNTRY, OCRB.BANKCODE, OCRB.ACCOUNT, OCRB.CARDCODE.

The post txn we use is:

UPDATE    OCRD

SET              U_ApproveR1 = N'N'

FROM         OCRD INNER JOIN

                      OCRB ON OCRD.CardCode = OCRB.CardCode

WHERE     (OCRD.CardCode = (Select CardCode from OCRB where OCRB.Country+' '+OCRB.BankCode+' '+OCRB.Account+' '+OCRB.CardCode = @list_of_cols_val_tab_del))

END

Your help will be appreciated as always.

Jacques

[Former Member]

Hi Jacques,

Direct update to system table is not supported by SAP even if they are UDF.

However, if you like to take the risk for your client, you may try:

FROM         OCRD T0

WHERE     T0.CardCode = (Select T1.CardCode from OCRB T1 where T1.Country+' '+T1.BankCode+' '+T1.Account+' '+T1.CardCode = @list_of_cols_val_tab_del)

Thanks,

Gordon